Question: Need help finding the formula for cell C5. The spreadsheet below represents money put away every year into a mutual find which gets 9.5% per
Need help finding the formula for cell C5.

The spreadsheet below represents money put away every year into a mutual find which gets 9.5% per year. Write a formula for cell C5. C D m F Rate of Return: 9.5% Year New Balance Deposit End Balance 1 S $ 5,000.00 $ 5,475.00 2 $ 5,475.00 $ 5,150.00 $ 11,634.38 3 5 11,634.38 $ 5,304.50 S 18,548.07 A $ 18,548.07 $ 5,463.64 S 26,292.81 5 $ 26,292.81 $ 5,627.54 $ 34,952.79 6 $ 34,952.79 $ 5,796.37 S 44,620.33 44,620.33 $ 5,970.26 S 55,396.70 8 5 55,396.70 $ 6,149.37 S 67,392.95 9 5 67.392.95 $ 6,333.85 S 80,730.84 10 $ 80,730.84 $ 6,523.87 95,543.91 11 $ 95,543.91 $ 6,719.58 $ 111,978.52 12 $ 111,978.52 $ 6,921.17 $ 130,195.16
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
