Question
The ABC Company has two project proposals currently under consideration and would like your help in selecting one of the two projects. They would like
The ABC Company has two project proposals currently under consideration and would like your help in selecting one of the two projects. They would like you to use both financial and non-financial selection criteria, and to defend your selection in a brief paragraph. Details about each project are as follows:
Project Blue: This project has an initial investment of $120,000 and projected cash inflows of $37,000 per year for six years.
Project Gold: This project has an initial investment of $115,000 and projected cash inflows of $42,000 per year for six years.
ABC Companys minimum desired rate-of-return is 22 percent, and they expect inflation to remain at 3 percent over the time period.
Complete the following four tasks in an Excel spreadsheet, with each task on a separate worksheet:
- Task 1: Compare the two projects using the payback model (and include the rate of return for each). Use the example in Exhibit 2.3A on page 39 as a general guide for how to set up your worksheet. At the bottom of the worksheet, write one or two sentences describing which project you would select and why. Base your answer solely on the payback model.
- Task 2: Compare the two projects using the net present value model. Use the example in Exhibit 2.3B on page 39 as a general guide for how to set up your worksheet. At the bottom of the worksheet, write one or two sentences describing which project you would select and why. Base your answer solely on the NPV model.
- Task 3: Set up a project screening matrix as follows and create formulas in the weighted total column to calculate the weighted total for each project. At the bottom of the worksheet, write one or two sentences describing which project you would select and why. Base your answer solely on this screening matrix.
Criteria | Strong sponsor | Supports business strategy | Urgency | Competition | Fill market gap | Weighted total |
Weight | 2.0 | 3.0 | 3.0 | 2.0 | 2.0 | -- |
Blue | 2 | 7 | 8 | 4 | 7 | |
Gold | 5 | 6 | 5 | 4 | 4 |
- Task 4: Select one of the two projects to move forward with. Write a paragraph describing why you selected the project. Base your selection on all of the screening methods you used.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started