Question: General Calibri (Body) 11 A A E BLUE 00 Paste 00 Conditional Form Formatting as Tal Open recovered workbooks? Your recent changes were saved. Do


General Calibri (Body) 11 A A E BLUE 00 Paste 00 Conditional Form Formatting as Tal Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? G A M H F D C N L K J 2 3 You are saving for retirement. You have 23.5 years to retirement and you currently have $153,000 You will be putting $388 a week into your retirement fund. You will receive 6.75% annual interest return on the money. Setup this problem as we have done in class and assignments. Use a function to calculate how much money you will have at retirement Use a utility to determine what the weekly amount needs to be to end up with 2.1 million dollars. 5 6 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Create a two dimensional data table showing how the amount you have at retirement will vary if the Interest rate varies from 4% to 8% in one half percentages and the weekly amount varies from 350 to 400 in ten dollar amounts Format appropriately 10 points You are saving for retirement. You have 23.5 years to retirement and you currently have $153,000. You will be putting $388 a week into your retirement fund. You will receive 6.75% annual interest return on the money. Setup this problem as we have done in class and assignments. Use a function to calculate how much money you will have at retirement. Use a utility to determine what the weekly amount needs to be to end up with 2.1 million dollars. Create a two dimensional data table showing how the amount you have at retirement will vary if the interest rate varies from 4% to 8% in one half percentages and the weekly amount varies from 350 to 400 in ten dollar amounts. Format appropriately. (10 points) Do Not Hard code Please Show work
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
