Question

In: Accounting

#1: Prepare a depreciation schedule: Z Company's fiscal year runs July 1st to June 30th. The...

#1: Prepare a depreciation schedule:

Z Company's fiscal year runs July 1st to June 30th. The company purchased a new machine which was installed and operational at the beginning of the second quarter in October. Machine purchase price of $145,800 with an additional installation cost of $10,000, and has an estimated useful life of four years from installation and estimated salvage value of $5,600.

Required:

1. Prepare a depreciation schedule showing Net Book value (beginning and ending), depreciation expense, and accumulated depreciation for the asset. Hint: pay attention to dates of acquisition and fiscal year.

Prepare one schedule for each method:

a. Straight-line

b. Double-declining balance

2. Z Company receives an offer of $45,000 for the machine at the end of the third fiscal year.

a. What factors should Z Company consider in determining whether to sell or keep the machine?

b. Assume the machine is sold. Prepare the appropriate journal entry showing sale of the machine and disposition of asset under each depreciation schedule.

Solutions

Expert Solution

  • All working forms part of the answer
  • Amounts are in $
  • Working for both methods of Depreciation

Working

Amount ($)

A

Purchase cost on 1 Oct

145800

B

Add: installation cost

10000

C=A+B

Cost to be capitalised

$155800

D

Less: Salvage value

5600

E=C-D

Depreciable base

$150200

F

Useful life (in years)

4

G=E/F

Annual Straight Line Depreciation

$37550

H=G/E

SLM Rate

25%

I=H x2

Double declining balance

50%

  • Straight Line Depreciation Schedule

Year

Opening book Value

Depreciation expense

Closing Book Value

Accumulated Depreciation

1 (3 quarters)

155800

[37550 x9/12months] 28162.5

127637.5

28162.5

2

127637.5

37550

90087.5

65712.5

3

90087.5

37550

52537.5

103262.5

4

52537.5

37550

14987.5

140812.5

5 (1 quarter)

14987.5

[37550 x 3/12months] 9387.5

5600

150200

$150200

  • Double declining balance Schedule

Year

Opening Balance

Depreciation rate

Depreciation expense

Closing Net Book Value

Accumulated Depreciation

1 (3 quarters)

155800

50%

([155800 x 50%]x9/12) 58425

97375

58425

2

97375

50%

48688

48688

107113

3

48687.5

50%

24344

24344

131456

4

24343.75

50%

12172

12172

143628

5 (1 quarter)

12171.88

6572

5600

150200

$150200

  • Answer to 2 (a)

Z Company should see if the depreciated book value is less or more than the consideration.

Also, it should consider, whether the machine will be as efficient as it is expected or its better to sell it off.

  • Answer to 2 (b) : Journal Entries in both the methods

Straight Line Method

As per working above, net book value at the end of 3rd year is $52537.5. Sold at $45000. Hence loss is of $7537.5

General Journal

Dr (in $)

Cr (in $)

Cash

45000

Accumulated Depreciation

103262.5

Loss on Sale of machine

7537.5

Machine

155800

Double Declining Balance Method

As per working above, net book value at the end of 3rd year is $24344. Sold at $45000. Hence gain is of $20656

General Journal

Dr (in $)

Cr (in $)

Cash

45000

Accumulated Depreciation

131456

Machine

155800

Gain on Sale of Machine

20656


Related Solutions

Martha Ltd has a year ended 30th June. On 1st July 2015 the company, owned equipment...
Martha Ltd has a year ended 30th June. On 1st July 2015 the company, owned equipment that originally cost £650,000 and for which accumulated depreciation of £200,000 had been provided. On 4th October 2015 a piece of equipment, which was originally purchased for £95,000 on 1st October 2013, was sold for £18,000. It is the accounting policy of the company to depreciate equipment by 25% using the reducing balance method, charging a full year’s depreciation in the year of acquisition...
At 1st July 2017 a company's allowance for receivable was $48,000. At 30 June 2018, trade...
At 1st July 2017 a company's allowance for receivable was $48,000. At 30 June 2018, trade receivable amounted to $838,000. It was decided to write off $72,000 of these debts and adjust the allowance for receivables to $60,000. What are the final amount of Receivable net of allowance for inclusion in the company's Statement of Financial position at 30 June 2018?
Prepare the company's direct materials purchases budget and schedule of expected cash disbursements for materials for the upcoming fiscal year.
The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year:   1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 5,000 8,000 7,000 6,000 In addition, 6,000 grams of raw materials inventory is on hand at the start of the 1st quarter and the beginning accounts payable for the 1st quarter is $2,880. Each unit requires 8 grams of raw material that costs $1.20...
Part 1: Prepare a depreciation schedule showing depr. exp., accumulated depreciation and ending book value, year-by-year....
Part 1: Prepare a depreciation schedule showing depr. exp., accumulated depreciation and ending book value, year-by-year. 3 schedules for the 3 methods: straight-line, units-of-production, double declining basis. Asset is a delivery Truck. Est. Life … 4 Orig. Cost Basis 26,300.00 Est. Residual Value 1,500.00 Est. total mileage 100,000 miles driven, Yr 1 23,400 miles driven, Yr 2 20,100 miles driven, Yr 3 33,100 miles driven, Yr 4 23,400 Part 2: Assuming the truck is sold at the end of yr....
Prepare a schedule of depreciation​ expense, accumulated​ depreciation, and book value per year for the equipment...
Prepare a schedule of depreciation​ expense, accumulated​ depreciation, and book value per year for the equipment under the three depreciation​ methods: straight-line,​ units-of-production, and​ double-declining-balance. Show your computations. ​Note: Three depreciation schedules must be prepared. 2. Which method tracks the wear and tear on the equipment most​ closely? Mama'sMama's Fried Chicken bought equipment on JanuaryJanuary 22, 20182018, for $ 18 comma 000$18,000. The equipment was expected to remain in service for four years and to operate for 3 comma 0003,000...
1. ) Prepare a depreciation schedule for the assets in the following transactions using the straight...
1. ) Prepare a depreciation schedule for the assets in the following transactions using the straight line method of depreciation: A. Flash Enterprises purchased 3 new delivery trucks at a cost of $45,000 each. Each truck has an estimated useful life of 5 years. B. Flash needed a new forklift to be used in warehouse operations at a cost of $12,500. The old forklift was traded in for $1,500. The new forklift has an estimated useful life of 4 years....
Prepare a retained earnings statement for the fiscal year ended June 30,20Y5
Rockwell Inc, reported the following results for the year ended June 30,20Y5ParticularsAmount$Retained earnings July 1,20Y43,900,000Net income7,14,000Cash dividends declared1,00,000Stock dividends declared50,000
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 35,000 37,000 28,000 33,000 The company’s variable selling and administrative expense per unit is $3.40. Fixed selling and administrative expenses include advertising expenses of $12,000 per quarter, executive salaries of $53,000 per quarter, and depreciation of $34,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 21,000 28,000 19,000 19,000 The company’s variable selling and administrative expense per unit is $2.00. Fixed selling and administrative expenses include advertising expenses of $14,000 per quarter, executive salaries of $41,000 per quarter, and depreciation of $20,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 31,000 33,000 24,000 29,000 The company’s variable selling and administrative expense per unit is $3.00. Fixed selling and administrative expenses include advertising expenses of $8,000 per quarter, executive salaries of $50,000 per quarter, and depreciation of $30,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT