Question

In: Finance

Calculate depreciation (create schedule - excel is fine) of an asset costing $5,000,000, depreciating at a...

Calculate depreciation (create schedule - excel is fine) of an asset costing $5,000,000, depreciating at a rate of 10% per annum (diminishing value), having a life of 12 years and salvage value of $900,000 at the end of life.

Please show working out / formulas used.

Solutions

Expert Solution

Calculation of Depreciation as per Diminishing Value Method
Year Value of Assest (A) Rate of Dep. (B) Amount of Dep (At the End of Year) Closing Value of Assets
( C ) = (A) x (B) (D) = (A) - ( C )
1                             50,00,000.00 10%                   5,00,000.00             45,00,000.00
(A) = Closing Value of Last Year 2                             45,00,000.00 10%                   4,50,000.00             40,50,000.00
(A) = Closing Value of Last Year 3                             40,50,000.00 10%                   4,05,000.00             36,45,000.00
(A) = Closing Value of Last Year 4                             36,45,000.00 10%                   3,64,500.00             32,80,500.00
(A) = Closing Value of Last Year 5                             32,80,500.00 10%                   3,28,050.00             29,52,450.00
(A) = Closing Value of Last Year 6                             29,52,450.00 10%                   2,95,245.00             26,57,205.00
(A) = Closing Value of Last Year 7                             26,57,205.00 10%                   2,65,720.50             23,91,484.50
(A) = Closing Value of Last Year 8                             23,91,484.50 10%                   2,39,148.45             21,52,336.05
(A) = Closing Value of Last Year 9                             21,52,336.05 10%                   2,15,233.61             19,37,102.45
(A) = Closing Value of Last Year 10                             19,37,102.45 10%                   1,93,710.24             17,43,392.20
(A) = Closing Value of Last Year 11                             17,43,392.20 10%                   1,74,339.22             15,69,052.98
(A) = Closing Value of Last Year 12                             15,69,052.98 10%                   1,56,905.30             14,12,147.68
Salvage Value 12                               9,00,000.00

In diminishing value method, there is no use of salvage value while calculating depreciation.


Related Solutions

Using Excel create depreciation schedule for the Straight-Line and Double-Declining-Methods for the following Long-Term assets: Asset...
Using Excel create depreciation schedule for the Straight-Line and Double-Declining-Methods for the following Long-Term assets: Asset 1 – Office Furniture Acquisition cost $30,000 Residual value $5,000 Useful life 7 years-------- Asset 2 – Delivery Truck Acquisition cost $40,000 Residual value $5,000 Useful life 5 years------- Asset 3 – Computer Acquisition cost $2000 Residual value $0 Useful life 4 years For each asset create its own Tab (Sheet) in the Excel worksheet and name the corresponding sheet by the asset. At...
Create an Excel workbook containing two depreciation schedule templates, each on a separate spreadsheet. One template...
Create an Excel workbook containing two depreciation schedule templates, each on a separate spreadsheet. One template should be a SL depreciation schedule and the other template should be a DDB depreciation schedule. You should construct the spreadsheets using the formulas and cell referencing so that when the value of input variables are altered the calculations which automatically adjust. The spreadsheet columns should include depreciation expense, accumulated depreciation, and book value end of year (see textbook 575-576 for examples). Please note,...
Create an Excel workbook containing two depreciation schedule templates, each on a separate spreadsheet. One template...
Create an Excel workbook containing two depreciation schedule templates, each on a separate spreadsheet. One template should be a SL depreciation schedule and the other template should be a DDB depreciation schedule. You should construct the spreadsheets using the formulas and cell referencing so that when the value of input variables are altered the calculations which automatically adjust. The spreadsheet columns should include depreciation expense, accumulated depreciation, and book value end of year. Please note, you can not depreciate assets...
Create an Excel workbook containing two depreciation schedule templates, each on a separate spreadsheet. One template...
Create an Excel workbook containing two depreciation schedule templates, each on a separate spreadsheet. One template should be a SL depreciation schedule and the other template should be a DDB depreciation schedule. You should construct the spreadsheets using the formulas and cell referencing so that when the value of input variables are altered the calculations which automatically adjust. The spreadsheet columns should include depreciation expense, accumulated depreciation, and book value end of year (see textbook 575-576 for examples). Please note,...
Create an Excel workbook containing two depreciation schedule templates, each on a separate spreadsheet. One template...
Create an Excel workbook containing two depreciation schedule templates, each on a separate spreadsheet. One template should be a SL depreciation schedule and the other template should be a DDB depreciation schedule. You should construct the spreadsheets using the formulas and cell referencing so that when the value of input variables are altered the calculations which automatically adjust. The spreadsheet columns should include depreciation expense, accumulated depreciation, and book value end of year (see textbook 575-576 for examples). Please note,...
Depreciation and accounting cash flow   A firm in the third year of depreciating its only​ asset,...
Depreciation and accounting cash flow   A firm in the third year of depreciating its only​ asset, which originally cost $ 184,000 and has a​ 5-year MACRS recovery period has gathered the following data relative to the current​ year's operations: Accruals $ 15,800 Current assets 113,000 Interest expense 14,500 Sales revenue 402,000 Inventory 69,900 Total costs before​ depreciation, interest and taxes 291,000 Tax rate on ordinary income 21 % a. Use the relevant data to determine the operating cash flow for...
Depreciation and accounting cash flow   A firm in the third year of depreciating its only​ asset,which...
Depreciation and accounting cash flow   A firm in the third year of depreciating its only​ asset,which originally cost $175,000and has a​ 5-yearMACRS recovery period Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Percentage by recovery​ year* Recovery year 3 years 5 years 7 years 10 years 1 3333​% 2020​% 1414​% 1010​% 2 4545​% 3232​% 2525​% 1818​% 3 1515​% 1919​% 1818​% 1414​% 4 77​% 1212​% 1212​% 1212​% 5 1212​% 99​% 99​% 6 55​% 99​% 88​% 7...
DEPRECIATION Calculate the complete depreciation table for an asset with a Cost Basis of $80,000, a...
DEPRECIATION Calculate the complete depreciation table for an asset with a Cost Basis of $80,000, a Salvage Value of $20,000 and a useful life of 6 years with the Declining Balance 200% method with switchover to Straight Line Method.
Use Excel to create an applicable supporting schedule that provides an example of the adjustments that...
Use Excel to create an applicable supporting schedule that provides an example of the adjustments that would need to be made to any China company’s financial statements for it to comply with U.S. GAAP
Tax Depreciation Lab Assignment: Prepare an excel Spreadsheet to calculate MACRS depreciation on the following assets....
Tax Depreciation Lab Assignment: Prepare an excel Spreadsheet to calculate MACRS depreciation on the following assets. Use the MACRS tables to look up the proper % to use for depreciation each year. Business Assets: Date Item                             Purchased        Amount           Bus. Use         Life Truck                           2/05/17            $28,000             100%            5 yr. Mower 2                      3/08/17               12,000             100%            7 yr Seeder                         3/01/16                 3,400             100%            7 yr Equipment                   6/25/16                 1,595             100%            7 yr             Laptop                         5/18/16           ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT