4.1 - Financial Report
Unrestricted Cash On Hand
Checking = $5,615
Undeposited Funds = $11,319
Operating Savings = $2,378
Total = $19,312
Undeposited Funds = $11,319
Operating Savings = $2,378
Total = $19,312
Q4 Forecasted Revenue
April = $26,400
May = $32,500
June = $62,700
Total = $121,600 + Checking + Undeposited = $138,534
May = $32,500
June = $62,700
Total = $121,600 + Checking + Undeposited = $138,534
Unearned Revenue
ARDA = $40,000
Conference = $3,600
Total = $43,600
Conference = $3,600
Total = $43,600
Oustanding Debt
VISA = $21,231
Other = $4,228
Subtotal = $25,459
Steve = $8,201 ($9401 by June 30)
Other = $4,228
Subtotal = $25,459
Steve = $8,201 ($9401 by June 30)
Forecasted Fixed Costs
April = $28,600
May = $21,400
June = $33,600 (includes $10,000 to savings)
Total = $83,600
May = $21,400
June = $33,600 (includes $10,000 to savings)
Total = $83,600
Forecasted Variable Costs
Insurance Reinstatement = $7000 (E&O, Directors, Cyber)
Prepaid ARDA = $1800
Board/Council Travel = $6000
Total = $14,800
Prepaid ARDA = $1800
Board/Council Travel = $6000
Total = $14,800
Q4 Cashflow Forecast
Total Revenue and Unrestricted Cash = $138,534
Fixed Expenses = -$83,600
Variable Expenses = -$14,800
Outstanding Debt = -$25,459
Subtotal = $14,675
Unearned Revenue = -$43,600
We will be "eating into" our deferred revenue by $28,925
Based on the past three years, ARDA produces a $24,700 "profit" (average)
Fixed Expenses = -$83,600
Variable Expenses = -$14,800
Outstanding Debt = -$25,459
Subtotal = $14,675
Unearned Revenue = -$43,600
We will be "eating into" our deferred revenue by $28,925
Based on the past three years, ARDA produces a $24,700 "profit" (average)
