Financial analysis from single-stock metrics to DCF models and portfolio optimization, delivered as dashboards, PDFs, or Excel.
Data & analysis
Financial Analysis
Try itInvestment-grade financial modeling — DCF valuation, comparable-company analysis, 3-statement models, returns (IRR/MOIC/cap-rate), and investor data-room pac...
What it does
Investment-grade financial modeling — DCF valuation, comparable-company analysis, 3-statement models, returns (IRR/MOIC/cap-rate), and investor data-room packs. Use for capital raises, valuations, and any returns or valuation question. Work only from provided, public, or project-level figures.
The skill document
Financial Analysis
Institutional-grade analysis for raises, valuations, and investor materials. Work only from figures that are provided, public, or project-level — never assume confidential numbers; ask for them or state them as inputs.
Capabilities
1. DCF Valuation
- Project unlevered free cash flow (revenue → EBITDA → FCF) over 5–7 years from stated assumptions.
- Discount at WACC — show the build (cost of equity via CAPM + after-tax cost of debt, weighted).
- Terminal value via Gordon growth and exit-multiple; cross-check both.
- Output: enterprise value, equity value, and a sensitivity table (WACC × growth/exit-multiple).
2. Comparable Company / Transaction Analysis
- Identify 5–8 true comparables (sector, stage, geography).
- Multiples: EV/Revenue, EV/EBITDA; for property/hospitality use cap-rate/yield and EV/key.
- Apply to target; show implied valuation range and where the target sits (premium/discount + why).
3. 3-Statement Model
- Linked IS → BS → CF. Verify the BS balances and cash ties out. Drivers explicit and editable; no hardcoded plugs.
4. Returns Analysis (investor-facing)
- IRR, MOIC, cash-on-cash, payback — by scenario (base / bull / bear).
- Property/hospitality: stabilised NOI, cap rate, DSCR, exit value, equity multiple.
5. Investor Data-Room Pack
- Assemble: one-pager, model summary, returns table, risk register, use-of-funds, structure/terms.
- Match the live deal terms exactly as provided.
Output Rules
- State every assumption; flag provided vs. estimated.
- Always give a range + sensitivity — never single false-precision numbers.
- Sanity-check against comparables and reality; flag anything that looks off.
- Show the working so the numbers can be audited.
Related skills
Financial Modeling Prep (financialmodelingprep.com). Use this skill for ANY Financial Modeling Prep request — searching and reading data. Whenever a task inv...
Turn financial model outputs into a clear written narrative. Use when asked to write a financial narrative, explain a financial model, summarise a P&L, or tr...
AI-powered stock analysis using AlphaGBM's Five Pillars framework (Fundamental, Technical, Sentiment, Flow, Valuation) with real market data. Returns a 1-10...
Point-in-time Buffett-style company analysis for stocks, Berkshire case studies, and BUY/PASS verdicts. Use when the user wants a Buffett/Graham underwriting...
This skill should be used when a user asks to analyze a US-listed technology giant such as Apple, Microsoft, Nvidia, Amazon, Alphabet, Meta, or Tesla. It produces a deep, data-rich, and visually structured investment-and-competitive analysis with charts and valuation tables, covering business model,