Our biggest savings of the year
Scan Lab
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 | |||||||||||||
X-ray | 0% | $0 | $0 | $5,500 | $8,565 | $10,005 | $12,454 | $13,121 | $14,005 | $14,989 | $15,114 | $15,265 | $15,274 |
Ultrasound | 0% | $0 | $0 | $3,245 | $5,053 | $5,903 | $7,348 | $7,741 | $8,263 | $8,844 | $8,917 | $9,006 | $9,012 |
CAT scan | 0% | $0 | $0 | $6,050 | $9,422 | $11,006 | $13,699 | $14,433 | $15,406 | $16,488 | $16,625 | $16,792 | $16,801 |
MRI | 0% | $0 | $0 | $3,894 | $6,064 | $7,084 | $8,817 | $9,290 | $9,916 | $10,612 | $10,701 | $10,808 | $10,814 |
Total Sales | $0 | $0 | $18,689 | $29,104 | $33,997 | $42,319 | $44,585 | $47,589 | $50,933 | $51,357 | $51,870 | $51,901 | |
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 | |
X-ray | $0 | $0 | $1,265 | $1,970 | $2,301 | $2,864 | $3,018 | $3,221 | $3,447 | $3,476 | $3,511 | $3,513 | |
Ultrasound | $0 | $0 | $746 | $1,162 | $1,358 | $1,690 | $1,781 | $1,900 | $2,034 | $2,051 | $2,071 | $2,073 | |
CAT scan | $0 | $0 | $1,392 | $2,167 | $2,531 | $3,151 | $3,320 | $3,543 | $3,792 | $3,824 | $3,862 | $3,864 | |
MRI | $0 | $0 | $896 | $1,395 | $1,629 | $2,028 | $2,137 | $2,281 | $2,441 | $2,461 | $2,486 | $2,487 | |
Subtotal Direct Cost of Sales | $0 | $0 | $4,298 | $6,694 | $7,819 | $9,733 | $10,255 | $10,945 | $11,715 | $11,812 | $11,930 | $11,937 |
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 | ||
Dr. Jones | 0% | $0 | $0 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
Technicians | 0% | $0 | $0 | $0 | $3,000 | $3,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
Other | 0% | $0 | $0 | $0 | $1,200 | $1,200 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 |
Total People | 0 | 0 | 0 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $0 | $0 | $6,000 | $10,200 | $10,200 | $14,400 | $14,400 | $14,400 | $14,400 | $14,400 | $14,400 | $14,400 |
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 | 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 | 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 | $0 | $0 | $18,689 | $29,104 | $33,997 | $42,319 | $44,585 | $47,589 | $50,933 | $51,357 | $51,870 | $51,901 | |
Direct Cost of Sales | $0 | $0 | $4,298 | $6,694 | $7,819 | $9,733 | $10,255 | $10,945 | $11,715 | $11,812 | $11,930 | $11,937 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $4,298 | $6,694 | $7,819 | $9,733 | $10,255 | $10,945 | $11,715 | $11,812 | $11,930 | $11,937 | |
Gross Margin | $0 | $0 | $14,391 | $22,410 | $26,178 | $32,585 | $34,331 | $36,644 | $39,218 | $39,545 | $39,940 | $39,964 | |
Gross Margin % | 0.00% | 0.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | 77.00% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $6,000 | $10,200 | $10,200 | $14,400 | $14,400 | $14,400 | $14,400 | $14,400 | $14,400 | $14,400 | |
Sales and Marketing and Other Expenses | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Depreciation | $14,358 | $14,358 | $14,358 | $14,358 | $14,358 | $14,358 | $14,358 | $14,358 | $14,358 | $14,358 | $14,358 | $14,358 | |
Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Utilities | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Insurance | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Payroll Taxes | 15% | $0 | $0 | $900 | $1,530 | $1,530 | $2,160 | $2,160 | $2,160 | $2,160 | $2,160 | $2,160 | $2,160 |
Other | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Total Operating Expenses | $19,058 | $19,058 | $25,958 | $30,788 | $30,788 | $35,618 | $35,618 | $35,618 | $35,618 | $35,618 | $35,618 | $35,618 | |
Profit Before Interest and Taxes | ($19,058) | ($19,058) | ($11,568) | ($8,378) | ($4,611) | ($3,033) | ($1,288) | $1,025 | $3,600 | $3,927 | $4,322 | $4,346 | |
EBITDA | ($4,700) | ($4,700) | $2,791 | $5,980 | $9,748 | $11,325 | $13,071 | $15,384 | $17,958 | $18,285 | $18,680 | $18,704 | |
Interest Expense | $7,083 | $7,000 | $6,917 | $6,833 | $6,750 | $6,667 | $6,583 | $6,500 | $6,417 | $6,333 | $6,250 | $6,167 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($26,142) | ($26,058) | ($18,484) | ($15,212) | ($11,361) | ($9,700) | ($7,871) | ($5,475) | ($2,817) | ($2,406) | ($1,928) | ($1,821) | |
Net Profit/Sales | 0.00% | 0.00% | -98.91% | -52.27% | -33.42% | -22.92% | -17.65% | -11.50% | -5.53% | -4.69% | -3.72% | -3.51% |
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 | $0 | $0 | $4,672 | $7,276 | $8,499 | $10,580 | $11,146 | $11,897 | $12,733 | $12,839 | $12,968 | $12,975 | |
Cash from Receivables | $0 | $0 | $0 | $467 | $14,277 | $21,950 | $25,706 | $31,796 | $33,514 | $35,775 | $38,210 | $38,531 | |
Subtotal Cash from Operations | $0 | $0 | $4,672 | $7,743 | $22,776 | $32,530 | $36,852 | $43,693 | $46,247 | $48,615 | $51,178 | $51,506 | |
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 | $0 | $0 | $4,672 | $7,743 | $22,776 | $32,530 | $36,852 | $43,693 | $46,247 | $48,615 | $51,178 | $51,506 | |
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 | $0 | $0 | $6,000 | $10,200 | $10,200 | $14,400 | $14,400 | $14,400 | $14,400 | $14,400 | $14,400 | $14,400 | |
Bill Payments | $393 | $11,781 | $11,871 | $16,913 | $19,792 | $20,881 | $23,275 | $23,718 | $24,328 | $24,992 | $25,007 | $25,038 | |
Subtotal Spent on Operations | $393 | $11,781 | $17,871 | $27,113 | $29,992 | $35,281 | $37,675 | $38,118 | $38,728 | $39,392 | $39,407 | $39,438 | |
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 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | |
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 | $10,393 | $21,781 | $27,871 | $37,113 | $39,992 | $45,281 | $47,675 | $48,118 | $48,728 | $49,392 | $49,407 | $49,438 | |
Net Cash Flow | ($10,393) | ($21,781) | ($23,198) | ($29,370) | ($17,216) | ($12,751) | ($10,822) | ($4,425) | ($2,481) | ($777) | $1,771 | $2,068 | |
Cash Balance | $307,507 | $285,727 | $262,528 | $233,158 | $215,943 | $203,191 | $192,369 | $187,944 | $185,462 | $184,685 | $186,456 | $188,525 |
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 | $317,900 | $307,507 | $285,727 | $262,528 | $233,158 | $215,943 | $203,191 | $192,369 | $187,944 | $185,462 | $184,685 | $186,456 | $188,525 |
Accounts Receivable | $0 | $0 | $0 | $14,017 | $35,377 | $46,598 | $56,387 | $64,120 | $68,016 | $72,701 | $75,444 | $76,137 | $76,532 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $317,900 | $307,507 | $285,727 | $276,545 | $268,536 | $262,541 | $259,578 | $256,489 | $255,960 | $258,164 | $260,130 | $262,593 | $265,057 |
Long-term Assets | |||||||||||||
Long-term Assets | $861,500 | $861,500 | $861,500 | $861,500 | $861,500 | $861,500 | $861,500 | $861,500 | $861,500 | $861,500 | $861,500 | $861,500 | $861,500 |
Accumulated Depreciation | $0 | $14,358 | $28,717 | $43,075 | $57,433 | $71,792 | $86,150 | $100,508 | $114,866 | $129,225 | $143,583 | $157,941 | $172,300 |
Total Long-term Assets | $861,500 | $847,142 | $832,783 | $818,425 | $804,067 | $789,709 | $775,350 | $760,992 | $746,634 | $732,275 | $717,917 | $703,559 | $689,200 |
Total Assets | $1,179,400 | $1,154,649 | $1,118,510 | $1,094,970 | $1,072,603 | $1,052,249 | $1,034,928 | $1,017,481 | $1,002,593 | $990,439 | $978,047 | $966,152 | $954,257 |
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 | $11,391 | $11,310 | $16,255 | $19,099 | $20,106 | $22,485 | $22,908 | $23,495 | $24,158 | $24,172 | $24,206 | $24,132 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $11,391 | $11,310 | $16,255 | $19,099 | $20,106 | $22,485 | $22,908 | $23,495 | $24,158 | $24,172 | $24,206 | $24,132 |
Long-term Liabilities | $860,000 | $850,000 | $840,000 | $830,000 | $820,000 | $810,000 | $800,000 | $790,000 | $780,000 | $770,000 | $760,000 | $750,000 | $740,000 |
Total Liabilities | $860,000 | $861,391 | $851,310 | $846,255 | $839,099 | $830,106 | $822,485 | $812,908 | $803,495 | $794,158 | $784,172 | $774,206 | $764,132 |
Paid-in Capital | $330,000 | $330,000 | $330,000 | $330,000 | $330,000 | $330,000 | $330,000 | $330,000 | $330,000 | $330,000 | $330,000 | $330,000 | $330,000 |
Retained Earnings | ($10,600) | ($10,600) | ($10,600) | ($10,600) | ($10,600) | ($10,600) | ($10,600) | ($10,600) | ($10,600) | ($10,600) | ($10,600) | ($10,600) | ($10,600) |
Earnings | $0 | ($26,142) | ($52,200) | ($70,684) | ($85,896) | ($97,257) | ($106,956) | ($114,827) | ($120,302) | ($123,119) | ($125,525) | ($127,453) | ($129,275) |
Total Capital | $319,400 | $293,258 | $267,200 | $248,716 | $233,504 | $222,143 | $212,444 | $204,573 | $199,098 | $196,281 | $193,875 | $191,947 | $190,125 |
Total Liabilities and Capital | $1,179,400 | $1,154,649 | $1,118,510 | $1,094,970 | $1,072,603 | $1,052,249 | $1,034,928 | $1,017,481 | $1,002,593 | $990,439 | $978,047 | $966,152 | $954,257 |
Net Worth | $319,400 | $293,258 | $267,200 | $248,716 | $233,504 | $222,143 | $212,444 | $204,573 | $199,098 | $196,281 | $193,875 | $191,947 | $190,125 |