Introduction to Cash Flow Diagrams, NPV & IRR

Cash flow diagrams are a tool for organizing and visualizing information about a specific investment, business opportunity, or engineering project.  Drawing an accurate cash flow diagram helps financial analysts keep track of all the money flows that result from any decision.  However, the goal of net present value analysis is to simplify all of the disparate information in the cash flow diagram into a single number: present value.

“Net” present value refers to the difference between all of the costs resulting from a project and all of the revenues, after each is discounted to present value.  This video shows an example of a college student who is considering investing $10K they’ve save for college in equipment for a landscaping business.  They make some assumptions about the cost of the equipment, the revenues they will receive from the business, and what they can sell the used equipment for.  Lastly, to complete the analysis, they need to choose a discount rate that reflects their time preference.  This could be the cost of borrowing the initial $10K investment, or it could be some other value.

This video uses Excel to show how the net present value changes with respect to changes in discount rate.  Notice that Excel includes an “NPV” formula that saves the analyst the trouble of typing.

When an investment has positive net present value, then it is profitable.  However, this doesn’t necessarily say much about whether this investment is more profitable than alternative investments, relative to amount invested.  Another way to assess the quality of an investment opportunity is to calculate the internal rate of return (IRR).

The next video uses the same example, but instead of selecting a discount rate to calculate a net present value, we look for a discount rate that makes all the future revenues equivalent to the initial investment, which we call the IRR.  Investment opportunities with higher IRR are preferable to lower.

Related articles

18 thoughts on “Introduction to Cash Flow Diagrams, NPV & IRR

    1. Thomas P Seager

      Well done. Several people miss the importance of NET present value.

      Also, it’s interesting to think about the labor required to earn this return. How many hours? If the NPV were amortized over those hours, what would be the hourly wage?

      Reply
      1. Andres Amado

        I was also intrigued by how the NPV would amortized over the hours spent working before reading your comment. The 2016 summer months conveniently work out to be exactly 13 working weeks. assuming a 40 hour work week the $6,510.80 would equate to a value of $12.52 per hour. this does not include the time spent selling the equipment in the fourth month.

        Reply
  1. Trevor

    I Agree with Ken, it took me a minute to come up with the correct present value. As Sal Khan pointed out in an his video, it was nice being able to replay certain content to grasp the understanding.

    Reply
  2. Pingback: Perpetual Bonds, the Long View, and Hyperbolic Discounting | CEE300 – Engineering Business Practices

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s