creating-financial-models

Construct financial models for investment analysis with DCF, M&A, and sensitivity analysis.

18|3|Updated Jan 20, 2026
One-click install
npx skills add https://github.com/mohitjandwani/analyst-kit --skill creating-financial-models-mohitjandwani
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: creating-financial-models
Source: https://github.com/mohitjandwani/analyst-kit/tree/main/plugins/analyst-kit/skills/creating-financial-models
Command: npx skills add https://github.com/mohitjandwani/analyst-kit --skill creating-financial-models-mohitjandwani

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires numpy, pandas, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides the ability to construct detailed financial models for investment analysis, including DCF valuations, M&A accretion/dilution, and sensitivity analysis.

Core Features & Use Cases

  • DCF Valuation: Perform full DCF valuations using free cash flow projections, WACC calculations, and terminal value determination.
  • M&A Analysis: Create merger models to analyze accretion/dilution for acquisition deals, considering financing, synergies, and PPA amortization.
  • Sensitivity Analysis: Conduct one-way, two-way, and tornado analysis to assess the impact of changes in key variables on model outputs.
  • Use Case: Use this Skill to evaluate the potential acquisition of a company by modeling its DCF value, analyzing the accretion/dilution impact of the deal, and performing sensitivity analysis on critical parameters.

Quick Start

Build a DCF model for the company XYZ with the provided financial data and assumptions.

Frequently Asked Questions about creating-financial-models

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

FAQPage Schema
How do I build a DCF valuation model using Python for investment analysis?

DCF valuation models require projecting future free cash flows, calculating the WACC, and determining the terminal value. You can construct these models using Python libraries like numpy and pandas to handle the complex financial calculations.

What is the best way to perform M&A accretion and dilution analysis in Python?

M&A accretion and dilution analysis involves creating merger models that account for financing structures, synergy analysis, and purchase price allocation amortization. Using pandas allows you to structure the deal assumptions and calculate the pro-forma financial impact efficiently.

How does sensitivity analysis work in corporate finance models?

Sensitivity analysis in corporate finance assesses how changes in key variables impact model outputs. You can perform one-way, two-way, and tornado analysis to evaluate the effects of fluctuating parameters like WACC and terminal growth rates on your valuation.

Can I use numpy and pandas to calculate WACC and terminal growth rates for financial modeling?

Yes, numpy and pandas are required dependencies for constructing these financial models. They provide the computational framework to calculate complex corporate finance metrics including WACC, terminal growth rates, and synergy analysis for M&A transactions.

When do I need to include synergy analysis in my M&A merger models?

Synergy analysis is needed when evaluating M&A transactions to determine the combined value of the acquisition. It is incorporated into the merger model alongside financing assumptions and PPA amortization to accurately project the accretion or dilution impact of the deal.