I am a bit confused about this question and need the help (Project Management). Thanks

Use the case below to answer questions 1 & 2 (Adapted from PMBOK 6)

Company A was established 4 years ago. Its founders have recently become concerned about the competitiveness of the firms offerings and have asked the directors of product development and marketing to work together and prepare a list of potential projects.

The product development and marketing directors identified three projects related to updating company A's existing products. And they believed all these three projects can be finished at the end of the first year. The first project would integrate Company A's current calendar app with its email app. The investment for the first year is $65,000. Revenues from the second year of the products launch were estimated to be $750,000. However, because the directors expected that a large percentage of the users would likely upgrade to this new product soon after its introduction, they projected that annual sales would decline by 10% annually in subsequent years. The directors speculated that company A was moderately likely to obtain a leadership position in email/calendar apps if this project were undertaken and felt this app made moderate use of the Web.

The second project related to updating the expense report app. The directors estimated that this project would spend $20,800 in the first year. Sales estimated to be $250,000 in the second the year and to increase 5% annually in subsequent years. The directors speculated that completing this project would almost certainly maintain company As leadership position in the expense report category, although it made little use of the Web.

The last product enhancement project related to enhancing the existing portfolio tracking app. This project would require an investment of $39,000 for the first year and would generate $500,000 in the second-year sales. Sales were projected to increase 5% annually in subsequent years. The directors felt this project would have a high probability of maintaining company As leadership position in this category and the product would make moderate use of the Web.

In evaluating these three projects, the founders believed it was reasonable to assume each product had a 3-year sales life. They also felt that a hurdle rate(discount rate) of 12 percent fairly reflected the companys cost of capital. Based on this information answer these questions

Question 1. Provided that all the cash inflows are incurred at the end of year and each product has a 3-year sales, calculate the NPV for these three projects. (Hint: project life for each project is expected to be 4 years from project inception.)

Question 2. Assume the founders weigh a projects NPV twice as much as both obtaining/retaining a leadership position and making use of the Web. Use the weighted factor scoring method to rank these projects. Criteria for scoring are listed as below.

NPV > $2,000,000 3; $1,000,000 < NPV < $2,000,000 2; NPV <$1,000,000 1.

Certainly or highly maintain leadership 3; Moderately maintain leadership 2; Low probability to obtain leadership 1.

Extensive use of Web 3; Moderate use of Web 2; Little or no use of Web 1.

(Hint: the sum of the weights of all three criteria should be set as 1.00.)