F,3,10,0,0,T,Bond Portf
G,3,6,0,0,T,olio a
H,3,5,0,0,T,nd An
I,3,8,0,0,T,alysis
C,5,4,0,0,T, Yrs
F,5,10,0,0,T,  Total
G,5,6,0,0,T,Total
I,5,8,0,0,T,  Cost
B,6,4,0,0,T,Int
C,6,4,0,0,T, To
D,6,7,0,0,T,   Par
F,6,10,0.00,2,T,Par Value
G,6,6,0.00,2,T, Comm
H,6,5,0.00,2,T,Purch
I,6,8,0.00,2,T,   Per
J,6,9,0.00,2,T,    Net
K,6,9,0.00,2,T,   Total
M,6,6,0.00,2,T, Day's
A,7,6,0,0,T,Bond
B,7,4,0.00,2,T,Rte
C,7,4,0,0,T, Hld
D,7,7,0,0,T,  Value
E,7,3,0,0,T, #
F,7,10,0.00,2,T, of Bonds
G,7,6,0.00,2,T, Paid
H,7,5,0.00,2,T,Price
I,7,8,0.00,2,T,  Bond
J,7,9,0.00,2,T,    Cost
K,7,9,0.00,2,T,    Cost
M,7,6,0.00,2,T, High
A,9,6,0,0,T, ABC
B,9,4,7.80,2,N,7.8
C,9,4,12,0,N,12
D,9,7,1000,0,N,1000
E,9,3,5,0,N,5
F,9,10,5000.00,2,F,(E9XD9)
G,9,6,15.00,2,N,15
H,9,5,0.95,2,N,0.95
I,9,8,950.00,2,F,(H9*D9)
J,9,9,4750.00,2,F,(E9*I9)
K,9,9,4765.00,2,F,(G9+J9)
M,9,6,86.00,2,N,86
A,10,6,0,0,T, XYZ
B,10,4,9.50,2,N,9.5
C,10,4,5,0,N,5
D,10,7,1000,0,N,1000
E,10,3,10,0,N,10
F,10,10,10000.00,2,F,(E10*D10)
G,10,6,15.00,2,N,15
H,10,5,0.90,2,N,0.90
I,10,8,900.00,2,F,(H10*D10)
J,10,9,9000.00,2,F,(E10*I10)
K,10,9,9015.00,2,F,(G10+J10)
M,10,6,0.98,2,N,0.98
A,11,6,0,0,T, XYZ
B,11,4,8.00,2,N,8
C,11,4,5,0,N,5
D,11,7,1000,0,N,1000
E,11,3,10,0,N,10
F,11,10,10000.00,2,F,(E11*D11)
G,11,6,15.00,2,N,15
H,11,5,1.00,2,N,1
I,11,8,1000.00,2,F,(H11*D11)
J,11,9,10000.00,2,F,(E11*I11)
K,11,9,10015.00,2,F,(G11+J11)
M,11,6,0.96,2,N,0.96
A,12,6,0,0,T,===========
B,12,4,0,0,T,===========
C,12,4,0,0,T,===========
D,12,7,0,0,T,===========
E,12,3,0,0,T,===========
F,12,10,0,0,T,===========
G,12,6,0,0,T,===========
H,12,5,0,0,T,===========
I,12,8,0,0,T,===========
J,12,9,0,0,T,===========
K,12,9,0,0,T,===========
M,12,6,0,0,T,===========
A,14,6,0.00,2,T,Tots:
D,14,7,3000,0,F,(D9:D11)
E,14,3,25,0,F,(E9:E11)
F,14,10,25000.00,2,F,(F9:F11)
G,14,6,45.00,2,F,(G9:G11)
J,14,9,23750.00,2,F,(J9:J11)
K,14,9,23795.00,2,F,(K9:K11)
M,14,6,87.94,2,F,(M9:M11)
A,16,6,0,0,T,Avgs:
B,16,4,6.32,2,F,(AVG(B9:B11))
C,16,4,7.3,1,F,(AVG(C9:C11))
D,16,7,1000,0,F,(AVG(D9:D11))
G,16,6,15.00,2,F,(AVG(G9:G11))
H,16,5,0.95,2,F,(AVG(H9:H11))
I,16,8,950.00,2,F,(AVG(I9:I11))
J,16,9,7916.67,2,F,(AVG(J9:J11))
K,16,9,7931.67,2,F,(AVG(K9:K11))
M,16,6,21.98,2,F,(AVG(M9:M11))