Domino Comptech Holdings
Appendix
Sales Forecast | |||||||||||||
Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
Unit Sales | |||||||||||||
Basic PC | 0% | 75 | 100 | 125 | 180 | 210 | 220 | 250 | 275 | 290 | 300 | 320 | 340 |
Intermediate PC | 0% | 100 | 110 | 120 | 140 | 150 | 180 | 200 | 250 | 300 | 340 | 370 | 370 |
Power PC | 0% | 120 | 130 | 140 | 160 | 180 | 200 | 220 | 240 | 260 | 280 | 300 | 320 |
Laptop | 0% | 25 | 50 | 75 | 100 | 125 | 160 | 180 | 200 | 220 | 240 | 260 | 280 |
Basic Printer | 0% | 100 | 120 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 220 | 240 | 260 |
Intermediate Printer | 0% | 50 | 75 | 100 | 125 | 150 | 200 | 250 | 300 | 325 | 350 | 380 | 400 |
Power Printer | 0% | 20 | 40 | 60 | 80 | 100 | 150 | 200 | 250 | 300 | 325 | 350 | 400 |
Basic Network Server | 0% | 10 | 20 | 30 | 40 | 50 | 60 | 80 | 100 | 150 | 200 | 250 | 300 |
Intermediate Network Server | 0% | 25 | 30 | 35 | 40 | 45 | 50 | 125 | 150 | 200 | 250 | 300 | 350 |
Power Network Server | 0% | 10 | 20 | 30 | 40 | 50 | 75 | 95 | 105 | 125 | 130 | 145 | 190 |
Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total Unit Sales | 535 | 695 | 855 | 1,055 | 1,220 | 1,465 | 1,780 | 2,060 | 2,370 | 2,635 | 2,915 | 3,210 | |
Unit Prices | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | |
Basic PC | $1,634.00 | $1,634.00 | $1,634.00 | $1,634.00 | $1,634.00 | $1,634.00 | $1,634.00 | $1,634.00 | $1,634.00 | $1,634.00 | $1,634.00 | $1,634.00 | |
Intermediate PC | $2,523.00 | $2,523.00 | $2,523.00 | $2,523.00 | $2,523.00 | $2,523.00 | $2,523.00 | $2,523.00 | $2,523.00 | $2,523.00 | $2,523.00 | $2,523.00 | |
Power PC | $3,212.00 | $3,212.00 | $3,212.00 | $3,212.00 | $3,212.00 | $3,212.00 | $3,212.00 | $3,212.00 | $3,212.00 | $3,212.00 | $3,212.00 | $3,212.00 | |
Laptop | $2,483.00 | $2,483.00 | $2,483.00 | $2,483.00 | $2,483.00 | $2,483.00 | $2,483.00 | $2,483.00 | $2,483.00 | $2,483.00 | $2,483.00 | $2,483.00 | |
Basic Printer | $465.00 | $465.00 | $465.00 | $465.00 | $465.00 | $465.00 | $465.00 | $465.00 | $465.00 | $465.00 | $465.00 | $465.00 | |
Intermediate Printer | $1,393.00 | $1,393.00 | $1,393.00 | $1,393.00 | $1,393.00 | $1,393.00 | $1,393.00 | $1,393.00 | $1,393.00 | $1,393.00 | $1,393.00 | $1,393.00 | |
Power Printer | $3,368.00 | $3,368.00 | $3,368.00 | $3,368.00 | $3,368.00 | $3,368.00 | $3,368.00 | $3,368.00 | $3,368.00 | $3,368.00 | $3,368.00 | $3,368.00 | |
Basic Network Server | $3,883.00 | $3,883.00 | $3,883.00 | $3,883.00 | $3,883.00 | $3,883.00 | $3,883.00 | $3,883.00 | $3,883.00 | $3,883.00 | $3,883.00 | $3,883.00 | |
Intermediate Network Server | $6,351.00 | $6,351.00 | $6,351.00 | $6,351.00 | $6,351.00 | $6,351.00 | $6,351.00 | $6,351.00 | $6,351.00 | $6,351.00 | $6,351.00 | $6,351.00 | |
Power Network Server | $9,573.00 | $9,573.00 | $9,573.00 | $9,573.00 | $9,573.00 | $9,573.00 | $9,573.00 | $9,573.00 | $9,573.00 | $9,573.00 | $9,573.00 | $9,573.00 | |
Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
Sales | |||||||||||||
Basic PC | $122,550 | $163,400 | $204,250 | $294,120 | $343,140 | $359,480 | $408,500 | $449,350 | $473,860 | $490,200 | $522,880 | $555,560 | |
Intermediate PC | $252,300 | $277,530 | $302,760 | $353,220 | $378,450 | $454,140 | $504,600 | $630,750 | $756,900 | $857,820 | $933,510 | $933,510 | |
Power PC | $385,440 | $417,560 | $449,680 | $513,920 | $578,160 | $642,400 | $706,640 | $770,880 | $835,120 | $899,360 | $963,600 | $1,027,840 | |
Laptop | $62,075 | $124,150 | $186,225 | $248,300 | $310,375 | $397,280 | $446,940 | $496,600 | $546,260 | $595,920 | $645,580 | $695,240 | |
Basic Printer | $46,500 | $55,800 | $65,100 | $69,750 | $74,400 | $79,050 | $83,700 | $88,350 | $93,000 | $102,300 | $111,600 | $120,900 | |
Intermediate Printer | $69,650 | $104,475 | $139,300 | $174,125 | $208,950 | $278,600 | $348,250 | $417,900 | $452,725 | $487,550 | $529,340 | $557,200 | |
Power Printer | $67,360 | $134,720 | $202,080 | $269,440 | $336,800 | $505,200 | $673,600 | $842,000 | $1,010,400 | $1,094,600 | $1,178,800 | $1,347,200 | |
Basic Network Server | $38,830 | $77,660 | $116,490 | $155,320 | $194,150 | $232,980 | $310,640 | $388,300 | $582,450 | $776,600 | $970,750 | $1,164,900 | |
Intermediate Network Server | $158,775 | $190,530 | $222,285 | $254,040 | $285,795 | $317,550 | $793,875 | $952,650 | $1,270,200 | $1,587,750 | $1,905,300 | $2,222,850 | |
Power Network Server | $95,730 | $191,460 | $287,190 | $382,920 | $478,650 | $717,975 | $909,435 | $1,005,165 | $1,196,625 | $1,244,490 | $1,388,085 | $1,818,870 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales | $1,299,210 | $1,737,285 | $2,175,360 | $2,715,155 | $3,188,870 | $3,984,655 | $5,186,180 | $6,041,945 | $7,217,540 | $8,136,590 | $9,149,445 | $10,444,070 | |
Direct Unit Costs | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | |
Basic PC | 0.00% | $490.20 | $490.20 | $490.20 | $490.20 | $490.20 | $490.20 | $490.20 | $490.20 | $490.20 | $490.20 | $490.20 | $490.20 |
Intermediate PC | 0.00% | $756.90 | $756.90 | $756.90 | $756.90 | $756.90 | $756.90 | $756.90 | $756.90 | $756.90 | $756.90 | $756.90 | $756.90 |
Power PC | 0.00% | $963.60 | $963.60 | $963.60 | $963.60 | $963.60 | $963.60 | $963.60 | $963.60 | $963.60 | $963.60 | $963.60 | $963.60 |
Laptop | 0.00% | $744.90 | $744.90 | $744.90 | $744.90 | $744.90 | $744.90 | $744.90 | $744.90 | $744.90 | $744.90 | $744.90 | $744.90 |
Basic Printer | 0.00% | $139.50 | $139.50 | $139.50 | $139.50 | $139.50 | $139.50 | $139.50 | $139.50 | $139.50 | $139.50 | $139.50 | $139.50 |
Intermediate Printer | 0.00% | $417.90 | $417.90 | $417.90 | $417.90 | $417.90 | $417.90 | $417.90 | $417.90 | $417.90 | $417.90 | $417.90 | $417.90 |
Power Printer | 0.00% | $1,010.40 | $1,010.40 | $1,010.40 | $1,010.40 | $1,010.40 | $1,010.40 | $1,010.40 | $1,010.40 | $1,010.40 | $1,010.40 | $1,010.40 | $1,010.40 |
Basic Network Server | 0.00% | $1,164.90 | $1,164.90 | $1,164.90 | $1,164.90 | $1,164.90 | $1,164.90 | $1,164.90 | $1,164.90 | $1,164.90 | $1,164.90 | $1,164.90 | $1,164.90 |
Intermediate Network Server | 0.00% | $1,905.30 | $1,905.30 | $1,905.30 | $1,905.30 | $1,905.30 | $1,905.30 | $1,905.30 | $1,905.30 | $1,905.30 | $1,905.30 | $1,905.30 | $1,905.30 |
Power Network Server | 0.00% | $2,871.90 | $2,871.90 | $2,871.90 | $2,871.90 | $2,871.90 | $2,871.90 | $2,871.90 | $2,871.90 | $2,871.90 | $2,871.90 | $2,871.90 | $2,871.90 |
Other | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Direct Cost of Sales | |||||||||||||
Basic PC | $36,765 | $49,020 | $61,275 | $88,236 | $102,942 | $107,844 | $122,550 | $134,805 | $142,158 | $147,060 | $156,864 | $166,668 | |
Intermediate PC | $75,690 | $83,259 | $90,828 | $105,966 | $113,535 | $136,242 | $151,380 | $189,225 | $227,070 | $257,346 | $280,053 | $280,053 | |
Power PC | $115,632 | $125,268 | $134,904 | $154,176 | $173,448 | $192,720 | $211,992 | $231,264 | $250,536 | $269,808 | $289,080 | $308,352 | |
Laptop | $18,623 | $37,245 | $55,868 | $74,490 | $93,113 | $119,184 | $134,082 | $148,980 | $163,878 | $178,776 | $193,674 | $208,572 | |
Basic Printer | $13,950 | $16,740 | $19,530 | $20,925 | $22,320 | $23,715 | $25,110 | $26,505 | $27,900 | $30,690 | $33,480 | $36,270 | |
Intermediate Printer | $20,895 | $31,343 | $41,790 | $52,238 | $62,685 | $83,580 | $104,475 | $125,370 | $135,818 | $146,265 | $158,802 | $167,160 | |
Power Printer | $20,208 | $40,416 | $60,624 | $80,832 | $101,040 | $151,560 | $202,080 | $252,600 | $303,120 | $328,380 | $353,640 | $404,160 | |
Basic Network Server | $11,649 | $23,298 | $34,947 | $46,596 | $58,245 | $69,894 | $93,192 | $116,490 | $174,735 | $232,980 | $291,225 | $349,470 | |
Intermediate Network Server | $47,633 | $57,159 | $66,686 | $76,212 | $85,739 | $95,265 | $238,163 | $285,795 | $381,060 | $476,325 | $571,590 | $666,855 | |
Power Network Server | $28,719 | $57,438 | $86,157 | $114,876 | $143,595 | $215,393 | $272,831 | $301,550 | $358,988 | $373,347 | $416,426 | $545,661 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $389,763 | $521,186 | $652,608 | $814,547 | $956,661 | $1,195,397 | $1,555,854 | $1,812,584 | $2,165,262 | $2,440,977 | $2,744,834 | $3,133,221 |
Personnel Plan | |||||||||||||
Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
Kit Puma – Chairman of the Board | 0% | $8,500 | $8,500 | $5,800 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 |
Lynx Caracal – President & CEO | 0% | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 |
Neve Palenque – Vice President | 0% | $3,950 | $3,950 | $3,950 | $3,950 | $3,950 | $3,950 | $3,950 | $3,950 | $3,950 | $3,950 | $3,950 | $3,950 |
Felidae Kalakmul – Secretary | 0% | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 |
Panthera Dos Pilas, CPA – Treasurer | 0% | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
Marketing Director (not yet hired) | 0% | $0 | $0 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
Total Payroll | $21,866 | $21,866 | $22,916 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 |
General Assumptions | |||||||||||||
Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
Other | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Pro Forma Profit and Loss | |||||||||||||
Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
Sales | $1,299,210 | $1,737,285 | $2,175,360 | $2,715,155 | $3,188,870 | $3,984,655 | $5,186,180 | $6,041,945 | $7,217,540 | $8,136,590 | $9,149,445 | $10,444,070 | |
Direct Cost of Sales | $389,763 | $521,186 | $652,608 | $814,547 | $956,661 | $1,195,397 | $1,555,854 | $1,812,584 | $2,165,262 | $2,440,977 | $2,744,834 | $3,133,221 | |
Other Costs of Goods | 5% | $60,000 | $90,000 | $110,000 | $140,000 | $160,000 | $200,000 | $260,000 | $300,000 | $360,000 | $410,000 | $460,000 | $520,000 |
Total Cost of Sales | $449,763 | $611,186 | $762,608 | $954,547 | $1,116,661 | $1,395,397 | $1,815,854 | $2,112,584 | $2,525,262 | $2,850,977 | $3,204,834 | $3,653,221 | |
Gross Margin | $849,447 | $1,126,100 | $1,412,752 | $1,760,609 | $2,072,209 | $2,589,259 | $3,370,326 | $3,929,362 | $4,692,278 | $5,285,613 | $5,944,612 | $6,790,849 | |
Gross Margin % | 65.38% | 64.82% | 64.94% | 64.84% | 64.98% | 64.98% | 64.99% | 65.03% | 65.01% | 64.96% | 64.97% | 65.02% | |
Expenses | |||||||||||||
Payroll | $21,866 | $21,866 | $22,916 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | |
Divisions payroll (see note) | 20% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $100,000 |
Depreciation | 1% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Divisions operating expense (see note) | 38% | $200,000 | $300,000 | $300,000 | $400,000 | $500,000 | $600,000 | $800,000 | $900,000 | $1,100,000 | $1,200,000 | $1,400,000 | $1,600,000 |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,000 |
Other | 1% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Operating Expenses | $221,866 | $321,866 | $322,916 | $425,616 | $525,616 | $625,616 | $825,616 | $925,616 | $1,125,616 | $1,225,616 | $1,425,616 | $1,726,616 | |
Profit Before Interest and Taxes | $627,581 | $804,234 | $1,089,836 | $1,334,993 | $1,546,593 | $1,963,643 | $2,544,710 | $3,003,746 | $3,566,662 | $4,059,997 | $4,518,996 | $5,064,233 | |
EBITDA | $627,581 | $804,234 | $1,089,836 | $1,334,993 | $1,546,593 | $1,963,643 | $2,544,710 | $3,003,746 | $3,566,662 | $4,059,997 | $4,518,996 | $5,064,233 | |
Interest Expense | $19,313 | $19,927 | $19,706 | $19,484 | $19,260 | $19,033 | $18,805 | $18,575 | $18,343 | $18,109 | $17,874 | $17,636 | |
Taxes Incurred | $182,481 | $235,292 | $321,039 | $394,653 | $458,200 | $583,383 | $757,771 | $895,551 | $1,064,496 | $1,212,566 | $1,350,337 | $1,513,979 | |
Net Profit | $425,788 | $549,015 | $749,091 | $920,856 | $1,069,133 | $1,361,226 | $1,768,133 | $2,089,619 | $2,483,823 | $2,829,321 | $3,150,785 | $3,532,618 | |
Net Profit/Sales | 32.77% | 31.60% | 34.44% | 33.92% | 33.53% | 34.16% | 34.09% | 34.59% | 34.41% | 34.77% | 34.44% | 33.82% |
Pro Forma Cash Flow | |||||||||||||
Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $324,803 | $434,321 | $543,840 | $678,789 | $797,218 | $996,164 | $1,296,545 | $1,510,486 | $1,804,385 | $2,034,148 | $2,287,361 | $2,611,018 | |
Cash from Receivables | $286,055 | $318,535 | $985,359 | $1,313,916 | $1,645,015 | $2,048,209 | $2,411,547 | $3,018,529 | $3,911,029 | $4,560,849 | $5,436,131 | $6,127,764 | |
Subtotal Cash from Operations | $610,857 | $752,856 | $1,529,199 | $1,992,704 | $2,442,232 | $3,044,373 | $3,708,092 | $4,529,016 | $5,715,414 | $6,594,996 | $7,723,493 | $8,738,781 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
New Current Borrowing | $0 | $100,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Investment Received | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $610,857 | $852,856 | $1,529,199 | $1,992,704 | $2,442,232 | $3,044,373 | $3,708,092 | $4,529,016 | $5,715,414 | $6,594,996 | $7,723,493 | $8,738,781 | |
Expenditures | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | |
Expenditures from Operations | |||||||||||||
Cash Spending | $21,866 | $21,866 | $22,916 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | $25,616 | |
Bill Payments | $192,426 | $809,984 | $1,318,868 | $1,561,215 | $1,956,936 | $2,270,779 | $2,891,372 | $3,802,940 | $4,238,677 | $5,112,344 | $5,609,017 | $6,340,812 | |
Subtotal Spent on Operations | $214,292 | $831,850 | $1,341,784 | $1,586,831 | $1,982,552 | $2,296,395 | $2,916,988 | $3,828,556 | $4,264,293 | $5,137,960 | $5,634,633 | $6,366,428 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Principal Repayment of Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Liabilities Principal Repayment | $100,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $26,043 | $26,260 | $26,479 | $26,699 | $26,922 | $27,146 | $27,372 | $27,600 | $27,830 | $28,062 | $28,296 | $28,532 | |
Purchase Other Current Assets | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | |
Purchase Long-term Assets | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $380,334 | $898,109 | $1,408,262 | $1,653,530 | $2,049,474 | $2,363,541 | $2,984,360 | $3,896,156 | $4,332,123 | $5,206,022 | $5,702,930 | $6,434,960 | |
Net Cash Flow | $230,523 | ($45,253) | $120,937 | $339,175 | $392,758 | $680,832 | $723,732 | $632,859 | $1,383,291 | $1,388,974 | $2,020,563 | $2,303,822 | |
Cash Balance | $238,232 | $192,978 | $313,916 | $653,090 | $1,045,849 | $1,726,680 | $2,450,412 | $3,083,272 | $4,466,563 | $5,855,537 | $7,876,100 | $10,179,922 |
Pro Forma Balance Sheet | |||||||||||||
Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $7,709 | $238,232 | $192,978 | $313,916 | $653,090 | $1,045,849 | $1,726,680 | $2,450,412 | $3,083,272 | $4,466,563 | $5,855,537 | $7,876,100 | $10,179,922 |
Accounts Receivable | $572,109 | $1,260,462 | $2,244,891 | $2,891,052 | $3,613,502 | $4,360,140 | $5,300,422 | $6,778,510 | $8,291,439 | $9,793,565 | $11,335,159 | $12,761,112 | $14,466,400 |
Inventory | $487,587 | $428,739 | $573,304 | $717,869 | $896,001 | $1,052,327 | $1,314,936 | $1,711,439 | $1,993,842 | $2,381,788 | $2,685,075 | $3,019,317 | $3,446,543 |
Other Current Assets | $193,429 | $218,429 | $243,429 | $268,429 | $293,429 | $318,429 | $343,429 | $368,429 | $393,429 | $418,429 | $443,429 | $468,429 | $493,429 |
Total Current Assets | $1,260,834 | $2,145,862 | $3,254,602 | $4,191,265 | $5,456,023 | $6,776,745 | $8,685,468 | $11,308,791 | $13,761,982 | $17,060,345 | $20,319,200 | $24,124,957 | $28,586,294 |
Long-term Assets | |||||||||||||
Long-term Assets | $1,479,498 | $1,494,498 | $1,509,498 | $1,524,498 | $1,539,498 | $1,554,498 | $1,569,498 | $1,584,498 | $1,599,498 | $1,614,498 | $1,629,498 | $1,644,498 | $1,659,498 |
Accumulated Depreciation | $166,002 | $166,002 | $166,002 | $166,002 | $166,002 | $166,002 | $166,002 | $166,002 | $166,002 | $166,002 | $166,002 | $166,002 | $166,002 |
Total Long-term Assets | $1,313,496 | $1,328,496 | $1,343,496 | $1,358,496 | $1,373,496 | $1,388,496 | $1,403,496 | $1,418,496 | $1,433,496 | $1,448,496 | $1,463,496 | $1,478,496 | $1,493,496 |
Total Assets | $2,574,330 | $3,474,358 | $4,598,098 | $5,549,761 | $6,829,519 | $8,165,241 | $10,088,964 | $12,727,287 | $15,195,478 | $18,508,841 | $21,782,696 | $25,603,453 | $30,079,790 |
Liabilities and Capital | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | |
Current Liabilities | |||||||||||||
Accounts Payable | $166,002 | $766,285 | $1,267,270 | $1,496,321 | $1,881,921 | $2,175,432 | $2,765,074 | $3,662,636 | $4,068,809 | $4,926,179 | $5,398,775 | $6,097,043 | $7,069,294 |
Current Borrowing | $370,126 | $370,126 | $470,126 | $470,126 | $470,126 | $470,126 | $470,126 | $470,126 | $470,126 | $470,126 | $470,126 | $470,126 | $470,126 |
Other Current Liabilities | $335,462 | $235,462 | $235,462 | $235,462 | $235,462 | $235,462 | $235,462 | $235,462 | $235,462 | $235,462 | $235,462 | $235,462 | $235,462 |
Subtotal Current Liabilities | $871,590 | $1,371,873 | $1,972,858 | $2,201,909 | $2,587,509 | $2,881,020 | $3,470,662 | $4,368,224 | $4,774,397 | $5,631,767 | $6,104,363 | $6,802,631 | $7,774,882 |
Long-term Liabilities | $1,973,421 | $1,947,378 | $1,921,119 | $1,894,640 | $1,867,941 | $1,841,019 | $1,813,873 | $1,786,501 | $1,758,901 | $1,731,071 | $1,703,008 | $1,674,712 | $1,646,180 |
Total Liabilities | $2,845,011 | $3,319,251 | $3,893,977 | $4,096,549 | $4,455,450 | $4,722,039 | $5,284,536 | $6,154,725 | $6,533,297 | $7,362,838 | $7,807,371 | $8,477,343 | $9,421,062 |
Paid-in Capital | $676,193 | $676,193 | $676,193 | $676,193 | $676,193 | $676,193 | $676,193 | $676,193 | $676,193 | $676,193 | $676,193 | $676,193 | $676,193 |
Retained Earnings | ($946,874) | ($946,874) | ($946,874) | ($946,874) | ($946,874) | ($946,874) | ($946,874) | ($946,874) | ($946,874) | ($946,874) | ($946,874) | ($946,874) | ($946,874) |
Earnings | $0 | $425,788 | $974,802 | $1,723,893 | $2,644,749 | $3,713,883 | $5,075,109 | $6,843,242 | $8,932,862 | $11,416,685 | $14,246,006 | $17,396,791 | $20,929,409 |
Total Capital | ($270,681) | $155,107 | $704,121 | $1,453,212 | $2,374,068 | $3,443,202 | $4,804,428 | $6,572,561 | $8,662,181 | $11,146,004 | $13,975,325 | $17,126,110 | $20,658,728 |
Total Liabilities and Capital | $2,574,330 | $3,474,358 | $4,598,098 | $5,549,761 | $6,829,519 | $8,165,241 | $10,088,964 | $12,727,287 | $15,195,478 | $18,508,841 | $21,782,696 | $25,603,453 | $30,079,790 |
Net Worth | ($270,681) | $155,107 | $704,121 | $1,453,212 | $2,374,068 | $3,443,202 | $4,804,428 | $6,572,561 | $8,662,181 | $11,146,004 | $13,975,325 | $17,126,110 | $20,658,728 |