<17/08/2012 /> Analysis of Current Assets - Table No 1A.<17/08/2012 /> <17/08/2012> Quarter 2 <17/08/2012>30/06/2012 <17/08/2012>€ Stock<17/08/2012> 5,093,077 Urban Account<17/08/2012 /> <17/08/2012 /> Trade Debtors & Prepayments<17/08/2012 /> - Development Levy Debtors<17/08/2012> 46,251,603 - Agency Debtors<17/08/2012> - - Rates Debtors<17/08/2012> 242,742,748 - Other Debtors<17/08/2012> 189,582,780 Amounts due within I year<17/08/2012> 20,300,000 Total Debtors Gross Debtors<17/08/2012> 498,877,131 <17/08/2012 /> Less Provision for Doubtful Debts<17/08/2012 /> - Development Debtors <17/08/2012> 27,750,961 - Other Debtors<17/08/2012> 70,059,904 <17/08/2012 /> Add Prepayments<17/08/2012 /> <17/08/2012 /> - Prepayments<17/08/2012> 17,085,896 <17/08/2012 /> Debtors ( Per AFS )<17/08/2012> 418,152,162 <17/08/2012 /> Bank Investments<17/08/2012> 31,494,762 Cash at Bank<17/08/2012> - Cash on Hand<17/08/2012> 314,102 Total Cash Balances<17/08/2012> 31,808,864 <17/08/2012 /> Total Curent Assets<17/08/2012> 455,054,103 <17/08/2012 /> Deposits Invested Table No 1B<17/08/2012 /> <17/08/2012> Quarter 2 <17/08/2012>30/06/2012 <17/08/2012> € NTMA<17/08/2012> - Other Local Authorities<17/08/2012> - Holdings of Short-term paper issued by HFA<17/08/2012> - Other Financial Institutions<17/08/2012> 31,494,762 Total<17/08/2012> 31,494,762 <17/08/2012 /> <17/08/2012 /> Analysis of Current Liabilities - Table 2<17/08/2012 /> <17/08/2012> Quarter 2 <17/08/2012>30/06/2012 <17/08/2012>€ Bank Overdraft<17/08/2012> 15,514,588 <17/08/2012 /> Creditors and Accruals<17/08/2012 /> General Creditors<17/08/2012> 46,168,722 Accruals<17/08/2012> 87,239,842 Deferred Income - Rates<17/08/2012> 170,630,254 Deferred Income - Non Development Debtors (Other)<17/08/2012> 37,921,008 Amounts due within I year<17/08/2012> 28,500,000 Total Creditors (per afs)<17/08/2012> 370,459,826 <17/08/2012 /> Urban Account<17/08/2012> - Finance Leases<17/08/2012> - <17/08/2012 /> Total Current Liabilities<17/08/2012> 385,974,414 <17/08/2012 /> Analysis of Creditors (More than one year) Table 3<17/08/2012 /> <17/08/2012> Quarter 2 <17/08/2012>30/06/2012 <17/08/2012>€ <17/08/2012 /> Loans Payable<17/08/2012> 879,842,667 Finance Leases<17/08/2012> - Refundable Deposits<17/08/2012> 3,494,762 Deferred Income - Development Debtors ( Must Match Line 118)<17/08/2012> 36,100,944 <17/08/2012 /> Total<17/08/2012> 919,438,373 <17/08/2012 /> <17/08/2012 /> Analysis of Long-Term Loans Payable by Lender - Table no 3A.<17/08/2012 /> <17/08/2012> Quarter 2 <17/08/2012>30/06/2012 <17/08/2012>€ HFA <17/08/2012> 879,486,320 OPW<17/08/2012> - NTMA<17/08/2012> - National Development Finance Agency<17/08/2012> - Other Local Authorities<17/08/2012> - Other Financial Institutions<17/08/2012> 28,856,347 Other<17/08/2012> - Sub Total<17/08/2012> 908,342,667 Less amounts falling due within one year<17/08/2012> 28,500,000 Total Amounts Due after one year( Must agree with total @ row 63<17/08/2012> 879,842,667 <17/08/2012 /> Application of Loans of Loans Payable -Table 3B<17/08/2012 /> <17/08/2012> Quarter 2 <17/08/2012>30/06/2012 <17/08/2012>€ Mortgage Loans<17/08/2012> 217,014,573 Assets/Grants<17/08/2012> 200,022,787 Revenue Funding<17/08/2012> - Bridging Finance<17/08/2012> 91,641,989 Recoupable<17/08/2012> - Shared Ownership - Rented Equity<17/08/2012> 133,675,170 Inter Local Authority<17/08/2012> - Voluntary Housing<17/08/2012> 265,988,148 Sub Total<17/08/2012> 908,342,667 Less amounts falling due within one year<17/08/2012> 28,500,000 Total Amounts Due after one year( Must agree with total @ row 63<17/08/2012> 879,842,667 <17/08/2012 /> Analysis of Long Term Debtors - Table No 4.<17/08/2012 /> <17/08/2012> Quarter 2 <17/08/2012>30/06/2012 <17/08/2012>€ Long Term Mortgage Related Advances<17/08/2012> 230,217,263 Tenant Purchases Advances<17/08/2012> 9,349,526 Shared Ownership Rented Equity<17/08/2012> 129,190,983 Voluntary Housing<17/08/2012> 265,988,148 Inter local Authority Loans<17/08/2012> - Development Debtors (Must Match Line 73)<17/08/2012> 36,100,944 Long Term Investments<17/08/2012 /> - Cash<17/08/2012> - - Associated companies<17/08/2012> - Other<17/08/2012> - Sub Total<17/08/2012> 670,846,864 Less amounts due within one year<17/08/2012> 20,300,000 Total Amounts Due after more than one year<17/08/2012> 650,546,864 <17/08/2012 /> Net Balance GGB Balance<17/08/2012>-199,811,820 Change in GGB<17/08/2012> 384,140 <17/08/2012 /> <17/08/2012 /> Projected Change in Borrowings Table No 5.<17/08/2012 /> <17/08/2012 /> <17/08/2012 /> <17/08/2012>€ Quarter 3 2012<17/08/2012> 5,000,000 <17/08/2012 /> <17/08/2012 /> <17/08/2012 /> Forecast Development Contributions - Table No 6<17/08/2012 /> <17/08/2012 /> <17/08/2012 /> <17/08/2012 /> <17/08/2012> Outturn 2012 Income Development Contributions<17/08/2012> 12,000,000