Financial Tools / Budget Calculators
Here is a simple budgeting tool with two budgeting calculators: income, and expenses. These budget calculators will help you estimate the cost of doing specific goals in the budgeting period. We separated the budget calculators to stress the need to calculate the amount available to spend before you decide how much you can allocate to spend. Budget calculators follow goal setting and planning. Before you use these budgeting tools, ensure you identify goals you plan to do in the period, and plans you think you will follow to do them.
You do not need to finish using this budgeting tool for your entire budget in one session. Save the budget computation form data to the file generated automatically: "expenses.mgm." You can view this file only by clicking the "Restore Saved Work" button below. Develop the habit of saving the result of the budget calculators (budget computation forms) before clicking the Create Worksheet.
Before you start to use this budgeting tool, let us review quickly budgets and budgeting. A budget is a spending plan; your best estimate of resources--time, talents and money--you are likely to need during a specific future period to do specific goals. A budget is a freeing tool without which you stumble along and advertisements dictate how you spend. A budget starts with God's goal(s), followed by His plan(s)--steps to do His goal(s). It quantifies this plan, and helps identify potential gaps and opportunities during the budget period, so you might plan to remove gaps, and seize opportunities. Many people fear the word budget, that's why we refer to it often as a spending plan, a guide, not a straitjacket but a key part of PEACE Budgetary Control that begins with goal setting.
After doing the budget, Act - do what you planned, Compare results against the plan and the budget, and then, Execute needed changes:
This is the expenses budgeting calculator that you complete only after calculating the amount available to spend. Likely you will not know your spending pattern, so you will need to use your best estimates to allocate spending to the Budget Computation Expenses Form. What do you think likely income and expenses will be? Tough question, but you can answer it using information available. As you record spending over the next three to six months, you will learn your spending pattern and you can modify the budget (best estimates) on the spreadsheet file or on the expenses computation form. A spending fast will help during this challenging period.
As you prepare your budget, try to identify units you wish to monitor. don't try to"manage" dollar amounts--money isn't manageable, it the units behind money that's manageable. Instead of budgeting $250 for clothing without identifying what's included, specify clothing items (units) you wish to buy, then cost each (price). Show the cost on the expenses form. Keep details of these calculations to help with your budget review--the "C" in PEACE. I repeat, the key control unit isn't dollars, but what's behind the dollars. For meals, decide how many times you will eat out monthly and use a cost for each; monitor the number of times you eat out and the budgeted prices. If you focus on dollars only, you won't deal with real control variables, which your behaviour influences.
After you enter your expenses on the form, "Save Your Work," then click "Create Worksheet." The name of the file saved will be "expenses.mgm." You can open it only by clicking, "Restore Saved Work"--unlike other files, clicking on it won't open it. The worksheet form will give options to "Create Envelopes" for each category on the budget computation form, and save to "Spreadsheet File." More guidelines are on the worksheet form.
The Money May is a key budgeting worksheet. It is a portion of your budget that you travel with, not a complete budget. If you plan to do a full budget, go to the Incomes Form.
Have you ever wanted to take parts of your budget with you when you go on your spending trips? Over the next week, you want to go to the mall to buy clothes, birthday and Christmas gifts, and bulk toiletries, which you budgeted. Then again, you plan to go on vacation and do not want to overspend your budget for transport, food, shelter, and recreation.
The Money Map will help you spend for specific planned items at pre-determined prices. The Money Map system will give you a separate worksheet (your map) with expense categories and budgets to help track spending on the road. Don't leave home without it.
To activate the Money Map budgeting worksheet, enter amounts in the Budget Computation Expenses Form's weekly section only and ignore amounts the system calculates for other periods. For the Money Map calculations only, you do not need to enter amounts in the Income Form.
If you are going away for a week and plan to spend "gas" $100, "dining out" $350, "accommodation" $400, and "movies and shows" $50, enter these amounts in the weekly section of the Expenses Form, then click "Create Money Map." You will go to the "Money Map Worksheet" screen where you will see these amounts under "Weekly Budget." There you will be able to change amounts if needed.
The Money Map Worksheet does not replace the budget, it represents items included in the budget, which you want to isolate and track over a period shorter than the budget period.
© 2002-2015 Michel A. Bell. All Rights Reserved. This site is for information only.
Before you implement financial decisions, consult an Independent Financial Advisor. Scripture quotations, unless otherwise noted, are from the New International Version (NIV) of the Bible (Copyright © 1973, 1978, 1984 International Bible Society. Used by permission of Zondervan Bible Publishers. All rights reserved.)