Your company Portfolio Manager is convening a review board in the first calendar quarter to consider...

 

Transcribed Image Text:

Your company Portfolio Manager is convening a review board in the first calendar quarter to consider three mutually exclusive projects. You have been asked to provide recommendations with respect to the capital budgeting aspects of these projects. Your recommendations will be considered by the review board along with other non-financial aspects of the projects. Initial (year O) funding will be provided in the current year for the single project selected. Note: The review board may select a project for strategic reasons even if the financial aspects are not ideal. Project sponsors have provided the following estimated cash flow projections: The company has not yet decided how the selected project will be financed. The cost of capital or hurdle rate will vary depending on how the company decides to finance the project. You decide to compare projects in three areas: (1) payback period (not considering the cost of capital); NPV sensitivity (see note 1 below); and (3) Internal Rate of Return (IRR). Conduct each analysis and interpret the results. You must make as complete a recommendation as possible so that the board understands the financial implications of whatever decision they make. Based on your analysis, what would you recommend to the review board and why? Your recommendation must be based on the combination of all three factors (payback period, IRR, and NPV sensitivity). Show all calculations supporting your recommendation. Calculate NPV to the nearest dollar, IRR to three decimal places, and payback period to one decimal place. Year 012345 Project A Outflow Inflow Netflow 150,000 -150,000 20,000 30,000 40,000 20,000 30,000 40,000 40,000 50,000 40,000 50,000 Project B Outflow Inflow 150,000 130,000 Netflow -150,000 40,000 -90,000 50,000 50,000 60,000 60,000 90,000 90,000 90,000 90,000 Project C Outflow Inflow 200,000 150,000 Netflow -200,000 -150,000 90,000 90,000 100,000 100,000 110,000 110,000 120,000 120,000 Your company Portfolio Manager is convening a review board in the first calendar quarter to consider three mutually exclusive projects. You have been asked to provide recommendations with respect to the capital budgeting aspects of these projects. Your recommendations will be considered by the review board along with other non-financial aspects of the projects. Initial (year O) funding will be provided in the current year for the single project selected. Note: The review board may select a project for strategic reasons even if the financial aspects are not ideal. Project sponsors have provided the following estimated cash flow projections: The company has not yet decided how the selected project will be financed. The cost of capital or hurdle rate will vary depending on how the company decides to finance the project. You decide to compare projects in three areas: (1) payback period (not considering the cost of capital); NPV sensitivity (see note 1 below); and (3) Internal Rate of Return (IRR). Conduct each analysis and interpret the results. You must make as complete a recommendation as possible so that the board understands the financial implications of whatever decision they make. Based on your analysis, what would you recommend to the review board and why? Your recommendation must be based on the combination of all three factors (payback period, IRR, and NPV sensitivity). Show all calculations supporting your recommendation. Calculate NPV to the nearest dollar, IRR to three decimal places, and payback period to one decimal place. Year 012345 Project A Outflow Inflow Netflow 150,000 -150,000 20,000 30,000 40,000 20,000 30,000 40,000 40,000 50,000 40,000 50,000 Project B Outflow Inflow 150,000 130,000 Netflow -150,000 40,000 -90,000 50,000 50,000 60,000 60,000 90,000 90,000 90,000 90,000 Project C Outflow Inflow 200,000 150,000 Netflow -200,000 -150,000 90,000 90,000 100,000 100,000 110,000 110,000 120,000 120,000 Your company Portfolio Manager is convening a review board in the first calendar quarter to consider three mutually exclusive projects. You have been asked to provide recommendations with respect to the capital budgeting aspects of these projects. Your recommendations will be considered by the review board along with other non-financial aspects of the projects. Initial (year O) funding will be provided in the current year for the single project selected. Note: The review board may select a project for strategic reasons even if the financial aspects are not ideal. Project sponsors have provided the following estimated cash flow projections: The company has not yet decided how the selected project will be financed. The cost of capital or hurdle rate will vary depending on how the company decides to finance the project. You decide to compare projects in three areas: (1) payback period (not considering the cost of capital); NPV sensitivity (see note 1 below); and (3) Internal Rate of Return (IRR). Conduct each analysis and interpret the results. You must make as complete a recommendation as possible so that the board understands the financial implications of whatever decision they make. Based on your analysis, what would you recommend to the review board and why? Your recommendation must be based on the combination of all three factors (payback period, IRR, and NPV sensitivity). Show all calculations supporting your recommendation. Calculate NPV to the nearest dollar, IRR to three decimal places, and payback period to one decimal place. Year 012345 Project A Outflow Inflow Netflow 150,000 -150,000 20,000 30,000 40,000 20,000 30,000 40,000 40,000 50,000 40,000 50,000 Project B Outflow Inflow 150,000 130,000 Netflow -150,000 40,000 -90,000 50,000 50,000 60,000 60,000 90,000 90,000 90,000 90,000 Project C Outflow Inflow 200,000 150,000 Netflow -200,000 -150,000 90,000 90,000 100,000 100,000 110,000 110,000 120,000 120,000 Your company Portfolio Manager is convening a review board in the first calendar quarter to consider three mutually exclusive projects. You have been asked to provide recommendations with respect to the capital budgeting aspects of these projects. Your recommendations will be considered by the review board along with other non-financial aspects of the projects. Initial (year O) funding will be provided in the current year for the single project selected. Note: The review board may select a project for strategic reasons even if the financial aspects are not ideal. Project sponsors have provided the following estimated cash flow projections: The company has not yet decided how the selected project will be financed. The cost of capital or hurdle rate will vary depending on how the company decides to finance the project. You decide to compare projects in three areas: (1) payback period (not considering the cost of capital); NPV sensitivity (see note 1 below); and (3) Internal Rate of Return (IRR). Conduct each analysis and interpret the results. You must make as complete a recommendation as possible so that the board understands the financial implications of whatever decision they make. Based on your analysis, what would you recommend to the review board and why? Your recommendation must be based on the combination of all three factors (payback period, IRR, and NPV sensitivity). Show all calculations supporting your recommendation. Calculate NPV to the nearest dollar, IRR to three decimal places, and payback period to one decimal place. Year 012345 Project A Outflow Inflow Netflow 150,000 -150,000 20,000 30,000 40,000 20,000 30,000 40,000 40,000 50,000 40,000 50,000 Project B Outflow Inflow 150,000 130,000 Netflow -150,000 40,000 -90,000 50,000 50,000 60,000 60,000 90,000 90,000 90,000 90,000 Project C Outflow Inflow 200,000 150,000 Netflow -200,000 -150,000 90,000 90,000 100,000 100,000 110,000 110,000 120,000 120,000