A Pharmaceutical manufacture has projected net profits for a new drug that is being released to the market over the next five years: Use a spreadsheet to find the net present value of these cash flows for a discount rate of 3%.
Year Net Profit
1 $(300,000,000)
2 $(145,000,000)
3 $50,000,000
4 $125,000,000
5 $530,000,000