Claude Prompt for Financial Modeling
Value a healthcare company using three-statement model with earnings yield as the key driver.
More prompts for Financial Modeling.
Build a comprehensive 3-year financial model for a startup including revenue projections, expense forecasts, and key metrics.
Build a ROI calculator for a HR-tech law firm with step-by-step instructions.
Build a cap table model for a pharmaceuticals law firm with step-by-step instructions.
Build a 3-year financial forecast for a pet-care startup focused on strategic planning.
Build a PEG ratio calculator with formulas and benchmarks for real estate agents in food-delivery.
Build a revenue forecast model for a HR-tech law firm with step-by-step instructions.
You are a senior investment banker analyst. Your job is to provide data-driven insights and actionable recommendations for business valuation. Perform a valuation of a healthcare company using three-statement model with earnings yield as the key driver. **Analysis context:** CEOs and executives evaluating an investment opportunity **Market conditions:** stagflation ## Company Profile Template - Industry: healthcare - Business model description framework - Key revenue streams and cost drivers - Competitive position assessment ## Valuation Methodology ### three-statement model Approach - Why three-statement model is appropriate for healthcare companies - Key assumptions and their sensitivity - Step-by-step calculation methodology - Industry-specific adjustments to standard three-statement model ### earnings yield-Based Analysis - Calculate and interpret earnings yield for the target company - Compare to industry median and top quartile - Trend analysis over 5 years - Quality of earnings yield assessment ## Detailed Calculations Show all work with: - Revenue build-up (top-down and bottom-up approaches) - Cost structure modeling - Working capital forecasts - Capital expenditure estimates - Terminal value calculation (if applicable) - Discount rate derivation ## Valuation Output - Point estimate with key assumptions - Valuation range (25th to 75th percentile) - Football field chart data (multiple methods summary) - Per-share value (if applicable) ## Cross-Check Methods - Compare three-statement model result against: 1. Trading multiples (EV/EBITDA, P/E, P/S) 2. Precedent transactions 3. Sum-of-the-parts analysis - Reconcile differences between methods ## Investment Recommendation Framework - Buy/hold/sell criteria based on valuation range - Margin of safety calculation - Key risks that could change the valuation - Catalysts that could drive value realization Structure as a professional report with: Executive Summary, Key Findings, Detailed Analysis, Recommendations, and Next Steps.