Creating a Comprehensive Budget
The Cash Budget and Other Specialized Budgets
The Cash Budget
When cash flows are not periodic – that is, when they are affected by seasonality or a different frequency than the budgetary period – a closer look at cash flow management can be helpful. Although cash flows may be adequate to support expenses for the whole year, there may be timing differences. Cash flows from income may be less frequent than cash flows for expenses, for example, or may be seasonal, while expenses are more regular. Most expenses must be paid on a monthly basis, and if some income cash flows occur less frequently or only seasonally, there is a risk of running out of cash in a specific month. When it comes to cash flows, timing is everything.
A good management tool is the cash budget,
which is a rearrangement of budget items to show each month in detail.
Irregular cash flows can be placed in the specific months when they will
occur, allowing you to see the effects of cash flow timing more
clearly. Jeff's cash budget for 2019 is outlined in Table 5.3.1.
|
2019 |
2019 February |
2019 March |
2019 April |
2019 May |
2019 June |
2019 July |
2019 August |
2019 September |
2019 October |
2019 November |
2019 December |
Incomes |
|
|||||||||||
Contract Earnings |
3,417 |
3,417 |
3,417 |
3,417 |
3,417 |
3,417 |
3,417 |
3,417 |
3,417 |
3,417 |
3,417 |
3,417 |
Tutoring |
333 |
333 |
333 |
333 |
555 |
555 |
0 |
0 |
333 |
333 |
333 |
555 |
Memorabilia Sales |
79 |
79 |
79 |
79 |
79 |
79 |
79 |
79 |
79 |
79 |
79 |
79 |
House Painting |
0 |
0 |
0 |
0 |
0 |
3,472 |
3,472 |
3,472 |
0 |
0 |
0 |
0 |
Interest Income |
15 |
25 |
36 |
45 |
57 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Total Income |
3,844 |
3,854 |
3,865 |
3,874 |
4,108 |
7,523 |
6,968 |
6,968 |
3,829 |
3,829 |
3,829 |
4,051 |
Payroll/Income Taxes |
(792) |
(792) |
(792) |
(792) |
(792) |
(792) |
(792) |
(792) |
(792) |
(792) |
(792) |
(792) |
Disposable Income |
3,052 |
3,062 |
3,073 |
3,082 |
3,316 |
6,731 |
6,176 |
6,176 |
3,037 |
3,037 |
3,037 |
3,259 |
Living Expenses |
||||||||||||
Groceries |
(260) |
(260) |
(260) |
(260) |
(260) |
(260) |
(260) |
(260) |
(260) |
(260) |
(260) |
(260) |
Car (Fuel) |
(127) |
(127) |
(127) |
(127) |
(127) |
(127) |
(127) |
(127) |
(127) |
(127) |
(127) |
(127) |
Car (Service, etc.) |
(29) |
(29) |
(29) |
(29) |
(29) |
(29) |
(29) |
(29) |
(29) |
(29) |
(29) |
(29) |
|
2019 |
2019 February |
2019 March |
2019 April |
2019 May |
2019 June |
2019 July |
2019 August |
2019 September |
2019 October |
2019 November |
2019 December |
Car (Insurance) |
0 |
(400) |
0 |
0 |
0 |
0 |
0 |
(400) |
0 |
0 |
0 |
0 |
Electricity |
(65) |
(65) |
(65) |
(65) |
(65) |
(65) |
(65) |
(65) |
(65) |
(65) |
(65) |
(65) |
Phone / Cable / Internet |
(89) |
(89) |
(89) |
(89) |
(89) |
(89) |
(89) |
(89) |
(89) |
(89) |
(89) |
(89) |
Heat |
(100) |
(100) |
(100) |
(100) |
(100) |
(100) |
(100) |
(100) |
(100) |
(100) |
(100) |
(100) |
Health and Dental Insurance |
(70) |
(70) |
(70) |
(70) |
(70) |
(70) |
(70) |
(70) |
(70) |
(70) |
(70) |
(70) |
Medical |
(20) |
(20) |
(20) |
(20) |
(20) |
(20) |
(20) |
(20) |
(20) |
(20) |
(20) |
(20) |
Travel/Entertainment |
(250) |
(250) |
(250) |
(250) |
(250) |
(250) |
(250) |
(250) |
(250) |
(250) |
(250) |
(250) |
Car Loan Payment |
(499) |
(499) |
(499) |
(499) |
(499) |
(499) |
(499) |
(499) |
(499) |
(499) |
(499) |
(499) |
Mortgage Interest |
(897) |
(897) |
(897) |
(897) |
(897) |
(897) |
(897) |
(897) |
(897) |
(897) |
(897) |
(897) |
Property Tax |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
(4,350) |
0 |
0 |
Total Living Expenses |
(2,406) |
(2,806) |
(2,406) |
(2,406) |
(2,406) |
(2,406) |
(2,406) |
(2,806) |
(2,406) |
(6,756) |
(2,406) |
(2,406) |
|
2019 |
2019 February |
2019 March |
2019 April |
2019 May |
2019 June |
2019 July |
2019 August |
2019 September |
2019 October |
2019 November |
2019 December |
Income after Living Expenses |
646 |
256 |
667 |
676 |
910 |
4,325 |
3,770 |
3,370 |
631 |
(3,719) |
631 |
853 |
Interest Expense |
0 |
0 |
0 |
0 |
0 |
(526) |
(364) |
(214) |
(79) |
(88) |
(93) |
(114) |
Capital Expenditures/Investment |
||||||||||||
Mortgage Principal |
(270) |
(270) |
(270) |
(270) |
(270) |
(270) |
(270) |
(270) |
(270) |
(270) |
(270) |
(270) |
Free Cash Flow |
376 |
(14) |
397 |
406 |
640 |
3,529 |
3,163 |
2,886 |
282 |
(4,077) |
268 |
469 |
RRSP Deposit |
0 |
0 |
(1000) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Home Improvement |
0 |
0 |
0 |
0 |
(15,000) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
High-Interest Savings Account |
376 |
(14) |
(603) |
406 |
(6,210) |
3,529 |
3,163 |
2,886 |
282 |
(4,077) |
268 |
469 |
Line of Credit |
0 |
0 |
0 |
0 |
10,525 |
(3,250) |
(3,000) |
(2,700) |
180 |
100 |
415 |
417 |
Net Cash Flow |
0 |
0 |
0 |
0 |
2,375 |
279 |
163 |
186 |
462 |
100 |
683 |
886 |
|
2019 |
2019 February |
2019 March |
2019 April |
2019 May |
2019 June |
2019 July |
2019 August |
2019 September |
2019 October |
2019 November |
2019 December |
Line of Credit Balance |
0 |
0 |
0 |
0 |
10,525 |
7,275 |
4,275 |
1,575 |
1,755 |
1,855 |
2,270 |
2,687 |
Tax-Free Savings Account Balance |
7,336 |
7,336 |
7,336 |
7,336 |
7,200 |
7,100 |
7,150 |
7,200 |
7,300 |
7,350 |
7,400 |
7,500 |
Table 5.3.1
Jeff's original annual budget (Table 5.2.2
"Jeff's 2019 Budget") shows that although his income is enough to cover
his living expenses, it does not produce enough cash to support his
capital expenditures – specifically, to fix the roof. If he must make the
capital expenditure this year, he can finance it with a line of credit:
a loan where money can be borrowed as needed, up to a limit, and paid
down as desired, and interest is paid only on the outstanding balance.
The cash budget (Table 5.3.1) shows a more detailed and slightly different story. Because of Jeff's seasonal income, if he has the roof fixed in May, he will need to borrow $10,525 in May (before he has income from painting). Then, he can pay that balance down until September, when he will need to extend it again. By the end of the year, his outstanding debt will be a bit more than originally shown, but his total interest expense will be a bit less as the loan balance (and therefore the interest expense) will be less in some of the months that he has the loan.
The cash (monthly) budget shows a different story than the annual budget because of the seasonal nature of Jeff's incomes. Since he is planning the capital expenditures before he begins to earn income from painting, he actually has to borrow more – and assume more risk – than originally indicated.
The cash budget may show risks but also remedies that otherwise may not be apparent. In Jeff's case, it is clear that the capital expenditure cannot be financed without some external source of capital, most likely a line of credit. He would have to pay interest on that loan, creating an additional expense. That expense would be in proportion to the amount borrowed and the time it is borrowed for. In his original plan, the capital expenditure occurred in May, and Jeff would have had to borrow about $10,525, paying interest for the next seven months. Delaying the capital expenditure until October, however, would cost him less because he would have to borrow less and would be paying interest in fewer months.
Delaying the capital expenditure until October would also allow the high interest savings account to build value – Jeff's seasonal income would be deposited during the summer – which would finance more of the capital expenditure. He could borrow less and his interest expense would be lower because he has borrowed less and because he can wait until October to borrow, thus paying interest for only three months of the year.
Timing matters for cash flows because you need to get cash before you spend it, but also because time affects value, so it is always better to have liquidity sooner and hang onto it longer. A cash budget provides a much more detailed look at these timing issues and the risks – and opportunities – of cash management that you may otherwise have missed.
Other Specialized Budgets
A cash flow budget is a budget that projects a specific aspect of your finances – in this case, the cash flows. Other kinds of specialized budgets focus on one particular financial aspect or goal. A specialized budget is ultimately included in the comprehensive budget, as it is a part of total financial activity. It usually reflects one particular activity in more detail, such as the effect of owning and maintaining a particular asset or of pursuing a particular activity. You create a budget for that asset or activity by segregating its income and expenses from your comprehensive budget. It is possible to create such a focused budget only if you can identify and separate its financial activity from the rest of your financial life. If so, you may want to track an activity separately that is directly related to a specific goal.
For example, suppose you decide to take up weekend backpacking as a recreational activity. You will try it for two years and then decide if you want to continue. Aside from assessing the enjoyment that it gives you, you want to be able to assess its impact on your finances. Typically, weekend backpacking requires specialized equipment and clothing, travel to a hiking trail or campground, and perhaps lodging and meals: capital investment (in the equipment) and then recurring expenses. You may want to create a separate budget for your backpacking investment and expenses to assess the value of this new recreational activity.
One common type of specialized budget is a tax budget, which includes activities – incomes, expenses, gains, and losses – that have direct tax consequences. A tax budget can be useful in planning for or anticipating an event that will have significant tax consequences, such as income from self-employment or the sale of a long-term asset such as a stock portfolio, business, or real estate.
While it can be valuable to isolate and identify the effects of a specific activity or the progress toward a specific goal, that activity or that goal is ultimately just a part of your larger financial picture. Specialized budgets need to remain a part of your comprehensive financial planning.
Key Takeaways
-
The cash flow budget is an alternative format used as a cash management tool that provides:
• more detailed information about the timing and amounts of cash flows, and
• a clearer view of risks and opportunities.
- Specialized budgets focus on a specific asset or activity.
- A tax budget is commonly used to track taxable activities.
- Eventually, specialized budgets need to be included in the comprehensive budget to have a complete perspective.
Exercises
- When is a cash flow budget a useful alternative to a comprehensive budget?
- Create a specialized budget and a tax budget from your comprehensive budget.