Please solve before 11:45 pm ET using financial formulas in Excel a) Bisselll guarantees its carpet cleaners will work for one year after purchase with normal, non-commercial use.

If the carpet cleaner fails in the first year, Bissell will replace/fix the carpet cleaner at an authorized location free under warranty. Bissell predicts it has 450,000 carpet cleaners covered by their 1 year warranty on the year ended 12/31/2013. Bissell predicts that 0.5% of covered carpet cleaners will need repair under warranty; the estimated cost is $250 per repair claim.

Calculate the accrued warranty liability for the year ended 12/31/2013.

Please solve using Excel financial formulas wherever it applies and show work in Excel. b) Anderson Construction sets up a contract with Rental Equities.

Anderson Construction usually finishes half their projects on time.

Under Anderson Construction's contract with Rental Equities, Rental Equities will pay $9,000,000 for the project. If Anderson Construction finishes on time, Rental Equities will also pay a bonus of $90,000.

Calculate the contract price considering revenue recognition theory under from GAAP.

Please solve using Excel financial formulas wherever it applies and show work in Excel.