ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Dashboard31-Dec-2431-Dec-2531-Dec-2631-Dec-2731-Dec-28
3
688,000 1,596,000 2,558,400 3,039,379 3,647,255
4
Example Co
5
31-Dec-24 688,000
6
31-Dec-25 1,596,000
7
Profit & Loss (Summarised)31-Dec-2431-Dec-2531-Dec-26
Balance Sheet (condensed)
31-Dec-2431-Dec-2531-Dec-2631-Dec-26 2,558,400
8
9
Gross Revenue 688,000 1,596,000 2,558,400 `Current Assets 4,115,377 1,289,248 - 2,450,625
10
Cost of Sales 368,080 853,860 1,368,744 Non Current Assets 514,286 428,571 342,857
11
Gross Profit 319,920 742,140 1,189,656
12
Gross Profit Margin %46.5%46.5%46.5%Total Assets 4,629,663 1,717,820 - 2,107,768
13
53.5%53.5%53.5%
14
Operating Expenses 96,320 223,440 358,176 Current Liabilities - - -
15
EBITDA 223,600 518,700 831,480 Non Current Liabilities 540,000 - 2,460,000 - 6,460,000
16
Depreciation & Amortisation(85,714) (85,714) (85,714)
17
EBIT 137,886 432,986 745,766 Total Liabilities 540,000 - 2,460,000 - 6,460,000
18
Interest Expense(32,400) 147,600 387,600
19
EBT 105,486 580,586 1,133,366 Net Equity 4,089,663 4,177,820 4,352,232
20
Taxes(15,823) (15,557) (30,779) Shareholder eqiuty 4,000,000 4,000,000 4,000,000
21
Net Income/ (Loss)89,663565,0291,102,587Retained earnings 89,663 177,820 352,232
22
Net Income as % of Revenue13.03%35.40%43.10%Total Equity 4,089,663 4,177,820 4,352,232
23
24
25
Cashflow (condensed)31-Dec-2431-Dec-2531-Dec-26
26
Net Profit 89,663 88,157 174,413
27
Operating Cashflow 85,714 85,714 85,714
28
29
Investing cashflow(600,000) - -
30
31
Financing cashflow 540,000 (3,000,000) (4,000,000)
32
33
Net Increase/(Decrease) in Cash
115,377 (2,826,129) (3,739,873)
34
Cash at Beginning 4,000,000 4,115,377 1,289,248
35
Ending Cash Balance 4,115,377 1,289,248 (2,450,625)
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