1. A company bought a machine for BD300,000 which has a useful life of 7 years and can be sold for BD30,000 at the end of its useful life. Determine the a. Depreciation schedules, dn b. Accumulated depreciation, Dn c. Book value, Cn using straight line method and double declining balance method. Generate the plots using Microsoft excel. 2. Repeat problem #1 if there is an installation cost of BD20,000. 3. Repeat problem #1 if there is a dismantling cost of BD5,000.

1. A company bought a machine for BD300,000 which has a useful life of 7 years and can be sold for BD30,000 at the end of its useful life. Determine the a. Depreciation schedules, dn b. Accumulated depreciation, Dn c. Book value, Cn using straight line method and double declining balance method. Generate the plots using Microsoft excel. 2. Repeat problem #1 if there is an installation cost of BD20,000. 3. Repeat problem #1 if there is a dismantling cost of BD5,000.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter9: Depreciation (deprec)

Section: Chapter Questions

Problem 4R: To test your formulas, assume the machine purchased had an estimated useful life of three years...

See similar textbooks

Similar questions

A company bought a machine for BD300,000 which has a useful life of 7 years and can be sold for BD30,000 at the end of its useful life. Determine the Depreciation schedules, dn Accumulated depreciation, Dn Book value, Cn using straight line method and double declining balance method. Generate the plots using Microsoft excel. 2.Repeat problem #1 if there is an installation cost of BD20,000. 3.Repeat problem #1 if there is a dismantling cost of BD5,000.
A company bought a machine for BD300,000 which has a useful life of 7 years and can be sold for BD30,000 at the end of its useful life. Determine the Depreciation schedules, dn Accumulated depreciation, Dn Book value, Cn using straight line method and double declining balance method. Generate the plots using Microsoft excel. Repeat problem #1 if there is an installation cost of BD20,000. Repeat problem #1 if there is a dismantling cost of BD5,000. The coupon interest rate issued by Jordan Company on a 10-year bond is 10%, with a par value of BD1,000 and pays interest semi-annually. The required annual return expected by the company is 12%. Determine the bond’s value?
Consider the following accounting information for a computer system: Cost basis of the asset, I = $10,000, Useful life, N = 5 years, Estimated salvage value, S = $0. Use the double-declining-depreciation method to compute the annual depreciation allowances and the resulting book values.
Modified Accelerated Cost Recovery System (MACRS) (LO 8.2) Calculate the following: Click here to access the various depreciation tables. If required, round your final answers to the nearest dollar. If your answer is zero, enter "0". c. The first year of depreciation on a computer costing $2,800 purchased in May 2020, using the half-year convention and straight-line depreciation with no bonus depreciation.$fill in the blank dfbf18f8d052045_1 d. The third year of depreciation on business furniture costing $10,000 purchased in March 2018, using the half-year convention and accelerated depreciation but no bonus depreciation.$fill in the blank f2779406dfe8021_1
Modified Accelerated Cost Recovery System (MACRS) (LO 8.2) Calculate the following: Click here to access the various depreciation tables. If required, round your final answers to the nearest dollar. If your answer is zero, enter "0". The first year of depreciation on a office building that cost $250,000 purchased June 2, 2022. 4,168 X b. The second year (2023) of depreciation on a computer that cost $5,000 purchased in May 2022, using the half-year convention and accelerated depreciation considering any bonus depreciation taken Ov a. The first year of depreciation on a computer costing $2,800 purchased in May 2022, using the half-year convention and straight-line depreciation with no bonus depreciation 280 b. The third year of depreciation on business furniture costing $10,000 purchased in March 2020, using the half-year convention and accelerated depreciation but no bonus depreciation. 1,748 x
Please complete the answer for this draw also teh diagram like the given example. Determine how much depreciation, at the end of year 3 would a farm machinery have if it was bought at $100,000, using the MACRS method of depreciation. Attached image is the example:
Solve what is ask. Show complete solution. Avoid using Excel. Solve manually. A. The first costs of an equipment is P 65, 000 and a salvage value of P 3, 000 at the end of its 6 years life. Find the total depreciation up to the third year using the Sum of the Years Digit Method. a. 44, 286 b. 38, 148 c. 36, 654 d. 42, 824 B. A man deposits P 1000 at the end of each month for 3 years at a nominal rate of 12% compounded monthly. Compute the future worth of all his payments at the end of 3 years? a. 41 224 b. 36 089 c. 43 077 d. 50 102
in the following table (The annual usage for Asset III is 15,000 miles). (You can copy and paste the following table) Asset Depreciation Method End of Year Initial Cost (I) ($) Salvage Value (S) ($( Book Value ($) Depreciable Life (years or mi) Depreciable Amount ($) Accumulated Depreciation 1 SL 6 $30k $6k $12k 8 years ? ? || DDB 3 $25k $5k $5.4k 5 years ? $19,600 ||| UP 3 $41k $5k ? 90,000 miles 2. IV MACRS 4 $20k $2k $3,456 ? ? ?
Calculate the total cost, total depreciation, and annual depreciation (in $) for the following assets by using the straight-line method. (Round your answers to the nearest cent.) Cost ShippingCharges SetupCharges TotalCost SalvageValue EstimatedUseful Life(years) TotalDepreciation AnnualDepreciation $800,000 0 $15,600 $ $100,000 15 $ $
Shirley is studying depreciation in her engineering management course. The instructor asked her to graphically compare the total percent of first costdepreciated for an asset costing B dollars over a life of n = 5 years for DDB and 125% DB depreciation. Help her by developing the plots of percent of B depreciated versus years. Use a spreadsheet unless instructed otherwise.
How do I solve the following with complete solution in Excel format: An engine bought for Php 1,800,000.00 has a service life of 13 yrs which can then estimated to be valued at Php 500,000.00. Perform all 5 depreciation methods if the interest is 7% compounded annually. The following must be presented: Tabular form in exact order: Year, Depreciation charge on each year, Total depreciation on each year, Book Values Book value curves of each methods all in ONE graph with proper and identifiable labeling.
Consider the following accounting information for a computer system:Cost basis of the asset (I) = $10,000;Useful life (N) = 5 years;Estimated salvage value (S) = $2,000. Compute the annual depreciation allowances and the resulting book values using the double-declining-balance depreciation method.