Formula: Add, Subtract, Multiply; Cell Referencing BE18.6 - Using Excel for Contract Transaction Pricing PROBLEM Nair Corp. enters into a contract with a customer to build an apartment building. The customer hopes to rent apartments at the beginning of the school year and provides a performance bonus to be paid if the building is ready for rental beginning August 1, 2021. The bonus is reduced each week that completion is delayed. Information concerning the contract and bonus amounts are presented here. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area to calculate the first four amounts. Use the SUM function with cell references to calculate the total. Determine the transaction price for this contract. Completed by Contract amount Performance bonus Bonus reduction for delays $ 1,000,000 150,000 50,000 Nair commonly includes these completion bonuses in its contracts and, based on prior experience, estimates the following completion outcomes: August 1 August 8 Completed by August 1, 2021 August 8, 2021 August 15, 2021 After August 15, 2021 Expected Value August 15 After August 15 Total $ Probability 70% 20% 5% 5% PLEASE SHOW THE FORMULAS