Canine Critter College
Executive Summary
Canine Critter College (Tri C) is a dog obedience school located in Eugene. Canine Critter College is unique in its approach to dog obedience. Instead of training the dog, Tri C works on training the owners on how to train the dog, as well as help to establish clear lines of communication between the dog and the owner. Establishing clear communication with the dog, and understanding the dog’s physical, and social, behavior is the most fundamental of the lessons to learn.
Canine Critter College will leverage this strategy to develop long-term satisfied customers. Through the training philosophy and customer-centric business approach, Canine Critter College will consistently gain market share.
Canine Critter College is forecasted to reach profitability by month seven and will earn $91,000 in revenues for year three.
1.1 Mission
Canine Critter College’s mission is to provide the finest dog training program available. We exist to attract and maintain customers. When we adhere to this maxim, everything else will fall into place. Our services will exceed the expectations of our customers.
1.2 Objectives
The objectives for the first three years of operation include:
- To create a service-based company whose primary goal is to exceed customer’s expectations.
- To increase the number of clients by 20% a year.
- To develop a sustainable start-up business.
1.3 Keys to Success
The keys to success are providing a reasonably priced service that customers value. A customer-centric business model is the tool to achieve success.
Company Summary
Canine Critter College is a sole proprietorship based in Eugene, OR. Canine Critter College will offer three different levels of obedience training. The training will occur in a group setting, or through private lessons.
Canine Critter College is forecasted to reach profitability by month nine and will generate revenue of $91,000 by year three.
2.1 Company Ownership
Canine Critter College is a sole proprietorship founded and owned by Gerry Gestapo.
2.2 Start-up Summary
Canine Critter College will incur the following start-up costs:
- Computer system with a printer, CD-RW, Microsoft Office, QuickBooks Pro and broadband Internet connections.
- Fax machine, copier.
- Phone line, phone and answering machine.
- Assorted leashes, toys, collars.
Please note that the following items will be expensed; there will be no depreciation applied to them.
Start-up | |
Requirements | |
Start-up Expenses | |
Legal | $500 |
Stationery etc. | $100 |
Brochures | $200 |
Other | $0 |
Total Start-up Expenses | $800 |
Start-up Assets | |
Cash Required | $14,200 |
Other Current Assets | $0 |
Long-term Assets | $0 |
Total Assets | $14,200 |
Total Requirements | $15,000 |
Start-up Funding | |
Start-up Expenses to Fund | $800 |
Start-up Assets to Fund | $14,200 |
Total Funding Required | $15,000 |
Assets | |
Non-cash Assets from Start-up | $0 |
Cash Requirements from Start-up | $14,200 |
Additional Cash Raised | $0 |
Cash Balance on Starting Date | $14,200 |
Total Assets | $14,200 |
Liabilities and Capital | |
Liabilities | |
Current Borrowing | $0 |
Long-term Liabilities | $0 |
Accounts Payable (Outstanding Bills) | $0 |
Other Current Liabilities (interest-free) | $0 |
Total Liabilities | $0 |
Capital | |
Planned Investment | |
Gerry | $10,800 |
Investor 2 | $0 |
Other | $0 |
Additional Investment Requirement | $4,200 |
Total Planned Investment | $15,000 |
Loss at Start-up (Start-up Expenses) | ($800) |
Total Capital | $14,200 |
Total Capital and Liabilities | $14,200 |
Total Funding | $15,000 |
Services
Canine Critter College provides dog obedience classes for groups as well as individuals. Tri C offers three different levels of classes:
- Puppy Kindergarten: this class is used to teach dogs the basic commands, as well socialization skills. This course will have an introductory explanation of proper communication techniques.
- Household Obedience Level 1: the goal of this class is to have all members of the family work with their dog in a positive and consistent manner. The family will be taught to establish a leadership relationship with the dog. Much of the curriculum uses the American Kennel Club’s (AKC) Canine Good Citizen Test. This course will offer an intermediate level of communication techniques.
- Household Obedience Level 2: this class will perfect the standard commands such as sit, down, stay, come, and leash walking. This level will also work on healing, and will offer advanced communication techniques.
Canine Critter College courses are all based on a basic idea which can be summed up from a quote from R.D. Shaw, Chief Archaeologist for the Alaska Department of Natural Resources: “If societies are judged by their systems of order, justice, land rights, and family, the kingdom of the wolf is one of the most sophisticated.”
With this in mind, the courses are used to establish the pet owner’s role as the leader of the pack. Unless the owner establishes dominance, the animal will. Dominance is not punishment, dominance is the law of the pack. It is instinctively understood by all dogs. By showing dominance to the dog in a very responsible, consistent way, you are setting the dog at ease because he/she knows their place in the pack and are at ease around you because they know that you are in control and you will protect them.
The courses will also detail different types of canine social behavior as well as body language, providing the pet owner with insight into ways in which the pet is trying to communicate with them.
Market Analysis Summary
Canine Critter College will target two different groups that have uses for dog obedience training. The first group is people who just received a dog, whether a puppy or a dog new to the owners, and they would like the dog to be trained for easy management and clear communication with the pet. The other group of people are having issues with an existing dog and they are using the obedience training as a way to solve or minimize the issues. In general the distinction is a proactive vs. reactive approach.
4.1 Market Segmentation
The market can be broken down into two segments:
- Dog owners with young dogs: this segment recognizes the value of obedience training, particularly the efficiency of training at a younger age. This segment is typically well educated, with either an undergraduate degree or a graduate degree. Their household income is greater than $60,000. These people are willing to invest time into the pet now to create ease of control for the rest of the pet’s life.
- Dog owners with misbehaving dogs: this group of people either has a dog with control issues and just now has decided to do something about it, or just received a dog and would like to have more control over the animal.
Market Analysis | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
Potential Customers | Growth | CAGR | |||||
Proactive dog parents | 9% | 11,125 | 12,126 | 13,217 | 14,407 | 15,704 | 9.00% |
Reactive dog parents | 8% | 10,254 | 11,074 | 11,960 | 12,917 | 13,950 | 8.00% |
Other | 0% | 0 | 0 | 0 | 0 | 0 | 0.00% |
Total | 8.52% | 21,379 | 23,200 | 25,177 | 27,324 | 29,654 | 8.52% |
4.2 Target Market Segment Strategy
Canine Critter College will target the chosen segments through a focused networking and advertising campaign that will reach dog owners.
Strategy and Implementation Summary
The sales strategy will be based on communicating Canine Critter College’s philosophy for training pet owners to train their dogs. This is Tri C’s competitive advantage because instead of the traditional dog obedience school that trains the dog, Tri C trains the adults in how to communicate with the pet, as well as how to train the dog. This philosophy empowers the owner to be able to problem solve with the animal on their own instead of being held prisoner to a rigid rule based training system.
The marketing efforts will be concentrated on networking activities as well as advertising.
5.1 Competitive Edge
Canine Critter College’s competitive edge is based on their underlying philosophy and the way they present it as being completely intuitive to the client. This greatly effects the quality of interaction between the dog and its owner because the intuitive nature allows the owner to completely understand why they are doing what they are doing.
Canine Critter College carefully details canine social behavior. This provides insight into why the dog is acting like it does. When the dog has some sort of behavior outburst, it is because it is trying to communicate something to the owner in the only way it knows how. If the owner is taught not only why the dog is acting out, but also ways to analyze future actions by the dog, the training session is empowering the owner to have a more sophisticated method of communication/interaction with dog. This is of course recognizing that communication is a two-way street, one element is the understanding of the dog’s behavior, the other is ways that the owner can clearly communicate to the pet.
The key here is helping pet ownersunderstand the reason their dog is acting as they are and providing them with requisite knowledge to problem solve on their own. This distinction is important. Most obedience classes teach you what to do in certain circumstances. Canine Critter College explains the dog’s behavior and empowers the owner to interpret and make a well-reasoned analysis and conclusion of what to do.
5.2 Sales Strategy
The sales strategy will be based on communicating Canine Critter College’s competitive edge to the prospective customers. Training the owners to train the animal is far more effective because it empowers the owner to work with the dog well beyond the classes, as well as allows the owner/dog relationship to grow beyond the training classes because the owner has been taught an effective communication mechanism.
When a prospective customer calls to get more information about the classes, they will be pointed to the website for more in-depth information. The customer will also be offered a list of past customers, as well as the offer to sit in on a class. The ability for the person to observe a class will be instrumental in turning them into a dedicated customer.
5.2.1 Sales Forecast
The first month will be used to advertise Canine Critter College as well as develop outlines for the different sessions within the classes. There will be no sales activity during the first month. The first group class will occur during the second week of the second month. Also during the second month there will be a couple of private sessions. From month three on, there will be a steady increase of sales as the classes develop more participants. Profitability will be reached by month nine.
Sales Forecast | |||
Year 1 | Year 2 | Year 3 | |
Sales | |||
Proactive dog training | $21,975 | $42,125 | $49,874 |
Reactive dog training | $18,223 | $34,964 | $41,395 |
Total Sales | $40,198 | $77,089 | $91,269 |
Direct Cost of Sales | Year 1 | Year 2 | Year 3 |
Proactive dog parents | $798 | $421 | $499 |
Reactive dog parents | $662 | $350 | $414 |
Subtotal Direct Cost of Sales | $1,460 | $771 | $913 |
5.2.2 Marketing Strategy
Canine Critter College strategy will be based on networking and advertising. The networking will take place with different breeders in the area. Gerry will network with many of the local breeders. This will not be difficult as the canine training/breeding community is relatively small and intimate. By forming relationships with the different breeders, the breeders will act as a well respected referral service for Canine Critter College.
Canine Critter College will also do advertising with the local chapter of the AKC as well as with the Humane Society. These will be the initial marketing efforts. After a while, word-of-mouth referrals will take over as the most effective marketing mechanism.
5.3 Milestones
Canine Critter College will have several milestones early on:
- Business plan completion. This will be done as a roadmap for the organization, and will be an indispensable tool for the ongoing performance and improvement of the company.
- Office set up.
- Development of class structure.
- Profitability.
Milestones | |||||
Milestone | Start Date | End Date | Budget | Manager | Department |
Business plan completion | 1/1/2001 | 2/1/2001 | $0 | ABC | Marketing |
Office set up | 1/1/2001 | 2/1/2001 | $0 | ABC | Department |
Development of class structure | 1/1/2001 | 2/15/2001 | $0 | ABC | Department |
Profitability | 1/1/2001 | 9/31/2001 | $0 | ABC | Department |
Totals | $0 |
Management Summary
Gerry Gestapo received her Bachelor of Arts degree in psychology from the University of Oregon. Throughout college, Gerry worked with a local veterinarian. She found this work enlightening and challenging. Upon graduating, Gerry knew that she wanted to work with animals. She considered dog obedience as a way of combining her love for dogs with her psychology degree. She moved to Portland and got a job at a large dog obedience school to gain experience in the field. While she was learning the ropes at the organization, Gerry did a lot of research on the subject recognizing that this was something that she wanted to pursue. After one year of work, Gerry felt that she had enough insight to open up her own school and began working on this business plan.
6.1 Personnel Plan
Gerry will be the sole employee.
Personnel Plan | |||
Year 1 | Year 2 | Year 3 | |
Gerry | $24,000 | $36,000 | $36,000 |
Other | $0 | $0 | $0 |
Total People | 1 | 1 | 1 |
Total Payroll | $24,000 | $36,000 | $36,000 |
Financial Plan
The following sections will outline important financial information.
7.1 Important Assumptions
The following table details 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 |
7.2 Break-even Analysis
The Break-even Analysis indicates that approximately $3,600 will be needed in monthly revenue to reach the break-even point.
Break-even Analysis | |
Monthly Revenue Break-even | $3,668 |
Assumptions: | |
Average Percent Variable Cost | 4% |
Estimated Monthly Fixed Cost | $3,535 |
7.3 Projected Profit and Loss
The following table will indicate projected profit and loss.
Pro Forma Profit and Loss | |||
Year 1 | Year 2 | Year 3 | |
Sales | $40,198 | $77,089 | $91,269 |
Direct Cost of Sales | $1,460 | $771 | $913 |
Other Production Expenses | $0 | $0 | $0 |
Total Cost of Sales | $1,460 | $771 | $913 |
Gross Margin | $38,739 | $76,318 | $90,357 |
Gross Margin % | 96.37% | 99.00% | 99.00% |
Expenses | |||
Payroll | $24,000 | $36,000 | $36,000 |
Sales and Marketing and Other Expenses | $960 | $960 | $960 |
Depreciation | $0 | $0 | $0 |
Utilities | $900 | $900 | $900 |
Insurance | $1,560 | $1,560 | $1,560 |
Rent | $9,600 | $9,600 | $9,600 |
Payroll Taxes | $5,400 | $5,400 | $5,400 |
Other | $0 | $0 | $0 |
Total Operating Expenses | $42,420 | $54,420 | $54,420 |
Profit Before Interest and Taxes | ($3,681) | $21,898 | $35,937 |
EBITDA | ($3,681) | $21,898 | $35,937 |
Interest Expense | $333 | $293 | $99 |
Taxes Incurred | $0 | $6,481 | $10,751 |
Net Profit | ($4,014) | $15,123 | $25,086 |
Net Profit/Sales | -9.99% | 19.62% | 27.49% |
7.4 Projected Cash Flow
The following chart and table will indicate projected cash flow.
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $40,198 | $77,089 | $91,269 |
Subtotal Cash from Operations | $40,198 | $77,089 | $91,269 |
Additional Cash Received | |||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 |
New Current Borrowing | $5,000 | $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 | $0 | $0 |
Subtotal Cash Received | $45,198 | $77,089 | $91,269 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $24,000 | $36,000 | $36,000 |
Bill Payments | $18,110 | $25,934 | $29,836 |
Subtotal Spent on Operations | $42,110 | $61,934 | $65,836 |
Additional Cash Spent | |||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 |
Principal Repayment of Current Borrowing | $1,120 | $1,900 | $1,980 |
Other Liabilities Principal Repayment | $0 | $0 | $0 |
Long-term Liabilities Principal Repayment | $0 | $0 | $0 |
Purchase Other Current Assets | $0 | $0 | $0 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $43,230 | $63,834 | $67,816 |
Net Cash Flow | $1,968 | $13,255 | $23,453 |
Cash Balance | $16,168 | $29,423 | $52,876 |
7.5 Projected Balance Sheet
The following table will indicate the projected balance sheet.
Pro Forma Balance Sheet | |||
Year 1 | Year 2 | Year 3 | |
Assets | |||
Current Assets | |||
Cash | $16,168 | $29,423 | $52,876 |
Other Current Assets | $0 | $0 | $0 |
Total Current Assets | $16,168 | $29,423 | $52,876 |
Long-term Assets | |||
Long-term Assets | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 |
Total Assets | $16,168 | $29,423 | $52,876 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $2,103 | $2,134 | $2,481 |
Current Borrowing | $3,880 | $1,980 | $0 |
Other Current Liabilities | $0 | $0 | $0 |
Subtotal Current Liabilities | $5,983 | $4,114 | $2,481 |
Long-term Liabilities | $0 | $0 | $0 |
Total Liabilities | $5,983 | $4,114 | $2,481 |
Paid-in Capital | $15,000 | $15,000 | $15,000 |
Retained Earnings | ($800) | ($4,814) | $10,309 |
Earnings | ($4,014) | $15,123 | $25,086 |
Total Capital | $10,186 | $25,309 | $50,395 |
Total Liabilities and Capital | $16,168 | $29,423 | $52,876 |
Net Worth | $10,186 | $25,309 | $50,395 |
7.6 Business Ratios
Business ratios for the years of this plan are shown below. Industry profile ratios based on the Standard Industrial Classification (SIC) code 0752, Animal Specialty Services, are shown for comparison.
Ratio Analysis | ||||
Year 1 | Year 2 | Year 3 | Industry Profile | |
Sales Growth | 0.00% | 91.77% | 18.40% | 6.64% |
Percent of Total Assets | ||||
Other Current Assets | 0.00% | 0.00% | 0.00% | 29.75% |
Total Current Assets | 100.00% | 100.00% | 100.00% | 55.50% |
Long-term Assets | 0.00% | 0.00% | 0.00% | 44.50% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 37.00% | 13.98% | 4.69% | 23.28% |
Long-term Liabilities | 0.00% | 0.00% | 0.00% | 22.37% |
Total Liabilities | 37.00% | 13.98% | 4.69% | 45.65% |
Net Worth | 63.00% | 86.02% | 95.31% | 54.35% |
Percent of Sales | ||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 96.37% | 99.00% | 99.00% | 27.10% |
Selling, General & Administrative Expenses | 56.10% | 79.68% | 71.92% | 12.51% |
Advertising Expenses | 0.41% | 0.78% | 0.66% | 0.29% |
Profit Before Interest and Taxes | -9.16% | 28.41% | 39.37% | 1.91% |
Main Ratios | ||||
Current | 2.70 | 7.15 | 21.31 | 1.72 |
Quick | 2.70 | 7.15 | 21.31 | 0.94 |
Total Debt to Total Assets | 37.00% | 13.98% | 4.69% | 56.36% |
Pre-tax Return on Net Worth | -39.41% | 85.36% | 71.11% | 5.58% |
Pre-tax Return on Assets | -24.83% | 73.43% | 67.78% | 12.78% |
Additional Ratios | Year 1 | Year 2 | Year 3 | |
Net Profit Margin | -9.99% | 19.62% | 27.49% | n.a |
Return on Equity | -39.41% | 59.75% | 49.78% | n.a |
Activity Ratios | ||||
Accounts Payable Turnover | 9.61 | 12.17 | 12.17 | n.a |
Payment Days | 27 | 30 | 28 | n.a |
Total Asset Turnover | 2.49 | 2.62 | 1.73 | n.a |
Debt Ratios | ||||
Debt to Net Worth | 0.59 | 0.16 | 0.05 | n.a |
Current Liab. to Liab. | 1.00 | 1.00 | 1.00 | n.a |
Liquidity Ratios | ||||
Net Working Capital | $10,186 | $25,309 | $50,395 | n.a |
Interest Coverage | -11.06 | 74.74 | 363.00 | n.a |
Additional Ratios | ||||
Assets to Sales | 0.40 | 0.38 | 0.58 | n.a |
Current Debt/Total Assets | 37% | 14% | 5% | n.a |
Acid Test | 2.70 | 7.15 | 21.31 | n.a |
Sales/Net Worth | 3.95 | 3.05 | 1.81 | n.a |
Dividend Payout | 0.00 | 0.00 | 0.00 | n.a |
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 | |||||||||||||
Proactive dog training | 0% | $0 | $400 | $1,000 | $1,145 | $1,345 | $1,545 | $2,145 | $2,312 | $2,654 | $2,987 | $3,121 | $3,321 |
Reactive dog training | 0% | $0 | $332 | $830 | $950 | $1,116 | $1,282 | $1,780 | $1,919 | $2,203 | $2,479 | $2,574 | $2,757 |
Total Sales | $0 | $732 | $1,830 | $2,095 | $2,461 | $2,827 | $3,925 | $4,231 | $4,857 | $5,466 | $5,695 | $6,078 | |
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 | |
Proactive dog parents | $0 | $4 | $10 | $11 | $13 | $15 | $21 | $23 | $27 | $30 | $310 | $332 | |
Reactive dog parents | $0 | $3 | $8 | $10 | $11 | $13 | $18 | $19 | $22 | $25 | $257 | $276 | |
Subtotal Direct Cost of Sales | $0 | $7 | $18 | $21 | $25 | $28 | $39 | $42 | $49 | $55 | $568 | $608 |
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 | ||
Gerry | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
Total Payroll | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,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 | $732 | $1,830 | $2,095 | $2,461 | $2,827 | $3,925 | $4,231 | $4,857 | $5,466 | $5,695 | $6,078 | |
Direct Cost of Sales | $0 | $7 | $18 | $21 | $25 | $28 | $39 | $42 | $49 | $55 | $568 | $608 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $7 | $18 | $21 | $25 | $28 | $39 | $42 | $49 | $55 | $568 | $608 | |
Gross Margin | $0 | $725 | $1,812 | $2,074 | $2,437 | $2,799 | $3,886 | $4,189 | $4,808 | $5,412 | $5,127 | $5,470 | |
Gross Margin % | 0.00% | 99.00% | 99.00% | 99.00% | 99.00% | 99.00% | 99.00% | 99.00% | 99.00% | 99.00% | 90.03% | 90.00% | |
Expenses | |||||||||||||
Payroll | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Sales and Marketing and Other Expenses | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | $80 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | |
Insurance | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | $130 | |
Rent | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
Payroll Taxes | 15% | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $3,535 | $3,535 | $3,535 | $3,535 | $3,535 | $3,535 | $3,535 | $3,535 | $3,535 | $3,535 | $3,535 | $3,535 | |
Profit Before Interest and Taxes | ($3,535) | ($2,810) | ($1,723) | ($1,461) | ($1,098) | ($736) | $351 | $654 | $1,273 | $1,877 | $1,592 | $1,935 | |
EBITDA | ($3,535) | ($2,810) | ($1,723) | ($1,461) | ($1,098) | ($736) | $351 | $654 | $1,273 | $1,877 | $1,592 | $1,935 | |
Interest Expense | $0 | $0 | $0 | $42 | $41 | $39 | $38 | $37 | $36 | $35 | $34 | $32 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($3,535) | ($2,810) | ($1,723) | ($1,502) | ($1,139) | ($775) | $313 | $617 | $1,237 | $1,842 | $1,559 | $1,903 | |
Net Profit/Sales | 0.00% | -383.92% | -94.17% | -71.70% | -46.27% | -27.42% | 7.97% | 14.57% | 25.48% | 33.70% | 27.37% | 31.31% |
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 | $732 | $1,830 | $2,095 | $2,461 | $2,827 | $3,925 | $4,231 | $4,857 | $5,466 | $5,695 | $6,078 | |
Subtotal Cash from Operations | $0 | $732 | $1,830 | $2,095 | $2,461 | $2,827 | $3,925 | $4,231 | $4,857 | $5,466 | $5,695 | $6,078 | |
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 | $5,000 | $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 | $732 | $1,830 | $7,095 | $2,461 | $2,827 | $3,925 | $4,231 | $4,857 | $5,466 | $5,695 | $6,078 | |
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 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Bill Payments | $51 | $1,535 | $1,543 | $1,555 | $1,598 | $1,600 | $1,603 | $1,612 | $1,614 | $1,620 | $1,641 | $2,137 | |
Subtotal Spent on Operations | $2,051 | $3,535 | $3,543 | $3,555 | $3,598 | $3,600 | $3,603 | $3,612 | $3,614 | $3,620 | $3,641 | $4,137 | |
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 | $140 | $140 | $140 | $140 | $140 | $140 | $140 | $140 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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 | $2,051 | $3,535 | $3,543 | $3,555 | $3,738 | $3,740 | $3,743 | $3,752 | $3,754 | $3,760 | $3,781 | $4,277 | |
Net Cash Flow | ($2,051) | ($2,803) | ($1,713) | $3,541 | ($1,276) | ($913) | $182 | $478 | $1,102 | $1,707 | $1,914 | $1,801 | |
Cash Balance | $12,149 | $9,346 | $7,633 | $11,173 | $9,897 | $8,984 | $9,167 | $9,645 | $10,748 | $12,454 | $14,368 | $16,168 |
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 | $14,200 | $12,149 | $9,346 | $7,633 | $11,173 | $9,897 | $8,984 | $9,167 | $9,645 | $10,748 | $12,454 | $14,368 | $16,168 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $14,200 | $12,149 | $9,346 | $7,633 | $11,173 | $9,897 | $8,984 | $9,167 | $9,645 | $10,748 | $12,454 | $14,368 | $16,168 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $14,200 | $12,149 | $9,346 | $7,633 | $11,173 | $9,897 | $8,984 | $9,167 | $9,645 | $10,748 | $12,454 | $14,368 | $16,168 |
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 | $1,484 | $1,491 | $1,502 | $1,544 | $1,547 | $1,549 | $1,559 | $1,560 | $1,565 | $1,570 | $2,065 | $2,103 |
Current Borrowing | $0 | $0 | $0 | $0 | $5,000 | $4,860 | $4,720 | $4,580 | $4,440 | $4,300 | $4,160 | $4,020 | $3,880 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $1,484 | $1,491 | $1,502 | $6,544 | $6,407 | $6,269 | $6,139 | $6,000 | $5,865 | $5,730 | $6,085 | $5,983 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $1,484 | $1,491 | $1,502 | $6,544 | $6,407 | $6,269 | $6,139 | $6,000 | $5,865 | $5,730 | $6,085 | $5,983 |
Paid-in Capital | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
Retained Earnings | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) | ($800) |
Earnings | $0 | ($3,535) | ($6,345) | ($8,069) | ($9,571) | ($10,710) | ($11,485) | ($11,172) | ($10,555) | ($9,318) | ($7,476) | ($5,917) | ($4,014) |
Total Capital | $14,200 | $10,665 | $7,855 | $6,131 | $4,629 | $3,490 | $2,715 | $3,028 | $3,645 | $4,882 | $6,724 | $8,283 | $10,186 |
Total Liabilities and Capital | $14,200 | $12,149 | $9,346 | $7,633 | $11,173 | $9,897 | $8,984 | $9,167 | $9,645 | $10,748 | $12,454 | $14,368 | $16,168 |
Net Worth | $14,200 | $10,665 | $7,855 | $6,131 | $4,629 | $3,490 | $2,715 | $3,028 | $3,645 | $4,882 | $6,724 | $8,283 | $10,186 |