In: Finance
"The A.M.I. Company is considering installing a new process machine for the firm's manufacturing facility. The machine costs $555,000 installed, will generate additional revenue of $70,000 per year, and will save $69,000 per year in labor and material costs. The machine will be financed by a $223,000 bank loan repayable in three equal annual installments with a 6% interest rate. The machine will be depreciated using seven-year MACRS. The useful life of the machine is 10 years when the machine will be sold for $22,000. The marginal tax rate is 40%. Compute the IRR of the investment. Enter your answer as a percentage between 0 and 100."
Note: I have provided answer with excel formula of IRR. Let me know if manual calculation of IRR is needed.