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 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
Get step-by-step solutions from verified subject matter experts
