- Write a console application that mimic popular lottery. Ensure that you choose the right data structure to complete this exercise.The application asks user how many QuickPick numbers she wants. Once the user enters an integer, application should generate specified number of QuickPick numbers. The each QuickPick will have 6 integers in the range of 1-49 inclusive sorted in the ascending order without any duplicates..Once QuickPick numbers are generated they are sorted in the ascending order and displayed on console.Then, Winning Number is generated. If the winning number is matches the User Number. The application should calculated the reward, if any, and display appropriate message on the Console screen.The reward is based on the followingNumber of MatchesWin6/680.5 % of the 30million5/6 + Bonus5.75 % of the 30million5/64.75 % of the 30million4/69 % of the 30million3/6$10 prize2/6 + Bonus$5 prizeHere is a sample scenario:Enter the number of QuickPick numbers to generate: 4Your QuickPick numbers04 16 18 25 40 4706 07 13 15 21 4006 17 24 26 28 3311 19 29 36 34 47Do you want to generate winning number? (y/n) yThe winning number:06 17 24 26 28 33 Bonus 12Congratulations! You won the jack pot! Your prize is $ 24.15 Million
CUMIPMT Cumulative interest payment function allows you to calculate the interest paid for a loan or from an investment from period A to period B. When getting a loan, CUMIPMT function can be used to calculate the total amount of interest paid in the first five months or from period 12 to period 20. A period can be a month, a week or two week. Loan Amount : 350,000.00 APR: 4.5% Down payment: 0.00 Years: 25 Payment per year: 12 From the above data, we can calculate the following: No of Period: 25 × 12 = 300 Periodic Rate: 4.5/12 = 0.375% Here is how you will substitute these values into the function. = CUMIPMT (periodic rate, No of period, vehicle price, start period, end period, ) = CUMIPMT (0.375, 300, 350000, 1, 5, 0) In an excel worksheet, we use cell address instead of actual values as shown below: Here is the formula view of the worksheet: CUMPRINC Another related function is CUMPRINC. CUMPRINC function is used to calculate cumul
Comments
Post a Comment