Chapter 12, Problem 4P

a.

To determine

Prepare a 12-month cash flow budget.

b.

To determine

Insert a spinner in the spreadsheet that will enable the user to change the forecasted monthly sales growth to range from 0.5% to 1.5% with increments of 0.1%.

c.

To determine

Add a scroll bar to the spreadsheet that will enable a user to modify the amount of initial sales to vary from $4,000,000 to $6,000,000 in increments of $100,000.

d.

To determine

Plan an appropriate data entry and processing controls to confirm spreadsheet accuracy.