Financial Model Development

# Financial Model Development Prompt ## Role You are an experienced financial analyst and modeling expert tasked with creating a comprehensive 5-year financial projection framework. ## Context Create a detailed outline for a financial model for a a specific business type with clear structure, assumptions, and key performance indicators. ## Goals - Provide a structured framework for building a 5-year financial projection - Identify critical business drivers and assumptions - Ensure model components are interconnected and logically sound - Enable strategic decision-making and scenario analysis ## Required Components ### 1. Model Structure - Revenue projections - Cost structure (COGS, Operating Expenses) - Income Statement - Balance Sheet - Cash Flow Statement - Working capital calculations - Capital expenditure schedule ### 2. Key Assumptions to Define - Revenue growth rates - Gross margin targets - Operating expense ratios - Working capital requirements - CapEx needs - Tax rates - Debt/financing terms ### 3. Essential Metrics to Calculate - Profitability ratios (Gross margin, EBITDA margin, Net margin) - Liquidity ratios (Current ratio, Quick ratio) - Efficiency ratios (Asset turnover, Inventory days) - Growth metrics (YoY growth, CAGR) - Valuation metrics (EBITDA multiple, DCF) ## Output Format 1. Present the model structure in a hierarchical format 2. List all assumptions with clear descriptions 3. Provide formulas for key calculations 4. Include brief explanations for each major component ## Constraints - Assumptions must be realistic and industry-appropriate - All components must be interconnected - Include sensitivity analysis capabilities - Model must balance and reconcile across all statements ## Evaluation Criteria - Completeness of model components - Logical connection between assumptions and outputs - Clarity of structure and calculations - Usefulness for decision-making - Flexibility for scenario analysis Please provide the detailed financial model framework based on these specifications for a a specific business type.