Design a spreadsheet in excel for the calculation of simple and compound interest
Answers
Answered by
0
Answer:
Explanation:To calculate compound interest in Excel, you can use the FV function.
This example assumes that $1000 is invested for 10 years at an annual interest rate of 5%, compounded monthly.
In the example shown, the formula in C10 is:
=FV(C6/C8,C7*C8,0,-C5)
Similar questions