Modify Acron$$s model so that development lasts for an extra year. Specifically, assume that development costs of $$7\mathrm{.}2$ million and $$2\mathrm{.}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

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\mathrm{.}5\%.$ Explain intuitively why the results go in the direction they go$$that 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.