Question: REQUIRED Create a 12-month cash flow budget in Excel using the following assumptions: 40% of each month's sales for cash; 30% collected the following month,

 REQUIRED Create a 12-month cash flow budget in Excel using the

REQUIRED Create a 12-month cash flow budget in Excel using the following assumptions: 40% of each month's sales for cash; 30% collected the following month, 20% b. Add a "spinner" to your spreadsheet that will enable you to easily change forecasted c. Add a scroll bar to your spreadsheet that will let you modify the amount of initial Initial sales of $5 million, with forecasted monthly growth of 1% collected 2 months later; 8% collected 3 months later, and 2% never collected . Initial cash balance of $350,000 monthly sales growth to range from 0.5% to 1.5% in increments of 0.1%. 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 Accountancy is available in print or online at the AICPA's Web site: www.aicpa.org.)* Excel Project. REQUIRED Create a 12-month cash flow budget in Excel using the following assumptions: 40% of each month's sales for cash; 30% collected the following month, 20% b. Add a "spinner" to your spreadsheet that will enable you to easily change forecasted c. Add a scroll bar to your spreadsheet that will let you modify the amount of initial Initial sales of $5 million, with forecasted monthly growth of 1% collected 2 months later; 8% collected 3 months later, and 2% never collected . Initial cash balance of $350,000 monthly sales growth to range from 0.5% to 1.5% in increments of 0.1%. 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 Accountancy is available in print or online at the AICPA's Web site: www.aicpa.org.)* Excel Project

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!