Workwell
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) |