NEGAT HOUSING ASSOCIATION DETAILED FINANCIAL AUDIT & PROJECT PROGRESS REPORT (Derived directly from Excel Workbooks: New mebers contribution update Uxls.xlsx & New Nigat Expense Update xls.xlsx) 1. Executive Summary & Core Financial Overview Negat Housing Association comprises 72 active members working together toward constructing their multi-family residential housing complex. Construction has successfully reached the 1st Floor Columns Established phase. High-Level Financial Snapshot Account / Fund Category Total Collected (ETB) Total Expended (ETB) Net Balance (ETB) Main Construction Fund (Blocked Account) 129,333,664.92 88,898,698.34 +40,434,966.58 Administrative Fund (Sira Maskeja Account) 2,593,500.00 1,865,101.74 +728,398.26 Pitty Cash Account (Operational Ledger) 4,051,000.00 3,730,203.48 +320,796.52 COMBINED CASH ON HAND 135,978,164.92 94,494,003.56 +41,484,161.36 2. Detailed Member Contribution Breakdown The association maintains 72 members categorized across two residential unit sizes: 3-Bedroom Units: 54 Members 2-Bedroom Units: 18 Members Established Contribution Schedule per Member Contribution Phase 3-Bedroom Unit Rate 2-Bedroom Unit Rate Target Total Collection 1st Deposit (AA Housing Order) ETB 1,083,110.38 ETB 773,200.19 ETB 72,403,664.92 1st Round Contribution ETB 520,000.00 ETB 440,000.00 ETB 36,000,000.00 2nd Round Contribution ETB 520,000.00 ETB 440,000.00 ETB 36,000,000.00 3rd Round Contribution ETB 520,000.00 ETB 440,000.00 ETB 36,000,000.00 Sira Maskeja (Admin Fee) ETB 65,500.00 ETB 65,500.00 ETB 4,716,000.00 Collection Performance & Compliance Audit ======================================================================================== COLLECTION ROUND PAID MEMBERS DEFAULTING MEMBERS TOTAL COLLECTED (ETB) ======================================================================================== 1st Deposit (AA Order) 72 / 72 0 members 72,403,664.92 1st Round 66 / 72 6 members 33,150,000.00 2nd Round 45 / 72 27 members 22,220,000.00 3rd Round 3 / 72 69 members 1,560,000.00 ---------------------------------------------------------------------------------------- MAIN FUND SUBTOTAL ETB 129,333,664.92 ---------------------------------------------------------------------------------------- Sira Maskeja (Admin) 72 / 72 (Part) Varies ETB 2,593,500.00 ======================================================================================== Defaulter / Pending Member Lists (As recorded in Excel) 1. 1st Round Contribution Pending Members (6 Members): 2. o Medina Akmal Nesru o o Ejigayehu Seiyum Geberahiwot o o Fekerta Alemu Werdofa o o Leyela Jemal Mohammed o o Mohamed Ebrahim Mohamed o o Suna Mohammed Seif o 3. 2nd Round Contribution Pending Members (22 Key Identified Defaulters): 4. o Aberham Bekele Shewanga, Abinet Getachew Kassa, Aragaw Ali Hassen,
NEGAT HOUSING ASSOCIATION DETAILED FINANCIAL AUDIT & PROJECT PROGRESS REPORT (Derived directly from Excel Workbooks: New mebers contribution update Uxls.xlsx & New Nigat Expense Update xls.xlsx) 1. Executive Summary & Core Financial Overview Negat Housing Association comprises 72 active members working together toward constructing their multi-family residential housing complex. Construction has successfully reached the 1st Floor Columns Established phase. High-Level Financial Snapshot Account / Fund Category Total Collected (ETB) Total Expended (ETB) Net Balance (ETB) Main Construction Fund (Blocked Account) 129,333,664.92 88,898,698.34 +40,434,966.58 Administrative Fund (Sira Maskeja Account) 2,593,500.00 1,865,101.74 +728,398.26 Pitty Cash Account (Operational Ledger) 4,051,000.00 3,730,203.48 +320,796.52 COMBINED CASH ON HAND 135,978,164.92 94,494,003.56 +41,484,161.36 2. Detailed Member Contribution Breakdown The association maintains 72 members categorized across two residential unit sizes: 3-Bedroom Units: 54 Members 2-Bedroom Units: 18 Members Established Contribution Schedule per Member Contribution Phase 3-Bedroom Unit Rate 2-Bedroom Unit Rate Target Total Collection 1st Deposit (AA Housing Order) ETB 1,083,110.38 ETB 773,200.19 ETB 72,403,664.92 1st Round Contribution ETB 520,000.00 ETB 440,000.00 ETB 36,000,000.00 2nd Round Contribution ETB 520,000.00 ETB 440,000.00 ETB 36,000,000.00 3rd Round Contribution ETB 520,000.00 ETB 440,000.00 ETB 36,000,000.00 Sira Maskeja (Admin Fee) ETB 65,500.00 ETB 65,500.00 ETB 4,716,000.00 Collection Performance & Compliance Audit ======================================================================================== COLLECTION ROUND PAID MEMBERS DEFAULTING MEMBERS TOTAL COLLECTED (ETB) ======================================================================================== 1st Deposit (AA Order) 72 / 72 0 members 72,403,664.92 1st Round 66 / 72 6 members 33,150,000.00 2nd Round 45 / 72 27 members 22,220,000.00 3rd Round 3 / 72 69 members 1,560,000.00 ---------------------------------------------------------------------------------------- MAIN FUND SUBTOTAL ETB 129,333,664.92 ---------------------------------------------------------------------------------------- Sira Maskeja (Admin) 72 / 72 (Part) Varies ETB 2,593,500.00 ======================================================================================== Defaulter / Pending Member Lists (As recorded in Excel) 1. 1st Round Contribution Pending Members (6 Members): 2. o Medina Akmal Nesru o o Ejigayehu Seiyum Geberahiwot o o Fekerta Alemu Werdofa o o Leyela Jemal Mohammed o o Mohamed Ebrahim Mohamed o o Suna Mohammed Seif o 3. 2nd Round Contribution Pending Members (22 Key Identified Defaulters): 4. o Aberham Bekele Shewanga, Abinet Getachew Kassa, Aragaw Ali Hassen,
Created using ChatSlide
The project overview highlights a total of 72 members with 54 three-bedroom and 18 two-bedroom units, and construction has progressed to the first-floor columns, raising ETB 135.98 million across three funds. Compliance audits show full payment from the first round, while the second round has 27 members pending. Key decisions include implementing a tracker for overdue contributions, confirming second-round defaulters, and ensuring liquidity through cash controls.