Over 3 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.
Start Free
What Is a Net Operating Loss (NOL)?
A net operating loss occurs when a company’s allowable tax deductions exceed its taxable income for the period. When this happens, a business generally can’t use the full deduction in the current year, so the tax code allows it to apply the loss to other tax years instead, lowering what it owes when it’s profitable again.
Common Reasons for a Net Operating Loss
NOLs are especially common in two situations:
The startup phase, when a company spends more than it earns while building toward future revenue
Cyclical businesses, whose earnings rise and fall with broader economic cycles. A mining company, for example, might post a strong profit one year, a loss the next, and a recovery the year after. The loss year’s NOL can then offset taxable income in a future profitable year.
Key Highlights
What it is: A net operating loss occurs when a company’s deductions exceed its taxable income, allowing it to apply the loss to other tax years to lower future taxes.
Carryback vs. carryforward: Most businesses can no longer carry losses back to prior years; narrow exceptions exist for farming losses and certain insurance companies. Losses otherwise carry forward indefinitely, capped at 80% of taxable income.
Purpose: The rule aims to make a company’s lifetime tax bill roughly the same regardless of when its profits and losses occur.
Acquisitions: In a stock acquisition, the buyer can generally use the target’s NOLs going forward, but Internal Revenue Code Section 382 limits how much.
NOL Carryback Rules
Under current tax law, most businesses can no longer carry a net operating loss back to prior tax years. This changed with the Tax Cuts and Jobs Act of 2017, which eliminated the general carryback provision for losses arising in tax years after December 31, 2017.
There are two narrow exceptions that retain a carryback option:
Farming losses, which can still be carried back two years
Losses of insurance companies other than life insurance companies, which also retain a two-year carryback (and aren’t subject to the 80% taxable income cap that applies to other carryforwards)
Outside of these exceptions, a business with an NOL generally carries the loss forward instead. (NOLs from tax years that began before 2018 follow the older rules, including the prior carryback option, so timing matters when applying any of this.) Given how often these rules have shifted, it’s worth confirming current treatment with a tax advisor or IRS Publication 536 before filing.
What is an NOL/Tax Loss Carryforward?
A net operating loss (NOL) or tax loss carryforward is a tax provision that allows firms to carry forward losses from prior years to offset future profits and, therefore, lower future income taxes. The way a tax loss carryforward works is that a schedule is generated to track all cumulative losses, which are then applied in future years to reduce profits until the balance in the TLCF is zero. An NOL carryforward schedule is commonly used in financial modeling.
What is the Purpose of an NOL/Tax Loss Carryforward?
Tax loss carryforwards exist so that the total lifetime taxes for a firm will, in theory, be the same no matter how their profits and losses are spread out.
Example if firms could NOT carry forward losses
A company that had a loss of $10 million in 2018 and a profit of $10 million in 2019 with a 30% tax rate would pay zero tax in 2018 and $3 million in 2019. Its total profit before tax in 2018 and 2019 combined was zero, yet it paid $3 million in taxes.
Compare that to a different company that also had $0 of profit in 2018 and $0 of profit in 2019. This company would pay zero taxes and had a total pre-tax profit of $0.
So why would the first company pay $3 million in taxes while the second company paid none? The first company is much worse off due to the distribution and timing of its profits.
To address this issue, tax loss carryforwards were created.
Building a Tax Loss Carryforward Schedule
The easiest way to keep track of a TLCF schedule is to create a model in Excel. In the screenshot below, you can see how a financial analyst creates the schedule.
Steps To Create a Tax Loss Carryforward Schedule in Excel
For losses arising after 2020, keep in mind that the carryforward has no expiration date but is capped at 80% of taxable income in any given year, so a model needs to account for that limit when projecting how quickly the balance gets used up.
Create a line that’s the opening balance of carryforward losses
Create a line that’s equal to the current period loss, if any
Create a subtotal line
Create a line to calculate the loss used in the period with a formula stating that “if the current period has taxable income, reduce it by the lesser of the taxable income in the period and the remaining balance in the TLCF.
Create a closing balance line equal to the subtotal less any loss used in the period
Next period’s opening balance equals the last period’s closing balance
Example Tax Loss Carryforward
Below is a screenshot of a tax loss carryforward schedule built in Excel. This is taken from CFI’s e-commerce/startup financial modeling course, in which a company has the ability to carry forward losses due to the significant losses expected to be incurred by the business in its first few years of operation.
The best way to learn how to build a TLCF schedule is by practicing. By using the example provided, you can see how it was designed and test yourself to create your own in Excel. If you want a completed example to work with, check out CFI’s financial modeling templates library of completed models from beginner to advanced.
Treatment of NOLs in an Acquisition
Typically, when an acquisition is structured as a stock acquisition, the acquiring company obtains the ability to use the target’s NOLs going forward. However, there may be limits placed on the usage of these acquired NOLs. For example, in the United States, the usage of acquired NOLs is governed by Internal Revenue Code (IRC) Section 382.
Basics of IRC 382
There are two main components of Section 382 — limitation and ownership change. An ownership change occurs when one or more 5% shareholders increase their ownership, in aggregate, by more than 50% over a testing period. Obviously, an acquisition will trigger a change in ownership.
Limitations of IRC 382
After the acquisition, the acquiring company may deduct the acquired NOLs against its taxable income after calculating the Section 382 base limitation. The formula used in calculating the base limitation amount is:
Fair Market Value of the Target Corporation Stock x Federal Long-Term Tax Exempt Rate = Base Limitation Amount
When calculating the base limitation amount, the fair market value depends on potential adjustments as set forth in Internal Revenue Service (IRS) regulations. The IRS publishes the federal long-term tax-exempt rate monthly.
The base limitation formula drastically limits the usage of acquired NOLs.
Always consult a professional tax advisor before filing any tax forms.
Working NOLs into Your Financial Models
Net operating losses show up in all kinds of modeling work, from a straightforward tax loss carryforward schedule to the more involved limitations that come into play after an acquisition. Getting comfortable with how an NOL moves through a model, and which rules apply to it, makes your projections more accurate and your assumptions easier to defend.
If you want to build on these skills, CFI’s FMVA® certification covers tax loss carryforwards and the broader modeling techniques that go along with them, so you can apply this in a full financial model rather than just in isolation.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.