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

PVYRInterest FV
181 YRInterest FV

#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