Child Corporation joined the Madre 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 Madre generated significant profits for many years.

Child$$s operating results during the first few consolidated return years were as follows.

Tax year $1---$Taxable income of $(100,000)$

Tax year $2----$Taxable income of $1,600,000$

Tax year $3---$Taxable income of $1,800,000$

The $382$ rules do not apply to the group. All tax years occur after $2017.$

How will Child$$s NOLs affect consolidated taxable income for each of these years?

Express your computations for years $2$ and $3$ as a Microsoft Excel formula.