ABC Corporation, Inc. begins year 1 with 600,000 of Accumulated E&P.Determine current and accumulated E&P for the end of years 1, 2, & 3 with the following data:

YEAR 1YEAR 2YEAR 3

Taxable Income(loss)450,000(150,000)300,000

Installment Sale in year 1 AR 1,000,000, adjusted basis 600,000

Taxes paid140,000 093,000

Insurance Premiums100,000120,00095,000

Life Insurance Death benefit0250,000100,000

Tax Exempt Income85,00020,00050,000

Total Meal & Entertainment20,00026,00012,000

Section 179 Expense100,00020,000100,000

Capital Loss Cf(75,000)

Capital Gain 25,00055,00010,000

Capital Loss(35,000)

NOL Carryforward140,000

Distributions1,000,000200,000210,000

I need help solving this question showing calculations using Excel spreadsheet for each year show end of year earnings and profit, beginning of year Accumulated E&P, current year E&P, and treatment of distribution. The major part where i need help the putting it all in excel.

Please help with this problem, Thanks!