General
Weapons, Inc. (Comprehensive time value of money)
Mr.
Rambo, President of General Weapons, Inc., was pleased to hear that he had
three offers from major defence companies for his latest missile firing
automatic ejector. He will use a
discount rate of 10 percent to evaluate each offer.
|
Offer I |
$600,000 now plus $140,000 from the end of years 6 through
15. Also if the product goes over $60 million in cumulative sales by the end of year 15, he will receive an additional $1,800,000. Rambo thought there was an 80 percent probability this would happen. |
|
Offer II
|
Thirty percent of the buyer’s gross margin for the next four
years. The buyer in this case is Air Defence, Inc. (ADI). Its gross margin is 60 percent. Sales for year 1 are projected to be $1 million and then grow by 35 percent per year. This amount is paid today and is not discounted. |
|
Offer III
|
A trust fund would be set up for the next eight years. At the
end of that period, Rambo 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 $70,000 (a total of $140,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 the 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 then
indicate which one has the highest present value.
Please complete attached excel sheet.
SOLUTION PREVIEW TEMPLATE
|
Offer I
|
|
|
Amount now
|
600,000
|
|
Deferred annuity (payments begin Year 6 and end Year
15)
|
140,000
|
|
Potential bonus
|
1,800,000
|
File name:
General-Weapons.xls File type:
application/vnd.ms-excel PRICE: $10
