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

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.

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

Generate and edit Draw.io, Mermaid, and Excalidraw diagrams from natural language using a structured JSON spec.

by nssa.io1.0k installs47 stars

Stores durable facts in a categorized, plain-markdown vault on disk, alongside your agent's built-in memory.

by Iván559 installs18 stars

Join a video meeting as an AI bot with voice, avatar, and screenshare across four operating modes.

by johnpatternai22 installs8 stars

Find why your productivity system keeps failing, then apply the smallest fix — capacity math, bottleneck routing, durable local notes.

by Iván855 installs69 stars

Fetch raw ad creative, app, ranking, and revenue data from AdMapix as structured JSON.

by fly0pants4.3k installs296 stars

More from serkaion

Browse all skills

Ready-to-use, KPI-driven prompt templates for market research, due diligence, competitive analysis, investor pitches, and business strategy. Use when you nee...

by serkaion3 installs

Investment, partnership, and acquisition due diligence framework. Use for deep dives on companies, people, deals, and properties. Produces a structured risk...

by serkaion5 installs

Competitive landscape analysis, market sizing, and positioning research. Use for "who are the competitors", TAM/SAM/SOM sizing, go-to-market input, or positi...

by serkaion3 installs

Rigorous multi-source, fact-checked research producing a cited brief. Use for any high-stakes question where being wrong is costly — market sizing, company/p...

by serkaion5 installs

Executive-level research briefing and intelligence compilation. Use when you need a tight, decision-ready brief on a person, company, market, investment, or...

by serkaion3 installs