|
Interfund Loan upaated: 4/3o/2ooa
<br /> PW Property Purchase
<br /> Loan repayment schedule
<br /> Fleet Fund- 619 FY04 FY05 FY06 FY07 Total
<br /> Interfund Loan Portion
<br /> 619-9921-49290-000001 Ihterfund Loan Liquidated (274,700) (274,700) (274,700) (824,100)
<br /> 619-9911-47199-000000 Intertund Loan Interest (5,152) (25,000) (22,000) (11,000) (63,152)
<br /> 619-9991-97619-000000 Fleet Reserves 5,152 299,700 296,700 285,700 887,252
<br /> Fleet Fund "Loan" Portion
<br /> ~ 619-xxxx-44919-000000 Land & Building Rental (28,144) (28,144) (28,144) (84,432)
<br /> 619-9462-45584-000000 Equip. Rent Chgs (1,786) (76,135) (75,135) (71,135) (224,192)
<br /> 619-9991-97619-000000 Fleet Reserves 1,786 104,279 103,279 99,279 308,624
<br /> General Fund - 311 FY04 FY05 FY06 FY07 Total
<br /> 311-xxxx-44919-000000 Land & Building Rental (28,096) (28,096) (28,096) (84,288)
<br /> 311-9991-98000-000000 Balance Available (1,098) (35,764) (35,125) (32,781) (104,768)
<br /> ~ 311-9921-92290-000000 Principal Repaid-Interfund Loan 58,533 58,533 58,533 175,600
<br /> j 311-9911-86801-000000 Interfund Loan Interest 1,098 5,327 4,688 2,344 13,456
<br /> Road Fund - 312
<br /> i 312-xxxx-44919-000000 Land & Building Rental (47,376) (47,376) (47,376) (142,128)
<br /> 312-9991-98000-000000 Balance Available (1,851) (60,307) (59,229) (55,276) (176,662)
<br /> 312-9921-92290-000000 Principal Repaid-Intertund Loan 98,700 98,700 98,700 296,100
<br /> 312-9911-86801-000000 Interfund Loan Interest 1,851 8,983 7,905 3,952 22,690
<br /> Stormwater Fund - 531
<br /> 531-xxxx-44919-000000 Land & Building Rental (35,072) (35,072) (35,072) (105,216)
<br /> 531-9991-98000-000000 Balance Available (1,370) (44,644) (43,846) (40,921) (130,782)
<br /> 531-9921-92290-000000 Principal Repaid-Interfund Loan 73,067 73,067 73,067 219,200
<br /> ~ 531-9911-86801-000000 Interfund Loan Interest 1,370 6,650 5,852 2,926 16,798
<br /> ' Wastewater Fund - 532
<br /> 532-xxxx-44919-000000 Land & Building Rental (21,312) (21,312) (21;312) (63,936)
<br /> 532-9991-98000-000000 Balance Available (833) (27,129) (26,644) (24,866) (79,471)
<br /> 532-9921-92290-000000 Principal Repaid-Interfund Loan 44,400 44,400 44,400 133,200
<br /> 532-9911-86801-000000 Intertund Loan Interest 833 4,041 3,556 1,778 10,207
<br /> Total Principal Payments - 274,700 274,700 274,700 824,100
<br /> Total Interest Payments 5,152 25,000 22,000 11,000 63,152
<br />
<br /> i
<br /> Assumptions: Three year loan dated March 1, 2004; Drawdown effective April 1, 2004. Interest begins from April 1, 2004.
<br />
<br /> j Repayments made each June 30th starting in FY05.
<br /> Fleet Fund "Loan" Portion will be tracked in the Fund separately to ensure repayment occurs account 44919 & 45584.
<br /> Debt service is equal principal payments per year plus interest at the average rate earned by the investment portfolio.
<br /> Initial interest rate is estimated to be 2.5% in FY04, but will be adjusted to actual when determined.
<br /> The portfolio interest rate is estimated to be 3.0% in FY05 and 4.0% per annum thereafter.
<br /> Rental from the property of $160,000 per year will be applied as a revenue to each of the purchasing funds as follows:
<br /> General Road Stormwater Wastewater Fleet
<br /> Land & Building Rental 28,096 47,376 35,072 21,312 28,144
<br /> _ _ _
<br />
<br />
|