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