Expen
Total $5
38% Selected
This shape represents a slicer. Slicers are suppor
If the shape was modified in an earlier version o
was saved in Excel 2003 or earlier, the slicer can
Sales Plan 110%
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
Profit $9,350 Markup 23%
Select • This shape represents a slicer. Slicers
✘ Capacity
Bank are supported in Excel 2010 or later.
183.7K If the shape was modified in an earlier
167.4K version of Excel, or if the workbook
was saved in Excel 2003 or earlier, the
slicer cannot be used.
This shape represents a slicer. Slicers are supported in Excel 2010 or
later.
If the shape was modified in an earlier version of Excel, or if the
workbook was saved in Excel 2003 or earlier, the slicer cannot be
This shape represents a slicer. Slicers are supported in Excel 2010 or
later.
If the shape was modified in an earlier version of Excel, or if the
workbook was saved in Excel 2003 or earlier, the slicer cannot be
used.
Expense Structure Above Br
$52,606 $11
ed $23,629 +24% Break
a slicer. Slicers are supported in Excel 2010 or later.
ified in an earlier version of Excel, or if the workbook
003 or earlier, the slicer cannot be used.
Revenue $61,956 Expense $52,606
This shape represents a slicer. Slicers are supported in Excel 2010 or later.
If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earl
r. Slicers
or later.
Credit Capacity Use Loan Capital
an earlier
orkbook
earlier, the 21.6%
Debt Servic
32% 22% Margin
12.1%
$210,676 $140,450
$210,676 $140,450
Above Break-Even
$11,956
Break Even Level 12.1%
Margin
$50,000
ON
█
This shape
606 Break Even Level $50,000 represents
a slicer.
Slicers are
supported
in Excel
51 K 2010 or
later.
If the
shape was
modified in
an earlier
version of
Excel, or if
the
workbook
was saved
in Excel
2003 or
earlier, the
aved in Excel 2003 or earlier, the slicer cannot be used. slicer
cannot be
used.
Loan Interest
21.6% 14%
Debt Service Ratio
Margin
86%
12.1%
Loan Body
Loan Body
https://exceltable.com/
Expen
Total $5
38% Selected
This shape represents a slicer. Slicers are suppor
If the shape was modified in an earlier version o
was saved in Excel 2003 or earlier, the slicer can
Sales Plan 110%
Revenue $61,956
1 2 3 4 5 6 7 8 9 10 11 12 13 14
Select • This shape represents a slicer. Slicers
✘ Capacity
Bank are supported in Excel 2010 or later.
183.7K If the shape was modified in an earlier
167.4K version of Excel, or if the workbook
was saved in Excel 2003 or earlier, the
slicer cannot be used.
This shape represents a slicer. Slicers are supported in Excel 2010 or
later.
If the shape was modified in an earlier version of Excel, or if the
workbook was saved in Excel 2003 or earlier, the slicer cannot be
This shape represents a slicer. Slicers are supported in Excel 2010 or
later.
If the shape was modified in an earlier version of Excel, or if the
workbook was saved in Excel 2003 or earlier, the slicer cannot be
used.
Expense Structure Above Br
$52,606 $11
ed $23,629 +24% Break
a slicer. Slicers are supported in Excel 2010 or later.
ified in an earlier version of Excel, or if the workbook
003 or earlier, the slicer cannot be used.
Profit $9,350
This shape represents a slicer. Slicers are supported in Excel 2010 or later.
2 13 14
If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earl
r. Slicers
or later.
Credit Capacity Use Loan Capital
an earlier
orkbook
earlier, the 21.6%
Debt Servic
32% 22% Margin
12.1%
$210,676 $140,450
$210,676 $140,450
Above Break-Even
$11,956
Break Even Level 12.1%
Margin
$50,000
ON
█
This shape
Markup 23% represents a
slicer. Slicers
are supported
in Excel
2010 or later.
If the shape
was modified
in an earlier
version of
Excel, or if
the
workbook
was saved in
Excel 2003
or earlier, the
slicer cannot
be used.
aved in Excel 2003 or earlier, the slicer cannot be used.
Loan Interest
21.6% 14%
Debt Service Ratio
Margin
86%
12.1%
Loan Body
Loan Body
https://exceltable.com/
Markup 23% 23 #REF!
Expense Month Indent Revenue vs Cost
#N/A #N/A #N/A
#REF! JAN #REF! #REF! #REF!
#REF! FEB #REF! #REF! #REF!
#REF! MAR #REF! #REF! #REF!
#REF! APR #REF! #REF! #REF!
#REF! MAY #REF! #REF! #REF!
#REF! JUN #REF! #REF! #REF!
#REF! JUL #REF! #REF! #REF!
#REF! AUG #REF! #REF! #REF!
#REF! SEP #REF! #REF! #REF!
#REF! OCT #REF! #REF! #REF!
#REF! NOV #REF! #REF! #REF!
#REF! DEC #REF! #REF! #REF!
$ - #N/A #N/A #N/A
•
Capacity
MODE TRUE TRUE FALSE
TRUE Interest Rate B1 Interest Rate B2 Interest Rate B3
Select Bank Credit Capacity B1Credit Capacity B2Credit Capacity B3
Credit Line 68692 61807 60242
Credit Cards 34424 32077 29730
Overdraft 24253 20342 18777
Leasing 56330 53201 50072
Credit Line 0% 0% 0%
Credit Cards 0% 0% 0%
Overdraft 0% 0% 0%
Leasing 0% 0% 0%
Top 18369900.00% 16742700.00% 15882100.00%
Down 0 0 0
Cursor 18369900.00% 16742700.00% #N/A
Bank 1 Bank 2 Bank 3
Label 183.7K 167.4K 158.8K
Capacity
Rate 10% 9% 12%
• 24% 25% 24%
16% 16% 15%
6% 8% 8%
Total 14% 14% 15%
Selected 14% 14% 0%
Actual
Year Sales Plan $ - $ 1,455,045
FALSE #NAME? $ 400,000 #DIV/0! #DIV/0!
FALSE #NAME? $ 450,000 Label #DIV/0!
FALSE #NAME? $ 500,000
FALSE #NAME? $ 550,000
Boost $ 14,396.17 5
R vs C I Selected Revenue Break Even L $ 50,000
#N/A #N/A #N/A $ 50,000 $ 50,000
#REF! #N/A ### $ 50,000 TRUE
#REF! #N/A ### $ 50,000 ON
#REF! #N/A ### $ 50,000
#REF! #N/A ### $ 50,000 █
#REF! #N/A ### $ 50,000
#REF! #N/A ### $ 50,000 █
#REF! #N/A ### $ 50,000
#REF! #N/A ### $ 50,000
#REF! #N/A ### $ 50,000
#REF! #N/A ### $ 50,000
#REF! #N/A ### $ 50,000
#REF! #N/A ### $ 50,000
#N/A #N/A #N/A $ 50,000
$ 407,248 Total $ - $ -
FALSE 54%
Interest Rate B4 4
Credit Capacity B4 Title 22%
57113 Credit Line$
25036 Credit Cards$
17994 Overdraft$ Loan Interest
38336 Leasing$ 14%
0% Credit Line%
0% Credit Cards%
0% Overdraft%
0% Leasing%
13847900.00%
0
#N/A
Bank 4 Banks
138.5K BANK 1
BANK 2
11% BANK 3
22% BANK 4
17%
8%
15%
0%
#DIV/0!
$ 50,000
Break Even Level Label Expense Fill ExpensProfit
Profit #N/A #N/A #N/A
JAN 11.4 K 11.4 K #REF!
FEB 13.5 K 13.5 K #REF!
MAR 11.6 K 11.6 K #REF!
APR 17.7 K 17.7 K #REF!
MAY 18.9 K 18.9 K #REF!
JUN 17.1 K 17.1 K #REF!
JUL 17.6 K 17.6 K #REF!
AUG 19.4 K 19.4 K #REF!
SEP 37.4 K 37.4 K #REF!
OCT 20.1 K 20.1 K #REF!
NOV 16.1 K 16.1 K #REF!
DEC 14.3 K 14.3 K #REF!
#N/A #N/A #N/A
Credit Capacity Use Loan Capital Indent
32% 22% 10%
10% 10%
68% 32%
$ 210,676 $ 140,450 https://exceltable.
Loan Body Indent
86% 86% 10%
10% 10%
14% 14%
10% 10%
Buttons Products
🏦 Credit Line
💳 Credit Cards
📉 Overdraft
🚗 Leasing
FALSE FALSE TRUE FALSE Cursor
Debt Marketing Operating Other #N/A
$ 11,704 $ 3,570 $ 11,374 $ 2,346 #N/A
$ 11,704 $ 6,175 $ 13,482 $ 3,044 #N/A
$ 11,704 $ 6,182 $ 11,559 $ 2,419 #N/A
$ 11,704 $ 12,824 $ 17,657 $ 11,337 #N/A
$ 11,704 $ 6,599 $ 18,945 $ 7,396 #N/A
$ 11,704 $ 3,284 $ 17,088 $ 5,716 #N/A
$ 11,704 $ 7,477 $ 17,603 $ 8,100 #N/A #DIV/0!
$ 11,704 $ 8,773 $ 19,359 $ 11,798 #N/A
$ 11,704 $ 8,589 $ 37,389 $ 8,589 #N/A
$ 11,704 $ 10,818 $ 20,063 $ 8,353 #N/A
$ 11,704 $ 2,989 $ 16,088 $ 5,878 #N/A
$ 11,704 $ 4,200 $ 14,338 $ 10,573 #N/A
#N/A
$ -
s://exceltable.com/
Expense Structure % Cursor $
Debt #DIV/0! #DIV/0! FALSE 0% #DIV/0!
Marketing #DIV/0! #DIV/0! FALSE #DIV/0! #DIV/0!
Operating #DIV/0! #DIV/0! TRUE 0% #DIV/0!
Other #DIV/0! #DIV/0! FALSE #DIV/0! #DIV/0!
Selected #DIV/0!
Value #DIV/0! #DIV/0! 0%
0%
Above Break-Even #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
Label #DIV/0! #DIV/0!
Margin #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
Label #DIV/0! #DIV/0!
Debt Service Ratio 1 -1
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0!
Data
Month Sum of Marketing Sum of Operating Sum of Other
OCT 32385 80474 26019
Total Result 32385 80474 26019
Data
Month Sum of Marketing Sum of Operating Sum of Other Sum of Revenue
JAN 14677 58922 18670 86330.1461
FEB 27798 67387 21159 130443.38945
MAR 32690 71022 25172 147517.1324
APR 34043 65102 33876 135265.08215
MAY 27063 68047 27618 115928.48575
JUN 13499 51596 23486 95387.15065
JUL 26228 57514 25700 111802.1674
AUG 26591 61323 32419 126037.032
SEP 56853 114524 34275 204652.07895
OCT 32385 80474 26019 157720.6169
NOV 27327 67702 29409 141669.26015
DEC 19362 53633 30088 99465.53485
Total Result 338516 817246 327891 1552218.07675
Year (empty)
2026
Total Result
Banks (empty)
BANK 1
BANK 2
Total Result
Products (empty)
Credit Cards
Credit Line
Leasing
Overdraft
Total Result
Expense Structu(empty)
Operating
Total Result
https://exceltable.com/
ble.com/
Year Month Marketing Operating Other Revenue
2025 JAN 2778 15130 4862 22252.55395
2025 FEB 3564 14384 8020 27818.51655
2025 MAR 3011 9863 4548 20464.26635
2025 APR 2998 7111 3067 13248.16515
2025 MAY 5185 7866 4219 19312.17475
2025 JUN 1119 2260 1725 5995.40535
2025 JUL 1685 5996 1019 8747.85175
2025 AUG 4419 11589 7857 26462.4932
2025 SEP 12190 18550 8480 44595.32275
2025 OCT 7358 23913 6745 45012.5599
2025 NOV 10836 14899 2709 34213.3
2025 DEC 6530 13575 8935 25651.52095
2026 JAN 3570 11374 2346 16409.3842
2026 FEB 6175 13482 3044 25812.2106
2026 MAR 6182 11559 2419 20649.3881
2026 APR 12824 17657 11337 45583.9032
2026 MAY 6599 18945 7396 29715.8081
2026 JUN 3284 17088 5716 31869.64715
2026 JUL 7477 17603 8100 29620.89075
2026 AUG 8773 19359 11798 41650.24105
2026 SEP 8589 37389 8589 63584.22675
2026 OCT 10818 20063 8353 47560.13405
2026 NOV 2989 16088 5878 25795.29205
2026 DEC 4200 14338 10573 28996.92125
2027 JAN 4426 18442 4292 25777.44345
2027 FEB 13760 26300 7490 53173.07985
2027 MAR 9691 25842 10499 54503.72015
2027 APR 3366 16548 8190 29050.48795
2027 MAY 9098 18196 7714 30594.4441
2027 JUN 4483 17560 10461 33904.13675
2027 JUL 5330 11773 2631 20398.4836
2027 AUG 7349 12000 4249 28827.7671
2027 SEP 26321 37923 7966 61071.41975
2027 OCT 6877 25707 7204 45240.9133
2027 NOV 11914 26639 16547 63687.59815
2027 DEC 6253 18704 7131 31057.72395
2028 JAN 3903 13976 7170 21890.7645
2028 FEB 4299 13221 2605 23639.58245
2028 MAR 13806 23758 7706 51899.7578
2028 APR 14855 23786 11282 47382.52585
2028 MAY 6181 23040 8289 36306.0588
2028 JUN 4613 14688 5584 23617.9614
2028 JUL 11736 22142 13950 53034.9413
2028 AUG 6050 18375 8515 29096.53065
2028 SEP 9753 20662 9240 35401.1097
2028 OCT 7332 10791 3717 19907.00965
2028 NOV 1588 10076 4275 17973.06995
2028 DEC 2379 7016 3449 13759.3687
https://exceltable.com/
Bank 1 Bank 2
Select 1 Year Credit Capacity B1 Interest Rate B1 Credit Capacity B2
FALSE 2025 26741 11% 51701
FALSE 2025 24194 7% 24194
FALSE 2025 22497 24% 17403
FALSE 2025 16130 17% 12309
TRUE 2026 68692 10% 61807
TRUE 2026 56330 6% 53201
TRUE 2026 34424 24% 32077
TRUE 2026 24253 16% 20342
FALSE 2027 117264 10% 75808
FALSE 2027 72929 5% 71970
FALSE 2027 57576 22% 40303
FALSE 2027 31667 13% 25909
FALSE 2028 84321 9% 54960
FALSE 2028 46029 5% 43968
FALSE 2028 39846 21% 37785
FALSE 2028 28854 13% 26106
183699 167427
Bank 2 Bank 3 Bank 4
Interest Rate B2 Credit Capacity B3 Interest Rate B3 Credit Capacity B4
12% 28439 12% 25043
8% 22921 10% 22497
25% 16554 24% 16130
16% 9763 16% 8489
9% 60242 12% 57113
8% 50072 8% 38336
25% 29730 24% 25036
16% 18777 15% 17994
9% 73889 10% 73889
6% 59495 8% 58535
22% 38384 18% 33586
13% 23990 13% 23030
9% 54273 10% 48090
5% 41220 5% 40533
18% 36411 17% 30228
13% 22671 13% 21297
158821 138479
Bank 4
Interest Rate B4 Products Buttons https://exceltable.com/
11% Credit Line 🏦
8% Leasing 🚗
23% Credit Cards 💳
18% Overdraft 📉
11% Credit Line 🏦
8% Leasing 🚗
22% Credit Cards 💳
17% Overdraft 📉
10% Credit Line 🏦
8% Leasing 🚗
21% Credit Cards 💳
15% Overdraft 📉
9% Credit Line 🏦
7% Leasing 🚗
19% Credit Cards 💳
13% Overdraft 📉
ble.com/
0
[>=1000000]#,##0.0,, "M";[<=-1000000]-#,##0.0,, "M";
4E555D
█ <-- ALT+219
1000000]-#,##0.0,, "M";[>=1000]#,##0.0, "K";[<=-1000]-#,##0.0, "K"; https://exceltable
s://exceltable.com/
