Fast Retailing – Editable DCF Valuation Model (Japan Listed Company Case Study)

Description
This best-practice Excel model provides a complete Discounted Cash Flow (DCF) valuation for Fast Retailing.

It is fully editable, allowing users to adjust assumptions, update financials.The model follows professional equity research standards and includes a clear input sheet, forecast logic, WACC assumptions, valuation outputs, sensitivity analysis, and automated summary results.


The model follows professional equity research standards and includes a clear input sheet, forecast logic, WACC assumptions, valuation outputs, sensitivity analysis, and automated summary results.
It is suitable for:
• Equity research analysts
• Business school and CFA candidates
• Anyone needing a clean, reusable valuation framework


All calculations are transparent and easy to follow, with formulas structured to support scenario testing and customized valuation assumptions.This downloadable model can serve as a case study, learning tool, or starting point for your own valuation work.

1. Input & Assumptions Sheet

• Revenue growth assumptions
• Operating margin assumptions
• Tax rate
• Working capital
• Capex & depreciation
• WACC (cost of equity, beta, risk-free rate, risk premium)
• Terminal value assumptions

2. Financial Forecast (5–10 years)

• Income statement forecast
• Free cash flow calculations
• Operating profit, NOPAT, reinvestment

3. DCF Valuation

• Present value of free cash flows
• Terminal value (Gordon growth method)
• Enterprise value & equity value
• Implied share price

4. Sensitivity Analysis

• WACC sensitivity table
• Terminal growth sensitivity table
• Two-way data table for implied share price

Disclaimer

This model is for educational purposes only

Not investment advice

Financial data is based on publicly available sources

Users should update inputs at their own discretion