FIN 460 Week 4 Forecasting Financial Performance Example

Five Years Ahead for Trailhead Outfitters: Revenue Drivers, a Margin Path, Inventory Days, Capital Spending and the Free Cash Flow They Produce, With a Check Against What Forecasts Usually Get Wrong

[Student Name]

University of Phoenix

FIN/460: Fundamental Analysis

Week 4 Assignment

[Instructor Name]

[Date]

Trailhead Outfitters, its forecast and all figures are composites written for a model paper; forecasting methods and research findings come from the sources listed.

The previous weeks found that Trailhead Outfitters earns modest margins in a competitive, moderately cyclical industry, carries too much inventory and is installing a new allocation system to fix it. The next step is a forecast. A forecast is a chain of judgments, and each link should be visible so a reader can test it. This paper builds a five-year forecast from explicit drivers.

Revenue Drivers

Penman (2013) recommends forecasting from the business's operating drivers rather than from reported totals. Revenue of $2.4 billion comes from three sources. New stores: management plans six to eight openings a year, adding about 1.5 percent to revenue annually after closures. Comparable store sales: Week 3 suggested modest growth tied to real disposable income and sentiment, so the forecast assumes 0.5 percent in year one, rising to 1.5 percent. Online: online sales, 24 percent of revenue, have grown about 8 percent a year recently; the forecast assumes 6 percent slowing to 4 percent. Combined, revenue grows about 3 percent in year one, 4 to 4.5 percent in years two and three and 3.5 to 4 percent after, reaching about $2.89 billion in year five.

Gross Margin

Gross margin fell to 41.0 percent from 41.8 percent as markdowns increased. The forecast assumes a further dip to 40.5 percent in year one, as aged inventory is cleared, then recovery to 41.0 percent and 41.2 percent by year four, still below the pre-glut level. Supplier power and competitive promotions, identified in Week 3, limit the recovery.

Operating Expenses

Selling, general and administrative expenses were 31 percent of revenue. Store wages and rent grow with stores, but marketing and headquarters costs grow more slowly, so the ratio eases to 30.5 percent by year four. Depreciation rises from $75 million to $87 million with the store program.

Operating Income and Earnings

Operating income falls to about $160 million in year one, then rises to about $184 million in year two, $198 million in year three, $215 million in year four and $222 million in year five, a margin path from 6.5 percent to 7.7 percent. With interest steady at $18 million, a 25 percent tax rate and 50 million shares, earnings per share go from $2.13 in year one to about $3.07 in year five.

Inventory and Working Capital

Inventory is projected from target days. Days of inventory fall from 139 to 135 in year one, 130 in year two, 125 in year three and 120 by year five, as the allocation system takes effect. Because cost of goods sold grows, the inventory balance stays roughly flat at $540 to $560 million, releasing working capital compared with keeping days constant. Payables are held at 67 days of cost.

Capital Spending

Capital spending of $100 million in years one and two, rising to $108 million by year five, covers new stores at about $4 million each, remodels of older stores and about $15 million for the allocation system over two years. It runs slightly above depreciation, consistent with a growing store base.

Free Cash Flow

Unlevered free cash flow equals operating income after tax, plus depreciation, minus capital spending, minus the increase in working capital. In year one, about $120 million of after-tax operating income, plus $75 million of depreciation, minus $100 million of capital spending, plus a $6 million release of working capital, gives about $101 million. Free cash flow then rises to about $128 million in year two, $135 million in year three, $145 million in year four and $147 million in year five.

Testing for Optimism

Fama and French (2000) found that profitability reverts toward the mean: firms with unusually high or low returns tend to move back toward average within a few years. Trailhead's forecast margin recovers toward, but not to, the peer median, consistent with that pattern. Chan et al. (2003) found little persistence in growth rates beyond what chance would produce, which argues against assuming that recent online growth continues. The forecast slows online growth for that reason.

Consistency Checks

A forecast must hold together across statements. The analyst confirmed that depreciation grows with the asset base implied by capital spending, that inventory and payables follow cost of goods sold at the stated days, that the tax rate matches recent effective rates and that cash flow from the forecast reconciles to the change in net debt after dividends and buybacks. The forecast keeps dividends at $0.80 a share and buybacks at $20 million a year, which leaves cash rising slowly. A forecast in which cash piled up without explanation, or in which inventory fell while sales rose sharply, would signal an error in the model.

Scenarios

In a weak case, a mild recession cuts comparable sales by 4 percent in year two and gross margin stays at 40.5 percent; operating income falls to about $120 million, and free cash flow to about $80 million. In a strong case, the allocation system brings days of inventory to 110 and gross margin to 41.8 percent by year three; operating income reaches about $240 million by year five. The base case sits closer to the weak case than the strong one, reflecting the industry's competitive pressures.

The Key Assumptions

Three assumptions drive most of the result: comparable store sales growth, the pace of gross margin recovery and the improvement in inventory days. Each half point of gross margin is worth about $13 to $14 million of operating income, and each 10 days of inventory about $40 million of cash.

Conclusion

Built from store, comparable sales and online drivers, Trailhead's forecast shows revenue near $2.9 billion and operating income near $222 million in five years, with free cash flow rising from about $100 million to about $147 million as inventory falls relative to sales. Research on mean reversion supports a modest margin recovery, and scenarios bracket the uncertainty for the valuation in Week 5.

References

Chan, L. K. C., Karceski, J., & Lakonishok, J. (2003). The level and persistence of growth rates. The Journal of Finance, 58(2), 643-684. https://doi.org/10.1111/1540-6261.00540

Fama, E. F., & French, K. R. (2000). Forecasting profitability and earnings. The Journal of Business, 73(2), 161-175. https://doi.org/10.1086/209638

Penman, S. H. (2013). Financial statement analysis and security valuation (5th ed.). McGraw-Hill Education.