I've been using Google Gemini for about 1 year for a variety of projects I am pursuing, projects ranging from learning about scientific subjects about which I am interested, researching travel destinations, researching financial and legel issues associated with CCRC's, and several others. I am now placing deposits on several CCRC's for a move when something becomes available.
Today I tried the following prompt: "Examine my Gemini history and tell me ways Gemini can be more useful to me." For all of us, our knowledge of using AI tools is evolving, of course. The Gemini response has helped me to rethink I can use this tool to utiize AI to make my workflow more efficient going forward.
As a retiree I'm not overly interested in a more efficient workflow but am learning more about the potential of this tool. While it is outside the scope of this forum, I think of how AI will affect the lives of our children and grandchildren. (good and bad)
Here is the Gemini response:
Create a comprehensive comparison template for analyzing CCRC balance sheets, statutory reserves, and financial disclosures.
Evaluating a Continuing Care Retirement Community (CCRC) requires looking past marketing materials to audit its long-term financial solvency. Entry fees often represent a significant portion of personal net worth, and life-plan contracts depend on the community remaining solvent for 15 to 30+ years.
To perform a thorough audit, request three documents from each community:
- Audited Financial Statements (includes Independent Auditor’s Report, Balance Sheet, Statement of Operations, and Cash Flows).
- Annual State Statutory Disclosure Statement (e.g., Florida Chapter 651 filings).
- Actuarial Summary / Study (required for Type A LifeCare contracts to assess future care obligations).
1. Key Financial Indicators & Health Benchmarks
MetricFormula / SourceHealthy BenchmarkCaution / Red Flag ZoneDays Cash on Hand (DCOH)$\frac{\text{Unrestricted Cash + Unrestricted Investments}}{(\text{Total Operating Expenses} - \text{Depreciation}) / 365}$Greater than 350 daysLess than 150 daysOperating Ratio$\frac{\text{Total Operating Expenses}}{\text{Operating Revenue (excl. Entry Fees)}}$Less than 95%Greater than 105% (reliant on new entry fees to pay operating costs)Debt Service Coverage Ratio (DSCR)$\frac{\text{Net Operating Income + Net Entry Fees}}{\text{Annual Principal + Interest Payments}}$Greater than 1.35xLess than 1.15x (risk of bond covenant default)CapEx to Depreciation Ratio$\frac{\text{Capital Expenditures}}{\text{Annual Depreciation Expense}}$Greater than 1.0xLess than 0.6x (indicates deferred maintenance)Independent Living Occupancy$\frac{\text{Occupied IL Units}}{\text{Total Available IL Units}}$Greater than 90%Less than 82%
2. Core Financial Audit Pillars
Pillar A: Balance Sheet & Solvency
- Unrestricted Net Assets: Verify that the organization has a positive unrestricted net asset balance. A persistent negative net asset position indicates past operational losses that have eroded capital.
- Long-Term Debt Structure: Check the notes on debt obligations. Identify whether debt is fixed-rate or variable-rate, and check the maturity schedule for large balloon payments coming due in the next 3 to 5 years.
- Investment Portfolio Mix: Review asset allocation. Excessively aggressive portfolios (high equity exposure) risk sudden liquidity drops during market downturns, while 100% cash portfolios lose purchasing power to inflation.
Pillar B: Statutory Reserve Adequacy
State regulatory bodies (such as Florida's Office of Insurance Regulation) enforce statutory reserve minimums. Compare actual reserves against legal minimums:
- Operating Reserve: Does the provider maintain liquid funds covering 15% to 30% of projected annual operating costs?
- Debt Service Reserve: Is there an escrow account containing at least 12 months of principal and interest payments held by a trustee?
- Renewal & Replacement Reserve: Are funds set aside specifically for major infrastructure repairs (roofing, HVAC, roads) separate from operating cash?
Pillar C: Entry Fee Liability & Contract Structure
- Refund Liability Accounting: On the Balance Sheet under Liabilities, look for "Refundable Entry Fees" or "Deferred Revenue from Entrance Fees."
- Repayment Triggers: Does the contract state refunds are paid only when the specific unit is re-occupied, or is there a fixed maximum timeframe (e.g., 120 days)?
- Occupancy Turnover Cash Flow: Ensure turnover entry fees received from incoming residents consistently exceed refund payouts to departing residents or beneficiaries.
3. Red Flag Checklist
Red Flag Warning: If a CCRC meets two or more of these criteria, require a written explanation from the CFO before committing funds.
- DCOH drop: Days Cash on Hand declined by more than 20% year-over-year.
- Operating Deficit: The community relies on initial entry fees to pay standard monthly operating bills rather than capital debt or reserves.
- Occupancy Decline: Independent living occupancy stays below 85% for two consecutive years.
- Management Turnover: Frequent changes in executive director or CFO within 24 months.
- Unfunded Deferred Maintenance: Low CapEx ratio combined with aging campus infrastructure (15+ years old without major renovations).
4. Multi-Community Comparison Scorecard
Use this template to evaluate and compare candidate CCRCs side-by-side:
Evaluation CriteriaWeightCommunity ACommunity BCommunity CContract Type (Type A / B / C / Rental)—Days Cash on Hand (DCOH)25%Occupancy Rate (IL)20%Operating Ratio (excl. Entry Fees)20%Debt Service Coverage Ratio (DSCR)15%CapEx / Depreciation Ratio10%Statutory Reserve Surplus over Minimum10%Total Weighted Score (1–10 Scale)100%