Assignment title: Information


Message: Need below Questions to be done. The case, sample excel sheet and PowerPoint are attached as well to give you a better idea what I'm looking for What are the relevant cash flows associated with rehabilitating the Conway ? Be as specific as possible and identify the categories to which each cash flow belongs (i.e., Initial Outlay, Terminal, Operating). What are the relevant cash flows for the replacement project (buying a new diesel boat)? Be as specific as possible and identify the categories to which each cash flow belongs (i.e., Initial Outlay, Terminal, Operating). Using payback, NPV, and IRR analyses, should the company accept the project of purchasing a new diesel boat? In other words, do the annual cost savings of the new boat relative to rehabilitating and using the Conway outweigh the additional expense associated with purchasing the new boat? Or, are they better off rejecting the project and just repairing the Conway ? Be sure to show all work and explain your reasoning. [Hint: Perform a single analysis on the incremental differences in cash flows for parts 1) and 2) above.] I would like to solve the three problems in the email. An excel sheet would be great. Attached in word are the solutions to the five questions at the end of the case. Please do the work in excel.