Value your modelled company with a DCF

You will be able to complete a DCF for your modelled company and write a one-page note on the result.

Marcus is valuing Larkspur, a made-up company, using the forecast model he built in module 7. He has about seventy-five minutes to turn that model into a value range, a reverse DCF and a one-page note that someone else could challenge.

You will do the same with your own model. You need the balanced model from Lesson 7.8, Build the forecast and balance the model, and the WACC inputs from Lesson 8.2, Cost of capital: equity, debt and a WACC you can defend. The note is what you keep, and the spreadsheet is the evidence behind it.

Setting up the Valuation tab and linking free cash flow

Add a new tab to your model and call it Valuation. If your company is a bank or a REIT, use the methods in Lesson 8.7 in place of the free cash flow and terminal value steps below. Then pick up again at the sensitivity table.

The tab should read free cash flow from the statement tabs rather than from typed numbers. That way any change in a driver flows through to value per share. For each forecast year, calculate free cash flow to the firm (FCFF) as operating profit x (1 - tax rate) + depreciation - capital spending - increase in working capital. Below the FCFF row, add a row for the discount factor, which is 1 / (1 + WACC) raised to the year number. The present value of each year is FCFF multiplied by that year's discount factor. Record your WACC with its sources and the date you took them.

The Larkspur figures are invented examples, in S$ millions unless they are per share. Marcus's FCFF is about 32.4 in FY6, then about 35.4, 38.3 and 41.0, and about 43.5 in FY10. At a WACC of 9%, the present values of FY6 to FY10 add up to about 146.5.

Terminal value and the bridge to value per share

Calculate the terminal value two ways, by the growth method and by the exit multiple method, as in Lesson 8.3, The terminal value problem and why it dominates the answer. Beside the growth-method terminal value, show the multiple it implies. Beside the exit-multiple terminal value, show the growth it implies. Each figure lets you check the other method.

Then build the bridge from cash flows to a share price. Enterprise value is the sum of the present values plus the discounted terminal value. Equity value is enterprise value minus net debt. Treat leases the same way your cash flows treated them. Value per share is equity value divided by the share count.

Marcus uses the growth method at 2% long-term growth. His enterprise value is about 558.6. He subtracts net debt of 20 to get equity of about 538.6, and divides by 300 million shares to get about S$1.80 a share. Terminal value makes up about 74% of his enterprise value. His exit method at 7 times EBITDA gives about S$1.94 a share and implies long-term growth of about 2.6%.

Building the range and testing today's price

Add a sensitivity table, as in Lesson 8.6, Sensitivity tables and scenarios instead of one target price, with WACC down the side and long-term growth across the top. Mark today's price on it. Next, build bear and bull scenarios as separate copies of the inputs, each with its own value per share. Last, run the reverse DCF from Lesson 8.5, Reverse DCF: what the market is already pricing in, and record the growth that the current price implies.

Marcus's sensitivity table gives a central range of about S$1.58 to S$2.08, using WACC of 8.5% to 9.5% and long-term growth of 1.5% to 2.5%. His scenarios run from about S$1.05 in the bear case to about S$2.40 in the bull case. At a price of S$1.60, his reverse DCF implies revenue growth of about 1% a year. Larkspur's revenue grew about 7.5% a year in the past.

Before you write the note, look at where your range sits against today's price. If the whole range is far above or far below the price, recheck the share count, net debt and lease treatment first. A large gap is more often a linking error than a discovery.

Writing the one-page note

The note has four short parts:

the value range and how it compares with today's price the three or four assumptions that drive it most what the current price implies the evidence that would change your mind

Keep it to one page. If it runs longer, you are explaining the method rather than your view, and the method belongs in the spreadsheet. The note does not say buy, sell or hold. It states a range, the assumptions behind it, what the market assumes instead, and what would prove you wrong.

Marcus's note values Larkspur at about S$1.60 to S$2.10 a share, which is his S$1.58 to S$2.08 range rounded, against a price of S$1.60. His three main assumptions are a 13.5% operating margin through a cycle, revenue growth fading from 8% to 3%, and Larkspur keeping both of its two largest customers. He writes that the market is pricing in about 1% growth a year, well below the company's record. His bear case is a downturn starting next year with margins at 11%, worth about S$1.05. Because that is below the S$1.60 price, there is no margin of safety against that outcome.

He names two things that would change his view. One is a major customer moving meaningful volume to its second supplier. The other is the margin falling below 12% in a year when revenue held up, which would point to pricing pressure rather than the cycle. He gives no buy, sell or hold call.

Checking your work and where the range goes next

A finished Valuation tab has linked FCFF, a dated WACC, terminal value by both methods with the cross-check beside each, value per share, a sensitivity table with today's price marked, bear and bull values, and a reverse DCF result. A finished note has a range, the main assumptions, the implied growth and two things that would change your view.

Module 9 tests your range against what similar companies trade at. Module 11 decides how much of a portfolio a holding with this range deserves.

Now finish your Valuation tab and write the one-page note. It should give your value range, the growth implied by today's price and two things that would change your view.

Finish the valuation tab. Then write a one-page note giving your value range, the growth implied at today's price and two things that would change your view.

Course

Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).