Write prompt with Claude, Codex and Chat GPT – financial Modelling#finance #jobs #shortsfeed #viral

LBO Model

Act as a Senior Private Equity Analyst and Investment Banker.

Build a complete Leveraged Buyout (LBO) Financial Model for the following company:

[Insert Company Name]

Requirements:
1. Build a 5-year LBO model.
2. Include:
– Revenue projections
– EBITDA projections
– Margin assumptions
– Capex
– Working capital adjustments
– Debt schedule
– Interest calculations
– Mandatory & optional debt repayments
– Cash flow sweep
– Sources & Uses table
– Purchase price allocation
– Exit multiple assumptions
– IRR and MOIC calculations
3. Include Base, Upside, and Downside scenarios.
4. Provide sensitivity tables for:
– Exit EBITDA multiple
– Revenue growth
– Debt levels
5. Explain each formula step-by-step in simple words.
6. Highlight key PE investment risks.
7. Suggest optimal capital structure.
8. Output should be investor-grade and suitable for Investment Committee presentation.
9. Create charts and visual dashboards.
10. Use realistic assumptions based on industry standards.

Format:
– Professional investment banking style
– Excel-ready structure
– Clearly separated assumptions and outputs tabs

IPO Model

Act as a Senior Equity Capital Markets (ECM) Investment Banker.

Build a complete IPO Financial Model for:

[Insert Company Name]

Requirements:
1. Analyze:
– Historical financial statements (3 years)
– Revenue growth
– EBITDA margins
– Net income trends
– Free cash flow
2. Perform:
– Comparable Company Analysis (Trading Comps)
– Precedent Transactions
– DCF Valuation
3. Estimate:
– IPO valuation range
– Market capitalization
– Enterprise value
– Share price range
– Dilution impact
4. Include:
– Use of proceeds analysis
– Shareholding structure before & after IPO
– Lock-up assumptions
– Investor demand scenarios
5. Create:
– Bull, Base, Bear case scenarios
– Sensitivity analysis
– IPO pricing recommendations
6. Explain valuation methodology clearly.
7. Create institutional-grade charts and dashboards.
8. Present insights like a Goldman Sachs or Morgan Stanley IPO pitchbook.

Output:
– Investment banking format
– Excel-ready model structure
– Easy-to-understand explanations

Startup Valuations

Act as a Venture Capital Analyst and Startup Financial Modeling Expert.

Build a complete Startup Valuation Financial Model for:

[Insert Startup Name]

Industry:
[Insert Industry]

Requirements:
1. Forecast:
– Revenue growth
– User growth
– CAC (Customer Acquisition Cost)
– LTV (Lifetime Value)
– Burn rate
– Runway
– EBITDA
– Cash flow projections
2. Perform:
– Venture Capital valuation method
– Scorecard valuation method
– Comparable startup analysis
– DCF valuation (if applicable)
3. Include:
– Seed, Series A, Series B dilution analysis
– Cap table modeling
– Founder dilution
– ESOP pool calculations
4. Build:
– Base, Aggressive, Conservative scenarios
– Fundraising requirement analysis
– Break-even analysis
5. Calculate:
– IRR expectations for investors
– Exit valuation assumptions
– Unicorn potential analysis
6. Create:
– Investor dashboards
– Growth charts
– KPI tracking visuals
7. Explain assumptions in simple language.

Output:
– VC-grade financial model
– Investor pitch ready
– Excel-ready structure
– Modern startup finance format

source