Question

In: Finance

A new booster machine will cost $480,000. The anticipated increase in revenue will be $140,000/year for...

A new booster machine will cost $480,000. The anticipated increase in revenue will be $140,000/year for 5-years. Annual expenses will be $30,000/year for 5-years. The depreciable life is estimated to be 5-years and the salvage value will equal $35,000. Additional inventory necessary to run the machine will be $26,000. Initial training expenses are $20,000. Tax rate equals 40%.

 Find the NPV@10%.

 Find the IRR.

 Find the discounted payback and convert this into a percentage.

Solutions

Expert Solution

Particulars 1 2 3 4 5 Total
Revenue (A) 140000 140000 140000 140000 140000
Expenses (B) 30000 30000 30000 30000 30000
Depreciation © 89000 89000 89000 89000 89000
Profit Before Tax (D = A - B- C) 21000 21000 21000 21000 21000
Tax ( E = D*40%) 8400 8400 8400 8400 8400
Cash flow ( F = D + C -E) 101600 101600 101600 101600 101600
Discouting Factor ( G=1/ ( 1 + r)^n 0.909091 0.826446 0.751315 0.683013 0.620921
Present value ( F * G) 92363.64 83966.94 76333.58 69394.17 63085.61 385143.9
Present value of salvage value + Inventory ( 26000 + 35000 ) * 1/1.10^5 37876.2
Initial Investment -526000
Net Present Value -102980

Depreciation =( Historical cost - salvage value ) / useful life = ( 480000 - 35000 ) / 5 = 89000

Initial Investment = 480000 + 20000 + 26000 = 526000

Net Present value = - 102980

IRR is the rate of return which makes the present value of cash outflows equal to the present value of cash inflows

Let us use Financial calculator to find out the IRR

CF0 CF1 FR1 CF2 FR2 CF3 FR3 CF4 FR4 CF5 FR5 IRR < CPT
-526000 101600 1 101600 1 101600 1 101600 1 162600 1 2.50%

IRR = 2.5%

Years Cash flows Discounting Factor Present value Cummulative Present value
1 101600 0.909090909 92363.63636 92363.63636
2 101600 0.826446281 83966.94215 176330.5785
3 101600 0.751314801 76333.58377 252664.1623
4 101600 0.683013455 69394.16707 322058.3293
5 162600 0.620921323 100961.8071 423020.1365

Discounted payback period = more than 5 as there is -ve NPV.  


Related Solutions

A widget machine will cost $480,000. The anticipated increase in revenue will be $140,000/year for 5-years....
A widget machine will cost $480,000. The anticipated increase in revenue will be $140,000/year for 5-years. Annual expenses will be $30,000/year for 5-years. The depreciable life is estimated to be 5-years and the salvage value will equal $35,000. Additional inventory necessary to run the machine will be $26,000. Initial training expenses are $20,000. Tax rate equals 40%. A.  Find the discounted payback and convert this into a percentage.
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...
Sales revenue for Wholesales ehf is ISK 480,000. Its variable cost is 40% of sales and...
Sales revenue for Wholesales ehf is ISK 480,000. Its variable cost is 40% of sales and fixed costs are ISK 80,000. 1. What does the Wholesalers ehf need to sell for great value in order for the business to be in balance (ie where income and expenses are equal)? 2. What is the company's degree of operating leverage, etc. current sales? 3. If Wholesale Sales ehf's sales increase by 10%, how will the results change? Calculate both the percentage change...
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.)
Progress Incorporated is considering buying a new machine to increase production. It will cost $200,000 to...
Progress Incorporated is considering buying a new machine to increase production. It will cost $200,000 to purchase, $10,000 to modify and $5,000 to have it installed. It has a five-year class life. At the end of three years they plan to sell the machine for $95,000. The new machine will allow Progress to increase revenues by $80,000 each year but expenses will increase by $5,000 each year. Inventory will decrease by $6,000 and wages payable will increase by $2,000 if...
Progress Incorporated is considering buying a new machine to increase production. It will cost $200,000 to...
Progress Incorporated is considering buying a new machine to increase production. It will cost $200,000 to purchase, $10,000 to modify and $5,000 to have it installed. It has a five-year class life. At the end of three years they plan to sell the machine for $95,000. The new machine will allow Progress to increase revenues by $80,000 each year but expenses will increase by $5,000 each year. Inventory will decrease by $6,000 and wages payable will increase by $2,000 if...
Tall Oaks Corp. is considering a new machine that requires an initial investment of $480,000 installed,...
Tall Oaks Corp. is considering a new machine that requires an initial investment of $480,000 installed, and has a useful life of 8 years. The expected annual after-tax cash flows for the machine are $89,000 for each of the 8 years and nothing thereafter. a. Calculate the net present value of the machine if the required rate of return is 11 percent. b. Calculate the IRR of this project. c. Should Tall Oaks accept the project (assume that it is...
You must evaluate a proposal to buy a new milling machine. The base price is $140,000,...
You must evaluate a proposal to buy a new milling machine. The base price is $140,000, and shipping and installation costs would add another $14,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $91,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $10,000 increase in net operating working capital (increased inventory less increased accounts payable). There would be no effect on revenues, but pretax...
(Straight Line Depreciation) A new machine cost $100,000, and will increase inventory by $10,000, A/R by...
(Straight Line Depreciation) A new machine cost $100,000, and will increase inventory by $10,000, A/R by $15,000, and A/P by $5,000. This machine will reduce our expenses by $18,000 per year. The machine will be depreciated to a zero book value in 10 years, but could be sold for $12,000 at the end of 10 years. The marginal tax rate is 35%, and the cost of capital is 12%. Calculate the payback, NPV, IRR, and PI.
Maroon Limited is deciding whether to invest in a new machine. The new machine will increase...
Maroon Limited is deciding whether to invest in a new machine. The new machine will increase cash flow by $250,000 per year. You believe the technology used in the machine has a 10-year life; in other words, no matter when you purchase the machine, it will be obsolete 10 years from today. The machine is currently priced at $1,700,000. The cost of the machine will decline by $165,000 per year until it reaches $1,040,000, where it will remain. If your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT