ABCDEFGHIJKLMNOPQRSTUVWX
1
To copy or download this template, go to the File menu above.
2
Personal Financial Plan / template by Robert Vlachtypical amountMar 2022Apr 2022May 2022Jun 2022Jul 2022Aug 2022Sep 2022Oct 2022Nov 2022Dec 2022Jan 2023Feb 2023Mar 2023Apr 2023May 2023Jun 2023Jul 2023Aug 2023Sep 2023Oct 2023Nov 2023Dec 2023
3
total costs (sum of all items below the bold black line)$3,678$10,643$3,745$4,145$4,025$3,745$3,395$3,645$4,169$3,395$3,595$3,745$3,815$15,845$3,745$3,395$4,025$3,745$3,395$3,645$4,169$3,395
4
monthly business revenues
5
pessimistic (an estimate, or the weakest revenue in the previous 12 months)
$3,700$3,700$3,700$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,000$4,000$4,000$4,000$4,000$5,000$5,000$5,000$5,000$5,000
6
realistic (real, or an estimate, or the same month last year +20%)
$5,513$7,582$5,000$4,600$4,300$5,000$7,600$6,000$5,500$8,500$5,000$5,200$7,000$9,100$6,000$5,500$5,200$6,000$9,100$7,200$6,600$10,200
7
optimistic (an estimate, or the same month last year +50%)$7,000$6,500$5,800$7,000$9,500$8,500$7,000$10,800$7,000$6,700$8,000$11,000$8,000$7,000$6,000$8,000$11,000$9,000$8,000$13,000
8
monthly cash flow (the given scenario minus expenses)
9
pessimistic-$45-$445-$325$755$1,105$855$331$1,105$905$755$185-$11,845$255$605-$25$1,255$1,605$1,355$831$1,605
10
realistic$1,835-$3,061$1,255$455$275$1,255$4,205$2,355$1,331$5,105$1,405$1,455$3,185-$6,745$2,255$2,105$1,175$2,255$5,705$3,555$2,431$6,805
11
optimistic$3,255$2,355$1,775$3,255$6,105$4,855$2,831$7,405$3,405$2,955$4,185-$4,845$4,255$3,605$1,975$4,255$7,605$5,355$3,831$9,605
12
cumulative cash flow (for the given future scenario)
13
pessimistic-$45-$490-$815-$60$1,045$1,900$2,231$3,336$4,241$4,996$5,181-$6,664-$6,409-$5,804-$5,829-$4,574-$2,969-$1,614-$783$822
14
realistic$1,255$1,710$1,985$3,240$7,445$9,800$11,131$16,236$17,641$19,096$22,281$15,536$17,791$19,896$21,071$23,326$29,031$32,586$35,017$41,822
15
optimistic$3,255$5,610$7,385$10,640$16,745$21,600$24,431$31,836$35,241$38,196$42,381$37,536$41,791$45,396$47,371$51,626$59,231$64,586$68,417$78,022
16
exceptional revenues (non-business)
17
profits from sales of investment assets (stocks, cryptocurrencies, etc.)
$6,600
18
minor sales, received gifts, etc.$790
19
real monthly cash flow$9,225-$3,061$1,255$455$275$1,255$4,205$2,355$1,331$5,105$1,405$1,455$3,185-$6,745$2,255$2,105$1,175$2,255$5,705$3,555$2,431$6,805
20
real cumulative cash flow$9,225$6,164$7,419$7,874$8,149$9,404$13,609$15,964$17,295$22,400$23,805$25,260$28,445$21,700$23,955$26,060$27,235$29,490$35,195$38,750$41,181$47,986
21
realistic estimate of financial reserve from the current month forwards
$80,000$80,455$80,730$81,985$86,190$88,545$89,876$94,981$96,386$97,841$101,026$94,281$96,536$98,641$99,816$102,071$107,776$111,331$113,762$120,567
22
fixed business expenses (examples)
23
health insurance$411$411$411$411$411$411$411$411$411$411$411$411$411$411$411$411$411$411$411$411$411$411$411
24
coworking membership$150$150$150$150$150$150$150$150$150$150$150$150$150$150$150$150$150$150$150$150$150$150$150
25
car payments$260$260$260$260$260$260$260$260$260$260$260$260$260$260$260$260$260$260$260$260$260$260$260
26
phone$37$37$37$37$37$37$37$37$37$37$37$37$37$37$37$37$37$37$37$37$37$37$37
27
invoicing software$15$15$15$15$15$15$15$15$15$15$15$15$15$15$15$15$15$15$15$15$15$15$15
28
variable business expenses (examples)
29
office helper$500$478$512$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500
30
virtual secretary$390$285$313$290$290$290$290$290$290$290$290$290$290$290$290$290$290$290$290$290$290$290$290
31
Facebook promo posts$400$470$295$470$470$470$470$470$470$470$470$470$470$470$470$470$470$470$470$470$470$470$470
32
other periodic business costs (month number, examples)
33
1-4-7-10: accounting services$150$150$150$150$150$150$150$150
34
2-5-8-11: classroom rental$350$350$350$350$350$350$350$350
35
1: Chamber of Commerce $50$50
36
3: insurance against business risks$420$420$420
37
4: taxes$7,277$12,300
38
7: web hosting$480$480$480
39
10: yearly Google Workspace license$100$100$100
40
11: annual web maintenance$424$424$424
41
personal and other variable monthly costs (examples)
42
mortgage$380$380$380$380$380$380$380$380$380$380$380$380$380$380$380$380$380$380$380$380$380$380$380
43
electricity$190$190$190$190$190$190$190$190$190$190$190$190$190$190$190$190$190$190$190$190$190$190$190
44
life and accident insurance$192$192$192$192$192$192$192$192$192$192$192$192$192$192$192$192$192$192$192$192$192$192$192
45
minor expenses (groceries, restaurants, cafes, gas, clothing, books, etc.)
$390$461$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500$500
46
one-off expenses$750
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100