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 value 15,000 10% 5 $91,576.50
Step by Step Solution
3.47 Rating (177 Votes )
There are 3 Steps involved in it
A 1 Annual payment 2 Interest rate 3 Number of years 4 Total val... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1553_61d57f259d845_810509.pdf
180 KBs PDF File
1553_61d57f259d845_810509.docx
120 KBs Word File
