Compute the future value in year 9 of a $2,000 deposit in year 1 and another

Click here for tutorial

Complete the following problem sets from Chapter 5 in Microsoft^® Excel^®:

•   5-1

•   5-3

•   5-5

•   5-7

•   5-12

•   5-15

5-39 (Calculate monthly payment only)

5-1   FutureValue Compute the future value in year 9 of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 using a 10 percent interest rate. (LG5-1)

5-3   Future Value of an Annuity What is the future value of a $900 annuity payment over five years if interest rates are 8 percent? (LG5-2)

5-5   Present Value Compute the present value of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 if interest rates are 10 percent. (LG5-3)

5-7   Present Value of an Annuity What’s the present value of a $900 annuity payment over five years if interest rates are 8 percent? (LG5-4)

5-12   Present Value of an Annuity Due If the present value of an ordinary, 6-year annuity is $8,500 and interest rates are 9.5 percent, what’s the present value of the same annuity due? (LG5-6)

5-15   Effective Annual Rate A loan is offered with monthly payments and a 10 percent APR. What’s the loan’s effective annual rate (EAR)? (LG5-7)

5-39   Loan Payments You wish to buy a $25,000 car. The dealer offers you a 4-year loan with a 9 percent APR. What are the monthly payments? How would the payment differ if you paid interest only? What would the consequences of such a decision be? 

Click here for tutorial

The following table shows your stock positions at the beginning of the year, the dividends that each

Click here for tutorial

Fin 370 week 3

Complete the following problem sets from Chapter 7 in Microsoft^® Excel^®:

•    7-21

•    7-27 

Complete the following problem sets from Chapter 8 in Microsoft^® Excel^®:

•    8-19

•    8-21

Complete the following problem sets from Chapter 9 in Microsoft^® Excel^®:

•    9-31

7-21 Compute Bond Price Compute the price of a 3.8 percent coupon bond with 15 years left to maturity and a market interest rate of 6.8 percent. (Assume interest payments are semiannual.) Is this a discount or premium bond? (LG7-4)

7-27 Yield to Maturity A 5.65 percent coupon bond with 18 years left to maturity is offered for sale at $1,035.25. What yield to maturity is the bond offering? (Assume interest payments are semiannual.) (LG7-6)

8-19   Value a Constant Growth Stock Financial analysts forecast Safeco Corp.’s (SAF) growth rate for the future to be 8 percent. Safeco’s recent dividend was $0.88. What is the value of Safeco stock when the required return is 12 percent? (LG8-5)

8-21   Expected Return Ecolap Inc. (ECL) recently paid a $0.46 dividend. The dividend is expected to grow at a 14.5 percent rate. At a current stock price of $44.12, what is the return shareholders are expecting? (LG8-5)

9-31  Portfolio Return The following table shows your stock positions at the beginning of the year, the dividends that each stock paid during the year, and the stock prices at the end of the year. What is your portfolio dollar return and percentage return? (LG9-7)

Click here for tutorial