Gen 2- Powerboat. The company is considering Gen 2 as a green alternative to Gen 1 and requires further information to assist in the final decision. According to Viviers and Cohen (2011), motor manufacturers with projects that span on average 6 years equally prefer the net present value (NPV) and internal rate of return (IRR) methods, followed by payback period (PB). The Chief Financial Officer of Zubeir Engineering is looking to substantiate the financial implications of the manufacture of a new powerboat. At the request of the Chief Financial Officer, you are required to use projected cashflow to write comprehensive report on merit of each project using common capital budgeting methods. The projects have a minimum required return of 10%. Below are the projected cashflows from the both the projects: minimum required return of 10%. Below are the projected cashflows from the both the projects: Year 0 1 2 Gen 1-Powerboat Cash Flow ($ 21,500,000) $ 8,924,800 $ 8,294,800 0 21,500,000-$ 21,500,000-$ -$ 18,924,800$ 6,400,000$ 2,524,800$ 2 8,294,800$ 7,400,000$ 894,800$ 37,664,800$ $ 7,664,800 $ 7,034,800 $ 6,404,800 $ 10.322.000 Gen 2-Powerboat Cash Flow ($ 21,500,000) $ 6,400,000 $ 7,400,000 $ 7,900,000 $ 8,600,000 $ 9,300,000 $ 11,100,000 4 5 6 3. Capital Budgeting Techniques. 3.1 Net present Value. – Calculate NPV for both the projects and interpret your findings. 3.2 Internal Rate of Return – Calculate IRR for both the projects and interpret your findings. 3.3 Payback Period 1 – Calculate payback periods for both the projects and interpret your findings with cut- off point is 6 years. 3.4 Profitability Index – Calculate profitability index for both the projects and interpret your findings. Zubeir Engineering Limited is one of top high-speed boat Manufacturer in the Middle Eastern Region. The capital budgeting strategies in the company involves a three- phase approach: planning or budgeting, evaluation, and post completion reviews. The first phase involves identification of likely projects at strategic planning time. These are selected to support the strategic objectives of the corporation. This identification is generally broad in scope with minimal financial evaluation attached. Projects are classified as new product, cost savings, capacity expansion, etc. As the planning process focuses more closely on the short-term plans (or budgets), major capital expenditures are scrutinized more rigorously. Project costs are more closely honed, and specific projects may be reconsidered. Each project is then individually reviewed and authorized. Planning, developing, and refining cash flows underlie capital analysis at Zubeir Engineering. Once the cash flows have been determined, the application of capital evaluation techniques such as those using net present value, internal rate of return, profitability index and payback period is routine. Presentation of the results is enhanced using sensitivity analysis, which plays a major role for management in assessing the critical assumptions and resulting impact. The final phase relates to post completion reviews in which the original forecasts of the project’s performance are compared to actual results and/or revised expectations. Zubeir Engineering has identified two mutually exclusive projects, Gen 1-powerboat and Gen 2- Powerboat. The company is considering Gen 2 as a green alternative to Gen 1 and requires further information to assist in the final decision. According to Viviers and Cohen (2011), motor manufacturers with projects that span on average 6 years equally prefer the net present value (NPV) and internal rate of return (IRR) methods, followed by payback period (PB). The Chief Financial Officer of Zubeir Engineering is looking to substantiate the financial implications of the manufacture of a new powerboat. At the request of the Chief Financial Officer, you are required to use projected cashflow to write comprehensive report on merit of each project using common capital budgeting methods. The projects have a minimum required return of 10%. Below are the projected cashflows from the both the projects: Year Gen 1-Powerboat Cash Flow Gen 2-Powerboat Cash Flow 0 ($ 21,500,000) ($ 21,500,000) $ 8,924,800 $ 6,400,000 2 $ 8,294,800 $ 7,400,000 $ 7,664,800 $ 7,900,000 $ 7,034,800 $ 8,600,000 $ 6,404,800 $9,300,000 $ 10,322,000 $ 11,100,000 UAWNO 6

To access the full solution pay $1.97

calculate the capital budgeting techniques using excel ( show the working please)

EXPERT ANSWER