14. Modify Acrons model so that development lasts for an extra year. Specifically, assume that development costs of $7.2 million and $2.1 million are incurred at the beginnings of years 1 and 2, and then the sales in the current model occur one year later, that is, from year 2 until year 21. Again, calculate the NPV dis- counted back to the beginning of year 1, and perform the same sensitivity analyses. Comment on the effects of this change in timing

15. Create a one-way data table in the Acron model to see how the NPV varies with discount rate, which is allowed to vary from 8% to 18% in increments of 0.5%. Explain intuitively why the results go in the direction they gothat is, the NPV decreases as the discount rate increases. Should Acron pursue the drug for all of these discount rates?

Please be specific with formulas and cell numbers. My calculations are coming out correct and I need to compare correctly. Thank you!