In Week 5(using the Decision-Making Examples manual), you developed a simple spreadsheet modelling for Acron, a large drug company. You answered several questions on company production of drugs and their effect on the financial investments(NPV). Now, use the fully developed spreadsheet (after completing the manual) and perform below changes on the model,

1. Modify Acron`s model so that development lasts for an extra year. Specifically, assume that development costs of $7.2million and $2.1million 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 discounted back to the beginning of year 1, and perform the same sensitivity analyses. Comment on the effects of this change in timing.