Lightlines
By anthropics

dcf-model

anthropics2.3k installs

Value a company with an Excel cash flow model.

What it does

Builds company valuation spreadsheets with cash flow forecasts, scenario comparisons, and sensitivity analysis.

When to use it

Use for company valuation using discounted cash flows, intrinsic value analysis, or detailed financial modeling.

How to use it

Give it a company and growth assumptions; it builds an Excel valuation model with user confirmation between modeling stages.

What you provide

  • a ticker symbol or company name
  • growth rates or "use consensus"

Latest review

What you need · 4

The default standalone spreadsheet workflow uses Python; the live Excel environment instead uses Office JS.

The standalone Python workflow requires openpyxl version 3.0.0 or later.

The standalone workflow's mandatory recalculation script uses LibreOffice to recalculate every sheet.


Access · 1

This skill

market data pages

Read

Reads current market data