IV. a. iii. Calculate the cost of the Easement
Estimated time:
1 minutes
With our excel file, we can easily apply simple math functions. In Excel, we can multiply a constant cost per area to the calculated area and develop a cost per parcel. Finally, we can get a sum to account for the total buyout cost of the easement
In this exercise, you will:
- Apply simple functions in Excel
- Create an accumulated cost table
Text Version:
- In Excel, apply the specified cost per square foot to the calculated area
- Label the column to hold the calculated cost
- In the appropriate box, type: “=Cost*Area” (Cost is equal to the cost per area and Area is the value in the Area cell)
- Calculate the sum of the individual costs
- Select the entire list of costs
- Press the “Sum” symbol
(Note: This table will be attached to your memo, so try to make it look sharp)