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. 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: Completed by 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 August 1 August 8 August 15 After August 15 Expected Value Answer Field 22.7% of your score. Formula: Add, Multiply. Cell reference. Use a mathematical formula with cell references to the Problem area. Probability Total August 1, 2021 70% August 8, 2021 20% August 15, 2021 5% After August 15, 2021 5%