Problem 13.6 - 12 Month Cash Budget, expended Assumptions: Initial sales Monthly sales growth % monthly sales growth % monthly cash sales % collected following month % collected 2 months later % collected 3 months later % never collected Initial cash balance Cash outflows as % current month sales Desired ending cash balance each month Beginning loan Month Beginning Cash Balance Sales Cash Sales Collected prior sales Expenditures Tentative cash balance Desired end balance Amount borrowed Cash after loan loan repayment Ending cash balance roufaiel: Add spin button here roufaiel: Add scroll bar here 1% 8% 20/0 350,000.00 50,000.00 January 350,000.00 February March April