X-ASTRiS Financial Modeling
X-ASTRiS
Free practical guide

Value-Based Cash Flow Modeling

A Practical Guide to Building Cash Flow Models Focused on Maximizing Value

Written by Carlo Fiscalini — with experience at Deloitte M&A, PE value creation and business restructuring. This guide explains how to build a three-statement financial model from scratch, step by step, using worked examples throughout.

↓ Download PDF (free)Try X-ASTRiS free →

Free to download · no registration required

What this guide covers

A cash flow forecast model is one of the most useful tools in business — whether you're starting a company, raising funding, planning a major investment or assessing a restructuring. Yet most guides make it harder than it needs to be.

This guide walks through every component of a three-statement model — P&L, Balance Sheet and Cash Flow — using a practical coffee shop example that grows in complexity through each chapter. Every concept is explained with worked tables, driver trees and formulas you can use immediately.

Aimed at companies in early stages of scaling, but the same principles apply to larger organisations, carve-outs, restructurings and M&A situations.

Table of contents

Ch. 1
Introduction
Why cash flow forecasts matter — for strategy, financing, restructuring and M&A. When to build one and what it gives you.
Ch. 2
Model output — expected cash flow
Cash position as the key output. Monthly vs annual views, cash deficit scenarios, business valuation and DCF basics, enterprise value vs equity value.
Ch. 3
Revenue forecasting
Driver-based estimates, product-market combinations, growth rates, SaaS subscription models, market share analysis and sense-checking techniques.
Ch. 4
Costs forecasting
COGS, FTE-based employee expenses, other operating costs, depreciation and amortization, interest expenses and corporate income tax.
Ch. 5
Fixed assets & working capital
Fixed asset roll, inventory (DIO), accounts receivable (DSO), accounts payable (DPO) and other balance sheet working capital items.
Ch. 6
Funding forecasting
Equity and debt modeling, interest payments and the tax shield. How financing decisions flow through to cash.
Ch. 7
Bringing it together: cash flow
Operating, investing and financing cash flows. NOPLAT. Reconciling the cash position to the balance sheet.
Ch. 8
Next steps
Scenario and sensitivity analysis, MBO models, monthly forecasting, DCF valuation, value creation planning.

Key concepts covered

EBITDA
Earnings before interest, tax, depreciation and amortization
NOPLAT
Net operating profit less adjusted tax — starting point of operating cash flow
DSO
Days sales outstanding — average time customers take to pay
DPO
Days payables outstanding — time taken to pay suppliers
DIO
Days inventory outstanding — time stock sits before being sold
DCF model
Discounted cash flow — values a business based on expected future cash flows
Tax shield
Tax saving created by the deductibility of interest on debt
Enterprise Value
Total business value — equity value plus net debt

About the author

Carlo Fiscalini is the founder of X-ASTRiS. He started his career at a boutique restructuring firm during the 2008 financial crisis, building cash flow models for distressed businesses. He later joined Deloitte to work on M&A valuation and carve-out programs across a range of industries. His work since has focused on PE value creation, transformation and strategic financial decision-making.

X-ASTRiS was built from his experience that the question "what does this decision do to our cash?" too often gets answered too late. This guide and the X-ASTRiS platform are both designed to change that.

LinkedIn →About X-ASTRiS →

Put the theory into practice

X-ASTRiS automates everything in this guide — revenue drivers, cost modeling, balance sheet mechanics, cash flow derivation and scenario analysis. Try it free for 5 days.

Start free trialDownload the guide