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?
-
Sales cutoff tests are performed to obtain evidence that sales are recorded in the proper period. You are to perform a cutoff test of sales for a manufacturer that uses pre numbered bills of lading...
-
Use the Chain Rule to find the derivative. y = cos 3 (12)
-
Apple. Apple seeks energetic, dedicated students with a passion to educate others about Apple products. The company prefers students who excel at time management, have a marketing or sales...
-
Clancey Inc. issues $2,000,000 of 7% bonds due in 10 years with interest payable at year-end. The current market rate of interest for bonds of similar risk is 8%. What amount will Clancey receive...
-
The price of a car you want is $39,000 today. Its price is expected to increase by $1000 each year. You now have $23,500 in an investment account, which is earning 11% per year. How many years will...
-
Suppose an investment project costs $100,000 to start in period 0, and we know of the dividends it will return with certainty. The project returns dividends of $0 in period 0, $20,000 in period 1,...
-
Survey Results 100 clients were surveyed in both Year 1 and Year 2. 30 clients gave an average rating in Year 1. Below average ratings in Year 2 dropped to 1/4 of the total from Year 1. 100...
-
On January 1, 2022, Illini Company borrowed $20,000 from a local bank by signing a two-month 12% note. Interest was payable at maturity on February 28, 2022. Based on the information provided, please...
-
Knox Jewelers issued $1,000,000 of 8% interest bearing debt at the beginning of the year. The company reported net income before interest and taxes of $2,000,000 for the current year. Assuming a 40%...
-
The Stewart Company has $1,635,000 in current assets and $604,950 in current liabilities. Its initial inventory level is $343,350, and it will raise funds as additional notes payable and use them to...
-
My student loans totaled $ 8 5 , 0 0 0 , and requires monthly payments of $ 9 4 3 . 6 7 , at a 6 % annual interest rate. How much is interest expense for the first month?
-
The thermite reaction is: 2Al(s) + Fe0,(s) Alz0a(s) + 2Fe(s) Use the thermodynamic quantities provided following problems. in Table III-I to solve the Table III-I: Thermal characteristics of...
-
The table below contains PLASMA concentration-time data for a new medication (LIU987) following administration of a single IV bolus dose (250 mg). Below the table is a Ln C vs time plot of the data....
-
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...
-
Eugene Fama and Robert Shiller recently won the Nobel Prize in economics. Go to http://nobelprize.org/nobel_prizes/economics/ and locate the press release on Eugene Fama and Robert Shiller. What was...
-
Visit the Bloomberg Markets website at www.bloomberg.com/markets/stocks. Their interactive graph allows you to see cumulative returns for individual stocks as well as market indices. Over the last...
-
Compute the price of a share of stock that pays a \($5\) per year dividend and that you expect to be able to sell in one year for \($40\), assuming you require a 5% return.
Study smarter with the SolutionInn App