Thank you :)

Formula Add, Subtract, Multiply; Cell Referencing Student Work Area BE18.6 - Using Excel for Contract Transaction Pricing PROBLEM 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. 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. Determine the transaction price for this contract. Expected Value Completed by August 1 Contract amount Performance bonus Bonus reduction for delays $ 1,000,000 150,000 50,000 August 8 August 15 Nair commonly includes these completion bonuses in its contracts and, based on prior experience, estimates the following completion outcomes: After August 15 Total Probability 70% Completed by August 1, 2021 August 8, 2021 August 15, 2021 After August 15, 2021 20% 5% 5%