Cost: Estimated Residual: Estimated Life in years: Estimated Life in hours: Actual Hours: Year 1 Year 2 Year 3 Year 4 $ $ 150,000 10,000 4 1200 360 270 350 220

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
NEED CALCULATIONS NOT JUST NUMBERS PLEASE Don't give answer in image
B Cost:
Estimated Residual:
5 Estimated Life in years:
5 Estimated Life in hours:
B
9
0
1
2
4
Sullivan Ranch Corporation has purchased a new tractor. The following information is given:
$
$
5
6
7
8
9
0
1
2
Actual Hours:
Year 1
Year 2
Year 3
Year 4
Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the
3 Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for
the remaining cells.
150,000
10,000
4
1200
Year
1
2
3
360
270
350
220
SULLIVAN RANCH CORPORATION
Depreciation Schedule-Straight Line Method
End of year amounts
Depreciation
Expense
Accumulated
Depreciation
Book Value
Transcribed Image Text:B Cost: Estimated Residual: 5 Estimated Life in years: 5 Estimated Life in hours: B 9 0 1 2 4 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: $ $ 5 6 7 8 9 0 1 2 Actual Hours: Year 1 Year 2 Year 3 Year 4 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the 3 Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 150,000 10,000 4 1200 Year 1 2 3 360 270 350 220 SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Depreciation Expense Accumulated Depreciation Book Value
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Depreciation Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education