1

# Problem 11-31: Use the data from Problem 31 to not only calculate the depreciation schedule four...

## Question

###### Problem 11-31: Use the data from Problem 31 to not only calculate the depreciation schedule four...

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=

#### Similar Solved Questions

##### Calculate the gross profit rate and the profit margin.(Round answers to 1 decimal place, s. 15.2%)...
Calculate the gross profit rate and the profit margin.(Round answers to 1 decimal place, s. 15.2%) Gross profit rate Profit margin Suppose in its income statement for the year ended June 30, 2022, The Clorox Company reported the following condensed data (dollars in millions Salaries and wages expens...
##### If a 0.489 M solution of L-ascorbic acid is being prepared what mass of solid (in grams) must be added to make a 500 ml of solution?
If a 0.489 M solution of L-ascorbic acid is being prepared what mass of solid (in grams) must be added to make a 500 ml of solution?...
##### Table 10-2 Impact of time to maturity on bond prices Time Period in Years to Maturity...
Table 10-2 Impact of time to maturity on bond prices Time Period in Years to Maturity (10% Interest Payment, Various Times to Maturity) Bond Price with 8% Bond Price with 12% Yield to Maturity Yield to Maturity \$1,000.00 1,018.52 1,079.85 1,134.20 1,171.19 1,196.36 1,213.50 1,225.16 \$1,000.00 982.14...
##### Sort the following terms into the proper bin based on whether or not they describe a...
Sort the following terms into the proper bin based on whether or not they describe a radiative process or a nonradiative process....
##### Being able to eloquently speak in public is often considered to be an art form that...
Being able to eloquently speak in public is often considered to be an art form that takes practice and skill. While speaking, it is also important to be able to respond to and engage the audience. An individual can be a natural born speaker, but for someone else it can take tremendous amounts of pra...
##### What are the four typical interpolation methods for Discrete-to- Continuous conversion? HTML Editor
What are the four typical interpolation methods for Discrete-to- Continuous conversion? HTML Editor...
##### . How does data create value in healthcare for the following entities? a. Providers (Hospitals, physicians)...
. How does data create value in healthcare for the following entities? a. Providers (Hospitals, physicians) b. Patients c. Payers or Insurance companies...
##### ABC soft drink manufacturing company produces soda bottles at three plants: Orlando, Tampa, and Miami. They...
ABC soft drink manufacturing company produces soda bottles at three plants: Orlando, Tampa, and Miami. They ship them to major distribution centers in Charlotte. Birmingham, and Tallahassee. The accounting, production, and marketing departments have provided the information in the table below, which...
##### OH H20 4. Circle and identify the functional groups in the fol dentify the functional groups...
OH H20 4. Circle and identify the functional groups in the fol dentify the functional groups in the following compounds. H оснэ он...
##### CASE STUDY 8.1 Jenny, a 19-year-old college student, was injured in a fire resulting from a...
CASE STUDY 8.1 Jenny, a 19-year-old college student, was injured in a fire resulting from a car accident. She experienced ull-thickness burns over approximately 10% of her body. Consider the clinical model that is most re- lated to this process. From your reading related to fluid, electrolyte, and a...
##### Water bottle question you decide to take an international adventure to the locations shown below. During...
Water bottle question you decide to take an international adventure to the locations shown below. During this trip yc rry a bottle of water with you made of cheap plastic so its walls are really flexible. (Guess you must not be flying with today's restrictions). you don't drink any of the ...
##### Column Design for Compression Given: A column supports vertical loads Species and Grade: DF-L Sel...
Column Design for Compression Given: A column supports vertical loads Species and Grade: DF-L Select Structural Column Size 6x10 Axial dead load, PD 5 kips Axial snow load, Ps 15 kips Column length, L = 16 feet The column is not braced about either axis The column is pinned top and bottom, k 1.0 CM ...