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.
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.
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:
1. Rent/payment
2. Grocery
3. Clothing
4. Bills for heat and
electricity
5. Car maintenance/payment/gas
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.
Person X lists the non-essentials-things that he spends on that aren't
as necessary:
1. recreation-this includes trips to restaurants, video rental or
purchases, etc.
2. gifts-weddings, etc.
3. long-distance
calls (to mom and dad-back in New York)
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
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
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
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
Meet advanced users of MS Excel and Spreadsheet and do not be shy to ask your question.
Visit our busy book shop, were you can find latest books for beginners as well as advanced users of excel and similar programs.
See Spreadsheets for:
a.Hotel
Management
b.Personal
Budget
c.Corporate
Finance
d.Rating
Calculation
e.Real
Estate and Mortgage
f.Web Calc