• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Penpoin.

Better Knowledge. Your Insight Is Sharper

  • Business
    • Business and Strategy
    • Marketing
    • Operation
    • Human Resources
  • Finance
    • Financial Analysis
    • Investment
  • Economics
    • Introduction to Economics
    • Microeconomics
    • Macroeconomics
  • Online Learning
    • Coursera
    • Udacity
    • Udemy
    • Skillshare
    • Magoosh
  • Reading List
    • Self-Help
    • Business and Money
You are here: Home / Financial Analysis / Present Value: Formulas, Examples, How to Calculate

Present Value: Formulas, Examples, How to Calculate

Updated on April 15, 2022 by Ahmad Nasrudin

Present value

The present value (PV) is the present discounted value of future cash flows. For assets, it is the present discounted value of future net cash inflows that an asset is expected to produce. For liabilities, it represents the present discounted value of future net cash outflows that are expected to be required to settle the liability.

Present value formula and its example calculation

The present value represents the present nominal of the money we would receive in the future. We can calculate it with the following formula:

Present Value Formula
Present Value Formula

This concept is widely applied in various fields of finance. For example, when you target to have Rp1,000 in the next five years and invest in assets with a return of 12% per year (or 1% per month), then you must now invest as much as:

PV = 1000/((1+1%)^60) = Rp550.45

In excel, we can calculate it using the PV formula:

= PV(rate, nper, pmt, [fv], [type])

  • RATE is the interest rate per period (1%)
  • NPER is the number of periods (60 months)
  • PMT is the payment for each period and cannot change during the annuity period (0)
  • FV is the future value (Rp1000)
  • TYPE refers to when payments are due (0 at the end and 1 at the beginning, in this case, 0).

The above formula assumes we get a monthly return on investment of 1%. If we get annual returns instead of monthly, the values we need to invest now are:

PV = 1000 / ((1 + 12%)^5) = Rp567.43

The value is slightly different due to differences in interest and number of periods. PV uses the concept of interest on interest – or compound interest, i.e. ((1+r%)^N) – so that the value is sensitive to the percentage discount rate and the number of periods. A higher the discount rate leads to a lower the present value of future cash flows. Likewise, the longer the period, the smaller the present value of future cash flows. The following are simulations for the different number of periods and discount rates:

PV (r=1%, FV =1000)Number of periode (r=1%)PV (nper=60, FV=1000)r
408.490421.61.45%
451.180460.71.30%
498.370503.61.15%
550.460550.41.00%
608.050601.80.85%
671.740658.00.70%
741.930719.60.55%
819.520787.00.40%
905.310860.90.25%

Category: Financial Analysis

AFFILIATE

If you click on this link, thank you for contributing to us. We may earn a commission when you buy through our links. Learn more ›

5 NEW ARTICLES

How to Handle and Resolve Stakeholder Conflicts

How to Handle and Resolve Stakeholder Conflicts

Stakeholders have different interests and goals, which are often contradictory. Stakeholder

What are the Benefits of International Trade

What are the Benefits of International Trade?

Increased access to cheaper and more varied goods and services is key benefits of international

Where Do Comparative Advantages Come From

Where Do Comparative Advantages Come From?

The comparative advantage stems from the ability to produce goods and services at low opportunity

What is the Capital Budgeting Process

What is the Capital Budgeting Process?

In simple terms, the capital budgeting process involves generating ideas, making proposals about

Autarky Examples, Pros, and Cons

Autarky: Examples, Pros, and Cons

What's it: Autarky is a system or philosophy in which an economy seeks to

Primary Sidebar

  • "Rich Dad Poor Dad" by Robert Kiyosaki
    "Rich Dad Poor Dad" by Robert Kiyosaki
  • "Why Men Love Bitches" by Sherry Argov
    "Why Men Love Bitches" by Sherry Argov
  • "The Big Short" by Michael Lewis
    "The Big Short" by Michael Lewis

Footer

5 TRENDING ARTICLES

  • Socio-cultural Factors: Examples and How They Impact Business
  • Business Size: Definition, Measurement, Classification
  • The Role of Business in Society and the Economy
  • Trade Restriction: Reasons, Types, and Impacts
  • List of Examples of Social Enterprises You May Be Familiar

EXPLORE MORE

CATEGORIES

Accounting and Finance Books Business and Strategy Financial Analysis Human Resources Investment Macroeconomics Marketing Microeconomics Operation

TOPICS

Aggregate Demand Business Management Demand Financial Analysis Financial Ratio Government Budget International Trade Leadership Macroeconomic Equilibrium Marketing Marketing Management Organizational Structure Profitability Ratio

Copyright © 2023 · About Us  · Privacy Policy and Disclaimer  ·  Affiliate Disclaimer  ·  Terms of Use  ·  Comment Policy  ·  Contact Us