|
Mike Gaffron - Pricing Analysis- 11-14-01.XLS Page 9
<br /> City of Orono,Minnesota
<br /> Senior Housing Revenue Bonds, Series 2001
<br /> Wedum Foundation
<br /> Orono Senior Housing Project
<br /> PROJECT SUMMARY
<br /> Dated 11/01/2001 Delivered 11/29/2001
<br /> Senior Tax-Exempt Senior Taxable Subordinate Tax-Exe Issue Summary
<br /> SOURCES OF FUNDS
<br /> Par Amount of Bonds $7,825,000.00 $210,000.00 $250,000.00 $8,285,000.00
<br /> Deferred City Fees 200,000.00 - - 200,000.00
<br /> Accrued Interest from 11/01/2001 to 11/2912001 37,039.33 1,306.67 1,750.00 40,096.00
<br /> TOTAL SOURCES $8,062,039.33 $211,306.87 $251,750.00 $8,525,096.00
<br /> USES OF FUNDS
<br /> Deposit to Project Construction Fund 4,930,333.74 - 225,000.00 5,155,333.74
<br /> Land Acquisition 837,558.00 - - 837,558.00
<br /> Deposit to Capitalized Interest(CIF)Fund 593,413.33 22,074.94 29,564.66 645,052.93
<br /> Deposit to Debt Service Reserve Fund(DSRF) 579,437.50 - - 579,437.50
<br /> Development Fee&Misc Development Costs 333,577.00 - - 333,577.00
<br /> Total Underwriters Discount(2.425%) 195,625.00 5,250.00 - 200,875.00
<br /> City Fees 200,000.00 - - 200,000.00
<br /> Architectural and Engineering 164,300.00 - - 164,300.00
<br /> Costs of Issuance 141,867.00 8,750.00 - 150,617.00
<br /> F,F&E&Marketing&Management 143,211.00 - - 143,211.00
<br /> Construction Contingency 75,000.00 - - 75,000.00
<br /> Deposit to Debt Service Fund 37,039.33 1,306.67 1,750.00 40,096.00
<br /> Rounding Amount (169,322.57) 173,925.06 (4,564.66) 37.83
<br /> TOTAL USES $8,062,039.33 $211,306.67 $251,750.00 $8,525,096.00
<br /> FLOW OF FUNDS DETAIL
<br /> State and Local Government Series(SLGS)rates for
<br /> PRIMARY PURPOSE FUND SOLUTION METHOD Net Funded Net Funded Net Funded Net Funded
<br /> Total Cost of Investments $4,930,333.74 - $225,000.00 $5,155,333.74
<br /> Interest Earnings©2.500% 52,666.26 - - 52,666.26
<br /> TOTAL DRAWS $4,983,000.00 - $225,000.00 55,208,000.00
<br /> CAPITALIZED INTEREST FUND SOLUTION METHOD Net Funded Net Funded Net Funded Net Funded
<br /> Original Bond Proceeds 593,413.33 22,074.94 29,564.66 645,052.93
<br /> Accrued Interest 37,039.33 1,306.67 1,750.00 40,096.00
<br /> Interest Earnings @ 2.000% 11,243.89 418.39 560.34 12,222.62
<br /> Transfers from Debt Service Reserve Fund 32,948.45 - - 32,948.45
<br /> TOTAL DRAWS $674,645.00 $23,800.00 $31,875.00 $730,320.00
<br /> DEBT SERVICE RESERVE FUND SOLUTION METHOD Gross Funded Gross Funded Gross Funded Gross Funded
<br /> Total Cost of Investments $579,437.50 - - $579,437.50
<br /> Interest Earnings t5 4.000% 229,957.20 - - 229,957.20
<br /> Transfers to Capitalized Interest Fund (32,948.45) - - (32,948.45)
<br /> Transfers to Debt Service Fund (197,008.75) - - (197,008.75)
<br /> TOTAL DRAWS $579,437.50 - - $579,437.50
<br /> PRESENT VALUE ANALYSIS SUMMARY(NET TO NET)
<br /> NET PRESENT VALUE BENEFIT - - - -
<br /> &Mier Johnson Steichen Kinnard,Inc. File=WEDUMFOUNDATION.SF-Cyon-Wedum Foundation Series A,B&C-Issue Summary
<br /> Fixed Income Investment Banking Group 11/14/2001 1:40 PM
<br />
|