WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » NPV Examples

NPV Examples

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Examples of NPV (Net Present Value)

Net Present Value (NPV) refers to the dollar value derived by deducting the present value of all the cash outflows of the company from the present value of the total cash inflows and the example of which includes the case of the company A ltd. where the present value of all the cash outflows is $100,000 and the present value of the total Cash inflows is $120,000, so the net present value will be $20,000 ($120,000 – $100,000)

The following NPV examples (Net Present Value) provides an outline of the most common investment decisions. It is impossible to provide a complete set of examples that address every variation in every situation since there are thousands of such projects with Net Present Value analysis. Each example of the  NPV states the topic, the relevant reasons, and additional comments as needed

The net present value is the difference between the present value of future cash inflow and the present value of cash outflow over a period of time. NPV is widely used in capital budgeting and to know the profitability of the project.

  • If the Net present value is positive, then the project should be accepted. It indicates that earning from the project is more than the amount invested in the project, so the project should be accepted.
  • If the Net present value is negative, then it indicates that the project in which we invested the money does not provide a positive return, so the project should be rejected.

Mathematically, NPV Formula is represented as,

NPV = Cash Flows /(1- i)t – Initial Investment

Where

  • i stands for the Required Rate of Return or Discount Rate
  • t stands for Time or Number of Period

Examples of Net Present Value (NPV)

Let’s see some simple to advanced examples of Net present value to understand it better.

Example #1

Company A ltd wanted to know their net present value of cash flow if they invest 100000  today. And their initial investment in the project is 80000 for the 3 years of time, and they are expecting the rate of return is 10 % yearly. From the above available information, calculate the NPV.

Solution:

Calculation of NPV can be done as follows,

Net present Value Example 1

NPV = Cash flows /(1- i)t – Initial investment

= 100000/(1-10)^3-80000

NPV = 57174.21

So in this example, NPV is positive, so we can accept the project.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example #2

In 2nd example, we will take the example of WACC (weighted average cost of capital) for calculating the NPV because, in WACC, we consider the weight of equity and debt also the cost of equity and debt. Calculate the NPV.

Solution:

Company XYZ Ltd provides the following detail regarding their project for 10 years.

Free cash flow to the firm is given below over a period of time. And WACC is 15 %

Calculation of NPV can be done as follows,

Net present Value 2

NPV =1104.55

In this example also Net present value is positive, so we can, or we should accept the project

Example #3

Maruti is in the business of auto and ancillary, and they want to start their subsidiary business as an expansion plan for assembling the auto part, so they had provided the below information for calculating the NPV. They want to know should this project will be feasible or not.

  • Cost of equity – 35%
  • Cost of debt – 15%
  • The weight of equity – 20%
  • The weight of debt – 80 %
  • Tax rate – 32%
  • Cash flow is given below for 7 year
  • 2010= -12000
  • 2011=10000
  • 2012=11000
  • 2013=12000
  • 2014=13000
  • 2015=14000
  • 2016=15000

Find the NPV with the help of WACC.

Solution:

Calculation of WACC can be done as follows,

Example 3

WACC formula = We*Ce+Wd*Cd*(1-tax rate)

= 20*35+80*15*(1-32)

WACC = 15.16%

Calculation of NPV can be done as follows,

net present value Example 3.1

NPV = 29151.0

In this example, we are getting a positive net present value of future cash flows, so in this example also we will accept the project.

Example #4

Toyota wants to set up one new plant for expansion of current business, so they want to check the feasibility of the project. Toyota had provided the following information regarding cash flows and WACC. Cash flow during the period is as follows.

  • 2008 = -4000
  • 2009= -5000
  • 2010= 6000
  • 2011=7000
  • 2012=9000
  • 2013= 1200

Solution:

Calculation of NPV can be done as follows,

net present value

NPV = 12348.33

Recommended Article

This has been a guide to NPV Examples. Here we learn how to calculate NPV (Net Present Value) step by step with the help of practical examples. You may learn more about financing from the following articles –

  • Examples of Capital Budgeting
  • Formula of Time Value of Money
  • PV of an Annuity
  • NPV vs IRR
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More