Please help, this is due at midnight

Please view the following video before answering this question. Excel Video Lesson: DB Financial Function A surface mount PCB placement/soldering line is to be installed for $2,700,000. It will have a salvage value of $70,000 after 5 years. Determine the depreciation deduction and the resulting unrecovered investment during each year of the asset's life. Click here to access the MACRS-GDS Table Calculator Part a Your answer is partially correct. Determine the depreciation deduction and the resulting unrecovered investment during each year of the asset's life using declining balance depreciation using a rate that ensures the book value equals the salvage value. EOY Depreciation Balances 0 0 2700000 1 526000 2174000 2 526000 1648000 3 526000 1122000 4 526000 596000 5 526000 70000 i Sum depreciation 2630000 i Round entry to two decimal places. The tolerance is 10