i Enter average annual inflation rate: % Calculate $230,629 Future Value $148,032 Future Value Inflation Adjusted $115,000 Total Deposits $115,629 Interest Earned If you start with $25,000 in a savings account earning a 7% interest rate, compounded monthly, and make a beginning monthly cont...
Read More: How to Apply Present Value of Annuity Formula in Excel 2.3. Utilize NPV Function Including Initial Cost Steps Select the NPV cell (e.g., Cell C14). Enter the following formula: =NPV(C12/12,C5:C10)*(1+C12/12) Press Enter to obtain the NPV. Explanation This formula include...