The Entrepreneur Forum | Startups | Entrepreneurship | Starting a Business | Motivation | Success
  • Please Leave the Politics to CNN and FOX.
    Just a reminder that political topics/memes are prohibited, unless discussed within the realm of business and investment, for example, the impact the new Treasury Secretary might have with BTC. Please help keep the forum free of politics. (And I promise to do better myself!)

Remove ads while supporting the Unscripted philosophy...become an INSIDER.

Did you find this thread useful?

  • Yes

    Votes: 1 33.3%
  • No

    Votes: 2 66.7%

  • Total voters
    3

Millenial_Kid5K1

Bronze Contributor
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Feb 14, 2017
156
396
190
32
Atlanta
Hello all,

I wanted to share one of my favorite tools for making financial decisions: Net present value (NPV) tables.

What you can do with an NPV table:
  1. Compare two options where money is the only deciding factor, e.g.:
  2. Deciding what car to buy
  3. Deciding whether to buy a house or rent
  4. Deciding whether to invest in product A or B(or neither)

Limitations of NPV tables:
  1. You have to have some internal rate of return (IRR), which represents the best return on your money you think you'd get if you invested it somewhere else. This can represent the stock market, bonds, or the average rate of growth of your business.
  2. You can't make conceptual decisions about your life where there are abstract variables, such as the decision to get a job or be an entrepreneur
  3. You can't easily incorporate "odds" into your calculation, for much the same reason as point 2 above. There are ways to do math related to appetite for risk, but I've yet to see a way to rectify these with a simple NPV table.

Concepts:

Inflation - The percentage that your money becomes less useful year over year. This might be the average increase in cost of groceries since 1999, the consumer price index, or you could use a standard 3%.

Internal Rate of Return (IRR) - This is the percentage you could make on a baseline investment year over year with relatively little risk. Many companies use 9.8%, which is supposed to approximate the best investments available to large companies(unrelated to company growth). This is used to discount future money.

I will construct a concrete example to help you learn. Let's consider buying a car. In this case, we're only interested in what will get us from point A to point B for about 10 years. The two options we're considering are a 2007 Toyota Prius, and a 2003 Toyota Corolla, both with about 130,000 miles.

https://www.autotrader.com/cars-for-sale/vehicledetails.xhtml?listingId=460140381


Cars for Sale: Used 2003 Toyota Corolla CE for sale in Norcross, GA 30071: Sedan Details - 456638758 - Autotrader

The first thing with an NPV table is to define our parameters:
  1. We'll take our IRR as 9.8%. It could be much, much higher if your business is growing quickly(e.g. 150%), and it could be lower if you're protecting your assets with very low risk investments(e.g. 5%). Remember that this is supposed to represent money you're actually taking away from another investment with IRR being the return of that other investment.
  2. We'll take inflation as 3%
  3. We'll say that we plan to keep either car for 10 years, driving it roughly 10,000 miles per year.
  4. We'll say the Prius gets 45 mpg, while the Corolla gets 28 mpg.
upload_2017-7-4_14-9-53.png

Next we go about defining some financial aspects:
  1. From the car listings, the prius is $5800 while the corolla is $3800.
  2. We'll guess that the increase of gas stays just ahead of inflation, at about 4% per year.
  3. From repairpal.com, we'll estimate average annual repair costs of the prius at $435/yr, and the corolla at $341 per year, increasing each year with inflation.
  4. In addition, we'll assume that the Prius will need its battery replaced within the first 5 years of ownership(It's free if it happens in 2017, $2600 after that). We'll spread this cost over years 1-4.
CASH FLOW - For each year starting at 0(this is important mathematically), we'll add the gross profit and subtract the costs for that year. In year 0, the costs are the purchase price of the car, the price of gas, and the repair costs for each vehicle. The sum of these is your cash flow.

At this point our spreadsheet for the Prius option looks like this:

upload_2017-7-4_14-10-26.png

And the Corolla looks like this:
upload_2017-7-4_14-10-53.png

DISCOUNT FACTOR - This is the value of money in a given year relative to year 0. It is calculated by {(1 + Inflation)/(1 + IRR)}^year. What this tells you is the useful value of money in that year. In year 1 of our example, (1.03/1.098)^1 = .94, so we're saying that the value of money properly invested next year, should be worth only 94% of the same money invested today.

DISCOUNTED CASH FLOW - This is simply CASH FLOW * DISCOUNT FACTOR. This is the value of cash flow in a given year in today's dollars.

NET PRESENT VALUE - This is the sum of discounted cash flows for every year. This number will tell you whether or not the investment you're considering is worthwhile. In the case of a car, this number will be very negative, since it's a necessity and not an investment geared towards making money. Since you're comparing two options, you can pick the one which is less negative.

Our final spreadsheet for the Prius looks like this:
upload_2017-7-4_14-11-42.png
And this is the Corolla:
upload_2017-7-4_14-11-19.png

In this case, the Corolla would be a better choice, based on our initial assumptions(and assuming there are no other factors than money.)

I've attached the spreadsheet for those who would like to mess around with it. I hope this was useful to you, like I said it's been one of the main tools I've used in the past for making financial decisions.View attachment 15410
 

Don't like ads? Remove them while supporting the forum. Subscribe.

Attachments

  • Car Comparison.xlsx
    13.8 KB · Views: 2

ZCP

Legendary Contributor
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Summit Attendee
Speedway Pass
Oct 22, 2010
2,964
10,258
2,456
Woodstock, GA
Awesome! Put a buy vs rent example out there and it will be Rep+!!
 

Millenial_Kid5K1

Bronze Contributor
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Feb 14, 2017
156
396
190
32
Atlanta
Awesome! Put a buy vs rent example out there and it will be Rep+!!
I pulled an insanely detailed version I did for the duplex I bought. In my case, I didn't even need an NPV table to tell me that living for free far outstripped renting, but the numbers certainly bear that out.

Even if the sell price was worth exactly what it appraised for, buying my duplex would have had a payback period of about 7 months. I'm praying to god that I didn't screw up any math in this spreadsheet. You can see two tabs, where I broke it down by both year(up to 30 years) and monthly (up to 120 months)
upload_2017-7-4_16-6-1.png
 

Attachments

  • Insanely detailed mortgage calculation(30 year).xlsx
    81 KB · Views: 6

Millenial_Kid5K1

Bronze Contributor
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Feb 14, 2017
156
396
190
32
Atlanta
Bump? I'm certain that every entrepreneur could benefit from knowing how to make an NPV table.
 

Leo Hendrix

Bronze Contributor
Read Millionaire Fastlane
Speedway Pass
Apr 15, 2014
468
277
141
WWW
I havent had to use one for personal finance or SMB finance yet as I have gone as minimal as possible and still cutting, no car, renting. Pay Bills + food with a set budget depending on cashflow (savings) but I always calculate NPV depending on my current situation and try to keep cashflow within a certain range and never pay for things in installments or for more than a month at a time upfront if it is a bill, e.g Visa Extension costs.

Great skill and knowledge to have and I know I will use NPV as time goes on.
 

Sponsored Offers

  • Sticky
MARKETPLACE Fox Web School "Legend" Group Coaching Program 2021
Yeah, your youtube channel is incredible and all the videos I have seen so far are really great...
  • Sticky
FEATURED! Introducing... WEALTH EXPO$ED, A Short Story By MJ DeMarco
Finally! I just launched a short story on Kindle (FREE if you have Kindle Unlimited)! After...
  • Sticky
MARKETPLACE You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
I planned to make a separate post for this video but it is useful here as well for anyone...
  • Sticky
MARKETPLACE Lex DeVille's - Advanced Freelance Udemy Courses!
Last promo of the year.. Get the training you need now or miss it. Promo Code: FINALHOUR...
  • Sticky
MARKETPLACE Kill Bigger Incubator
UPDATED POST: Hey Guys! I wanted to give a quick update on what this program has become. In...
  • Sticky
MARKETPLACE Grow Your Business With a Book (An Unorthodox Marketing Strategy That Built One of the Largest...
Are you looking for a new, lesser-known but potentially very lucrative source of leads to your...



Forum Sponsor

sponsor

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Monthly conference calls with doers
Ideas needing execution, more!

Join Fastlane Insiders.

Top Bottom