Question

In: Finance

Medical Research Corporation (Comprehensive time value of money) Dr. Harold Wolf of Medical Research Corporation (MRC)...

Medical Research Corporation (Comprehensive time value of money) 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 following 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 eight 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 eight 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.

Solutions

Expert Solution

Offer 1:
To find out the present value, all the future cash flows are to be discounted. $1,000,000 is not required to be discounted as it is received now. Additional $3,000,000 to be received at the end of 15 years has a probability of 70%. So we will take only 70% of its present value.
PV = 1,000,000 + 200,0000/(1+10%)^6 + 200,0000/(1+10%)^7 + 200,0000/(1+10%)^8…………….200,0000/(1+10%)^15 + 70% of 3000,000(1+10%)^15
PV = $ 2,265,782
Calculation as below:
(A) (B) (C) = (A)/(B)
Amount PV Factor PV
Year 0 10,00,000 0       10,00,000
Year 6 2,00,000 (1+10%)^6        1,12,895
Year 7 2,00,000 (1+10%)^7        1,02,632
Year 8 2,00,000 (1+10%)^8           93,301
Year 9 2,00,000 (1+10%)^9           84,820
Year 10 2,00,000 (1+10%)^10           77,109
Year 11 2,00,000 (1+10%)^11           70,099
Year 12 2,00,000 (1+10%)^12           63,726
Year 13 2,00,000 (1+10%)^13           57,933
Year 14 2,00,000 (1+10%)^14           52,666
Year 15 2,00,000 (1+10%)^15           47,878
Year 15* 21,00,000 (1+10%)^15        5,02,723
Total       22,65,782

*70% of $3,000,000 = $ 210,000 as there is 70% probability of receiving additional $3,000,000

Offer 2:
First, we will calculate the sales for the next four years.
Sales
Year 1                                                 20,00,000
Year 2 2,000,000 + 40% of 2,000,000 = 2,800,000
Year 3 2,800,000 + 40% of 2,800,000 = 3,920,000
Year 4 3,920,000 + 40% of 3,920,000 = 5,488,000
Now, we will discount the 30% of the gross margin on the yearly sales for next four years.
A B = A * 60% C = B * 30% D E = C/D
Sales Gross Margin (60% of sales) 30% of Gross Margin PV Factor PV
Year 1 20,00,000                              12,00,000                    3,60,000 (1+10%)^1    3,27,273
Year 2 28,00,000                              16,80,000                    5,04,000 (1+10%)^2    4,16,529
Year 3 39,20,000                              23,52,000                    7,05,600 (1+10%)^3    5,30,128
Year 4 54,88,000                              32,92,800                    9,87,840 (1+10%)^4    6,74,708
Total

19,48,637

PV = $ 1,948,637

Offer 3:
We can calculate the future value of the trust fund by adding all the future values of all the semi annual cash flows or directly by multiplying the semi annual cash flow with the annuity due future value factor from the table.
Method 1. Future value of all semi annual cash flows
A B C = A*B
Amount FV Factor Future value at end of 8 years
Beginning of first half of year 1 200000 (1+10%)^8                                    4,28,718
Beginning of 2nd half of year 1 200000 (1+10%)^7.5                                    4,08,766
Beginning of first half of year 2 200000 (1+10%)^7                                    3,89,743
Beginning of 2nd half of year 2 200000 (1+10%)^6.5                                    3,71,606
Beginning of first half of year 3 200000 (1+10%)^6                                    3,54,312
Beginning of 2nd half of year 3 200000 (1+10%)^5.5                                    3,37,823
Beginning of first half of year 4 200000 (1+10%)^5                                    3,22,102
Beginning of 2nd half of year 4 200000 (1+10%)^4.5                                    3,07,112
Beginning of first half of year 5 200000 (1+10%)^4                                    2,92,820
Beginning of 2nd half of year 5 200000 (1+10%)^3.5                                    2,79,193
Beginning of first half of year 6 200000 (1+10%)^3                                    2,66,200
Beginning of 2nd half of year 6 200000 (1+10%)^2.5                                    2,53,812
Beginning of first half of year 7 200000 (1+10%)^2                                    2,42,000
Beginning of 2nd half of year 7 200000 (1+10%)^1.5                                    2,30,738
Beginning of first half of year 8 200000 (1+10%)^1                                    2,20,000
Beginning of 2nd half of year 8 200000 (1+10%)^0.5                                    2,09,762
Total Future value                                  49,14,708
Future value of the trust fund = 4,914,708
Now Present value of this trust fund value = FV discounted by 10% for 8 years
PV = 4,914,708 * (1+10%)^8
PV= 2,292,747
Method 2:Multiplying the semi annual cash flow with the annuity due future value factor from the table.
FV factor for 10 cash flows ( 5 years * 2 as there are two paymenmts every year) for 5% interest rate (10% annual interest rate divided by 2 for semiannual interest rate) is 24.8404 from the table
Future value = 200,000*24.8404
Future value of the trust fund = 4,968,080
Now Present value of this trust fund value = FV discounted by 10% for 8 years
PV = 4,968,080 * (1+10%)^8
PV= 2,317,646
Please note that method 1 gives the exact values while method 2 gives an approximate value
After comparing all the offers, Offer 3 has highest present value

Related Solutions

"Time Value of Money " The time value of money is a critical concept to understand...
"Time Value of Money " The time value of money is a critical concept to understand in accounting, especially when dealing with loans, investment analysis, and capital budgeting decisions. The time value of money concept can be used to decide which projects to start and what investments to make. You can also utilize the time value of money concept in your personal life. Provide two (2) decisions you may need to make that could involve the time value of money....
"Time Value of Money " The time value of money is a critical concept to understand...
"Time Value of Money " The time value of money is a critical concept to understand in accounting, especially when dealing with loans, investment analysis, and capital budgeting decisions. The time value of money concept can be used to decide which projects to start and what investments to make. You can also utilize the time value of money concept in your personal life. Provide two (2) decisions you may need to make that could involve the time value of money....
Time value of money
How many years will it take for $136,000 to grow to be $468,000 if it is invested in an account with an annual interest rate of 8%?
What is time value of money? Whu problems may arise if time value of money is...
What is time value of money? Whu problems may arise if time value of money is not taken into consideration while making transactions? Explain theoretically how can these problems be dealt with?
Finance- Time Value of Money
    You believe you will need to have saved $500,000 by the time you retire in 40 years in order to live comfortably. If the interest rate is 6 percent per year, how much must you save each year to meet your retirement goal?  
Time Value Money Ice Breaker Discussion Please take a moment to click on "Time Value money"...
Time Value Money Ice Breaker Discussion Please take a moment to click on "Time Value money" topic and and share your understanding to that concept with the class.
Time value of money is a financial concept that illustrates how the value of money grows...
Time value of money is a financial concept that illustrates how the value of money grows over time. This takes into consideration that the money can be invested at a specified interest rate, that grows. One financial concept is present value (PV) and another financial concept is future value (FV). Discuss and show one example of how the present value formula is a good method to determine how much is needed to save monthly, in order to have a specified...
Time Value of Money Concept The following situations involve the application of the time value of...
Time Value of Money Concept The following situations involve the application of the time value of money concept. Use the full factor when calculating your results. Use the appropriate present or future value table: FV of $1, PV of $1, FV of Annuity of $1 and PV of Annuity of $1 1. Janelle Carter deposited $9,610 in the bank on January 1, 2000, at an interest rate of 15% compounded annually. How much has accumulated in the account by January...
Time Value of Money Concept The following situations involve the application of the time value of...
Time Value of Money Concept The following situations involve the application of the time value of money concept. Use the full factor when calculating your results. Use the appropriate present or future value table: FV of $1, PV of $1, FV of Annuity of $1 and PV of Annuity of $1 1. Janelle Carter deposited $9,510 in the bank on January 1, 2000, at an interest rate of 10% compounded annually. How much has accumulated in the account by January...
Time Value of Money Concept The following situations involve the application of the time value of...
Time Value of Money Concept The following situations involve the application of the time value of money concept. Use the full factor when calculating your results. Use the appropriate present or future value table: FV of $1, PV of $1, FV of Annuity of $1 and PV of Annuity of $1 1. Janelle Carter deposited $9,790 in the bank on January 1, 2000, at an interest rate of 12% compounded annually. How much has accumulated in the account by January...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT