Data & analysis

Financial Analysis

Try it

Investment-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 analysis from single-stock metrics to DCF models and portfolio optimization, delivered as dashboards, PDFs, or Excel.

134 installs5 stars

Financial Modeling Prep (financialmodelingprep.com). Use this skill for ANY Financial Modeling Prep request — searching and reading data. Whenever a task inv...

7 installs

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...

21 installs

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,