Complete the attached Depreciation Schedules for each of the

Complete the attached Depreciation Schedules for each of the planned asset purchases using the provided information regarding cost, useful life, and selected method. You should do only the first 4 years for the building and do the complete useful life depreciation schedules for all of the other assets. This is part of part 1 of the project.

Formulas Data Review View Cut Copy Format Painter Calibri O-A-???! ???Merge & Cer aste Clipboard Font Alignment PLANNED ASSET ACQUISITIONS Reminder that the company\'s fiscal year is November 1 through October 31 Cost Useful life Salvage Depreciation Purchase 200,000 NIA 275,5005 350,0004 Asset Value Method Date Land N/A N/A Building 65000 Office 10,500 Straight line 12,500 Straight line 20,000 production 1-Sep-19 Delivery Equipment 1-Jun-19 Additional information related to the $350,000 delivery equipment purchase: It is ESTIMATED that the equipment will be ABLE TO DRIVE 150,000 total miles over its ifetime. To complete the depreciation schedule, PRESUME that the actual miles drive Project Information pctb Asset aquisitions planned Dep financing opti Type here to search

Solution

DEPRECIATION SCHEDULE BUILDING DEPRECIATION FOR THE YEAR DATE ASSET COST DEP\'BLE BASIS RATE DEPRECITAION EXPENSE ACCUMULATED DEPRECIATION BOOK VALUE 01.04.2018 $650,500 SLM $16,000 $16,000 $16,000 $634,500 31.03.2019 $650,500 SLM $16,000 $16,000 $32,000 $618,500 31.03.2020 $650,500 SLM $16,000 $16,000 $48,000 $602,500 31.03.2021 $650,500 SLM $16,000 $16,000 $64,000 $586,500 31.03.2022 $650,500 SLM $16,000 $16,000 $80,000 $570,500 DEPRECIATION SCHEDULE OFFICE EQUIPMENT DEPRECIATION FOR THE YEAR DATE ASSET COST DEP\'BLE BASIS RATE DEPRECITAION EXPENSE ACCUMULATED DEPRECIATION BOOK VALUE 01.09.2019 $275,500 SLM $52,600 $30,683 $30,683 $244,817 31.03.2020 $275,500 SLM $52,600 $52,600 $83,283 $192,217 31.03.2021 $275,500 SLM $52,600 $52,600 $135,883 $139,617 31.03.2022 $275,500 SLM $52,600 $52,600 $188,483 $87,017 31.03.2023 $275,500 SLM $52,600 $52,600 $241,083 $34,417 31.03.2024 $275,500 SLM $52,600 $34,417 $275,500 $0 DEPRECIATION SCHEDULE DELIVERY EQUIPMENT DEPRECIATION FOR THE YEAR DATE ASSET COST DEPRECIATION PER UNIT UNITS OF PRODUCTION DEPRECITAION EXPENSE ACCUMULATED DEPRECIATION BOOK VALUE 01.06.2019 $350,000 $2.20 19850 $43,670.00 $43,670.00 $306,330.00 31.03.2020 $350,000 $2.20 42680 $93,896.00 $137,566.00 $212,434.00 31.03.2021 $350,000 $2.20 44980 $98,956.00 $236,522.00 $113,478.00 31.03.2022 $350,000 $2.20 46950 $93,478.00 $330,000.00 $20,000.00