Create a 12 month cash flow budget in Excel using the following assumptions:
• Initial sales of $5 million, with fore-casted monthly growth of 1%
• 40% of each month's sales for cash: 30% collected the following month, 20% collected 2 months later; 8% collected 3 months later; and 2% never collected
• Initial cash balance of $350,000