I am having trouble calculating the present value for Offer I. Any help would be appreciated. There should be three answers to this one offer.
Dr. Harold Wolf of Medical Research Corporation (MRC) was thrilled with the response he had received from drug companies for his latest discovery, a unique electronic stimulator that reduces the pain from arthritis. The process had yet to pass rigorous Federal Drug Administration (FDA) testing and was still in the early stages of development, but the interest was intense. He received the three offers described below this paragraph. (A 10 percent interest rate should be used throughout this analysis unless otherwise specified.)
Offer I $1,000,000 now plus $200,000 from year 6 through 15. Also if the product did over $100 million in cumulative sales by the end of year 15, he would receive an additional $3,000,000. Dr. Wolf thought there was a 70 percent probability this would happen.© BrainMass Inc. brainmass.com June 3, 2020, 7:12 pm ad1c9bdddf
I calculated this solution with the attached Excel file (I used Excel's NPV function). See *ATTACHED* file for complete ...
A detailed response lies within this solution, including formulas/functions used to determine the results.