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