Determine the following cash flows (ATCF) - provide in spreadsheet format (BTCF, Taxable Income, Tax and ATCF).

Initial investment of $1,000,000.

Bankrupt Scenario: Bankrupt in 3 years, no payoff.

Break even Scenario: Break even with$1,000,000 in year 3.

Successful Scenario: Payout of $3,000,000 at year 4.

Very Successful Scenario: Payout of $2,000,000 in years 2, 3, 4 and 5.

MARR = 15% and Tax Rate = 30%.