Get documents about "The Budget Planner Plus
Document Sample
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.
