Information Management Hawaii

Start your own business plan »

Information Technology Business Plan

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Hardware - Image Platforms 0% $78,500 $78,500 $78,500 $86,350 $86,350 $86,350 $94,985 $94,985 $94,985 $104,484 $104,484 $104,484
Hardware - Printers 0% $5,000 $5,000 $5,000 $5,500 $5,500 $5,500 $6,050 $6,050 $6,050 $6,655 $6,655 $6,655
Hardware - Facsimiles 0% $10,250 $10,250 $10,250 $11,275 $11,275 $11,275 $12,403 $12,403 $12,403 $13,643 $13,643 $13,643
Hardware - Misc (TW, Shrd) 0% $3,250 $3,250 $3,250 $3,575 $3,575 $3,575 $3,933 $3,933 $3,933 $4,326 $4,326 $4,326
Professional Services 0% $0 $0 $2,500 $2,750 $2,750 $2,750 $3,025 $3,025 $3,025 $3,328 $3,328 $3,328
Government (Comp) 0% $6,250 $6,250 $6,250 $6,875 $6,875 $6,875 $7,563 $7,563 $7,563 $8,319 $8,319 $8,319
Supplies (Toner/Paper) 0% $36,000 $36,000 $36,000 $39,600 $39,600 $39,600 $43,560 $43,560 $43,560 $47,916 $47,916 $47,916
Service - Agreements/Repairs 0% $68,000 $68,000 $68,000 $74,800 $74,800 $74,800 $82,280 $82,280 $82,280 $90,508 $90,508 $90,508
Equipment Rentals 0% $17,500 $17,500 $17,500 $19,250 $19,250 $19,250 $21,175 $21,175 $21,175 $23,293 $23,293 $23,293
Other 0% $2,250 $2,250 $2,250 $2,475 $2,475 $2,475 $2,723 $2,723 $2,723 $2,995 $2,995 $2,995
Total Sales $227,000 $227,000 $229,500 $252,450 $252,450 $252,450 $277,695 $277,695 $277,695 $305,465 $305,465 $305,465
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Hardware - Image Platforms $48,670 $48,670 $48,670 $53,537 $53,537 $53,537 $58,891 $58,891 $58,891 $64,780 $64,780 $64,780
Hardware - Printers $3,250 $3,250 $3,250 $3,575 $3,575 $3,575 $3,933 $3,933 $3,933 $4,326 $4,326 $4,326
Hardware - Facsimiles $6,355 $6,355 $6,355 $6,991 $6,991 $6,991 $7,690 $7,690 $7,690 $8,459 $8,459 $8,459
Hardware - Misc (TW, Shrd) $2,275 $2,275 $2,275 $2,503 $2,503 $2,503 $2,753 $2,753 $2,753 $3,028 $3,028 $3,028
Professional Services $0 $0 $1,250 $1,375 $1,375 $1,375 $1,513 $1,513 $1,513 $1,664 $1,664 $1,664
Government (Comp) $2,188 $2,188 $2,188 $2,406 $2,406 $2,406 $2,647 $2,647 $2,647 $2,912 $2,912 $2,912
Supplies (Toner/Paper) $16,200 $16,200 $16,200 $17,820 $17,820 $17,820 $19,602 $19,602 $19,602 $21,562 $21,562 $21,562
Service - Agreements/Repairs $27,200 $27,200 $27,200 $29,920 $29,920 $29,920 $32,912 $32,912 $32,912 $36,203 $36,203 $36,203
Equipment Rentals $9,625 $9,625 $9,625 $10,588 $10,588 $10,588 $11,646 $11,646 $11,646 $12,811 $12,811 $12,811
Other $563 $563 $563 $619 $619 $619 $681 $681 $681 $749 $749 $749
Subtotal Direct Cost of Sales $116,325 $116,325 $117,575 $129,333 $129,333 $129,333 $142,266 $142,266 $142,266 $156,492 $156,492 $156,492
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Production Personnel
None planned $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales and Marketing Personnel
Alan Fukuyama - Sales (Maui) $3,000 $3,000 $3,000 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250
Brian Kurlansky - Sales (Kona) $3,000 $3,000 $3,000 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250
Jay Moore - Sales (Maui) $3,000 $3,000 $3,000 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250
Wilbert Shimabukuro - Sales (Hilo) $3,000 $3,000 $3,000 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250 $3,250
Vacant - Aftermarket Sales (Maui) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Vacant - Aftermarket Sales (Hilo) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $12,000 $12,000 $12,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000
General and Administrative Personnel
Bill Harding - General Manager $4,500 $4,500 $4,500 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900
Laurie Watson - Admin Manager $3,650 $3,650 $3,650 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850
Vacant - Office Manager (Hilo) $2,450 $2,450 $2,450 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650
Vacant - Whse & Delivery (Maui) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Vacant - Whse & Delivery (Hilo) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $10,600 $10,600 $10,600 $11,400 $11,400 $11,400 $11,400 $11,400 $11,400 $11,400 $11,400 $11,400
Other Personnel
Earle Oshiro - Systems Manager (Hilo) $4,000 $4,000 $4,000 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200
Joe Alfonsi - Systems Manager (Maui) $4,000 $4,000 $4,000 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200
Wane Ogawa - Syst Engineer (Hilo) $3,150 $3,150 $3,150 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350
Francis Takahashi - Syst Engineer (Hilo) $3,150 $3,150 $3,150 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350
Baron Ganeko - Syst Engineer (Kona) $3,150 $3,150 $3,150 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350 $3,350
Abe Braceros - Sr. Syst Engineer (Maui) $3,200 $3,200 $3,200 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Arlo Villanueva - Syst Tech (Maui) $2,250 $2,250 $2,250 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450
Caroline Nacua - Syst Tech (Maui) $2,250 $2,250 $2,250 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450
Vacant - Syst Tech (Kona) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Vacant - Syst Tech (Maui) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $25,150 $25,150 $25,150 $26,850 $26,850 $26,850 $26,850 $26,850 $26,850 $26,850 $26,850 $26,850
Total People 15 15 15 15 15 15 15 15 15 15 15 15
Total Payroll $47,750 $47,750 $47,750 $51,250 $51,250 $51,250 $51,250 $51,250 $51,250 $51,250 $51,250 $51,250
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.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% 38.00% 38.00% 38.00% 38.00% 38.00% 38.00% 38.00% 38.00% 38.00% 38.00% 38.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $227,000 $227,000 $229,500 $252,450 $252,450 $252,450 $277,695 $277,695 $277,695 $305,465 $305,465 $305,465
Direct Cost of Sales $116,325 $116,325 $117,575 $129,333 $129,333 $129,333 $142,266 $142,266 $142,266 $156,492 $156,492 $156,492
Production Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $116,325 $116,325 $117,575 $129,333 $129,333 $129,333 $142,266 $142,266 $142,266 $156,492 $156,492 $156,492
Gross Margin $110,675 $110,675 $111,925 $123,118 $123,118 $123,118 $135,429 $135,429 $135,429 $148,972 $148,972 $148,972
Gross Margin % 48.76% 48.76% 48.77% 48.77% 48.77% 48.77% 48.77% 48.77% 48.77% 48.77% 48.77% 48.77%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $12,000 $12,000 $12,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000
Advertising/Promotion $500 $500 $500 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Commissions $11,350 $11,350 $11,475 $12,623 $12,623 $12,623 $13,885 $13,885 $13,885 $15,273 $15,273 $15,273
Travel - Sales $1,500 $1,500 $1,500 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Learning & Growth - Sales $0 $0 $0 $400 $400 $400 $400 $400 $400 $1,250 $1,250 $1,250
Entertainment $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Total Sales and Marketing Expenses $25,800 $25,800 $25,925 $29,473 $29,473 $29,473 $30,735 $30,735 $30,735 $32,973 $32,973 $32,973
Sales and Marketing % 11.37% 11.37% 11.30% 11.67% 11.67% 11.67% 11.07% 11.07% 11.07% 10.79% 10.79% 10.79%
General and Administrative Expenses
General and Administrative Payroll $10,600 $10,600 $10,600 $11,400 $11,400 $11,400 $11,400 $11,400 $11,400 $11,400 $11,400 $11,400
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Telephone & ISP $2,850 $2,850 $2,850 $2,850 $2,850 $2,850 $2,850 $2,850 $2,850 $2,850 $2,850 $2,850
Office Supplies $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Insurance $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Bank Charges $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Postage $835 $835 $835 $835 $835 $835 $835 $835 $835 $835 $835 $835
Taxes & Licenses $850 $850 $850 $850 $850 $850 $850 $850 $850 $850 $850 $850
Bonuses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Learning & Growth - Admin $0 $0 $0 $150 $150 $150 $150 $150 $150 $750 $750 $750
Accounting $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Rent $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Payroll Taxes 30% $14,325 $14,325 $14,325 $15,375 $15,375 $15,375 $15,375 $15,375 $15,375 $15,375 $15,375 $15,375
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $38,960 $38,960 $38,960 $40,960 $40,960 $40,960 $40,960 $40,960 $40,960 $41,560 $41,560 $41,560
General and Administrative % 17.16% 17.16% 16.98% 16.22% 16.22% 16.22% 14.75% 14.75% 14.75% 13.61% 13.61% 13.61%
Other Expenses:
Other Payroll $25,150 $25,150 $25,150 $26,850 $26,850 $26,850 $26,850 $26,850 $26,850 $26,850 $26,850 $26,850
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Learning & Growth - Service $0 $0 $0 $850 $850 $850 $650 $650 $850 $1,500 $1,500 $1,500
Travel - Service $1,500 $1,500 $1,500 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Freight & Cartage $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Total Other Expenses $29,150 $29,150 $29,150 $32,200 $32,200 $32,200 $32,000 $32,000 $32,200 $32,850 $32,850 $32,850
Other % 12.84% 12.84% 12.70% 12.76% 12.76% 12.76% 11.52% 11.52% 11.60% 10.75% 10.75% 10.75%
Total Operating Expenses $93,910 $93,910 $94,035 $102,633 $102,633 $102,633 $103,695 $103,695 $103,895 $107,383 $107,383 $107,383
Profit Before Interest and Taxes $16,765 $16,765 $17,890 $20,485 $20,485 $20,485 $31,735 $31,735 $31,535 $41,589 $41,589 $41,589
EBITDA $16,765 $16,765 $17,890 $20,485 $20,485 $20,485 $31,735 $31,735 $31,535 $41,589 $41,589 $41,589
Interest Expense $11,667 $11,667 $11,667 $11,667 $11,667 $11,667 $11,667 $11,667 $11,667 $11,667 $11,667 $11,667
Taxes Incurred $1,530 $1,937 $2,365 $3,351 $3,351 $3,351 $7,626 $7,626 $7,550 $11,370 $11,370 $11,370
Net Profit $3,569 $3,161 $3,858 $5,467 $5,467 $5,467 $12,442 $12,442 $12,318 $18,552 $18,552 $18,552
Net Profit/Sales 1.57% 1.39% 1.68% 2.17% 2.17% 2.17% 4.48% 4.48% 4.44% 6.07% 6.07% 6.07%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $147,550 $147,550 $149,175 $164,093 $164,093 $164,093 $180,502 $180,502 $180,502 $198,552 $198,552 $198,552
Cash from Receivables $0 $2,648 $79,450 $79,479 $80,593 $88,358 $88,358 $88,652 $97,193 $97,193 $97,517 $106,913
Subtotal Cash from Operations $147,550 $150,198 $228,625 $243,572 $244,685 $252,450 $268,859 $269,154 $277,695 $295,745 $296,069 $305,465
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 $0 $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 $30,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $177,550 $150,198 $228,625 $243,572 $244,685 $252,450 $268,859 $269,154 $277,695 $295,745 $296,069 $305,465
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $47,750 $47,750 $47,750 $51,250 $51,250 $51,250 $51,250 $51,250 $51,250 $51,250 $51,250 $51,250
Bill Payments $3,455 $106,054 $176,195 $180,247 $208,235 $195,733 $196,816 $227,755 $214,007 $215,366 $250,790 $235,663
Subtotal Spent on Operations $51,205 $153,804 $223,945 $231,497 $259,485 $246,983 $248,066 $279,005 $265,257 $266,616 $302,040 $286,913
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $51,205 $153,804 $223,945 $231,497 $259,485 $246,983 $248,066 $279,005 $265,257 $266,616 $302,040 $286,913
Net Cash Flow $126,345 ($3,605) $4,680 $12,075 ($14,800) $5,467 $20,793 ($9,852) $12,438 $29,129 ($5,971) $18,552
Cash Balance $351,345 $347,740 $352,420 $364,495 $349,696 $355,163 $375,956 $366,105 $378,543 $407,672 $401,700 $420,252
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $225,000 $351,345 $347,740 $352,420 $364,495 $349,696 $355,163 $375,956 $366,105 $378,543 $407,672 $401,700 $420,252
Accounts Receivable $0 $79,450 $156,252 $157,127 $166,005 $173,770 $173,770 $182,606 $191,147 $191,147 $200,866 $210,261 $210,261
Inventory $200,000 $127,958 $127,958 $129,333 $142,266 $142,266 $142,266 $156,492 $156,492 $156,492 $172,142 $172,142 $172,142
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $425,000 $558,753 $631,949 $638,879 $672,766 $665,731 $671,199 $715,054 $713,744 $726,182 $780,679 $784,103 $802,655
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $425,000 $558,753 $631,949 $638,879 $672,766 $665,731 $671,199 $715,054 $713,744 $726,182 $780,679 $784,103 $802,655
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $0 $100,184 $170,219 $173,291 $201,710 $189,208 $189,208 $220,622 $206,870 $206,989 $242,935 $227,807 $227,807
Current Borrowing $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $1,000,000 $1,100,184 $1,170,219 $1,173,291 $1,201,710 $1,189,208 $1,189,208 $1,220,622 $1,206,870 $1,206,989 $1,242,935 $1,227,807 $1,227,807
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $1,000,000 $1,100,184 $1,170,219 $1,173,291 $1,201,710 $1,189,208 $1,189,208 $1,220,622 $1,206,870 $1,206,989 $1,242,935 $1,227,807 $1,227,807
Paid-in Capital $0 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
Retained Earnings ($575,000) ($575,000) ($575,000) ($575,000) ($575,000) ($575,000) ($575,000) ($575,000) ($575,000) ($575,000) ($575,000) ($575,000) ($575,000)
Earnings $0 $3,569 $6,730 $10,588 $16,056 $21,523 $26,990 $39,432 $51,874 $64,193 $82,744 $101,296 $119,848
Total Capital ($575,000) ($541,431) ($538,270) ($534,412) ($528,944) ($523,477) ($518,010) ($505,568) ($493,126) ($480,807) ($462,256) ($443,704) ($425,152)
Total Liabilities and Capital $425,000 $558,753 $631,949 $638,879 $672,766 $665,731 $671,199 $715,054 $713,744 $726,182 $780,679 $784,103 $802,655
Net Worth ($575,000) ($541,431) ($538,270) ($534,412) ($528,944) ($523,477) ($518,010) ($505,568) ($493,126) ($480,807) ($462,256) ($443,704) ($425,152)