financial-modeling

Build DCF, comparable company, and LBO financial models with sensitivity testing.

Updated Aug 13, 2025
One-click install
npx skills add https://github.com/JoeyJoziah/investment-analysis-platform --skill financial-modeling-joeyjoziah
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: financial-modeling
Source: https://github.com/JoeyJoziah/investment-analysis-platform/tree/main/.claude/skills/financial-modeling
Command: npx skills add https://github.com/JoeyJoziah/investment-analysis-platform --skill financial-modeling-joeyjoziah

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you build, evaluate, and communicate investment valuations and financial models without getting lost in formula sprawl, inconsistent assumptions, or manual scenario math.

Core Features & Use Cases

  • Valuation Methods: Apply discounted cash flow, comparable company analysis, and precedent transaction frameworks to estimate intrinsic value and market-relative value.
  • Cash Flow Modeling: Forecast unlevered and levered cash flows, working capital, debt paydown, and capital expenditure needs for investment cases.
  • Scenario and Sensitivity Analysis: Compare base, upside, and downside cases, then test how key drivers such as growth, margins, and discount rates change outcomes.
  • Use Case: If you are evaluating a public company or building an investment memo, this Skill helps you assemble assumptions, calculate returns, and present a defensible valuation range.

Quick Start

Ask the financial modeling skill to build or review a DCF, comparable company analysis, or scenario model for your target company.

Frequently Asked Questions about financial-modeling

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a DCF model without losing track of assumptions?

DCF modeling requires disciplined assumption tracking and calculation integrity. Forecast unlevered cash flows, working capital, and capital expenditures, then apply a discount rate to estimate intrinsic value across base, upside, and downside cases.

What's the best way to run scenario analysis for investment valuation?

Scenario analysis for investment valuation compares base, upside, and downside cases to test how key drivers like growth, margins, and discount rates change outcomes. This sensitivity testing produces a defensible valuation range.

How do I structure an LBO model for debt paydown and cash flow forecasting?

LBO modeling structures debt paydown by forecasting levered cash flows and working capital. It requires calculation integrity to track debt schedules and capital expenditure needs, producing investment-ready outputs.

Can I use comparable company analysis for market-relative valuation?

Comparable company analysis estimates market-relative value by comparing target financial metrics against similar public companies. It pairs with precedent transaction analysis to frame intrinsic value within market realities.

Why does my financial model produce inconsistent valuation ranges?

Inconsistent valuation ranges often stem from manual scenario math and formula sprawl. Applying structured sensitivity testing to key drivers like growth and margins ensures calculation integrity and a defensible valuation output.

Do I need precedent transaction analysis alongside discounted cash flow?

Precedent transaction analysis complements discounted cash flow by benchmarking target value against historical deal premiums. Together they provide both intrinsic and market-relative valuation perspectives for investment memos.