ANALYSIS For each of the questions in (a) through (d), write one short paragraph to answer the question:

A. What is the largest surplus cash amount, if any, over the four months, and in what month does it occur?

B. What is the largest shortage cash amount, if any, over the four months, and in what month does it occur?

C. If there is a cash surplus in one or more months (refer to your answer in (a)), what could Tri-City Academy do with the surplus (after reviewing pertinent sections of Chapters 7 and 8, give some recommendations for how to utilize or deploy those funds)? If there is no month with a surplus, just answer not applicable for part (c).

D.) If there is a shortage in one or more months, what could Tri-City Academy do to deal with the shortfall, give some recommendations for how to obtain or free up the needed funds, bearing in mind that your recommendations have to be done in the middle of a school year and must have an effect on cash inflows or cash outflows within the next several months)? If there is no month with a shortage, just answer not applicable for part (d)

May TOTAL 270800 Projected Cash Receipts for Tri-City Academy (Feb-May 2020) Month Feb Mar Item Apr Tuition 63600 80000 63600 Athletic Fees 500 500 500 Late Fees 300 300 300 Telethon Income 0 0 0 Foundation Grant 0 0 0 State Grant 0 0 0 Registration Fees 30000 10000 0 Club Donations 2000 2000 2000 Pre- & Post-Care 1900 1900 1900 Store Certificate Sales 0 0 0 Other 0 0 0 TOTAL: 98300 63600 500 300 17000 0 1200 17000 0 0 0 2000 0 40000 8000 7600 1900 0 0 0 0 TOTAL 25,000 Projected Cash Disbursements for Tri-City Academy (Feb-May 2020) Month Feb Item Mar Apr May Payroll Expense: Faculty $72,000 $72,000 $72,000 $72,000 & Staff Substitute Teachers 0 2,656 0 5,000 Retiremt. Withholding 700 700 700 700 Subtotal: Payroll & 72,700 Other Empl. Exp. Payment to Church 6,250 6,250 6,250 6,250 Other Expenses: Copier 500 987 750 750 PSI & IN Gas 220 562 350 350 Misc. 500 5,001 1,000 1,000 Repair & Mainten. 300 100 100 100 Fundraising Expenses 6,625 Office Supplies 1,600 5,560 3,000 3,000 Postage 300 616 450 450 Athletic 1,000 1,800 1,200 1,200 Phone 400 272 300 300 Supplies 3,000 1,080 2,250 2,250 Yearbooks & Ribbons 8,500 Sports Banquet 2,400 2,400 Testing Evaluation 1,800 Total Other Exps. 7,820 Store Certificate 0 0 0 0 Remittances TOTAL REGULAR 86,770 EXPENSES: Capital Expenditures: 0 43,000 0 0 TOTAL CASH DISBURSEMENTS: 86,770 0 43,000 Projected Cash Budget (Feb-May 2020) Month Feb Mar Item Apr May TOTAL BEGINNING CASH $5,000 CASH RECEIPTS 98,300