3. LO.6 Castle Corporation conducts business and has nexus in States 1, 2, and 3. All of the states use a three-equal-factors apportionment formula, with the factors evenly weighted. Castle generates $555,000 apportionable income and $75,000 allocable income related to State 3 activities. Castle’s sales, payroll, and property are divided evenly among the three states. Compute taxable income for:

a. State 1.

b. State 2.

c. State 3.

d. Express your computation as a Microsoft Excel formula that will provide the correct solution for all three states.