How do you calculate present value of savings?
James Olson
Updated on February 23, 2026
It’s important to understand exactly how the NPV formula works in Excel and the math behind it. NPV = F / [ (1 + r)^n ] where, PV = Present Value, F = Future payment (cash flow), r = Discount rate, n = the number of periods in the future.
What is the formula for calculating present value?
The present value formula is PV=FV/(1+i)n, where you divide the future value FV by a factor of 1 + i for each period between present and future dates.
How do you find the future value of 1?
The future value formula
- future value = present value x (1+ interest rate)n Condensed into math lingo, the formula looks like this:
- FV=PV(1+i)n In this formula, the superscript n refers to the number of interest-compounding periods that will occur during the time period you’re calculating for.
- FV = $1,000 x (1 + 0.1)5
What is the formula for a savings plan?
−1 i APR. n. where A = accumulated savings plan balance PMT = regular payment (deposit) amount APR =annual percentage rate (as a decimal) n = number of payment periods per year Y = number of years. Ex.1. Suppose you deposit $100 into your savings plan at the end of each month.
How to calculate the value of savings after taxes?
Subtract that amount from your future savings value to get your savings after taxes. The present value of a future sum of money is equal to the future value times (1 – the annual rate of inflation as a decimal) raised to the n th power, where n is the number of years into the future.
Do you have to put money into savings calculator?
You’ll enter this number into the calculator as your starting point. You can deposit as much or as little as you want into the calculator but beware that some savings accounts have minimum deposit requirements. Making a larger deposit does allow your money to grow more than, say, a $20 original deposit.
How to calculate the future value of money?
n is the number of periods until it’s received. An annuity is a stream of equal payments. The future value of an annuity is how much a stream of A dollars invested each year at r interest rate will be worth in n years. The formula is FV A = A * { (1 + r) n – 1} / r.
