Question

In: Accounting

Sullivan ranch corporation has purchased a new tractor and has provided the information related to the purchase

EXCEL

Sullivan ranch corporation has purchased a new tractor and has provided the information related to the purchase. the controller has asked you to calculate the depreciation for the new piece of equipment using different methods. straight-line depreciation, units of production depreciation, snd double-declining balance depreciation. use the information included in the excel simulation and EXCEL FUNCTION FORMULAS described below to complete the task.

Workbook Views Show Zoom Macros ✓ fx Sullivan Ranch Corporation has purchased a new tractor. The following Sullivan Ranch Cor

Assignment i Saveu в Total $ 140,000 25 Prepare the following Units-of-Production depreciation schedule by entering formulas.

B C Total $ 140,000 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute

Excel Assignment Help Sav Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTIO

Expert Solution

Answer is given below

For excel formulas Screen shot is given

For units of production method absolute reference is used and for DDB method - DDB formula in excel has been used.

Screen shots given for both.

ekkarill92 answered 2 years ago

An owner of a large ranch is considering the purchase of a tractor with a front-end...

An owner of a large ranch is considering the purchase of a tractor with a front-end loader to clean his corrals instead of hiring workers that do it with a pitch fork. He has given you the following information and has asked you to evaluate this investment. The equipment costs $40,000. The rancher expects that he will save $11,500 a year that is usually paid to workers that clean out the corral by hand. However, he will incur an additional...

$ Bonita Corporation purchased a special tractor on December 31, 2017. The purchase agreement stipulated that...

$ Bonita Corporation purchased a special tractor on December 31, 2017. The purchase agreement stipulated that Bonita should pay $19,360 at the time of purchase and $5,450 at the end of each of the next 8 years. The tractor should be recorded on December 31, 2017, at what amount, assuming an appropriate interest rate of 12%? (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 458,581.)

Creighton Corporation is a one product company and has provided the following information related to their...

Creighton Corporation is a one product company and has provided the following information related to their product. Sales price per unit $60 Units produced and sold 2,000 Manufacturing cost: Variable manufacturing cost per unit $20 Fixed manufacturing cost per unit 12 Selling and Administrative cost: Variable S&A cost per unit 10 Fixed S&A cost per unit 6 REQUIRED Prepare a Contribution format income statement for Creighton Corporation. Calculate the break-even point in dollar sales. How many units does Creighton have...

A farm purchased a new tractor for $30,000. They estimated the tractor would have a useful...

A farm purchased a new tractor for $30,000. They estimated the tractor would have a useful life of 5 years and would have a salvage value of $5,000. The farm uses the straight-line method and the half-year convention. The farm sold the tractor during year 3 for $19,000. 1. Compute the amount of depreciation expense to be taken in years 1, 2 and 3 Year 1 Year 2 Year 3 2. Prepare a journal entry to record the sale of...

On December 31, 20X4, Peterson Corporation purchased shares of Sullivan Inc.

ICP 4 On December 31, 20X4, Peterson Corporation purchased shares of Sullivan Inc. by issuing its own shares worth $1,500,000. Peterson’s and Sullivan’s statements of financial position immediately after the purchase transaction were as follows: Peterson Sullivan Sullivan Carrying Carrying Fair value Value value Cash $260,000 $110,000 $110,000 Accounts receivable 670,000 350,000 350,000 Inventory 1,200,000 920,000 1,050,000 Land 800,000 250,000 340,000 Buildings and equipment 2,500,000 700,000 650,000 Investment in Sullivan 1,500,000 $6,930,000 $2,330,000 ...

Your company has purchased a large new truck-tractor for over the road use. It has a...

Your company has purchased a large new truck-tractor for over the road use. It has a cost basis of $209,697. Its MV at the end of 18 years is estimated as $1,271. Assume it will be depreciated using DDB method and the depreciation period is 18 years. What is the depreciation payment in year 4?

Asplund Corporation has provided the following information:

Asplund Corporation has provided the following information: Cost per Unit Cost per Period Direct materials $ 6.25 Direct labor $ 2.90 Variable manufacturing overhead $ 1.30 Fixed manufacturing overhead $ 18,000 Sales commissions $ 1.50 Variable administrative expense $ 0.45 Fixed selling and administrative expense $ 7,500 Required: a. For financial reporting purposes, what is the total amount of product costs incurred to make 5,000 units? b. For financial reporting purposes,...

A construction company needs enough money to purchase a new tractor-trailer in 6 years at a...

A construction company needs enough money to purchase a new tractor-trailer in 6 years at a cost of $450,000. If the company sets aside $175,000 in year 2, $125,000 in year 3, and $75,000 in year 4, how much will the company have to set aside in year 5 to have the money needed in year 6? Assume investments earn 8% per year compounded semi-annually. What is the value of the individual cash flow at year = 1? What semi-annual...

Green Acres Farms just purchased a tractor on January 1, 2020. The total purchase price (cost)...

Green Acres Farms just purchased a tractor on January 1, 2020. The total purchase price (cost) was $600,000. They expect to use the tractor for 5 years and sell for $100,000. Assume according to MACRS, they can depreciate tractors for 3 years using 150% declining balance. Complete the following depreciation questions. PART A Fill in the economic depreciation table using the straight-line method. Year Remaining value at beginning of year Depreciation Remaining value at end of year 2020 [Q30] [Q31]...

On January 1, 2019, Geonosis Corporation purchased a new kyber crystal machine. To finance the purchase,...

On January 1, 2019, Geonosis Corporation purchased a new kyber crystal machine. To finance the purchase, the company borrowed $12,000 and signed a 3-year installment note requiring 4% annual interest. As a result, payments of $4,324.18 must be made at the end of the year for the next three years. The company believes the machine will have a 10-year useful life and a $1,000 residual value. Required: Use the templates provided and labaled in Red/Yellow for each number below. 1....