Skip to content
PromptReady to runFinanceValuation

FCF Projection Builder

Written in-house · editorially graded

Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.

Dry-run test passed · Jun 13, 2026

Editorially graded · Jun 20, 2026

This prompt generates a 5-year free cash flow projection for a given company, using input growth rates and margins. The user inputs the company's historical financial data, growth rates, and margins, and the prompt outputs a detailed 5-year projection of free cash flows. The prompt assumes a specific growth rate and margin range to estimate the future cash flows. The output is a table with 5 years of projected free cash flows, which can be used in DCF valuations. The user provides the historical financial data, growth rates, and margins, and the prompt generates the 5-year projection.

What you get

A ready-to-paste prompt you can drop into your AI. Produces an Excel workbook (.xlsx).

Works in
Claude · ChatGPT · Gemini
Paste it in, fill the [brackets]
Any AI assistant
Works anywhere you can paste text

See it in action

A real input → output sample

Sample input
Build a 5-year UFCF model for Acme Corp. Base year is FY2024. Revenue was $500 million. Use USD, in millions. EBITDA margin is 22%. Tax rate is 21%. CapEx is 5% of revenue.
Sample output
Sample Excel output produced by the FCF Projection Builder prompt
Produced by an AI assistant following this prompt on the sample input above.
View the full output as text
Example Output
Delivering Acme_Corp_5Y_FCF_Model_FY2024.xlsx. Provided: base revenue $500M, EBITDA margin 22%, tax 21%, CapEx 5%. Defaults applied (flagged for confirmation): revenue growth fading 10%→6% over FY2025–FY2029 toward a long-run terminal rate, D&A 5% of revenue, ΔNWC 2% of the annual revenue change (delta-based). Unlevered FCF FY2025–FY2029: $72.9M / $79.5M / $86.0M / $92.1M / $97.8M. Review and update assumptions as needed.

Goes well with

Related