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

PVYRInterest FV
139%15451
47%51557
2924%886073
PV4035%550164
181 YRInterest FV
3354297
48000181080
4035319185382
25531618

#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?

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support