Capital Budgeting Techniques This assignment must be completed in Excel. If your work is not completed...

Transcribed Image Text:

Capital Budgeting Techniques This assignment must be completed in Excel. If your work is not completed in Excel, it won't be graded. CSUSM is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows a. Construct NPV profiles for Projects A and B.(20 points) b. Calculate each project's IRR (15 points). C. Year Project A Project B 0 $(45,000) $(50,000) 1 (20,000) 15,000 2 11,000 15,000 3 20,000 15,000 4 30,000 15,000 5 45,000 15,000 If the required rate of return for each project is 12 percent, which project should CSUSM select? If the required rate of return is 9.5 percent, what would be the proper choice? If the required rate of return is 15.5 percent, what would be the proper choice? (15 points) d. At what rate do the NPV profiles of the two projects cross? (20 points) e. Project A has a large cash flow in Year 5 associated with ending the project. CSUSM's management is confident of Project A's cash flows in Years 0 to 4 but is uncertain about what its Year 5 cash flow will be. (There is no uncertainty about Project B's cash flows.) Under a worst-case scenario, Project A's Year 5 cash flow will be $41,000, whereas under a best-case scenario, the cash flow will be $51,000. Redo parts (a), (b), and (d) for each scenario, assuming a 12.5 percent required rate of return. If the required rate of return for each project is 12.5 percent, which project should be selected under each scenario? (30 points) Capital Budgeting Techniques This assignment must be completed in Excel. If your work is not completed in Excel, it won't be graded. CSUSM is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows a. Construct NPV profiles for Projects A and B.(20 points) b. Calculate each project's IRR (15 points). C. Year Project A Project B 0 $(45,000) $(50,000) 1 (20,000) 15,000 2 11,000 15,000 3 20,000 15,000 4 30,000 15,000 5 45,000 15,000 If the required rate of return for each project is 12 percent, which project should CSUSM select? If the required rate of return is 9.5 percent, what would be the proper choice? If the required rate of return is 15.5 percent, what would be the proper choice? (15 points) d. At what rate do the NPV profiles of the two projects cross? (20 points) e. Project A has a large cash flow in Year 5 associated with ending the project. CSUSM's management is confident of Project A's cash flows in Years 0 to 4 but is uncertain about what its Year 5 cash flow will be. (There is no uncertainty about Project B's cash flows.) Under a worst-case scenario, Project A's Year 5 cash flow will be $41,000, whereas under a best-case scenario, the cash flow will be $51,000. Redo parts (a), (b), and (d) for each scenario, assuming a 12.5 percent required rate of return. If the required rate of return for each project is 12.5 percent, which project should be selected under each scenario? (30 points)