Granite Industries, Inc.

Start your own business plan »

Chemical Laboratory Business Plan

Appendix

Sales Forecast
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Sales
Row 1 0% $69,525 $99,100 $125,175 $146,450 $164,425 $188,600 $201,650 $214,600 $222,150 $242,400 $264,400 $278,900
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $69,525 $99,100 $125,175 $146,450 $164,425 $188,600 $201,650 $214,600 $222,150 $242,400 $264,400 $278,900
Direct Cost of Sales Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Row 1 $29,200 $44,595 $52,573 $65,902 $75,635 $90,528 $96,792 $92,278 $95,524 $104,232 $111,048 $117,138
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $29,200 $44,595 $52,573 $65,902 $75,635 $90,528 $96,792 $92,278 $95,524 $104,232 $111,048 $117,138
Personnel Plan
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Manufacturing 0% $13,282 $13,282 $13,282 $15,760 $18,920 $18,920 $18,920 $19,500 $19,500 $19,500 $21,580 $21,580
Sales 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $15,000
Total People 6 6 6 6 6 6 6 9 9 9 9 11
Total Payroll $13,282 $13,282 $13,282 $15,760 $18,920 $18,920 $18,920 $19,500 $19,500 $19,500 $21,580 $36,580
General Assumptions
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
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 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Sales $69,525 $99,100 $125,175 $146,450 $164,425 $188,600 $201,650 $214,600 $222,150 $242,400 $264,400 $278,900
Direct Cost of Sales $29,200 $44,595 $52,573 $65,902 $75,635 $90,528 $96,792 $92,278 $95,524 $104,232 $111,048 $117,138
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $29,200 $44,595 $52,573 $65,902 $75,635 $90,528 $96,792 $92,278 $95,524 $104,232 $111,048 $117,138
Gross Margin $40,325 $54,505 $72,602 $80,548 $88,790 $98,072 $104,858 $122,322 $126,626 $138,168 $153,352 $161,762
Gross Margin % 58.00% 55.00% 58.00% 55.00% 54.00% 52.00% 52.00% 57.00% 57.00% 57.00% 58.00% 58.00%
Expenses
Payroll $13,282 $13,282 $13,282 $15,760 $18,920 $18,920 $18,920 $19,500 $19,500 $19,500 $21,580 $36,580
Sales and Marketing and Other Expenses $1,400 $1,400 $2,000 $2,500 $4,000 $1,500 $2,000 $1,500 $27,000 $27,500 $27,000 $7,000
Depreciation $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Leased Equipment $931 $931 $931 $931 $931 $931 $931 $931 $931 $931 $931 $931
Utilities $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Insurance $285 $285 $285 $285 $285 $285 $285 $310 $310 $310 $310 $310
Rent $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450
Payroll Taxes 15% $1,992 $1,992 $1,992 $2,364 $2,838 $2,838 $2,838 $2,925 $2,925 $2,925 $3,237 $5,487
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $24,340 $24,340 $24,940 $28,290 $33,424 $30,924 $31,424 $31,616 $57,116 $57,616 $59,508 $56,758
Profit Before Interest and Taxes $15,985 $30,165 $47,662 $52,258 $55,366 $67,148 $73,434 $90,706 $69,510 $80,552 $93,844 $105,004
EBITDA $18,985 $33,165 $50,662 $55,258 $58,366 $70,148 $76,434 $93,706 $72,510 $83,552 $96,844 $108,004
Interest Expense $2,785 $2,805 $2,825 $2,845 $2,865 $2,885 $2,905 $2,925 $2,945 $2,965 $2,985 $3,005
Taxes Incurred $3,300 $6,840 $11,209 $12,353 $13,125 $16,066 $17,632 $21,945 $16,641 $19,397 $22,715 $25,500
Net Profit $9,900 $20,520 $33,627 $37,060 $39,376 $48,197 $52,897 $65,836 $49,924 $58,190 $68,144 $76,500
Net Profit/Sales 14.24% 20.71% 26.86% 25.31% 23.95% 25.56% 26.23% 30.68% 22.47% 24.01% 25.77% 27.43%
Pro Forma Cash Flow
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Cash Received
Cash from Operations
Cash Sales $6,953 $9,910 $12,518 $14,645 $16,443 $18,860 $20,165 $21,460 $22,215 $24,240 $26,440 $27,890
Cash from Receivables $7,750 $9,836 $63,460 $89,972 $113,296 $132,344 $148,708 $170,132 $181,874 $193,367 $200,543 $218,820
Subtotal Cash from Operations $14,703 $19,746 $75,977 $104,617 $129,738 $151,204 $168,873 $191,592 $204,089 $217,607 $226,983 $246,710
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) $3,000 $2,500 $2,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
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 $75,000 $0 $0 $300,000 $0 $0 $0 $500,000 $0 $0 $0 $0
Subtotal Cash Received $97,703 $27,246 $82,977 $409,617 $134,738 $156,204 $173,873 $696,592 $209,089 $222,607 $231,983 $251,710
Expenditures Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Expenditures from Operations
Cash Spending $13,282 $13,282 $13,282 $15,760 $18,920 $18,920 $18,920 $19,500 $19,500 $19,500 $21,580 $36,580
Bill Payments $28,399 $57,345 $79,393 $84,750 $105,577 $114,537 $134,827 $133,309 $122,365 $153,896 $171,551 $178,851
Subtotal Spent on Operations $41,681 $70,627 $92,675 $100,510 $124,497 $133,457 $153,747 $152,809 $141,865 $173,396 $193,131 $215,431
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 $607 $607 $607 $607 $607 $607 $607 $607 $607 $607 $607 $614
Other Liabilities Principal Repayment $0 $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Long-term Liabilities Principal Repayment $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Purchase Other Current Assets $0 $0 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $0
Purchase Long-term Assets $0 $0 $0 $10,000 $10,000 $10,000 $10,000 $10,000 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $44,288 $73,234 $100,282 $119,117 $143,104 $152,064 $172,354 $171,416 $150,472 $182,003 $201,738 $219,045
Net Cash Flow $53,414 ($45,988) ($17,305) $290,500 ($8,366) $4,141 $1,519 $525,175 $58,616 $40,603 $30,244 $32,665
Cash Balance $65,414 $19,426 $2,121 $292,621 $284,256 $288,396 $289,915 $815,090 $873,706 $914,309 $944,554 $977,218
Pro Forma Balance Sheet
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Assets Starting Balances
Current Assets
Cash $12,000 $65,414 $19,426 $2,121 $292,621 $284,256 $288,396 $289,915 $815,090 $873,706 $914,309 $944,554 $977,218
Accounts Receivable $15,500 $70,323 $149,677 $198,875 $240,707 $275,394 $312,790 $345,567 $368,576 $386,637 $411,431 $448,848 $481,038
Inventory $18,873 $32,120 $49,055 $57,830 $72,492 $83,199 $99,581 $106,471 $101,506 $105,076 $114,655 $122,153 $128,852
Other Current Assets $0 $0 $0 $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 $35,000 $40,000 $45,000 $45,000
Total Current Assets $46,373 $167,857 $218,157 $263,826 $615,821 $657,848 $720,767 $766,953 $1,315,171 $1,400,420 $1,480,395 $1,560,554 $1,632,108
Long-term Assets
Long-term Assets $149,118 $149,118 $149,118 $149,118 $159,118 $169,118 $179,118 $189,118 $199,118 $199,118 $199,118 $199,118 $199,118
Accumulated Depreciation $23,605 $26,605 $29,605 $32,605 $35,605 $38,605 $41,605 $44,605 $47,605 $50,605 $53,605 $56,605 $59,605
Total Long-term Assets $125,513 $122,513 $119,513 $116,513 $123,513 $130,513 $137,513 $144,513 $151,513 $148,513 $145,513 $142,513 $139,513
Total Assets $171,886 $290,370 $337,670 $380,339 $739,334 $788,361 $858,280 $911,466 $1,466,684 $1,548,933 $1,625,908 $1,703,067 $1,771,621
Liabilities and Capital Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Current Liabilities
Accounts Payable $26,513 $54,704 $76,592 $81,240 $101,782 $110,041 $130,370 $129,266 $117,255 $148,187 $165,579 $173,201 $163,869
Current Borrowing $7,291 $6,684 $6,077 $5,470 $4,863 $4,256 $3,649 $3,042 $2,435 $1,828 $1,221 $614 $0
Other Current Liabilities $43,503 $46,503 $49,003 $51,003 $50,003 $49,003 $48,003 $47,003 $46,003 $45,003 $44,003 $43,003 $42,003
Subtotal Current Liabilities $77,307 $107,891 $131,672 $137,713 $156,648 $163,300 $182,022 $179,311 $165,693 $195,018 $210,803 $216,818 $205,872
Long-term Liabilities $324,550 $327,550 $330,550 $333,550 $336,550 $339,550 $342,550 $345,550 $348,550 $351,550 $354,550 $357,550 $360,550
Total Liabilities $401,857 $435,441 $462,222 $471,263 $493,198 $502,850 $524,572 $524,861 $514,243 $546,568 $565,353 $574,368 $566,422
Paid-in Capital $814,820 $889,820 $889,820 $889,820 $1,189,820 $1,189,820 $1,189,820 $1,189,820 $1,689,820 $1,689,820 $1,689,820 $1,689,820 $1,689,820
Retained Earnings ($877,599) ($1,044,791) ($1,044,791) ($1,044,791) ($1,044,791) ($1,044,791) ($1,044,791) ($1,044,791) ($1,044,791) ($1,044,791) ($1,044,791) ($1,044,791) ($1,044,791)
Earnings ($167,192) $9,900 $30,419 $64,047 $101,106 $140,482 $188,679 $241,576 $307,412 $357,336 $415,526 $483,671 $560,170
Total Capital ($229,971) ($145,071) ($124,552) ($90,924) $246,135 $285,511 $333,708 $386,605 $952,441 $1,002,365 $1,060,555 $1,128,700 $1,205,199
Total Liabilities and Capital $171,886 $290,370 $337,670 $380,339 $739,334 $788,361 $858,280 $911,466 $1,466,684 $1,548,933 $1,625,908 $1,703,067 $1,771,621
Net Worth ($229,971) ($145,071) ($124,552) ($90,924) $246,135 $285,511 $333,708 $386,605 $952,441 $1,002,365 $1,060,555 $1,128,700 $1,205,199