Cash Receipts September October November December Sales $12,000 $15,000 $22,000 $18,000 Credit Sales 70% Cash Sales 30% Collections 1 month after sale 40% 2 months after sale 60% Total Cash Receipts $- $- Cash Budget November December Cash receipts $- $- Calc Above Cash payments 18,500 11,000 Given Net cash flow Calculate Beginning cash balance 5,000 5,000 Given Cumulative cash balance Calculate Monthly loan (or repayment) Calculate Cumulative loan balance Calculate Ending cash balance $0 $0 Calculate "Ending cash balance Student Check:" $5,000 $9,200