Claude Prompt for Financial Modeling
Build a 5-year financial forecast for a entertainment startup focused on board reporting.
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.
Acting as a world-class venture capital analyst consultant, you provide strategic guidance to entrepreneurs in the startup finance space. Build a comprehensive 5-year financial forecast for a entertainment startup. **Stage:** Early-stage (pre-revenue to early revenue) **Purpose:** board reporting and investor presentation **Target audience:** freelancers ## Revenue Model - Define revenue streams for a entertainment startup - Pricing model assumptions and rationale - Customer acquisition funnel metrics (CAC, conversion rates) - Monthly recurring revenue (MRR) / annual recurring revenue (ARR) projections - Churn assumptions and net revenue retention modeling ## Cost Structure ### Fixed Costs (Monthly) - Founders/team salaries - Office/infrastructure - Software and tools - Insurance and legal - Other recurring costs ### Variable Costs - Cost of goods sold / cost of revenue - Customer acquisition cost breakdown - Payment processing fees - Hosting/infrastructure scaling costs ### Hiring Plan - Month-by-month headcount additions - Department breakdown (engineering, sales, marketing, ops) - Fully loaded cost per employee - Contractor vs. full-time decision framework ## Financial Statements ### Income Statement (Monthly for Year 1, Quarterly for Years 2-5-year) - Revenue, COGS, Gross Profit - Operating Expenses by department - EBITDA and Net Income ### Cash Flow Statement - Operating cash flow - Investing cash flow (CapEx, equipment) - Financing cash flow (equity raises, debt) - Monthly cash balance and burn rate ### Balance Sheet - Key asset and liability line items - Equity and retained earnings ## Key Metrics Dashboard - Monthly burn rate and runway - Unit economics (LTV, CAC, LTV:CAC ratio) - EBITDA trend over the forecast period - Break-even analysis (month and revenue level) ## Fundraising Scenarios - Scenario A: Bootstrap (no external funding) - Scenario B: Seed round ($500K-$2M) - Scenario C: Series A ($3M-$10M) - Impact on growth trajectory and dilution ## Presentation-Ready Outputs - Executive summary for investor deck - Key charts: revenue hockey stick, burn rate, margins - Comparable company benchmarks for entertainment - Summary table for board/investor updates Organize your output using a clear framework with labeled sections. Each section should build on the previous one.