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.
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.
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.