Adult Day Care Financial Planning Tool

Adult Day Care Financial Planning Tool

Comprehensive startup budgeting, P&L projections, payer mix strategy, and location analysis

📊 Startup Budget Calculator

Licensing & Legal

$

Facility Costs

$
$

Equipment & Furnishings

$
$
$

Supplies & Services

$
$
$

Operating Capital

$
$

Total Startup Investment

$107,000

Recommended Funding Sources:

  • • SBA Loan: $74,900
  • • Personal Investment: $21,400
  • • Grants/Other: $10,700

📈 3-Year P&L Projections

Revenue Assumptions

Annual Operating Expenses

← Swipe to see all columns →
Metric Year 1 Year 2 Year 3

💡 Key Insights:

  • • Break-even occurs when net income is positive
  • • Target profit margin: 15-25% for sustainable operations
  • • Consider seasonal variations in occupancy rates
  • • Build in 5-10% buffer for unexpected expenses

💵 Payer Mix Strategy Planner

Payer Mix Percentages

Total: 100%

Daily Rates by Payer

Weighted Average Daily Rate

$77.50

Based on your payer mix percentages

Projected Annual Revenue

$362,700

At 60% occupancy (Year 1)

🎯 Payer Mix Strategy Recommendations:

Optimal Mix Targets:

  • • Private Pay: 40-60% (highest revenue)
  • • Medicaid: 20-40% (stable, predictable)
  • • VA Benefits: 10-20% (good rates, reliable)
  • • Insurance/Other: 5-15% (diversification)

Key Considerations:

  • • Higher private pay = higher revenue but less stability
  • • Medicaid certification takes time but ensures steady income
  • • Diversification reduces risk from single payer source
  • • Adjust mix based on local market demographics

📍 Location Scorecard & Analysis

📍 Location Scoring Criteria (1-10 scale):

Demographics:

Senior population density, income levels, cultural fit

Competition:

Number of competitors, market saturation, differentiation opportunity

Accessibility:

Proximity to residential areas, parking, public transit

Cost:

Rental/purchase price, utilities, property taxes

Zoning:

Zoning compliance, permit ease, building codes

🏆 Location Ranking

All projections are estimates and should be validated with local market research