Mr.Love invested money for his retirement as follows:
• starting at age 30 (on his 30th birthday), he invested $800.00 each year on his birthday up to and including his 54th birthday
• at various times (always on his birthday) he invested additional amounts of money:
o $2000.00 on his 35th birthday
o $5000.00 on his 40th birthday
o $1000.00 on his 43th birthday
o $6000.00 on his 50th birthday
Mr. Love is now 55 years old (and yes, it is his birthday), and he wants to check up on the calculations of the financial institution where he invested his money. The financial institution reported that the rate of growth had been approximately 19% per year compounded annually.
Prepare an investment spreadsheet for Mr.Love that includes one column for regular payments, and another column for additional payments. The spreadsheet should also show the balance at each birthday, including his 55th birthday. Use a rate of growth (interest rate) as 19% per annum compounded annually.
I have solved the problem(see attached) but I need to explain how I calculated the interest.
=C9*$D$4/$D$5 (I've got it from the book but doesn't make any sense to me)[/FONT]