Answer To: AssessmentConditions NotetoAssessor...
Ishmeet Singh answered on Dec 09 2021
Contents
Table of Contents - Section & Sheet Titles
Go to the Cover Sheet
1. Reports What each tab does
1 a. Financial Statements Summary On this tab you may get a quick glance at your Financial Statement Summary and have
1 a. a better understanding of the Income Statement, Cash Flow, and the Balance Sheet
1 a. as well as the Monthly view of a fiscal year, and the annual view of the five-year forecast.
2 b. DashBoard DashBoard tab gives you a snapshot of your business financial viability.
2 b. Core financials, Cash Flow data, Revenue Breakdown, Profitability forecasts, and
2 b. cumulative Cash Flow are shown there.
1 c. Top Revenue In here you can see your annual revenue on the midweeks as well as weekends and holidays.
2 d. Top Expenses This tab displays your 4 biggest expense categories and the rest of the expenses as the "other".
1 e. Break Even Analysis Here you can compare your overall revenues with the expenses.
2 f. Valuation Displays your company’s estimated value based on Discounted Cash Flow method.
1 g. Financial Charts On this tab you can visually track your key financial figures in form of charts.
2 h. Operational Charts Here you may visually track your key performance indicators in form of charts.
1 i. Benchmark KPIs This tab shows a comparison of performance indicators in the model and in the industry.
j. Sources and Uses On this tab you can see the funding structure as well as sources and uses of the funds.
2. Assumptions and calculations
1 a. Seasonality Setup On this tab you can see sales seasonality.
2 b. Revenue Calculation Overall revenue are shown here.
1 c. Fixed Expenses Enter fixed expenses and their annual growth rate.
2 d. Wages Fields to enter your employees assumptions: annual salary, taxes,
2 d. hire/fire dates, would-be annual FTEs, etc.
1 e. Variable Expenses Here you can fill up your variable expenses associated with revenue.
2 f. Development Expenses Here you can input Capital Expenses (CAPEX) for the cafe.
1 g. Capitalization Table Shareholder's ownership dilution is calculated here. This tab consists of 4 rounds of financing.
2 h. Book Assets Here you check internal calculations of the assets depreciation and the closing book value.
3. Statements
1 a. Income Statement On this tab you can see the monthly Income Statement report - Revenue, EBITDA, Net Profit.
2 b. Cash Flow Statement Here you can have a comprehensive Monthly Cash Flow Statement (direct method).
1 c. Cash Flow Statement (indirect method) Here you can have a comprehensive Monthly Cash Flow Statement (indirect method).
2 d. Balance Sheet The Balance Sheet Statement. Assets, Liabilities, and Equity are displayed.
1 e. Capital Here you see internal calculations of the loans, interest, and equity.
1 e. In case of capital return, please, use yellow entry line.
2 f. Outputs This is the engine of this tool. All core calculations are done here.
1 g. Inventory On this sheet you can track your inventory within 60 months period.
4. Setup
2 a. Time Series The tab to set up: Fiscal Year End, First Fiscal Year.
&12Built with finmodelslab.com template &12Table of Contents &D
TimeSeries
Time Series
Go to the Table of Contents
Time Series - Assumptions
Fiscal Year End December
12
First Fiscal Year 2020
Term (Years) 5
Your Business Model Start Date 1-Jan-04
Your Business Model End Date 1-Jan-04
Denomination $
Denomination 2
Denomination Conversion Factor 1,000
Currency exch rate $ / $ 1.0000
&12Built with finmodelslab.com template &12Time Series &D
DashBoard
DashBoard CURRENCY, DENOMINATOR & TAX DEBT ASSUMPTIONS
Currency Inputs $ Loan Name Amount, $ Launch Term, M Interest, % Select Type
Go to the Table of Contents Currency Outputs $ Debt_1 800,000 Jan-20 36 7% Usual
Denomination 1,000 Debt_2 100,000 Apr-20 36 7% Usual Min Cash Month Dec-21
Currency exch rate $ / $ 1.000 Debt_3 Min Cash ($'000) 159.1
Corporate tax, % 10% Grant
Core Inputs Revenue Breakdown ($'000) - 5 Years to December 2024 Profitability ($'000) - 5 Years to December 2024
WORKING DAYS INVENTORY
# of Days Open per Week 7 Safety Stock, % 30%
# of Working Days per Year 364
Weekends & Holidays per Year 100
Midweeks per Year 264
AVERAGE SALES PER DAY, $
2020 2021 2022 2023 2024
Midweek 3,700 4,350 5,500 6,550 6,700
Weekends & Holidays 5,500 5,700 6,500 7,000 7,500
SALES MIX BY PRODUCT CATEGORIES, %
Product categories 2020 2021 2022 2023 2024
Food 10% 10% 10% 10% 10%
Beverage 20% 20% 20% 20% 20%
Placeholder 1 30% 30% 30% 30% 30%
Placeholder 2 25% 25% 25% 25% 25%
Placeholder 3 15% 15% 15% 15% 15%
COGS BY PRODUCT CATEGORIES, %
Product categories 2020 2021 2022 2023 2024
Food 20% 20% 20% 20% 20%
Beverage 25% 25% 25% 25% 25%
Placeholder 1 30% 30% 30% 30% 30%
Placeholder 2 35% 35% 35% 35% 35%
Placeholder 3 40% 40% 40% 40% 40%
Core Financials ($'000) Cash flow ($'000) - 5 Years to December 2024 Cumulative CashFlow ($'000) - 5 Years to December 2024
Fiscal Year 2020 2021 2022 2023 2024
Revenue 1,597 1,797 2,199 2,541 2,635
COGS (491) (553) (676) (781) (810)
GROSS MARGIN 1,106 1,245 1,523 1,760 1,825
GROSS MARGIN % 69% 69% 69% 69% 69%
Salaries & Wages (578) (590) (602) (615) (629)
Variable Expenses (303) (342) (418) (483) (501)
Fixed Expenditure (91) (91) (91) (91) (91)
NET MARGIN 134 223 412 571 605
NET MARGIN % 8% 12% 19% 22% 23%
EBITDA 134 223 412 571 605
EBITDA % 8% 12% 19% 22% 23%
Depreciation & Amortization (110.6) (103.6) (103.6) (103.3) (102.0)
EBIT 23 119 308 468 503
Net Interest Expense (48) (35) (14) (0) -
Net Profit Before Tax (25) 84 295 467 503
Tax Expense - (8) (29) (47) (50)
Net Profit After Tax (25) 76 265 421 452
Net Profit After Tax % 0% 4% 12% 17% 17%
Operating Cash Flows 71 178 365 521 553
Cash 281 159 224 711 1,265
Dashboard Source Data
Displayed Periods Description 5 Years to December 2024
0 1 2 3 4 5
Year Ending 2020 2021 2022 2023 2024
Year End Date 1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04
Income Statement Source Data
Revenue 1,597,033 1,797,446 2,198,692 2,540,943 2,634,665
COGS (491,088) (552,715) (676,098) (781,340) (810,159)
Salaries & Wages (577,830) (589,891) (602,388) (615,339) (628,766)
Variable Expenditure (303,436) (341,515) (417,751) (482,779) (500,586)
Fixed Expenditure (90,600) (90,600) (90,600) (90,600) (90,600)
EBITDA 134,079 222,725 411,855 570,885 604,553
Depreciation & Amortization (110,583) (103,583) (103,583) (103,250) (102,000)
EBIT 23,496 119,142 308,272 467,635 502,553
Interest Expense (48,417) (34,708) (13,708) (292) -
Net Profit Before Tax (24,921) 84,434 294,563 467,343 502,553
Tax Expense - (8,443) (29,456) (46,734) (50,255)
Net Profit After Tax (24,921) 75,990 265,107 420,609 452,298
Balance Sheet Source Data
Cash 281,324 159,057 224,061 711,442 1,264,879
Current Assets 295,996 175,569 244,260 734,785 1,289,083
Non-Current Assets 412,417 308,833 205,250 102,000 (0)
Total Assets 708,412 484,403 449,510 836,785 1,289,083
Current Liabilities - - - - -
Non-Current Liabilities 633,333 333,333 33,333 (0) (0)
Total Liabilities 633,333 333,333 33,333 (0) (0)
Net Assets 75,079 151,069 416,176 836,785 1,289,083
Ordinary Equity 100,000 100,000 100,000 100,000 100,000
Retained Profits (24,921) 51,069 316,176 736,785 1,189,083
Total Equity 75,079 151,069 416,176 836,785 1,289,083
Cash Flow Statement Source Data
Cash Receipts 1,597,033 1,797,446 2,198,692 2,540,943 2,634,665
Cash Payments (1,477,625) (1,576,562) (1,790,523) (1,973,202) (2,030,973)
Cash Flow from Operating Activities 70,991 177,732 365,004 520,715 553,437
Fixed Assets Capital Expenditure (523,000) - - - -
Cash Flow from Investing Activities - - - - -
Debt Drawdowns 900,000 - - - -
Debt Repayments (266,667) (300,000) (300,000) (33,333) -
Ordinary Equity Raisings 100,000 - - - -
Ordinary Equity Buybacks - - - - -
Cash Flow from Financing Activities 733,333 (300,000) (300,000) (33,333) -
Net Increase/(Decrease) in Cash Held 281,324 (122,268) 65,004 487,382 553,437
Change in Cash (Pre-Corporate Tax & Interest on Cash) 329,741 (79,116) 108,169 534,408 603,692
Chart Data 2020 2021 2022 2023 2024
1 Midweek 1,022 1,201 1,519 1,809 1,850
2 Weekends & Holidays 575 596 680 732 785
Cash-flow chart data By years
Operating Cash Receipts 1,597 1,797 2,199 2,541 2,635
Financing 685 (335) (314) (34) -
Investing (523) - - - -
Operating Cash Payments (1,478) (1,577) (1,791) (1,973) (2,031)
Tax Payment - (8) (29) (47) (50)
Cash balance 281 159 224 711 1,265
&12Built with finmodelslab.com template &12Dashboard &D
Midweek
2020 2021 2022 2023 2024 1021.7328 1201.2264 1518.7919999999999 1808.7431999999999 1850.1648 Weekends & Holidays
2020 2021 2022 2023 2024 575.29999999999984 596.22 679.89999999999975 732.19999999999993 784.5
Revenue
2020 2021 2022 2023 2024 1597.0327999999997 1797.4463999999998 2198.6919999999996 2540.9431999999993 2634.6648 EBITDA
2020 2021 2022 2023 2024 134.07898199999971 222.72531600000019 411.85495499999973 570.88507724999954 604.55320304250017 EBITDA %
2020 2021 2022 2023 2024 8.395505840581341E-2 0.12391207659933572 0.18731816689195205 0.22467447412834718 0.22946114550985772
Operating Cash Receipts 2020 2021 2022 2023 2024 1597.0327999999997 1797.4463999999998 2198.6919999999996 2540.9431999999993 2634.6648 Operating Cash Payments 2020 2021 2022 2023 2024 -1477.62541175 -1576.5622402499998 -1790.5232012499998 -1973.2023102500002 -2030.9725969575002 Investing 2020 2021 2022 2023 2024 -523 0 0 0 0 Financing 2020 2021 2022 2023 2024 684.91666666666663 -334.70833333333331 -313.70833333333331 -33.625 0 Tax Payment 2020 2021 2022 2023 2024 0 -8.4433649333333207 -29.456328833333306 -46.734341058333328 -50.255320304250013 Cash balance
2020 2021 2022 2023 2024 281.32405491666657 159.05651639999985 224.06065298333317 711.44220167499975 1264.8790844132495
Operating
2020 2021 2022 2023 2024 70.990721583333212 177.73246148333325 365.00413658333338 520.71488202499984 553.43688273824989 Investing
2020 2021 2022 2023 2024 -523 0 0 0 0 Financing
2020 2021 2022 2023 2024 733.33333333333326 -300 -300 -33.333333333333336 0 Net Cash Flow
2020 2021 2022 2023 2024 281.32405491666646 -122.26753851666675 65.004136583333377 487.38154869166652 553.43688273824989 Closing Cash
2020 2021 2022 2023 2024 281.32405491666657 159.05651639999985 224.06065298333317 711.44220167499975 1264.8790844132495
Summary
Financial Statements Summary
Select detailed year: 2020
Go to the Table of Contents
Income Statement ($'000) - 5 Years to December 2024 Income Statement ($'000) - 2020
Year Ending 2020 2021 2022 2023 2024 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Revenue 1,597 1,797 2,199 2,541 2,635 165 102 127 127 127 127 127 127 127 127 153 159
Growth % 13% 22% 16% 4% - (38%) 25% - - - 0% (0%) - - 20% 4%
COGS (491) (553) (676) (781) (810) (51) (31) (39) (39) (39) (39) (39) (39) (39) (39) (47) (49)
% of Revenue (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%) (31%)
GROSS MARGIN 1,106 1,245 1,523 1,760 1,825 115 70 88 88 88 88 88 88 88 88 106 110
GROSS MARGIN % 69% 69% 69% 69% 69% 69% 69% 69% 69% 69% 69% 69% 69% 69% 69% 69% 69%
Variable Expenses (303) (342) (418) (483) (501) (31) (19) (24) (24) (24) (24) (24) (24) (24) (24) (29) (30)
% of Revenue (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%) (19%)
Salaries & Wages (578) (590) (602) (615) (629) (48) (48) (48) (48) (48) (48) (48) (48) (48) (48) (48) (48)
% of Revenue (36%) (33%) (27%) (24%) (24%) (29%) (47%) (38%) (38%) (38%) (38%) (38%) (38%) (38%) (38%) (32%) (30%)
Fixed Expenses (91) (91) (91) (91) (91) (8) (8) (8) (8) (8) (8) (8) (8) (8) (8) (8) (8)
% of Revenue (6%) (5%) (4%) (4%) (3%) (5%) (7%) (6%) (6%) (6%) (6%) (6%) (6%) (6%) (6%) (5%) (5%)
EBITDA 134 223 412 571 605 27 (5) 8 8 8 8 8 8 8 8 21 24
EBITDA % 8% 12% 19% 22% 23% 17% (4%) 6% 6% 6% 6% 7% 6% 6% 6% 14% 15%
Depreciation & Amortization (111) (104) (104) (103) (102) (9) (9) (9) (9) (9) (9) (9) (9) (9) (9) (9) (9)
EBIT 23 119 308 468 503 18 (14) (1) (1) (1) (1) (1) (1) (1) (1) 12 15
Net Interest Expense (48) (35) (14) (0) - - (5) (5) (4) (5) (5) (5) (4) (4) (4) (4) (4)
Net Profit Before Tax (25) 84 295 467 503 18 (18) (6) (5) (6) (6) (5) (5) (5) (5) 8 11
Tax Expense - (8) (29) (47) (50) - - - - - - - - - - - -
Net Profit After Tax (25) 76 265 421 452 18 (18) (6) (5) (6) (6) (5) (5) (5) (5) 8 11
Net Profit After Tax % (2%) 4% 12% 17% 17% 11% (18%) (4%) (4%) (5%) (4%) (4%) (4%) (4%) (4%) 5% 7%
Income Statement ($'000) - 5 Years to December 2024 Income Statement ($'000) - 2020
Balance Sheet ($'000) - 5 Years to December 2024 Balance Sheet ($'000) - 2020
Year Ending 2020 2021 2022 2023 2024 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Assets 296 176 244 735 1,289 907 875 854 436 414 393 372 351 329 309 301 296
Non-Current Assets 412 309 205 102 (0) 514 505 495 486 477 468 458 449 440 431 422 412
Total Assets 708 484 450 837 1,289 1,421 1,380 1,350 922 891 861 830 800 770 739 722 708
Current Liabilities - - - - - 503 502 500 - - - - - - - - -
Non-Current Liabilities 633 333 33 (0) (0) 800 778 756 833 808 783 758 733 708 683 658 633
Total Liabilities 633 333 33 (0) (0) 1,303 1,280 1,256 833 808 783 758 733 708 683 658 633
Net Assets 75 151 416 837 1,289 118 100 94 89 83 77 72 66 61 56 64 75
Net Current Assets 296 176 244 735 1,289 404 373 354 436 414 393 372 351 329 309 301 296
Ordinary Equity 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100
Other Equity 0 (0) - - - (0) (0) (0) - (0) (0) (0) - - - - 0
Retained Profits (25) 51 316 737 1,189 18 (0) (6) (11) (17) (23) (28) (34) (39) (44) (36) (25)
Total Equity 75 151 416 837 1,289 118 100 94 89 83 77 72 66 61 56 64 75
Balance Sheet ($'000) - 5 Years to December 2024 Balance Sheet ($'000) - 2020
Cash Flow Statement ($'000) - 5 Years to December 2024 Cash Flow Statement ($'000) - 2020
Year Ending 2020 2021 2022 2023 2024 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Receipts 1,597 1,797 2,199 2,541 2,635 165 102 127 127 127 127 127 127 127 127 153 159
Cash Payments (1,478) (1,577) (1,791) (1,973) (2,031) (153) (100) (121) (119) (119) (119) (119) (119) (119) (119) (134) (135)
Other Operating Cash Flows (48) (43) (43) (47) (50) - (5) (5) (4) (5) (5) (5) (4) (4) (4) (4) (4)
Operating Cash Flows 71 178 365 521 553 12 (3) 1 4 3 4 4 4 4 4 15 20
Capital Expenditure (523) - - - - (20) (1) (2) (500) - - - - - - - -
Other Investing Cash Flows - - - - - - - - - - - - - - - - -
Investing Cash Flows (523) - - - - (20) (1) (2) (500) - - - - - - - -
Debt Drawdowns/(Repayments) 633 (300) (300) (33) - 800 (22) (22) 78 (25) (25) (25) (25) (25) (25) (25) (25)
Equity Raisings/(Buybacks) 100 - - - - 100 - - - - - - - - - - -
Other Financing Cash Flows - - - - - - - - - - - - - - - - -
Financing Cash Flows 733 (300) (300) (33) - 900 (22) (22) 78 (25) (25) (25) (25) (25) (25) (25) (25)
Change in Cash Held 281 (122) 65 487 553 892 (27) (23) (418) (22) (21) (21) (21) (21) (21) (10) (5)
Closing Cash 281 159 224 711 1,265 892 866 843 424 403 381 360 339 318 297 287 281
Cash Flow Statement ($'000) - 5 Years to December 2024 Cash Flow Statement ($'000) - 2020
Dashboard Source Data
First Displayed Period 1
Displayed Periods Description 5 Years to December 2024
Linked In Data Columns Offset -
Year Ending 2020 2021 2022 2023 2024 1/31/20 2/29/20 3/31/20 4/30/20 5/31/20 6/30/20 7/31/20 8/31/20 9/30/20 10/31/20 11/30/20 12/31/20
Year End Date 1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04
Data Available TRUE TRUE TRUE TRUE TRUE
Income Statement Source Data
Revenue 1,597,033 1,797,446 2,198,692 2,540,943 2,634,665 165,403.3 101,786.7 127,233.3 127,233.3 127,233.3 127,233.3 127,487.8 127,233.3 127,233.3 127,233.3 152,680.0 159,041.7
COGS (491,088) (552,715) (676,098) (781,340) (810,159) (50,861.5) (31,299.4) (39,124.3) (39,124.3) (39,124.3) (39,124.3) (39,202.5) (39,124.3) (39,124.3) (39,124.3) (46,949.1) (48,905.3)
Salaries & Wages (577,830) (589,891) (602,388) (615,339) (628,766) (48,152.5) (48,152.5) (48,152.5) (48,152.5) (48,152.5) (48,152.5) (48,152.5) (48,152.5) (48,152.5) (48,152.5) (48,152.5) (48,152.5)
Variable Expenses (303,436) (341,515) (417,751) (482,779) (500,586) (31,426.6) (19,339.5) (24,174.3) (24,174.3) (24,174.3) (24,174.3) (24,222.7) (24,174.3) (24,174.3) (24,174.3) (29,009.2) (30,217.9)
Fixed Expenses (90,600) (90,600) (90,600) (90,600) (90,600) (7,550.0) (7,550.0) (7,550.0) (7,550.0) (7,550.0) (7,550.0) (7,550.0) (7,550.0) (7,550.0) (7,550.0) (7,550.0) (7,550.0)
EBITDA 134,079 222,725 411,855 570,885 604,553 27,412.7 (4,554.7) 8,232.2 8,232.2 8,232.2 8,232.2 8,360.1 8,232.2 8,232.2 8,232.2 21,019.2 24,215.9
Total Depreciation & Amortization (110,583) (103,583) (103,583) (103,250) (102,000) (9,215.3) (9,215.3) (9,215.3) (9,215.3) (9,215.3) (9,215.3) (9,215.3) (9,215.3) (9,215.3) (9,215.3) (9,215.3) (9,215.3)
EBIT 23,496 119,142 308,272 467,635 502,553 18,197.4 (13,770.0) (983.0) (983.0) (983.0) (983.0) (855.2) (983.0) (983.0) (983.0) 11,803.9 15,000.7
Interest Expense (48,417) (34,708) (13,708) (292) - - (4,666.7) (4,537.0) (4,407.4) (4,861.1) (4,715.3) (4,569.4) (4,423.6) (4,277.8) (4,131.9) (3,986.1) (3,840.3)
Net Profit Before Tax (24,921) 84,434 294,563 467,343 502,553 18,197.4 (18,436.6) (5,520.1) (5,390.4) (5,844.1) (5,698.3) (5,424.6) (5,406.6) (5,260.8) (5,115.0) 7,817.8 11,160.4
Tax Expense - (8,443) (29,456) (46,734) (50,255) - - - - - - - - - - - -
Net Profit After Tax (24,921) 75,990 265,107 420,609 452,298 18,197.4 (18,436.6) (5,520.1) (5,390.4) (5,844.1) (5,698.3) (5,424.6) (5,406.6) (5,260.8) (5,115.0) 7,817.8 11,160.4
Balance Sheet Source Data
Cash 281,324 159,057 224,061 711,442 1,264,879 892,154 865,579 842,705 424,307 402,679 381,196 359,963 338,795 317,749 296,850 286,535 281,324
Current Assets 295,996 175,569 244,260 734,785 1,289,083 907,413 874,969 854,442 436,045 414,416 392,933 371,723 350,532 329,487 308,587 300,620 295,996
Non-Current Assets 412,417 308,833 205,250 102,000 (0) - 513,785 504,569 495,354 486,139 476,924 467,708 458,493 449,278 440,063 430,847 421,632 412,417
Total Assets 708,412 484,403 449,510 836,785 1,289,083 1,421,197 1,379,539 1,349,796 922,184 891,339 860,641 830,217 799,810 769,549 739,434 722,252 708,412
Current Liabilities - - - - - 503,000.0 502,000.0 500,000.0 - - - - - - - - -
Non-Current Liabilities 633,333 333,333 33,333 (0) (0) 800,000.0 777,777.8 755,555.6 833,333.3 808,333.3 783,333.3 758,333.3 733,333.3 708,333.3 683,333.3 658,333.3 633,333.3
Total Liabilities 633,333 333,333 33,333 (0) (0) 1,303,000.0 1,279,777.8 1,255,555.6 833,333.3 808,333.3 783,333.3 758,333.3 733,333.3 708,333.3 683,333.3 658,333.3 633,333.3
Net Assets 75,079 151,069 416,176 836,785 1,289,083 118,197.4 99,760.8 94,240.7 88,850.3 83,006.1 77,307.8 71,883.2 66,476.6 61,215.8 56,100.8 63,918.6 75,079.0
Ordinary Equity 100,000 100,000 100,000 100,000 100,000 100,000.0 100,000.0 100,000.0 100,000.0 100,000.0 100,000.0 100,000.0 100,000.0 100,000.0 100,000.0 100,000.0 100,000.0
Retained Profits (24,921) 51,069 316,176 736,785 1,189,083 18,197.4 (239.2) (5,759.3) (11,149.7) (16,993.9) (22,692.2) (28,116.8) (33,523.4) (38,784.2) (43,899.2) (36,081.4) (24,921.0)
Total Equity 75,079 151,069 416,176 836,785 1,289,083 118,197.4 99,760.8 94,240.7 88,850.3 83,006.1 77,307.8 71,883.2 66,476.6 61,215.8 56,100.8 63,918.6 75,079.0
Cash Flow Statement Source Data
Cash Receipts 1,597,033 1,797,446 2,198,692 2,540,943 2,634,665 165,403.3 101,786.7 127,233.3 127,233.3 127,233.3 127,233.3 127,487.8 127,233.3 127,233.3 127,233.3 152,680.0 159,041.7
Cash Payments (1,477,625) (1,576,562) (1,790,523) (1,973,202) (2,030,973) (153,249.1) (100,472.7) (121,348.5) (119,001.1) (119,001.1) (119,001.1) (119,151.2) (118,977.6) (119,001.1) (119,001.1) (134,008.3) (135,412.6)
Interest Paid (48,417) (34,708) (13,708) (292) - - (4,666.7) (4,537.0) (4,407.4) (4,861.1) (4,715.3) (4,569.4) (4,423.6) (4,277.8) (4,131.9) (3,986.1) (3,840.3)
Operating Cash Flows 70,991 177,732 365,004 520,715 553,437 12,154.2 (3,352.7) 1,347.8 3,824.8 3,371.1 3,517.0 3,767.2 3,832.1 3,954.5 4,100.3 14,685.6 19,788.8
Book Assets Capital Expenditure (523,000) - - - - (20,000.0) (1,000.0) (2,000.0) (500,000.0) - - - - - - - -
Investing Cash Flows (523,000) - - - - (20,000.0) (1,000.0) (2,000.0) (500,000.0) - - - - - - - -
Debt Drawdowns 900,000 - - - - 800,000.0 - - 100,000.0 - - - - - - - -
Debt Repayments (266,667) (300,000) (300,000) (33,333) - - (22,222.2) (22,222.2) (22,222.2) (25,000.0) (25,000.0) (25,000.0) (25,000.0) (25,000.0) (25,000.0) (25,000.0) (25,000.0)
Ordinary Equity Raisings 100,000 - - - - 100,000.0 - - - - - - - - - - -
Ordinary Equity Buybacks - - - - - - - - - - - - - - - - -
Ordinary Equity Dividends Paid - - - - - - - - - - - - - - - - -
Financing Cash Flows 733,333 (300,000) (300,000) (33,333) - 900,000.0 (22,222.2) (22,222.2) 77,777.8 (25,000.0) (25,000.0) (25,000.0) (25,000.0) (25,000.0) (25,000.0) (25,000.0) (25,000.0)
Change in Cash Held 281,324 (122,268) 65,004 487,382 553,437 892,154.2 (26,575.0) (22,874.5) (418,397.4) (21,628.9) (21,483.0) (21,232.8) (21,167.9) (21,045.5) (20,899.7) (10,314.4) (5,211.2)
Error Values - - - - -
EBITDA Reconciliation
EBIT Reconciliation - - - - -
NPBT Reconciliation - - - - -
NPAT Reconciliation - - - - -
Total Assets Reconciliation - - - - -
Total Liabilities Reconciliation - - - - -
Net Assets Reconciliation - - - - -
Balance Sheet Balances Check - - - - -
Cash Flow Statement Reconciliation - - - - -
Total Error Checks - - - - - -
&12Built with finmodelslab.com template &12Financial Statements Summary &D
Top_Revenue
Top Revenue
Go to the Table of Contents
Revenue Summary ($'000) - 5 Years to December 2024
2020 2021 2022 2023 2024 2020 2021 2022 2023 2024
Midweek 1,022 1,201 1,519 1,809 1,850 64.0% 66.8% 69.1% 71.2% 70.2%
Weekends & Holidays 575 596 680 732 785 36.0% 33.2% 30.9% 28.8% 29.8%
Total Revenue 1,597 1,797 2,199 2,541 2,635 100.0% 100.0% 100.0% 100.0% 100.0%
Revenue Summary ($'000) - 5 Years to December 2024
Revenue Depth ($'000) - 2020 Monthly Run-Rate ($'000) - 2020
2020
Revenue Bridge ($'000) - 2020 Total Revenue to 2024 Total Revenue
2020 2024
Dashboard Source Data
Timing Information
First Displayed Period 1
Displayed Periods Description 5 Years to December 2024
Linked In Data Columns Offset -
Central Chart End Date 1
Central Chart Periods Description 2020
Periods of Presentation 1
Displayed Bridge Dates 1 5
Year Ending 2020 2021 2022 2023 2024
Year End Date 1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04
Data Available TRUE TRUE TRUE TRUE TRUE
Revenue Data
Heading Revenue Summary
Base Categories Total Rank Total Base Categories
Midweek 1,021.7 1,201.2 1,518.8 1,808.7 1,850.2 7,400.7 1 7,400.7 Midweek
Weekends & Holidays 575.3 596.2 679.9 732.2 784.5 3,368.1 2 3,368.1 Weekends & Holidays
Total Revenue 1,597.0 1,797.4 2,198.7 2,540.9 2,634.7 10,768.8 10,768.8
Summary Categories Total Monthly 2020
Midweek 1,021.7 1,201.2 1,518.8 1,808.7 1,850.2 7,400.7 85.1 1,021.7
Weekends & Holidays 575.3 596.2 679.9 732.2 784.5 3,368.1 47.9 575.3
Total Revenue 1,597.0 1,797.4 2,198.7 2,540.9 2,634.7 10,768.8
Error Values - - - - -
Balance Check - - - - -
Total Error Checks - - - - - -
Revenue Bridge
Positive Negative Total
Value Cumulative Invisible + Green + Invisble - Green - Red + Red - Blue
2020 Total Revenue 1,597.0 1,597.0 - 1,597.0 - - - - -
Midweek 828.4 2,425.5 1,597.0 828.4 - - - - -
Weekends & Holidays 209.2 2,634.7 2,425.5 209.2 - - - - -
2024 Total Revenue 2,634.7 2,634.7 - - - - - - 2,634.7
&12Built with finmodelslab.com template &12Top Revenue &D
Top_Expenses
Top Expenses
Go to the Table of Contents
Top 5 Expense Categories ($'000) - 5 Years to December 2024
2020 2021 2022 2023 2024 2020 2021 2022 2023 2024
Total Salary and Wages 578 590 602 615 629 51.1% 50.5% 47.9% 46.0% 45.8%
Direct Labor 160 180 220 254 263 14.1% 15.4% 17.5% 19.0% 19.2%
Food loss 80 90 110 127 132 7.1% 7.7% 8.7% 9.5% 9.6%
Total Depreciation 111 104 104 103 102 9.8% 8.9% 8.2% 7.7% 7.4%
Other 203 206 222 239 246 17.9% 17.6% 17.6% 17.9% 17.9%
Total Expenses 1,131 1,169 1,257 1,339 1,372 100% 100% 100% 100% 100%
Top 5 Expense Categories ($'000) - 5 Years to December 2024
Expenses Depth ($'000) - 2020 Monthly Run-Rate ($'000) - 2020
2020
Expenses Bridge ($'000) - 2020 Total Expenses to 2024 Total Expenses
2020 2024
Dashboard Source Data
Timing Information
First Displayed Period 1
Displayed Periods Description 5 Years to December 2024
Linked In Data Columns Offset -
Central Chart End Date 1
Central Chart Periods Description 2020
Periods of Presentation 1
Displayed Bridge Dates 1 5
Year Ending 2020 2021 2022 2023 2024
Year End Date 1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04
Data Available TRUE TRUE TRUE TRUE TRUE
Expenses Data
Heading Top 5 Expense Categories
Base Categories Total Rank Total Base Categories
Direct Labor 159.7 179.7 219.9 254.1 263.5 1,076.9 2 3,014.2 Total Salary and Wages
Bank fee 16.0 18.0 22.0 25.4 26.3 107.7 8 1,076.9 Direct Labor
Food loss 79.9 89.9 109.9 127.0 131.7 538.4 3 538.4 Food loss
Plates 47.9 53.9 66.0 76.2 79.0 323.1 5 523.0 Total Depreciation
VC_Placeholder5 - - - - - - 14 323.1 Plates
VC_Placeholder6 - - - - - - 15 300.0 Rent
Total Salary and Wages 577.8 589.9 602.4 615.3 628.8 3,014.2 1 134.9 Tax Expense
Advertising 6.0 6.0 6.0 6.0 6.0 30.0 11 107.7 Bank fee
Utilities 18.6 18.6 18.6 18.6 18.6 93.0 10 97.1 Interest Expense
Rent 60.0 60.0 60.0 60.0 60.0 300.0 6 93.0 Utilities
Web site 2.4 2.4 2.4 2.4 2.4 12.0 13 30.0 Advertising
Miscellaneous 3.6 3.6 3.6 3.6 3.6 18.0 12 18.0 Miscellaneous
FC_Placeholder6 - - - - - - 16 12.0 Web site
FC_Placeholder7 - - - - - - 17 - VC_Placeholder5
FC_Placeholder8 - - - - - - 18 - VC_Placeholder6
FC_Placeholder9 - - - - - - 19 - FC_Placeholder6
FC_Placeholder10 - - - - - - 20 - FC_Placeholder7
FC_Placeholder11 - - - - - - 21 - FC_Placeholder8
FC_Placeholder12 - - - - - - 22 - FC_Placeholder9
FC_Placeholder13 - - - - - - 23 - FC_Placeholder10
FC_Placeholder14 - - - - - - 24 - FC_Placeholder11
FC_Placeholder15 - - - - - - 25 - FC_Placeholder12
Total Depreciation 110.6 103.6 103.6 103.3 102.0 523.0 4 - FC_Placeholder13
Interest Expense 48.4 34.7 13.7 0.3 - 97.1 9 - FC_Placeholder14
Tax Expense - 8.4 29.5 46.7 50.3 134.9 7 - FC_Placeholder15
Total Expenses 1,130.9 1,168.7 1,257.5 1,339.0 1,372.2 6,268.3 6,268.3
Summary Categories Total Monthly 2020
Total Salary and Wages 577.8 589.9 602.4 615.3 628.8 3,014.2 48.2 577.8
Direct Labor 159.7 179.7 219.9 254.1 263.5 1,076.9 13.3 159.7
Food loss 79.9 89.9 109.9 127.0 131.7 538.4 6.7 79.9
Total Depreciation 110.6 103.6 103.6 103.3 102.0 523.0 9.2 110.6
Other 202.9 205.6 221.7 239.3 246.2 1,115.8 16.9 202.9
Total Expenses 1,130.9 1,168.7 1,257.5 1,339.0 1,372.2 6,268.3
Error Values - - - - -
Balance Check - - - - -
Total Error Checks - - - - - -
Expenses Bridge
Positive Negative Total
Value Cumulative Invisible + Green + Invisble - Green - Red + Red - Blue
2020 Total Expenses 1,130.9 1,130.9 - 1,130.9 - - - - -
Total Salary and Wages 50.9 1,181.8 1,130.9 50.9 - - - - -
Direct Labor 103.8 1,285.6 1,181.8 103.8 - - - - -
Food loss 51.9 1,337.4 1,285.6 51.9 - - - - -
Total Depreciation (8.6) 1,328.9 1,328.9 - - - 8.6 - -
Other 43.3 1,372.2 1,328.9 43.3 - - - - -
2024 Total Expenses 1,372.2 1,372.2 - - - - - - 1,372.2
&12Built with finmodelslab.com template &12Top Expenses &D
BE
Break Even Analysis
Go to the Table of Contents
Break Even Chart ($'000)
Break Even Calculation ($'000)
Fiscal Year 2020 2021 2022 2023 2024
Revenue 1,597 1,797 2,199 2,541 2,635
COGS (491) (553) (676) (781) (810)
Gross Margin 1,106 1,245 1,523 1,760 1,825
Variable Expenses (303) (342) (418) (483) (501)
Net Margin 803 903 1,105 1,277 1,324
EBITDA 134 223 412 571 605
Break Even level 1,647 1,629 1,612 1,611 1,635
Net Profit Before Tax (25) 84 295 467 503
Net Profit Before Tax % 0.0% 4.7% 13.4% 18.4% 19.1%
Net Profit After Tax (25) 76 265 421 452
Net Profit After Tax % 0.0% 4.2% 12.1% 16.6% 17.2%
&12Built with finmodelslab.com template &12Break Even Analysis &D
Valuation
Valuation
Go to the Table of Contents
7.5307182411
WACC Calculation
Cost of Capital
Cost of Resources Resource Share
Loans 7.00% 90.0% Terminal Valuation Method EBITDA X
Equity 10.00% 10.0% Multiple of Method 5.00
Tax Rate 10.00%
Weighted avg cost of capital (WACC) 6.7%
Free Cash Flow Calculation ($'000)
1 2 3 4 5
Free Cash Flow ($'000)
1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04 1-Jan-04
Financial year 2020 2021 2022 2023 2024
Operating Income 23 119 308 468 503
Tax Expense - (8) (29) (47) (50)
Tax-Effected EBIT (Earnings Before Interest) 23 111 279 421 452
Plus: Depreciation Expense 111 104 104 103 102
Capital Expenditures (523) - - - -
Inventory balance 147 166 203 234 243
Accounts Receivable - - - - -
Current Liabilities - - - - -
Non-Current Liabilities (633) (333) (33) 0 0
Changes in Working Capital 486 (318) (337) (65) (9)
Changes in Other Assets & Liabilities
Unlevered Free Cash Flow 97 (104) 45 459 546
Free Cash Flow Valuation ($'000)
Discounted Cash Flow ($'000)
Financial year 2020 2021 2022 2023 2024
Terminal Value 3,023
Present Value of Unlevered Free Cash Flow 91 (92) 37 355 2,584
NPV based on year 5 2,975
Multiplicator evaluation 8x
&12Built with finmodelslab.com template &12Valuation &D
Revenue
Revenue Calculation
Go to the Table of Contents
Revenue ($'000)
2020 2021 2022 2023 2024
Midweek 1,021.7 1,201.2 1,518.8 1,808.7 1,850.2
Weekends & Holidays 575.3 596.2 679.9 732.2 784.5
Total Revenue 1,597.0 1,797.4 2,198.7 2,540.9 2,634.7
Average Revenue per Day 4.4 4.9 6.0 7.0 7.2
Sales Mix ($'000)
2020 2021 2022 2023 2024
Food 159.7 179.7 219.9 254.1 263.5
Beverage 319.4 359.5 439.7 508.2 526.9
Placeholder 1 479.1 539.2 659.6 762.3 790.4
Placeholder 2 399.3 449.4 549.7 635.2 658.7
Placeholder 3 239.6 269.6 329.8 381.1 395.2
Total Revenue 1,597.0 1,797.4 2,198.7 2,540.9 2,634.7
&12Built with finmodelslab.com template &12Revenue Calculation &D
Fin_Charts
Financial Charts
Go to the Table of Contents
24 months 5 years
REVENUE BREAKDOWN - $'000
REVENUE BREAKDOWN - $'000
OPERATING CASH FLOW - $'000
CASH BALANCE - $'000
EBITDA - $'000
EBIT - $'000
&12Built with finmodelslab.com template &12Financial Charts &D
Op_Charts
Operational Charts
Go to the Table of Contents
24 months 5 years
PRODUCTIVITY - $'000
WORKFORCE PRODUCTIVITY - $'000
&12Built with finmodelslab.com template &12Operational Charts &D
KPI
Benchmark KPIs
Go to the Table of Contents
KPI's KPI's
Industry 2020 2021 2022 2023 2024
Gross margin, % 65.0% 69.3% 69.3% 69.3% 69.3% 69.3%
Profit margin, % 15.0% 0.0% 4.2% 12.1% 16.6% 17.2%
Wages as a % of Revenue 30.0% 36.2% 32.8% 27.4% 24.2% 23.9%
Avg weekly revenue, $ 50,000 30,712 34,566 42,283 48,864 50,667
Avg weekly net profit, $ 10,000 -479 1,461 5,098 8,089 8,698
KPI's
2020 2021 2022 2023 2024
Calculated KPI's
Gross margin, % 69% 69% 69% 69% 69%
5 Profit margin, % 0% 4% 12% 17% 17%
1 Wages as a % of Revenue 36% 33% 27% 24% 24%
0 Avg weekly revenue, $ 30,712 34,566 42,283 48,864 50,667
2 Avg weekly net profit, $ -479 1,461 5,098 8,089 8,698
Industry KPI's
Industry Gross margin, % 65% 65% 65% 65% 65%
5 Industry Profit margin, % 15% 15% 15% 15% 15%
1 Industry Wages as a % of Revenue 30% 30% 30% 30% 30%
Industry Avg weekly revenue, $ 50,000 50,000 50,000 50,000 50,000
2 Industry Avg weekly net profit, $ 10,000 10,000 10,000 10,000 10,000
&12Built with finmodelslab.com template &12KPI`s &D
Sources & Uses
Sources and Uses
Go to the Table of Contents
Funding Structure ($'000)
Debts 900.0 90.0% Debts 900
Equity 100.0 10.0% Equity 100
Total Funding 1,000.0 100.0%
Gearing (debt to equity) 9.0x
Sources of Funds ($'000)
Debts Debt_1 800 1 1 Debt_1 800
Debt_1 800.0 80.0% Debt_2 100 2 2 Debt_2 100
Debt_2 100.0 10.0% Debt_3 0 0 3 Founders 100
Debt_3 - 0 - Grant 0 0 4 0 0
Grant - 0 - Founders 100 3 5 0 0
Total Debts 900.0 90.0% Series A 0 0 6 0 0
Series B 0 0 7 0 0
Equity Series C 0 0 8 0 0
Founders 100.0 10.0%
Series A - 0 -
Series B - 0 -
Series C - 0 -
Total Equity 100.0 10.0%
Total Funding 1,000.0 100.0%
Sources and Uses ($'000)
First 12 months
Sources Uses
Revenue receipts 1,597.0 61.5% COGS 505.8 19.5%
Debt Drawdowns 900.0 34.7% Variable Expenses 303.4 11.7%
Equity Raisings 100.0 3.9% Fixed Expenses 90.6 3.5%
Salaries & Wages 577.8 22.2%
Debt Repayments 266.7 10.3%
Interest Paid 48.4 1.9%
Corporate Tax Paid - 0 -
Capital Expenditure 523.0 20.1%
Cash in Bank 281.3 10.8%
Total Sources 2,597.0 100.0% Total Uses 2,597.0 100.0%
&12Built with finmodelslab.com template &12Sources and Uses &D
IS
Income Statement
Go to the Table of Contents
Fiscal year 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024
Month Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24
Period Start Date 01/01/2020 01/02/2020 01/03/2020 01/04/2020 01/05/2020 01/06/2020 01/07/2020 01/08/2020 01/09/2020 01/10/2020 01/11/2020 01/12/2020 01/01/2021 01/02/2021 01/03/2021 01/04/2021 01/05/2021 01/06/2021 01/07/2021 01/08/2021 01/09/2021 01/10/2021 01/11/2021 01/12/2021 01/01/2022 01/02/2022 01/03/2022 01/04/2022 01/05/2022 01/06/2022 01/07/2022 01/08/2022 01/09/2022 01/10/2022 01/11/2022 01/12/2022 01/01/2023 01/02/2023 01/03/2023 01/04/2023 01/05/2023 01/06/2023 01/07/2023 01/08/2023 01/09/2023 01/10/2023 01/11/2023 01/12/2023 01/01/2024 01/02/2024 01/03/2024 01/04/2024 01/05/2024 01/06/2024 01/07/2024 01/08/2024 01/09/2024 01/10/2024 01/11/2024 01/12/2024
Period End Date Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24
Counter 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 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
Current Year 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024
Income Statement, $
Revenue
Midweek 105,820 65,120 81,400 81,400 81,400 81,400 81,563 81,400 81,400 81,400 97,680 101,750 124,410 76,560 95,700 95,700 95,700 95,700 95,891 95,700 95,700 95,700 114,840 119,625 157,300 96,800 121,000 121,000 121,000 121,000 121,242 121,000 121,000 121,000 145,200 151,250 187,330 115,280 144,100 144,100 144,100 144,100 144,388 144,100 144,100 144,100 172,920 180,125 191,620 117,920 147,400 147,400 147,400 147,400 147,695 147,400 147,400 147,400 176,880 184,250
Weekends & Holidays 59,583 36,667 45,833 45,833 45,833 45,833 45,925 45,833 45,833 45,833 55,000 57,292 61,750 38,000 47,500 47,500 47,500 47,500 47,595 47,500 47,500 47,500 57,000 59,375 70,417 43,333 54,167 54,167 54,167 54,167 54,275 54,167 54,167 54,167 65,000 67,708 75,833 46,667 58,333 58,333 58,333 58,333 58,450 58,333 58,333 58,333 70,000 72,917 81,250 50,000 62,500 62,500 62,500 62,500 62,625 62,500 62,500 62,500 75,000 78,125
Total Revenue 165,403 101,787 127,233 127,233 127,233 127,233 127,488 127,233 127,233 127,233 152,680 159,042 186,160 114,560 143,200 143,200 143,200 143,200 143,486 143,200 143,200 143,200 171,840 179,000 227,717 140,133 175,167 175,167 175,167 175,167 175,517 175,167 175,167 175,167 210,200 218,958 263,163 161,947 202,433 202,433 202,433 202,433 202,838 202,433 202,433 202,433 242,920 253,042 272,870 167,920 209,900 209,900 209,900 209,900 210,320 209,900 209,900 209,900 251,880 262,375
COGS
Food (3,308) (2,036) (2,545) (2,545) (2,545) (2,545) (2,550) (2,545) (2,545) (2,545) (3,054) (3,181) (3,723) (2,291) (2,864) (2,864) (2,864) (2,864) (2,870) (2,864) (2,864) (2,864) (3,437) (3,580) (4,554) (2,803) (3,503) (3,503) (3,503) (3,503) (3,510) (3,503) (3,503) (3,503) (4,204) (4,379) (5,263) (3,239) (4,049) (4,049) (4,049) (4,049) (4,057) (4,049) (4,049) (4,049) (4,858) (5,061) (5,457) (3,358) (4,198) (4,198) (4,198) (4,198) (4,206) (4,198) (4,198) (4,198) (5,038) (5,248)
Beverage (8,270) (5,089) (6,362) (6,362) (6,362) (6,362) (6,374) (6,362) (6,362) (6,362) (7,634) (7,952) (9,308) (5,728) (7,160) (7,160) (7,160) (7,160) (7,174) (7,160) (7,160) (7,160) (8,592) (8,950) (11,386) (7,007) (8,758) (8,758) (8,758) (8,758) (8,776) (8,758) (8,758) (8,758) (10,510) (10,948) (13,158) (8,097) (10,122) (10,122) (10,122) (10,122) (10,142) (10,122) (10,122) (10,122) (12,146) (12,652) (13,644) (8,396) (10,495) (10,495) (10,495) (10,495) (10,516) (10,495) (10,495) (10,495) (12,594) (13,119)
Placeholder 1 (14,886) (9,161) (11,451) (11,451) (11,451) (11,451) (11,474) (11,451) (11,451) (11,451) (13,741) (14,314) (16,754) (10,310) (12,888) (12,888) (12,888) (12,888) (12,914) (12,888) (12,888) (12,888) (15,466) (16,110) (20,495) (12,612) (15,765) (15,765) (15,765) (15,765) (15,797) (15,765) (15,765) (15,765) (18,918) (19,706) (23,685) (14,575) (18,219) (18,219) (18,219) (18,219) (18,255) (18,219) (18,219) (18,219) (21,863) (22,774) (24,558) (15,113) (18,891) (18,891) (18,891) (18,891) (18,929) (18,891) (18,891) (18,891) (22,669) (23,614)
Placeholder 2 (14,473) (8,906) (11,133) (11,133) (11,133) (11,133) (11,155) (11,133) (11,133) (11,133) (13,360) (13,916) (16,289) (10,024) (12,530) (12,530) (12,530) (12,530) (12,555) (12,530) (12,530) (12,530) (15,036) (15,662) (19,925) (12,262) (15,327) (15,327) (15,327) (15,327) (15,358) (15,327) (15,327) (15,327) (18,393) (19,159) (23,027) (14,170) (17,713) (17,713) (17,713) (17,713) (17,748) (17,713) (17,713) (17,713) (21,256) (22,141) (23,876) (14,693) (18,366) (18,366) (18,366) (18,366) (18,403) (18,366) (18,366) (18,366) (22,040) (22,958)
Placeholder 3 (9,924) (6,107) (7,634) (7,634) (7,634) (7,634) (7,649) (7,634) (7,634) (7,634) (9,161) (9,542) (11,170) (6,874) (8,592) (8,592) (8,592) (8,592) (8,609) (8,592) (8,592) (8,592) (10,310) (10,740) (13,663) (8,408) (10,510) (10,510) (10,510) (10,510) (10,531) (10,510) (10,510) (10,510) (12,612) (13,137) (15,790) (9,717) (12,146) (12,146) (12,146) (12,146) (12,170) (12,146) (12,146) (12,146) (14,575) (15,182) (16,372) (10,075) (12,594) (12,594) (12,594) (12,594) (12,619) (12,594) (12,594) (12,594) (15,113) (15,742)
Total COGS (50,862) (31,299) (39,124) (39,124) (39,124) (39,124) (39,202) (39,124) (39,124) (39,124) (46,949) (48,905) (57,244) (35,227) (44,034) (44,034) (44,034) (44,034) (44,122) (44,034) (44,034) (44,034) (52,841) (55,042) (70,023) (43,091) (53,864) (53,864) (53,864) (53,864) (53,971) (53,864) (53,864) (53,864) (64,636) (67,330) (80,923) (49,799) (62,248) (62,248) (62,248) (62,248) (62,373) (62,248) (62,248) (62,248) (74,698) (77,810) (83,908) (51,635) (64,544) (64,544) (64,544) (64,544) (64,673) (64,544) (64,544) (64,544) (77,453) (80,680)
GROSS MARGIN 114,542 70,487 88,109 88,109 88,109 88,109 88,285 88,109 88,109 88,109 105,731 110,136 128,916 79,333 99,166 99,166 99,166 99,166 99,364 99,166 99,166 99,166 118,999 123,957 157,694 97,042 121,303 121,303 121,303 121,303 121,546 121,303 121,303 121,303 145,564 151,629 182,241 112,148 140,185 140,185 140,185 140,185 140,465 140,185 140,185 140,185 168,222 175,231 188,962 116,285 145,356 145,356 145,356 145,356 145,646 145,356 145,356 145,356 174,427 181,695
Variable Expenses
Direct Labor (16,540) (10,179) (12,723) (12,723) (12,723) (12,723) (12,749) (12,723) (12,723) (12,723) (15,268) (15,904) (18,616) (11,456) (14,320) (14,320) (14,320) (14,320) (14,349) (14,320) (14,320) (14,320) (17,184) (17,900) (22,772) (14,013) (17,517) (17,517) (17,517) (17,517) (17,552) (17,517) (17,517) (17,517) (21,020) (21,896) (26,316) (16,195) (20,243) (20,243) (20,243) (20,243) (20,284) (20,243) (20,243) (20,243) (24,292) (25,304) (27,287) (16,792) (20,990) (20,990) (20,990) (20,990) (21,032) (20,990) (20,990) (20,990) (25,188) (26,238)
Bank fee (1,654) (1,018) (1,272) (1,272) (1,272) (1,272) (1,275) (1,272) (1,272) (1,272) (1,527) (1,590) (1,862) (1,146) (1,432) (1,432) (1,432) (1,432) (1,435) (1,432) (1,432) (1,432) (1,718) (1,790) (2,277) (1,401) (1,752) (1,752) (1,752) (1,752) (1,755) (1,752) (1,752) (1,752) (2,102) (2,190) (2,632) (1,619) (2,024) (2,024) (2,024) (2,024) (2,028) (2,024) (2,024) (2,024) (2,429) (2,530) (2,729) (1,679) (2,099) (2,099) (2,099) (2,099) (2,103) (2,099) (2,099) (2,099) (2,519) (2,624)
Food loss (8,270) (5,089) (6,362) (6,362) (6,362) (6,362) (6,374) (6,362) (6,362) (6,362) (7,634) (7,952) (9,308) (5,728) (7,160) (7,160) (7,160) (7,160) (7,174) (7,160) (7,160) (7,160) (8,592) (8,950) (11,386) (7,007) (8,758) (8,758) (8,758) (8,758) (8,776) (8,758) (8,758) (8,758) (10,510) (10,948) (13,158) (8,097) (10,122) (10,122) (10,122) (10,122) (10,142) (10,122) (10,122) (10,122) (12,146) (12,652) (13,644) (8,396) (10,495) (10,495) (10,495) (10,495) (10,516) (10,495) (10,495) (10,495) (12,594) (13,119)
Plates (4,962) (3,054) (3,817) (3,817) (3,817) (3,817) (3,825) (3,817) (3,817) (3,817) (4,580) (4,771) (5,585) (3,437) (4,296) (4,296) (4,296) (4,296) (4,305) (4,296) (4,296) (4,296) (5,155) (5,370) (6,832) (4,204) (5,255) (5,255) (5,255) (5,255) (5,266) (5,255) (5,255) (5,255) (6,306) (6,569) (7,895) (4,858) (6,073) (6,073) (6,073) (6,073) (6,085) (6,073) (6,073) (6,073) (7,288) (7,591) (8,186) (5,038) (6,297) (6,297) (6,297) (6,297) (6,310) (6,297) (6,297) (6,297) (7,556) (7,871)
VC_Placeholder5 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
VC_Placeholder6 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Total Variable Expenses (31,427) (19,339) (24,174) (24,174) (24,174) (24,174) (24,223) (24,174) (24,174) (24,174) (29,009) (30,218) (35,370) (21,766) (27,208) (27,208) (27,208) (27,208) (27,262) (27,208) (27,208) (27,208) (32,650) (34,010) (43,266) (26,625) (33,282) (33,282) (33,282) (33,282) (33,348) (33,282) (33,282) (33,282) (39,938) (41,602) (50,001) (30,770) (38,462) (38,462) (38,462) (38,462) (38,539) (38,462) (38,462) (38,462) (46,155) (48,078) (51,845) (31,905) (39,881) (39,881) (39,881) (39,881) (39,961) (39,881) (39,881) (39,881) (47,857) (49,851)
Salary and Wages
Waiter (13,090) (13,090) (13,090) (13,090) (13,090) (13,090) (13,090) (13,090) (13,090) (13,090) (13,090) (13,090) (13,745) (13,745) (13,745) (13,745) (13,745) (13,745) (13,745) (13,745) (13,745) (13,745) (13,745) (13,745) (14,432) (14,432) (14,432) (14,432) (14,432) (14,432) (14,432) (14,432) (14,432) (14,432) (14,432) (14,432) (15,153) (15,153) (15,153) (15,153) (15,153) (15,153) (15,153) (15,153) (15,153) (15,153) (15,153) (15,153) (15,911) (15,911) (15,911) (15,911) (15,911) (15,911) (15,911) (15,911) (15,911) (15,911) (15,911) (15,911)
Administrator (4,675) (4,675) (4,675) (4,675) (4,675) (4,675) (4,675) (4,675) (4,675) (4,675) (4,675) (4,675) (4,722) (4,722) (4,722) (4,722) (4,722) (4,722) (4,722) (4,722) (4,722) (4,722) (4,722) (4,722) (4,769) (4,769) (4,769) (4,769) (4,769) (4,769) (4,769) (4,769) (4,769) (4,769) (4,769) (4,769) (4,817) (4,817) (4,817) (4,817) (4,817) (4,817) (4,817) (4,817) (4,817) (4,817) (4,817) (4,817) (4,865) (4,865) (4,865) (4,865) (4,865) (4,865) (4,865) (4,865) (4,865) (4,865) (4,865) (4,865)
Cleaner (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811)
Cook (14,025) (14,025) (14,025) (14,025) (14,025) (14,025) (14,025) (14,025) (14,025) (14,025) (14,025) (14,025) (14,165) (14,165) (14,165) (14,165) (14,165) (14,165) (14,165) (14,165) (14,165) (14,165) (14,165) (14,165) (14,307) (14,307) (14,307) (14,307) (14,307) (14,307) (14,307) (14,307) (14,307) (14,307) (14,307) (14,307) (14,450) (14,450) (14,450) (14,450) (14,450) (14,450) (14,450) (14,450) (14,450) (14,450) (14,450) (14,450) (14,594) (14,594) (14,594) (14,594) (14,594) (14,594) (14,594) (14,594) (14,594) (14,594) (14,594) (14,594)
Chef (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,545) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,610) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,677) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,743) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811) (6,811)
Accounting (3,273) (3,273) (3,273) (3,273) (3,273) (3,273) (3,273) (3,273) (3,273) (3,273) (3,273) (3,273) (3,305) (3,305) (3,305) (3,305) (3,305) (3,305) (3,305) (3,305) (3,305) (3,305) (3,305) (3,305) (3,338) (3,338) (3,338) (3,338) (3,338) (3,338) (3,338) (3,338) (3,338) (3,338) (3,338) (3,338) (3,372) (3,372) (3,372) (3,372) (3,372) (3,372) (3,372) (3,372) (3,372) (3,372) (3,372) (3,372) (3,405) (3,405) (3,405) (3,405) (3,405) (3,405) (3,405) (3,405) (3,405) (3,405) (3,405) (3,405)
HC_Placeholder7 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder8 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder9 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder10 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder11 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder13 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder14 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder15 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder16 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder17 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder18 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
HC_Placeholder19 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Total Salary and Wages (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397)
Fixed Expenses
Advertising (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500) (500)
Utilities (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550) (1,550)
Rent (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000)
Web site (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200) (200)
Miscellaneous (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300) (300)
FC_Placeholder6 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FC_Placeholder7 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FC_Placeholder8 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FC_Placeholder9 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FC_Placeholder10 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FC_Placeholder11 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FC_Placeholder12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FC_Placeholder13 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FC_Placeholder14 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FC_Placeholder15 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Total Fixed Expenses (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550)
Total Operating Expenditure (87,129) (75,042) (79,877) (79,877) (79,877) (79,877) (79,925) (79,877) (79,877) (79,877) (84,712) (85,920) (92,078) (78,474) (83,916) (83,916) (83,916) (83,916) (83,970) (83,916) (83,916) (83,916) (89,357) (90,718) (101,015) (84,374) (91,031) (91,031) (91,031) (91,031) (91,097) (91,031) (91,031) (91,031) (97,687) (99,351) (108,829) (89,598) (97,291) (97,291) (97,291) (97,291) (97,367) (97,291) (97,291) (97,291) (104,983) (106,906) (111,792) (91,852) (99,828) (99,828) (99,828) (99,828) (99,908) (99,828) (99,828) (99,828) (107,804) (109,798)
EBITDA 27,413 (4,555) 8,232 8,232 8,232 8,232 8,360 8,232 8,232 8,232 21,019 24,216 36,838 859 15,250 15,250 15,250 15,250 15,394 15,250 15,250 15,250 29,642 33,240 56,679 12,668 30,272 30,272 30,272 30,272 30,448 30,272 30,272 30,272 47,877 52,278 73,411 22,550 42,895 42,895 42,895 42,895 43,098 42,895 42,895 42,895 63,239 68,325 77,170 24,433 45,528 45,528 45,528 45,528 45,739 45,528 45,528 45,528 66,623 71,896
Depreciation & Amortization
Cafe Development (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400) (8,400)
Placeholder1 (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) (104) - - - - - - - - - - - -
Placeholder2 (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) (28) - - - - - - - - - - - - - - - - - - - - - - - -
Placeholder3 (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100) (100)
Placeholder4 (583) (583) (583) (583) (583) (583) (583) (583) (583) (583) (583) (583) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Placeholder5 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Placeholder6 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Total Depreciation (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500)
Total Depreciation & Amortization (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (9,215) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,632) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,604) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500) (8,500)
EBIT 18,197 (13,770) (983) (983) (983) (983) (855) (983) (983) (983) 11,804 15,001 28,206 (7,773) 6,618 6,618 6,618 6,618 6,762 6,618 6,618 6,618 21,010 24,608 48,047 4,036 21,640 21,640 21,640 21,640 21,816 21,640 21,640 21,640 39,245 43,646 64,807 13,946 34,290 34,290 34,290 34,290 34,494 34,290 34,290 34,290 54,635 59,721 68,670 15,933 37,028 37,028 37,028 37,028 37,239 37,028 37,028 37,028 58,123 63,396
Interest Expense - (4,667) (4,537) (4,407) (4,861) (4,715) (4,569) (4,424) (4,278) (4,132) (3,986) (3,840) (3,694) (3,549) (3,403) (3,257) (3,111) (2,965) (2,819) (2,674) (2,528) (2,382) (2,236) (2,090) (1,944) (1,799) (1,653) (1,507) (1,361) (1,215) (1,069) (924) (778) (632) (486) (340) (194) (49) (32) (16) - - - - - - - - - - - - - - - - - - - -
Net Profit Before Tax 18,197 (18,437) (5,520) (5,390) (5,844) (5,698) (5,425) (5,407) (5,261) (5,115) 7,818 11,160 24,511 (11,322) 3,216 3,361 3,507 3,653 3,943 3,945 4,091 4,236 18,774 22,518 46,102 2,237 19,988 20,133 20,279 20,425 20,747 20,717 20,863 21,008 38,758 43,305 64,613 13,897 34,258 34,274 34,290 34,290 34,494 34,290 34,290 34,290 54,635 59,721 68,670 15,933 37,028 37,028 37,028 37,028 37,239 37,028 37,028 37,028 58,123 63,396
Tax Expense 12.0 12.0 - - - - - - - - - - - - (2,161) - (284) (296) (309) (322) (348) (348) (361) (374) (1,655) (1,986) (4,610) (224) (1,999) (2,013) (2,028) (2,043) (2,075) (2,072) (2,086) (2,101) (3,876) (4,331) (6,461) (1,390) (3,426) (3,427) (3,429) (3,429) (3,449) (3,429) (3,429) (3,429) (5,463) (5,972) (6,867) (1,593) (3,703) (3,703) (3,703) (3,703) (3,724) (3,703) (3,703) (3,703) (5,812) (6,340)
Net Profit After Tax 18,197 (18,437) (5,520) (5,390) (5,844) (5,698) (5,425) (5,407) (5,261) (5,115) 7,818 11,160 22,350 (11,322) 2,932 3,065 3,198 3,331 3,595 3,597 3,730 3,863 17,119 20,532 41,492 2,014 17,989 18,120 18,251 18,383 18,672 18,645 18,776 18,908 34,883 38,975 58,151 12,507 30,832 30,847 30,861 30,861 31,044 30,861 30,861 30,861 49,171 53,749 61,803 14,339 33,325 33,325 33,325 33,325 33,515 33,325 33,325 33,325 52,310 57,057
Error Check - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
0 1 2 3 4 5 6 7 8 9 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
&12Built with finmodelslab.com template &12Income Statement &D
CF
Cash Flow Statement
Go to the Table of Contents
é ç è x h O
Fiscal year 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024
Month Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24
Period Start Date 01/01/2020 01/02/2020 01/03/2020 01/04/2020 01/05/2020 01/06/2020 01/07/2020 01/08/2020 01/09/2020 01/10/2020 01/11/2020 01/12/2020 01/01/2021 01/02/2021 01/03/2021 01/04/2021 01/05/2021 01/06/2021 01/07/2021 01/08/2021 01/09/2021 01/10/2021 01/11/2021 01/12/2021 01/01/2022 01/02/2022 01/03/2022 01/04/2022 01/05/2022 01/06/2022 01/07/2022 01/08/2022 01/09/2022 01/10/2022 01/11/2022 01/12/2022 01/01/2023 01/02/2023 01/03/2023 01/04/2023 01/05/2023 01/06/2023 01/07/2023 01/08/2023 01/09/2023 01/10/2023 01/11/2023 01/12/2023 01/01/2024 01/02/2024 01/03/2024 01/04/2024 01/05/2024 01/06/2024 01/07/2024 01/08/2024 01/09/2024 01/10/2024 01/11/2024 01/12/2024
Period End Date Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24
Counter 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 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
Current Year 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024
Cash Flow Statement, $
Cash Flow from Operating Activities
Revenue 165,403 101,787 127,233 127,233 127,233 127,233 127,488 127,233 127,233 127,233 152,680 159,042 186,160 114,560 143,200 143,200 143,200 143,200 143,486 143,200 143,200 143,200 171,840 179,000 227,717 140,133 175,167 175,167 175,167 175,167 175,517 175,167 175,167 175,167 210,200 218,958 263,163 161,947 202,433 202,433 202,433 202,433 202,838 202,433 202,433 202,433 242,920 253,042 272,870 167,920 209,900 209,900 209,900 209,900 210,320 209,900 209,900 209,900 251,880 262,375
Inflow 165,403 101,787 127,233 127,233 127,233 127,233 127,488 127,233 127,233 127,233 152,680 159,042 186,160 114,560 143,200 143,200 143,200 143,200 143,486 143,200 143,200 143,200 171,840 179,000 227,717 140,133 175,167 175,167 175,167 175,167 175,517 175,167 175,167 175,167 210,200 218,958 263,163 161,947 202,433 202,433 202,433 202,433 202,838 202,433 202,433 202,433 242,920 253,042 272,870 167,920 209,900 209,900 209,900 209,900 210,320 209,900 209,900 209,900 251,880 262,375
Cash Receipts 165,403 101,787 127,233 127,233 127,233 127,233 127,488 127,233 127,233 127,233 152,680 159,042 186,160 114,560 143,200 143,200 143,200 143,200 143,486 143,200 143,200 143,200 171,840 179,000 227,717 140,133 175,167 175,167 175,167 175,167 175,517 175,167 175,167 175,167 210,200 218,958 263,163 161,947 202,433 202,433 202,433 202,433 202,838 202,433 202,433 202,433 242,920 253,042 272,870 167,920 209,900 209,900 209,900 209,900 210,320 209,900 209,900 209,900 251,880 262,375
COGS (66,120) (25,431) (41,472) (39,124) (39,124) (39,124) (39,226) (39,101) (39,124) (39,124) (49,297) (49,492) (59,746) (28,622) (46,676) (44,034) (44,034) (44,034) (44,148) (44,008) (44,034) (44,034) (55,483) (55,703) (74,517) (35,011) (57,096) (53,864) (53,864) (53,864) (54,004) (53,831) (53,864) (53,864) (67,868) (68,138) (85,001) (40,461) (65,983) (62,248) (62,248) (62,248) (62,410) (62,211) (62,248) (62,248) (78,433) (78,744) (85,737) (41,954) (68,417) (64,544) (64,544) (64,544) (64,712) (64,506) (64,544) (64,544) (81,326) (81,648)
Variable Expenses (31,427) (19,339) (24,174) (24,174) (24,174) (24,174) (24,223) (24,174) (24,174) (24,174) (29,009) (30,218) (35,370) (21,766) (27,208) (27,208) (27,208) (27,208) (27,262) (27,208) (27,208) (27,208) (32,650) (34,010) (43,266) (26,625) (33,282) (33,282) (33,282) (33,282) (33,348) (33,282) (33,282) (33,282) (39,938) (41,602) (50,001) (30,770) (38,462) (38,462) (38,462) (38,462) (38,539) (38,462) (38,462) (38,462) (46,155) (48,078) (51,845) (31,905) (39,881) (39,881) (39,881) (39,881) (39,961) (39,881) (39,881) (39,881) (47,857) (49,851)
Fixed Expenses (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550) (7,550)
Salary and Wages (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (48,153) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (49,158) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (50,199) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (51,278) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397) (52,397)
Operating Expenditure (153,249) (100,473) (121,349) (119,001) (119,001) (119,001) (119,151) (118,978) (119,001) (119,001) (134,008) (135,413) (151,824) (107,096) (130,592) (127,950) (127,950) (127,950) (128,119) (127,923) (127,950) (127,950) (144,840) (146,421) (175,532) (119,386) (148,126) (144,894) (144,894) (144,894) (145,101) (144,862) (144,894) (144,894) (165,555) (167,489) (193,830) (130,059) (163,274) (159,539) (159,539) (159,539) (159,778) (159,501) (159,539) (159,539) (183,416) (185,650) (197,529) (133,806) (168,245) (164,372) (164,372) (164,372) (164,620) (164,334) (164,372) (164,372) (189,130) (191,447)
Cash Payments (153,249) (100,473) (121,349) (119,001) (119,001) (119,001) (119,151) (118,978) (119,001) (119,001) (134,008) (135,413) (151,824) (107,096) (130,592) (127,950) (127,950) (127,950) (128,119) (127,923) (127,950) (127,950) (144,840) (146,421) (175,532) (119,386) (148,126) (144,894) (144,894) (144,894) (145,101) (144,862) (144,894) (144,894) (165,555) (167,489) (193,830) (130,059) (163,274) (159,539) (159,539) (159,539) (159,778) (159,501) (159,539) (159,539) (183,416) (185,650) (197,529) (133,806) (168,245) (164,372) (164,372) (164,372) (164,620) (164,334) (164,372) (164,372) (189,130) (191,447)
Interest Paid - (4,667) (4,537) (4,407) (4,861) (4,715) (4,569) (4,424) (4,278) (4,132) (3,986) (3,840) (3,694) (3,549) (3,403) (3,257) (3,111) (2,965) (2,819) (2,674) (2,528) (2,382) (2,236) (2,090) (1,944) (1,799) (1,653) (1,507) (1,361) (1,215) (1,069) (924) (778) (632) (486) (340) (194) (49) (32) (16) - - - - - - - - - - - - - - - - - - - -
Corporate Tax Paid - - - - - - - - - - - - - - - - - - - - - - - (8,443) - - - - - - - - - - - (29,456) - - - - - - - - - - - (46,734) - - - - - - - - - - - (50,255)
CASH INFLOW 165,403 101,787 127,233 127,233 127,233 127,233 127,488 127,233 127,233 127,233 152,680 159,042 186,160 114,560 143,200 143,200 143,200 143,200 143,486 143,200 143,200 143,200 171,840 179,000 227,717 140,133 175,167 175,167 175,167 175,167 175,517 175,167 175,167 175,167 210,200 218,958 263,163 161,947 202,433 202,433 202,433 202,433 202,838 202,433 202,433 202,433 242,920 253,042 272,870 167,920 209,900 209,900 209,900 209,900 210,320 209,900 209,900 209,900 251,880 262,375
CASH OUTFLOW (153,249) (105,139) (125,886) (123,408) (123,862) (123,716) (123,721) (123,401) (123,279) (123,133) (137,994) (139,253) (155,518) (110,645) (133,994) (131,207) (131,061) (130,915) (130,938) (130,597) (130,477) (130,332) (147,076) (156,954) (177,477) (121,184) (149,779) (146,401) (146,256) (146,110) (146,170) (145,786) (145,672) (145,526) (166,041) (197,285) (194,024) (130,108) (163,306) (159,555) (159,539) (159,539) (159,778) (159,501) (159,539) (159,539) (183,416) (232,385) (197,529) (133,806) (168,245) (164,372) (164,372) (164,372) (164,620) (164,334) (164,372) (164,372) (189,130) (241,702)
Net Cash Flow from Operating Activities 12,154 (3,353) 1,348 3,825 3,371 3,517 3,767 3,832 3,954 4,100 14,686 19,789 30,642 3,915 9,206 11,993 12,139 12,285 12,548 12,603 12,723 12,868 24,764 22,046 50,240 18,949 25,388 28,765 28,911 29,057 29,347 29,381 29,494 29,640 44,159 21,673 69,139 31,839 39,127 42,878 42,895 42,895 43,061 42,932 42,895 42,895 59,504 20,657 75,341 34,114 41,655 45,528 45,528 45,528 45,700 45,566 45,528 45,528 62,750 20,673
Cash Flow from Investing Activities
Capital Expenditure Paid (20,000) (1,000) (2,000) (500,000) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Fixed Assets Capital Expenditure (20,000) (1,000) (2,000) (500,000) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Net Cash Flow from Investing Activities (20,000) (1,000) (2,000) (500,000) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Cash Flow from Financing Activities
Grant - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Debt 800,000 - - 100,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Debt Drawdowns 800,000 - - 100,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Debt Repayments - (22,222) (22,222) (22,222) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (2,778) (2,778) (2,778) - - - - - - - - - - - - - - - - - - - -
Debt Repayments - (22,222) (22,222) (22,222) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (2,778) (2,778) (2,778) - - - - - - - - - - - - - - - - - - - -
Ordinary Equity Raisings 100,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ordinary Equity Buybacks - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ordinary Equity Dividends Paid - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Other Financing Cash Flows Category 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Other Financing Cash Flows Category 2 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Other Financing Cash Flows - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Net Cash Flow from Financing Activities 900,000 (22,222) (22,222) 77,778 (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (2,778) (2,778) (2,778) - - - - - - - - - - - - - - - - - - - -
Net Increase/(Decrease) in Cash Held 892,154 (26,575) (22,874) (418,397) (21,629) (21,483) (21,233) (21,168) (21,046) (20,900) (10,314) (5,211) 5,642 (21,085) (15,794) (13,007) (12,861) (12,715) (12,452) (12,397) (12,277) (12,132) (236) (2,954) 25,240 (6,051) 388 3,765 3,911 4,057 4,347 4,381 4,494 4,640 19,159 (3,327) 44,139 29,061 36,349 40,101 42,895 42,895 43,061 42,932 42,895 42,895 59,504 20,657 75,341 34,114 41,655 45,528 45,528 45,528 45,700 45,566 45,528 45,528 62,750 20,673
Interest on Cash Breakdown
Net Cash Flow from Investing Activities (20,000) (1,000) (2,000) (500,000) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Net Cash Flow from Financing Activities 900,000 (22,222) (22,222) 77,778 (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (2,778) (2,778) (2,778) - - - - - - - - - - - - - - - - - - - -
Cash Receipts 165,403 101,787 127,233 127,233 127,233 127,233 127,488 127,233 127,233 127,233 152,680 159,042 186,160 114,560 143,200 143,200 143,200 143,200 143,486 143,200 143,200 143,200 171,840 179,000 227,717 140,133 175,167 175,167 175,167 175,167 175,517 175,167 175,167 175,167 210,200 218,958 263,163 161,947 202,433 202,433 202,433 202,433 202,838 202,433 202,433 202,433 242,920 253,042 272,870 167,920 209,900 209,900 209,900 209,900 210,320 209,900 209,900 209,900 251,880 262,375
Cash Payments (153,249) (100,473) (121,349) (119,001) (119,001) (119,001) (119,151) (118,978) (119,001) (119,001) (134,008) (135,413) (151,824) (107,096) (130,592) (127,950) (127,950) (127,950) (128,119) (127,923) (127,950) (127,950) (144,840) (146,421) (175,532) (119,386) (148,126) (144,894) (144,894) (144,894) (145,101) (144,862) (144,894) (144,894) (165,555) (167,489) (193,830) (130,059) (163,274) (159,539) (159,539) (159,539) (159,778) (159,501) (159,539) (159,539) (183,416) (185,650) (197,529) (133,806) (168,245) (164,372) (164,372) (164,372) (164,620) (164,334) (164,372) (164,372) (189,130) (191,447)
Change in Cash (Pre-Corporate Tax & Interest on Cash) 892,154 (21,908) (18,337) (413,990) (16,768) (16,768) (16,663) (16,744) (16,768) (16,768) (6,328) (1,371) 9,336 (17,536) (12,392) (9,750) (9,750) (9,750) (9,632) (9,723) (9,750) (9,750) 2,000 7,579 27,185 (4,252) 2,040 5,272 5,272 5,272 5,416 5,305 5,272 5,272 19,645 26,470 44,333 29,109 36,382 40,117 42,895 42,895 43,061 42,932 42,895 42,895 59,504 67,391 75,341 34,114 41,655 45,528 45,528 45,528 45,700 45,566 45,528 45,528 62,750 70,928
Interest Paid - (4,667) (4,537) (4,407) (4,861) (4,715) (4,569) (4,424) (4,278) (4,132) (3,986) (3,840) (3,694) (3,549) (3,403) (3,257) (3,111) (2,965) (2,819) (2,674) (2,528) (2,382) (2,236) (2,090) (1,944) (1,799) (1,653) (1,507) (1,361) (1,215) (1,069) (924) (778) (632) (486) (340) (194) (49) (32) (16) - - - - - - - - - - - - - - - - - - - -
Corporate Tax Paid - - - - - - - - - - - - - - - - - - - - - - - (8,443) - - - - - - - - - - - (29,456) - - - - - - - - - - - (46,734) - - - - - - - - - - - (50,255)
Net Increase/(Decrease) in Cash Held 892,154 (26,575) (22,874) (418,397) (21,629) (21,483) (21,233) (21,168) (21,046) (20,900) (10,314) (5,211) 5,642 (21,085) (15,794) (13,007) (12,861) (12,715) (12,452) (12,397) (12,277) (12,132) (236) (2,954) 25,240 (6,051) 388 3,765 3,911 4,057 4,347 4,381 4,494 4,640 19,159 (3,327) 44,139 29,061 36,349 40,101 42,895 42,895 43,061 42,932 42,895 42,895 59,504 20,657 75,341 34,114 41,655 45,528 45,528 45,528 45,700 45,566 45,528 45,528 62,750 20,673
Cash Flow to Capital Providers
Net Cash Flow from Operating Activities 12,154 (3,353) 1,348 3,825 3,371 3,517 3,767 3,832 3,954 4,100 14,686 19,789 30,642 3,915 9,206 11,993 12,139 12,285 12,548 12,603 12,723 12,868 24,764 22,046 50,240 18,949 25,388 28,765 28,911 29,057 29,347 29,381 29,494 29,640 44,159 21,673 69,139 31,839 39,127 42,878 42,895 42,895 43,061 42,932 42,895 42,895 59,504 20,657 75,341 34,114 41,655 45,528 45,528 45,528 45,700 45,566 45,528 45,528 62,750 20,673
Net Cash Flow from Investing Activities (20,000) (1,000) (2,000) (500,000) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Cash Flow Available To Capital Providers (CFACP) (7,846) (4,353) (652) (496,175) 3,371 3,517 3,767 3,832 3,954 4,100 14,686 19,789 30,642 3,915 9,206 11,993 12,139 12,285 12,548 12,603 12,723 12,868 24,764 22,046 50,240 18,949 25,388 28,765 28,911 29,057 29,347 29,381 29,494 29,640 44,159 21,673 69,139 31,839 39,127 42,878 42,895 42,895 43,061 42,932 42,895 42,895 59,504 20,657 75,341 34,114 41,655 45,528 45,528 45,528 45,700 45,566 45,528 45,528 62,750 20,673
Debt Drawdowns 800,000 - - 100,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Debt Repayments - (22,222) (22,222) (22,222) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (2,778) (2,778) (2,778) - - - - - - - - - - - - - - - - - - - -
Other Financing Cash Flows - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Cash Flow Available to Equity (CFAE) 792,154 (26,575) (22,874) (418,397) (21,629) (21,483) (21,233) (21,168) (21,046) (20,900) (10,314) (5,211) 5,642 (21,085) (15,794) (13,007) (12,861) (12,715) (12,452) (12,397) (12,277) (12,132) (236) (2,954) 25,240 (6,051) 388 3,765 3,911 4,057 4,347 4,381 4,494 4,640 19,159 (3,327) 44,139 29,061 36,349 40,101 42,895 42,895 43,061 42,932 42,895 42,895 59,504 20,657 75,341 34,114 41,655 45,528 45,528 45,528 45,700 45,566 45,528 45,528 62,750 20,673
Ordinary Equity Raisings 100,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ordinary Equity Buybacks - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Cash Flow Available for Dividends (CFAD) 892,154 (26,575) (22,874) (418,397) (21,629) (21,483) (21,233) (21,168) (21,046) (20,900) (10,314) (5,211) 5,642 (21,085) (15,794) (13,007) (12,861) (12,715) (12,452) (12,397) (12,277) (12,132) (236) (2,954) 25,240 (6,051) 388 3,765 3,911 4,057 4,347 4,381 4,494 4,640 19,159 (3,327) 44,139 29,061 36,349 40,101 42,895 42,895 43,061 42,932 42,895 42,895 59,504 20,657 75,341 34,114 41,655 45,528 45,528 45,528 45,700 45,566 45,528 45,528 62,750 20,673
Ordinary Equity Dividends Paid - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Net Increase/(Decrease) in Cash Held 892,154 (26,575) (22,874) (418,397) (21,629) (21,483) (21,233) (21,168) (21,046) (20,900) (10,314) (5,211) 5,642 (21,085) (15,794) (13,007) (12,861) (12,715) (12,452) (12,397) (12,277) (12,132) (236) (2,954) 25,240 (6,051) 388 3,765 3,911 4,057 4,347 4,381 4,494 4,640 19,159 (3,327) 44,139 29,061 36,349 40,101 42,895 42,895 43,061 42,932 42,895 42,895 59,504 20,657 75,341 34,114 41,655 45,528 45,528 45,528 45,700 45,566 45,528 45,528 62,750 20,673
Error Values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Cash Flow Statement, $ - Reconciliation - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Interest on Cash Breakdown - Reconciliation - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Cash Flow to Capital Providers - Reconciliation - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Total Error Checks Result - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
&12Built with finmodelslab.com template &12Cash Flow Statement &D
CF_Indirect
Cash Flow Statement (indirect method)
Go to the Table of Contents
é ç è x h O
Fiscal year 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024
Month Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24
Period Start Date 01/01/2020 01/02/2020 01/03/2020 01/04/2020 01/05/2020 01/06/2020 01/07/2020 01/08/2020 01/09/2020 01/10/2020 01/11/2020 01/12/2020 01/01/2021 01/02/2021 01/03/2021 01/04/2021 01/05/2021 01/06/2021 01/07/2021 01/08/2021 01/09/2021 01/10/2021 01/11/2021 01/12/2021 01/01/2022 01/02/2022 01/03/2022 01/04/2022 01/05/2022 01/06/2022 01/07/2022 01/08/2022 01/09/2022 01/10/2022 01/11/2022 01/12/2022 01/01/2023 01/02/2023 01/03/2023 01/04/2023 01/05/2023 01/06/2023 01/07/2023 01/08/2023 01/09/2023 01/10/2023 01/11/2023 01/12/2023 01/01/2024 01/02/2024 01/03/2024 01/04/2024 01/05/2024 01/06/2024 01/07/2024 01/08/2024 01/09/2024 01/10/2024 01/11/2024 01/12/2024
Period End Date Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24
Counter 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 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
Current Year 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024 2024
Cash Flow Statement, $
Operating Activities
Net Income 18,197 (18,437) (5,520) (5,390) (5,844) (5,698) (5,425) (5,407) (5,261) (5,115) 7,818 11,160 22,350 (11,322) 2,932 3,065 3,198 3,331 3,595 3,597 3,730 3,863 17,119 20,532 41,492 2,014 17,989 18,120 18,251 18,383 18,672 18,645 18,776 18,908 34,883 38,975 58,151 12,507 30,832 30,847 30,861 30,861 31,044 30,861 30,861 30,861 49,171 53,749 61,803 14,339 33,325 33,325 33,325 33,325 33,515 33,325 33,325 33,325 52,310 57,057
Changes in Working Capital 487,742 4,869 (4,347) (500,000) - - (23) 23 - - (2,347) (587) (340) 6,605 (2,358) 296 309 322 321 374 361 374 (987) (7,118) 116 8,303 (1,233) 2,013 2,028 2,043 2,042 2,104 2,086 2,101 644 (25,934) 2,383 10,727 (309) 3,427 3,429 3,429 3,412 3,466 3,429 3,429 1,729 (41,696) 5,038 11,275 (170) 3,703 3,703 3,703 3,685 3,741 3,703 3,703 1,940 (44,884)
Total Operating Activities 505,939 (13,568) (9,868) (505,390) (5,844) (5,698) (5,448) (5,383) (5,261) (5,115) 5,470 10,574 22,010 (4,717) 574 3,361 3,507 3,653 3,916 3,971 4,091 4,236 16,132 13,414 41,608 10,317 16,756 20,133 20,279 20,425 20,715 20,749 20,863 21,008 35,527 13,041 60,535 23,234 30,523 34,274 34,290 34,290 34,456 34,328 34,290 34,290 50,900 12,053 66,841 25,614 33,155 37,028 37,028 37,028 37,200 37,066 37,028 37,028 54,250 12,173
Investing Activities
Fixed Assets (513,785) 9,215 9,215 9,215 9,215 9,215 9,215 9,215 9,215 9,215 9,215 9,215 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,632 8,604 8,604 8,604 8,604 8,604 8,604 8,604 8,604 8,604 8,604 8,604 8,604 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500
Total Cash From (For) Investing...