A company is considering the purchase of a large stamping machine that will cost $140,000, plus...

A company is considering the purchase of a large stamping machine that will cost $140,000, plus $6,500 transportation and $12,000 installation charges. It is estimated that, at the end of five years, the market value of the machine will be $50,000. The IRS has established that this machine will fall under a three-year MACRS class life category. The justifications for the machine include $35,000 savings per year in labor and $45,000 savings per year in reduced materials. The before-tax MARR is 20% per year, and the effective income tax rate is 40%. What is the after-tax equivalent annual worth of this investment over the five year period which ends with the sale of the machine? (Do not enter a dollar sign $ with your answer.)

Solutions

Expert Solution

Cost Basis = 140000 + 6500 + 12000 = 158500

Annual savings = 35000 + 45000 = 80000

After tax MARR = 0.2 * (1 - 0.4) = 0.12 ~ 12%

Salvage value of 50000 at end of year 5 will be depreciation recapture as its a 3 yr MACRS property and BV after 4th yr is 0

Using Excel

Year	BTCF	MACRS Factor	Depreciation	Taxable income	Tax	ATCF
0	-158500.00					-158500.00
1	80000.00	0.3333	52828.05	27171.95	10868.78	69131.22
2	80000.00	0.4445	70453.25	9546.75	3818.70	76181.30
3	80000.00	0.1481	23473.85	56526.15	22610.46	57389.54
4	80000.00	0.0741	11744.85	68255.15	27302.06	52697.94
5	130000.00			130000.00	52000.00	78000.00
					NPW	82,554.10
					AW	22,901.31

Showing formula in excel

Year	BTCF	MACRS Factor	Depreciation	Taxable income	Tax	ATCF
0	-158500					=B61
1	80000	0.3333	=C62*-B$61	=B62-D62	=E62*0.4	=B62-F62
2	80000	0.4445	=C63*-B$61	=B63-D63	=E63*0.4	=B63-F63
3	80000	0.1481	=C64*-B$61	=B64-D64	=E64*0.4	=B64-F64
4	80000	0.0741	=C65*-B$61	=B65-D65	=E65*0.4	=B65-F65
5	=50000+80000			=B66-D66	=E66*0.4	=B66-F66
					NPW	=NPV(12%,G62:G66)+G61
					AW	=PMT(12%,5,-G67)

Rahul Sunny answered 1 month ago

Next > < Previous

Related Solutions

A company is considering the purchase of a large stamping machine that will cost $135,000, plus...

A company is considering the purchase of a large stamping machine that will cost $135,000, plus $6,700 transportation and $12,300 installation charges. It is estimated that, at the end of five years, the market value of the machine will be $52,000. The IRS has established that this machine will fall under a three-year MACRS class life category. The justifications for the machine include $36,000 savings per year in labor and $46,000 savings per year in reduced materials. The before-tax MARR...

A company is considering the purchase of a large stamping machine that will cost $145,000, plus...

A company is considering the purchase of a large stamping machine that will cost $145,000, plus $6,300 transportation and $11,700 installation charges. It is estimated that, at the end of five years, the market value of the machine will be $48,000. The IRS has established that this machine will fall under a three-year MACRS class life category. The justifications for the machine include $34,000 savings per year in labor and $44,000 savings per year in reduced materials. The before-tax MARR...

A company is considering the purchase of a large stamping machine that will cost $185,000, plus...

A company is considering the purchase of a large stamping machine that will cost $185,000, plus $4,700 transportation and $9,300 installation charges. It is estimated that, at the end of five years, the market value of the machine will be $32,000. The IRS has established that this machine will fall under a three-year MACRS class life category. The justifications for the machine include $26,000 savings per year in labor and $36,000 savings per year in reduced materials. The before-tax MARR...

Your company is contemplating the purchase of a large stamping machine. The machine will cost $161,000....

Your company is contemplating the purchase of a large stamping machine. The machine will cost $161,000. With additional transportation and installation costs of $5,000 and $12,000, respectively, the cost basis for depreciation purposes is $178,000. Its MV at the end of five years is estimated as $39,000. The IRS has assured you that this machine will fall under a three year MACRS class life category. The justifications for this machine include $39,000 savings per year in labor and $26,000 savings...

Clairmont Corporation is considering the purchase of a machine that would cost $140,000 and would last...

Clairmont Corporation is considering the purchase of a machine that would cost $140,000 and would last for 5 years. At the end of 5 years, the machine would have a salvage value of $18,000. By reducing labor and other operating costs, the machine would provide annual cost savings of $30,000. The company requires a minimum pretax return of 7% on all investment projects. (Ignore income taxes in this problem.)

A company is considering the purchase of a new machine. The machine will cost $14,000, will...

A company is considering the purchase of a new machine. The machine will cost $14,000, will result in an annual savings of $1750 with a salvage value of $500 at the end of 12 years. For a MARR of 7%, what is the benefit to cost ratio? Question options: 0.63 8.25 1.36 1.01

Big Steve's, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine....

Big Steve's, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of $90,000 and will generate net cash inflows of $19,000 per year for 11 years. a. What is the project's NPV using a discount rate of 8 percent? Should the project be accepted? Why or why not? b. What is the project's NPV using a discount rate of 16 percent? Should the project be accepted? Why or why...

Big Steve's, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine....

Big Steve's, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of $110,000 and will generate net cash inflows of $20,000 per year for 9 years. a. What is the project's NPV using a discount rate of 88 percent? Should the project be accepted? Why or why not? b. What is the project's NPV using a discount rate of 1717 percent? Should the project be accepted? Why or why...

Big Steve's, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine....

Big Steve's, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of $105,000 and will generate net cash inflows of $17,000 per year for 9 years. a. What is the project's NPV using a discount rate of 7 percent? Should the project be accepted? Why or why not? b. What is the project's NPV using a discount rate of 16 percent? Should the project be accepted? Why or why...

Big Steve's, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine....

Big Steve's, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of $90,000 and will generate net cash inflows of $17,000 per year for 11 years. a. If the discount rate is 8%, then the project's NPV is $________ (Round to the nearest dollar.) The project (should not be/ Should be) accepted because the NPV is (negative/positive) and therefore (does not add/ adds) value to the firm. (Select the...

Subjects