Developing Quarterly Budget Analysis

• Seven worksheet columns needed:

  1. The list of all budget items from headings on the Pro Forma Cash Flow Statement.

  2. Budget This Quarter: enter amount budgeted for current quarter from the Pro Forma Cash Flow Statement.

  3. Actual This Quarter: enter actual expenditures and cash receipts for quarter.

  4. Variation: Subtract amount spent or received from the amount budgeted for the current quarter.

  5. YTD Budget: Amount budgeted from beginning of year through and including current quarter
     (also from cash flow statement)

  6. Actual YTD: Actual amount spent or received from beginning of year through current quarter.

  7. Variation YTD: Subtract the amount spent or received from the amount budgeted from the start of the year through the current quarter.