Child Corporation joined the Thrust consolidated group in year 1. At the time it joined the group, Child held a $2,000,000 NOL carryforward. On a consolidated basis, the members of Thrust generated significant profits for many years.

Child’s operating results during the first few consolidated return years were as follows. The § 382 rules do not apply to the group. All tax years occur after 2017.

Tax Year................Taxable Income
1...................................($ 100,000)
2....................................1,600,000
3....................................1,800,000

a. How will Child’s NOLs affect consolidated taxable income for each of these years?
b. Express your computations for years 2 and 3 as a Microsoft Excel formula.