Question: please use excel to solve this problem, each scenario has table and graph A friend of yours opens a savings account and immediately invests R22,500

 please use excel to solve this problem, each scenario has table

please use excel to solve this problem, each scenario has table and graph

A friend of yours opens a savings account and immediately invests R22,500 in the account. Thereafter your friend decides to invest an amount of R715 at the end of each month in the same savings account. The monthly investments will be made for a total of 5 years and the savings account earns interest at a rate of 5.45% per year. Do the following for each of the scenarios below: Complete the table, calculate the accumulated value at the end of 5 years, as well as the present value at the start of the period. Scenario 1: Scenario 2: Scenario 3: The monthly investments remain constant over the 5 years. The monthly investments increase every quarter with 1.65%. The monthly investments increase every halfyear with 4.15%. Draw a graph where you compare the growth in the savings account under each of the three scenarios. (Include all 3 scenarios in 1 graph)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Finance Questions!