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

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Financial Modeling

          • What is Financial Modeling
          • Financial Modeling Excel
          • Financial Model Types
        • Excel Modeling

          • Financial Functions Excel
          • Sensitivity Analysis in Excel
          • Time Value of Money
        • Excel-Modeling
        • Valuation

          • Discounted Cash Flow
          • Dividend Discount Model
          • Terminal Value
        • Valuation
        • Investment Banking Guides

          • Investment Banking
          • What is LBO?
          • What is Pitch Book?
        • Investment-Banking-Guides
        • Excel

          • Excel Functions
          • Excel Charts
          • Excel Tips
        • Excel
        • Others

          • Resources (A to Z)
          • Accounting
          • Financial Statement Analysis
          • Equity Research
          • Private Equity
          • Corporate Finance
  • Free Courses
  • All Courses
        • Certification Courses

          Certificate
        • All in One Financial Analyst Bundle

          Financial-Analyst-Bundle
        • Financial Modeling Course

          Financial-Modeling-Course
        • Investment Banking Course

          Investment-Banking-Training
        • Others

          • M&A Modeling Course
          • LBO Modeling Course
          • Valuation Modeling Course


          • PE Modeling Course
          • VC Modeling Course
          • View All
  • 250+ Courses All in One Bundle
  • Login

NPV Examples

Home » Financial Modeling » Excel Modeling » NPV Examples

By Harshada Khot Leave a Comment

NPV Examples

NPV Examples (Net Present Value)

The following NPV example (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

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
Cyber Monday Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) 250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,067 ratings)
Course Price

View Course

Related Courses
M&A Modeling CourseLBO Modeling CourseValuation Modeling 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 of the auto part so they had provided 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 follow.

  • 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 –

  • What is the Nominal Rate of Return?
  • Importance of Capital Budgeting
  • Top 5 Best Capital Budgeting Techniques
  • Examples of Capital Budgeting
  • Marginal Tax Rate | Definition
  • Formula of Time Value of Money
  • PV of an Annuity
  • PV vs NPV – Compare
  • NPV vs IRR – Compare
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 >>

Filed Under: Excel Modeling, Financial Modeling

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. 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

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

Download Colgate's Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

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