Reading 38
MODULE 38.1: FINANCIAL STATEMENT MODELING
Demonstrate the development of a sales-based pro forma company model.
A sales-based pro forma company model consists of projected future financial statements, based on an analyst's estimate of a company's future revenues. We summarize the steps in creating such a model here. (In our Equity Investments reading on Company Analysis: Forecasting, we will describe some of these steps in more detail.)
| Step | Description |
|---|---|
| Step 1 | Estimate revenue growth and future revenue, based on market growth and market share, a trend growth rate, or growth relative to GDP. |
| Step 2 | Estimate COGS based on a percentage of sales, or on a more detailed method based on business strategy or competitive environment. |
| Step 3 | Estimate SG&A as either fixed, growing with revenue, or using some other estimation technique. |
| Step 4 | Estimate financing costs using interest rates, debt levels, and the effects of any large anticipated increases or decreases in capital expenditures or anticipated changes in financial structure. |
| Step 5 | Estimate income tax expense and cash taxes using historical effective rates and trends, segment information for different tax jurisdictions, and anticipated growth in high- and low-tax segments, taking into account changes in deferred tax items. |
| Step 6 | Model the balance sheet based on items that flow from the income statement (working capital accounts). |
| Step 7 | Use depreciation and capital expenditures (for maintenance and for growth) to estimate capital expenditures and net PP&E for the balance sheet. |
| Step 8 | Use the completed pro forma income statement and balance sheet to construct a pro forma cash flow statement. |
銷售導向的擬制公司模型(sales-based pro forma model):以分析師對未來營收的估計為基礎,產出公司未來財務報表的預測。建構此模型的標準八步驟:
- 估計營收成長與未來營收:可依市場成長與市占率、趨勢成長率,或相對 GDP 的成長率推估
- 估計 COGS:以佔銷售額百分比,或依商業策略與競爭環境的詳細方法
- 估計 SG&A:可設為固定金額、隨營收成長,或採其他估算方式
- 估計財務成本:考量利率、負債水準,以及資本支出大幅變動或資本結構改變的影響
- 估計所得稅費用與現金稅:依歷史有效稅率與趨勢、分部稅務管轄資訊、高低稅率分部的成長,並考量遞延稅項變動
- 編製資產負債表:依損益表項目(營運資金科目)推導
- 估計資本支出與淨 PP&E:以折舊與維修、成長性資本支出推算
- 編製現金流量表:依完成的擬制損益表與資產負債表推導
Explain how behavioral factors affect analyst forecasts and recommend remedial actions for analyst biases.
Like everyone, those in the financial industry are prone to behavioral biases. For analysts, these biases can result in inaccurate forecasts.
- Overconfidence bias. This is having too much faith in one's own work. Analysts may underestimate their forecasting errors; hence, they have a narrower confidence interval for their forecasts than warranted. Research has shown that analysts who "go against the grain" (i.e., forecasting what others are not) are more likely to suffer from overconfidence bias. Mitigation: share forecasts and solicit critique; evaluate past forecasts and learn from forecasting errors (which should lead to widening confidence intervals); use scenario analysis to produce a range of forecasts.
- Illusion of control bias. Related to overconfidence, but refers specifically to overestimating what an analyst can control and trying to control things an analyst cannot control. Manifested in two ways: (1) seeking "expert" opinions to justify a forecast, and (2) making a model more complex (e.g., by including more independent variables). Overfitted models perform poorly out of sample and can also conceal assumptions that need to be updated. Mitigation: focus only on variables with known explanatory power; seek outside opinions only from those with a relevant perspective.
- Conservatism bias (anchoring). The analyst makes only small adjustments to their prior forecasts when new information becomes available. Usually results in reluctance to incorporate new negative information, but can also lead to lags in incorporating positive news. Mitigation: periodic evaluation of forecasting errors; use simpler models that are easier to adjust for new or changed assumptions.
- Representativeness bias. Tendency to rely on known classifications. New information may only be superficially similar to a known classification but be better viewed from a fresh perspective. One common form is base-rate neglect, where an observation's base rate (incidence in a larger population) is neglected in favor of situation-specific information. Fixating on company-specific factors is the inside view; viewing the company as a member of a particular industry (focusing on the base rate) is the outside view. Mitigation: consider both inside and outside views.
- Confirmation bias. Causes an analyst to seek out (or pay attention to) data that affirms their earlier convictions, and to disregard or underestimate information that calls those opinions into question. Analysts should also be aware of confirmation bias when evaluating company management's representations — managements tend to portray their companies in a positive way. Mitigation: keep abreast of research from analysts with opposite views; seek out the points of view of colleagues who have no emotional investment in the opinion.
The focus here is on how behavioral biases affect analysts. We will revisit these biases in the context of investors' behavior in the Portfolio Management topic area.
金融業從業人員與一般人一樣,會受到行為偏誤影響。對分析師而言,這些偏誤可能導致預測失準。
- 過度自信偏誤(Overconfidence bias):過於相信自己的工作,可能低估預測誤差,使信賴區間過於狹窄。「逆向預測者」(forecasting against the grain)更易受此偏誤影響。緩解方法:與他人分享預測並接受批評、評估自己過去的預測誤差以擴大信賴區間、使用情境分析。
- 控制錯覺偏誤(Illusion of control bias):與過度自信相關,但特指高估自己對事物的控制能力。表現為:(1)尋求「專家」意見以支撐預測、(2)讓模型過於複雜(加入更多自變量)。過度配適的模型在樣本外表現差,且可能掩蓋需更新的假設。緩解方法:只關注具有已知解釋力的變量;只向具相關觀點的外部人士尋求意見。
- 保守偏誤(Conservatism bias,又稱錨定 anchoring):在新資訊出現時,僅對先前的預測做微小調整。通常表現為對負面新資訊的接受意願不足,也可能延遲納入正面資訊。緩解方法:定期評估預測誤差;使用較簡單的模型以便調整。
- 代表性偏誤(Representativeness bias):依賴既有分類的傾向。新資訊可能只與既有分類表面相似,但從新角度看待會更佳。常見形式為基率忽視(base-rate neglect):忽略觀察值在大群體中的發生率,偏重情境或個體資訊。專注公司特有因素稱為內部觀點;視公司為產業成員(看基率)稱為外部觀點。緩解方法:兼顧內外部觀點。
- 確認偏誤(Confirmation bias):分析師傾向尋找支持既有觀點的資料,忽略相反證據。例如對某公司持正面看法的分析師,會選擇與看法相同的同事討論。也應警覺管理層自我美化的陳述。緩解方法:關注持相反觀點的分析師研究;徵詢無情感投入的同事意見。
教授提醒:此處討論的是行為偏誤對分析師的影響。在投資組合管理章節中,將從投資人角度再探討這些偏誤。
Explain how the competitive position of a company based on a Porter's five forces analysis affects prices and costs.
The competitive environment that a firm operates in and how successful it is in that environment are key in determining the firm's future financial results. There are no formulas for, or clear rules about, how a firm's competitive environment affects its future revenue and costs, but a firm's future competitive success is possibly the most important factor in its future revenue and profitability.
Porter's five forces are a framework analysts commonly use to evaluate a company's competitive position. (Described further in the Equity Investments reading on Industry and Competitive Analysis.)
- Threat of substitute products. Companies have more pricing power when the threat of substitutes is low and switching costs are high. They have less pricing power when good substitutes are or may become available, and when it is less costly for customers to switch.
- Intensity of industry rivalry. Companies have more pricing power when rivalry is low, and less pricing power when competitive intensity is high. Industry rivalry tends to be more intense when an industry has many competitors (less concentrated), when fixed costs and exit barriers are high, when industry growth is slow or negative, and when products are not differentiated significantly.
- Bargaining power of suppliers. Pressure on a company's costs may be higher, and its prospects for earnings growth lower, when supplier bargaining power is high. If suppliers are few, they may be able to extract a larger portion of any value added.
- Bargaining power of customers. Companies have less pricing power when customer bargaining power is higher, especially if a small number of customers are responsible for a large proportion of sales, or if switching costs are low.
- Threat of new entrants. Companies have more pricing power and better prospects for earnings growth when the threat of new entrants is low. Significant barriers to entry make it possible for existing companies to sustain economic profits over time.
公司所處的競爭環境及其成功程度,是決定未來財務表現的關鍵。雖無公式或明確規則描述競爭環境如何影響未來收入與成本,但公司未來的競爭優勢可能是其未來收入與獲利能力最重要的因素。
Porter 五力分析是分析師常用於評估公司競爭地位的架構(將在 Equity Investments 章節詳述):
- 替代品威脅:替代品威脅低且轉換成本高 → 公司有較強定價力;反之則弱。
- 產業競爭強度:強度低 → 定價力較強;強度高 → 定價力較弱。產業競爭加劇的條件:競爭者眾多(集中度低)、固定成本與退出障礙高、產業成長緩慢或負成長、產品差異化不足。
- 供應商議價能力:供應商議價力高 → 公司成本壓力大、獲利成長前景受限。供應商少時可能取得更大價值份額。
- 顧客議價能力:顧客議價力高 → 公司定價力較弱(尤其當少數客戶占大宗銷售或轉換成本低時)。
- 新進入者威脅:威脅低 → 定價力較強且獲利成長前景佳。進入障礙高使現有公司得以長期維持經濟利潤。
Explain how to forecast industry and company sales and costs when they are subject to price inflation or deflation.
Input costs can be significant in many industries. The cost of jet fuel in the airline industry, the cost of grains to cereal and baking companies, and the cost of coffee beans to coffee shops are all variable. Changes in these costs can significantly affect earnings.
Companies with commodity-type inputs can hedge their exposure to changes in input prices through derivatives, or more simply through fixed-price contracts for future delivery. Such hedging will reduce the effect of short-term changes in input prices and increase the time until longer-term price changes affect costs and earnings. Companies that are vertically integrated (in effect, their own suppliers) are relatively less exposed to input cost risk.
For a company that neither hedges input price exposure nor is vertically integrated, the issue for an analyst is to determine how rapidly, and to what extent, an increase in costs can be passed on to customers, as well as the expected effect of price increases on sales volume and sales revenue.
An analyst should monitor a company's production costs by product category and geographic location, with a focus on significant factors affecting input prices: weather, government regulation and taxation, tariffs, and the characteristics of input markets. A firm may reduce the impact of an input price increase by switching to a substitute input (e.g., rising oil prices may lead power generation firms to switch from oil to natural gas).
When estimating the effects of an increase in input prices, an analyst must make assumptions about the company's pricing strategy and the effects of price increases on unit sales. When increases in input costs are thought to be temporary, a company may cut other costs (e.g., advertising expenses) to preserve operating margins. This strategy is, however, not appropriate for long-term increases in input costs.
The effects of raising a product's price depend on its elasticity of demand. For most firms, product demand is relatively elastic. With elastic demand, the percentage reduction in unit sales is greater than the percentage increase in price, and a price increase will decrease total sales revenue.
Elasticity of demand is most affected by the availability of substitute products. In a competitive industry, the pricing decisions of other firms can affect market shares. A company that is first to increase prices in response to increased costs will experience a greater decrease in unit sales than a company that increases prices after other firms have already done so. A firm may decide to delay increasing prices to gain market share when other firms increase prices in response to increased costs. Firms that are too quick to increase prices will experience declining sales volumes; firms that are slow to increase prices will experience declining gross margins.
If the money amount of the increase in cost per unit is added to product price and unit sales do not decrease (this is unlikely), the amount of operating profit is unchanged, but gross margins, operating margins, and net margins will decrease.
原料成本在許多產業中佔重要地位(如航空業的燃油、穀物之於早餐穀片公司、咖啡豆之於咖啡店)。原料成本變動會顯著影響獲利。
具有大宗商品型投入的公司可透過衍生性商品避險,或以未來固定價格合約方式因應價格變動。避險可降低短期價格變動的影響,延緩長期價格變化對成本與獲利的衝擊。垂直整合(自有供應)的公司則面臨較低的原料價格風險。
對於既未避險也未垂直整合的公司,分析師關注:成本上漲能多快、多大幅度轉嫁給客戶?漲價對銷售量與營收的預期影響為何?
應依產品類別與地區監控公司生產成本,並關注影響原料價格的因素:天氣、政府法規與稅賦、關稅、原料市場特性。公司可透過替代投入降低原料漲價衝擊(如以天然氣替代石油)。
估計原料價格上漲影響時,需對公司定價策略及漲價對銷量的影響做出假設。若成本上漲被視為短期現象,公司可能削減其他成本(如廣告費)以維持營業利潤率,但此策略不適用於長期成本上漲。
漲價的效果取決於需求彈性。多數公司面對的需求相對彈性。彈性需求下,銷量下降百分比 > 漲價百分比,漲價將降低總營收。
需求彈性主要受替代品可得性影響。在競爭性產業中,其他公司的定價決策會影響市占率。率先漲價者銷量下降幅度大於跟隨漲價者。公司可能延後漲價以爭取市占率。漲價過快 → 銷量下降;漲價過慢 → 毛利率下降。
若每單位成本上漲全額轉嫁、銷量不變(極不可能),營業利潤金額不變,但毛利率、營業利潤率、淨利率均下降(因分母變大)。
Alfredo, Inc., sells a specialized network component. The firm's income statement for the past year follows.
| Revenues | 1,000 @ $100 | $100,000 |
| COGS | 1,000 @ $40 | $40,000 |
| Gross profit | $60,000 | |
| SG&A | $30,000 | |
| Operating profit | $30,000 |
For 20X2, the input costs (COGS) will increase by $5 per unit.
- Calculate the gross margin and operating margin for Alfredo, Inc., for 20X1.
- Calculate the 20X2 gross margin and operating margin assuming the following:
- The entire increase in input cost is passed on to the customers through an equal increase in selling price. The number of units sold is not affected.
- The selling price is increased by 5% and the number of units sold decreases by 5%.
- The selling price is increased by 5% and the number of units sold decreases by 10%.
1. 20X1 baseline:
gross margin = gross profit / sales = $60,000 / $100,000 = 60%
operating margin = operating profit / sales = $30,000 / $100,000 = 30%
2a. 20X2 — unit price +$5, units unchanged (1,000 units @ $105):
| Revenues | 1,000 units @ $105 | $105,000 |
| COGS | 1,000 units @ $45 | $45,000 |
| Gross profit | $60,000 | |
| SG&A | $30,000 | |
| Operating profit | $30,000 |
gross margin = $60,000 / $105,000 = 57%
operating margin = $30,000 / $105,000 = 29%
2b. 20X2 — price +5%, units −5% (950 units @ $105):
| Revenues | 950 units @ $105 | $99,750 |
| COGS | 950 units @ $45 | $42,750 |
| Gross profit | $57,000 | |
| SG&A | $30,000 | |
| Operating profit | $27,000 |
gross margin = $57,000 / $99,750 = 57%
operating margin = $27,000 / $99,750 = 27%
2c. 20X2 — price +5%, units −10% (900 units @ $105):
| Revenues | 900 units @ $105 | $94,500 |
| COGS | 900 units @ $45 | $40,500 |
| Gross profit | $54,000 | |
| SG&A | $30,000 | |
| Operating profit | $24,000 |
gross margin = $54,000 / $94,500 = 57%
operating margin = $24,000 / $94,500 = 25%
Key observation: When the price increase exactly offsets the cost increase per unit, gross profit (in $) stays the same in case 2a (no volume change), but gross margin falls because the denominator (sales) is larger. When unit sales fall, gross profit also falls. Operating margin falls more sharply because SG&A is fixed and now spreads over a smaller revenue base.
範例:通膨對毛利、毛利率與營業利潤率的影響
Alfredo 公司販售特殊網路元件。20X1 損益:營收 $100,000(1,000 單位 × $100)、COGS $40,000(1,000 × $40)、毛利 $60,000、SG&A $30,000、營業利潤 $30,000。20X2 每單位 COGS 上漲 $5。
- 20X1 基準:毛利率 = 60%、營業利潤率 = 30%。
- 20X2 三情境:
- 2a. 漲價全額轉嫁、銷量不變(1,000 × $105):營收 $105,000、COGS $45,000、毛利 $60,000、營業利潤 $30,000。毛利率 57%、營業利潤率 29%。
- 2b. 漲價 5%、銷量 −5%(950 × $105):營收 $99,750、COGS $42,750、毛利 $57,000、營業利潤 $27,000。毛利率 57%、營業利潤率 27%。
- 2c. 漲價 5%、銷量 −10%(900 × $105):營收 $94,500、COGS $40,500、毛利 $54,000、營業利潤 $24,000。毛利率 57%、營業利潤率 25%。
關鍵觀察:每單位漲價額正好抵銷每單位成本上漲時,2a 情境下毛利金額不變,但毛利率下降(分母變大);銷量下降時毛利金額隨之下降;營業利潤率下降幅度更大,因 SG&A 為固定費用,銷售基底縮小時其佔比上升。
Explain considerations in the choice of an explicit forecast horizon and an analyst's choices in developing projections beyond the short-term forecast horizon.
For a buy-side analyst, the appropriate forecast horizon may simply be the expected holding period for a stock. For example, a portfolio with a 25% annual turnover has an average holding period of four years, so four years may be the most appropriate forecast horizon.
Highly cyclical companies present difficulties when choosing a forecast horizon. The horizon should be long enough that the effects of the current phase of the economic cycle are not driving above-trend or below-trend earnings. The forecast horizon should be long enough to include the middle of a business cycle so that the analyst's forecast includes a midcycle level of sales and profits. Normalized earnings are expected midcycle earnings — alternatively, expected earnings when current (temporary) effects of events or cyclicality are no longer affecting earnings.
Events such as acquisitions, mergers, or restructurings should be considered temporary. The forecast horizon should be long enough that the perceived benefits of such events can be realized (or not). It may also be the case that the forecast horizon is dictated by an analyst's manager.
For earnings projections beyond the short term, one method is to assume that a trend growth rate of revenue over the previous cycle will continue. An analyst can estimate pro forma financial results based on the projection of each future period's revenue.
An analyst will typically value a stock using earnings or some measure of cash flow over a forecast period, along with the stock's terminal value at the end of the forecast horizon. This terminal value is usually estimated using either a relative valuation (price multiple) approach or a discounted cash flow approach.
We will describe these approaches to estimating stock values in our Equity Investments reading on Equity Valuation: Concepts and Basic Tools.
When using a multiples approach, an analyst must ensure that the multiple used is consistent with the estimate of the company's growth rate and required rate of return. Using the average P/E ratio for the company over the last 10 years, for example, presupposes that the growth in earnings and required rate of return of the stock will be, on average, the same in the future as it was over the previous 10 years.
When using a discounted cash flow approach to estimate the terminal value, two key inputs are a cash flow or earnings measure and an expected future growth rate. The expected earnings or cash flow should be normalized to a midcycle value that is not affected by temporary events. Because the terminal value is calculated as the present value of a perpetuity, small changes in the estimated (perpetual) growth rate of future earnings or cash flows can have large effects on estimated terminal values — and, hence, the current stock value.
Assuming that growth in future profitability will be the same as average profitability growth in the past may not be justified. A difficult part of an analyst's job is recognizing inflection points — those instances when the future will not be like the past. Examples of inflection points include changes in the economic environment or business cycle stage, government regulations, or technology.
買方分析師的合適預測期間,通常等於股票的預期持有期間。例如:投資組合年週轉率 25% → 平均持有期 4 年 → 4 年為最適預測期間。
強週期性公司的預測期間應夠長,使當前景氣階段不致主導預測(避免景氣高峰高估、谷底低估)。預測期間應涵蓋景氣循環中段,使預測包含中週期水準的銷售與利潤。正常化盈餘(normalized earnings)即為預期中週期盈餘,或剔除暫時性事件影響後的盈餘。
併購、合併、重整等事件應視為暫時性。預測期間應夠長以判斷其預期效益能否實現。預測期間有時亦由分析師主管指定。
短期之外的盈餘預測,常假設前一景氣循環的趨勢成長率持續。分析師可據各期營收預測編製擬制財務報表。
分析師通常以預測期間的盈餘或現金流,加上預測期末的終值(terminal value)來評價股票。終值估計採相對估值法(本益比倍數)或折現現金流法。
教授提醒:這些評價方法將在 Equity Investments 章節《Equity Valuation: Concepts and Basic Tools》詳述。
採倍數法時,所選倍數須與公司成長率及要求報酬率一致。例如使用過去 10 年平均 P/E 預設未來盈餘成長與要求報酬與過去 10 年平均相同。
採DCF 法估終值時,兩關鍵輸入:現金流/盈餘衡量值,與預期未來成長率。盈餘或現金流應正常化為中週期水準。由於終值為永續年金現值,永續成長率的微小變動可造成終值大幅變動,進而影響當前股價估計(敏感度高)。
假設未來獲利成長與過去歷史平均相同並非總是合理。分析師的難點之一是辨識轉折點(inflection points)——未來不同於過去的時刻。例子包括經濟環境或景氣循環階段改變、政府法規變化、技術變遷。
- A. confirmation bias.
- B. illusion of control bias.
- C. representativeness bias.
- A. Threat of new entrants.
- B. Intensity of industry rivalry.
- C. Bargaining power of suppliers.
- A. a full business cycle.
- B. the midpoint of a business cycle.
- C. the next change in phase of a business cycle.
Sales-based pro forma financial statement steps:
- Estimate revenue growth and future expected revenue.
- Estimate COGS.
- Estimate SG&A.
- Estimate financing costs.
- Estimate income tax expense and cash taxes (account for deferred tax items).
- Model the balance sheet from items flowing from the income statement and working capital estimates.
- Use historical depreciation and capital expenditures to estimate future capex and net PP&E.
- Use the completed pro forma IS and BS to construct a pro forma cash flow statement.
Five biases affecting analyst forecasts: (1) Overconfidence; (2) Illusion of control; (3) Conservatism / anchoring; (4) Representativeness (incl. base-rate neglect, inside vs. outside view); (5) Confirmation bias. Mitigations include sharing forecasts, reviewing past errors, scenario analysis, simpler models, considering both inside and outside views, and seeking opposing viewpoints.
Pricing power and earnings prospects depend on:
- Companies have less (more) pricing power when threat of substitutes is high (low) and switching costs are low (high).
- Companies have less (more) pricing power when intensity of industry rivalry is high (low).
- Pressure on input costs is higher when bargaining power of suppliers is high.
- Companies have less pricing power when bargaining power of customers is high.
- Companies have more pricing power when threat of new entrants is low.
Increases in input costs raise COGS unless hedged with derivatives or contracts for future delivery; vertically integrated companies are less affected. The effect on sales of raising prices to reflect higher COGS depends on elasticity of demand and on the timing and amount of competitors' price increases. Firms first to raise prices lose more volume; firms slow to raise prices lose gross margin.
For a buy-side analyst, the appropriate forecast horizon may be the expected holding period for a stock. For highly cyclical companies, the horizon should include the middle of a cycle so the analyst can forecast normalized earnings. Acquisitions, mergers, or restructurings are temporary; the horizon should be long enough that perceived benefits can be realized.
Earnings projections beyond the short term often use the historical average growth rate of revenue over the previous economic cycle. Analysts typically estimate a terminal value using a price multiple or DCF approach. Small changes in the estimated growth rate of future profits or cash flows can have large effects on the estimated stock value.