Assignment

profileraa.o
answers_to_assignment1_2012_1.xls

Sheet1

Answers to assignment 1
simple loan
1 loan 11167.8955383024
2 future value 41354.756877215
3 yield 32.29%
fixed payment
1 fixed payment 3856.3868543512
2 loan 17719.0626619172
Coupon Bond
1 price 5290.8098991675
coupon rate 1.67%
current yield 1.89%
2 p 1 year 11775.7009345794
p 2 year 11566.0756397939
p 3 year 11370.1641493401
3 if i increases, prices will fall
discount bond
1 yield 5.00%
2 yield to maturity 21.00%
yield on discount basis 20.00%
3 price 14575.1037293922
yield on discount basis 5.67%
consol bond
1 coupon payment 1050
2 price 2857143
3 yield 0.60%
extra problems
1 present value 3118
2 present value 28486.4888453004
3 trust fund 300000
4 future value 6620.25
5 future value 7350.258
6 trust fund 1090909

Sheet2

Sheet3

Sheet4