Workwell

Start your own business plan »

Occupational Health Business Plan

Appendix

Funding Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Funding
Employment Physicals 0% $34,861 $38,069 $45,071 $34,341 $26,803 $36,592 $36,492 $35,592 $33,592 $31,424 $36,592 $37,592
Drug Screenings 0% $2,318 $1,540 $2,202 $2,496 $3,301 $4,197 $4,315 $4,591 $4,489 $3,843 $3,897 $3,776
X-ray 0% $6,483 $7,013 $8,123 $11,377 $8,218 $8,711 $8,910 $7,171 $9,218 $8,816 $10,010 $10,310
Laboratory 0% $8,911 $11,593 $13,482 $12,038 $13,511 $15,956 $14,299 $13,071 $14,753 $13,613 $14,962 $15,723
Spirometry 0% $0 $25 $343 $35 $80 $87 $92 $83 $73 $88 $95 $92
Audiometry 0% $344 $312 $352 $354 $345 $394 $338 $402 $381 $372 $393 $407
Immunizations 0% $3,017 $4,657 $4,851 $2,042 $6,146 $4,743 $5,046 $4,146 $4,129 $5,146 $6,449 $6,267
BAT (Breath Alcohol Test) 0% $300 $275 $400 $200 $425 $435 $390 $494 $487 $584 $475 $498
Other 0% $1,968 $939 $4,596 $7,522 $3,542 $1,970 $2,523 $1,569 $1,649 $1,523 $1,678 $1,543
Total Funding $58,202 $64,423 $79,420 $70,405 $62,371 $73,085 $72,405 $67,119 $68,771 $65,409 $74,551 $76,208
Direct Cost of Funding Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Employment Physicals 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Drug Screenings 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
X-ray 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Laboratory 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Spirometry 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Audiometry 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Immunizations 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
BAT (Breath Alcohol Test) 0% $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 Cost of Funding $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Marketing Coordinator (1) 0% $0 $0 $0 $0 $0 $0 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083
Receptionist/Administrative/Clerical (1) 0% $1,513 $1,513 $1,513 $1,513 $1,513 $1,513 $1,513 $1,513 $1,513 $1,513 $1,513 $1,513
Nurse Aid (1) 0% $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300
Rad/Lab Tech (2) 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
LPNS (2) 0% $3,822 $3,822 $3,822 $3,822 $3,822 $3,822 $3,822 $3,822 $3,822 $3,822 $3,822 $3,822
Total People 10 10 10 10 10 10 10 10 10 10 10 10
Total Payroll $10,635 $10,635 $10,635 $10,635 $10,635 $10,635 $12,718 $12,718 $12,718 $12,718 $12,718 $12,718
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
Surplus and Deficit
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Funding $58,202 $64,423 $79,420 $70,405 $62,371 $73,085 $72,405 $67,119 $68,771 $65,409 $74,551 $76,208
Direct Cost $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 Direct Cost $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Surplus $58,202 $64,423 $79,420 $70,405 $62,371 $73,085 $72,405 $67,119 $68,771 $65,409 $74,551 $76,208
Gross Surplus % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll $10,635 $10,635 $10,635 $10,635 $10,635 $10,635 $12,718 $12,718 $12,718 $12,718 $12,718 $12,718
Sales and Marketing and Other Expenses $27,551 $27,551 $27,551 $27,551 $27,551 $27,551 $21,407 $21,407 $21,407 $21,407 $21,407 $21,407
Depreciation $945 $945 $945 $945 $945 $945 $945 $945 $945 $945 $945 $945
Utilities $1,029 $1,029 $1,029 $1,029 $1,029 $1,029 $1,029 $1,029 $1,029 $1,029 $1,029 $1,029
Rent $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Payroll Taxes 20% $2,127 $2,127 $2,127 $2,127 $2,127 $2,127 $2,544 $2,544 $2,544 $2,544 $2,544 $2,544
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $47,287 $47,287 $47,287 $47,287 $47,287 $47,287 $43,643 $43,643 $43,643 $43,643 $43,643 $43,643
Surplus Before Interest and Taxes $10,915 $17,136 $32,133 $23,118 $15,084 $25,798 $28,762 $23,476 $25,128 $21,766 $30,908 $32,565
EBITDA $11,860 $18,081 $33,078 $24,063 $16,029 $26,743 $29,707 $24,421 $26,073 $22,711 $31,853 $33,510
Interest Expense $7,572 $7,410 $7,248 $7,086 $6,924 $6,762 $6,600 $6,438 $6,276 $6,114 $5,952 $5,790
Taxes Incurred $836 $2,432 $6,221 $4,008 $2,040 $4,759 $5,541 $4,260 $4,713 $3,913 $6,239 $6,694
Net Surplus $2,507 $7,295 $18,664 $12,024 $6,120 $14,277 $16,622 $12,779 $14,140 $11,740 $18,718 $20,082
Net Surplus/Funding 4.31% 11.32% 23.50% 17.08% 9.81% 19.54% 22.96% 19.04% 20.56% 17.95% 25.11% 26.35%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Funding $14,551 $16,106 $19,855 $17,601 $15,593 $18,271 $18,101 $16,780 $17,193 $16,352 $18,638 $19,052
Cash from Receivables $74,128 $75,583 $43,807 $48,692 $59,340 $52,603 $47,046 $54,797 $54,172 $50,381 $51,494 $49,285
Subtotal Cash from Operations $88,678 $91,688 $63,662 $66,293 $74,932 $70,874 $65,147 $71,577 $71,364 $66,733 $70,132 $68,337
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $88,678 $91,688 $63,662 $66,293 $74,932 $70,874 $65,147 $71,577 $71,364 $66,733 $70,132 $68,337
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $10,635 $10,635 $10,635 $10,635 $10,635 $10,635 $12,718 $12,718 $12,718 $12,718 $12,718 $12,718
Bill Payments $10,506 $44,163 $45,669 $49,097 $46,730 $44,756 $47,058 $42,072 $40,687 $40,936 $40,079 $42,180
Subtotal Spent on Operations $21,141 $54,798 $56,304 $59,732 $57,365 $55,391 $59,776 $54,790 $53,405 $53,654 $52,797 $54,898
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 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000 $17,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $2,445 $2,445 $2,445 $2,445 $2,445 $2,445 $2,445 $2,445 $2,445 $2,445 $2,445 $2,445
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 $40,586 $74,243 $75,749 $79,177 $76,810 $74,836 $79,221 $74,235 $72,850 $73,099 $72,242 $74,343
Net Cash Flow $48,092 $17,446 ($12,087) ($12,884) ($1,878) ($3,962) ($14,073) ($2,658) ($1,485) ($6,367) ($2,110) ($6,006)
Cash Balance $56,529 $73,974 $61,887 $49,003 $47,126 $43,164 $29,091 $26,432 $24,947 $18,580 $16,471 $10,465
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $8,437 $56,529 $73,974 $61,887 $49,003 $47,126 $43,164 $29,091 $26,432 $24,947 $18,580 $16,471 $10,465
Accounts Receivable $148,255 $117,779 $90,514 $106,272 $110,383 $97,822 $100,033 $107,290 $102,833 $100,240 $98,916 $103,335 $111,205
Other Current Assets $184,531 $184,531 $184,531 $184,531 $184,531 $184,531 $184,531 $184,531 $184,531 $184,531 $184,531 $184,531 $184,531
Total Current Assets $341,223 $358,839 $349,019 $352,690 $343,918 $329,479 $327,728 $320,912 $313,796 $309,718 $302,027 $304,337 $306,202
Long-term Assets
Long-term Assets $120,579 $120,579 $120,579 $120,579 $120,579 $120,579 $120,579 $120,579 $120,579 $120,579 $120,579 $120,579 $120,579
Accumulated Depreciation $60,760 $61,705 $62,650 $63,595 $64,540 $65,485 $66,430 $67,375 $68,320 $69,265 $70,210 $71,155 $72,100
Total Long-term Assets $59,819 $58,874 $57,929 $56,984 $56,039 $55,094 $54,149 $53,204 $52,259 $51,314 $50,369 $49,424 $48,479
Total Assets $401,042 $417,713 $406,948 $409,674 $399,957 $384,573 $381,877 $374,116 $366,055 $361,032 $352,396 $353,761 $354,681
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $9,036 $42,644 $44,030 $47,537 $45,241 $43,182 $45,654 $40,716 $39,321 $39,603 $38,673 $40,765 $41,048
Current Borrowing $634,601 $617,601 $600,601 $583,601 $566,601 $549,601 $532,601 $515,601 $498,601 $481,601 $464,601 $447,601 $430,601
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $643,637 $660,245 $644,631 $631,138 $611,842 $592,783 $578,255 $556,317 $537,922 $521,204 $503,274 $488,366 $471,649
Long-term Liabilities $293,480 $291,035 $288,590 $286,145 $283,700 $281,255 $278,810 $276,365 $273,920 $271,475 $269,030 $266,585 $264,140
Total Liabilities $937,117 $951,280 $933,221 $917,283 $895,542 $874,038 $857,065 $832,682 $811,842 $792,679 $772,304 $754,951 $735,789
Paid-in Capital $293,480 $293,480 $293,480 $293,480 $293,480 $293,480 $293,480 $293,480 $293,480 $293,480 $293,480 $293,480 $293,480
Accumulated Surplus/Deficit ($611,473) ($829,555) ($829,555) ($829,555) ($829,555) ($829,555) ($829,555) ($829,555) ($829,555) ($829,555) ($829,555) ($829,555) ($829,555)
Surplus/Deficit ($218,082) $2,507 $9,802 $28,466 $40,490 $46,610 $60,887 $77,509 $90,288 $104,428 $116,167 $134,885 $154,967
Total Capital ($536,075) ($533,568) ($526,273) ($507,609) ($495,585) ($489,465) ($475,188) ($458,566) ($445,787) ($431,647) ($419,908) ($401,190) ($381,108)
Total Liabilities and Capital $401,042 $417,713 $406,948 $409,674 $399,957 $384,573 $381,877 $374,116 $366,055 $361,032 $352,396 $353,761 $354,681
Net Worth ($536,075) ($533,568) ($526,273) ($507,609) ($495,585) ($489,465) ($475,188) ($458,566) ($445,787) ($431,647) ($419,908) ($401,190) ($381,108)