YOUR CO NAME

Projected Cash Flow

Jan 1 2021 to Dec 31 2021
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Sales $ 23,000 $ 25,750 $ 31,500 $ 33,500 $ 37,250 $ 37,750 $ 41,500 $ 45,250 $ 47,250 $ 49,250 $ 53,000 $ 58,750 $ 483,750

Cash Receipts
From cash sales 23,000 25,750 31,500 33,500 37,250 37,750 41,500 45,250 47,250 49,250 53,000 58,750 483,750
From credit sales -
From owner advance -
Other Loans advances -
Total cash receipts 23,000 25,750 31,500 33,500 37,250 37,750 41,500 45,250 47,250 49,250 53,000 58,750 483,750

Cash Disbursements
Purchases of stock 11,500 12,875 15,750 16,750 18,625 18,875 20,750 22,625 23,625 24,625 26,500 29,375 241,875
Wages 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 184,999
DAS 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 27,750
Rent 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000
Taxes & lisc - - - - - - - - - - - - -
Utilities 650 650 650 650 650 650 650 650 650 650 650 650 7,800
Insurance & alarm 450 450 450 450 450 450 450 450 450 450 450 450 5,400
Repair & maintenance - - - - - - - - - - - - -
Advertising, promo & ro 375 375 375 375 375 375 375 375 375 375 375 375 4,500
Commissions - - - - - - - - - - - - -
Tel & internet - - - - - - - - - - - - -
Tranning 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 19,999
Meals & entertainment - - - - - - - - - - - - -
Office expense - - - - - - - - - - - - -
Computer supplies - - - - - - - - - - - - -
Professional fees - - - - - - - - - - - - -
Interest, CC and bank fe - - - - - - - - - - - - -
Interest on term debt 1,643 1,615 1,588 1,561 1,533 1,506 1,478 1,451 1,424 1,396 1,369 1,342 17,906
Income taxes - 4,791 - 4,524 - 3,973 - 3,777 - 3,416 - 3,363 - 3,002 - 2,640 - 2,445 - 2,250 - 1,889 - 1,337 - 37,407
Mortgage payments -
Other loan payments 5,476 5,476 5,476 5,476 5,476 5,476 5,476 5,476 5,476 5,476 5,476 5,476 65,710
Capital Purchases -
Owner withdrawals -
Total cash disbursements 44,699 46,313 49,712 50,880 53,089 53,364 55,573 57,782 58,950 60,118 62,327 65,726 658,532

Cash position
Opening balance 20,000 - 1,699 - 22,262 - 40,473 - 57,853 - 73,692 - 89,306 - 103,379 - 115,911 - 127,611 - 138,479 - 147,806
Surplus (shortage) - 21,699 - 20,563 - 18,212 - 17,380 - 15,839 - 15,614 - 14,073 - 12,532 - 11,700 - 10,868 - 9,327 - 6,976
Closing balance -$ 1,699 -$ 22,262 -$ 40,473 -$ 57,853 -$ 73,692 -$ 89,306 -$ 103,379 -$ 115,911 -$ 127,611 -$ 138,479 -$ 147,806 -$ 154,782
YOUR CO NAME
Projected Income Statement
Jan 1 2021 to Dec 31 2021
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Sales $ 23,000 $ 25,750 $ 31,500 $ 33,500 $ 37,250 $ 37,750 $ 41,500 $ 45,250 $ 47,250 $ 49,250 $ 53,000 $ 58,750 $ 483,750 100.00%

Cost of sales
Opening Inventory 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 8.27%
Purchases of stock % 11,500 12,875 15,750 16,750 18,625 18,875 20,750 22,625 23,625 24,625 26,500 29,375 241,875 50.00%
Avaliable for sale 51,500 52,875 55,750 56,750 58,625 58,875 60,750 62,625 63,625 64,625 66,500 69,375 281,875 58.27%
Less ending inventory 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 8.27%
11,500 12,875 15,750 16,750 18,625 18,875 20,750 22,625 23,625 24,625 26,500 29,375 241,875 50.00%
Contribution margin 1 1 1 1 1 1 1 1 1 1 1 1 1
Expenses
Wages 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 15,417 184,999 38.24%
DAS 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 2,312 27,750 5.74%
Rent 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 24.81%
Taxes & lisc - 0.00%
Utilities 650 650 650 650 650 650 650 650 650 650 650 650 7,800 1.61%
Insurance & alarm 450 450 450 450 450 450 450 450 450 450 450 450 5,400 1.12%
Repair & maintenance - 0.00%
Advertising, promo & royalties 375 375 375 375 375 375 375 375 375 375 375 375 4,500 0.93%
Commissions % - - - - - - - - - - - - - 0.00%
Tel & internet - 0.00%
Tranning 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 19,999 4.13%
Meals & entertainment - 0.00%
Office expense - 0.00%
Computer supplies - 0.00%
Professional fees - 0.00%
Interest, CC and bank fees - 0.00%
Interest on term debt 1,643 1,615 1,588 1,561 1,533 1,506 1,478 1,451 1,424 1,396 1,369 1,342 17,906 3.70%
Amortization 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 4,200 50,400 10.42%
Total expenses 36,713 36,686 36,659 36,631 36,604 36,577 36,549 36,522 36,494 36,467 36,440 36,412 438,754 90.70%
Income before IT - 25,213 - 23,811 - 20,909 - 19,881 - 17,979 - 17,702 - 15,799 - 13,897 - 12,869 - 11,842 - 9,940 - 7,037 - 196,879 -40.70%
Income taxes - 4,791 - 4,524 - 3,973 - 3,777 - 3,416 - 3,363 - 3,002 - 2,640 - 2,445 - 2,250 - 1,889 - 1,337 - 37,407 -7.73%
Net Income - 20,423 - 19,287 - 16,936 - 16,104 - 14,563 - 14,338 - 12,797 - 11,256 - 10,424 - 9,592 - 8,051 - 5,700 - 159,472 -32.97%

Break even $73,427 $73,372 $73,317 $73,263 $73,208 $73,153 $73,098 $73,044 $72,989 $72,934 $72,879 $72,825 $877,509
YOUR CO NAME
Balance Sheet
As at Jan. 2021 Opening 31-Jan 29-Feb 31-Mar 30-Apr 31-May 30-Jun 31-Jul 31-Aug 30-Sep 31-Oct 30-Nov 31-Dec

ASSETS
Current
Cash $ 20,000 $ (1,699) $ (22,262) $ (40,473) $ (57,853) $ (73,692) $ (89,306) $ (103,379) $ (115,911) $ (127,611) $ (138,479) $ (147,806) $ (154,782)
Supplies $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000
Inventory $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000
Prepaid expenses $ 36,550 $ 36,550 $ 36,550 $ 36,550 $ 36,550 $ 36,550 $ 36,550 $ 36,550 $ 36,550 $ 36,550 $ 36,550 $ 36,550 $ 36,550
Total current assets $ 176,550 $ 154,851 $ 134,288 $ 116,077 $ 98,697 $ 82,858 $ 67,244 $ 53,171 $ 40,639 $ 28,939 $ 18,071 $ 8,744 $ 1,768

Capital assets
Rolling Stock/ Vehicles $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Building/ real state $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Computers $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000
Equipment $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000
Furniture and fixtures $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000
Leasehold improvements $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000
Less: Accumulated depreciation $ 4,200 $ 8,400 $ 12,600 $ 16,800 $ 21,000 $ 25,200 $ 29,400 $ 33,600 $ 37,800 $ 42,000 $ 46,200 $ 50,400
Total capital assets $ 252,000 $ 247,800 $ 243,600 $ 239,400 $ 235,200 $ 231,000 $ 226,800 $ 222,600 $ 218,400 $ 214,200 $ 210,000 $ 205,800 $ 201,600
Other assets
Goodwill
TOTAL ASSETS $ 428,550 $ 402,651 $ 377,888 $ 355,477 $ 333,897 $ 313,858 $ 294,044 $ 275,771 $ 259,039 $ 243,139 $ 228,071 $ 214,544 $ 203,368

LIABILITIES AND OWNERS EQUITY

Current
Bank indebtedness loan $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Accounts payable and accrued liabilities
Sales taxes payable
Income taxes payable
Current portion of long-term debt $ 82,137.5 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138
Total current liabilities $ 82,137.5 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138 $ 82,138

Long term liabilities

Long-term debt $ 246,412.5 $ 240,937 $ 235,461 $ 229,985 $ 224,509 $ 219,033 $ 213,558 $ 208,082 $ 202,606 $ 197,130 $ 191,654 $ 186,178 $ 180,703
Loans from shareholders $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Owners equity
Owners equity $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000
Retained earnings $ - $ (20,423) $ (39,710) $ (56,646) $ (72,750) $ (87,313) $ (101,651) $ (114,448) $ (125,705) $ (136,129) $ (145,721) $ (153,772) $ (159,472)
Total owners equity $ 100,000 $ 79,577 $ 60,290 $ 43,354 $ 27,250 $ 12,687 $ (1,651) $ (14,448) $ (25,705) $ (36,129) $ (45,721) $ (53,772) $ (59,472)

Total liabilities and owners equity $ 428,550 $ 402,651 $ 377,888 $ 355,477 $ 333,897 $ 313,858 $ 294,044 $ 275,771 $ 259,039 $ 243,139 $ 228,071 $ 214,544 $ 203,368
Balance Yes if 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Debt to equity
Total debt $ 328,550 $ 323,074 $ 317,598 $ 312,123 $ 306,647 $ 301,171 $ 295,695 $ 290,219 $ 284,743 $ 279,268 $ 273,792 $ 268,316 $ 262,840
Total equity $ 100,000 $ 79,577 $ 60,290 $ 43,354 $ 27,250 $ 12,687 $ (1,651) $ (14,448) $ (25,705) $ (36,129) $ (45,721) $ (53,772) $ (59,472)
debt to equity ratio 3.29 4.06 5.27 7.20 11.25 23.74 -179.11 -20.09 -11.08 -7.73 -5.99 -4.99 -4.42

Working capital ratio 2.15 1.89 1.63 1.41 1.20 1.01 0.82 0.65 0.49 0.35 0.22 0.11 0.02
Quick ratio 1.66 1.40 1.15 0.93 0.71 0.52 0.33 0.16 0.01 -0.13 -0.27 -0.38 -0.47
STEPS:

Step 1 Go to Balance sheet tab and fill in column B (Assets= Liab+Equity) USING Start-up costs TABLE
Step 2 Go to Income statement tab and fill in monthly sales (from C5 to N5) (sales estimation sheet)
Step 3 In the same income statement, plug your monthly expenses (FROM OP and MP)
Depending on Net income (O37), make a decision.
Step 4 Your cashflow tab will be updated- DON’T TOUCH :)
Step 5 Ratios will be calculated.
costs TABLE