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 athritis. 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 a year 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 S3,000,000. Dr. Wolf thought there was a 70 percent probability this would happen Offer II Thirty percent of the buyer's gross profit on the product for the next four years. The buyer in this case was Zbay Pharmaceutical. Zbay's gross profit margin was 60 percent. Sales in year one were projected to be $2 million and then expected to grow by 40 percent per year For part (b) you need to use your calculator functions (PV, FV, PMT, /Y, and N) to estimate the value of each offer. Hint: To calculate the value of each offer you only need to calculate the PV (the value of the offer today). No need to calculate future values and then discount them back to present values. Using MS Excel (Spreadsheets) is NOT allowed. 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 athritis. 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 a year 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 S3,000,000. Dr. Wolf thought there was a 70 percent probability this would happen Offer II Thirty percent of the buyer's gross profit on the product for the next four years. The buyer in this case was Zbay Pharmaceutical. Zbay's gross profit margin was 60 percent. Sales in year one were projected to be $2 million and then expected to grow by 40 percent per year For part (b) you need to use your calculator functions (PV, FV, PMT, /Y, and N) to estimate the value of each offer. Hint: To calculate the value of each offer you only need to calculate the PV (the value of the offer today). No need to calculate future values and then discount them back to present values. Using MS Excel (Spreadsheets) is NOT allowed