Docstoc

The Budget Planner Plus

Document Sample
The Budget Planner Plus Powered By Docstoc
					Budget Planner Plus
                       Start by reading the Financial Plan below. When you have finished the first step sho
                       So move on to the next worksheet titled Goals.

                                                                                 FINANCIAL PLANNING

                      Everybody should have a Financial Plan. Most of what you do in your life will involve
                      take control of it. There are different levels of Financial Planning and this one is inten
                      If and when you are seriously looking at point 9 below you may be thinking of aiming
                      even rich. If you are at that stage already, congratulations and I suggest you research
                      would be the ‘Rich Dad Poor Dad’ series of books by Robert Kiyosaki with Sharon Lec
                      you a good understanding of the different types of investor, some basic rules of inves

                      My goal however, is to help those in need to get out of the mud and to start aiming f
                      ‘Rich Dad Poor Dad’ and ‘Rich Dad Poor Dad 2: Cash Flow Quadrant’ to give you a diff

                      You might want to print this and tick the boxes once you have set up or achieved eac

                      1. Identify your goals
                      Have a clear idea of your priorities in life – identify the goals in life that are the most i
                      start to plan for them. Go to our Goals page to get one idea of how to proceed and w
                      our Budget Planner Plus spreadsheet.
                      In the SHORT TERM next 12 months
                      In the MEDIUM TERM next 3-5 years
                       In the LONG TERM e.g. over 5 years

                      2. Know what you are worth
                      Your net worth is the difference between what you own and what you owe. The Net
                      your net worth will motivate you to reduce that debt and increase your financial wor
                      liabilities very well.

                      3. Budgeting
                      Draw up a budget and make sure you stick to it or as close as you can. You should sp
                      work on ways to cut your costs and/or find ways to increase your income, rather than
                      worksheet on our Budget Planner Plus will help with this.

                      4. Debts
                       Borrow what you only really need and, before you take out a loan or credit card, kno
                      charges can greatly increase the total cost of your purchase. Work out a plan to pay
                      tackle your high interest debts first, or you might pay off the smallest debt first. Eithe
                      money to pay off your next debt and so on. Paying off all your debts should be a prio
                      for a time, should be to not need to borrow in the future. Do not consolidate your de
                      solution but long term it will cause problems.

                      5. Cash cushion
                      Use a deposit account or ISA to save for an emergency fund or ‘cash cushion’ of at le
                      even if you’re paying off a mortgage and other debts, otherwise you may extend you
                      help cover you for emergencies such as if your car breaks down or you lose your job.
                      make it a priority to get it back again.

                      6. Get yourself protected
                      Wouldn’t it be great to get to a position where you have cleared your debts and have
                      would feel? But how would you and your family cope financially if you were unable t
would feel? But how would you and your family cope financially if you were unable t
you feel then? It would be wise to protect your assets and therefore your family agai
insurance policies to cover against illness, accident, death etc as otherwise your finan
ruined. Go to www.budgetplannerplus.com to access comparison websites.

7. Save
Once you’ve paid off your debts and have got your emergency cash cushion, use the
and save for your cash cushion to now save for your medium term goals. Your short
budgeting on the Budget Planner Plus spreadsheet.

8. Retirement plans
 Make a financial plan for your retirement, use the Retirement worksheet on our Bud
workplace pension scheme? Even if you still have debt, seriously consider it, especia
too. Saving for your retirement, even though it may be a long way off, must be a prio

9. Investing
Investments are not just for the rich. It opens up opportunities to make your money
look into ways to help reduce the tax you have to pay on your returns. I recommend
Dad Poor Dad’ series of books by Robert Kiyosaki and Sharon Lechter as a start.

10. Spread the word
 Teach your children/grandchildren about money – the earlier they learn, the better t
can get them to listen that is?

On your Excel spreadsheet you can move this worksheet to the end or delete it so tha
w. When you have finished the first step should really be to establish some Goals.



               FINANCIAL PLANNING

 Most of what you do in your life will involve money at some point so it makes sense to
 els of Financial Planning and this one is intended to get you to a place of financial security.
point 9 below you may be thinking of aiming for being financially comfortable and maybe
y, congratulations and I suggest you research further into investing. A good place to start
of books by Robert Kiyosaki with Sharon Lechter. ‘Rich Dad’s Guide to Investing’ will give
nt types of investor, some basic rules of investing and how to reduce your investment risk.

d to get out of the mud and to start aiming for financial security. I still recommend reading
Dad 2: Cash Flow Quadrant’ to give you a different view of money.

 boxes once you have set up or achieved each item.


   identify the goals in life that are the most important to you and your partner/family and
 age to get one idea of how to proceed and write them down on the Goals worksheet on




n what you own and what you owe. The Net Worth worksheet will help with this. Knowing
 ce that debt and increase your financial worth. ‘Rich Dad Poor Dad’ expalains asstes and



ck to it or as close as you can. You should spend less than you earn, but if you don’t then
nd ways to increase your income, rather than borrowing to pay bills. The budgeting



before you take out a loan or credit card, know the true cost of the borrowing – interest
st of your purchase. Work out a plan to pay off your debts as quickly as you can. You may
ou might pay off the smallest debt first. Either way, after the first debt is repaid, use that
on. Paying off all your debts should be a priority. The aim, after managing your finances
 ow in the future. Do not consolidate your debts, it might sound a tempting short term



an emergency fund or ‘cash cushion’ of at least 3 month’s income (this is important to do
 other debts, otherwise you may extend your debt to cover any emergencies). This will
f your car breaks down or you lose your job. Once you have it and find you have to use it,



where you have cleared your debts and have some savings. Can you imagine how that
r family cope financially if you were unable to work, lose your job or worse? How would
 r family cope financially if you were unable to work, lose your job or worse? How would
 ct your assets and therefore your family against unforeseen events with the right
s, accident, death etc as otherwise your finances – and your life – could easily be
        to access comparison websites.


ve got your emergency cash cushion, use the amount you were using to pay off those debts
ave for your medium term goals. Your short term goals will be catered for in your annual



nt, use the Retirement worksheet on our Budget Planner Plus. Do you have access to a
 still have debt, seriously consider it, especially if your employer will make a contribution
ough it may be a long way off, must be a priority if you ever do want to stop working.


opens up opportunities to make your money work harder for you over the long term. Also
u have to pay on your returns. I recommend reading up on the subject such as the ‘Rich
 Kiyosaki and Sharon Lechter as a start.


            the earlier they learn, the better they will be at managing their money. If you


e this worksheet to the end or delete it so that it is not in your way.
Replace my examples with yor own goals and delete these notes when you no longer need them.

Any kind of plan needs goals. It is said that those who achieve their goals, write them down. Writing your goals down

If you do not have the foggiest what you want to achieve the following may help.

         1. Go with your wildest imagination and write down everything you would ever like to do in your life. It doe
         2. Then put a cost next to each item. It doesn’t have to be accurate to the penny. It might cost time rather
         3. Then put how far into the future you realistically think you might be able to achieve them. You might end
         4. Separate them into the Goals worksheet into Short, Medium and Long term goals. You have to be realist
         5. Complete the Budget Planner, start on the 2011 tab below. Delete the example amounts and enter your
         5. Once you have completed the Budget Planner you may want to revise your goals once you can see realist

                            Goals                              Target      Achieved
SHORT TERM - 1 year
Ensure xmas and birthdays paid for                                Jun-11
Ensure annual bills covered                                       Jun-11
Start saving for cash cushion                                     Jun-11




MEDIUM TERM - 2-5 years
Clear overdraft                                                   Apr-11
Pay off credit card                                               Jun-12
Pay off loan                                                      Dec-12
Save for cash cushion                                             Dec-13
Start saving for medium and long term goals                       Jan-14

LONG TERM - 5 years +
Buy a new car                                                     Feb-17

Retire                                                           May-29
when you no longer need them.

r goals, write them down. Writing your goals down will help you focus on them, especially if you have a planned timeframe in which to achieve them.




erything you would ever like to do in your life. It doesn’t matter how mad it is, write it down anyway. Only you are going to see it.
 be accurate to the penny. It might cost time rather than money.
nk you might be able to achieve them. You might end up with 20 goals; you cannot expect to do them all tomorrow?
Medium and Long term goals. You have to be realistic here; you cannot put 20 Short term goals that might cost you £10,000 if you are still paying off d
below. Delete the example amounts and enter your own. Insert more rows if you need too and delete the cell comments when you no longer need the
 ay want to revise your goals once you can see realistically what shape your finances are going to be in. You can of course change your goals any time y

                                                                            Actions

                    Complete Birthdays worksheet and transfer amounts needed to save to budget worksheet.
                    Open savings account for Short Term Savings. Use Short Term Savings table on budget worksheet.
                    £100 per month. Use this for emergencies instead of credit card.




                    Use debt snowball technique. (see note below)
                    Good idea to clear overdraft first to regain some sanity. Ease cashflow by leaving extra in your account.
                    Keep paying £100 per month.
                    Use £100 used to pay credit card towards clearing loan quicker (if allowed within terms of loan agreement)
                    £100 per month until debts paid of then £400 per month until 3 x salary saved.
                    Split £400 per month used for cash cushion.


                    Save £5,000.

                    Complete Retirement worksheet. Sort pension. Long term savings. Learn to invest.

                      Note: Most places advocate paying off debts with the highest interest rate first. Whilst this is not
                      wrong and will lead to paying less interest in the long term. Emotionally it is more satisfying and
                      motivational if you pay off the smallest debt first then use the money you used to pay off that debt
                      to pay off the next smallest debt and so on.
rame in which to achieve them. The Goals worksheet will help you set these out.




10,000 if you are still paying off debt.
nts when you no longer need them.
 rse change your goals any time you like; it is after all your life!
Date                           Jan-12    Feb-12    Mar-12    Apr-12   May-12    Jun-12    Jul-12   Aug-12     Sep-12    Oct-12    Nov-12    Dec-12   Total    Retired       Current Balance        £86.80 30/04/2011 Telephone 20.00
Bought fward                  -500.00   -403.30   -206.60     -9.90    86.80     86.80    183.50    280.20    376.90    473.60    570.30    667.00                                    Cashflow
Salary 1 (25)                 1300.00   1300.00   1300.00   1300.00            1300.00   1300.00   1300.00   1300.00   1300.00   1300.00   1300.00   14300                                                              1300.00
Salary 2 (last working day)   1000.00   1000.00   1000.00   1000.00            1000.00   1000.00   1000.00   1000.00   1000.00   1000.00   1000.00   11000                                                                          1000.00
From savings                  1200.00     40.00     60.00    250.00              50.00              150.00              400.00               60.00    2210
Benefits                                                                                                                                                 0
Tax credit                                                                                                                                               0
Child benefit                   81.20     81.20     81.20     81.20              81.20     81.20     81.20     81.20     81.20     81.20     81.20     893                              81.20                                                  Cashflow Note: If you had just completed April and were a
                                                                                                                                                                                                                                               1. Copy May income and expenditure figures into the cahs
                                                                                                                                                         0
                                                                                                                                                                                                                                               and paste but I find that alters the formatting)
Monthly total                 3581.20   2421.20   2441.20   2631.20     0.00   2431.20   2381.20   2531.20   2381.20   2781.20   2381.20   2441.20   27510                              81.20         0.00       0.00   1300.00     1000.00    2. Then delete May income and expenditure so that the Ba
Total income                  3081.20   2017.90   2234.60   2621.30    86.80   2518.00   2564.70   2811.40   2758.10   3254.80   2951.50   3108.20   28403                  May                                                                Balance.
HOUSEHOLD                                                                                                                                                                         1-4 May        7-11 May    14-18 May 21-25 May   28-31 May   3. When you then make appropriate entries from your onl
Mortgage/rent (1st)            500.00    500.00    500.00    500.00             500.00    500.00    500.00    500.00    500.00    500.00    500.00    5500        5500                 500.00                                                  column delete the correspondingentry in the cashflow colu
Secured loans                                                                                                                                            0           0                                                                         column you will see what will be left if all expenses were p
                                                                                                                                                                                                                                               This may be a negative figure which is why we have severa
Council Tax                    100.00                        100.00             100.00    100.00    100.00    100.00    100.00    100.00    100.00     900         900                 100.00
                                                                                                                                                                                                                                               one column. Any items not due to be paid before the next
Water                           30.00     30.00     30.00     30.00              30.00     30.00     30.00     30.00     30.00     30.00     30.00     330         330                                                    30.00                account can be moved into the column to the right. At the
Electricity                     25.00     25.00     25.00     25.00              25.00     25.00     25.00     25.00     25.00     25.00     25.00     275         275                              25.00                                      will see how much will be left after all expenses are paid ta
Gas                             25.00     25.00     25.00     25.00              25.00     25.00     25.00     25.00     25.00     25.00     25.00     275         275                              25.00                                      income still due to be received.
Taxes                                                                                                                                                    0           0                                                                         4. If cashflow is a real issue, instead of using one column y
Fines                                                                                                                                                    0           0                                                                         example and move the amounts to the relevant week to e
TV License                      13.00     13.00     13.00     13.00              13.00     13.00     13.00     13.00     13.00     13.00     13.00     143         143                  13.00                                                  overspending.
Telephone                       20.00     20.00     20.00     20.00              20.00     20.00     20.00     20.00     20.00     20.00     20.00     220         220                                                                20.00
Internet                        15.00     15.00     15.00     15.00              15.00     15.00     15.00     15.00     15.00     15.00     15.00     165         165                              15.00
TV Service                      25.00     25.00     25.00     25.00              25.00     25.00     25.00     25.00     25.00     25.00     25.00     275         275                              25.00
Buildings insurance             20.00     20.00     20.00     20.00              20.00     20.00     20.00     20.00     20.00     20.00     20.00     220         220                  20.00                                                  Note: I have added some figures just to show
Contents insurance              15.00     15.00     15.00     15.00              15.00     15.00     15.00     15.00     15.00     15.00     15.00     165         165                  15.00                                                  Change these figures with your own.
Food                           200.00    200.00    200.00    200.00             200.00    200.00    200.00    200.00    200.00    200.00    200.00    2200        2200                  50.00       50.00       50.00     50.00       50.00
LOANS/CREDIT
Car Loan                       200.00    200.00    200.00    200.00             200.00    200.00    200.00    200.00    200.00    200.00    200.00    2200                                                     200.00
Credit Card                    100.00    100.00    100.00    100.00             100.00    100.00    100.00    100.00    100.00    100.00    100.00    1100                                         100.00
                                                                                                                                                         0              0
                                                                                                                                                         0              0
                                                                                                                                                         0              0
VEHICLES
Petrol                         150.00    150.00    150.00    150.00             150.00    150.00    150.00    150.00    150.00    150.00    150.00    1650        1650                  30.00       30.00       30.00     30.00       30.00
Insurance                                                                                                               400.00                         400         400
Tax                                                                                                 150.00                                             150         150
MOT                                                                              50.00                                                                  50          50
Service                                                      250.00                                                                                    250         250
Recovery                                  40.00                                                                                                         40          40
INSURANCE'S
Life                            10.00     10.00     10.00     10.00              10.00     10.00     10.00     10.00     10.00     10.00     10.00      110        110                  10.00
Income protection                                                                                                                                         0          0
Health                                                                                                                                                    0          0
Mortgage                                                                                                                                                  0          0
                                                                                                                                                          0          0
ADULT SPENDING
Personal                        50.00     50.00     50.00     50.00              50.00     50.00     50.00     50.00     50.00     50.00     50.00     550         550                              50.00
Socialising                    100.00    100.00    100.00    100.00             100.00    100.00    100.00    100.00    100.00    100.00    100.00    1100        1100                  20.00       20.00       20.00     20.00       20.00
Mobile 1                        20.00     20.00     20.00     20.00              20.00     20.00     20.00     20.00     20.00     20.00     20.00     220         220                                          20.00
Mobile 2                                                                                                                                                 0           0
Toiletries/make up              20.00     20.00     20.00     20.00              20.00     20.00     20.00     20.00     20.00     20.00     20.00     220         220                                                    20.00
Clothing                        20.00     20.00     20.00     20.00              20.00     20.00     20.00     20.00     20.00     20.00     20.00     220         220                                                    20.00
Haircut                         10.00     10.00     10.00     10.00              10.00     10.00     10.00     10.00     10.00     10.00     10.00     110         110                                                    10.00
Birthdays                                           60.00                                                                                               60          60
Christmas                                                                                                                                    60.00      60          60
Holidays                      1200.00                                                                                                                 1200        1200
KIDS
Childcare                      150.00    150.00    150.00    150.00             150.00    150.00    150.00    150.00    150.00    150.00    150.00    1650                             150.00
School fees                                                                                                                                              0
Allowance                                                                                                                                                0
Clothing                        20.00     20.00     20.00     20.00              20.00     20.00     20.00     20.00     20.00     20.00     20.00     220                              20.00
Hobbys/sports                                                                                                                                            0
SAVINGS & INVESTMENTS
Short Term Savings 1st         236.50    236.50    236.50    236.50             236.50    236.50    236.50    236.50    236.50    236.50    236.50    2602      2601.5                 236.50
Charity                         10.00     10.00     10.00     10.00              10.00     10.00     10.00     10.00     10.00     10.00     10.00     110         110                  10.00
Cash Cushion                100.00      100.00      100.00      100.00                  100.00          100.00     100.00      100.00          100.00         100.00         100.00    1100      1100     100.00
Medium Term
Long Term Savings                                                                                                                                                                         0
Pension                      100.00      100.00      100.00     100.00                   100.00       100.00        100.00      100.00       100.00         100.00         100.00      1100                100.00                                                  Cashflow Balance
Total outgoings            3484.50     2224.50     2244.50     2534.50        0.00     2334.50      2284.50       2434.50     2284.50      2684.50        2284.50        2344.50      27140     20870     1374.50        340.00      320.00     180.00    120.00   between the Cashflow columns to avoid a
Monthly balance               96.70     196.70      196.70       96.70       0.00         96.70        96.70         96.70       96.70        96.70          96.70          96.70                       -1206.50       -253.20     -233.20    1206.80    966.80    to ensure there is enough funds in your ac
Balance                    -403.30     -206.60        -9.90      86.80      86.80       183.50       280.20        376.90      473.60       570.30         667.00         763.70                                                                                   monthly expenses at the start of a month
                                                                                                                                                                                                                                                                   last day of the month your Current Balanc
                                                                                                                                                                                                                                                                   you need to manage cashflow. If the bala
Short Term Savings        Jan         Feb         Mar         Apr         May         Jun         Jul            Aug         Sep         Oct            Nov            Dec                                                                                         the Cashflow columns are negative you w
Christmas                     5.00        5.00        5.00        5.00        5.00        5.00            5.00       5.00        5.00            5.00           5.00           5.00     60.00                                                                      need to manage your cashflow.
Birthdays                     5.00        5.00        5.00        5.00        5.00        5.00            5.00       5.00        5.00            5.00           5.00           5.00     60.00                       budgetplannerplus.co.uk
Holiday(s)                  100.00      100.00      100.00      100.00      100.00      100.00          100.00     100.00      100.00          100.00         100.00         100.00   1200.00
Holiday spending             50.00       50.00       50.00       50.00       50.00       50.00           50.00      50.00       50.00           50.00          50.00          50.00    600.00
Car Tax                      12.50       12.50       12.50       12.50       12.50       12.50           12.50      12.50       12.50           12.50          12.50          12.50    150.00
Car Insurance                34.00       34.00       34.00       34.00       34.00       34.00           34.00      34.00       34.00           34.00          34.00          34.00    408.00
MOT                           5.00        5.00        5.00        5.00        5.00        5.00            5.00       5.00        5.00            5.00           5.00           5.00     60.00
Car Service                  21.00       21.00       21.00       21.00       21.00       21.00           21.00      21.00       21.00           21.00          21.00          21.00    252.00
Car Recovery                  4.00        4.00        4.00        4.00        4.00        4.00            4.00       4.00        4.00            4.00           4.00           4.00     48.00



SAVE                        236.50      236.50      236.50      236.50      236.50      236.50          236.50     236.50      236.50          236.50         236.50         236.50   2838.00

Adult Spending Personal   Jan         Feb         Mar         Apr         May         Jun         Jul            Aug         Sep         Oct            Nov            Dec
Cash
Uncleared cash
Takeaways


Treats (for yourself)
Gifts (for others)


Spent                             0           0           0           0           0           0             0            0           0             0              0              0
Available                       100         100         100         100         100         100           100          100         100           100            100            100
Cashflow Note: If you had just completed April and were about to start May.
1. Copy May income and expenditure figures into the cahsflow column. (You could cut
and paste but I find that alters the formatting)
2. Then delete May income and expenditure so that the Balance still equals your Current

3. When you then make appropriate entries from your online bank statement in the May
column delete the correspondingentry in the cashflow column. At the bottom of the
column you will see what will be left if all expenses were paid with the Current Balance.
This may be a negative figure which is why we have several columns. You may only need
one column. Any items not due to be paid before the next income is added to your
account can be moved into the column to the right. At the bottom of that column you
will see how much will be left after all expenses are paid taking into account all the
income still due to be received.
4. If cashflow is a real issue, instead of using one column you cold use more as in this
example and move the amounts to the relevant week to ensure you keep away from




     I have added some figures just to show the effect on the Retirement worksheet.
Change these figures with your own.
Cashflow Balance Note: You may need to move expenses
between the Cashflow columns to avoid an overdraft. You need
to ensure there is enough funds in your account to cover all your
monthly expenses at the start of a month. If you are paid on the
last day of the month your Current Balance may cover this? If not
you need to manage cashflow. If the balance at the bottom of
the Cashflow columns are negative you will have problems and
need to manage your cashflow.
Date                           Jan-13    Feb-13    Mar-13    Apr-13   May-13
Bought fward                   763.70    860.40   1057.10   1253.80   1350.50
Salary 1 (25)                 1300.00   1300.00   1300.00   1300.00   1300.00
Salary 2 (last working day)   1000.00   1000.00   1000.00   1000.00   1000.00
From savings                  1200.00     40.00     60.00    250.00
Benefits
Tax credit
Child benefit                   81.20     81.20     81.20     81.20     81.20

Monthly total                 3581.20   2421.20   2441.20   2631.20   2381.20
Total income                  4344.90   3281.60   3498.30   3885.00   3731.70
HOUSEHOLD
Mortgage/rent (1st)            500.00    500.00    500.00    500.00    500.00
Secured loans
Council Tax                    100.00                        100.00    100.00
Water                           30.00     30.00     30.00     30.00     30.00
Electricity                     25.00     25.00     25.00     25.00     25.00
Gas                             25.00     25.00     25.00     25.00     25.00
Taxes
Fines
TV License                      13.00     13.00     13.00     13.00     13.00
Telephone                       20.00     20.00     20.00     20.00     20.00
Internet                        15.00     15.00     15.00     15.00     15.00
TV Service                      25.00     25.00     25.00     25.00     25.00
Buildings insurance             20.00     20.00     20.00     20.00     20.00
Contents insurance              15.00     15.00     15.00     15.00     15.00
Food                           200.00    200.00    200.00    200.00    200.00
LOANS/CREDIT
Car Loan                       200.00    200.00    200.00    200.00    200.00
Credit Card                    100.00    100.00    100.00    100.00    100.00




VEHICLES
Petrol                         150.00    150.00    150.00    150.00    150.00
Insurance
Tax
MOT
Service                                                      250.00
Recovery                                  40.00
INSURANCE'S
Life                            10.00     10.00     10.00     10.00     10.00
Income protection
Health
Mortgage

ADULT SPENDING
Personal                       50.00      50.00         50.00             50.00      50.00
Socialising                   100.00     100.00        100.00            100.00     100.00
Mobile 1                       20.00      20.00         20.00             20.00      20.00
Mobile 2
Toiletries/make up             20.00         20.00         20.00          20.00         20.00
Clothing                       20.00         20.00         20.00          20.00         20.00
Haircut                        10.00         10.00         10.00          10.00         10.00
Birthdays                                                  60.00
Christmas
Holidays                  1200.00
KIDS
Childcare                     150.00     150.00        150.00            150.00     150.00
School fees
Allowance
Clothing                       20.00         20.00         20.00          20.00         20.00
Hobbys/sports
SAVINGS & INVESTMENTS
Short Term Savings            236.50     236.50        236.50            236.50     236.50
Charity                        10.00      10.00         10.00             10.00      10.00
Cash Cushion                  100.00     100.00        100.00            100.00     100.00
Medium Term
Long Term Savings
Pension                     100.00         100.00        100.00       100.00         100.00
Total outgoings           3484.50        2224.50       2244.50       2534.50        2284.50
Monthly balance              96.70        196.70        196.70         96.70          96.70
Balance                    860.40       1057.10       1253.80       1350.50        1447.20

Short Term Savings      Jan            Feb           Mar           Apr            May
Christmas                       5.00       5.00          5.00              5.00       5.00
Birthdays                       5.00       5.00          5.00              5.00       5.00
Holiday(s)                    100.00     100.00        100.00            100.00     100.00
Holiday spending               50.00      50.00         50.00             50.00      50.00
Car Tax                        12.50      12.50         12.50             12.50      12.50
Car Insurance                  34.00      34.00         34.00             34.00      34.00
MOT                             5.00       5.00          5.00              5.00       5.00
Car Service                    21.00      21.00         21.00             21.00      21.00
Car Recovery                    4.00       4.00          4.00              4.00       4.00


SAVE                          236.50     236.50        236.50            236.50     236.50
Adult Spending Personal   Jan         Feb         Mar         Apr         May
Cash
Uncleared cash
Takeaways


Treats (for yourself)
Gifts (for others)




Spent                             0           0           0           0           0
Available                       100         100         100         100         100
 Jun-13    Jul-13    Aug-13    Sep-13    Oct-13    Nov-13    Dec-13   Total
1447.20   1543.90   1640.60   1737.30   1834.00   1930.70   2027.40
1300.00   1300.00   1300.00   1300.00   1300.00   1300.00   1300.00    15600
1000.00   1000.00   1000.00   1000.00   1000.00   1000.00   1000.00    12000
  50.00              150.00              400.00               60.00     2210
                                                                           0
                                                                           0
  81.20     81.20     81.20     81.20     81.20     81.20     81.20      974
                                                                           0
2431.20   2381.20   2531.20   2381.20   2781.20   2381.20   2441.20    29810
3878.40   3925.10   4171.80   4118.50   4615.20   4311.90   4468.60    30784

 500.00    500.00    500.00    500.00    500.00    500.00    500.00     6000
                                                                           0
 100.00    100.00    100.00    100.00    100.00    100.00    100.00     1000
  30.00     30.00     30.00     30.00     30.00     30.00     30.00      360
  25.00     25.00     25.00     25.00     25.00     25.00     25.00      300
  25.00     25.00     25.00     25.00     25.00     25.00     25.00      300
                                                                           0
                                                                           0
  13.00     13.00     13.00     13.00     13.00     13.00     13.00      156
  20.00     20.00     20.00     20.00     20.00     20.00     20.00      240
  15.00     15.00     15.00     15.00     15.00     15.00     15.00      180
  25.00     25.00     25.00     25.00     25.00     25.00     25.00      300
  20.00     20.00     20.00     20.00     20.00     20.00     20.00      240
  15.00     15.00     15.00     15.00     15.00     15.00     15.00      180
 200.00    200.00    200.00    200.00    200.00    200.00    200.00     2400

 300.00    300.00    300.00    300.00    300.00    300.00               2800
                                                                         500
                                                                           0
                                                                           0
                                                                           0

 150.00    150.00    150.00    150.00    150.00    150.00    150.00     1800
                                         400.00                          400
                     150.00                                              150
  50.00                                                                   50
                                                                         250
                                                                          40

  10.00     10.00     10.00     10.00     10.00     10.00     10.00      120
                                                                           0
                                                                           0
                                                                                                           0
                                                                                                           0

       50.00          50.00      50.00         50.00             50.00          50.00          50.00     600
      100.00         100.00     100.00        100.00            100.00         100.00         100.00    1200
       20.00          20.00      20.00         20.00             20.00          20.00          20.00     240
                                                                                                           0
       20.00          20.00         20.00         20.00          20.00          20.00          20.00     240
       20.00          20.00         20.00         20.00          20.00          20.00          20.00     240
       10.00          10.00         10.00         10.00          10.00          10.00          10.00     120
                                                                                                          60
                                                                                               60.00      60
                                                                                                        1200

      150.00         150.00     150.00        150.00            150.00         150.00         150.00    1800
                                                                                                           0
                                                                                                           0
       20.00          20.00         20.00         20.00          20.00          20.00          20.00     240
                                                                                                           0

      236.50         236.50     236.50        236.50            236.50         236.50         236.50    2838
       10.00          10.00      10.00         10.00             10.00          10.00          10.00     120
      100.00         100.00     100.00        100.00            100.00         100.00         400.00
                                                                                                           0
                                                                                                           0
   100.00         100.00         100.00        100.00         100.00        100.00         100.00       1200
  2334.50        2284.50        2434.50       2284.50        2684.50       2284.50        2344.50      27924
    96.70          96.70          96.70         96.70          96.70         96.70          96.70
 1543.90        1640.60        1737.30       1834.00        1930.70       2027.40        2124.10

Jun            Jul            Aug           Sep           Oct            Nov            Dec
        5.00           5.00       5.00          5.00              5.00           5.00           5.00
        5.00           5.00       5.00          5.00              5.00           5.00           5.00
      100.00         100.00     100.00        100.00            100.00         100.00         100.00
       50.00          50.00      50.00         50.00             50.00          50.00          50.00
       12.50          12.50      12.50         12.50             12.50          12.50          12.50
       34.00          34.00      34.00         34.00             34.00          34.00          34.00
        5.00           5.00       5.00          5.00              5.00           5.00           5.00
       21.00          21.00      21.00         21.00             21.00          21.00          21.00
        4.00           4.00       4.00          4.00              4.00           4.00           4.00


      236.50         236.50     236.50        236.50            236.50         236.50         236.50
Jun         Jul         Aug         Sep         Oct         Nov         Dec




        0           0           0           0           0           0           0
      100         100         100         100         100         100         100
Retired    Current Balance      8-Feb
                     Cashflow




                       0.00
                       0.00

    6000
       0
    1000
     360
     300
     300
       0
       0
     156
     240
     180
     300
     240
     180
    2400

    2800
     500
       0
       0
       0

    1800
     400
     150
      50
     250
      40

     120
       0
       0
    0
    0

  600
 1200
  240
    0
  240
  240
  120
   60
   60
 1200

 1800
    0
    0
  240
    0

 2838
  120

    0


26724   0.00   0.00
        0.00   0.00   0.00
                      Assets                                       Liabilities
Savings                                              Car loan                       3,000.00
Short term
Bank name 56781234                          500.00

Cash cushion
Medium term


Investments                (long term)




Total                                     £500.00 Total                            £3,000.00
Assets-Liabilities (Net Worth)                                                    -£2,500.00



        Note: Only put items in the asset cloumn if it is making you money. You may have a car worth £5,000.00 but unless you
        run a taxi service or hire it out it is a liablilty. (Read Rich Dad Poor Dad for an in depth explanation - put
        that an asset puts money in your pocket and a liability takes money out of your pocket)
        The asset column should be larger than the liability column.
ve a car worth £5,000.00 but unless you
depth explanation - put simply it states
                Household
       Need                        Want
Item          Cost          Item          Cost




                     Jobs
Need                        Want
Item          Cost          Item          Cost
                     Mum
       Need                       Want
Item          Cost         Item          Cost
                                                Note: Don't be too strict on
                                                yourself here. But it does
                                                focus the mind to buy what
                                                you really need before what
                                                you want.
                                                To achieve all your goals you
                                                may have to learn and
                                                practise "delayed
                                                gratification" (Rich Dad Poor
                                                Dad).


                     Dad
       Need                       Want
Item          Cost         Item          Cost
n't be too strict on
here. But it does
 mind to buy what
y need before what

       your goals you
e to learn and

ion" (Rich Dad Poor
Date                     2012        2013       2014        2015        2016       2017        2018
David                      47          48          49          50         51          52          53

Wage inflation             1.5         1.5        1.5         1.5         1.5        1.5         1.5
Savings growth rates      2.65        2.65       2.65        2.65        2.65       2.65        2.65
Long Term Savings        1200        1218       1236        1255        1274       1293        1312
Total savings            1200        2432       3714        5049        6438       7882        9383
From Savings
Inflation cpi              3.2         3.2        3.2         3.2         3.2        3.2         3.2
Living expenses        20869.5    21537.3    22226.5     22937.8     23671.8    24429.3     25211.0

Income
State pension (67)       5312        5391       5472        5554        5638       5722        5808

Pension                  8000        8256       8520        8793        9074       9365        9664




less tax                     0          0           0           0          0           0           0


Balance



                         Note: State pension based on 30 years contributions.
                         From April 2011, basic State Pension increases every year by whichever of the following is t
                         highest;
                         earnings – the average percentage increase in UK wages that year,
                         prices – the percentage the cost of living increases by that year or
                         2.5 per cent
                   2019        2020        2021      2022        2023        2024        2025        2026        2027
                     54            55        56         57         58          59          60          61           62

                    1.5         1.5          1.5       1.5         1.5        1.5         1.5         1.5          1.5
                   2.65        2.65         2.65      2.65        2.65       2.65        2.65        2.65         2.65
                  1332        1352         1372      1393        1414       1435        1456        1478         1500
                 10944       12566        14251     16001       17817      19703       21660       23690        25796

                     3.2           3.2       3.2       3.2         3.2         3.2         3.2         3.2         3.2
                26017.8     26850.3      27709.5   28596.2    29511.3     30455.7     31430.3     32436.0     33474.0



                   5895        5984        6073      6165        6257        6351        6446        6543        6641

                   9974      10293        10622     10962       11313      11675       12048       12434        12832




                       0            0         0          0           0           0           0           0              0




                                                   Note: In this example, my savings will run out in 2033, which is
hichever of the following is the                   not a problem if I don't make it past 67 years old. But it is very
                                                   scary as I am expecting to live longer than that. Ideally your
                                                   savings should never run out. When you enter your figures see
                                                   how long yours will last. You may have to play with it to find out
                                                   when you can afford to retire. Add more columns if necessary.
                                                   Update it at the end of each year to see where you stand.
                                                   In any event it is a reality check and you will see what needs to
                                                   be done to retire when you want. In this example I need to re-
                                                   start contributing to a pension and to start saving more.
               2028      2029      2030      2031      2032      2033      2034      2035      2036
                 63        64        65        66        67        68        69        70        71

                 1.5       1.5       1.5       1.5       1.5       1.5       1.5       1.5       1.5
                2.65      2.65      2.65      2.65      2.65      2.65      2.65      2.65      2.65
               1523      1546      1569
              27980     30244     32591     35024     12538    -11293    -29268    -48407    -68767
                                            23414     24163     17675     18364     19077     19815
                 3.2       3.2       3.2       3.2       3.2       3.2       3.2       3.2       3.2
             34545.2   35650.6   36791.4   37968.7   39183.7   40437.6   41731.6   43067.0   44445.2

                                            37969     39184     40438     41732     43067     44445
               6741      6842      6944      7048      7154      7262      7370      7481      7593

              13242     13666     14103     14555     15020     15501     15997     16509     17037




                  0         0         0         0         0         0         0         0         0


                                                0         0         0         0         0         0




o find out
  2037      2038      2039      2040      2041      2042      2043      2044      2045
    72        73        74        75        76        77        78        79        80

    1.5       1.5       1.5       1.5       1.5       1.5       1.5       1.5       1.5
   2.65      2.65      2.65      2.65      2.65      2.65      2.65      2.65      2.65

-90404    -113377   -137749   -163583   -190947   -219910   -250544   -282925   -317132
 20578     21367     22184     23029     23903     24807     25742     26709     27709
    3.2       3.2       3.2       3.2       3.2       3.2       3.2       3.2       3.2
45867.4   47335.2   48849.9   50413.1   52026.3   53691.2   55409.3   57182.4   59012.2

 45867     47335     48850     50413     52026     53691     55409     57182     59012
  7707      7823      7940      8059      8180      8303      8427      8554      8682

 17583     18145     18726     19325     19943     20582     21240     21920     22621




     0         0         0         0         0         0         0         0         0


     0         0         0         0         0         0         0         0         0
  2046      2047      2048      2049      2050      2051      2052      2053      2054
    81        82        83        84        85        86        87        88        89

    1.5       1.5       1.5       1.5       1.5       1.5       1.5       1.5       1.5
   2.65      2.65      2.65      2.65      2.65      2.65      2.65      2.65      2.65

-353244   -391348   -431532   -473886   -518507   -565492   -614946   -666974   -721688
 28743     29813     30919     32062     33245     34468     35732     37040     38391
    3.2       3.2       3.2       3.2       3.2       3.2       3.2       3.2       3.2
60900.6   62849.4   64860.6   66936.2   69078.1   71288.6   73569.9   75924.1   78353.7

 60901     62849     64861     66936     69078     71289     73570     75924     78354
  8812      8944      9079      9215      9353      9493      9636      9780      9927

 23345     24092     24863     25659     26480     27327     28202     29104     30036




     0         0         0         0         0         0         0         0         0


     0         0         0         0         0         0         0         0         0
  2055      2056      2057      2058       2059       2060       2061       2062       2063
    90        91        92        93         94         95         96         97         98

    1.5       1.5       1.5       1.5        1.5        1.5        1.5        1.5        1.5
   2.65      2.65      2.65      2.65       2.65       2.65       2.65       2.65       2.65

-779204   -839641   -903125   -969784   -1039753   -1113172   -1190186   -1270946   -1355608
 39788     41233     42726     44270      45866      47515      49220      50982      52804
    3.2       3.2       3.2       3.2        3.2        3.2        3.2        3.2        3.2
80861.0   83448.5   86118.9   88874.7    91718.7    94653.7    97682.6   100808.4   104034.3

 80861     83449     86119     88875      91719      94654      97683     100808     104034
 10076     10227     10380     10536      10694      10855      11017      11183      11350

 30997     31989     33012     34069      35159      36284      37445      38643      39880




     0         0         0         0          0          0          0          0          0


     0         0         0         0          0          0          0          0          0
   2064       2065       2066       2067
     99        100        101        102

     1.5        1.5        1.5        1.5
    2.65       2.65       2.65       2.65

-1444336   -1537298   -1634669   -1736631
  54687      56633      58644      60722
     3.2        3.2        3.2        3.2
107363.4   110799.0   114344.6   118003.6

 107363     110799     114345     118004
  11521      11693      11869      12047

  41156      42473      43832      45235




      0          0          0          0


      0          0          0          0
Date      Whose     Age Next Birthday    Xmas
                    Birthday  Spend      Spend
24-Mar David               21       60        60
                                                    Note: Enter details as stated, pr
                                                    start of each year you can put a
                                                    birthdays on your calendar and
                                                    forget a birthday.




                        Totals   60.00      60.00
       Monthly Totals             5.00       5.00
       Annual Total                120.00
Note: Enter details as stated, preferably in date order. At the
start of each year you can put all your friends and family
birthdays on your calendar and look the hero when you never
forget a birthday.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:8/9/2012
language:English
pages:33