Templates

State Apportionment Workbook

The arithmetic of a multistate corporate return: receipts by destination, shipping point and service location, the federal starting point, the depreciation adjustment, state bases, sales factors with throwback and market or cost-of-performance sourcing, loss caps and suspensions, tax by state and the Texas margin options: ten tabs, one fictional company, no macros.

Enter your own receipts and rules. With the book's case, a manufacturer with $153,000,000 of receipts, the workbook computes an Illinois sales factor of 48.86% with throwback (15.82% without it), a California factor of 20.13%, state taxes of $1,020,000 across four states, 10.76% of federal taxable income, the four Texas margin options and the effect of losing P.L. 86-272 protection in a state. A Checks tab runs 27 checks against the book.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 212 free models.

State_Apportionment_Workbook.xlsx (24 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind the workbook: The State Corporate Income Tax Handbook, PDF and paperback, with the full case, the memo to the CFO and the checklists.

What is in the workbook

Inputs
All case inputs and all rules, one per row, with the source of each rule and the date it was checked. Inputs are in blue.
Receipts
Meters by destination and shipping point, FlowWatch by customer location and by cost of performance, total receipts.
Federal
From pre-tax book income to federal taxable income; the parent's separate income after the royalty.
Depreciation
Federal depreciation with bonus, state depreciation without it, and the adjustment.
Bases
The Illinois, California and Pennsylvania bases, with a switch for adding back the Texas tax.
Factors
Numerators and factors by state, with switches for throwback, the services sourcing rule in Illinois and California, and Indiana protection.
Tax
Apportioned income, losses with the Illinois cap and the California suspension, rates and tax by state; the Texas margin options.
Scenarios
The Indiana scenario, no throwback, cost of performance, three factors and double weighting, no loss limits.
Exposure
Pennsylvania tax for 2024 and 2025 and the matching Illinois refunds.
Checks
Every key output compared with the figure printed in the book, and the message ALL CHECKS OK when they match.

Every assumption is shaded in a light color on the Inputs tab; every other cell is a formula, with no macros, no links to other files and no circular references. Every ratio is guarded against an empty divisor. Replace the inputs with your own company's figures; the Checks tab will then show differences from the book by design.

From The State Corporate Income Tax Handbook. To read: a state apportionment formula example · what P.L. 86-272 protects · the throwback rule.