o be entered. The blue cells are "relationship" cells in which formulas are entered. The green cell ake facts, assumptions or estimates from input" cells Duta input: Projected Balance Sheet as of December 31, 20x0 u. Lasm recerpes budget: b. Cash receipts bedget: Cash s:es Cash collections frem credit sales (current month) Cath collections from eredt sales (prewous month) Total cash receipt c. Purchases budget: Iirventery puichases: Cash payments for purchases (current menth) Cash payments for puchases (previous month) Total cash payments fot inventory purchases Other expenses Sales salaries Adveriting and promotion Administrative salaties Interest on bonds Pioperty taxes Syles comenissions Total cash payments for other expenses Total cahh disbusements e. Summary cash budget: Cash receipts Cash disbursements Change in cash balance during period due to operations Sale of marketable securities Proceeds from bank loan Purchase of equipment Repayment of bank loan Interest on bank loan Payment of dividends Change in cash balance during first quarter Cash balance, 1/1/1 Cash balance, 3/31/1 1. Analysis of short term linancing needs: Projected cash balance as of December 31,200 Less: Minimum cash balance Cash available for equipment purchases Projected proceeds from sale of marketable securities Cash available L.ess. Cost of investment in equipment Required short-term bonrowing