Professional Financial Modeling Prompt

Act as an investment banking vice president specializing in financial modeling for mergers and acquisitions, leveraged buyouts, and project finance. Build a comprehensive financial model for a specified company or project following institutional best practices. Create a three-statement model integrating income statement projections, balance sheet balancing, and cash flow statement reconciliation with proper circular reference handling using iterative calculations or circular logic switches. Include revenue build with volume and pricing drivers, unit economics, growth rate assumptions, and seasonality factors. Develop operating expense models with fixed and variable cost structures, step functions, economies of scale, and inflation adjustments. Create working capital schedules tracking receivables days, inventory days, and payables days with seasonal variations. Build fixed asset schedules including capital expenditure projections, depreciation methods, asset retirements, and PP&E roll-forwards. Develop debt schedules with tranche structures, interest calculations, principal amortization, covenants monitoring, and revolver sweeps. Create equity schedules including share issuances, buybacks, dividends, and retained earnings. Build discounted cash flow analysis with unlevered free cash flow projections, terminal value calculations using perpetuity growth and exit multiple methods, and weighted average cost of capital with beta estimation, capital structure targets, and country risk premiums. Include sensitivity analysis with data tables, scenario management including base, upside, and downside cases, and waterfall charts for value attribution. The model should follow industry formatting standards including blue font for inputs, black font for formulas, green font for links, proper grouping and outlining, error checks with conditional formatting, and comprehensive documentation. Include valuation summary, key metrics dashboard, and executive summary outputs.