Tilton Company purchased a hazardous chemical detoxification facility for $1,700,000 on April 1, 2019.

Tilton agreed to pay $500,000 cash and issued a promissory note for the balance.

The annual interest rate for the note is 8% and interest is payable annually, on the anniversary date of the purchase. The note matures on April 1, 2023.

As part of the purchase agreement, Tilton has agreed to assume responsibility for the restoration of the property following the closure and decommissioning of the facility.

The initial estimated cost to clean up contamination caused by the location of hazardous chemicals on the property is $1,100,000 (based on the probabilities of the various estimated cash outflows considered), expected to be incurred in 11 years upon the anticipated closure and decommissioning of the facility.

Additional contamination will likely occur each year the plant is in operation. In its first year of operation, additional contamination is expected to add $200,000 (again based on probabilities of estimated cash flows) to the estimated cleanup cost, which would then occur after 10 years because one year of the expected 11 total years of operation will have elapsed.

Using the following template, determine the present value of the initial asset retirement obligation and the monthly accretion expense for the asset retirement obligation for the expected life of the facility. In cell C10 use the Excel function for present value to determine the present value for the asset retirement obligation. Note: Every cell for every month for columns C through F should include a formula.
Month	Date of Entry	Present Value of Asset Retirement Obligation - Beginning	Interest Rate	Accretion Expense	Present Value of Asset Retirement Obligation - Ending
1	30-Apr-19	($0.00)
2	31-May-19

Note: Accretion entries continue for the 11 years the asset is in use. The asset retirement
obligation liability grows to the estimated liability after 11 years and is used
to record the payment for the obligation when satisfied.

there are 130 more rows(132 total) but I didnt include them since it was too long.