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.

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

1. How will Childs NOLs affect consolidated taxable income for each of these years?

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