Reference no: EM132483645
Question 1: Use Excel to develop a monthly cash-flow budget for a preschool based on the information below. Assume that the board of directors does not allow for short-term borrowing. How much operating reserve or liquidity should the school have to embark on the preschool program? In what month will the end-of-the-month balance turn positive? In addition to answering these questions based on your cash-flow budget, please copy-paste or attach your Excel cash-based budget table to receive full credit for your work.
Revenues
Tuition fees: $100,000 paid monthly
Event income: $50,000 by Thanksgiving
Foundation support: $200,000 semiannually, May and November
Expenses
Salary and wages: $80,000 monthly
Rent and maintenance: $100,000 in January
Supply and food: $10,000 monthly
Administration and fundraising: $10,000 monthly