Fin 306 | ||||||||||
The Financial Services Industry | Back to Assignments and Projects | |||||||||
Valuation
Worksheet
|
||||||||||
Money Market Instruments | ||||||||||
1.Find the market values of each of the following T Bills | ||||||||||
Days to Maturity | Discount Rate | Par | ANSWER | |||||||
1 | 91 | 4.1% | $ 100 | $ 98.964 | ||||||
2 | 91 | 5.2% | $ 100 | $ 98.686 | ||||||
3 | 143 | 6.6% | $ 10,000 | $ 9,737.833 | ||||||
4 | 56 | 6.6% | $ 10,000 | $ 9,897.333 | ||||||
5 | 364 | 5.5% | $ 1,000,000 | $944,388.889 | ||||||
2. Given the prices of the following T Bills, determine d, y, and y* Assume par = 100 | ||||||||||
Days to Maturity | Price | d | y | y* | ||||||
1 | 150 | 98.535 | 3.52% | 3.62% | 3.66% | |||||
2 | 22 | 99.767 | 3.81% | 3.87% | 3.95% | |||||
3 | 60 | 99.235 | 4.59% | 4.69% | 4.78% | |||||
3. Determine the market values of the following CD's (add-on interest) | ||||||||||
Days to Maturity | Annual Rate | Promised Payment | ANSWER | |||||||
1 | 90 | 4.0% | $ 50,500 | $ 50,000 | ||||||
2 | 125 | 6.0% | $ 12,500 | $ 12,245 | ||||||
3 | 270 | 7.5% | $ 8,850 | $ 8,379 | ||||||
Bonds | ||||||||||
1. Determine the prices of the following bonds (face value = $1000) | ||||||||||
Annual Coupon | Maturity (Years) | Annual YTM | ANSWER | |||||||
1 | 4.0% | 10 | 9.0% | $679.12 | ||||||
2 | 8.5% | 5 | 12.0% | $873.83 | ||||||
3 | 0.0% | 15 | 7.6% | $333.29 | ||||||
2. Determine the YTM on the following bonds (face value =$1000) | ||||||||||
Annual Coupon | Maturity (Years) | Price | ANSWER | |||||||
1 | 6.0% | 8 | $895.77 | 7.8% | ||||||
2 | 8.0% | 12 | $1,122.38 | 6.5% | ||||||
3 | 0.0% | 3 | $751.31 | 10.0% | ||||||
Mortgages | ||||||||||
1. Determine the monthly payment on the following mortgages | ||||||||||
Initial Months to Maturity | Loan Amount | Annual Interest Rate | ANSWER | |||||||
1 | 360 | $ 200,000 | 7.0% | $1,330.60 | ||||||
2 | 300 | $ 500,000 | 8.0% | $3,859.08 | ||||||
3 | 180 | $ 125,000 | 8.5% | $1,230.92 | ||||||
2. For the 3 mortgages above, what is the value of the mortgages after 5 years have elapsed | ||||||||||
given 1) the annual rates stay the same and 2) the rates increase 1 percentage point | ||||||||||
Rates Stay the Same | Rates Increase 1 percentage Point | |||||||||
1 | $188,263.18 | $172,399.20 | ||||||||
2 | $461,369.71 | $428,917.39 | ||||||||
3 | $99,279.56 | $95,127.33 |