Assignment - Annuity/Retirement
A. If you deposited the following amount per month (6 X $80) from your paycheck from the time you are 36 until you retire (at age 75) and your employer contributed an extra 6%, how much wealth would you have accumulated? The annual interest rate you will earn should be = 6 X 1.10%.
B. Based on your final answers to A above, what would your retirement income be once you retired if you
a. earned 5.5% and only lived off the earnings (did not draw down the principle-every month you took out the interest and left the initial amount to earn the same amount of interest-think simple interest)
b. earned 5.5% and created an annuity to last until you were 90 years old (this means that by age 90 your balance should be equal to zero).
Loan Amortization Problem
Now assume that your annual salary = 6 x $45,000 and that the bank you want to borrow from, has determined that it will lend you,
loan amount= your annual salary x 2.5
interest rate = 17 x 0.9%
Assume that you will borrow for 15 years and you will make monthly payments at the end of each month.
A) Calculate your monthly payment (Type your calculator inputs, i.e. N=, PV= and so on)
B) Calculate the total interest amount you will pay over the life of the loan
C) Fill in (type) the missing values in the amortization table below based on your payment found in A. Accuracy should be six decimals.
Month
|
Beginning Balance
|
Payment
|
Interest payment
|
Principal Payment
|
Ending Balance
|
1
|
|
|
|
|
|
2
|
|
|
|
|
|
3
|
|
|
|
|
|
4
|
|
|
|
|
|
5
|
|
|
|
|
|
Assignment-Bonds
A. From the list of following bonds identify the bond that is least sensitive to interest rate and the bond that is the most sensitive to interest changes. Justify your selections.
Bond
|
Maturity (years
|
YTM (%)
|
Coupon Rate (%)
|
A
|
15
|
8
|
7.1
|
B
|
15
|
6
|
7.4
|
C
|
15
|
8
|
7.5
|
D
|
30
|
6
|
7.1
|
E
|
30
|
6
|
7.0
|
B. A bond that was issued 5 years ago had an original time to maturity of 30 years, a YTM of 7.5%, a coupon rate of 8.2% and made semi-annual coupon payments. Today interest rates on similar bonds have dropped 0.25%. Calculate the new bond price. Show all your calculator inputs and adjustments made.
Assignment - Stocks
A. Identify all the following stocks as overpriced, underpriced or fairly valued. For all calculations assume a market risk premium of 5.3% and a risk free rate of 3%. Show also your calculations.
Stock
|
E(Ri)
(%)
|
βi
|
Stock classification
(over, under or fairly valued)
|
A
|
22.15
|
5
|
|
B
|
12.08
|
-1.7
|
|
C
|
11.20
|
1
|
|
D
|
9.36
|
1.2
|
|
B. Calculate the price of a stock that will pay its first dividend of $1.25 one year from now and your required rate of return for this stock is 12%. Dividends are expected to grow at 20% for the first 15 years and their growth rate will drop to a steady 3% every year thereafter.