Please do not copy and paste.

Determine the net present value of the following five options through the year 2009 . (Use a discount rate of 30% and attach an Excel spreadsheet to show what numbers you used and how you did the NPV calculation. DO NOT JUST WRITE DOWN FIVE NUMBERS!: Compare options (a) through (e) using two criteria: 1. Which option has the highest NPV? 2. Identify what Nucleon's competitive advantage(s) would be if it chooses each of the five options (for example, if Nucleon chooses Option (e) then manufacturing capabilities are unlikely to be part of Nucleon's competitive advantage). Also comment on the ability of Nucleon to sustain the advantage implied with each of the five options: Based on your analysis of NPV and competitive advantage, which option do you recommend? Your assignment should include a one-page spreadsheet showing the NPV calculations and a write-up. The written portion of QA assignments must be no longer than two double-spaced pages. NOTE: There is an error in Exhibit 5 on page 15. In the sentence "After the year 2000, sales of CRP-1...; 2000 should be changed to 2002 . The timeframe for NPV calculation should be 1991-2009. You should calculate net cashflow for each year in each option. You should utilize this information when calculating some of the NPVs: -Nucleon would sell CRP-1 to the parther at cost" (the last sentence right above "Licensing Out Manufacturing -" on Page 11). Determine the net present value of the following five options through the year 2009 . (Use a discount rate of 30% and attach an Excel spreadsheet to show what numbers you used and how you did the NPV calculation. DO NOT JUST WRITE DOWN FIVE NUMBERS!: Compare options (a) through (e) using two criteria: 1. Which option has the highest NPV? 2. Identify what Nucleon's competitive advantage(s) would be if it chooses each of the five options (for example, if Nucleon chooses Option (e) then manufacturing capabilities are unlikely to be part of Nucleon's competitive advantage). Also comment on the ability of Nucleon to sustain the advantage implied with each of the five options: Based on your analysis of NPV and competitive advantage, which option do you recommend? Your assignment should include a one-page spreadsheet showing the NPV calculations and a write-up. The written portion of QA assignments must be no longer than two double-spaced pages. NOTE: There is an error in Exhibit 5 on page 15. In the sentence "After the year 2000, sales of CRP-1...; 2000 should be changed to 2002 . The timeframe for NPV calculation should be 1991-2009. You should calculate net cashflow for each year in each option. You should utilize this information when calculating some of the NPVs: -Nucleon would sell CRP-1 to the parther at cost" (the last sentence right above "Licensing Out Manufacturing -" on Page 11)