Spreadsheet: phillip_allen__29456__Phillip Allen Muni Bond Proposal
Sheet: Proposal

 |  |  |  |  |  |  |  |  |  |  |  |  | Proposal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculations
 |  |  |  |  |  |  |  |  |  |  |  | Settlement: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select Lower of
($000's) |  |  |  |  | [NAME]. | [NAME]. Call | Par | Pre-Re |  |  |  |  |  |  |  |  |  |  |  |  | Annual Income |  | [NAME] |  | Weighted Days to Maturity |  |  | Weighting | Weighted Yield |  |  | Current Yield |  | Average Cost |  |  |  | Proceeds/Cost |  |  | Accrued % |  |  |  |  | New |  |  |  | Average Weighted Coupon |  |  |  | YTM | YTC | YTC |  | Call/Mat Yld | What Call
Par | Rating | Description | Coupon | Maturity | Call | Price | Call | Y/N | Price | YTC | YTM | CY | TEY* |  |  |  | Pre-Re  TRUE/FALSE | Effective Mat | Redemption $ | Row # |  |  | % of Market Value |  | (Select Maturity Date) | DAYS360(SD, [NAME] ) | If C6=0,0,AC6 | (Y6*AC6) | If B6=0,0,AG | Yield | Yield x % of Par | Select Coupon | %/(mkt px/100) | (Face*Bid) |  |  |  | (Bid_Price*10*Face Value) |  |  | 6m0/bond |  | %6mo |  |  | Issue |  |  |  | (Coupon * %0f Par Weighting) |  |  |  |  | PREMIUM | PAR |  | (IF/Then) | Pr,Par,Mat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
*  [NAME] a ______combined effective Federal and _____ State income tax bracket and that all bonds are free from both federal and state income tax . However certain states
(Illinois, Iowa, Oklahoma, and Wisconsin) generally tax the interest from in-state bonds, therefore the taxable equivalents for those states assume a bond exempt only from
federal taxes. Intangible taxes are not considered.