Domino Comptech Holdings

Start your own business plan »

Financial Holding Company Business Plan

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