Timeline Beginning Cash Balance Cash Collections Total Cash Available Cash Payments: Merchandise Purchases Sales Commissions Sales Salaries Cash Budget October November December Total $45,000 $145,000 $244,921 $45,000 $383,325 $553,050 $667,500 $1,603,875 $428,325 $698,050 $912,421 $1,648,875 $160,000 $386,380 $409,570 $955,950 $9,750 $12,750 $18,750 $41,250 $10,000 $10,000 $10,000 $30,000 Advertisting Expense $2,000 $2,000 $2,000 $6,000 General & Admin Salaries $12,500 $12,500 $12,500 $37,500 Clerical Wages $15,000 $15,000 $15,000 $45,000 Rent $13,500 $13,500 $13,500 $40,500 Office Supplies $375 $375 $375 $1,125 Prepaid Insurance - Expire December / Non Renewal $1,500 $1,500 Taxes Payable $68,500 $68,500 Long Term Debt Loan $55,000 $55,000 Line of Credit - Sept Total Cash Payments $100,000 $323,125 $100,000 $452,505 $606,695 $1,382,325 Cash on Hand $105,200 $245,545 $305,726 $266,550 Over/-Short for Cash Minimum Balance Requirement -$39,800 $100,545 $160,726 Interest Payment $1,117 $624 $624 $2,365 Loan Payment $74,917 $74,917 5 Line of Credit Borrowing Ending Cash Balance $40,917 $145,000 $0 $244,921 $0 $40,917 $230,185 $230,185 Minimum Cash Balance = $145,000 Interest 10%/Year = 0.0083%/Month