There are 2 projects in the intake process. There is only enough financial capital available to do
Question:
There are 2 projects in the intake process. There is only enough financial capital available to do 1 of the 2, though it might later be possible to do the other one. The company is also concerned with cash flow. Finally, the organization has given a weight of 50 to project 1 and 60 for project 2, in terms of how likely each project might increase market penetration for these markets served by what each project provides.
Knowing the above, and having the data in the table below, create a weighted scoring model (create it in a Spreadsheet, like MS-Excel, but post a screenshot of it into the MS-Word file you submit) to help the portfolio governance committee select a project, as well as to see the weighting info for the non-selected projects.
Project 1
Rate of return = 10%
Year 1 | Year 2 | Year 3 | |
Projected net cash flow: | $15,000 | $25,000 | $30,000 |
Cost to develop: | $50,000 |
Project 2
Rate of return = 10%
Year 1 | Year 2 | Year 3 | |
Projected net cash flow: | $10,000 | $30,000 | $26,000 |
Cost to develop: | $48,000 |
- Determine the NPV of each of the 2 projects
- Determine the payback period for each of the 2 projects (averaging the cash flows is acceptable here)