Forecasting Inputs for a Business Plan Workbook in QuickBooks - dummies

Forecasting Inputs for a Business Plan Workbook in QuickBooks

By Stephen L. Nelson

The inputs area of a business planning starter workbook in QuickBooks contains one set of formulas. The second row identifies the period for which the results are calculated. The period identifier numbers the periods for which values are entered. The start of the first period is stored in cell B2 as the integer 0. Periods that follow are stored as the previous period plus 1.

The business plan workbook has seven parts: the inputs forecast, Balance Sheet, Common Size Balance Sheet, Income Statement, Common Size Income Statement, Cash Flow Statement, and Financial Ratios Table.

The period identifiers in the Balance Sheet, Common Size Balance Sheet, Income Statement, Cash Flow Statement, and Financial Ratios Table schedules use similar formulas.

The cells that hold the period identifiers use a custom number format that precedes each period with the word Period. To remove this, simply reformat the cells by using another number format. You can most easily do this by selecting a cell and then clicking a formatting button on the Excel toolbar, such as the Currency or Percent Style button.