ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Skin + TonicMONTHS
2
123456789101112
3
Opening Balance $30,000.00$322,740.00$325,630.00$330,520.00$334,910.00$342,300.00$347,690.00$341,080.00$343,970.00$347,860.00$534,750.00$541,640.00
4
CASH IN-FLOW
5
Treatment Sales $10,000.00$10,000.00$12,500.00$12,500.00$15,000.00$15,000.00$15,000.00$15,000.00$15,000.00$200,000.00$20,000.00$20,000.00
6
Product Sales $1,000.00$1,000.00$1,000.00$1,000.00$1,500.00$1,500.00$1,500.00$1,500.00$2,000.00$2,000.00$2,000.00$2,000.00
7
Loans $400,000.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
8
Grants$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
9
Investment $0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
10
Total In-Flows$411,000.00$11,000.00$13,500.00$13,500.00$16,500.00$16,500.00$16,500.00$16,500.00$17,000.00$202,000.00$22,000.00$22,000.00
11
CASH OUT-FLOW
12
Clinic/room rental $4,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00
13
Utilities (energy, water, internet)$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00
14
Aesthetics Business Insurance$60.00$60.00$60.00$60.00$60.00$60.00$60.00$60.00$60.00$60.00$60.00$60.00
15
Clinic & Office Supplies $200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00
16
Product Purchases (Fillers, Botulinium Toxins etc)$10,000.00$0.00$0.00$0.00$0.00$0.00$10,000.00$0.00$0.00$0.00$0.00$0.00
17
Equipment$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00$4,000.00
18
Wages$0.00$1,000.00$1,500.00$2,000.00$2,000.00$2,000.00$4,000.00$4,000.00$4,000.00$6,000.00$6,000.00$6,000.00
19
Marketing & Advertising $300.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00
20
Branding$1,000.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
21
Website $50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00
22
Clinic Management Software$50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00$50.00
23
Accountancy Fees$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00
24
Start-up costs$100,000.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
25
Training & Qualifications $0.00$0.00$0.00$0.00$0.00$0.00$0.00$500.00$0.00$0.00$0.00$0.00
26
Miscellaneous $100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00
27
Total Out-Flows$118,260.00$8,110.00$8,610.00$9,110.00$9,110.00$11,110.00$23,110.00$13,610.00$13,110.00$15,110.00$15,110.00$15,110.00
28
NET CASH FLOW
29
Net cash flow$292,740.00$2,890.00$4,890.00$4,390.00$7,390.00$5,390.00-$6,610.00$2,890.00$3,890.00$186,890.00$6,890.00$6,890.00
30
Closing balance$322,740.00$325,630.00$330,520.00$334,910.00$342,300.00$347,690.00$341,080.00$343,970.00$347,860.00$534,750.00$541,640.00$548,530.00
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
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