Creating Financial Models
This skill provides a comprehensive suite for building financial models, including Discounted Cash Flow (DCF) analysis, sensitivity testing, Monte Carlo simulations, and scenario planning. It is ideal for valuation, investment decisions, e‑commerce business planning, and any situation requiring rigorous financial analysis.
Overview
- Core workflow: Gather inputs → run DCF model → perform sensitivity analysis → optional Monte Carlo simulation → scenario comparison.
- Outputs: Excel workbook with full model, valuation summary, charts, and a PDF report.
Core Workflow
- Collect data
- Historical financial statements (3‑5 years).
- Revenue growth assumptions, margin forecasts, capex, working‑capital needs.
- Discount rate components (risk‑free rate, beta, market premium) to compute WACC.
- Run DCF model (
scripts/dcf_model.py)
- Projects free cash flow, computes terminal value, discounts to present value.
- Generates enterprise and equity valuations.
- Sensitivity analysis (built‑in in the script)
- Varies key inputs (growth rate, WACC) and produces tornado charts.
- Monte Carlo simulation (optional)
- Executes thousands of iterations with probabilistic inputs, returns confidence intervals.
- Scenario planning
- Define best/base/worst cases, assign probabilities, compare outcomes.
- Deliver output
output/model.xlsx – full model.output/summary.pdf – executive summary with charts.
Usage Examples
Create a DCF valuation for Acme Corp using the attached financials.Run a sensitivity analysis on the WACC and growth rate for the startup model.Perform a Monte Carlo simulation with 5,000 iterations on the acquisition model.Generate best, base, and worst case scenarios for the new e‑commerce platform rollout.
References
- See
references/methodology.md for detailed methodology, assumptions, and best‑practice guidelines.
Scripts
scripts/dcf_model.py – Core DCF engine (Python). Use python scripts/dcf_model.py <input.json> <output.xlsx>.
Created by Simon Cai · More e-commerce skills: github.com/simoncai519/open-accio-skill
1---2name: creating-financial-models3description: Use when user wants to build financial models, DCF analysis, valuation, sensitivity analysis, e-commerce business planning, investment decisions, or project finance assessments.4---567# Creating Financial Models89This skill provides a comprehensive suite for building financial models, including Discounted Cash Flow (DCF) analysis, sensitivity testing, Monte Carlo simulations, and scenario planning. It is ideal for valuation, investment decisions, e‑commerce business planning, and any situation requiring rigorous financial analysis.1011## Overview1213- **Core workflow**: Gather inputs → run DCF model → perform sensitivity analysis → optional Monte Carlo simulation → scenario comparison.14- **Outputs**: Excel workbook with full model, valuation summary, charts, and a PDF report.1516## Core Workflow17181. **Collect data**19 - Historical financial statements (3‑5 years).20 - Revenue growth assumptions, margin forecasts, capex, working‑capital needs.21 - Discount rate components (risk‑free rate, beta, market premium) to compute WACC.222. **Run DCF model** (`scripts/dcf_model.py`)23 - Projects free cash flow, computes terminal value, discounts to present value.24 - Generates enterprise and equity valuations.253. **Sensitivity analysis** (built‑in in the script)26 - Varies key inputs (growth rate, WACC) and produces tornado charts.274. **Monte Carlo simulation** (optional)28 - Executes thousands of iterations with probabilistic inputs, returns confidence intervals.295. **Scenario planning**30 - Define best/base/worst cases, assign probabilities, compare outcomes.316. **Deliver output**32 - `output/model.xlsx` – full model.33 - `output/summary.pdf` – executive summary with charts.3435## Usage Examples3637- `Create a DCF valuation for Acme Corp using the attached financials.`38- `Run a sensitivity analysis on the WACC and growth rate for the startup model.`39- `Perform a Monte Carlo simulation with 5,000 iterations on the acquisition model.`40- `Generate best, base, and worst case scenarios for the new e‑commerce platform rollout.`4142## References4344- See `references/methodology.md` for detailed methodology, assumptions, and best‑practice guidelines.4546## Scripts4748- `scripts/dcf_model.py` – Core DCF engine (Python). Use `python scripts/dcf_model.py <input.json> <output.xlsx>`.4950---515253---5455**Created by [Simon Cai](https://github.com/simoncai519) · More e-commerce skills: [github.com/simoncai519/open-accio-skill](https://github.com/simoncai519/open-accio-skill)**
simoncai519