Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sullivan Ranch Corporation has purchased a new tractor and has provided you with information about the purchase. The controller has asked you to calculate the
Sullivan Ranch Corporation has purchased a new tractor and has provided you with information about the purchase. The controller has asked you to calculate the depreciation for the new piece of equipment using three different methods: straightline, unitsofproduction, and doubledecliningbalance.
Cost: $
Estimated residual value: $
Estimated life in years:
Estimated life in hours:
Actual hours used:
Year
Year
Year
Year
Here are some tips for using Excel:
Cell References: Never type a number from an Excel sheet elsewhere in the sheet. Instead, type an equals sign and then click the cell that includes the number. For example, B would return the number from B
Basic Math Functions: Use symbols to add, subtract, multiply, and divide in Excel. Do not do any calculations by hand.
SUM Function: This function sums multiple cells. You can enter individual cell references or ranges. For example, SUMCCC and SUMC:C will both return the value of CCC
SLN Function: This function calculates depreciation expense using the straightline method. The syntax of the SLN function is SLNcostsalvage,life Enter the asset's cost, salvage value, and useful life.
DDB Function: This function calculates depreciation expense using the doubledeclining balance method. The syntax of the DDB function is DDBcostsalvage,life,period Enter the asset's cost, salvage value, useful life, and the period number you are calculating depreciation for.
Required:
Prepare the following depreciation schedule using the SLN function.
You must use absolute cell references $ if a cell reference is repeated multiple times across different cells' formulas.
SULLIVAN RANCH CORPORATION
Depreciation Schedule: StraightLine Method
EndofYear Amounts
Year Depreciation Expense Accumulated Depreciation Book Value
$ $ $
$ $ $
$ $ $
$ $ $
Total $
Prepare the following depreciation schedule using the unitsofproduction method. Use the formula from the Chapter notes.
You must use absolute cell references $ if a cell reference is repeated multiple times across different cells' formulas.
SULLIVAN RANCH CORPORATION
Depreciation Schedule: UnitsofProduction Method
EndofYear Amounts
Year Depreciation Expense Accumulated Depreciation Book Value
$ $ $
$ $ $
$ $ $
$ $ $
Total $
Prepare the following depreciation schedule using the Excel DDB function.
You must use absolute cell references $ if a cell reference is repeated multiple times across different cells' formulas.
SULLIVAN RANCH CORPORATION
Depreciation Schedule: DoubleDecliningBalance Method
EndofYear Amounts
Year Depreciation Expense Accumulated Depreciation Book Value
$ $ $
$ $ $
$ $ $
$ $ $
Total $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started