| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | A personal financial plan is suitable for those who have a stable income. Therefore, it is necessary to revise the financial plan in case of major life changes that entail a change in financial flows. | |||||||||||
2 | If you're always trying new things and changing income sources and tools, then keeping a personal financial plan might not be suitable for you. | |||||||||||
3 | PFP template | |||||||||||
4 | Budget for the month | |||||||||||
5 | Income | $3 500,00 | - enter your monthly income amount here | - manually fill cell | ||||||||
6 | Expenses | $2 000,00 | - enter your monthly expense amount here | - the cell is filled in automatically | ||||||||
7 | Balance | $1 500,00 | ||||||||||
8 | Emergency fund | $375,00 | ||||||||||
9 | Funds for investment per month | $1 125,00 | ||||||||||
10 | Average annual return | 20% | ||||||||||
11 | 1,20 | |||||||||||
12 | Funds for investment per year | $13 500,00 | ||||||||||
13 | 10 years plan | |||||||||||
14 | 1 Year | 2 Years | 3 Years | 4 Years | 5 Years | 6 Years | 7 Years | 8 Years | 9 Years | 10 Years | ||
15 | Average annual investment return | $16 200,00 | $35 640,00 | $58 968,00 | $86 961,60 | $120 553,92 | $160 864,70 | $209 237,64 | $267 285,17 | $336 942,21 | $420 530,65 | |
16 | A year's safety cushion | $4 500,00 | $9 000,00 | $13 500,00 | $18 000,00 | $22 500,00 | $27 000,00 | $31 500,00 | $36 000,00 | $40 500,00 | $0,00 | |
17 | ||||||||||||
18 | ||||||||||||
19 | Example of completing the PFP | |||||||||||
20 | Budget for the month | |||||||||||
21 | Income | $3 000,00 | ||||||||||
22 | Expenses | $2 000,00 | ||||||||||
23 | Balance | $1 000,00 | ||||||||||
24 | Emergency fund | $250,00 | ||||||||||
25 | Funds for investment per month | $750,00 | ||||||||||
26 | Average annual return | 10% | ||||||||||
27 | 1,1 | |||||||||||
28 | Funds for investment per year | $9 000,00 | ||||||||||
29 | 10 Years plan | |||||||||||
30 | 1 Year | 2 Years | 3 Years | 4 Years | 5 Years | 6 Years | 7 Years | 8 Years | 9 Years | 10 Years | ||
31 | Average annual investment return | $9 900,00 | $20 790,00 | $32 769,00 | $45 945,90 | $60 440,49 | $76 384,54 | $93 922,99 | $113 215,29 | $134 436,82 | $157 780,50 | |
32 | A year's safety cushion | $3 000,00 | $6 000,00 | $9 000,00 | $12 000,00 | $15 000,00 | $18 000,00 | $21 000,00 | $24 000,00 | $27 000,00 | $30 000,00 | |
33 | ||||||||||||
34 | ||||||||||||