Finance Assignment PRESENT VALUE CALCULATIONS Homework Help

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?