You will be able to present a valuation as a range, driven by the inputs that matter most.
Most broker reports put a single target price on the cover, such as S$1.85. That one number implies a certainty the analyst does not have. The DCF behind a target price depends on a discount rate and a growth rate, and lesson 8.1 showed that a one-point change in either can move the answer by 15% or more. A single target price hides this uncertainty, while a professional valuation shows it. You show it with three tools: a sensitivity table, a set of scenarios, and a check on margin of safety. All figures below are made up and in S$ per share unless stated.
A sensitivity table shows value per share across a grid of two inputs. For a DCF, the usual pair is the discount rate (WACC) down the side and long-term growth across the top, because those two move the answer most. Every other input is held at the base case.
In Excel, the Data Table tool under What-If Analysis builds the whole grid from one formula. Google Sheets has no equivalent, so you build it by hand: copy the valuation into a small block that reads its WACC and growth from the row and column headers, then fill the grid. Once it is built, mark the cell nearest today's share price so the comparison is visible at a glance.
Marcus is valuing Larkspur, a company he already owns. Larkspur is cyclical. It depends on chip equipment spending, has two big customers, and had a weak FY4. Marcus runs WACC from 8% to 10% and long-term growth from 1.5% to 2.5%, with everything else at his base case. His results, for growth of 1.5%, 2% and 2.5% in turn:
WACC 8%: about 1.98, 2.11 and 2.27 WACC 9%: about 1.70, 1.80 and 1.91 WACC 10%: about 1.48, 1.56 and 1.64
The range runs from about S$1.48 to about S$2.27. His base value of S$1.80 sits in the middle. Today's price of S$1.60 is inside the range, close to the 10% row.
A sensitivity table varies two inputs while everything else stays fixed, and real outcomes do not work that way. In a downturn, revenue falls, margins fall with it because of fixed costs, and working capital ties up cash for longer. A scenario changes all related drivers together so they tell one consistent story. Scenario ranges are typically wider than sensitivity table ranges, because business drivers often matter more than valuation inputs, especially for a cyclical company.
To build scenarios, keep the discount rate fixed, define a base, bear and bull case that each move revenue growth, operating margin and long-term growth together, and value each one. Marcus uses a 9% discount rate for all three.
His base case is the forecast he built in module 7: growth fading from 8% to 3%, a 13.5% margin and 2% long-term growth, giving about S$1.80.
His bear case assumes a chip equipment downturn. Revenue falls 10% in FY6, then grows 2%, 4%, 3% and 3%. Operating margin is 11% throughout and long-term growth is 1.5%. Value is about S$1.05. This is roughly Larkspur's own FY4 carried for five years.
His bull case has revenue growth of 12%, 10%, 8%, 6% and 4%, a 15% margin and 2.5% long-term growth, giving about S$2.40. The scenario range is S$1.05 to S$2.40.
Building both tools lets you compare them and see which input matters most. Marcus checks margin on its own, with everything else at base: an 11% margin gives about S$1.33, and a 15% margin gives about S$2.07. That swing is wider than moving WACC from 8% to 10%. For Larkspur, the margin assumption moves value more than any single valuation input. The second biggest driver is whether a downturn arrives early in the forecast.
Your research time should go to the inputs that matter most. For Larkspur, that means evidence on margin through a cycle and on customers' spending plans. Another hour refining the equity risk premium would change little. Another hour reading the two big customers' results calls might change a lot.
Benjamin Graham, the investor and author who taught Warren Buffett, used the phrase "margin of safety". Margin of safety is the gap between the price you pay and a cautious estimate of value. The reasoning is that your estimate will be wrong in ways you cannot foresee, so you want enough room that being wrong does not ruin you.
A cautious estimate is the value you would still believe in if several things went against you. It is a different number from the base case. A pessimistic corner of the sensitivity table or the bear case both work. Compare today's price with it.
Marcus has two cautious estimates: the 10% WACC and 1.5% growth corner at about S$1.48, and the bear case at about S$1.05. The price of S$1.60 sits above both, so there is no margin of safety, even though his base case is 12% above the price (S$1.80 against S$1.60). Lack of margin of safety is neither a reason to sell nor a reason to buy. It is a fact about the risk.
Marcus holds S$8,000 of Larkspur, which is 5,000 shares at S$1.60. At the bear value of S$1.05 those shares are worth S$5,250, a loss of about S$2,750, around a third of the holding. That potential loss in a bad cycle is the figure that belongs in his position limits, which module 11 covers in lesson 11.1, "Position sizing: equal, conviction and volatility weights".
For the activity, build a sensitivity table of value per share against WACC and long-term growth for your company, and mark today's share price on it.
Build a sensitivity table of value per share against WACC and terminal growth, and mark today's price on it.
Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).