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


