Question

In: Accounting

On January 1, Vixen, Inc. purchased a new sleigh packing machine, costing $62,500, by signing a...

On January 1, Vixen, Inc. purchased a new sleigh packing machine, costing $62,500, by signing a promissory note with 7-year, 4.75% terms with biannual payments. Show the entire amortization schedule and highlight the total, interest and principal payment for payment number 13. Also, specify what year/month this payment occurs.

Solutions

Expert Solution

Payments are done biannual, therefore interest rate for a period (semi- annual)

= 4.75/2 = 2.375%

Total Installment = 7 x 2 = 14

Discounting Factor @ 2.375%

1 0.9768
2 0.9541
3 0.9320
4 0.9104
5 0.8893
6 0.8686
7 0.8485
8 0.8288
9 0.8096
10 0.7908
11 0.7724
12 0.7545
13 0.7370
14 0.7199
PVAF 11.7928

Amount of each installment = 62500/ PVAF

= 62500 / 11.7928 = $ 5300

Amortization Schedule:

Year Date Principal Amount Interest @ 2.375% Payment Closing Balance
Year 1 31st June 62500 1484 5300 58685
31st Dec 58685 1394 5300 54778
Year 2 31st June 54778 1301 5300 50780
31st Dec 50780 1206 5300 46686
Year 3 31st June 46686 1109 5300 42495
31st Dec 42495 1009 5300 38204
Year 4 31st June 38204 907 5300 33812
31st Dec 33812 803 5300 29315
Year 5 31st June 29315 696 5300 24711
31st Dec 24711 587 5300 19998
Year 6 31st June 19998 475 5300 15173
31st Dec 15173 360 5300 10234
Year 7 31st June 10234 243 5300 5177
31st Dec 5177 123 5300 0
Total Interest 11698

Related Solutions

On January 1, Vixen, Inc. purchased a new sleigh packing machine, costing $62,500, by signing a...
On January 1, Vixen, Inc. purchased a new sleigh packing machine, costing $62,500, by signing a promissory note with 7-year, 4.75% terms with biannual payments. Show the entire amortization schedule and highlight the total, interest and principal payment for payment number 13. Also, specify what year/month this payment occurs. please show on excel
1)Cane Inc purchased a machine costing $80,000 on January 2nd of year 1. The machine is...
1)Cane Inc purchased a machine costing $80,000 on January 2nd of year 1. The machine is expected to last 9 years with a salvage value of $8,000. Cane sold the machine for $65,000 on July 1st of year 3. What was the gain or loss recognized on the sale? $7,222 loss $5,000 loss $7,222 gain $5,000 gain 2.)Rider Inc purchased a machine costing $70,000 on January 3rd. The machine is expected to last 10 years and 10,000 hours with a...
On January 1, Year 1, Dunn Brothers, Inc., purchased a new smartphone case making machine at...
On January 1, Year 1, Dunn Brothers, Inc., purchased a new smartphone case making machine at a cost of $44,000. The estimated residual value was $5,000. Assume that the estimated useful life was four years and the estimated productive life of the machine was 390,000 units. Actual annual production was as follows: Year Units 1 117,000 2 85,800 3 107,250 4 79,950 Required: a. Calculate depreciation expense under the Straight-line method for Years 1 to 4. b. Calculate depreciation expense...
1. On January 1, 2015, Reno Inc. purchased a machine for $150,000. The machine has an...
1. On January 1, 2015, Reno Inc. purchased a machine for $150,000. The machine has an estimated five year life, and no residual value. Double declining balance depreciation has been used for financial statement reporting and CCA for income tax reporting. Effective January 1, 2018, Reno decided to change to straight-line depreciation for this machine, and treated the change as a change in accounting policy. For calendar 2018, Reno’s pre-tax income before depreciation on this asset is $125,000. Their income...
SBS Company purchased a new machine on January 1, at a cost of $420,000. The machine...
SBS Company purchased a new machine on January 1, at a cost of $420,000. The machine has an expected useful life of four years and an expected salvage value of $40,000. The company expects to use the machine for 1,300 hours in the first year, 1,900 hours in the second year, and 900 hours in the third and fourth year, respectively. (a) Calculate Depreciation Expenses for each year using Straight-Line Method Year Depreciation Expenses 1 $ 2 $ 3 $...
Duluth Ranch, Inc. purchased a machine on January 1, 2018. The cost of the machine was...
Duluth Ranch, Inc. purchased a machine on January 1, 2018. The cost of the machine was $30,500. Its estimated residual value was $9,500 at the end of an estimated 5-year life. The company expects to produce a total of 10,000 units. The company produced 1,150 units in 2018 and 1,600 units in 2019. Required: a. Calculate depreciation expense for 2018 and 2019 using the straight-line method. b. Calculate the depreciation expense for 2018 and 2019 using the units-of-production method. c....
Duluth Ranch, Inc. purchased a machine on January 1, 2018. The cost of the machine was...
Duluth Ranch, Inc. purchased a machine on January 1, 2018. The cost of the machine was $32,000. Its estimated residual value was $10,000 at the end of an estimated 5-year life. The company expects to produce a total of 20,000 units. The company produced 1,200 units in 2018 and 1,650 units in 2019. Required: Calculate depreciation expense for 2018 and 2019 using the straight-line method. Calculate the depreciation expense for 2018 and 2019 using the units-of-production method. Calculate depreciation expense...
Duluth Ranch, Inc. purchased a machine on January 1, 2018. The cost of the machine was...
Duluth Ranch, Inc. purchased a machine on January 1, 2018. The cost of the machine was $38,000. Its estimated residual value was $12,000 at the end of an estimated 5-year life. The company expects to produce a total of 20,000 units. The company produced 1,400 units in 2018 and 1,850 units in 2019. Required: Calculate depreciation expense for 2018 and 2019 using the straight-line method. Calculate the depreciation expense for 2018 and 2019 using the units-of-production method. Calculate depreciation expense...
Duluth Ranch, Inc. purchased a machine on January 1, 2018. The cost of the machine was...
Duluth Ranch, Inc. purchased a machine on January 1, 2018. The cost of the machine was $36,500. Its estimated residual value was $11,500 at the end of an estimated 5-year life. The company expects to produce a total of 10,000 units. The company produced 1,350 units in 2018 and 1,800 units in 2019. Required: Calculate depreciation expense for 2018 and 2019 using the straight-line method. Calculate the depreciation expense for 2018 and 2019 using the units-of-production method. Calculate depreciation expense...
On January 1, 2020, Concord Corporation purchased a new machine for $4130000. The new machine has...
On January 1, 2020, Concord Corporation purchased a new machine for $4130000. The new machine has an estimated useful life of nine years and the salvage value was estimated to be $143000. Depreciation was computed using the sum-of-the-years'-digits method. What amount should be shown in Concord's balance sheet at December 31, 2021, net of accumulated depreciation, for this machine? $2535200 $3987000 $3332600 $2623800
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT