Question: You are considering a savings plan which calls for a deposit of $15,000 at the end of each of the next 5 years. If the

You are considering a savings plan which calls for a deposit of $15,000 at the end of each of the next 5 years. If the plan offers an interest rate of 10%, how much will you accumulate at the end of year 5? Do this calculation by completing the following spreadsheet. This spreadsheet does the calculation twice?once using the FV function and once using a simple table which shows the accumulation at the beginning of each year.

1 Annual payment 2 Interest rate 3 Number of years 4 Total

1 Annual payment 2 Interest rate 3 Number of years 4 Total value 15,000 10% 5 $91,576.50

Step by Step Solution

3.47 Rating (177 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

A 1 Annual payment 2 Interest rate 3 Number of years 4 Total val... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1553_61d57f259d845_810509.pdf

180 KBs PDF File

Word file Icon

1553_61d57f259d845_810509.docx

120 KBs Word File

Students Have Also Explored These Related Financial Modeling Questions!