Spreadsheet 123 Steps to Creating a Personal Budget

Steps to Creating a Personal Budget


Creating a personal financial plan should be simple enough so that a second grader, who knows addition, subtraction, multiplication and division, can understand it. It doesn't have to be a jungle of incomprehensible figures. Using a one-person example, here's a sample guide that can help:

Person X, with no one to support but himself and his heavy credit card debts. He wants to clean up the mess he has gotten himself into without losing the essentials.

1. Calculate what you've got

The first thing he does is calculate exactly how much money he makes on a monthly basis. In his case, he makes about $20,000 (after taxes) yearly. He has no other income or money coming from any other source.

By dividing by 12, he gets his monthly salary: $1,666.66.

He also uses this principle to divide up any costs he may have had had over a yearly period, just so that everything works on a monthly basis.

2. Decide what you HAVE to pay to survive

He decides to make a list of those things, every month, that he absolutely needs to survive In doing this, he comes up with the following categories:

3. Decide how much this costs monthly

Some of the things are already set like rent. But most everything else fluctuates monthly. However, this fluctuation is not so much.

This is why Person X decides, one month, to note down EVERY expense for ANYTHING he bought (even small items). This gave him a pretty clear idea of how much he spends in the categories above.

He also digs up old bills for a period of a couple of months for things like heating and electricity and calculates the average but adds a little to cover times when it may be more than usual. Now he fills in these categories.

1. Rent........$600
2. Food.......$100
3. Clothing...$100
4. Bills........$200
5. Car.........$100
_________________
Total.........$1100

Now Person X knows that every month, he must set aside $1300 for basics. He doesn't even have to use the credit card, since he knows this is how much he will need.

4. Determine and calculate your non-essentials

Person X lists the non-essentials-things that he spends on that aren't as necessary:

He thinks about his latest trips to restaurants and decides to start eating more at home, perhaps picking up some cooking skills by trial and error, to cut down his restaurant eating costs.

For gifts, he decides to allocate a small amount every month so when necessary, there will be enough for it.

He does some calling and gets a good deal and reduces his long-distance bill by paying a flat rate for a certain number of hours every month.

So the picture stands:

For non-essentials, Person X spends this amount:

$50-for recreation
$50-for gifts
$50-for his long-distance calls
_____________________
$150 for non-essentials.

So the total so far is at :

Monthly salary.....$1666.66
Essentials......... -$1100.00
Non-essentials.....-$150.00
_________________________
Total.................$416.00

5. Establish categories for Debt elimination, Charity and Savings

Since Person X is serious about giving charity, eliminating his debt and wants to have some savings as well, he decides that these are categories that have to be included as well.

After fiddling around a bit, he decides on the following numbers:

Savings.....$100.00
Charity........$25.00
Debt..........$100.00

A sample financial sheet for Person X now, that includes all of his categories are

INCOME-WHAT PERSON X MAKES MONTHLY

How much money is coming in monthly $1666.66

NECESSARY EXPENSES-WHAT PERSON X MUST SPEND MONTHLY

1. How much money is spent on essentials

a. rent...................$600.00
b. food..................$100.00
c. clothing..............$100.00
d. car....................$100.00
e. bills...................$300.00
f. Charity.................$25.00
g. Debt elimination....$100.00
h. Savings..............$ 100.00
__________________________
Total....................$1425.00


EXTRA STUFF PERSON X HAS TO SPEND ON

2. How much money is spent on non-essentials $ 150.00

a. recreation
b. gifts
c. telephone calls (long-distance)


TOTALS

Total monthly income $1666.66

MINUS

Total expenditure ($1425.00+$ 150.00=$1575.00)
_____________________________________________________________
LEFT OVER $91.66

Some Things to Remember

1. Numbers are flexible. Experiment with getting cheaper options for things, even for essentials. If, for instance your rent is very high, consider moving. If you can, reduce your clothing bill to only what you really, really need. Be on the lookout for ways, especially, that you can increase the proportions of money you put in for debts, savings and charity.

2. Don't spend unless you have it (so you can avoid interest and unnecessary borrowing).

2. Write down every expenditure. Keep receipts of all purchases.

3. Deal with averages.

4. Plan for extras

5. Plan for emergencies

Suggested Reading

Spreadsheet News



Forum


Meet advanced users of MS Excel and Spreadsheet and do not be shy to ask your question.


Book Shop


Visit our busy book shop, were you can find latest books for beginners as well as advanced users of excel and similar programs.



Software Library




Excel & Spreadsheet
Online Tutorials




Spreadsheet123
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Streamline.Net The home of good value web hosting
Home
About Us

Book Shop

Excel
Excel Tutorials
Financial Modeling
Excel Templates

Excel Tutorials

Excel Basic Tutorial
Excel Tech on Net
MS Excel Tutorials and Projects
MS Excel Spreadsheet Tutorial
How to Decide What Chart Type to Use
How To Merge Cells in Excel
Excel - Printing Effectively from Excel
Using Excel Functions and Creating Formulas

Spreadsheets Library

Corporate finance spreadsheets
Valuation Inputs Spreadsheets
Big-picture valuation spreadsheets
Focused valuation spreadsheets
Financial Service firms
Troubled firms
Private companies
Young and high-growth firms
Multiples
Valuation in Acquisitions
Valuation of other assets
Value Enhancement Spreadsheets
Basic option pricing models
Real option models in corporate finance
Real option models in valuation
Hotel & Restaurant Management Spreadsheets
Real Estate & Mortgage Excel Spreadsheets
Excel Personal Budget Spreadsheets
More Spreadsheets

Software Library

Accounting Software
Small Business Software
Tax Calculating Software
Auditing Software
Excel Add-Ins
Property Management Software
Payroll Software
Spreadsheet Software

Contact Us
Useful Links
Our Services
Site Map