Fargo Medical Laboratories (FML) is a start-up company committed to providing the most convenient, friendliest blood testing service to the physicians of the Main Street Professional Building and the surrounding area. Fargo Medical Laboratories has been founded as a single member L.L.C. registered in North Dakota by Dave Gigsted. Fargo Medical Laboratories will quickly gain market share serving the Fargo medical community.
Objectives
Fargo Medical Laboratories has established three significant objectives to pursue. The first is securing 60% of the physicians in the Main Street Professional Building as customers. The second objective is to develop 20% of their revenue from physicians who practice in the nearby vicinity. The third objective is the desire to reach profitability with 12 months. This is especially important since Fargo Medical Laboratories will be using bank debt would like to see a positive ROI fairly soon.
Market
Fargo Medical Laboratories has identified two market segments they will serve. First is the large number of physicians that have a practice in the Main Street Professional Building, where Fargo Medical Laboratories will lease space. This customer segment has 128 potential customers with a growth rate of 3%. The second group is physicians that have medical practices in other nearby facilities. There are 115 potential customers in this segment with a 5% annual growth rate.
Services
Fargo Medical Laboratories offers a comprehensive battery of blood tests for physician’s patients. Several tests will be done in-house including:
Other types of blood analysis can be done with the specimen sent to a central lab for testing.
Management
Fargo Medical Laboratories has been founded and will be led by Dave Gigsted. Dave received an undergraduate degree in small business management. After graduation Dave got his laboratory technician certification and went to work for a laboratory. He was eventually elevated to lab manager, staying with the lab for five years.
Dave then moved with his wife to Fargo where he worked for a year in a lab. Surveying the business environment with the thought of opening up his own blood laboratory, he recognized the great need for a lab in the Main Street Professional Building, and developed a plan and secured financing for the venture.
It is Fargo Medical Laboratories’ mission to serve local physicians with fast, accurate, private, reasonably priced blood testing services. Fargo Medical Laboratories exists to exceed all of their customer’s expectations.
Discover the simplest way to create detailed graphs for your business plan.
Fargo Medical Laboratories has been formed as an L.L.C., registered in North Dakota. Fargo Medical Laboratories is a single member entity owned by Dave Gigsted. Fargo Medical Laboratories will lease office space in the Main Street Professional Building. This building has over 120 offices, 93 of which are leased by medical professionals. Of the 93, a high percentage of those are primary care physicians or general practitioners. There currently is no laboratory within this professional building, and doctors are forced to send their patients across town to have blood drawn and analyzed.
The owner of Fargo Medical Laboratories is Dave Gigsted. Dave has received bank debt financing and will have a long term loan to pay off.
Fargo Medical Laboratories will require the following equipment for the start up of the business:
Start-up Funding | |
Start-up Expenses to Fund | $5,000 |
Start-up Assets to Fund | $165,000 |
Total Funding Required | $170,000 |
Assets | |
Non-cash Assets from Start-up | $73,000 |
Cash Requirements from Start-up | $92,000 |
Additional Cash Raised | $0 |
Cash Balance on Starting Date | $92,000 |
Total Assets | $165,000 |
Liabilities and Capital | |
Liabilities | |
Current Borrowing | $0 |
Long-term Liabilities | $170,000 |
Accounts Payable (Outstanding Bills) | $0 |
Other Current Liabilities (interest-free) | $0 |
Total Liabilities | $170,000 |
Capital | |
Planned Investment | |
Investor 1 | $0 |
Investor 2 | $0 |
Other | $0 |
Additional Investment Requirement | $0 |
Total Planned Investment | $0 |
Loss at Start-up (Start-up Expenses) | ($5,000) |
Total Capital | ($5,000) |
Total Capital and Liabilities | $165,000 |
Total Funding | $170,000 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
Start-up | |
Requirements | |
Start-up Expenses | |
Legal | $1,000 |
Stationery etc. | $0 |
Brochures | $500 |
Consultants | $0 |
Insurance | $500 |
Rent | $1,000 |
Research and Development | $0 |
Expensed Equipment | $2,000 |
Other | $0 |
Total Start-up Expenses | $5,000 |
Start-up Assets | |
Cash Required | $92,000 |
Other Current Assets | $0 |
Long-term Assets | $73,000 |
Total Assets | $165,000 |
Total Requirements | $170,000 |
Fargo Medical Laboratories offers routine blood tests on-site and more complex blood tests outsourced to a central lab. FML will be located inside the Main Street Professional Building which is home to numerous physicians. Currently, when the doctors need blood work done, they have to send their patients to an off-site laboratory, a 15 minute drive from the doctor’s office.
Once Fargo Medical Laboratories is up an running the doctors will be able to send their patients to FML’s offices, within the building. For simple tests Fargo Medical Laboratories will do the analysis in-house, for more complex blood work the specimens will be sent to an outsourced central laboratory.
The advantages to the physicians and their patients include: convenience (blood can be drawn within the same building), and faster service (there is no driving or transportation time to get the blood drawn), and for the most commonly requested tests the analysis occurs in-house guaranteeing results within 24 hours.
Fargo Medical Laboratories will offer the following tests in-house:
If more extensive blood work is needed, blood with be drawn in our offices and sent to a central laboratory. Fargo Medical Laboratories will use a courier service that transports the samples in an ice cooler. The specimens are tested within 24-36 hours of receipt at the central lab and the results are returned to FML via encrypted email.
Fargo Medical Laboratories has identified two market segments. The first segment is the physicians that practice within the same professional building as FML. The second group is comprised of physicians that practice in the surrounding area.
Fargo Medical Laboratories will provide services geared to two distinct customer segments.
Market Analysis | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
Potential Customers | Growth | CAGR | |||||
Main Street building physicians | 3% | 128 | 132 | 136 | 140 | 144 | 2.99% |
Nearby physicians | 5% | 115 | 121 | 127 | 133 | 140 | 5.04% |
Total | 3.97% | 243 | 253 | 263 | 273 | 284 | 3.97% |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
It is fairly intuitive as to why physicians within the Main Street Professional Building will be targeted, they are the customers who would have the most demand for Fargo Medical Laboratories’ services. Almost all types of doctors regularly have patients who need blood testing done. Assuming that the lab accepts most of the common types of medical insurance, the lab is generally chosen by being the most convenient for the patient since they are the ones who must travel to the lab to have the blood drawn.
For physicians who work within the Main Street Professional Building, Fargo Medical Laboratories would be the most convenient laboratory, being located within the same building as the physician’s offices. No longer would the doctor have to ask the patient to travel to have blood drawn. For the second target market, the nearby physicians, the reasoning is similar, convenience for the patients. While it is not quite as convenient as sending the patient to another office within the same building, Fargo Medical Laboratories would still be closer than the current lab.
Blood laboratories all provide similar services. Most accept a wide range of insurance plans. Some do the tests in-house, others will outsource the tests. Where the tests are completed is not really that significant. To be competitive the labs need to have the tests completed within a couple of days at the most. This means it all comes down to convenience. Labs serve the physicians and doctors that are closest in terms of geographic proximity. In most cities/towns, you will see labs placed throughout the city serving the different clusters of physicians.
Fargo is different, or at least Main Street is. Main Street Professional Building has for years been trying to have a laboratory locate within the building to serve the large population of doctors. The trouble has been that South Dakota is experiencing an exodus of people. As college students have completed school, they have left the state. Fargo has had difficulty attracting qualified technical people, in this instance phlebotomists (blood drawing technicians) and chemical analyzers. This is the explanation for the absence of a blood laboratory in the Main Street Professional Building. The need has existed, just no one has “stepped up to the plate”, at least not until now.
In Fargo, there is a total of seven blood drawing laboratories. Of the seven, two only serve their specific clients and do not do work for other physicians. Of the remaining five, three offer basic tests done on-site, like Fargo Medical Laboratories, and the remaining two are full service laboratories that do work complex for the other labs.
The closest competitor to Fargo Medical Laboratories is Mednet, located four miles away. This is the facility that 95% of the physicians in the Main Street Professional Building currently use. It is used by these physicians because of convenience, it WAS the closest laboratory. As mentioned earlier, blood testing service providers are chosen based on convenience, how close they are to the patients. Hours of operation (i.e. longer hours/evening hours) are insignificant since physicians are only available during traditional daytime office hours.
Fargo Medical Laboratories will leverage their competitive edge of a convenient location within a large medical facility to help it quickly gain market share. FML has developed a strategic marketing plan that will use several different methods to develop local awareness of itself and the benefits offered. Fargo Medical Laboratories has also developed a sales strategy to help turn the qualified leads into clients by emphasizing the significant benefits that physicians can offer their patients by sending them to Fargo Medical Laboratories. Sections 5.1-5.3 offers more detail regarding the competitive edge, marketing and sales strategies.
Fargo Medical Laboratories’ competitive edge is convenience. In the blood analysis industry it is hard to differentiate yourself from competitors assuming a few basic levels of care and performance:
If these basic, foundational levels of performance are met, then you are competitive. This is why convenience is so important and why it is an effective way of distinguishing one lab from another. The physician is looking for a way to get a blood sample from a patient that is easiest from the patient’s perspective.
Other factors include maintaining a high level of customer satisfaction. If these were not met it would not “kill the deal” but would decrease sales. Here are some important customer service elements that all employees of Fargo Medical Laboratories will emphasize:
These customer service factors will certainly be taught to all employees to ensure the most positive patient experience.
To develop good business strategies, perform a SWOT analysis of your business. It's easy with our free guide and template. Learn how to perform a SWOT analysis
Fargo Medical Laboratories will undertake a marketing strategy employing three means of communicating its new service offering:
Fargo Medical Laboratories’ sales strategy will be used to convert a qualified lead into a client by emphasizing three important services:
Fargo Medical Laboratories had developed a conservative sales forecast for the three years of this business plan. A conservative forecast was chosen because the venture is being funded by bank debt, which is fairly risk-averse, and therefore, it is in Fargo Medical Laboratories’ best interests if they are able to meet the monthly sales goals. If the forecast was more aggressive it would be far easier for FML to miss sales targets and find themselves hurting financially due to inaccurate assumptions and forecasts. This would then cast doubt on the survival of the business.
Sales Forecast | |||
Year 1 | Year 2 | Year 3 | |
Sales | |||
Professional building physicians | $81,778 | $210,545 | $232,545 |
Nearby physicians | $16,356 | $42,109 | $46,509 |
Total Sales | $98,134 | $252,654 | $279,054 |
Direct Cost of Sales | Year 1 | Year 2 | Year 3 |
Professional building physicians | $28,622 | $73,691 | $81,391 |
Nearby physicians | $5,724 | $14,738 | $16,278 |
Subtotal Direct Cost of Sales | $34,347 | $88,429 | $97,669 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
Fargo Medical Laboratories has identified several milestones for the organization to achieve. The achievement of the milestones will be instrumental in the success of the the venture. By enumerating the milestones it provides the organization with clear goals that everyone can focus their energy on.
Milestones | |||||
Milestone | Start Date | End Date | Budget | Manager | Department |
Completion of business plan | 1/1/2003 | 2/1/2003 | $0 | Dave | Business development |
Secure lease | 1/1/2003 | 2/15/2003 | $0 | Dave | Operations |
Conversion of 50% of in-house drs into customers | 2/15/2003 | 10/15/2003 | $0 | Dave | Sales |
Profitability | 10/15/2003 | 12/15/2003 | $0 | Dave | Everyone |
Revenue of $100,000 | 12/15/2003 | 2/1/2004 | $0 | Dave | Sales |
Totals | $0 |
Dave Gigsted is the founder and manager of Fargo Medical Laboratories. Dave received his undergraduate degree in Small Business Management from the University of Illinois. While in college, Dave worked at a bicycle shop, initially as a mechanic, moving up to assistant manager by the time he graduated. This provided him with hands-on business experience to combine with his business degree.
Upon graduation, Dave began his job search, including opportunities in the medical profession. His mother and aunt are both registered nurses who shared with Dave that, at that time in Illinois, lab technicians were in short supply. So Dave enrolled in an eight-month program through the community college for a degree in Laboratory Technology. After completing this degree, Dave went to work at a laboratory. Within two years, he had been promoted to Lab Manager. Dave found this work challenging, enjoyed the medical aspect and worked hard in the business end of the job.
After five years, Dave and his wife moved to Fargo for a job opportunity for his wife. He immediately began working at a laboratory and worked there for a year. During this time Dave began looking into different business opportunities, recognizing that he had now developed sufficient business skills to operate his own business. Dave found there was a high concentration of physicians in a professional building with no nearby lab. In talking with people, he learned the physicians were looking for a lab to relocate to the building but but had been unable to find any. Armed with this information, Dave began to draft a business plan confident that with a solid strategy and comprehensive plan he would be able to find financing and begin his new venture.
Personnel Plan | |||
Year 1 | Year 2 | Year 3 | |
Dave | $22,000 | $28,000 | $32,000 |
Phlebotomist | $16,500 | $18,000 | $18,000 |
Phlebotomist | $15,000 | $18,000 | $18,000 |
Lab technician | $22,000 | $24,000 | $24,000 |
Total People | 4 | 4 | 4 |
Total Payroll | $75,500 | $88,000 | $92,000 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
The following sections will outline important financial information.
The following table includes important financial assumptions.
General Assumptions | |||
Year 1 | Year 2 | Year 3 | |
Plan Month | 1 | 2 | 3 |
Current Interest Rate | 10.00% | 10.00% | 10.00% |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% |
Tax Rate | 30.00% | 30.00% | 30.00% |
Other | 0 | 0 | 0 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
The Break-even Analysis indicates what will be needed in monthly revenue to reach the break even point.
Break-even Analysis | |
Monthly Revenue Break-even | $15,388 |
Assumptions: | |
Average Percent Variable Cost | 35% |
Estimated Monthly Fixed Cost | $10,002 |
The following chart provides business ratios for Fargo Medical Laboratories as well as for the blood-related health industry, SIC Code 8099.01. Fargo Medical Laboratories’ ratios are consistent with the industry, with the exception of liabilities because it is a start-up organization that is relying on financing for its start-up costs.
Ratio Analysis | ||||
Year 1 | Year 2 | Year 3 | Industry Profile | |
Sales Growth | 0.00% | 157.46% | 10.45% | 7.73% |
Percent of Total Assets | ||||
Accounts Receivable | 28.45% | 57.95% | 60.94% | 28.59% |
Other Current Assets | 0.00% | 0.00% | 0.00% | 42.01% |
Total Current Assets | 35.47% | 61.72% | 75.71% | 72.68% |
Long-term Assets | 64.53% | 38.28% | 24.29% | 27.32% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 11.14% | 10.18% | 10.66% | 36.54% |
Long-term Liabilities | 174.60% | 127.62% | 111.54% | 22.81% |
Total Liabilities | 185.74% | 137.80% | 122.20% | 59.35% |
Net Worth | -85.74% | -37.80% | -22.20% | 40.65% |
Percent of Sales | ||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 65.00% | 65.00% | 65.00% | 100.00% |
Selling, General & Administrative Expenses | 138.75% | 61.53% | 58.82% | 81.83% |
Advertising Expenses | 0.00% | 0.00% | 0.00% | 1.10% |
Profit Before Interest and Taxes | -57.31% | 10.73% | 13.50% | 0.61% |
Main Ratios | ||||
Current | 3.18 | 6.06 | 7.10 | 1.64 |
Quick | 3.18 | 6.06 | 7.10 | 1.32 |
Total Debt to Total Assets | 185.74% | 137.80% | 122.20% | 0.81% |
Pre-tax Return on Net Worth | 93.56% | -27.56% | -88.79% | 66.74% |
Pre-tax Return on Assets | -80.22% | 10.42% | 19.71% | 2.43% |
Additional Ratios | Year 1 | Year 2 | Year 3 | |
Net Profit Margin | -73.97% | 3.30% | 5.94% | n.a |
Return on Equity | 0.00% | 0.00% | 0.00% | n.a |
Activity Ratios | ||||
Accounts Receivable Turnover | 2.86 | 2.86 | 2.86 | n.a |
Collection Days | 54 | 89 | 122 | n.a |
Accounts Payable Turnover | 7.99 | 12.17 | 12.17 | n.a |
Payment Days | 27 | 28 | 29 | n.a |
Total Asset Turnover | 1.08 | 2.21 | 2.32 | n.a |
Debt Ratios | ||||
Debt to Net Worth | 0.00 | 0.00 | 0.00 | n.a |
Current Liab. to Liab. | 0.06 | 0.07 | 0.09 | n.a |
Liquidity Ratios | ||||
Net Working Capital | $22,012 | $58,961 | $78,141 | n.a |
Interest Coverage | -3.44 | 1.78 | 2.69 | n.a |
Additional Ratios | ||||
Assets to Sales | 0.92 | 0.45 | 0.43 | n.a |
Current Debt/Total Assets | 11% | 10% | 11% | n.a |
Acid Test | 0.63 | 0.37 | 1.38 | n.a |
Sales/Net Worth | 0.00 | 0.00 | 0.00 | n.a |
Dividend Payout | 0.00 | 0.00 | 0.00 | n.a |
The following table will show annual projected profit and loss. A net loss will occur the first year, with well developed profit in year two and year three.
Pro Forma Profit and Loss | |||
Year 1 | Year 2 | Year 3 | |
Sales | $98,134 | $252,654 | $279,054 |
Direct Cost of Sales | $34,347 | $88,429 | $97,669 |
Other Costs of Sales | $0 | $0 | $0 |
Total Cost of Sales | $34,347 | $88,429 | $97,669 |
Gross Margin | $63,787 | $164,225 | $181,385 |
Gross Margin % | 65.00% | 65.00% | 65.00% |
Expenses | |||
Payroll | $75,500 | $88,000 | $92,000 |
Sales and Marketing and Other Expenses | $2,400 | $3,000 | $3,500 |
Depreciation | $14,604 | $14,604 | $14,604 |
Rent | $12,000 | $13,500 | $14,500 |
Utilities | $1,800 | $1,800 | $1,800 |
Insurance | $2,400 | $3,000 | $3,500 |
Payroll Taxes | $11,325 | $13,200 | $13,800 |
Other | $0 | $0 | $0 |
Total Operating Expenses | $120,029 | $137,104 | $143,704 |
Profit Before Interest and Taxes | ($56,242) | $27,121 | $37,681 |
EBITDA | ($41,638) | $41,725 | $52,285 |
Interest Expense | $16,350 | $15,200 | $14,000 |
Taxes Incurred | $0 | $3,576 | $7,104 |
Net Profit | ($72,592) | $8,345 | $16,577 |
Net Profit/Sales | -73.97% | 3.30% | 5.94% |
The following chart and table describe the projected cash flow. Because we will have a large starting balance because of our initial bank loan, our cash flow should be strong enough to cover our expenses as the business becomes established. The only concern will be to monitor the accounts receivable balances, since the majority of our revenue will be in receivables.
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $24,533 | $63,164 | $69,764 |
Cash from Receivables | $47,853 | $148,948 | $202,364 |
Subtotal Cash from Operations | $72,386 | $212,112 | $272,127 |
Additional Cash Received | |||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 |
New Current Borrowing | $0 | $0 | $0 |
New Other Liabilities (interest-free) | $0 | $0 | $0 |
New Long-term Liabilities | $0 | $0 | $0 |
Sales of Other Current Assets | $0 | $0 | $0 |
Sales of Long-term Assets | $0 | $0 | $0 |
New Investment Received | $0 | $26,000 | $0 |
Subtotal Cash Received | $72,386 | $238,112 | $272,127 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $75,500 | $88,000 | $92,000 |
Bill Payments | $70,537 | $140,143 | $154,709 |
Subtotal Spent on Operations | $146,037 | $228,143 | $246,709 |
Additional Cash Spent | |||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 |
Principal Repayment of Current Borrowing | $0 | $0 | $0 |
Other Liabilities Principal Repayment | $0 | $0 | $0 |
Long-term Liabilities Principal Repayment | $12,000 | $12,000 | $12,000 |
Purchase Other Current Assets | $0 | $0 | $0 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $158,037 | $240,143 | $258,709 |
Net Cash Flow | ($85,651) | ($2,031) | $13,419 |
Cash Balance | $6,349 | $4,318 | $17,737 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
The following table will indicate the projected balance sheet. We will achieve positive Net Worth in the second and third years.
Pro Forma Balance Sheet | |||
Year 1 | Year 2 | Year 3 | |
Assets | |||
Current Assets | |||
Cash | $6,349 | $4,318 | $17,737 |
Accounts Receivable | $25,748 | $66,290 | $73,216 |
Other Current Assets | $0 | $0 | $0 |
Total Current Assets | $32,097 | $70,608 | $90,953 |
Long-term Assets | |||
Long-term Assets | $73,000 | $73,000 | $73,000 |
Accumulated Depreciation | $14,604 | $29,208 | $43,812 |
Total Long-term Assets | $58,396 | $43,792 | $29,188 |
Total Assets | $90,493 | $114,400 | $120,141 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $10,085 | $11,647 | $12,811 |
Current Borrowing | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 |
Subtotal Current Liabilities | $10,085 | $11,647 | $12,811 |
Long-term Liabilities | $158,000 | $146,000 | $134,000 |
Total Liabilities | $168,085 | $157,647 | $146,811 |
Paid-in Capital | $0 | $26,000 | $26,000 |
Retained Earnings | ($5,000) | ($77,592) | ($69,247) |
Earnings | ($72,592) | $8,345 | $16,577 |
Total Capital | ($77,592) | ($43,247) | ($26,671) |
Total Liabilities and Capital | $90,493 | $114,400 | $120,141 |
Net Worth | ($77,592) | ($43,247) | ($26,671) |
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 | |||||||||||||
Professional building physicians | 0% | $0 | $2,500 | $3,565 | $4,245 | $4,989 | $5,353 | $5,978 | $6,874 | $8,989 | $10,225 | $13,545 | $15,515 |
Nearby physicians | 0% | $0 | $500 | $713 | $849 | $998 | $1,071 | $1,196 | $1,375 | $1,798 | $2,045 | $2,709 | $3,103 |
Total Sales | $0 | $3,000 | $4,278 | $5,094 | $5,987 | $6,424 | $7,174 | $8,249 | $10,787 | $12,270 | $16,254 | $18,618 | |
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 | |
Professional building physicians | $0 | $875 | $1,248 | $1,486 | $1,746 | $1,874 | $2,092 | $2,406 | $3,146 | $3,579 | $4,741 | $5,430 | |
Nearby physicians | $0 | $175 | $250 | $297 | $349 | $375 | $418 | $481 | $629 | $716 | $948 | $1,086 | |
Subtotal Direct Cost of Sales | $0 | $1,050 | $1,497 | $1,783 | $2,095 | $2,248 | $2,511 | $2,887 | $3,775 | $4,295 | $5,689 | $6,516 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
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 | ||
Dave | 0% | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Phlebotomist | 0% | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
Phlebotomist | 0% | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
Lab technician | 0% | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Total People | 0 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
Total Payroll | $0 | $5,500 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 |
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 | $3,000 | $4,278 | $5,094 | $5,987 | $6,424 | $7,174 | $8,249 | $10,787 | $12,270 | $16,254 | $18,618 | |
Direct Cost of Sales | $0 | $1,050 | $1,497 | $1,783 | $2,095 | $2,248 | $2,511 | $2,887 | $3,775 | $4,295 | $5,689 | $6,516 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $1,050 | $1,497 | $1,783 | $2,095 | $2,248 | $2,511 | $2,887 | $3,775 | $4,295 | $5,689 | $6,516 | |
Gross Margin | $0 | $1,950 | $2,781 | $3,311 | $3,891 | $4,175 | $4,663 | $5,362 | $7,011 | $7,976 | $10,565 | $12,102 | |
Gross Margin % | 0.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | 65.00% | |
Expenses | |||||||||||||
Payroll | $0 | $5,500 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | |
Sales and Marketing and Other Expenses | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Depreciation | $1,217 | $1,217 | $1,217 | $1,217 | $1,217 | $1,217 | $1,217 | $1,217 | $1,217 | $1,217 | $1,217 | $1,217 | |
Rent | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Utilities | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Payroll Taxes | 15% | $0 | $825 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $2,767 | $9,092 | $10,817 | $10,817 | $10,817 | $10,817 | $10,817 | $10,817 | $10,817 | $10,817 | $10,817 | $10,817 | |
Profit Before Interest and Taxes | ($2,767) | ($7,142) | ($8,036) | ($7,506) | ($6,926) | ($6,642) | ($6,154) | ($5,455) | ($3,806) | ($2,842) | ($252) | $1,285 | |
EBITDA | ($1,550) | ($5,925) | ($6,819) | ($6,289) | ($5,709) | ($5,425) | ($4,937) | ($4,238) | ($2,589) | ($1,625) | $965 | $2,502 | |
Interest Expense | $1,408 | $1,400 | $1,392 | $1,383 | $1,375 | $1,367 | $1,358 | $1,350 | $1,342 | $1,333 | $1,325 | $1,317 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($4,175) | ($8,542) | ($9,428) | ($8,889) | ($8,301) | ($8,008) | ($7,512) | ($6,805) | ($5,147) | ($4,175) | ($1,577) | ($32) | |
Net Profit/Sales | 0.00% | -284.73% | -220.38% | -174.50% | -138.65% | -124.67% | -104.72% | -82.50% | -47.72% | -34.02% | -9.70% | -0.17% |
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 | $750 | $1,070 | $1,274 | $1,497 | $1,606 | $1,793 | $2,062 | $2,697 | $3,068 | $4,064 | $4,655 | |
Cash from Receivables | $0 | $0 | $75 | $2,282 | $3,229 | $3,843 | $4,501 | $4,836 | $5,407 | $6,250 | $8,127 | $9,302 | |
Subtotal Cash from Operations | $0 | $750 | $1,145 | $3,555 | $4,726 | $5,449 | $6,294 | $6,899 | $8,104 | $9,318 | $12,191 | $13,957 | |
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 | $750 | $1,145 | $3,555 | $4,726 | $5,449 | $6,294 | $6,899 | $8,104 | $9,318 | $12,191 | $13,957 | |
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 | $5,500 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | |
Bill Payments | $99 | $3,021 | $4,847 | $5,498 | $5,776 | $6,075 | $6,223 | $6,481 | $6,866 | $7,734 | $8,274 | $9,641 | |
Subtotal Spent on Operations | $99 | $8,521 | $11,847 | $12,498 | $12,776 | $13,075 | $13,223 | $13,481 | $13,866 | $14,734 | $15,274 | $16,641 | |
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 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,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 | $1,099 | $9,521 | $12,847 | $13,498 | $13,776 | $14,075 | $14,223 | $14,481 | $14,866 | $15,734 | $16,274 | $17,641 | |
Net Cash Flow | ($1,099) | ($8,771) | ($11,703) | ($9,943) | ($9,051) | ($8,626) | ($7,929) | ($7,583) | ($6,763) | ($6,417) | ($4,083) | ($3,685) | |
Cash Balance | $90,901 | $82,131 | $70,428 | $60,485 | $51,435 | $42,808 | $34,879 | $27,297 | $20,534 | $14,117 | $10,034 | $6,349 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
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 | $92,000 | $90,901 | $82,131 | $70,428 | $60,485 | $51,435 | $42,808 | $34,879 | $27,297 | $20,534 | $14,117 | $10,034 | $6,349 |
Accounts Receivable | $0 | $0 | $2,250 | $5,384 | $6,922 | $8,183 | $9,158 | $10,037 | $11,387 | $14,070 | $17,023 | $21,086 | $25,748 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $92,000 | $90,901 | $84,381 | $75,812 | $67,407 | $59,618 | $51,966 | $44,917 | $38,684 | $34,604 | $31,140 | $31,120 | $32,097 |
Long-term Assets | |||||||||||||
Long-term Assets | $73,000 | $73,000 | $73,000 | $73,000 | $73,000 | $73,000 | $73,000 | $73,000 | $73,000 | $73,000 | $73,000 | $73,000 | $73,000 |
Accumulated Depreciation | $0 | $1,217 | $2,434 | $3,651 | $4,868 | $6,085 | $7,302 | $8,519 | $9,736 | $10,953 | $12,170 | $13,387 | $14,604 |
Total Long-term Assets | $73,000 | $71,783 | $70,566 | $69,349 | $68,132 | $66,915 | $65,698 | $64,481 | $63,264 | $62,047 | $60,830 | $59,613 | $58,396 |
Total Assets | $165,000 | $162,684 | $154,947 | $145,161 | $135,539 | $126,533 | $117,664 | $109,398 | $101,948 | $96,651 | $91,970 | $90,733 | $90,493 |
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 | $2,860 | $4,664 | $5,306 | $5,574 | $5,868 | $6,008 | $6,253 | $6,609 | $7,460 | $7,954 | $9,293 | $10,085 |
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 | $2,860 | $4,664 | $5,306 | $5,574 | $5,868 | $6,008 | $6,253 | $6,609 | $7,460 | $7,954 | $9,293 | $10,085 |
Long-term Liabilities | $170,000 | $169,000 | $168,000 | $167,000 | $166,000 | $165,000 | $164,000 | $163,000 | $162,000 | $161,000 | $160,000 | $159,000 | $158,000 |
Total Liabilities | $170,000 | $171,860 | $172,664 | $172,306 | $171,574 | $170,868 | $170,008 | $169,253 | $168,609 | $168,460 | $167,954 | $168,293 | $168,085 |
Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Retained Earnings | ($5,000) | ($5,000) | ($5,000) | ($5,000) | ($5,000) | ($5,000) | ($5,000) | ($5,000) | ($5,000) | ($5,000) | ($5,000) | ($5,000) | ($5,000) |
Earnings | $0 | ($4,175) | ($12,717) | ($22,145) | ($31,035) | ($39,335) | ($47,343) | ($54,856) | ($61,661) | ($66,808) | ($70,983) | ($72,560) | ($72,592) |
Total Capital | ($5,000) | ($9,175) | ($17,717) | ($27,145) | ($36,035) | ($44,335) | ($52,343) | ($59,856) | ($66,661) | ($71,808) | ($75,983) | ($77,560) | ($77,592) |
Total Liabilities and Capital | $165,000 | $162,684 | $154,947 | $145,161 | $135,539 | $126,533 | $117,664 | $109,398 | $101,948 | $96,651 | $91,970 | $90,733 | $90,493 |
Net Worth | ($5,000) | ($9,175) | ($17,717) | ($27,145) | ($36,035) | ($44,335) | ($52,343) | ($59,856) | ($66,661) | ($71,808) | ($75,983) | ($77,560) | ($77,592) |