Content is user-generated and unverified.

Aboriginal Housing Recovery Centre Limited (AHRCL)

Comprehensive Financial Analysis 2020-2024

Executive Summary

Aboriginal Housing Recovery Centre Limited is a not-for-profit organization dedicated to eliminating homelessness among Noongar people. This comprehensive analysis examines financial performance from 2020-2024, revealing critical financial challenges requiring immediate strategic intervention.

Key Finding: AHRCL transformed from exceptional financial health in 2020 to severe financial distress by 2024, with persistent liquidity crises and operational losses threatening organizational sustainability.

1. CONSOLIDATED FINANCIAL DATA

Primary Financial Statements Summary

Year	2020	2021	2022	2023	2024
Total Assets	$4,178,246	N/A	$10,116,494	$7,909,225	$7,322,776
Current Assets	$777,127	N/A	$50,596	$26,930	$108,073
Non-Current Assets	$3,401,119	N/A	$10,065,898	$7,882,295	$7,214,704
Total Liabilities	$29,636	N/A	$4,870,400	$4,067,735	$4,427,671
Current Liabilities	$29,636	N/A	$252,560	$244,283	$246,402
Non-Current Liabilities	$0	N/A	$4,617,840	$3,823,452	$4,181,270
Net Assets	$4,148,610	N/A	$5,246,094	$3,841,491	$2,895,105
Revenue	$4,330,359	N/A	$1,710,283	$1,084,335	$580,245
Net Profit/Loss	$4,148,606	N/A	$(528,841)	$(875,762)	$(946,386)
Cash & Equivalents	$423,681	N/A	$4,510	$(21,734)	$18,480

Note: 2021 financial data not available in provided documents

2. LIQUIDITY RATIOS ANALYSIS

2.1 Current Ratio Analysis

Formula: Current Assets ÷ Current Liabilities

Year	Current Assets	Current Liabilities	Current Ratio	Benchmark
2020	$777,127	$29,636	26.22	✅ Excellent
2022	$50,596	$252,560	0.20	❌ Critical
2023	$26,930	$244,283	0.11	❌ Severe Crisis
2024	$108,073	$246,402	0.44	❌ Poor

Trend Analysis:

Current Ratio Trend Chart
30 |████████████████████████████████ 26.22 (2020)
25 |
20 |
15 |
10 |
5  |
1  |---------------------------- Benchmark Line
0.5|           ▲ 0.44 (2024)
0  |      ▼ 0.20 (2022)  ▼ 0.11 (2023)
   2020    2021    2022    2023    2024

2.2 Quick Ratio (Acid-Test Ratio)

Formula: (Current Assets - Inventories) ÷ Current Liabilities

Year	Quick Assets	Current Liabilities	Quick Ratio	Assessment
2020	$775,955	$29,636	26.18	Exceptional
2022	$50,596	$252,560	0.20	Critical
2023	$26,930	$244,283	0.11	Severe
2024	$108,073	$246,402	0.44	Poor

2.3 Cash Ratio

Formula: Cash & Cash Equivalents ÷ Current Liabilities

Year	Cash	Current Liabilities	Cash Ratio	Assessment
2020	$423,681	$29,636	14.30	Exceptional
2022	$4,510	$252,560	0.02	Critical
2023	$(21,734)	$244,283	(0.09)	Crisis
2024	$18,480	$246,402	0.08	Very Poor

2.4 Operating Cash Flow Ratio

Formula: Operating Cash Flow ÷ Current Liabilities

Year	Operating Cash Flow	Current Liabilities	OCF Ratio	Quality
2020	$3,839,346	$29,636	129.57	Exceptional
2022	$(1,209,952)**	$252,560	(4.79)	Poor
2023	$(1,038,596)**	$244,283	(4.25)	Poor
2024	$(949,237)**	$246,402	(3.85)	Poor

Critical Finding: Negative operating cash flows from 2022-2024 indicate fundamental operational issues.

3. PROFITABILITY RATIOS ANALYSIS

3.1 Revenue Analysis

Year	Revenue	YoY Change	Cumulative Change
2020	$4,330,359	-	-
2022	$1,710,283	(60.5%)	(60.5%)
2023	$1,084,335	(36.6%)	(75.0%)
2024	$580,245	(46.5%)	(86.6%)

3.2 Net Profit Margin Analysis

Formula: Net Income ÷ Revenue × 100

Year	Revenue	Net Income	Net Profit Margin	Performance
2020	$4,330,359	$4,148,606	95.8%	Exceptional
2022	$1,710,283	$(528,841)	(30.9%)	Loss-making
2023	$1,084,335	$(875,762)	(80.8%)	Severe Loss
2024	$580,245	$(946,386)	(163.1%)	Critical Loss

3.3 Expense Structure Analysis

Expense Category	2022	2023	2024	Trend
Depreciation	$345,491	$398,133	$383,841	Stable
Interest Expense	$714,874	$566,758	$608,679	High
Professional Fees	$219,494	$140,843	$16,934	Decreasing
Agent Fees	$154,931	$60,365	$14,595	Decreasing
Council Rates	$(1,649)	$56,681	$22,711	Variable

4. LEVERAGE RATIOS ANALYSIS

4.1 Debt-to-Equity Ratio

Formula: Total Liabilities ÷ Net Assets

Year	Total Liabilities	Net Assets	D/E Ratio	Risk Level
2020	$29,636	$4,148,610	0.007	Very Low
2022	$4,870,400	$5,246,094	0.928	Moderate
2023	$4,067,735	$3,841,491	1.059	High
2024	$4,427,671	$2,895,105	1.529	Very High

4.2 Debt Service Coverage Analysis

Year	EBITDA	Interest Expense	Coverage Ratio
2022	$(183,350)	$714,874	N/A (Negative)
2023	$(477,629)	$566,758	N/A (Negative)
2024	$(562,545)	$608,679	N/A (Negative)

Critical Finding: Negative EBITDA makes debt service coverage impossible without asset sales.

5. EFFICIENCY RATIOS ANALYSIS

5.1 Asset Turnover Ratio

Formula: Revenue ÷ Total Assets

Year	Revenue	Total Assets	Asset Turnover	Efficiency
2020	$4,330,359	$4,178,246	1.04	Good
2022	$1,710,283	$10,116,494	0.17	Poor
2023	$1,084,335	$7,909,225	0.14	Poor
2024	$580,245	$7,322,776	0.08	Very Poor

5.2 Working Capital Analysis

Year	Current Assets	Current Liabilities	Working Capital
2020	$777,127	$29,636	$747,491
2022	$50,596	$252,560	$(201,964)
2023	$26,930	$244,283	$(217,353)
2024	$108,073	$246,402	$(138,329)

6. CASH FLOW ANALYSIS

6.1 Cash Flow Statement Summary

Cash Flow Category	2022	2023	2024
Operating Activities	$(1,209,952)	$(1,038,596)	$(949,237)
Investing Activities	$3,090,673	$476,657	$293,750
Financing Activities	$(1,945,205)	$535,695	$695,701
Net Change in Cash	$(64,483)	$(26,244)	$40,214

6.2 Cash Flow Trends

Operating Cash Flow Trend
$4,000,000 |████████████████████████████ $3.84M (2020)
$2,000,000 |
$0         |________________________
$(1,000,000)|    ████████ $(1.21M) 2022
$(1,500,000)|       ██████ $(1.04M) 2023
           |         ████ $(0.95M) 2024
           2020    2022    2023    2024

7. VISUAL FINANCIAL DASHBOARD

7.1 Financial Health Scorecard

Metric	2020	2022	2023	2024	Trend
Current Ratio	🟢 26.22	🔴 0.20	🔴 0.11	🔴 0.44	⬇️ Critical
Cash Position	🟢 $424K	🔴 $5K	🔴 $(22K)	🟡 $18K	⬇️ Severe
Profitability	🟢 95.8%	🔴 (30.9%)	🔴 (80.8%)	🔴 (163.1%)	⬇️ Critical
Debt Level	🟢 0.007	🟡 0.928	🔴 1.059	🔴 1.529	⬇️ High Risk

7.2 Net Assets Erosion Chart

Net Assets Decline (2020-2024)
$5,000,000 |████████████████████████████████ $4.15M (2020)
$4,000,000 |██████████████████████████ $3.84M (2023)  
$3,000,000 |██████████████████ $2.90M (2024)
$2,000,000 |
$1,000,000 |
$0         |
           2020    2021    2022    2023    2024
           
Loss of $1.25M (30.2%) over 4 years

8. GOING CONCERN ANALYSIS

8.1 Going Concern Indicators

Risk Factor	Status	Evidence
Liquidity Crisis	🔴 Critical	Current ratio < 0.5 for 3 years
Operating Losses	🔴 Critical	3 consecutive years of losses
Cash Flow Negative	🔴 Critical	Negative operating cash flows
Debt Burden	🔴 High	D/E ratio > 1.5
Revenue Decline	🔴 Severe	86.6% revenue decline

8.2 Auditor's Going Concern Qualification

2023 Audit Report: "Material uncertainty that may cast significant doubt on the entity's ability to continue as a going concern"

2024 Audit Report: "Net loss of $(946,386) and current liabilities exceeding current assets by $138,329"

9. FINANCIAL PROJECTIONS & SCENARIOS

9.1 Base Case Scenario (Current Trend)

Projection	2025E	2026E
Revenue	$350,000	$200,000
Operating Loss	$(800,000)	$(900,000)
Cash Position	$(50,000)	$(200,000)
Going Concern	❌ Unlikely	❌ Not Viable

9.2 Recovery Scenario (With Intervention)

Projection	2025E	2026E
Revenue	$800,000	$1,200,000
Operating Result	$(200,000)	$50,000
Cash Position	$200,000	$400,000
Going Concern	🟡 Possible	✅ Viable

10. KEY FINDINGS & RECOMMENDATIONS

10.1 Critical Findings

Liquidity Crisis: Current ratio collapsed from 26.22 to 0.44
Cash Emergency: Negative cash position in 2023, minimal recovery in 2024
Revenue Collapse: 86.6% decline from 2020 peak
Persistent Losses: Three consecutive years of operating losses
Debt Burden: Debt-to-equity ratio of 1.529 indicates over-leverage

10.2 Immediate Actions Required (0-3 months)

Emergency Cash Management
- Implement daily cash monitoring
- Negotiate payment deferrals with creditors
- Accelerate receivables collection
Cost Reduction Program
- Reduce operating expenses by 30-40%
- Eliminate non-essential expenditures
- Renegotiate supplier contracts
Asset Liquidation Strategy
- Identify non-core properties for immediate sale
- Engage real estate professionals
- Target $500K+ in quick asset sales

10.3 Medium-term Strategy (3-12 months)

Revenue Recovery Plan
- Diversify funding sources beyond property sales
- Develop fee-for-service programs
- Explore government grant opportunities
Debt Restructuring
- Negotiate with secured creditors
- Extend payment terms
- Consider debt consolidation
Operational Restructuring
- Focus on core mission activities
- Improve operational efficiency
- Implement performance monitoring

10.4 Long-term Sustainability (12+ months)

Strategic Partnership Development
- Collaborate with other Aboriginal organizations
- Explore merger opportunities
- Develop shared service arrangements
Business Model Innovation
- Develop sustainable revenue streams
- Create social enterprise initiatives
- Build endowment fund
Governance Enhancement
- Strengthen financial oversight
- Implement risk management
- Enhance board financial literacy

11. CONCLUSION

Aboriginal Housing Recovery Centre Limited faces an existential financial crisis requiring immediate and decisive action. The organization's transformation from exceptional financial health in 2020 to severe distress by 2024 represents one of the most dramatic financial deteriorations observed in the not-for-profit sector.

Critical Success Factors:

Immediate Liquidity: Must secure $200K+ cash within 60 days
Revenue Stabilization: Need to halt revenue decline and achieve $800K+ annually
Cost Control: Reduce operating expenses to match sustainable revenue levels
Debt Management: Restructure debt burden to manageable levels

Risk Assessment: CRITICAL

Without immediate intervention, AHRCL faces probable insolvency within 6-12 months. However, with proper management and strategic support, the organization can potentially recover and continue its vital mission of supporting Aboriginal housing needs.

The board and management must act swiftly to implement emergency measures while developing a comprehensive recovery plan to ensure long-term organizational sustainability and mission continuity.

Content is user-generated and unverified.