In: Finance
Caspian Sea Drinks is considering the purchase of a new water filtration system produced by Rube Goldberg Machines. This new equipment, the RGM-7000, will allow Caspian Sea Drinks to expand production. It will cost $12.00 million fully installed and will be fully depreciated over a 15 year life, then removed for no cost. The RGM-7000 will result in additional revenues of $2.61 million per year and increased operating costs of $640,351.00 per year. Caspian Sea Drinks' marginal tax rate is 32.00%. The internal rate of return for the RGM-7000 is _____.
IRR can be calcualted using IRR function in EXCEL
=IRR(Year0 to Year15 cashflows)
IRR=10.20%
Explanation and answer has given in the below table.