Business income worksheet
Project business income and extra expense, then compare waiting periods, policy limits and coinsurance.
Start with the records
Build the business-income baseline
Use a twelve-month annual schedule or actual monthly seasonality. This worksheet treats each month as 30 days for allocation and says exactly when each policy limit is applied.
Annual values are divided by 12; monthly values keep seasonality.
Gross receipts before COGS.
Cost of goods sold for the same annual period.
Worksheet result
Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; same facts without selected financial-policy caps.
Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; selected BI, waiting, period, and extra-expense treatment.
Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; overall carried limit applied after BI plus EE.
Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; net profit plus continuing costs less additional saved expense.
Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; timed extra-expense entries.
Source: ISO CP 15 15, Business Income Coverage Form worksheet basis; Last reviewed September 16, 2026.; net plus operating expenses including payroll multiplied by percentage.
This is a reasonable-speed restoration scenario using the entered short projected shutdown. Actual timing may be longer or shorter when supported by dated records.
Actual loss sustained is a comparison using the same facts without the selected waiting, monthly BI, 120-day, or carried-limit caps. It is not a promise of coverage or payment.
| Month | Net before tax | Continuing costs | Saved costs | Eligible days | BI | EE | Total | Source |
|---|---|---|---|---|---|---|---|---|
| 1 | $0.00 | $0.00 | $0.00 | 27 | $0.00 | $0.00 | $0.00 | ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026. |
Calculation ordering and assumptions
- Build monthly revenue, COGS, categorized operating expenses, payroll, and net profit before tax.
- Add continuing expenses, including payroll only on eligible ordinary-payroll days; subtract additional saved expenses once.
- Use actual day counts for the 72-hour BI-only waiting period, once. The waiting window is not also subtracted from the restoration clock.
- Apply the BI-only fraction separately to each consecutive 30-day eligible window, including a partial first or last window; do not replace this with one global minimum.
- Add extra expense without the monthly BI fraction or BI waiting period.
- Apply the optional 120-day BI + EE period to the combined period, then the carried limit as the overall as-written cap.
- Every month is treated as 30 days for monthly-to-daily allocation and restoration-month timing.
- Projected shutdown duration is measured from the loss date. The 72-hour waiting window equals 3 actual day(s), applies to BI only, and is not subtracted twice.
- The projected restoration period starts after the loss-date waiting window for payment eligibility; the interruption/restoration clock itself remains the entered loss duration.
- Ordinary payroll is counted on every eligible day because no optional ordinary-payroll limitation was selected.
- Civil-authority days are limited to four weeks, overlapping direct-loss days are removed once, and those overlap days do not extend the restoration period.
- Extra expense is not reduced by the monthly BI fraction or the BI waiting window.
- The 120-day BI + EE option is not selected.
- Extended business income is not selected; the worksheet does not add a post-restoration extension.
- A reasonable-speed restoration scenario and an accountant's projection are inputs for this illustration, not automatic coverage conclusions.
Business-income source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.. Coinsurance estimate source: ISO CP 15 15, Business Income Coverage Form worksheet basis; Last reviewed September 16, 2026..
Related tools and reading
Frequently Asked Questions
What does the 72-hour waiting period do?
It removes the first three actual days from business-income payment in this illustration, once. It does not remove extra expense, and it does not shorten the entered shutdown clock a second time.
How are seasonal businesses handled?
Enter twelve months of receipts and COGS and choose the month the loss began. The worksheet uses that month to move through consecutive 30-day periods.
Does the monthly fraction cap extra expense?
No. The one-third, one-fourth, or one-sixth fraction applies to BI only. Extra expense is separate, subject to the selected combined period and overall carried limit.
What is the actual loss sustained comparison?
It uses the same revenue, expense, payroll, restoration, civil-authority, and extra-expense facts without the selected waiting, monthly BI, 120-day, or carried-limit caps. It is not a promise of coverage or payment.
What does the CP 15 15 estimate show?
When selected, it multiplies twelve months of net profit plus operating expenses, including payroll, by the entered percentage. It is labelled an estimate and does not replace the policy wording.
Policy provisions · Last reviewed September 16, 2026
- ISO CP 00 30: business income waiting period of 72 hours, extended business income of 60 days on current forms (30 on older editions), optional monthly and 120-day maximum periods, and civil authority coverage up to four weeks. ISO CP 15 15 provides the business income worksheet basis. Last reviewed September 16, 2026; read the applicable edition and endorsements.
Supporting Records Needed
- 12 months of income statements and profit-and-loss records
- Monthly sales, production, and COGS records
- Payroll register showing ordinary payroll and dates paid
- Operating expense ledger identifying continuing and saved costs
- Invoices, receipts, and logs for extra expense
- Restoration timeline and civil-authority records
Related Reading
Educational illustration based on your inputs. Not legal, coverage or claim advice. Your policy language controls.
Business income worksheet Summary
Generated on
The linked URL in a saved PDF reopens these inputs. The worksheet values are printed below.
Inputs
| Seasonality | annualSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected annual or monthly schedule. |
| Annual gross receipts | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered annual gross receipts. |
| Annual COGS | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered annual COGS. |
| Annual operating-expense fallback | Not usedSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered fallback when no categorized rows are present. |
| Net profit before tax override | ComputedSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered accountant projection override. |
| Monthly gross receipts 1 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 1 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 2 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 2 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 3 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 3 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 4 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 4 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 5 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 5 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 6 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 6 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 7 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 7 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 8 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 8 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 9 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 9 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 10 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 10 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 11 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 11 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly gross receipts 12 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Monthly COGS 12 | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered monthly seasonal schedule. |
| Operating expense 1 name | Rent or leaseSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered categorized expense line. |
| Operating expense 1 category | occupancySource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected expense category. |
| Operating expense 1 annual amount | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered categorized expense line. |
| Operating expense 1 continues | YesSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected continuing-cost toggle. |
| Operating expense 1 monthly schedule | Annual / 12Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered expense schedule. |
| Operating expense 2 name | UtilitiesSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered categorized expense line. |
| Operating expense 2 category | utilitiesSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected expense category. |
| Operating expense 2 annual amount | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered categorized expense line. |
| Operating expense 2 continues | YesSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected continuing-cost toggle. |
| Operating expense 2 monthly schedule | Annual / 12Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered expense schedule. |
| Annual payroll | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered payroll. |
| Payroll continues | YesSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected payroll toggle. |
| Ordinary payroll limitation | Not selectedSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; optional user-entered ordinary-payroll limitation. |
| Payroll monthly schedule | Annual / 12Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered payroll schedule. |
| Projected shutdown duration from loss | 30 day(s)Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered projected duration. |
| Restoration period | 1 month(s) at 30 days/monthSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered restoration scenario. |
| Loss start month | 1Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered start month. |
| Extended business income | Not selectedSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected post-resumption hypothetical control. |
| Waiting period hours | 72 hour(s)Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered waiting-period facts. |
| Waiting period day input | Derived from hoursSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered or derived waiting-period day count. |
| 72-hour BI-only waiting | Applied onceSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected waiting treatment. |
| Civil authority | Not selectedSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered civil-authority period and documented overlap. |
| Monthly BI-only fraction | Not selectedSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected consecutive eligible-window fraction. |
| 120-day BI + EE option | Not selectedSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-selected combined-period option. |
| Carried limit overall cap | Not enteredSource: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; user-entered as-written cap. |
| CP 15 15 estimate | Not selectedSource: ISO CP 15 15, Business Income Coverage Form worksheet basis; Last reviewed September 16, 2026.; user-selected coinsurance estimate. |
Results
| Actual loss sustained comparison | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; same facts without selected financial-policy caps. |
| Policy illustration before carried limit | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; BI caps, waiting, extra expense, and optional period treatment. |
| Policy illustration after carried limit | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; overall as-written carried-limit cap. |
| Estimated CP 15 15 required 12 months | Not selectedSource: ISO CP 15 15, Business Income Coverage Form worksheet basis; Last reviewed September 16, 2026. |
| Covered period | 30 day(s)Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; loss, non-overlapping civil authority, extension, and 30-day restoration ordering. |
| Actual waiting day count | 3 day(s)Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; 72-hour BI-only waiting converted to actual days. |
| Actual annual net profit before tax | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; annual or monthly schedule, including override when selected. |
| Actual business income before policy caps | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; same facts without selected financial-policy caps. |
| Actual extra expense before policy caps | $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; same facts without selected financial-policy caps. |
| Month 1 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 2 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 3 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 4 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 5 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 6 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 7 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 8 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 9 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 10 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 11 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
| Month 12 calculation | $0.00 + $0.00 - $0.00 = $0.00; BI $0.00 + EE $0.00 = $0.00Source: ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; monthly worksheet calculation. |
Applied Formulas
| Label | Formula / Value |
|---|---|
| Step 1 | Build monthly revenue, COGS, categorized operating expenses, payroll, and net profit before tax.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet calculation order. |
| Step 2 | Add continuing expenses, including payroll only on eligible ordinary-payroll days; subtract additional saved expenses once.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet calculation order. |
| Step 3 | Use actual day counts for the 72-hour BI-only waiting period, once. The waiting window is not also subtracted from the restoration clock.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet calculation order. |
| Step 4 | Apply the BI-only fraction separately to each consecutive 30-day eligible window, including a partial first or last window; do not replace this with one global minimum.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet calculation order. |
| Step 5 | Add extra expense without the monthly BI fraction or BI waiting period.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet calculation order. |
| Step 6 | Apply the optional 120-day BI + EE period to the combined period, then the carried limit as the overall as-written cap.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet calculation order. |
| Assumption 1 | Every month is treated as 30 days for monthly-to-daily allocation and restoration-month timing.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet assumption. |
| Assumption 2 | Projected shutdown duration is measured from the loss date. The 72-hour waiting window equals 3 actual day(s), applies to BI only, and is not subtracted twice.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet assumption. |
| Assumption 3 | The projected restoration period starts after the loss-date waiting window for payment eligibility; the interruption/restoration clock itself remains the entered loss duration.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet assumption. |
| Assumption 4 | Ordinary payroll is counted on every eligible day because no optional ordinary-payroll limitation was selected.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet assumption. |
| Assumption 5 | Civil-authority days are limited to four weeks, overlapping direct-loss days are removed once, and those overlap days do not extend the restoration period.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet assumption. |
| Assumption 6 | Extra expense is not reduced by the monthly BI fraction or the BI waiting window.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet assumption. |
| Assumption 7 | The 120-day BI + EE option is not selected.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet assumption. |
| Assumption 8 | Extended business income is not selected; the worksheet does not add a post-restoration extension.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet assumption. |
| Assumption 9 | A reasonable-speed restoration scenario and an accountant's projection are inputs for this illustration, not automatic coverage conclusions.ISO CP 00 30, Business Income Coverage Form; Last reviewed September 16, 2026.; worksheet assumption. |
Policy provisions · Last reviewed September 16, 2026
- ISO CP 00 30: business income waiting period of 72 hours, extended business income of 60 days on current forms (30 on older editions), optional monthly and 120-day maximum periods, and civil authority coverage up to four weeks. ISO CP 15 15 provides the business income worksheet basis. Last reviewed September 16, 2026; read the applicable edition and endorsements.