Question
In: Economics
An auto supplier installed new equipment costing $1,050,000. The equipment generated new income averaging $275,000 per...
- An auto supplier installed new equipment costing $1,050,000. The equipment generated new income averaging $275,000 per year, and its operating costs averaged $50,000 per year. The equipment was depreciated using the MACRS method, assuming a 7-year recovery period and no salvage value. However, the equipment was kept in service for a total of 10 years, after which time a scrap dealer bought it for $75,000. The company has a combined effective federal and local tax rate of 26%, and uses an after-tax MARR rate of 8%. Determine the equipment’s after-tax net present worth over its 10-year service life.
[Answer: $302,000]
Solutions
Expert Solution
Using Excel
Tax rate = 26%
MACRS rate for 7 yrs property are 0.1429, 0.2449, 0.1749, 0.1249, 0.0893, 0.0892, 0.0893 & 0.0446
Depreciation = Purchase value * Depreciation rate
Net cash Flow = Annual revenue - annual O&M cost
Net cash flow will include depreciation recapture in EOY10
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 | -1050000.00 | -1050000 | ||||||
| 1 | 275000.00 | -50000.00 | 150045.00 | 74955.00 | 19488.30 | 205512 | ||
| 2 | 275000.00 | -50000.00 | 257145.00 | -32145.00 | -8357.70 | 233358 | ||
| 3 | 275000.00 | -50000.00 | 183645.00 | 41355.00 | 10752.30 | 214248 | ||
| 4 | 275000.00 | -50000.00 | 131145.00 | 93855.00 | 24402.30 | 200598 | ||
| 5 | 275000.00 | -50000.00 | 93765.00 | 131235.00 | 34121.10 | 190879 | ||
| 6 | 275000.00 | -50000.00 | 93660.00 | 131340.00 | 34148.40 | 190852 | ||
| 7 | 275000.00 | -50000.00 | 93765.00 | 131235.00 | 34121.10 | 190879 | ||
| 8 | 275000.00 | -50000.00 | 46830.00 | 178170.00 | 46324.20 | 178676 | ||
| 9 | 275000.00 | -50000.00 | 225000.00 | 58500.00 | 166500 | |||
| 10 | 275000.00 | -50000.00 | 75000.00 | 300000.00 | 78000.00 | 222000 | ||
| NPW | 302084 |
NPW after tax = 302084 ~ 302000 (Nearest Thousand)
Showing formula in Excel
| Year | Initial cost | Revenue | O&M cost | Depreciation | Depreciation recapture | TI | Tax | ATCF |
| 0 | -1050000 | =B2 | ||||||
| 1 | 275000 | -50000 | =0.1429*1050000 | =C3+D3-E3+F3 | =G3*0.26 | =C3+D3-H3+F3 | ||
| 2 | 275000 | -50000 | =0.2449*1050000 | =C4+D4-E4+F4 | =G4*0.26 | =C4+D4-H4+F4 | ||
| 3 | 275000 | -50000 | =0.1749*1050000 | =C5+D5-E5+F5 | =G5*0.26 | =C5+D5-H5+F5 | ||
| 4 | 275000 | -50000 | =0.1249*1050000 | =C6+D6-E6+F6 | =G6*0.26 | =C6+D6-H6+F6 | ||
| 5 | 275000 | -50000 | =0.0893*1050000 | =C7+D7-E7+F7 | =G7*0.26 | =C7+D7-H7+F7 | ||
| 6 | 275000 | -50000 | =0.0892*1050000 | =C8+D8-E8+F8 | =G8*0.26 | =C8+D8-H8+F8 | ||
| 7 | 275000 | -50000 | =0.0893*1050000 | =C9+D9-E9+F9 | =G9*0.26 | =C9+D9-H9+F9 | ||
| 8 | 275000 | -50000 | =0.0446*1050000 | =C10+D10-E10+F10 | =G10*0.26 | =C10+D10-H10+F10 | ||
| 9 | 275000 | -50000 | =C11+D11-E11+F11 | =G11*0.26 | =C11+D11-H11+F11 | |||
| 10 | 275000 | -50000 | 75000 | =C12+D12-E12+F12 | =G12*0.26 | =C12+D12-H12+F12 | ||
| NPW | =NPV(8%,I3:I12)+I2 |
Rahul Sunny answered 6 months agoRelated Solutions
The ABC Company is looking at a new piece of equipment with an installed cost of...
The ABC Company is looking at a new piece of equipment
with an installed cost of $187,400. This cost will be depreciated
straight-line to zero over the four-year life. At the end of the
four years the book value will be zero however it can be scrapped
for $25,000. The equipment will save the firm $99,000 per year in
pre-tax operating costs and the equipment requires an initial
investment in net working capital of $9,000 and will be recovered
at...
Sloan Corporation is considering new equipment. The equipment can be purchased from an overseas supplier for...
Sloan Corporation is considering new equipment. The equipment
can be purchased from an overseas supplier for $3,180. The freight
and installation costs for the equipment are $640. If purchased,
annual repairs and maintenance are estimated to be $430 per year
over the four-year useful life of the equipment. Alternatively,
Sloan can lease the equipment from a domestic supplier for $1,420
per year for four years, with no additional costs.
Prepare a differential analysis dated December 3, to determine
whether Sloan...
Sloan Corporation is considering new equipment. The equipment can be purchased from an overseas supplier for...
Sloan Corporation is considering new equipment. The equipment
can be purchased from an overseas supplier for $3,160. The freight
and installation costs for the equipment are $660. If purchased,
annual repairs and maintenance are estimated to be $430 per year
over the four-year useful life of the equipment. Alternatively,
Sloan can lease the equipment from a domestic supplier for $1,400
per year for four years, with no additional costs.
Prepare a differential analysis dated December 3, to determine
whether Sloan...
Sloan Corporation is considering new equipment. The equipment can be purchased from an overseas supplier for...
Sloan Corporation is considering new equipment. The equipment
can be purchased from an overseas supplier for $125,500. The
freight and installation costs for the equipment are $1,600. If
purchased, annual repairs and maintenance are estimated to be
$2,500 per year over the five-year useful life of the equipment.
Alternatively, Sloan can lease the equipment from a domestic
supplier for $30,000 per year for five years, with no additional
costs.
Prepare a differential analysis dated December 3 to determine
whether Sloan...
Sloan Corporation is considering new equipment. The equipment can be purchased from an overseas supplier for...
Sloan Corporation is considering new equipment. The equipment
can be purchased from an overseas supplier for $3,220. The freight
and installation costs for the equipment are $650. If purchased,
annual repairs and maintenance are estimated to be $390 per year
over the four-year useful life of the equipment. Alternatively,
Sloan can lease the equipment from a domestic supplier for $1,420
per year for four years, with no additional costs.
Prepare a differential analysis dated December 3, to determine
whether Sloan...
Sloan Corporation is considering new equipment. The equipment can be purchased from an overseas supplier for...
Sloan Corporation is considering new equipment. The equipment
can be purchased from an overseas supplier for $3,280. The freight
and installation costs for the equipment are $650. If purchased,
annual repairs and maintenance are estimated to be $400 per year
over the four-year useful life of the equipment. Alternatively,
Sloan can lease the equipment from a domestic supplier for $1,460
per year for four years, with no additional costs.
Prepare a differential analysis dated December 3, to determine
whether Sloan...
D’Amato Corporation is considering new equipment. The equipment can be purchased from an overseas supplier for...
D’Amato Corporation is considering new equipment. The equipment
can be purchased from an overseas supplier for $4,024. The freight
and installation costs for the equipment are $460. If purchased,
annual repairs and maintenance are estimated to be $413 per year
over the four-year useful life of the equipment. Alternatively,
D’Amato can lease the equipment from a domestic supplier for $1,769
per year for four years, with no additional costs.
Required:
A.
Prepare a differential analysis dated December 11 to determine...
The gym is looking for a new equipment supplier. The candidate manufacturer provided for the equivalence...
The gym is looking for a new equipment supplier. The candidate
manufacturer provided for the equivalence testing a set of ten
dumbbells with a nominal weight of 12-kg. The sample mean and
sample standard deviation of the weight of these sample dumbbells
are 12.06-kg and 0.06-kg, respectively. The gym is going to sign a
contract if the mean weight of a dumbbell is within 0.05-kg of the
nominal weight. Would you recommend the gym to sign a contract with
this...
TopNotch Medical, Inc. is a supplier of medical equipment. It recently introduced a new line of...
TopNotch Medical, Inc. is a supplier of medical equipment. It
recently introduced a new line of equipment that may revolutionize
the medical profession. Because of the new technology, potential
users of the equipment are reluctant to purchase the equipment, but
they are willing to enter into a lease arrangement if they can
classify the lease as an operating lease. The new equipment will
replace equipment that TopNotch has been selling in the past.
Leasing the new equipment will result in...
A company bought a new machine fot $300,000. The new machine generated revenue for $90,000 per...
A company bought a new machine fot $300,000. The new machine
generated revenue for $90,000 per year. Operating cost of that
machine is $10,000 per year. The machine is depreciated according
to 7-years MACRS method. The machine is sold for $80,000 in the
middle of 6th year of service. Determine the after tax
net present worth. Assume, the after-tax MARR is 10% and income tax
rate is 25% (federal and state combined).
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 1. Why do most leases have expensive cancellation provisions? Does the existence of this provision shift...
- The requirements for your assignment are: Decode the IP address 172.16.31.255 /20 Determine the following: Subnet...
- Examine the various types of contracts available to Toyota when dealing with international suppliers and advise...
- Problem 10-08 NPVs, IRRs, and MIRRs for Independent Projects Edelman Engineering is considering including two pieces...
- Give an example for market segmentation for a new company developing either products for cats or...
- Suppose you have set a specific goal for the balance in your savings account 12 years...
- Explain in very good details the hardening and procedures of Microsoft Server 2019
ADVERTISEMENT