Build financial projections, P&L statements, DCF models, and valuation analyses from assumptions and historical data
Build financial projections, P&L statements, DCF models, and valuation analyses from assumptions and historical data
npx skills add https://github.com/seb1n/awesome-ai-agent-skills --skill financial-modeling이 명령을 Claude Code에 복사하여 붙여넣어 스킬을 설치하세요
Identify at-risk customer accounts by analyzing usage patterns, engagement signals, and support history to generate churn risk scores and intervention recommendations.
Analyze NPS, CSAT, and qualitative customer feedback to extract themes, identify trends, and generate actionable insight reports.
Write clear, searchable help center articles and FAQ entries based on support data, product documentation, and common customer questions.
Design structured customer onboarding workflows with phased checklists, email templates, success milestones, and ownership assignments.
Classify, prioritize, and route incoming support tickets by extracting intent and entities, assigning severity, and generating initial responses.
Create and manage budgets with variance analysis and departmental allocation
| name | financial-modeling |
| description | Build financial projections, P&L statements, DCF models, and valuation analyses from assumptions and historical data |
| license | MIT |
| metadata | {"author":"community","version":"1.0"} |
Build structured financial projections including income statements, discounted cash flow (DCF) models, and valuation analyses. This skill takes a set of business assumptions and transforms them into multi-period financial forecasts with key metrics like NPV, IRR, EBITDA margins, and revenue growth rates. Suitable for startup fundraising, acquisition analysis, budgeting, and strategic planning.
Define Core Assumptions Gather all foundational inputs: revenue growth rates, pricing tiers, customer acquisition rates, churn, cost structures, tax rates, discount rates, and terminal growth rates. Validate that assumptions are internally consistent — for example, headcount growth should align with projected revenue capacity. Document each assumption with its source or rationale.
Build the Revenue Model Construct a bottoms-up or top-down revenue forecast depending on available data. For subscription businesses, model MRR by cohort with expansion and churn. For transactional businesses, model volume × average transaction value. Break revenue into segments if the business has multiple product lines or geographies.
Project Operating Expenses Forecast COGS, gross margin, and operating expenses by category: personnel, marketing, R&D, G&A, and infrastructure. Use a mix of fixed and variable cost assumptions. Tie headcount plans to compensation benchmarks. Model economies of scale where applicable — hosting costs per user should decline as volume grows.
Calculate Free Cash Flows Derive EBITDA from the projected P&L, then adjust for capital expenditures, changes in working capital, and taxes to arrive at unlevered free cash flow (UFCF) for each period. Clearly separate operating cash flow from investing and financing activities.
Compute Valuation Metrics Discount projected cash flows using WACC to compute enterprise value via DCF. Calculate terminal value using either a perpetuity growth model or an exit multiple approach. Derive NPV, IRR, and payback period. Run sensitivity tables across discount rate and growth rate ranges.
Stress Test and Summarize Run bear/base/bull scenarios by varying 2-3 key assumptions. Present results in a summary table showing the range of outcomes. Highlight which assumptions have the most impact on valuation.
Provide your business assumptions, historical financials (if available), and the type of model you need. Specify the projection period and any specific metrics you want calculated.
Example prompt:
Build a 3-year monthly P&L projection for a B2B SaaS startup. Starting MRR is $45K, growing 8% month-over-month for year 1, decelerating to 5% in year 2 and 3% in year 3. Gross margin is 78%. Opex starts at $60K/month and grows 4% monthly. Show EBITDA and cash position.
Input: B2B SaaS, $45K starting MRR, 8%/5%/3% MoM growth by year, 78% gross margin, $60K starting opex growing 4% monthly.
Output (Year-End Summary):
| Metric | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Annual Revenue | $1,012,680 | $2,048,352 | $3,195,744 |
| COGS (22%) | $222,790 | $450,637 | $703,064 |
| Gross Profit | $789,890 | $1,597,715 | $2,492,680 |
| Operating Expenses | $959,328 | $1,530,878 | $2,443,002 |
| EBITDA | ($169,438) | $66,837 | $49,678 |
| EBITDA Margin | -16.7% | 3.3% | 1.6% |
| Cumulative Cash Burn | ($169,438) | ($102,601) | ($52,923) |
The company reaches monthly EBITDA breakeven in month 18. Cumulative cash burn peaks at $169K, suggesting a modest seed round is sufficient. Opex growth outpacing revenue deceleration in year 3 compresses margins — consider flattening hiring in year 3.
Input: Target business generates $500K annual UFCF, growing 6% per year for 5 years. WACC is 12%. Terminal growth rate 2.5%. Acquisition price $2.1M.
Output:
| Year | UFCF | Discount Factor | PV of UFCF |
|---|---|---|---|
| 1 | $530,000 | 0.893 | $473,214 |
| 2 | $561,800 | 0.797 | $447,771 |
| 3 | $595,508 | 0.712 | $423,801 |
| 4 | $631,238 | 0.636 | $401,227 |
| 5 | $669,113 | 0.567 | $379,482 |
The acquisition is strongly accretive at the asking price. Sensitivity: if WACC rises to 15%, enterprise value drops to $4.8M — still a clear buy.
