Completethe Questions and Problems in the Week 2 Questions and Problems Workbook.Note the Excelworkbook contains separate sheets with questions related to Chapters 5, 6, 7, and 8 of the textbook.

Showall work and analysis. Use the space provided on the worksheets.Expand the worksheets if necessary by inserting rows.The use ofExcelformulas for calculations is encouraged.

Calculate the missing Time Value of Money variable for each of the following sets of data: rate periods pmt present value Compute Future Value 5.25% 10 0 2,500 rate periods pmt present value Compute Future Value 2.50% 25 0 $1,000 rate periods pmt Compute Present Value future value 7.50% 35 0 $325,000 rate periods pmt Compute Present Value future value 4.40% 40 0 $325,000 Compute Interest Rate periods pmt present value future value 15 0 $1,500 $7,500 Compute Interest Rate periods pmt present value future value 5 0 $500 $750 rate Compute # of Periods pmt present value future value rate Compute # of Periods pmt present value future value 7.50% 0 $1,250 $7,500 3.50% 0 $10,000 $15,000 ing sets of data: Present Value and Multiple Cash Flows [LO1] Investment X offers to pay you $5,400 per year for eight years, wh Y offers to pay you $7,100 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount rate is 15 percent? Calculating Loan Payments [LO2, 4] You want to buy a new sports coupe for $84,750, and the finance office at t quoted you an APR of 5.5 percent for a 60-month loan to buy the car. What will your monthly payments be? What is the effective annual rate on this loan? er year for eight years, whereas Investment 5 percent? and the finance office at the dealership has Valuing Bonds [LO2] Even though most corporate bonds in the United States make coupon payments semiannu elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of to maturity, and a coupon rate of 5.2 percent paid annually. If the yield to maturity is 4.8 percent, what is the current price of the bond? Valuing Bonds [LO2] A local school district has a bond outstanding with a coupon rate of 3.5 percent paid semia years to maturity. The yield to maturity on this bond is 3.8 percent, and the bond has a par value of $5,000. What is the price of the bond? upon payments semiannually, bonds issued bond with a par value of 1,000, 18 years of 3.5 percent paid semiannually and 21 a par value of $5,000. Stock Values [LO1] A firm just paid a dividend of $2.10 per share on its stock. The dividends are expected to gro rate of 3.5 percent per year indefinitely. Investors require a return of 10.5 percent on stock. What is the current price? What will the price be in three years? In 15 years? Stock Valuation [LO1] Suppose you know that a company's stock currently sells for $74 per share and the requir stock is 12.0 percent. You also know that the total return on the stock is evenly divided between a capital gains y dividend yield. If the company's policy is to always maintain a constant growth rate in its dividends, what is the current divide dends are expected to grow at a constant tock. 4 per share and the required return on the between a capital gains yield and a what is the current dividend per share