Question

In: Economics

An asset in the five-years MACRS property class costs $150,000 and has a zero estimated salvage...

An asset in the five-years MACRS property class costs $150,000 and has a zero estimated salvage value after six years of use. The asset will generate annual revenues of $320,000 and will require $80,000 in annual labor costs and $50,000 in annual material expenses. Assume a tax rate of 21%. Compute the after-tax cash flows over the project life and the NPW for a MARR = 12%. Is the investment acceptable?

Solutions

Expert Solution

MARR = 12%

Tax rate = 21%

Depreciation = Purchase value * Depreciation rate

Taxable income = Net cash flow - Depreciation

Tax = Tax rate * Taxable income

ATCF = Taxable income - Tax + Depreciation

Using Excel

Year Initial cost Revenue O&M cost Depreciation Depreciation recapture TI Tax ATCF
0 -150000.00 -150000
1 320000.00 -130000.00 30000.00 160000.00 33600.00 156400
2 320000.00 -130000.00 48000.00 142000.00 29820.00 160180
3 320000.00 -130000.00 28800.00 161200.00 33852.00 156148
4 320000.00 -130000.00 17280.00 172720.00 36271.20 153729
5 320000.00 -130000.00 17280.00 172720.00 36271.20 153729
6 320000.00 -130000.00 8640.00 0.00 181360.00 38085.60 151914
NPW 490372

NPW = 490372

As NPW is positive, project should be selected

Showing formula in excel

Year Initial cost Revenue O&M cost Depreciation Depreciation recapture TI Tax ATCF
0 -150000 =B10
1 320000 =-80000-50000 =150000*0.2 =C11+D11-E11+F11 =G11*0.21 =C11+D11-H11+F11
2 320000 =-80000-50000 =150000*0.32 =C12+D12-E12+F12 =G12*0.21 =C12+D12-H12+F12
3 320000 =-80000-50000 =150000*0.192 =C13+D13-E13+F13 =G13*0.21 =C13+D13-H13+F13
4 320000 =-80000-50000 =150000*0.1152 =C14+D14-E14+F14 =G14*0.21 =C14+D14-H14+F14
5 320000 =-80000-50000 =150000*0.1152 =C15+D15-E15+F15 =G15*0.21 =C15+D15-H15+F15
6 320000 =-80000-50000 =150000*0.0576 0 =C16+D16-E16+F16 =G16*0.21 =C16+D16-H16+F16
NPW =NPV(12%,I11:I16)+I10

Related Solutions

Calculating Salvage Value, An asset used in a four-year project falls in the five-year MACRS class...
Calculating Salvage Value, An asset used in a four-year project falls in the five-year MACRS class for tax purposes. The asset has an acquisition cost of $9,300,000 and will be sold for $2,100,000 at the end of the project. If the tax rate is 35 percent, what is the after tax salvage value of the asset?
A depreciable asset costs $10,000 and has an estimated salvage value of $1600 at the end...
A depreciable asset costs $10,000 and has an estimated salvage value of $1600 at the end of its 6-year depreciable life. Compute the depreciation schedule for this asset by both SOYD depreciation and DDB depreciation.  
A company purchases an asset that costs $46,000. This asset qualifies as three-year property under MACRS....
A company purchases an asset that costs $46,000. This asset qualifies as three-year property under MACRS. The company uses an after-tax discount rate of 12% and faces a 31% income tax rate. (Use Table 1, Table 2 and Exhibit 12.4.) 1. Demonstrate that the PV of the depreciation deductions, when the income tax rate is 31%, is $11,472. 2. Given an after-tax discount rate of 12%, what tax rate would be needed in order for the PV of the depreciation...
An asset costs $10,000 and has a depreciable life of 10 years and a salvage value...
An asset costs $10,000 and has a depreciable life of 10 years and a salvage value of $3,000. Determine the book (asset) value at the end of the 9th year using each of the following methods of depreciation (a) double-declining-balance method (b) textbook-declining-balance method (Matheson formula), and (c) sum-of-years’ digits method.
Cost Salvage Value Useful Life Units of Production MACRS Class Life Asset #1 $        1,400,000 $          ...
Cost Salvage Value Useful Life Units of Production MACRS Class Life Asset #1 $        1,400,000 $           100,500 5 2016                  41,000 5 * Total units of 2017 48,000 output = 2018 26,000 160,000 On january 1st 2016, the company purchased the above asset. Then, calculate the annual depreciation for 2016, 2017, and 2018 assuming they were all purchased June 1st, 2016. Show all of your work.
A new machine costs $120,000, has an estimated useful life of five years and an estimated...
A new machine costs $120,000, has an estimated useful life of five years and an estimated salvage value of $15,000 at the end of that time. It is expected that the machine can produce 210,000 widgets during its useful life. The New Times Company purchases this machine on January 1, 2017, and uses it for exactly three years. During these years the annual production of widgets has been 80,000, 50,000, and 30,000 units, respectively. On January 1, 2020, the machine...
A new van costs $25,000, has an estimated useful life of five years and an estimated...
A new van costs $25,000, has an estimated useful life of five years and an estimated salvage value of $5,000 at the end of that time. It is expected that the van will be driven 100,000 miles during its useful or service life. The Nation Express Company purchases this van on April 1, 2019. During 2019 the van is driven 13,000 miles and during 2020 it was driven 21,000 miles. On January 1, 2021, the van is sold for $7,000....
10.Calculating Salvage ValueAn asset used in a 4-year project falls in the 5-year MACRS class for...
10.Calculating Salvage ValueAn asset used in a 4-year project falls in the 5-year MACRS class for tax purposes. The asset has an acquisition cost of $7.6 million and will be sold for $1.4 million at the end of the project. If the tax rate is 21 percent, what is the aftertax salvage value of the asset? 11.Calculating NPVThurston Petroleum is considering a new project that complements its existing business. The machine required for the project costs $4.1 million. The marketing...
A. A fixed asset is classified as 5-year MACRS property and has an initial cost of...
A. A fixed asset is classified as 5-year MACRS property and has an initial cost of $41,000 What is the aftertax cash flow from the sale of this asset if the pre-tax salvage value at the end of year 3 is $17,500 and the tax rate is 34 percent? Year Five-Year Property Class 1 20.00 %           2 32.00            3 19.20           4 11.52            5 11.52 6 5.76 $15,439.38 $15,558.04 $15,564.72 $15,463.06 B. A firm has sales for the...
An asset used in a four-year project falls in the five-year MACRS class for tax purposes....
An asset used in a four-year project falls in the five-year MACRS class for tax purposes. The asset has an acquisition cost of $6,050,000 and will be sold for $1,250,000 at the end of the project. If the tax rate is 25 percent, what is the aftertax salvage value of the asset? Refer to Table 8.3. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT