Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Investing

Authors: Scott B. Smart, Lawrence J. Gitman, Michael D. Joehnk

12th edition

978-0133075403, 133075354, 9780133423938, 133075400, 013342393X, 978-0133075359

More Books

Students also viewed these Finance questions