Sullivan Ranch Corporation has purchased a new tractor. The following information is given: Cost: $ 150,000 Estimated Residual: $ 10,000 Estimated Life in years: 4 Estimated Life in hours: 1200 Actual Hours: Year 1 360 Year 2 270 Year 3 350 Year 4 220 2 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Depreciation Expense Accumulated Year Book Value Depreciation 1 3 4 Total Prepare the following Activity-Based depreciation schedule by entering formulas. 5 Use absolute cell references when appropriate. SULLIVAN RANCH CORPORATION Depreciation Schedule-Units-of-Production Method End of year amounts Accumulated Depreciation Expense Year Book Value Depreciation 1 3 4 Total Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method End of year amounts Depreciation Expense Accumulated Year Book Value Depreciation 1 3 4 Total
Sullivan Ranch Corporation has purchased a new tractor. The following information is given: Cost: $ 150,000 Estimated Residual: $ 10,000 Estimated Life in years: 4 Estimated Life in hours: 1200 Actual Hours: Year 1 360 Year 2 270 Year 3 350 Year 4 220 2 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Depreciation Expense Accumulated Year Book Value Depreciation 1 3 4 Total Prepare the following Activity-Based depreciation schedule by entering formulas. 5 Use absolute cell references when appropriate. SULLIVAN RANCH CORPORATION Depreciation Schedule-Units-of-Production Method End of year amounts Accumulated Depreciation Expense Year Book Value Depreciation 1 3 4 Total Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method End of year amounts Depreciation Expense Accumulated Year Book Value Depreciation 1 3 4 Total
Century 21 Accounting Multicolumn Journal
11th Edition
ISBN:9781337679503
Author:Gilbertson
Publisher:Gilbertson
Chapter19: Accounting For Plant Assets, Depreciation, And Intangible Assets
Section19.5: Declining-balance Method Of Depreciation
Problem 1WT
Related questions
Question
![1. Prepare depreciation schedules using Straight-Line, Units-of-Production, and Double-Declining Balance Depreciation.
Finance Depreciation Schedules - Excel
Sign In
FILE
НOМE
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Calibri
-11
Alignment Number Conditional Format as Cell
Formatting Table Styles -
Paste
в I U
A.
Cells
Editing
Clipboard
Font
Styles
A1
fx
Sullivan Ranch Corporation has purchased a new tractor. The following
A
D
F
1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given:
2
$ 150,000
10,000
3 Cost:
4 Estimated Residual:
5 Estimated Life in years:
4
6 Estimated Life in hours:
1200
7 Actual Hours:
Year 1
360
9.
Year 2
270
10
Year 3
350
11
Year 4
220
12
Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the
13
Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell
references for the remaining cells.
14
15
16
SULLIVAN RANCH CORPORATION
17
Depreciation Schedule-Straight Line Method
18
End of
year amounts
Depreciation
Expense
Accumulated
19
Year
Book Value
Depreciation
20
21
2
22
3
23
4
24
Total
25 Prepare the following Activity-Based depreciation schedule by entering formulas.
26 Use absolute cell references when appropriate.
27
SULLIVAN RANCH CORPORATION
Depreciation Schedule-Units-of-Production Method
End of year amounts
28
29
Depreciation
Expense
Accumulated
Year
Book Value
Depreciation
31
32
2
33
3
34
4
35
Total
36
Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to
37
calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell
references for the remaining cells.
38
39
40
SULLIVAN RANCH CORPORATION
41
Depreciation Schedule-Double-Declining-Balance Method
42
End of
year
amounts
Depreciation
Expense
Accumulated
43
Year
Book Value
Depreciation
44
45
2
46
3
47
4
48
Total
49
50
51
52
Sheet1
READY
100%
30](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2026c0b0-7b1d-4913-b534-a9aba708cafe%2F02ca1ab6-9e17-4b66-83dc-ca6802df5f61%2Fxt6y7t6.jpeg&w=3840&q=75)
Transcribed Image Text:1. Prepare depreciation schedules using Straight-Line, Units-of-Production, and Double-Declining Balance Depreciation.
Finance Depreciation Schedules - Excel
Sign In
FILE
НOМE
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Calibri
-11
Alignment Number Conditional Format as Cell
Formatting Table Styles -
Paste
в I U
A.
Cells
Editing
Clipboard
Font
Styles
A1
fx
Sullivan Ranch Corporation has purchased a new tractor. The following
A
D
F
1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given:
2
$ 150,000
10,000
3 Cost:
4 Estimated Residual:
5 Estimated Life in years:
4
6 Estimated Life in hours:
1200
7 Actual Hours:
Year 1
360
9.
Year 2
270
10
Year 3
350
11
Year 4
220
12
Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the
13
Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell
references for the remaining cells.
14
15
16
SULLIVAN RANCH CORPORATION
17
Depreciation Schedule-Straight Line Method
18
End of
year amounts
Depreciation
Expense
Accumulated
19
Year
Book Value
Depreciation
20
21
2
22
3
23
4
24
Total
25 Prepare the following Activity-Based depreciation schedule by entering formulas.
26 Use absolute cell references when appropriate.
27
SULLIVAN RANCH CORPORATION
Depreciation Schedule-Units-of-Production Method
End of year amounts
28
29
Depreciation
Expense
Accumulated
Year
Book Value
Depreciation
31
32
2
33
3
34
4
35
Total
36
Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to
37
calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell
references for the remaining cells.
38
39
40
SULLIVAN RANCH CORPORATION
41
Depreciation Schedule-Double-Declining-Balance Method
42
End of
year
amounts
Depreciation
Expense
Accumulated
43
Year
Book Value
Depreciation
44
45
2
46
3
47
4
48
Total
49
50
51
52
Sheet1
READY
100%
30
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
![Cornerstones of Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
![Survey of Accounting (Accounting I)](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
![Cornerstones of Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
![Survey of Accounting (Accounting I)](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
![Financial Accounting: The Impact on Decision Make…](https://www.bartleby.com/isbn_cover_images/9781305654174/9781305654174_smallCoverImage.gif)
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College