Solve the following problems in an Excel spreadsheet, # 1 for present values and #2 for rates.

PV | YR | Interest | FV | |

13 | 9% | 15451 | ||

4 | 7% | 51557 | ||

29 | 24% | 886073 | ||

PV | 40 | 35% | 550164 | |

181 | YR | Interest | FV | |

335 | 4 | 297 | ||

48000 | 18 | 1080 | ||

40353 | 19 | 185382 | ||

25 | 531618 |

#3 Solve current price for a 23 year bond with a coupon rate of 5.8% and a yield to maturity of 4.7%

#4 Solve for current price of a stock that paid a $1.95 dividend and expected to grow at a 4% rate with a required return of 10.5%.

#5 A company is expecting yearly cash inflows for the next four years in their new expansion investment of $50,000, $55,000, $80,000, and $120,000. Using a 8.5% discount rate, what is the sum of the present values of these expected cash inflows and should the company continue with this investment if the initial outlay is $200,000?