Sullivan Ranch Corporation has purchased a new tractor. The following information is given: $150,000 $10,000 Cost:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sullivan Ranch Corporation has purchased a new tractor. The following information is given: $150,000 $10,000 Cost: Estimated Residual: Estimated Life in years: Estimated Life in hours: Actual Hours: Year 1 Year 2 Year 3 Year 4 1200 360 270 350 220 Required: 1. Prepare the following Straight-Line depreciation schedule by using the Excel SLN function to calculate Depreciation Expense and entering formulas for the remaining cells. Use absolute cell references when appropriate. Depreciation Schedule-Straight-Line Method End of year amounts Depreciatio Depreciatio n Expense n $42,000 Year 1 2 WN 3 $31,500 $40,833 $25,667 $25,667 2. Prepare the following Activity Based depreciation schedule by entering formulas. Use absolute cell references when appi (Use cells A4 to B12 from the given information to complete this question.) 4 Total SULLIVAN RANCH CORPORATION Year 1 $42,000 $73,500 $114,333 $140,000 2 3 4 Total SULLIVAN RANCH CORPORATION Depreciation Schedule-Activity Based Method End of year amounts Book Value $108,000 $76,500 $35,667 $10,000 Depreciatio Depreciatio n Expense n Book Value 3. Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB function to calculate Depreciation Expense and entering formulas for the remaining cells. Use absolute cell references when appropriate. (Use cells A4 to B12 from the given information to complete this question.) SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method End of year amounts Year 1 2 3 4 Total Depreciatio Depreciatio n Expense n Book Value Sullivan Ranch Corporation has purchased a new tractor. The following information is given: $150,000 $10,000 Cost: Estimated Residual: Estimated Life in years: Estimated Life in hours: Actual Hours: Year 1 Year 2 Year 3 Year 4 1200 360 270 350 220 Required: 1. Prepare the following Straight-Line depreciation schedule by using the Excel SLN function to calculate Depreciation Expense and entering formulas for the remaining cells. Use absolute cell references when appropriate. Depreciation Schedule-Straight-Line Method End of year amounts Depreciatio Depreciatio n Expense n $42,000 Year 1 2 WN 3 $31,500 $40,833 $25,667 $25,667 2. Prepare the following Activity Based depreciation schedule by entering formulas. Use absolute cell references when appi (Use cells A4 to B12 from the given information to complete this question.) 4 Total SULLIVAN RANCH CORPORATION Year 1 $42,000 $73,500 $114,333 $140,000 2 3 4 Total SULLIVAN RANCH CORPORATION Depreciation Schedule-Activity Based Method End of year amounts Book Value $108,000 $76,500 $35,667 $10,000 Depreciatio Depreciatio n Expense n Book Value 3. Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB function to calculate Depreciation Expense and entering formulas for the remaining cells. Use absolute cell references when appropriate. (Use cells A4 to B12 from the given information to complete this question.) SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method End of year amounts Year 1 2 3 4 Total Depreciatio Depreciatio n Expense n Book Value
Expert Answer:
Related Book For
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these accounting questions
-
Sullivan ranch corporation has purchased a new tractor on Jan 1, year 1 paying 10% of the purchase price in cash and signing a 2 year note for the balance. The following information is given: Cost:...
-
The following information is based on independent random samples taken from two normally distributed populations having equal variances: Based on the sample information, determine the 90% confidence...
-
The following information is based on independent random samples taken from two normally distributed populations having equal variances: Based on the sample information, determine the 95% confidence...
-
What would a profile look like across a restraining bend? Releasing bend?
-
Comprehensive Accounting Change and Error Analysis Problem Botticelli Inc. were organized in late 2008 to manufacture and sell hosiery. At the end of its fourth year of operation, the company has...
-
The following table is similar to Table 17.2, except that it includes the earnings of Asian males and females. Does the fact that Asian males are the highest-earning group in the table affects the...
-
Juliana is considering an investment proposal with the following cash flows: Required a. Determine the payback period b. Determine the accounting rate of return on initial investment c. Determine the...
-
You can form a portfolio of two assets, A and B, whose returns have the following characteristics: If you demand an expected return of 12%, what are the portfolio weights? What is the portfolios...
-
Question 23 < > Find the commission. Round to the nearest cent. Sale: $2900 Commission rate: 6% Commission amount: $
-
Par Corporation acquired all the stock of Sad Corporation on January 1, 2011, for $280,000 cash, when the book values and fair values of Sad's assets and liabilities were as follows (in thousands):...
-
The partnership of Bramble, Sunland, and Coronado engaged you to adjust its accounting records and convert them uniformly to the accrual basis in anticipation of admitting Kerns as a new partner....
-
Healthcare marketing did not exist prior to 1970. Marketing was "product oriented," prior to the 70's. Health care is something everyone needed and one decided to use the services or not (Thomas,...
-
Problem 1: (Inertia tensor I) Calculate the inertia tensor for (a) A single mass m with coordinates (x, y, z) = (0, yo, 2o). (b) The same as (a) but with a second equal mass placed at (0, yo,zo).
-
How do epistemological frameworks inform the attainment of intellectual perspicacity, and to what extent does the obfuscation of ontological principles impede the elucidation of complex phenomena ?
-
Night 'N Days, a clothing resale store, employs one salesperson, Daisy Hadley. Hadley's straight-time wage is $50 per hour, with time-and-a-half pay for hours above 40. Night 'N Days withholds income...
-
For a recent time period, the following information is given about Mantix, Inc: Sales = $5,000,000 Total Variable costs = $3,400,000 Total Fixed costs = $1,500,000 Assume that cost patterns will...
-
Plug Corporation holds 80 percent of Socket Company??s commonstock. The following balance sheet data are presented for December31, 20X7:Plug CorporationSocket CompanyAssetsCash$ 10 2 answers
-
What tools are available to help shoppers compare prices, features, and values and check other shoppers opinions?
-
You and Laura Cooper are the two partners of a PA firm in Ottawa. After your two-week Caribbean vacation, you return to the office to discover that your secretary is busily preparing to mail some...
-
Assume you audited control compliance in the Kingston Company for the deviations related to a random selection of sales transactions, as shown in Exhibit EP 10-4. For different sample sizes, the...
-
The Patrick Company had poor internal control over its cash transactions. Facts about its cash position at November 30 were the following: The cash books showed a balance of $18,901.62, which...
-
What is the popular saying on which the cash flow fade method is founded?
-
Should the buyers costs be separated from the target companys costs in the cost savings that come out of a merger of two companies?
-
What is the cost of capital equal to?
Study smarter with the SolutionInn App