Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the largest shortage cash amount, and in what month dose it occur? Projected Cash Receipts for Tri-City Academy (Feb-May 2006) MONTH FEB MAR
What is the largest shortage cash amount, and in what month dose it occur?
Projected Cash Receipts for Tri-City Academy (Feb-May 2006) MONTH FEB MAR APR MAY TOTAL ITEM $63.600 $80,000 $63.600 $63,600 $270.800 2,000 Late Fees Telethon Income Foundation Grant State Grant 300 17,000 17,000 Club Donations Pre- & Post-Care Store Certificate S 30,000 2,000 40.000 8,000 7,600 2.000 2,000 TOTAL: $98,300 S94.700 S68.300 $85300 S346,600 Projeeted Cash Disbursements for Tri-City Academy (Feb-May 2006) ITEMMONTH FEB MAR MAY TOTAI ITEM Payroll Expense: Faculty& Staff 72,000 2,656 72.000 288.000 Substitute Teachers Retirement Withholding SUBTOTAL 700 72.700 ,000 700 77.700 72.700 6.250 298.456 25.000 PAYROLL & 75,356 Oher Expenses: Copier PSI& IN Gas 750 5,001 600 6,625 13.160 6,625 Office Supplies 1.600 5,200 1.272 8,580 8,500 4.800 300 3,000 Yearbooks&Ribbons 8,500 2,400 33.503 115.109 Sports Banquet Testing Evaluation TOTAL OTHER EXPENSES 11.800 64.323 Store Certificate Remittances TOTAL REGULAR EXPENSES 86.770 90.150 95.750 387.779 43,000 Capital Expenditures: 43,000 TOTAL CASH DISBURSEMENTS: ITEMMONTH FEB APR MAY TOTAL ITEM BEGINNING CASH Cash Receipts S5.000 $25,000 S25.000 $25,000 S5,000.00 94.700 158.109 (63.409) (38.409) 85,300 S346,600.00 95.750 S430.779.00 (10.450)S84.179.00 14.550 68,300 ash Disbursements +Net Cash Flow 86.770 11.530 16.530 25.000 (21.850) Cash Minimum Cash Balance Cash Suuplus/ (ShotfaS $25.000 (63,409) S S8.470.00 $8,470.00 S25,000.00 S63.409.00 $71,879.00 $25,000.00 $93,729.00 $25,000.00 S10.450.00 S104.179.00$104.179.00 $25,000.00 Cash Balance S25,000.00Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started