DCF Model Assumption Reviewer

يستخدم المحللون الاستثماريون ومستشارو الاندماج والاستحواذ والمديرون الماليون هذا الموجه لاختبار متانة افتراضات نموذج DCF قبل تقديم التقييم لمجلس الإدارة أو لجنة الاستثمار أو المستحوذ المحتمل.

You are a senior investment analyst specializing in discounted cash flow valuation for [INDUSTRY] companies. I will provide you with the key assumptions embedded in our DCF model for [COMPANY NAME] covering the [FISCAL YEAR] forecast period. The model uses [CURRENCY] as the reporting currency.

Here are the assumptions under review:

- Revenue growth rates by year: [REVENUE GROWTH RATES]
- EBITDA margin progression: [EBITDA MARGINS]
- Weighted Average Cost of Capital (WACC): [WACC %]
- Terminal growth rate: [TERMINAL GROWTH RATE %]
- Capital expenditure as % of revenue: [CAPEX %]
- Tax rate: [TAX RATE %]
- Net working capital changes: [NWC ASSUMPTIONS]

For each assumption, perform the following analysis:

1. **Benchmark Comparison**
   Compare each assumption against publicly available industry benchmarks, historical averages for comparable companies in [INDUSTRY], and consensus analyst estimates where applicable. Classify each as: Aggressive / Reasonable / Conservative.

2. **Internal Consistency Check**
   Assess whether the assumptions are mutually consistent — e.g., high revenue growth paired with margin expansion requires investment, which should be reflected in CAPEX and working capital assumptions.

3. **Key Sensitivity Flags**
   Identify the top three assumptions that have the greatest leverage on terminal value and equity value. Explain why small changes in these inputs drive outsized valuation swings.

4. **WACC Reasonableness**
   Decompose the WACC into its equity and debt components. Evaluate whether the cost of equity (via CAPM or other method) and the capital structure reflect current market conditions for a [INDUSTRY] company of [COMPANY NAME]'s size and credit profile.

5. **Terminal Value Risk**
   Assess the terminal growth rate relative to long-run GDP growth and [INDUSTRY] secular trends. Flag if terminal value represents more than 75% of total enterprise value, as this signals excessive dependence on long-term assumptions.

6. **Recommendations**
   Provide a prioritized list of assumption adjustments with rationale, and suggest a realistic bull / base / bear case range for the two most sensitive inputs.

Present your output in a structured table followed by a written summary and risk-ranked recommendation list.

متغيرات الأمر

استبدل كل عنصر نائب بمعلوماتك الخاصة:

ما ستحصل عليه

جدول منظم يُصنف كل افتراض بوصفه عدوانيًا أو معقولًا أو محافظًا مع مراجع المعايير المرجعية؛ وتقييم الاتساق الداخلي؛ وقائمة مرتبة بمحركات الحساسية الرئيسية؛ ومراجعة تفكيك WACC؛ وتحذير مخاطر القيمة النهائية؛ وقائمة توصيات مع نطاقات السيناريوهات.

💡 نصيحة خبير

أضف مصدر كل افتراض (مثل 'توجيهات الإدارة' أو 'توافق المحللين' أو 'المتوسط التاريخي') — سيُركز الذكاء الاصطناعي نقده على الافتراضات الأقل دعمًا بالبيانات.

أدوات الذكاء الاصطناعي المتوافقة

أوامر ذات صلة

موارد ذات صلة