Function: SUM; Formula: Multiply, Divide; Absolute Cell Referencing

Using Excel to Value Assets Purchased at a Lump$-$Sum Price

PROBLEM

Butcher Inc. purchased land, building, and equipment from

Sutter Co$.$ Information concerning the purchase follows.

Cash payment for assets

$$406,000$

Estimated fair values:

Land

Building

Equipment

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.