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?
-
The Zone Fitness Center is planning its cash payments for operations for the fourth quarter (OctoberDecember), 2007. The Accrued Expenses Payable balance on October 1 is $21,400. The budgeted...
-
The drawing shows three particles that are moving with different velocities. Two of the particles have mass m, and the third has a mass 2m. At the instant shown, the center of mass (cm) of the three...
-
You have been meeting with a potential new customer regularly for three months. She likes the product but finally admits a loyalty to the existing supplier. The buyer says, I have known Judith...
-
Redraft the following issues in the format presented in this chapter. Part A Can a bystander who witnesses the death of a victim from three blocks away recover for negligent infliction of emotional...
-
Image transcription text Engineering Feats and Disasters Presentation . 5 Minute Presentation (with Powerpoint and/or other visuals) . Capture the key information . What happened? . Why did happen? ....
-
Bob purchased a property for $6,500,000 at a 5.50% cap rate. At the time of purchase, there were 15 years remaining on the lease with 7.50% rent increases every 5 years. Bob purchased the above...
-
The company requires one workforce for every 10 products to be produced. Each workforce will be paid RM1,500/month with regular working hour per month is 40 hours, with an allowable 10 hours of...
-
Describe the accounting for a convertible bond. Can the conversion ever result in the recognition of a gain in the income statement?
-
What is the difference between a spin-off and a split-off? Under what circumstances can either result in the recognition of a gain in the income statement?
-
Employee stock options potentially dilute earnings per share (EPS). What can companies do to offset these dilutive effects and how might this action affect the balance sheet?
-
Analysts attempt to identify transitory items in an income statement. Define transitory items. What is the purpose of identifying transitory items?
-
Explain how we account for a cost that creates an immediate benefit versus a cost that creates a future benefit.
-
If the charge on an electron is 1.6 x 10 -19 coulombs, how many electrons should pass through a conductor in 1 second to constitute 1 ampere current ?
-
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...
-
Obtain the time variation of the lift and propulsive force coefficients and their plots for the airfoil given by Example 8.5. Assume that the profile pitches about quarter chord point. Example 8.5...
-
Write down a numerical solution algorithm for the LU decomposition solution of the pseudo penta diagonal matrix equation given by (A11.4). A11.4 || B C 2 A2 B2 C2 922 An-1 Bn-1 Cn-1 -1 An Bn R R Rn-1...
-
Obtain Eq. 8.66 as a relation between the wake vorticity and the reduced circulation. Eq. 8.66 w(x) = k(Q; cosx-22, sin x) cos ks +k(Q; sin x+Q, cos x) sinks, Q = Q, +Q;i
Study smarter with the SolutionInn App