H Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated Function: SUM; Formula: Multiply. Divide; Cell Referencing BE10.6 - Using Excel to Value Assets Acquired at a Lump- Sum Price PROBLEM Mohave Inc purchased land, building, and equipment from Laguna Corporation Information concerning the purchase follows Cash payment for assets $ 315,000 Estimated fair values Land 60,000 Building 220,000 Equipment 80,000 At what amounts should each of the three assets be recorded? Recorded Amount Fair Value $ 60,000 Land + Building 220,000 5 2 Equipment 80,000 $360,000