Problem 11-31: Use the data from Problem 31 to not only calculate the depreciation schedule four ways, but also find the After Tax Cash Flows (ATCE) and calculate the Net Present Value (NPV) and Rate of Return (IRR) for each different method. The spreadsheet is organized to help you and the BTCF is $5000 (note: earlier version of the spreadsheet used a BTCF of $4000, so check that column after you download the template). Note that if you depreciate down below the book value you have to "recapture" the untaxed portion of the salvage value in the last year and pay taxes on it. You can tell this is the case if the book value at the end is below the salvage value. That happens frequently with some of the depreciation methods. You will see examples in the book. ou use UI talc? 11-31 A small used delivery van can be purchased for $20,000. At the end of its useful life (8 years), the van can be sold for $3000. Determine the PW of the depreciation schedule based on 15% interest using: (a) Straight-line depreciation (b) Double declining balance depreciation (c) 100% bonus depreciation (d) MACRS depreciation Problem 11-31a Year Tax ATCE BTCF Purchase & salvage -20.000 BTCF benefits expenses Straight Line Book Value Taxable come 5000 50.00 5000 5000 5000 5000 500D 5000 3000 NPW= RR= Problem 11-31b Year Book Value Tax ATCE Double Decig Balance Taxable come BTC BTCF Puchsel benefits & salvage expenses -200.00 50.00 5000 50.00 5000 5000 50.00 5000 100 5000 | NPW= RR= Problem 11-31c Year 100% Boms Book Value Tax ATCE Taxable hcome BICE | BTCF Pacae benefits & salvage expenses -20000 5000 5000 5000 50.00 5000 5000 5000 30:00 5000 NPW= RR= Problem 11-310 Year | ATCE WACRS 15 year cka) Book Value Taxable cone BTCE | BTCF Purchase benefits & salvage expenses 20000 5000 5000 5000 5000 50.00 5000 5000 30:00 5000 NPW= RR=