Monthly Cash Flow Projections
Darts Corner
AUGUST 2022 THROUGH JULY 2023
Month
AUG
SEP
OCT
NOV
DEC
JAN
FEB
MAR
APR
MAY
JUNE
JULY
TOTAL
Beginning Cash
$41000:00
::$5;000.00
. $4,000.00
:::$4,000:04
::.$4;000.00
:.$4,000.00
::$4;000.90
::$41000:00
.:$4;000.00
::$4,000.00
:$4;000.00
...$4,000.00
$49,000.00
REVENUES
Food & Beverage
$12;000.00
$12,300.00
:$12,607,50
:$12,92169
:$13,245.75
:$13;576:90
$13,916.32.
:$14,264:23
:$14;620.83
:$14,986.36
$15,361.01.$15,745.04
$165,546.64
Dart Board/Juke Box
$900:00
;.::. $900:00$g0o.00
:::::::5900:00
::::::$900:00
::::::,$900:00
::.: :$900:00
:::::$900:00
.::::$900.00
$10,800.00
CASH AVAILABLE
$16,900.00
$18,200:00
.$i7507..50
`:$17;822:69:$18;145:75
$18;476:90
$18,816:32
$19;164:23
:$19;520:83
;$19;886:36
$201261:01
:$20;545.04
$225,346.64
EXPENSES
Cost of Goods Sold
Equipment
a es
g
O.9D
Salaries
.$6;000.00
:: MOD 0.00
:. $6.000:00
.`$5;000:Qo
: $SOdbo.bo
$6,Ooo.00
.:: $6,000.00
6,000.00
000:00
$9o0:0o
$6;000:00
:$61000.00
$72,000.90
Payroll Expense
$0:00
:$9.00
$0.00
':$0:00
::`$0:00:
:$O:oD
: 0:00
.:$0.00
::::::::.::: '0:00
::::.:::: 0.00
:::..: 0:00
::::::::; 0.09
$0.00
Fringe Benefits
Rent
;$5;600.00
::$500:00
::$5,600:00
::.:.$5;fi00:00
:::$51 +;00:00
.::$5;690:DO
`:..$50600.00
::..$5 600.00
.:::$5;600:00
:::$5;500.00
;:$5,660:00:
$51600.00
$67,200.00
Tele phone/]nternet
$133:00
::.::5133:00
:::::$133:00.
`: $133.00
;:::::$133:00
;:::.:$133:00
...::::$133:00
.::::::$133:00$13300
$7.33:00
:. :$133:09
$1,596.00
Utilities
:.::$450.00
:...:$450:00
:.::::.$450:00
:::.:$450:00
:.:::$450:o0
;::.:.$450:00
::::::.:$450.00$450:00
:.::::$450:oo
:::::$450:00
`.::.::$450:00
$5,400.00
Supplies
$i 200:60
:::$11200:00
$1,200.00
:: $1;200:00
.: $1;290:00
::.$1;200:00:
$1;200.00
:::$1,200:00
..$1200.00
:;:$1,200.00
..$1;200:00.
$1,26b.60
$14,400.00
Re air/Maint.
p
::::$800:00
:::::. 800:00
$
:i:: 800:00
$
' '. I: 800:00
$
::.:. 800:00
$
.:::' 8D0:o9800.00.:::
$
$
$
$
$
$ 800.00
$
9 600.00
$ ,
Travel/Delivery
....
$0:90
...:::........
::::`:.:;$0.90
:.:::::.:$0.00
:;::: :i$0.00
::.;:.: $0:00
::.::::::$0.00
;:.. ..$0.00::.:::::::::$0:00
::::..:.$o.00
...:::.$0:00:
:..:: $0.00r:::....$0:00
$0.00
Ads/Promotion
... .......... .::::......
.....:.......:..
Licenses
e ses
..........
Vii'';.
zDa.aD
Insurance
$1;238.00
:::$1;23800
:::$1;238.00238:00:::$1;238.00
::::$11338:00
:::$1;238:00
::$1;238:40
$L238.00.::.$1,238,00
::$1,238.00
.:$1;238.00
$14,856.00
Bad Debts
.
......
.......... .
Loan oa mts
..::; .::..... :....::::.:::.:.:::.:
358:32
..:: ;. 358:32
.:.::: 358:32:
; .. 2
$35$ 3 .
'::::::
... $35$:32
::::::::$358.32......$358$358:32
:32
:::. $358:32
$3224.88
Miscellaneous
.................
...................:.
.
9.a9
TOTAL DISBURSEMENT
$15,421:00
:$15;421.001:$15,421:001:$15
779.32 :$15,779:32
$15;779.32
:$15,779.32
$15;7.79:32
$15979.32
.:$15,779.32
:$15779:32
$15,779:32
$188,476.88
BALANCE
$1;479:00.
$2,7.79:60
:::.$2,086.50
:: $2,043:37
::.$2;366:43
$2;697:58
::$3;037.00
:. $3;384.91
:.:$3,541:51::$4;107:04
:::$4,481 -69L:$4?
-865:72 :.:.:$36,869.76
DEBT COVERAGE RATIO
1 1.101
1.181
1.141
1,131
1.151
1.171
1.19 1,21
1.22 1.2-61
1.281
1.31 Q
�
O
�
Q
o
�
a
�
a
F
CF
Q
o
MITI
o
0 o
e
66 'a
0 'o
o
Y �
6 o
'a
7 al
$
o
B
m
Pi
¢
o
Ri
10 O
o
O
mm
0 4
O
�
C
Darts Corner LLC
Three Year Cash Flow Projection
August 2022 through July 2025
Fiscal Year
August
2022 to July
2023
August
2023 to July
2024
August
2024 to July
2025
Beginning Cash
$
4900.00
$
48,000.00
$
21,000.00
REVENUES
Food & Beverage
$
165,546.64
$
213,435.53
$
250,191.51
Dart Board/Juke Box
$
10,800.00
$
11,340.00
$
11,907.00
CASH AVAILABLE
$
225,346.64
$
272,775.53
$
283,098.51
EXPENSES
Cost of Goods Sold
$
$
$
Equipment
$
$
-
$
-
Wages
$
$
$
Salaries
$
72,000.00
$
108,000.00
$
108,000.00
Payroll Expense
$
-
$
-
$
Fringe Benefits
$
$
-
$
Rent
$
67,200.00
$
68,544.00
$
69,914.88
Telephone/Internet
$
11596.00
$
11596.00
$
11596.00
Utilities
$
51400.00
$
51400.00
$
5,400.00
Supplies
$
14,400.00
$
14,400.00
$
147400.00
Repair/Maint.
$
9,600.00
$
91600.00
$
9,600.00
Travel/Delivery
$
-
$
-
$
Ads/Promotion
$
$
-
$
-
Licenses
$
200.00
$
200.00
$
200.00
Insurance
$
14,856.00
$
14,856.00
$
14,856.00
Bad Debts
$
$
-
$
-
Loan Pymts
$
31224.88
$
4,299.84
$
41299.84
Miscellaneous
$
-
$
$
TOTAL CASH OUTFLOWS
$
188,476.88
$
226,895.84
$
228,266.72
ENDING CASH BALANCE
$
36,869.76
$
45,879.69
$
54,831.79
(Total Cash Available minus Total
Cash Outflows)