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

PropertyMetrics

  • Home
  • Blog
  • Products
    • Proforma Software
    • Publisher Software
    • Courses
  • Sign In
    • Software Login
    • Courses Login
  • Contact Us
  • Build a Proforma

Easy NPV Calculator

The Net Present Value (NPV) is a frequently used and critical measure of investment performance. We’ve written about the NPV in depth, but to further clarify these concepts we’ve created a simple to use NPV calculator. This NPV calculator is based on Excel and makes it easy to quickly calculate NPV for any set of cash flows.

NPV Calculator

Fill out the quick form below and we'll email you our free NPV calculator. You can use our NPV calculator to quickly calculate NPV for any holding period you need. You can also visualize what your cash flows are doing in each period of the analysis.

 

How to Use The NPV Calculator

Here is how you can use this NPV calculator, step by step.

  1. Download the NPV calculator using the form above.
  2. Adjust the number of periods you want in your holding period. Our calculator can handle any number of periods you need.
  3. Input your cash flows.
  4. Enter your require discount rate.
  5. View the calculated NPV

As you can see, we’ve made it simple to use our NPV calculator.

 

NPV Calculator Example #1

Let’s walk through a simple example using this NPV calculator. Suppose we have the following cash flows we’ve estimated for a potential commercial real estate investment property:

Initial Investment: $1,000,000

Annual Cash Flows for 5 years: $100,000, $103,000, $105,000, $110,000, $112,000

Net Sales Proceeds: $1,100,000

 

In order to determine if this is an investment we want to take a closer look at, we can quickly calculate the net present value. To do this we simply need to input the above cash cash flows into our NPV calculator, enter a discount rate, and then view our NPV:

NPV calculator

As you can see, the projected cash flows result in an NPV of $3,762 assuming our discount rate is 12%. What does this mean? The net present value simply measures the present value of all future cash flows minus the present cost to acquire those cash flows. Our present value is also calculated above at a 12% discount rate and this results in a PV of $1,003,762. This is what all of these future cash flows are worth to us today at a 12% discount rate. Now we can simply subtract our initial cost of $1,000,000 to get our net present value of $3,762. The NPV formula in Excel simply completes this process in one single step. As you can see, we also provide the internal rate of return (IRR) in this calculator, as well as a visual breakout of the cash flows in each period of the holding period.

 

NPV Calculator Example #2

Now suppose we have more than 5 cash flows. To change the holding period all you need to do is change the optional “# of Periods” input. Then the cash flow table and visual chart will automatically update for you. As shown below, we’ve updated our cash flow projection from the example above to 10 years instead of 5. Now we instantly have a new cash flow table as well as new calculations.

Net Present Value Calculator

Again, we can see that the NPV calculated above is $-20,213. This means that in order to achieve our required return of 12%, we need to pay $20,2013 less than the initial investment of $1,00,000. In other words, if we pay $979,787 for this set of cash flows instead of $1,000,000, then we will achieve our requires rate of return of 12%. For more on the meaning of NPV, check out our article on the intuition behind IRR and NPV.

NPV Calculator

Fill out the quick form below and we'll email you our free NPV calculator. You can use our NPV calculator to quickly calculate NPV for any holding period you need. You can also visualize what your cash flows are doing in each period of the analysis.

Primary Sidebar

What is PropertyMetrics?

PropertyMetrics provides web-based software for commercial real estate analysis and presentation.

Recent Posts

  • How the Development Spread Works
  • Understanding the Texas Ratio
  • Understanding the Construction Draw Schedule
  • How The Double Net Lease Works
  • How to Calculate an Interest Reserve for a Construction Loan

WHAT OTHERS ARE SAYING

"I'm a 30+ year seasoned veteran in shopping center development. PropertyMetrics is an excellent source of information with professional grade software for analysis and presentation. I highly recommend it."
- Frank C. Guess | Barnhart Guess Properties, LLC


"PropertyMetrics is very helpful in my understanding of commercial real estate. The presentation and information provided is astute and always to the point with great clarity. PropertyMetrics is truly appreciated."
-Sheriar Khorsandian, CCIM | Osceola Partners, LLC


"I am very impressed with your product. I have to also compliment your company on clearly explaining valuation concepts to me. To put this into context, I asked my professor in my investment class last week if he knew of a way to value an income property using discounted cash flow analysis. Long story short...you guys are smarter than my professor. THANKS PropertyMetrics! "
-Jonathan Torres | College Student


"I want to compliment PropertyMetrics for providing clear and concise tools for analyzing commercial real estate. As the head of a local Taxpayers Association with a considerable amount of municipal real estate, your data provides me with the information needed to show how much current lease terms cost the town in lost revenue, making my task much easier. Thank you!"
-Jerome Scott | Taxpayers Association of Jamestown


I am a professor at NYU's real estate program and I always tell my students that PropertyMetrics has the best and most easily understood explanations of real estate concepts. Great job!!!"
-J. Weinberg, Adjunct Professor | New York University


"I want you to know how much I appreciate PropertyMetrics. As a 30 year real estate attorney focusing primarily on commercial leasing and purchase and sale of commercial properties, it is extremely helpful to see the principles I have learned and used for so many years explained so clearly."
-Jon K. Ladd | Business and Real Estate Law Group


"I am commercial real estate lender for a large regional bank and I recommend PropertyMetrics to everyone."
-Andrew Levin | Commercial Lender


"Frankly, since I have been getting your emails we have one of the best educated offices in our market!"
-William C. Colucci | Associate Real Estate Broker


"PropertyMetrics is awesome. I actually just went ranting and raving about it to a few other analysts at my company and everyone has been thanking me for referring them!"
-Richard Cadena Jr. | Analyst


"PropertyMetrics is great. Invaluable."
-Peter Knobloch | President/CEO

Footer

My Account

Software Login

Courses Login

Contact Us

Do you have questions, comments, or feedback? Drop us a line and let us know. Get in touch.

Get Our Best Content First

Solutions | Blog | Resources | Contact | Terms | Privacy

Copyright © 2021 PropertyMetrics.com

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OK