How to Model Tax-Loss Carryforwards (NOLs) in a Financial Model

How net operating loss (NOL) carryforwards shelter future taxable profit, and how to build the tax-loss schedule so your cash tax and free cash flow are right.

A net operating loss (NOL) carryforward lets a business use losses from unprofitable years to reduce the tax it pays in later, profitable years. For any company with early losses — startups, turnarounds, heavy-CAPEX projects — modelling NOLs correctly is the difference between a free cash flow forecast that reflects reality and one that overstates tax by hundreds of thousands in the recovery years. Yet it is one of the most commonly skipped mechanics in do-it-yourself models, which simply apply a flat tax rate to every year.

What a net operating loss carryforward is

When taxable profit is negative, most tax systems do not send a refund; instead they let you carry the loss forward to offset future taxable profit. The accumulated pool of unused losses is the NOL balance. In a later year, taxable income is reduced by the losses available, and cash tax is charged only on what remains. The pool depletes as it is used and grows again in any further loss-making year.

Why NOLs matter for free cash flow

Cash tax sits directly in the free cash flow bridge — it is deducted after operating profit and before you reach unlevered free cash flow. If you apply a flat statutory rate to a company that lost money for two years and then turns profitable, you charge tax it would never actually pay, understating free cash flow (and therefore valuation) precisely in the years that matter most to investors. Getting the NOL schedule right can lift early-recovery-year free cash flow by 20–30% for a business coming out of losses.

Building the NOL schedule step by step

The schedule has four rows per period. First, the opening NOL balance (last period's closing). Second, pre-tax profit for the period. Third, the loss used or added: if pre-tax profit is negative, add it to the pool; if positive, use the smaller of the profit or the available pool. Fourth, taxable income after NOL = max(0, pre-tax profit − opening NOL balance), with cash tax = that figure × the tax rate. The closing balance carries forward to the next period.

A worked example

Suppose a business loses $400,000 in Year 1 and $200,000 in Year 2, then earns $300,000 in Year 3 and $500,000 in Year 4. Without NOLs, Years 3 and 4 pay tax on $300k and $500k. With a carryforward, the $600,000 loss pool first shelters all $300,000 of Year 3 profit (zero cash tax, pool falls to $300,000), then $300,000 of Year 4's profit, leaving only $200,000 taxable in Year 4. At a 25% rate that is $125,000 of cash tax saved across the two years — cash that flows straight into free cash flow.

Limits, expiry and jurisdictions

The rules vary by country and change over time: some jurisdictions cap the share of profit that NOLs can offset in a single year (for example 80%), some let losses expire after a set number of years, and some allow carrybacks as well as carryforwards. A credible model parameterises the tax rate and, where it matters, the annual utilisation cap, rather than hard-coding a single number — and you should always confirm the current rule for the entity's jurisdiction.

Common mistakes

Three errors recur: applying a flat tax rate and ignoring the pool entirely; letting taxable income go negative and generating a phantom tax credit (it should floor at zero); and forgetting to grow the pool in further loss years. Each distorts cash tax, and because tax is a large, non-negotiable outflow, each distorts free cash flow and any DCF built on it.

Automate the NOL schedule

The EasyFinancialModels engine builds the tax-loss carryforward schedule automatically inside a dedicated Tax sheet: it accumulates losses, applies them against future taxable profit, and floors cash tax at zero — all as live, auditable Excel formulas. To automate these tax schedules across a full forecast, use our free cashflow forecasting model, which carries the correct cash tax straight through to unlevered and levered free cash flow. It's free for a 3-year model, with no sign-up.

→ Build your free cash flow model free with the Free Cash Flow tool

More Free Cash Flow guides

What Is Free Cash Flow? UFCF vs LFCF Explained Simply · How to Calculate Free Cash Flow From EBITDA (With Formula) · Unlevered vs Levered Free Cash Flow: The Difference and When to Use Each · Why Free Cash Flow Matters More Than Profit · Free Cash Flow Conversion: What It Is and What's a Good Rate

About the author

Every model is built and reviewed by the project's Financial Advisor — a Fellow Chartered Accountant (FCA), Chartered Global Management Accountant (CGMA) and Associate Chartered Management Accountant (ACMA) with around two decades of corporate finance, audit and accounting experience, designing investor-grade financial models across industries. Full credentials and background are available on LinkedIn. More about the author →

← All guides · WACC calculator · DCF calculator · IRR calculator · Inside the 15-sheet model