# Discounted Cashflow Model

> Builds a discounted cash flow (DCF) valuation model, calculating enterprise value, equity value, and per-share price with a growth-rate × discount-rate sensitivity analysis matrix. Triggered by requests like 'do a DCF on [company]', 'run a valuation', 'calculate WACC/discount rate', or mentions of free cash flow, terminal value, or sensitivity analysis.

- **Type:** Skill
- **Install:** `agentstack add skill-null0xxx-kimi-atlas-discounted-cashflow-model`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [null0xxx](https://agentstack.voostack.com/s/null0xxx)
- **Installs:** 0
- **Category:** [AI & ML](https://agentstack.voostack.com/c/ai-and-ml)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [null0xxx](https://github.com/null0xxx)
- **Source:** https://github.com/null0xxx/kimi-atlas/tree/main/skills/discounted-cashflow-model

## Install

```sh
agentstack add skill-null0xxx-kimi-atlas-discounted-cashflow-model
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Discounted Cash Flow Valuation Model

A DCF (Discounted Cash Flow) valuation tool that supports full free cash flow projections, terminal value calculation, enterprise value derivation, and automatic generation of a **growth rate × discount rate** sensitivity analysis matrix.

## Quick Start

### Basic DCF Valuation

```bash
python scripts/dcf_model.py --fcf 1000 --growth 0.15 --discount 0.10
```

### With Sensitivity Analysis Matrix

```bash
python scripts/dcf_model.py --fcf 1000 --growth 0.15 --discount 0.10 --sensitivity
```

### Full Equity Valuation + CSV Export

```bash
python scripts/dcf_model.py \
    --fcf 5000 --growth 0.12 --discount 0.09 \
    --terminal-growth 0.03 --years 5 \
    --debt 8000 --cash 3000 --shares 10000000 \
    --currency "M USD" \
    --sensitivity \
    --growth-range 0.05,0.25,0.05 \
    --discount-range 0.06,0.14,0.02 \
    --output valuation.csv
```

## Detailed Usage

### Core Valuation Workflow

1. **Projected Free Cash Flows**: Project FCF for each year based on a base FCF and growth rate
2. **Terminal Value**: Calculated using the Gordon Growth Model (perpetuity growth model): `TV = FCF_n × (1+g) / (r-g)`
3. **Discounting**: Discount projected FCFs and terminal value to present value, yielding Enterprise Value
4. **Equity Value**: `Equity Value = EV - Net Debt + Cash`
5. **Per-Share Value**: `Per Share = Equity Value / Shares Outstanding`

### Sensitivity Analysis Matrix

Use the `--sensitivity` flag to automatically generate a two-dimensional matrix showing enterprise value under different combinations of growth rates and discount rates. This helps visualize how changes in key assumptions affect the valuation.

The base case scenario is marked with `[brackets]` in the matrix.

### JSON Output Mode

Add the `--json` flag to output the full results in JSON format to stdout, useful for programmatic processing:

```bash
python scripts/dcf_model.py --fcf 1000 --growth 0.15 --discount 0.10 --json
```

## Parameters

| Parameter | Required | Default | Description |
|-----------|----------|---------|-------------|
| `--fcf` | Yes | - | Base year free cash flow (positive number) |
| `--growth` | Yes | - | Annual growth rate, e.g. 0.15 for 15% |
| `--discount` | Yes | - | Discount rate / WACC, e.g. 0.10 for 10% |
| `--terminal-growth` | No | 0.03 | Perpetuity growth rate (must be < discount rate) |
| `--years` | No | 5 | Number of projection years (1–30) |
| `--debt` | No | 0 | Net debt (used for equity value calculation) |
| `--cash` | No | 0 | Cash and equivalents |
| `--shares` | No | 0 | Total shares outstanding (used for per-share value) |
| `--sensitivity` | No | false | Generate sensitivity analysis matrix |
| `--growth-range` | No | auto | Growth rate range as `min,max,step`, e.g. `0.05,0.25,0.05` |
| `--discount-range` | No | auto | Discount rate range as `min,max,step`, e.g. `0.06,0.14,0.02` |
| `--output` | No | - | Output file path (.csv or .json) |
| `--currency` | No | "" | Currency unit label, e.g. `M USD`, `€K` |
| `--json` | No | false | Output results as JSON to stdout |

## Use Cases

- Perform DCF valuation on a target company to assess its fair value range
- Run valuation sensitivity checks before investment decisions (how much do key assumptions need to shift to change the conclusion?)
- Quickly generate valuation matrix tables for financial modeling
- Export CSV/JSON results to integrate into larger analysis pipelines or reports

## Notes

- The discount rate must exceed the perpetuity growth rate (a mathematical requirement of the Gordon Growth Model)
- This tool uses only the Python standard library — no additional dependencies required
- Cells marked `N/A` in the sensitivity matrix indicate parameter combinations that violate mathematical constraints

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [null0xxx](https://github.com/null0xxx)
- **Source:** [null0xxx/kimi-atlas](https://github.com/null0xxx/kimi-atlas)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-null0xxx-kimi-atlas-discounted-cashflow-model
- Seller: https://agentstack.voostack.com/s/null0xxx
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.