top of page
Personal budget template

Personal budget template

Purpose

Tool to aid the tracking of personal spending and income on a month to month basis. The tool enables the setting of budgets and provides spending analysis to help the user to identify and correct over spending patterns

 

Outputs

Outputs can be found on the Dash sheet

Summary of actual and forecast period income, fixed costs, variable costs, net cash flow, savings ratio and fixed cost ratio

Summary of up to two years of income, fixed and variable costs, net cash flow, savings ratio and fixed cost ratio for comparative purposes

An analysis of the latest month's costs broken down into categories

The ability to select (the yellow drop down cell) a particular month for further cost breakdown

A look at income and costs over time and projected income into the future

 

How to use the tool

Nav sheet:

The navigation sheet includes hyperlinked sheet names with description of the contents of each sheet, a key of various coloured cells and fonts used throughout the model

Every tab contains a “Navigation” button in the top left corner. Clicking this button will take you back to the ‘Nav’ sheet

 

Assumptions:

All assumptions are