Question: homework help! can u use excel? and show me the formulas Rum Co has asked you to evaluate the following proposal. Rum Co is contemplating

homework help! can u use excel? and show me the formulas
homework help! can u use excel? and show me the formulas Rum

Rum Co has asked you to evaluate the following proposal. Rum Co is contemplating the purchase of a new machine for $1,500,000 to produce a new rum drink. This machine would be used for 4 years, after which the machine will be worthless. Launch of the new rum drink will also require a $100,200 increase in working capital - an increase which will be recovered at the end of the 4 years (when the drink is pulled from the market and the machine rexiches the end of its useful life). Over this 4-year product life, Rum Co estimates incremental annual sales of $660,000 and increased annual cash-costs of $12,500. Based on Rum Co's discount rate of 18.0% and a marginal tax rate of 21.0% please answer the following for Rum Co's management: a) [2 pts] What is the total initial investment for this project? b) [2 pts] What is the project's incremental after-tax cash flow in year 1 ? c) [2 pts] What is the project's incremental after-tax cash flow in year 4 ? d) [1 pt] If the calculated IRR for this project is 19.2%, should Rum Co accept this project? Why - please explain your answer. e) What is the Net Present Value of this project

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!