Finance

Sheet1

	Let Face Value(F)	1000
	Required yield,r	Price,P(17Year)	Price,P(12 Year)	Price,P(5 Year)
	0	1000.00	1000	1000
	1	741.92	861.35	905.29
	2	552.07	743.01	820.35
	3	411.99	641.86	744.09
	4	308.32	555.26	675.56
	5	231.38	481.02	613.91
	6	174.11	417.27	558.39
	7	131.37	362.45	508.35
	8	99.38	315.24	463.19
	9	75.37	274.54	422.41
	10	57.31	239.39	385.54
	11	43.68	209.00	352.18
	12	33.38	182.70	321.97
	13	25.57	159.89	294.59
	14	19.63	140.10	269.74
	15	15.10	122.89	247.18
	16	11.65	107.93	226.68
	17	9.00	94.89	208.04

17Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 1000 741.92291778712388 552.07088897991196 411.9867595159069 308.3186679734203 231.37744865585813 174.11013091063427 131.36711715458981 99.377332549801224 75.371136128043148 57.308553301167962 43.682816918726573 33.377923879916558 25.565052886950578 19.6270242881541 15.103054493884668 11.648240347074143 9.0037649234647326 12 year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 1000 861.34947482837902 743.01472998851932 641.86194739671771 555.26450271327485 481.01709809097019 417.26506073554037 362.44601964235966 315.24170496588994 274.53804131311779 239.3920493691634 209.00434665031869 182.69626126419928 159.89075297511917 140.0964820691587 122.89448520533649 107.92701398201538 94.888170619233321

Sheet2

Sheet3