Calculating Present and Future Value of a Single Cash Flow

Welcome to the course. We begin with the first module, Core Financial Math and Investment Returns. The central idea is simple but used everywhere in finance: a dollar available today and a dollar promised in the future are not automatically equivalent. This lesson gives you the tools to translate one into the other for a single, one-time cash flow.

By the end, you will be able to decide whether a problem calls for present value or future value, use the appropriate formula, and check whether the result makes economic sense.

---

Why timing changes value

Money held today can potentially earn a return. That opportunity means that, if all else is equal, money today is worth more than the same stated amount received later. Inflation and uncertainty about receiving future money reinforce that principle, although this lesson will first treat the stated interest rate as given.

A single cash flow, also called a lump sum, is one payment at one specific date. Examples include:

• Investing USD 4,000 today and asking what it could be worth in five years.
• Being promised USD 20,000 in six years and asking what that promise is worth today.
• Comparing a cash payment now with a fixed payment at a future date.

The interest rate in these calculations has two closely related interpretations:

• For future value, it is the return you assume money can earn over time.
• For present value, it is the discount rate: the return you require to give up money today in exchange for future money.

The calculation does not guarantee that a risky investment will actually earn that return. It simply answers: given this stated rate and timing, what amounts are financially equivalent?

A useful way to frame every problem is:

If you know...	And want to find...	Use...
Money today	Its value at a future date	Future value
A future payment	Its value today	Present value

---

Future value: compounding today’s money

Suppose you invest an amount today, called present value or $PV$, at an annual rate $r$, for $n$ years. Its future value, $FV$, is:

$$FV=PV(1+r{)}^n$$

Use the rate in decimal form. Thus, $5\%$ becomes $0.05$, and $6\%$ becomes $0.06$.

The exponent $n$ matters because this is compound interest. You earn interest not only on the original investment but also on prior interest that remains invested.

Worked example: saving for a medium-term goal

Assume you invest USD 4,000 today at $5\%$ annually and leave it invested for five years.

$$FV=4,000(1+0.05{)}^5$$ $$FV=4,000(1.05{)}^5$$ $$FV=5,105.13$$

After five years, the investment’s future value is USD 5,105.13, assuming a constant $5\%$ annual return and annual compounding.

Here is the compounding process in selected years:

Point in time	Account value
Today	USD 4,000.00
End of year 1	USD 4,200.00
End of year 2	USD 4,410.00
End of year 5	USD 5,105.13

The first year adds USD 200 of interest. In the second year, the account earns $5\%$ on USD 4,200, not merely on the original USD 4,000. That additional interest on earlier interest is what makes compounding powerful over long periods.

When calculating a future value, do not round the growth factor too early. Keep the calculator’s full precision and round only the final dollar result.

---

Present value: bringing a future payment back to today

Present value reverses compounding. If a certain amount will grow at a stated rate, then a future payment must be divided by that growth factor to find its value today.

$$PV=\frac{FV}{(1+r{)}^n}$$

This process is called discounting.

Worked example: valuing a future payment

Suppose someone offers to pay you USD 20,000 six years from now. You believe a suitable annual return for money of similar risk is $4.5\%$. What is that future payment worth today?

$$PV=\frac{20,000}{(1+0.045{)}^6}$$ $$PV=\frac{20,000}{1.30226}$$ $$PV=15,357.96$$

The present value is USD 15,357.96.

In practical terms, USD 15,357.96 invested today at $4.5\%$ per year would grow to USD 20,000 after six years. Therefore, under that rate assumption, these are equivalent values at different dates.

The same mathematics lets you compare offers. For example, compare:

• USD 4,000 today
• USD 5,000 in five years

At a $5\%$ annual rate, USD 4,000 today has a five-year future value of USD 5,105.13. Alternatively, USD 5,000 received in five years has a present value of:

$$PV=\frac{5,000}{(1.05{)}^5}=3,917.63$$

Purely on this time-value basis, USD 4,000 today is more valuable than USD 5,000 in five years. In a real decision, you would also consider taxes, liquidity needs, and whether the future payment is genuinely certain.

---

A reliable calculation routine

Before reaching for a calculator or spreadsheet, organize each problem in the same way.

1. Identify the single dated cash flow. Is it an amount available today or an amount paid later?
2. Write the known inputs. Record $PV$ or $FV$, the rate $r$, and the number of periods $n$.
3. Match the rate to the period. A $5\%$ annual rate and a five-year horizon use $r=0.05$ and $n=5$. Do not combine an annual rate with a number of months unless you first convert the rate and periods consistently.
4. Choose the direction. Multiply by $(1+r{)}^n$ to move forward in time; divide by it to move backward.
5. Perform a reasonableness check. With a positive interest rate:
   • A future value should exceed the starting present value.
   • A present value should be less than the future payment.
   • More time or a higher positive rate should increase future value and reduce present value.

For a one-time payment, the two formulas are exact inverses. If you calculate a future value and then discount it using the same rate and number of periods, you should arrive back at the original amount, apart from rounding.

---

Using a spreadsheet without losing the finance logic

A spreadsheet is valuable because later finance problems often contain many cash flows. But the formula should still reflect the economic logic you just learned.

The present-value spreadsheet below uses:

• $5\%$ as the discount rate
• USD 127.63 as the payment received in year five
• the formula =F13/(1+F12)^F14

Because USD 127.63 is a rounded version of the exact five-year value of USD 100 at $5\%$, Excel returns approximately USD 100.001 rather than exactly USD 100.00. This illustrates a useful discipline: retain precision during calculations, then round the final reported amount appropriately.

For your own workbook, label inputs clearly rather than embedding numbers throughout formulas:

Input	Example value
Present value	USD 4,000
Annual rate	$5\%$
Number of years	$5$
Future-value formula	=PV_Cell*(1+Rate_Cell)^Years_Cell

For present value, reverse the formula:

=Future_Value_Cell/(1+Rate_Cell)^Years_Cell

A short practice habit: recreate the two worked examples in a spreadsheet, then change only the interest rate and observe how the result changes. This builds intuition that the rate is not a cosmetic input; it determines the opportunity cost of waiting.

---

Key takeaways

For a single cash flow, time value of money is governed by three inputs: the amount, the rate per period, and the number of periods.

$$FV=PV(1+r{)}^n$$ $$PV=\frac{FV}{(1+r{)}^n}$$

Use future value when starting with money today and projecting forward. Use present value when starting with a future payment and translating it into today’s dollars. Keep the rate and time periods consistent, and use the direction of the result as a quick sanity check.

Next, you will use similar arithmetic to calculate an investment’s total holding-period return, incorporating price movement, income such as dividends or interest, and fees.