A B C D E F G H End of Year 1 End of Year 2 End of Year 3 End of Year 4 End of Year 5 End of Year 6 End of Year 7 End of Year 8 End of Year 9 End of Year 10 SO SO SO SO $12,000,000 $13,400,000 $17,200,000 $20,700,000 $15,800,000 $7,200,000 $0.0 $1 $2 $3 $4 $5 $6 $7 $8 $9 $10 O Approximately 23.5 million Americans are addicted to alcohol and other substances, costing the U.S. economy $300 billion in medical expenses and lost productivity. Your firm has spent $200 million to date working on a cure + for drug and alcohol addiction but is now at a crossroads. It can either abandon its program or invest another $60 million today that will guarantee O the discovery of the cure exactly one year from now. Then it will take another three years to get final approval from the Food and Drug Administration so that the drug can be sold. Suppose your firm plans to donate the patent at the end of the tenth year and expects to receive zero profits after that. The firm's opportunity cost is 5.5%. Expected year-end profits from selling the drug are presented in the worksheet "Q1 Calculations" of the provided Excel file. (1) (Calculating) In the worksheet "Q1 Calculations", enter the value of interest rate in column K and the value of current cost in column L (0.1 points), and calculate the net present value of the project in column Musing formulas (0.4 points). You may add more rows or columns to facilitate your calculations. (Ctrl)