Andahl Corporation stock, of which you own 500 shares, will pay a
$2-per-share dividend
one year from today. Two years from now Andahl will close its doors;
stockholders will
receive liquidating dividends of $17.5375 per share. The required rate
of return on Andahl
stock is 15 percent.
a. What is the current price of Andahl stock?
b. You prefer to receive equal amounts of money in each of the next
two years. How will
you accomplish this?

Please provide answer with an Excel file, thanks

=2/1.15 + 17.5375/1.15*1.15 = $15

b) price of stock end of year 1  = 17.5375 / 1.15 = 15.25
cashj end of year 1 = 2 * 500 + selli x shares @ 15.25
Solve this equation
   2*500 + 15.25 * x = (500-x)*17.5375
Sell 236 year 1 and rest year 2