12.4 Excel Project. REQUIRED a. Create a 12-month cash flow budget in Excel using the following assumptions: Initial sales of 15 million, with forecasted 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 b. Add a "spinner" to your spreadsheet that will enable you to easily change forecasted monthly sales growth to range from 0.5% to 1.5% in increments of 0.1%. c. Add a scroll bar to your spreadsheet that will let you modify the amount of initial sales to vary from $4 million to $6 million in increments of $100,000. d. Design appropriate data entry and processing controls to ensure spreadsheet accuracy. (Hint: For help on steps b and c, see the article "Dial a Forecast," by James A. Weisel, in the December 2006 issue of the Journal of Accountancy. The Journal of Accoun- tancy is available in print or online at the AICPA's Web site: www.aicpa.org.)* Anfa The Home art Page Layout Formulan Data Rev Vww Ca AA Gene Cer 617 12 Month Cash Budget Asunctions Initial Cash Sales Monthly Sales Growth Monthly cash sales 7% collected following month % collected in 2 months Nollected in 3 months 10 % Never collected 11tal Cash Balance 14 Beginning Cash Balance 13 Sales 16 Cash Sales 17 Collections prior sales 18 Ending Cash Balance 19 Numbe 9 Sarch Normal Bad Good Ner Conditional Format Calation Bled Gall Input January February March April May June July August September October November December