Skip to main content

Michael Linton   |   FL Broker License BK703722   |   39 Years Experience   |  (312) 612-1031

Videos · · 1:46

Financial Analysis Lesson 6: DCF, NPV and IRR for a Commercial Property

Valuing the whole hold, not one year. Lesson 6 of the free Course 1: Financial Analysis for Commercial Real Estate, worked on one example property. Hypothetical figures.

Read the lesson →

Chapters

  1. 0:00Introduction
  2. 0:09The whole hold, plus the sale
  3. 0:30Seven years of cash flow to equity
  4. 0:37Equity IRR 9.59%; multiple 1.80×
  5. 1:02At a 9% hurdle: NPV
  6. 1:22Run the DCF in the calculator
  7. 1:27Apply it on a real deal

Transcript

Course one, Financial Analysis. Lesson six: discounted cash flow, net present value, and internal rate of return.

A cap rate looks at one year. A discounted cash flow looks at the whole hold: every year's cash flow, plus the sale. We grow NOI three percent a year and sell after seven years at a seven and a quarter cap rate, for about four point oh six million dollars, less selling costs. The loan balance then is about two point oh two million.

Here's every year of cash flow to equity, from the one point three three million we put in, through the sale in year seven.

The internal rate of return is the discount rate at which these flows are worth exactly what you paid. Without debt, the property's IRR is seven point eight eight percent. With the loan, the equity IRR is nine point five nine percent, and the equity multiple is one point eight. Leverage hurt year one, but helped the total return, because the property earns more than the six and three quarters percent interest rate.

Net present value asks the sharper question: at the return you require, is the deal worth its price? At nine percent, the levered NPV is positive, about forty-six thousand dollars. Unlevered, it's negative, about two hundred thirteen thousand. On its own, the property doesn't earn nine percent at this price.

The DCF calculator runs the full hold with your assumptions, inside the lesson.

On a real deal, build the year-by-year model, set the exit cap at or above today's, and choose your discount rate first. Then accept or reject on NPV. Next, lesson seven: taxes. From Linton Global Solutions.

Narration is AI-generated in Michael R. Linton's voice. Figures are illustrative unless sourced. General information, not investment, legal or tax advice.

More videos

Linton Global Solutions · Florida Licensed Real Estate Broker · BK703722