Moving from the Pro Forma to the Budget

A pro forma statement can be translated into financial budgets for the upcoming year. The pro forma statement is the forecast. Budgets are used to plan, coordinate, and control a company's operations. The budgeting time period is a matter of judgment. A business may develop annual, quarterly, or monthly budgets depending on such factors as its information needs, its sales patterns (for example, seasonal peaks and valleys versus a steady trend), its operational methods, and its financial structure.

Suppose that Cummins Printing wants to create a quarterly operating budget for 2005, based on its pro forma income statement for that year. The quarterly budget is shown in Figure 8.7.

Figure 8.7. The 2005 quarterly ...

Get Business Analysis with Microsoft® Excel, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.