Bond Yield Calculator

Client: Investment: Prepared by: 117 $0.00 2 43.160% 3 43.160% 10 86.320% 0 5-Dec-06 ($2,345.00) Acquisition Cost 1 1-Apr-07 $234.00 $185.92 $648.85 $648.85 $0.00 ($2,345.00) 2 1-Oct-07 $234.00 $129.87 $1,191.15 $1,191.15 ($0.00) ($2,759.85) 3 1-Jan-08 $5,234.00 $2,029.05 $1,604.26 $1,604.26 ($0.00) ($3,717.01) 4 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 5 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 6 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 7 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 8 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 9 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 10 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 11 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 12 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 13 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 14 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 15 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 16 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 17 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 18 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 19 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 20 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 21 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 22 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 23 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 24 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 25 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 26 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 27 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 28 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 29 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 30 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 31 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 32 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 33 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 34 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 35 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 36 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 37 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 38 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 39 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 40 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 41 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 42 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 43 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 44 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 45 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 46 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 47 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 48 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 49 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) 50 $0.00 $0.00 $0.00 $0.00 $0.00 ($87.27) $3,357.00 $2,344.84 $3,444.27 MAX ERROR: $0.00 ($87.27) MIN ERROR: ($0.00) Days in First "Odd" Period: Greatest Common Devisor: Last Cash Flow Period: INCREASED ACCURACY Maximum Accuracy: Period Yield to Maturity: Required YTM per Period: Annual Yield: DIFFERENC E PRINCIPAL OUTSTANDING INPUTS PERIOD DATE CASH FLOWS DISCOUNT AMOUNTS INCOME CALCULATIO RESULTS Number of Decimal Places: 1/30/2008 12:16 AM $ASQ14.xls