Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose the money is automatically deposited in a mutual fund. Further suppose that the mutual fund earns 3% each compounded monthly. Create an Excel
Suppose the money is automatically deposited in a mutual fund. Further suppose that the mutual fund earns 3% each compounded monthly. Create an Excel spreadsheet which shows the total value of your investment up until age 65. The spreadsheet will have the following column titles and 20*12= 240 rows. Start with month one. Month Prior balance Interest Earned Month 1 End of month deposit What is the value of your investment when you turn 65? Copy and paste your first and last two rows below. End of month total 3% Prior balance Interest Earned End of month deposit $40.00 End of month total 5% $80.10
Step by Step Solution
★★★★★
3.49 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
Month Prior Balance Interest Earned End of month deposit End of Month Total 1 000 000 4000 4000 2 4000 010 4000 8010 3 8010 020 4000 12030 4 12030 030 4000 16060 5 16060 040 4000 20100 6 20100 050 400...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started