, 22.06.2019 21:00 kebo63

# After hearing a knock at your front door, you are surprised to see the prize patrol from a large, well-known magazine subscription company. it has arrived with the good news that you are the big winner, having won \$21 million. you have three options.(a) receive \$1.05 million per year for the next 20 years.(b) have \$8.25 million today.(c) have \$2.25 million today and receive \$750,000 for each of the next 20 years. your financial adviser tells you that it is reasonable to expect to earn 13 percent on investments.

The requirement is to calculate the present value of each option:

\$ 11.26   million

\$11.5 million

\$ 12.52 million

Explanation:

The present value formula in excel is very useful in this case:

=-pv(rate,nper,pmt,fv)

rate is the 14% interest rate to be earned per year

nper is duration of the payment

pmt is the amount of payment expected per year

fv is the is the future worth of the payment which is unknown

Option 1:

=-pv(14%,20,1.7,0)=\$ 11.26   million

Option 2:

The amount receivable today is the present value i.e \$11.5 million

option 3:

=-pv(14%,20,1.4,0)=\$9.27   million

total =amount received today+\$ 9.27  million=\$3.25 million+\$ 9.27  millon=\$ 12.52 million

### Other questions on the subject: Business

If 1,000 shares of \$5 par common stock are reacquired by a corporation for \$12 a share, by how much will total stockholders' equity be reduced?
What is the relationship among market segmentation, target markts, and consumer profiles?