Business Income Worksheet
Written by Justin Goodman, CIC, CLCS, CISC, CEO and Co-Founder, Total CSR
Published: August 24, 2026 · Last reviewed: August 24, 2026
In plain language: A Business Income Worksheet helps a business owner figure out how much money they would lose if their operation had to shut down after a fire, storm, or other covered loss. It adds up lost net income plus expenses that keep running, like payroll and rent, so the insurance agent can set an accurate coverage limit.
Technical definition: A Business Income Worksheet is an exposure analysis tool, often ISO form CP 15 15 or a carrier's proprietary equivalent, used to project net income and continuing normal operating expenses over a twelve-month period. Insurers and insurance agents use it to establish an adequate business interruption insurance limit and satisfy coinsurance requirements under forms like CP 00 30.
Business Income Worksheet at a Glance
| Attribute | Detail |
|---|---|
| Also known as | Business Interruption Worksheet, BI Worksheet, Coinsurance Worksheet |
| Category | Commercial property insurance calculation tool |
| Lines of business | Commercial Property, Business Income and Extra Expense |
| Industries most affected | Retail, manufacturing, restaurants, contractors, habitational operations |
| Related forms or endorsements | CP 15 10 (Basic Coinsurance), CP 15 15 (Business Income Report/Worksheet), CP 00 30 (Business Income Coverage Form) |
| Who bears the risk | The insured, if the worksheet underestimates the insurance amount and coinsurance applies |
| Common solution | Annual worksheet review paired with an agreed value endorsement |
| Also interacts with | Coinsurance clause, period of restoration, extra expense coverage |
Key Takeaways
- A Business Income Worksheet is a financial projection tool that calculates net income and continuing expenses to help set an accurate business interruption exposure limit.
- The worksheet matters daily because an underestimated insurance amount triggers the coinsurance penalty, reducing claim payouts even on legitimate losses.
- The most common pitfall is basing the worksheet on last year's actual results instead of next year's projected revenue, which understates growth and leaves a coverage gap.
- Agencies get the best results by rerunning the worksheet annually at renewal and whenever the business adds locations, revenue, or payroll.
What Is a Business Income Worksheet in Insurance?
A Business Income Worksheet is the calculation an insurance agent or underwriter uses to determine how much business interruption insurance and Extra Expense coverage a commercial property insurance policy needs. Business Income coverage under ISO form CP 00 30 reimburses loss of income and continuing operating expenses during the recovery time after a covered property loss. Because policy limits are set at policy inception based on a forecast, not on an actual future loss, the worksheet exists to make that forecast defensible.
The worksheet exists because commercial property insurance policies with business interruption insurance typically carry a coinsurance requirement, usually 50 percent, 80 percent, or 100 percent of projected annual business income plus continuing expenses. If the insured selects policy limits below that required percentage, the carrier pays claims on a pro-rata basis, penalizing the insured for underinsuring even on a covered loss. The worksheet forces a documented, line-item financial projection rather than a guess.
Consider a bakery projecting $600,000 in annual revenue, $180,000 in cost of goods sold, and $250,000 in continuing expenses like rent, utilities, and management salaries during a shutdown. The worksheet nets these figures to arrive at business income values of roughly $670,000. Without that exercise, the owner might have insured for $250,000 based on a rough guess, triggering a severe coinsurance penalty after a kitchen fire.
How Does a Business Income Worksheet Work?
- The data gathering. The insurance agent or accountant collects the insured's prior-year financial statements, current-year projections, and payroll records.
- The financial projection. Revenue, cost of goods sold, and continuing expenses are projected forward twelve months, adjusting for known growth, new contracts, or seasonal shifts.
- The net income calculation. Net income is combined with continuing normal operating expenses to produce the total business interruption exposure figure.
- The insurance selection. The agency compares the calculated figure against the policy's coinsurance percentage and recommends policy limits that meet or exceed that threshold.
- The binding and monitoring. The insurance amount is bound on the policy, and the worksheet is flagged for review at each renewal or after any material change in operations.
Real Claim Examples Involving a Business Income Worksheet
Restaurant fire with an outdated worksheet
A family-owned restaurant carried policy limits set three years earlier, before it added a second dining room and doubled staff. After a kitchen fire triggered a four-month closure, the carrier's audit found the insured met only 55 percent of the required coinsurance percentage. The insurance claim payout was reduced proportionally, leaving the owner to cover a six-figure financial loss out of pocket because the worksheet was never updated for the expansion.
Manufacturer with an agreed value endorsement
A metal fabricator worked with its insurance agent to complete a detailed Business Income Worksheet at renewal, then added an Agreed Value endorsement to waive the coinsurance penalty for the policy terms. When a roof collapse under snow load shut the plant for ten weeks, the carrier paid the full actual loss sustained without applying coinsurance, because the worksheet had already established the insurance amount was adequate at binding.
Seasonal retailer underestimating holiday exposure
A gift shop generating 60 percent of annual revenue in November and December completed a worksheet based on average monthly income rather than peak season figures. A burst pipe closed the store in early December, and the flat monthly average understated the loss period's true income loss impact, leaving the insured with a lower actual loss sustained calculation than the business truly experienced and creating significant financial impact.
Business Income Worksheet vs. Actual Loss Sustained: What Is the Difference?
A Business Income Worksheet is a pre-loss planning tool used to set property insurance coverage limits, while Actual Loss Sustained is the post-loss method carriers use to calculate what the policy actually pays. Insurance agents use one to prevent a coinsurance penalty from ever applying, and adjusters use the other to quantify the real dollar loss once an insurance claim occurs.
| Comparison area | Business Income Worksheet | Actual Loss Sustained |
|---|---|---|
| Primary use case | Setting the policy limits before a loss | Calculating the insurance claim payment after a loss |
| Coverage / concept type | Underwriting and limit-setting tool | Loss valuation method |
| Typical exclusions | Not a coverage form; no exclusions apply directly | Excludes expenses that would not have been incurred but for the loss |
| Who is most affected by errors | The insured, through coinsurance penalties | The insured, through disputed claim documentation |
| Common mistakes | Using stale financials instead of forward projections | Failing to track continuing expenses contemporaneously during the shutdown |
What Are the Most Common Mistakes With a Business Income Worksheet?
- Agencies base the worksheet on last year's tax return instead of a forward-looking financial projection, understating policy limits for a growing business and triggering coinsurance penalties.
- Insurance agents forget to include continuing expenses like ordinary payroll, causing the calculated exposure to fall well short of the true need and affecting business continuity planning.
- The worksheet is completed once at policy inception and never revisited, so a business that doubles revenue over three years remains underinsured without anyone noticing the increased business interruption exposure.
- Seasonal businesses use annual averages instead of peak-period figures, which distorts the true income exposure during the months when a loss would hurt most.
- No documentation of the worksheet is kept in the agency file, leaving no evidence of the limit recommendation if a coinsurance dispute arises later.
- Insurance agents assume an Extra Expense sublimit for temporary relocation is automatically included in the Business Income figure, when it often requires separate calculation and limit selection.
How to Explain a Business Income Worksheet to a Client
Explaining a Business Income Worksheet to a personal lines client
This type of client rarely needs the term, but if they own a side business or rental property, explain it simply: this worksheet is how we make sure that if your business has to close for repairs, the property insurance actually replaces the income you'd lose, not just a random number.
Explaining a Business Income Worksheet to a small business owner
Tell the owner that this worksheet is the step that protects them from a nasty surprise at insurance claim time. If they underinsure, the insurance company can cut their claim payment even when the loss is completely covered, so filling this out accurately now means getting paid fairly later and maintaining business continuity.
Explaining a Business Income Worksheet to a CFO or risk manager
Frame it as the mechanism that satisfies the coinsurance requirement embedded in the business interruption insurance form and supports effective risk management. Recommend running the worksheet against forward-looking financial projections, not trailing twelve-month actuals, and discuss whether an Agreed Value endorsement makes sense to eliminate coinsurance risk entirely for the policy terms while ensuring broad coverage for all business personal property and income streams.
Frequently Asked Questions About a Business Income Worksheet
What happens if a business skips the Business Income Worksheet entirely?
Skipping the worksheet does not remove the coinsurance requirement built into the business interruption insurance Coverage Form. The insured simply guesses at policy limits, and if that guess falls short of the required percentage, the carrier applies the coinsurance penalty at insurance claim time regardless of whether a worksheet was ever completed.
Is a Business Income Worksheet required by the policy?
The worksheet itself is not a policy form requirement in most cases, but the coinsurance clause it supports is. Some carriers require a completed worksheet or a signed statement of property values before binding higher policy limits, especially for larger or more complex operations requiring comprehensive risk management.
How often should a Business Income Worksheet be updated?
The worksheet should be updated at every renewal and immediately after any material change, such as new locations, significant revenue growth, or added payroll. Total CSR's training work with agencies consistently finds that CSRs flag renewal reviews for property and liability changes but skip the business interruption insurance limit entirely unless a specific workflow step forces the conversation about annual business income.
Can an Agreed Value endorsement replace the need for a worksheet?
An Agreed Value endorsement waives the coinsurance penalty for the policy period but does not eliminate the need for an accurate worksheet. The insurer still requires a completed statement of business income values or worksheet to determine the agreed insurance amount before issuing the endorsement.
Does the Business Income Worksheet cover extra expenses too?
The worksheet can include Extra Expense projections for costs like temporary relocation, but many agencies calculate Business Income and Extra Expense separately since they serve different purposes. Extra Expense covers costs incurred to keep operating, like renting temporary space, while Business Income covers loss of income and continuing normal expenses during the recovery time.
Who is responsible for completing the worksheet, the agent or the client?
Completion is typically a collaborative process, with the client or their accountant supplying financial data and the insurance agent guiding the calculation and limit recommendation. The agent's file should document that a worksheet was offered and completed, since the absence of that documentation is a common E&O exposure in underinsurance disputes.
Related Insurance Terms
- Business Income Coverage: The commercial property insurance coverage that reimburses loss of income and continuing expenses during a shutdown, which the worksheet is used to size correctly.
- Coinsurance Clause: A policy provision requiring the insured to carry policy limits equal to a specified percentage of value, which the worksheet exists to satisfy and avoid penalties under.
- Extra Expense Coverage: Coverage for costs incurred to continue operating after a loss, often calculated alongside but separately from the Business Income figure on the worksheet.
- Actual Loss Sustained: The insurance claim valuation method used after a loss occurs, distinct from the worksheet's role in setting policy limits before a loss happens.
- Period of Restoration: The time frame during which Business Income losses are covered, a key variable the worksheet must account for when projecting total exposure.
- Agreed Value Endorsement: An endorsement that waives the coinsurance penalty for policy terms, typically issued only after a worksheet or statement of values is reviewed and accepted.
- Civil Authority Coverage: Additional business interruption insurance that covers income loss when civil authority prohibits access to the premises.
- Dependent Property Coverage: Extension covering income loss when a key supplier or customer location suffers a covered property loss.
- Replacement Cost: Valuation method for property insurance that pays to replace damaged property without deduction for depreciation.
Sources and References
About the Author
Justin Goodman, CIC, CCIP, CISC, CLCS, CRIS, PCIA, QCLS, MFHR
CEO and Co-Founder, Total CSR, Inc.
Justin Goodman is a third-generation insurance broker with over two decades in agency operations. He has trained more than 50,000 CSRs, account managers, and producers in commercial and personal lines coverage, from workers' compensation to construction risk management. He was named 2024 Insurance Journal Agent of the Year and one of the nation's top five construction insurance experts by Risk & Insurance. He is the author of Retain, which applies cognitive science research on memory and knowledge transfer to insurance training, and speaks nationally on how agencies build durable technical expertise in their teams.