Dr. Harold Wolf of Medical Research Corporation (MRC) was thrilled with the resp
ID: 1232015 • Letter: D
Question
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.
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.
Offer III A trust fund would be set up for the next 8 years. At the end of that period, Dr. Wolf would receive the proceeds (and discount them back to the present at 10 percent). The trust fund called for semiannual payments for the next 8 years of $200,000 (a total of $400,000 per year).
The payments would start immediately. Since the payments are coming at the beginning of each period instead of the end, this is an annuity due. To look up the future value of an annuity due in the tables, add 1 to n (16 + 1) and subtract 1 from the value in the table. Assume the annual interest rate on this annuity is 10 percent annually (5 percent semiannually). Determine the present value of the trust fund’s final value.
Required: Find the present value of each of the three offers and indicate which one has the highest present value.
Explanation / Answer
Present values and cashflows tabulated below.
For offer 1, used 70% of 3000000 added to the final cash flow
For offer 2 cashflow = sales * margin * 30%. This grows by 40% every year
For offer 3 equivalent annual cashflow (equivalent to 2 semiannual cash flows) calculated as 200000 + 200000*(1+10%)^0.5 [interest for half year, for the first pament]
all these dicounted at 10% to present value.
So he should go with offer 1 as it gives the max PV.
Offer I
Offer I
Offer II
Offer II
Offer III
Offer III
Year
Value
PV
Value
PV
Value
PV
0
$ 1,000,000
$ 1,000,000
$ -
$ -
1
$ -
$ 180,000
$ 163,636
$ 409,762
$ 372,511
2
$ -
$ 252,000
$ 208,264
$ 409,762
$ 338,646
3
$ -
$ 352,800
$ 265,064
$ 409,762
$ 307,860
4
$ -
$ 493,920
$ 337,354
$ 409,762
$ 279,873
5
$ -
$ 409,762
$ 254,430
6
$ 200,000
$ 112,895
$ 409,762
$ 231,300
7
$ 200,000
$ 102,632
$ 409,762
$ 210,273
8
$ 200,000
$ 93,301
$ 409,762
$ 191,157
9
$ 200,000
$ 84,820
10
$ 200,000
$ 77,109
11
$ 200,000
$ 70,099
12
$ 200,000
$ 63,726
13
$ 200,000
$ 57,933
14
$ 200,000
$ 52,666
15
$ 2,300,000
$ 550,602
Present Value
$ 2,265,782
$ 974,319
$ 2,186,049
Please rate my answer!
Thanks in advance :)
Offer I
Offer I
Offer II
Offer II
Offer III
Offer III
Year
Value
PV
Value
PV
Value
PV
0
$ 1,000,000
$ 1,000,000
$ -
$ -
1
$ -
$ 180,000
$ 163,636
$ 409,762
$ 372,511
2
$ -
$ 252,000
$ 208,264
$ 409,762
$ 338,646
3
$ -
$ 352,800
$ 265,064
$ 409,762
$ 307,860
4
$ -
$ 493,920
$ 337,354
$ 409,762
$ 279,873
5
$ -
$ 409,762
$ 254,430
6
$ 200,000
$ 112,895
$ 409,762
$ 231,300
7
$ 200,000
$ 102,632
$ 409,762
$ 210,273
8
$ 200,000
$ 93,301
$ 409,762
$ 191,157
9
$ 200,000
$ 84,820
10
$ 200,000
$ 77,109
11
$ 200,000
$ 70,099
12
$ 200,000
$ 63,726
13
$ 200,000
$ 57,933
14
$ 200,000
$ 52,666
15
$ 2,300,000
$ 550,602
Present Value
$ 2,265,782
$ 974,319
$ 2,186,049
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.