I need make Projected Statement Of Financial Position low(one document) and high (other document)Years 2018,2019,2020

Projected Cash Budget (HIGH) BACKYARD PUB April 30, 2020 May June July August September October November December January $ 5,100.00 $ 38,250.00 $38,250.00 $ 38,250.00 $38,250.00 $ 5,100.00 $ $ February $ March April Total $ 5,100.00 $ 5,100.00 $ 173,400.00 $ $ $ $ 950.00 $ 7,125.00 $ 7,125.00 $ 7,125.00 $ 7,125.00 $ $ 7,125.00 $ 950.00 $ 2,600.00 19,500.00 19,500.00 19,500.00 19,500.00 2,600.00 1,400.00 10,500.00 10,500.00 10,500.00 10,500.00 1,400.00 150.00 1,125.00 1.125.00 1,125.00 1,125.00 150.00 10,711,00 36,000.00 $ 51,811.00 $ 38,250.00 $ 38,250.00 $ 38,250.00 $38,250.00 $5,100.00 $ $ 950.00 $ 950.00 $ 32,300.00 2,600.00 2,600.00 $ 88,400.00 1,400.00 1,400.00 $ 47,600.00 150.00 150.00 $ 5,100.00 $ 10,711.00 $ 36,000.00 $ 5,100.00 $ 5,100.00 $ 220, 111.00 $ $ - 67.58 $ 1,013.63 $ 1,013.63 $ 1,013.63 $ 1,013.63 $ 135.15 $ $ - $ - $ $ 135.15 $ 135.15 $ 4,527.53 554.85 73.98 - 73.98 400.00 33.58 554.85 400.00 251.86 554.85 400.00 251.86 554.85 400.00 251.86 400.00 251.86 Sales Inflovs: Package 1 Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflows Outfolovs: E-commerce fee Add-on materials COGS ($36.99 per unit) Advertising Fuel Manager Salary Loan Repayments Interest Payments Truck insurance Business insurance Bank Fees Rent Website Investments: NUANS Legal fees Fixed Assets Purchase Inventory Total outfloys Net Cash Floy Beginning Cash Ending Cash - 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 33.58 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 73.98 $ 400.00 $ 33.58 $ 500.00 $ 103.00 $ 150.00 $ 200.00 $ 10.00 $ 240.00 $ $ 500.00 105.00 150.00 200.00 10.00 240.00 2,441.34 2,400.00 1,108.17 10.000.00 5,500.00 1,228.00 1,800.00 2,400.00 120.00 2,880.00 250.00 40.00 $ 40.00 2,500.00 $ 2,500.00 46,526.05 $ 46,526.05 184.95 $ 184.95 $ 48,176.14 $ 5,940.33 $ 3,438.33 $ 3,437.33 $ 3,035.33 $ 11,455.71 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1,740.15 $ 1,845.71 $ 83,906.03 $3,634.86 $ 32,309.67 $ 34,811.67 $ 34,812.67 $35,214.67 $(6,355.71) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $3,359.85 $3,254.29 $ 136,204.97 - 3,634.86 35,944.53 70.756.20 105,568.87 140,783.54 134,427.83 133,215.83 132,005.83 130,797.83 129,590.83 132,950.68 3,634.86 35,944.53 70,756.20 105,568.87 140,783.54 134,427.83 133,215.83 132,005.83 130,797.83 129,590.83 132,950.68 136,204.97 A A B E J M N 0 F G H Projected Cash Budget (LOW) BACKYARD PUB April 30, 2020 August September October November 22,950.00 $ 22,950.00 $ 5,100.00 $ May 5,100.00 $ June 22,950.00 $ December $ July 22,950.00 $ January $ $ February $ March 5,100.00 $ $ April 5,100.00 $ Sales Inflows: Total 112,200.00 $ $ $ $ Package 1 $ Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflows $ 950.00 $ 2,600.00 1,400.00 150.00 10,711,00 36,000.00 51,811.00 $ 4,275.00 $ 11,700.00 6,300.00 675.00 4,275.00 $ 11,700.00 6,300.00 675.00 4,275.00 $ 11,700.00 6,300.00 675.00 4,275.00 $ 11,700.00 6,300.00 675.00 950.00 $ 2,600,00 1,400.00 150.00 950.00 $ 2,600.00 1,400.00 150.00 950.00 $ 2,600.00 $ 1,400.00 $ 150.00 $ $ $ 5,100.00 $ 20,900.00 57,200.00 30,800.00 3,300.00 10,711,00 36,000.00 158,911.00 22,950.00 $ 22,950.00 $ 22,950.00 $ 22,950.00 $ 5,100.00 $ - $ $ - 5,100.00 $ Outfoloys: 67.58 $ 608.18 $ 608.18 $ 608.18 $ 608,18 $ 135.15$ $ $ $ $ 135.15$ 135.15 $ 2.905.73 332.91 73.98 73.98 400.00 33.58 332.91 400.00 151.11 332.91 400.00 151.11 332.91 400.00 151.11 400.00 151.11 E-commerce fee $ Add-on materials COGS Advertising Fuel Manager Salary Loan Repaymen Interest Payment Truck insurance Business insurar Bank Fees Rent Website 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 33.58 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 73.98 $ 400.00 $ 33.58 $ $ 500.00 $ 103.00 $ 150.00 $ 200.00 $ 10.00 $ 240.00 $ $ $ 500.00 105.00 150.00 200.00 10.00 240.00 1,553.58 2,400.00 705.20 10,000.00 5,500.00 1,228.00 1,800.00 2,400.00 120.00 2,880.00 250.00 Investments: 40.00 $ $ $ 2,500.00 NUANS Legalfees Fixed Assets Pur Inventory Total outflows $ Net Cash Flor $ Beginning Ca: Ending Cash 46,526.05 184.95 48,176.14 $ 3,634.86 40.00 2,500.00 46,526.05 184.95 80,993.50 77,917.50 5,212.20 $ 17,737.80 $ 3,634.86 21,372.67 2,710.20 $ 20,239.80 21,372.67 41,612.47 2,709.20 $ 20.240.80 41,612.47 61,853.27 2,307.20 $ 20,642.80 $ 61,853.27 82.496.07 11,455.71 $ (6,355.71) $ 82,496.07 76,140.36 1,212.00 $ (1.212.00) 76,140.36 74,928.36 1,210.00 $ (1,210.00) 74,928.36 73,718.36 1,208.00 $ (1,208.00) $ 73,718.36 72.510.36 1,207.00 $ (1,207.00) $ 72,510.36 71,303.36 $ $ 1,845.71 $ 3,254.29 $ 74,663.21 77.917.50 1,740.15 $ 3,359.85 $ 71,303.36 74,663.21 3,634.86 Projected Cash Budget (HIGH) BACKYARD PUB April 30, 2019 May June July August September October November December January $ 5,100.00 $25,500.00 $25,500.00 $25,500.00 $ 25,500.00 $ 5,100.00 $ February $ March April Total $ 5,100.00 $ 5,100.00 $ 122,400.00 - - - $ $ $ $ 950.00 $4,750.00 $4,750.00 $4,750.00 $4,750.00 $ $ 950.00 $ 2,600.00 13,000.00 13,000.00 13,000.00 13,000.00 2,600.00 1,400.00 7,000.00 7,000.00 7,000.00 7,000.00 1,400.00 150.00 750.00 750.00 750.00 750.00 150.00 10,711.00 36,000.00 $ 51,811.00 $25,500.00 $25,500.00 $25,500.00 $ 25,500.00 $ 5,100.00 $ - $ 950.00 $ 950.00 $ 22,800.00 2,600.00 2,600.00 $ 62,400.00 1,400.00 1,400.00 $ 33,600.00 150.00 150.00 $ 3,600,00 $ 10,711,00 $ 36,000.00 $ 5,100.00 $ 5,100.00 $ 169,111.00 $ - $ $ $ 67.58 ! $ 675.75 $ 675.75 $ 675.75 $ 675.75 $ 135.15 $ $ - $ $ - $ 135.15 $ 135.15 $ 3,176.03 369.9 73.98 73.98 400.00 33.58 369.9 400.00 167.90 369.9 400.00 167.90 369.9 400.00 167.90 400.00 167.90 Sales Inflovs: Package 1 Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflors Outfolovs: E-commerce fee Add-on materials COGS ($36.99 per unit) Advertising Fuel Manager Salary Loan Repayments Interest Payments Truok insurance Business Insurance Bank Fees Rent Website Investments: NUANS Legal fees Fixed Assets Purchase Inventory Total outflors Net Cash Floy Beginning Cash Ending Cash - 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 33.58 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 73.98 $ 1,701.54 400.00 $ 2,400.00 33.58 $ 772.36 $ 10,000.00 500.00 $ 5,500.00 103.00 $ 1,228.00 150.00 $ 1,800.00 200.00 $ 2,400.00 10.00 $ 120.00 240.00 $ 2,880.00 $ 250.00 500.00 105.00 150.00 200.00 10.00 240.00 40.00 $ 40.00 2,500.00 $ 2,500.00 46,526.05 $ 46,526.05 184.95 $ 184.95 $48,176.14 $ 5,333.55 $ 2,831.55 $ 2,830.55 $ 2,428.55 $ 11,455.71 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1,740.15 $ 1,845.71 $ 81,478.92 $ 3,634.86 $ 20,166.45 $ 22,668.45 $ 22,669.45 $ 23,071.45 $ (6,355.71) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $3,359.85 $3,254.29 $ 87,632.08 3,634.86 23,801.31 46,469.76 69,139.20 92,210.65 85,854.94 84,642.94 83,432.94 82,224.94 81,017.94 84,377.79 3,634.86 23,801.31 46.469.76 69,139,20 92,210.65 85,854.94 84,642.94 83,432.94 82,224.94 81,017.94 84,377.79 87,632.08 Projected Cash Budget (HIGH) BACKYARD PUB April 30, 2018 May June July August September October November December $ 2,550.00 $11,200.00 $11,200.00 $11,200.00 $11,200.00 $ 2,550.00 $ January February January $ February $ March April Total $ 2,550.00 $ 52,450.00 $ $ - $ $ $ - - $ 475.00 $2,375.00 $2,375.00 $2,375.00 $2,375.00 $ 475.00 $ 1,300.00 6,500.00 6,500.00 6,500.00 6,500.00 1,300.00 700.00 2,100.00 2,100.00 2,100.00 2,100.00 700.00 75.00 225.00 225.00 225.00 225.00 75.00 10,711.00 36,000.00 $49,261.00 $11,200.00 $ 11,200.00 $ 11,200.00 $ 11,200.00 $ 2,550.00 $ - - $ 475.00 $ 10,925.00 1,300.00 $ 29,900.00 700.00 $ 10,500.00 75.00 $ 1,125.00 $10,711.00 $36,000.00 $ 2,550.00 $ 99,161.00 $ - $ $ - $ - $ 67.58 $ 296.80 $ 296.80 $ 296.80 $ 296.80 $ 67.58 $ $ $ $ - $ - $ 67.58 $ 1,389.93 184.95 36.99 36.99 400.00 16.79 184.95 400.00 83.95 184.95 400.00 83.95 184.95 400.00 83.95 400.00 83.95 Sales Inflors: Package 1 Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflovs Outfolovs: E-commerce fee Add-on materials COGS ($36.99 per unit) Advertising Fuel Manager Salary Loan Repayments Interest Payments Truck insurance Business insurance Bank Fees Rent Website Investments: NUANS Legal fees Fixed Assets Purchase Inventory Total outflors Net Cash Floy Beginning Cash Ending Cash 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 16.79 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 36.99 $ 850.77 400.00 $ 2,400.00 16.79 $ 386.18 $ 10,000.00 500.00 $ 5,500.00 103.00 $ 1,228,00 150.00 $ 1,800.00 200.00 $ 2,400.00 10.00 $ 120.00 240.00 $ 2,880.00 250.00 500.00 105.00 150.00 200.00 10.00 240.00 40.00 $ 40.00 2,500.00 $ 2,500.00 46,526.05 $ 46,526.05 184.95 $ $ 184.95 $48,122.36 $ 4,685.70 $ 2.183.70 $ 2,182.70 $ 1,780.70 $ 11,334.36 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1.605.00 $ 1,724.36 $ 78,455.87 $ 1.138.64 $ 6,514.30 $ 9,016.30 $ 9,017.30 $ 9,419.30 $(8,784.36) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $ (1,605.00) $ 825.64 $ 20,705.13 1,138.64 7,652.94 16,669.24 25,686.54 35,105.84 26,321.48 25,109.48 23,899.48 22,691.48 21,484.48 19,879.48 1,138.64 7,652.94 16,669.24 25,686.54 35,105.84 26,321.48 25,109.48 23,899.48 22,691,48 21,484.48 19,879.48 20,705.13 Projected Cash Budget (HIGH) BACKYARD PUB April 30, 2018 May June July August September October November December $ 2,550.00 $11,200.00 $11,200.00 $11,200.00 $11,200.00 $ 2,550.00 $ January February January $ February $ March April Total $ 2,550.00 $ 52,450.00 $ $ - $ $ $ - - $ 475.00 $2,375.00 $2,375.00 $2,375.00 $2,375.00 $ 475.00 $ 1,300.00 6,500.00 6,500.00 6,500.00 6,500.00 1,300.00 700.00 2,100.00 2,100.00 2,100.00 2,100.00 700.00 75.00 225.00 225.00 225.00 225.00 75.00 10,711.00 36,000.00 $49,261.00 $11,200.00 $ 11,200.00 $ 11,200.00 $ 11,200.00 $ 2,550.00 $ - - $ 475.00 $ 10,925.00 1,300.00 $ 29,900.00 700.00 $ 10,500.00 75.00 $ 1,125.00 $10,711.00 $36,000.00 $ 2,550.00 $ 99,161.00 $ - $ $ - $ - $ 67.58 $ 296.80 $ 296.80 $ 296.80 $ 296.80 $ 67.58 $ $ $ $ - $ - $ 67.58 $ 1,389.93 184.95 36.99 36.99 400.00 16.79 184.95 400.00 83.95 184.95 400.00 83.95 184.95 400.00 83.95 400.00 83.95 Sales Inflors: Package 1 Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflovs Outfolovs: E-commerce fee Add-on materials COGS ($36.99 per unit) Advertising Fuel Manager Salary Loan Repayments Interest Payments Truck insurance Business insurance Bank Fees Rent Website Investments: NUANS Legal fees Fixed Assets Purchase Inventory Total outflors Net Cash Floy Beginning Cash Ending Cash 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 16.79 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 36.99 $ 850.77 400.00 $ 2,400.00 16.79 $ 386.18 $ 10,000.00 500.00 $ 5,500.00 103.00 $ 1,228,00 150.00 $ 1,800.00 200.00 $ 2,400.00 10.00 $ 120.00 240.00 $ 2,880.00 250.00 500.00 105.00 150.00 200.00 10.00 240.00 40.00 $ 40.00 2,500.00 $ 2,500.00 46,526.05 $ 46,526.05 184.95 $ $ 184.95 $48,122.36 $ 4,685.70 $ 2.183.70 $ 2,182.70 $ 1,780.70 $ 11,334.36 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1.605.00 $ 1,724.36 $ 78,455.87 $ 1.138.64 $ 6,514.30 $ 9,016.30 $ 9,017.30 $ 9,419.30 $(8,784.36) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $ (1,605.00) $ 825.64 $ 20,705.13 1,138.64 7,652.94 16,669.24 25,686.54 35,105.84 26,321.48 25,109.48 23,899.48 22,691.48 21,484.48 19,879.48 1,138.64 7,652.94 16,669.24 25,686.54 35,105.84 26,321.48 25,109.48 23,899.48 22,691,48 21,484.48 19,879.48 20,705.13 - 1 Projected Cash Budget (LOW) BACKYARD PUB April 30, 2018 May June July August September October November December January February March April Total Sales $ 2,550.00 $7,650.00 $7,650.00 $7,650.00 $7,650.00 $ 2,550.00 $ $ $ $ $ $ $2,550.00 $38,250.00 Inflovs: Package 1 $ 475.00 $1,425.00 $1,425.00 $1,425.00 $1,425.00 $ 475.00 $ $ $ $ $ $ 475.00 $ 7,125.00 Package 2 1,300.00 3,900.00 3,900.00 3,900.00 3,900.00 1,300.00 1,300.00 $ 19,500.00 Package 3 700.00 2,100.00 2,100.00 2,100.00 2,100.00 700.00 - 700.00 $ 10,500.00 Add on Package 75.00 225.00 225.00 225.00 225.00 75.00 75.00 $ 1,125.00 Equity infusion 10,711.00 $ 10,711.00 Bank Loans 36,000.00 $36,000.00 Total inflovs $49,261.00 $7,650.00 $7,650.00 $7,650.00 $7,650.00 $ 2,550.00 $ - $ $ $ $2,550.00 $ 84,961.00 Outfolovs: E-commerce fee $ 67.58 $ 202.73 $ 202.73 $ 202.73 $ 202.73 $ 67.58 $ $ - $ - $ - $ - $ 67.58 $ 1,013.63 Add-on materials 36.99 110.97 110.97 110.97 36.99 - - 110.97 - 36.99 $ 554.85 Advertising 400.00 400.00 400.00 400.00 400.00 400.00 $ 2,400.00 Fuel 16.79 50.37 50.37 50.37 50.37 16.79 - - 16.79 $ 251.86 Manager Salary 10.000.00 $ 10,000.00 Loan Repayments 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 $ 5,500.00 Interest Payments 120.00 118.00 117.00 115.00 113.00 112.00 110.00 108.00 107.00 105.00 103.00 $ 1,228.00 Truok insurance 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 $ 1,800.00 Business insurance 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 $ 2,400.00 Bank Fees 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 $ 120.00 Rent 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 $ 2,880.00 Website 250.00 $ 250.00 Investments: NUANS 40.00 $ 40.00 Legal fees 2,500.00 $ 2,500.00 Fixed Assets Purchasi 46,526.05 $ 46,526.05 Inventory 184.95 $ 184.95 Total outflovs $48,122.36 $4,484.07 $ 1,982.07 $ 1,981.07 $1,579.07 $ 11,334.36 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1,605.00 $1,724.36 $77,649.33 Net Cash Floy $ 1,138.64 $ 3.165.93 $5,667.93 $5,668.93 $6,070.93 $ (8,784.36) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $ (1,605.00) $825.64 $ 7,311.67 Beginning Cash 1.138.64 4,304.58 9,972.51 15,641.45 21,712.38 12,928.02 11,716.02 10,506.02 9,298.02 8,091.02 6,486.02 Ending Cash 1.138.64 4,304.58 9.972.51 15,641.45 21.712.38 12.928.02 11,716.02 10,506.02 9,298.02 8,091,02 6,486.02 7 31167 BACKYARD PUB July August September October November December Januar February March May June April Total 1 2 1 1 3 6 3 3 3 6 3 3 3 6 3 3 3 6 3 3 1 2 1 1 0 0 0 0 OOOO 0 0 0 0 1 2 1 1 15 30 15 15 1 2 1 1 5 10 5 5 5 10 5 5 5 10 5 5 5 10 5 5 1 2 1 1 OOOO 0 0 0 0 0 0 0 0 0 0 0 0 Oood 1 2 1 1 23 46 23 23 4 2 2 6 12 6 6 6 12 6 6 6 12 6 6 6 12 6 6 2 4 2 2 0 0 0 0 0 0 0 0 OOOO 0 0 0 0 2 4 2 2 2 4 2 2 32 64 32 32 Year 2018 Low: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2018 High: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2019 Low: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2019 High: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2020 Low: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2020 High: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience 2 4 2 2 10 20 10 10 10 20 10 10 10 20 10 10 10 20 10 10 2 4 2 2 OOOO OOOO 0 0 0 0 0 0 0 0 2 4 2 2 2 4 2 2 48 96 48 48 2 4 88 2 4 2 2 9 18 9 9 9 18 9 9 9 18 9 9 9 18 9 9 2 4 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 4 2 2 2 2 2 15 30 2 4 2 2 15 30 15 15 30 15 15 15 30 15 15 2 4 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 4 2 2 68 136 68 68 2 2 Projected Statement of Earnings (HIGH) BACKYARD PUB 2018 2019 2020 Revenue: Package 1 10,925.00 $ 22,800.00 $ 32,300.00 Package 2 29,900.00 62,400.00 88,400.00 Package 3 16,100.00 33,600.00 47,600.00 Add-on 1,725.00 3,600.00 5,100.00 Total Revenue $ 58,650.00 $ 122.400.00 $ 173.400.00 Variable Costs: E-commerce 1,554.23 3,243.60 4,595.10 Add-on materials 850.77 1,775.52 2,515.32 Total variable cost 2.405.00 $ 5.019.12 $ 7.110.12 Contribution margin $ 56,245.01 $ 117,380.88 $ 166,289.58 Fixed costs: Website 250.00 $ 250.00 $ 250.00 Rent 2.880.00 2,880.00 2,880.00 Incorporate BYP 2,500.00 NUANS 40.00 Business Insurance 2,400.00 2,400.00 2,400.00 Salary: Manager $ 10,000.00 $ 48,000.00 $ 48,000.00 Salary: Part-time 1,440.00 1,440.00 Fuel (truck) 386.18 805.94 1,141.75 Truck insurance 1,800.00 1.800.00 1,800.00 Truck Depreciation 2,958.33 2.750.00 2,750.00 Vehicle rent 960.00 960.00 Business Account F 120.00 120.00 120.00 Advertising 2,400.00 3,600.00 4,800.00 Depreciation 1,333.33 3,333.33 5,333.33 Depreciation other 402.60 1,006,50 1,610.40 Total Fixed Costs $ 27,470.45 $ 69.345.77 $ 73.185.18 EBIT $ 28,774.56 $ 48,035.11 $ 92,804.10 Interest & Tas: Truck interest 1.228.00 1,110.00 870.00 Tax rate 6,158.250 $ 12,852.000 Net Incomelloss $ 28.774.56 $ 41,876.86 $ 79.952.10 Projected Statement of Financial Positions (HIGH) BACKYARD PUB At December 2020 2018 2019 2020 ASSETS Current Asset: Cash Inventory add on package Fixed asset: Truck Accumulated Depreciation-Truck Inflatable Pub Accumulated Depreciation-Infatable Pub Inflatable Pub Accumulated Depreciation-Infatable Pub Other equipment Accumulated Depreciation-Equipment Total fix asset Total Assets $ $ $ Liabilities & Shareholder's Equity Current liabilities Current portion Tax payable Interest Payable Total current liabilities Long-terms liabilities Banck loan Retained earning from last year Add net income Retained earning Total liabilities and shareholder's equity $ 2020 Projected Statement of Financial Positions (LOW) BACKYARD PUB At December 2020 2018 2019 ASSETS Current Asset: Cash Inventory add on package Fixed asset: Truck Accumulated Depreciation-Truck Inflatable Pub Accumulated Depreciation-Infatable Pub Inflatable Pub Accumulated Depreciation-Infatable Pub Other equipment Accumulated Depreciation-Equipment Total fix asset Total Assets $ $ Liabilities & Shareholder's Equity Current liabilities Current portion Tax payable Interest Payable Total current liabilities Long-terms liabilities Banck loan Retained earning from last year Add net income Retained earning Total liabilities and shareholder's equity - $ Projected Cash Budget (HIGH) BACKYARD PUB April 30, 2020 May June July August September October November December January $ 5,100.00 $ 38,250.00 $38,250.00 $ 38,250.00 $38,250.00 $ 5,100.00 $ $ February $ March April Total $ 5,100.00 $ 5,100.00 $ 173,400.00 $ $ $ $ 950.00 $ 7,125.00 $ 7,125.00 $ 7,125.00 $ 7,125.00 $ $ 7,125.00 $ 950.00 $ 2,600.00 19,500.00 19,500.00 19,500.00 19,500.00 2,600.00 1,400.00 10,500.00 10,500.00 10,500.00 10,500.00 1,400.00 150.00 1,125.00 1.125.00 1,125.00 1,125.00 150.00 10,711,00 36,000.00 $ 51,811.00 $ 38,250.00 $ 38,250.00 $ 38,250.00 $38,250.00 $5,100.00 $ $ 950.00 $ 950.00 $ 32,300.00 2,600.00 2,600.00 $ 88,400.00 1,400.00 1,400.00 $ 47,600.00 150.00 150.00 $ 5,100.00 $ 10,711.00 $ 36,000.00 $ 5,100.00 $ 5,100.00 $ 220, 111.00 $ $ - 67.58 $ 1,013.63 $ 1,013.63 $ 1,013.63 $ 1,013.63 $ 135.15 $ $ - $ - $ $ 135.15 $ 135.15 $ 4,527.53 554.85 73.98 - 73.98 400.00 33.58 554.85 400.00 251.86 554.85 400.00 251.86 554.85 400.00 251.86 400.00 251.86 Sales Inflovs: Package 1 Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflows Outfolovs: E-commerce fee Add-on materials COGS ($36.99 per unit) Advertising Fuel Manager Salary Loan Repayments Interest Payments Truck insurance Business insurance Bank Fees Rent Website Investments: NUANS Legal fees Fixed Assets Purchase Inventory Total outfloys Net Cash Floy Beginning Cash Ending Cash - 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 33.58 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 73.98 $ 400.00 $ 33.58 $ 500.00 $ 103.00 $ 150.00 $ 200.00 $ 10.00 $ 240.00 $ $ 500.00 105.00 150.00 200.00 10.00 240.00 2,441.34 2,400.00 1,108.17 10.000.00 5,500.00 1,228.00 1,800.00 2,400.00 120.00 2,880.00 250.00 40.00 $ 40.00 2,500.00 $ 2,500.00 46,526.05 $ 46,526.05 184.95 $ 184.95 $ 48,176.14 $ 5,940.33 $ 3,438.33 $ 3,437.33 $ 3,035.33 $ 11,455.71 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1,740.15 $ 1,845.71 $ 83,906.03 $3,634.86 $ 32,309.67 $ 34,811.67 $ 34,812.67 $35,214.67 $(6,355.71) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $3,359.85 $3,254.29 $ 136,204.97 - 3,634.86 35,944.53 70.756.20 105,568.87 140,783.54 134,427.83 133,215.83 132,005.83 130,797.83 129,590.83 132,950.68 3,634.86 35,944.53 70,756.20 105,568.87 140,783.54 134,427.83 133,215.83 132,005.83 130,797.83 129,590.83 132,950.68 136,204.97 A A B E J M N 0 F G H Projected Cash Budget (LOW) BACKYARD PUB April 30, 2020 August September October November 22,950.00 $ 22,950.00 $ 5,100.00 $ May 5,100.00 $ June 22,950.00 $ December $ July 22,950.00 $ January $ $ February $ March 5,100.00 $ $ April 5,100.00 $ Sales Inflows: Total 112,200.00 $ $ $ $ Package 1 $ Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflows $ 950.00 $ 2,600.00 1,400.00 150.00 10,711,00 36,000.00 51,811.00 $ 4,275.00 $ 11,700.00 6,300.00 675.00 4,275.00 $ 11,700.00 6,300.00 675.00 4,275.00 $ 11,700.00 6,300.00 675.00 4,275.00 $ 11,700.00 6,300.00 675.00 950.00 $ 2,600,00 1,400.00 150.00 950.00 $ 2,600.00 1,400.00 150.00 950.00 $ 2,600.00 $ 1,400.00 $ 150.00 $ $ $ 5,100.00 $ 20,900.00 57,200.00 30,800.00 3,300.00 10,711,00 36,000.00 158,911.00 22,950.00 $ 22,950.00 $ 22,950.00 $ 22,950.00 $ 5,100.00 $ - $ $ - 5,100.00 $ Outfoloys: 67.58 $ 608.18 $ 608.18 $ 608.18 $ 608,18 $ 135.15$ $ $ $ $ 135.15$ 135.15 $ 2.905.73 332.91 73.98 73.98 400.00 33.58 332.91 400.00 151.11 332.91 400.00 151.11 332.91 400.00 151.11 400.00 151.11 E-commerce fee $ Add-on materials COGS Advertising Fuel Manager Salary Loan Repaymen Interest Payment Truck insurance Business insurar Bank Fees Rent Website 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 33.58 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 73.98 $ 400.00 $ 33.58 $ $ 500.00 $ 103.00 $ 150.00 $ 200.00 $ 10.00 $ 240.00 $ $ $ 500.00 105.00 150.00 200.00 10.00 240.00 1,553.58 2,400.00 705.20 10,000.00 5,500.00 1,228.00 1,800.00 2,400.00 120.00 2,880.00 250.00 Investments: 40.00 $ $ $ 2,500.00 NUANS Legalfees Fixed Assets Pur Inventory Total outflows $ Net Cash Flor $ Beginning Ca: Ending Cash 46,526.05 184.95 48,176.14 $ 3,634.86 40.00 2,500.00 46,526.05 184.95 80,993.50 77,917.50 5,212.20 $ 17,737.80 $ 3,634.86 21,372.67 2,710.20 $ 20,239.80 21,372.67 41,612.47 2,709.20 $ 20.240.80 41,612.47 61,853.27 2,307.20 $ 20,642.80 $ 61,853.27 82.496.07 11,455.71 $ (6,355.71) $ 82,496.07 76,140.36 1,212.00 $ (1.212.00) 76,140.36 74,928.36 1,210.00 $ (1,210.00) 74,928.36 73,718.36 1,208.00 $ (1,208.00) $ 73,718.36 72.510.36 1,207.00 $ (1,207.00) $ 72,510.36 71,303.36 $ $ 1,845.71 $ 3,254.29 $ 74,663.21 77.917.50 1,740.15 $ 3,359.85 $ 71,303.36 74,663.21 3,634.86 Projected Cash Budget (HIGH) BACKYARD PUB April 30, 2019 May June July August September October November December January $ 5,100.00 $25,500.00 $25,500.00 $25,500.00 $ 25,500.00 $ 5,100.00 $ February $ March April Total $ 5,100.00 $ 5,100.00 $ 122,400.00 - - - $ $ $ $ 950.00 $4,750.00 $4,750.00 $4,750.00 $4,750.00 $ $ 950.00 $ 2,600.00 13,000.00 13,000.00 13,000.00 13,000.00 2,600.00 1,400.00 7,000.00 7,000.00 7,000.00 7,000.00 1,400.00 150.00 750.00 750.00 750.00 750.00 150.00 10,711.00 36,000.00 $ 51,811.00 $25,500.00 $25,500.00 $25,500.00 $ 25,500.00 $ 5,100.00 $ - $ 950.00 $ 950.00 $ 22,800.00 2,600.00 2,600.00 $ 62,400.00 1,400.00 1,400.00 $ 33,600.00 150.00 150.00 $ 3,600,00 $ 10,711,00 $ 36,000.00 $ 5,100.00 $ 5,100.00 $ 169,111.00 $ - $ $ $ 67.58 ! $ 675.75 $ 675.75 $ 675.75 $ 675.75 $ 135.15 $ $ - $ $ - $ 135.15 $ 135.15 $ 3,176.03 369.9 73.98 73.98 400.00 33.58 369.9 400.00 167.90 369.9 400.00 167.90 369.9 400.00 167.90 400.00 167.90 Sales Inflovs: Package 1 Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflors Outfolovs: E-commerce fee Add-on materials COGS ($36.99 per unit) Advertising Fuel Manager Salary Loan Repayments Interest Payments Truok insurance Business Insurance Bank Fees Rent Website Investments: NUANS Legal fees Fixed Assets Purchase Inventory Total outflors Net Cash Floy Beginning Cash Ending Cash - 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 33.58 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 73.98 $ 1,701.54 400.00 $ 2,400.00 33.58 $ 772.36 $ 10,000.00 500.00 $ 5,500.00 103.00 $ 1,228.00 150.00 $ 1,800.00 200.00 $ 2,400.00 10.00 $ 120.00 240.00 $ 2,880.00 $ 250.00 500.00 105.00 150.00 200.00 10.00 240.00 40.00 $ 40.00 2,500.00 $ 2,500.00 46,526.05 $ 46,526.05 184.95 $ 184.95 $48,176.14 $ 5,333.55 $ 2,831.55 $ 2,830.55 $ 2,428.55 $ 11,455.71 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1,740.15 $ 1,845.71 $ 81,478.92 $ 3,634.86 $ 20,166.45 $ 22,668.45 $ 22,669.45 $ 23,071.45 $ (6,355.71) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $3,359.85 $3,254.29 $ 87,632.08 3,634.86 23,801.31 46,469.76 69,139.20 92,210.65 85,854.94 84,642.94 83,432.94 82,224.94 81,017.94 84,377.79 3,634.86 23,801.31 46.469.76 69,139,20 92,210.65 85,854.94 84,642.94 83,432.94 82,224.94 81,017.94 84,377.79 87,632.08 Projected Cash Budget (HIGH) BACKYARD PUB April 30, 2018 May June July August September October November December $ 2,550.00 $11,200.00 $11,200.00 $11,200.00 $11,200.00 $ 2,550.00 $ January February January $ February $ March April Total $ 2,550.00 $ 52,450.00 $ $ - $ $ $ - - $ 475.00 $2,375.00 $2,375.00 $2,375.00 $2,375.00 $ 475.00 $ 1,300.00 6,500.00 6,500.00 6,500.00 6,500.00 1,300.00 700.00 2,100.00 2,100.00 2,100.00 2,100.00 700.00 75.00 225.00 225.00 225.00 225.00 75.00 10,711.00 36,000.00 $49,261.00 $11,200.00 $ 11,200.00 $ 11,200.00 $ 11,200.00 $ 2,550.00 $ - - $ 475.00 $ 10,925.00 1,300.00 $ 29,900.00 700.00 $ 10,500.00 75.00 $ 1,125.00 $10,711.00 $36,000.00 $ 2,550.00 $ 99,161.00 $ - $ $ - $ - $ 67.58 $ 296.80 $ 296.80 $ 296.80 $ 296.80 $ 67.58 $ $ $ $ - $ - $ 67.58 $ 1,389.93 184.95 36.99 36.99 400.00 16.79 184.95 400.00 83.95 184.95 400.00 83.95 184.95 400.00 83.95 400.00 83.95 Sales Inflors: Package 1 Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflovs Outfolovs: E-commerce fee Add-on materials COGS ($36.99 per unit) Advertising Fuel Manager Salary Loan Repayments Interest Payments Truck insurance Business insurance Bank Fees Rent Website Investments: NUANS Legal fees Fixed Assets Purchase Inventory Total outflors Net Cash Floy Beginning Cash Ending Cash 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 16.79 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 36.99 $ 850.77 400.00 $ 2,400.00 16.79 $ 386.18 $ 10,000.00 500.00 $ 5,500.00 103.00 $ 1,228,00 150.00 $ 1,800.00 200.00 $ 2,400.00 10.00 $ 120.00 240.00 $ 2,880.00 250.00 500.00 105.00 150.00 200.00 10.00 240.00 40.00 $ 40.00 2,500.00 $ 2,500.00 46,526.05 $ 46,526.05 184.95 $ $ 184.95 $48,122.36 $ 4,685.70 $ 2.183.70 $ 2,182.70 $ 1,780.70 $ 11,334.36 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1.605.00 $ 1,724.36 $ 78,455.87 $ 1.138.64 $ 6,514.30 $ 9,016.30 $ 9,017.30 $ 9,419.30 $(8,784.36) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $ (1,605.00) $ 825.64 $ 20,705.13 1,138.64 7,652.94 16,669.24 25,686.54 35,105.84 26,321.48 25,109.48 23,899.48 22,691.48 21,484.48 19,879.48 1,138.64 7,652.94 16,669.24 25,686.54 35,105.84 26,321.48 25,109.48 23,899.48 22,691,48 21,484.48 19,879.48 20,705.13 Projected Cash Budget (HIGH) BACKYARD PUB April 30, 2018 May June July August September October November December $ 2,550.00 $11,200.00 $11,200.00 $11,200.00 $11,200.00 $ 2,550.00 $ January February January $ February $ March April Total $ 2,550.00 $ 52,450.00 $ $ - $ $ $ - - $ 475.00 $2,375.00 $2,375.00 $2,375.00 $2,375.00 $ 475.00 $ 1,300.00 6,500.00 6,500.00 6,500.00 6,500.00 1,300.00 700.00 2,100.00 2,100.00 2,100.00 2,100.00 700.00 75.00 225.00 225.00 225.00 225.00 75.00 10,711.00 36,000.00 $49,261.00 $11,200.00 $ 11,200.00 $ 11,200.00 $ 11,200.00 $ 2,550.00 $ - - $ 475.00 $ 10,925.00 1,300.00 $ 29,900.00 700.00 $ 10,500.00 75.00 $ 1,125.00 $10,711.00 $36,000.00 $ 2,550.00 $ 99,161.00 $ - $ $ - $ - $ 67.58 $ 296.80 $ 296.80 $ 296.80 $ 296.80 $ 67.58 $ $ $ $ - $ - $ 67.58 $ 1,389.93 184.95 36.99 36.99 400.00 16.79 184.95 400.00 83.95 184.95 400.00 83.95 184.95 400.00 83.95 400.00 83.95 Sales Inflors: Package 1 Package 2 Package 3 Add on Package Equity infusion Bank Loans Total inflovs Outfolovs: E-commerce fee Add-on materials COGS ($36.99 per unit) Advertising Fuel Manager Salary Loan Repayments Interest Payments Truck insurance Business insurance Bank Fees Rent Website Investments: NUANS Legal fees Fixed Assets Purchase Inventory Total outflors Net Cash Floy Beginning Cash Ending Cash 500.00 120.00 150.00 200.00 10.00 240.00 500.00 118.00 150.00 200.00 10.00 240.00 150.00 200.00 10.00 240.00 250.00 500.00 117.00 150.00 200.00 10.00 240.00 16.79 10,000.00 500.00 113.00 150.00 200.00 10.00 240.00 500.00 115.00 150.00 200.00 10.00 240.00 500.00 112.00 150.00 200.00 10.00 240.00 500.00 110.00 150.00 200.00 10.00 240.00 500.00 108.00 150.00 200.00 10.00 240.00 500.00 107.00 150.00 200.00 10.00 240.00 36.99 $ 850.77 400.00 $ 2,400.00 16.79 $ 386.18 $ 10,000.00 500.00 $ 5,500.00 103.00 $ 1,228,00 150.00 $ 1,800.00 200.00 $ 2,400.00 10.00 $ 120.00 240.00 $ 2,880.00 250.00 500.00 105.00 150.00 200.00 10.00 240.00 40.00 $ 40.00 2,500.00 $ 2,500.00 46,526.05 $ 46,526.05 184.95 $ $ 184.95 $48,122.36 $ 4,685.70 $ 2.183.70 $ 2,182.70 $ 1,780.70 $ 11,334.36 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1.605.00 $ 1,724.36 $ 78,455.87 $ 1.138.64 $ 6,514.30 $ 9,016.30 $ 9,017.30 $ 9,419.30 $(8,784.36) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $ (1,605.00) $ 825.64 $ 20,705.13 1,138.64 7,652.94 16,669.24 25,686.54 35,105.84 26,321.48 25,109.48 23,899.48 22,691.48 21,484.48 19,879.48 1,138.64 7,652.94 16,669.24 25,686.54 35,105.84 26,321.48 25,109.48 23,899.48 22,691,48 21,484.48 19,879.48 20,705.13 - 1 Projected Cash Budget (LOW) BACKYARD PUB April 30, 2018 May June July August September October November December January February March April Total Sales $ 2,550.00 $7,650.00 $7,650.00 $7,650.00 $7,650.00 $ 2,550.00 $ $ $ $ $ $ $2,550.00 $38,250.00 Inflovs: Package 1 $ 475.00 $1,425.00 $1,425.00 $1,425.00 $1,425.00 $ 475.00 $ $ $ $ $ $ 475.00 $ 7,125.00 Package 2 1,300.00 3,900.00 3,900.00 3,900.00 3,900.00 1,300.00 1,300.00 $ 19,500.00 Package 3 700.00 2,100.00 2,100.00 2,100.00 2,100.00 700.00 - 700.00 $ 10,500.00 Add on Package 75.00 225.00 225.00 225.00 225.00 75.00 75.00 $ 1,125.00 Equity infusion 10,711.00 $ 10,711.00 Bank Loans 36,000.00 $36,000.00 Total inflovs $49,261.00 $7,650.00 $7,650.00 $7,650.00 $7,650.00 $ 2,550.00 $ - $ $ $ $2,550.00 $ 84,961.00 Outfolovs: E-commerce fee $ 67.58 $ 202.73 $ 202.73 $ 202.73 $ 202.73 $ 67.58 $ $ - $ - $ - $ - $ 67.58 $ 1,013.63 Add-on materials 36.99 110.97 110.97 110.97 36.99 - - 110.97 - 36.99 $ 554.85 Advertising 400.00 400.00 400.00 400.00 400.00 400.00 $ 2,400.00 Fuel 16.79 50.37 50.37 50.37 50.37 16.79 - - 16.79 $ 251.86 Manager Salary 10.000.00 $ 10,000.00 Loan Repayments 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 $ 5,500.00 Interest Payments 120.00 118.00 117.00 115.00 113.00 112.00 110.00 108.00 107.00 105.00 103.00 $ 1,228.00 Truok insurance 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 150.00 $ 1,800.00 Business insurance 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 200.00 $ 2,400.00 Bank Fees 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 $ 120.00 Rent 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 240.00 $ 2,880.00 Website 250.00 $ 250.00 Investments: NUANS 40.00 $ 40.00 Legal fees 2,500.00 $ 2,500.00 Fixed Assets Purchasi 46,526.05 $ 46,526.05 Inventory 184.95 $ 184.95 Total outflovs $48,122.36 $4,484.07 $ 1,982.07 $ 1,981.07 $1,579.07 $ 11,334.36 $ 1,212.00 $ 1,210.00 $ 1,208.00 $ 1,207.00 $ 1,605.00 $1,724.36 $77,649.33 Net Cash Floy $ 1,138.64 $ 3.165.93 $5,667.93 $5,668.93 $6,070.93 $ (8,784.36) $ (1,212.00) $ (1,210.00) $ (1,208.00) $ (1,207.00) $ (1,605.00) $825.64 $ 7,311.67 Beginning Cash 1.138.64 4,304.58 9,972.51 15,641.45 21,712.38 12,928.02 11,716.02 10,506.02 9,298.02 8,091.02 6,486.02 Ending Cash 1.138.64 4,304.58 9.972.51 15,641.45 21.712.38 12.928.02 11,716.02 10,506.02 9,298.02 8,091,02 6,486.02 7 31167 BACKYARD PUB July August September October November December Januar February March May June April Total 1 2 1 1 3 6 3 3 3 6 3 3 3 6 3 3 3 6 3 3 1 2 1 1 0 0 0 0 OOOO 0 0 0 0 1 2 1 1 15 30 15 15 1 2 1 1 5 10 5 5 5 10 5 5 5 10 5 5 5 10 5 5 1 2 1 1 OOOO 0 0 0 0 0 0 0 0 0 0 0 0 Oood 1 2 1 1 23 46 23 23 4 2 2 6 12 6 6 6 12 6 6 6 12 6 6 6 12 6 6 2 4 2 2 0 0 0 0 0 0 0 0 OOOO 0 0 0 0 2 4 2 2 2 4 2 2 32 64 32 32 Year 2018 Low: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2018 High: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2019 Low: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2019 High: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2020 Low: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience Year 2020 High: Package 1 (25%) Package 2 (50% Package 3 (25%) Add-on convenience 2 4 2 2 10 20 10 10 10 20 10 10 10 20 10 10 10 20 10 10 2 4 2 2 OOOO OOOO 0 0 0 0 0 0 0 0 2 4 2 2 2 4 2 2 48 96 48 48 2 4 88 2 4 2 2 9 18 9 9 9 18 9 9 9 18 9 9 9 18 9 9 2 4 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 4 2 2 2 2 2 15 30 2 4 2 2 15 30 15 15 30 15 15 15 30 15 15 2 4 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 4 2 2 68 136 68 68 2 2 Projected Statement of Earnings (HIGH) BACKYARD PUB 2018 2019 2020 Revenue: Package 1 10,925.00 $ 22,800.00 $ 32,300.00 Package 2 29,900.00 62,400.00 88,400.00 Package 3 16,100.00 33,600.00 47,600.00 Add-on 1,725.00 3,600.00 5,100.00 Total Revenue $ 58,650.00 $ 122.400.00 $ 173.400.00 Variable Costs: E-commerce 1,554.23 3,243.60 4,595.10 Add-on materials 850.77 1,775.52 2,515.32 Total variable cost 2.405.00 $ 5.019.12 $ 7.110.12 Contribution margin $ 56,245.01 $ 117,380.88 $ 166,289.58 Fixed costs: Website 250.00 $ 250.00 $ 250.00 Rent 2.880.00 2,880.00 2,880.00 Incorporate BYP 2,500.00 NUANS 40.00 Business Insurance 2,400.00 2,400.00 2,400.00 Salary: Manager $ 10,000.00 $ 48,000.00 $ 48,000.00 Salary: Part-time 1,440.00 1,440.00 Fuel (truck) 386.18 805.94 1,141.75 Truck insurance 1,800.00 1.800.00 1,800.00 Truck Depreciation 2,958.33 2.750.00 2,750.00 Vehicle rent 960.00 960.00 Business Account F 120.00 120.00 120.00 Advertising 2,400.00 3,600.00 4,800.00 Depreciation 1,333.33 3,333.33 5,333.33 Depreciation other 402.60 1,006,50 1,610.40 Total Fixed Costs $ 27,470.45 $ 69.345.77 $ 73.185.18 EBIT $ 28,774.56 $ 48,035.11 $ 92,804.10 Interest & Tas: Truck interest 1.228.00 1,110.00 870.00 Tax rate 6,158.250 $ 12,852.000 Net Incomelloss $ 28.774.56 $ 41,876.86 $ 79.952.10 Projected Statement of Financial Positions (HIGH) BACKYARD PUB At December 2020 2018 2019 2020 ASSETS Current Asset: Cash Inventory add on package Fixed asset: Truck Accumulated Depreciation-Truck Inflatable Pub Accumulated Depreciation-Infatable Pub Inflatable Pub Accumulated Depreciation-Infatable Pub Other equipment Accumulated Depreciation-Equipment Total fix asset Total Assets $ $ $ Liabilities & Shareholder's Equity Current liabilities Current portion Tax payable Interest Payable Total current liabilities Long-terms liabilities Banck loan Retained earning from last year Add net income Retained earning Total liabilities and shareholder's equity $ 2020 Projected Statement of Financial Positions (LOW) BACKYARD PUB At December 2020 2018 2019 ASSETS Current Asset: Cash Inventory add on package Fixed asset: Truck Accumulated Depreciation-Truck Inflatable Pub Accumulated Depreciation-Infatable Pub Inflatable Pub Accumulated Depreciation-Infatable Pub Other equipment Accumulated Depreciation-Equipment Total fix asset Total Assets $ $ Liabilities & Shareholder's Equity Current liabilities Current portion Tax payable Interest Payable Total current liabilities Long-terms liabilities Banck loan Retained earning from last year Add net income Retained earning Total liabilities and shareholder's equity - $