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.

Need help finding the formula for cell C5. The spreadsheet below represents

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

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 Mathematics Questions!