Write Bike
Executive Summary
Write Bike is a home-based start-up business that provides cycling specific correspondent services in the form of written articles. Kraig Guthrie, the founder and sole employee will produce cycling related articles on a freelance basis for a variety of print and online magazines. By leveraging Kraig’s extensive industry experience, Write Bike will become a sustainable home-based business.
Services
Write Bike is able to produce a wide range of cycling related articles. Some of the articles will be product reviews. Through extensive testing and consistent criteria-based measurements, Kraig will be able to offer objective product testing. Write Bike also offers interviews, typically with professional racers as well as industry personalities. Kraig, having raced at the elite level in the past, is personal friends with many different racers and can offer written interviews to his different customer publications. Kraig will also sell reports from the annual bicycle industry trade shows, the premier place for new product launches. He will also be able to offer fitness and training articles, specific to cycling from his extensive riding experience and educational background. Write Bike will write articles either on demand or speculatively.
The Market
It was just several years ago when the only source of cycling information was either from the local bike shop or the printed magazine. With the proliferation of the Internet, there are many different cycling specific sites that act as online magazines. Write Bike will sell their articles either to the print magazines or the online magazines. Due to a consolidation phenomenon within the publishing industry, many different magazines are merging into larger units and many staff writers are being let go. This benefits Write Bike because it creates demand for freelance articles. The two target market customers: print and online magazines, comprise a total of 350 potential customers, 250 and 100 respectively. These two customer segments are growing at 2% and 8% annually.
Management
Kraig Guthrie brings a wealth of experience to Write Bike. Kraig received his undergraduate degree in Biology and Journalism from Brown University. While at Brown Kraig raced on their cycling team as well as wrote for the student newspaper. Upon graduation Kraig continued to pursue cycling, both at a competitive level as well as business related. Kraig participated at the Olympic Training sessions, riding as an elite cyclist. Additionally, Kraig managed a bicycle shop for several years. Kraig then went to work for Shimano America, the premier bicycle component manufacturer. Through a variety of jobs and responsibilities at Shimano, Kraig became intimately familiar with the industry and the people that make it up. Kraig’s expert knowledge of the industry will be invaluable in the production of articles.
1.1 Mission
It is Write Bike’s mission to produce well written articles about the bicycle industry. By leveraging Kraig’s extensive network of colleagues within the industry, Write Bike is able to offer a rare insight of the industry.
1.2 Keys to Success
- Create well written, insightful articles for the bicycle industry.
- Continue to develop a network of contacts, both as a source of information as well as to develop the market’s acceptance of Write Bike’s articles.
- Always remember the audience.
1.3 Objectives
- Develop regular, consistent article submissions with multiple publications.
- Create a profitable home-based business.
- Continue to develop and maintain a network of contacts within the bicycle industry.
Company Summary
Write Bike is a sole proprietorship that is located with the home of Kraig Guthrie. It was founded in January 2003. The business is based in Kraig’s home. Kraig pays a fixed amount of rent per month based on the square footage that his office occupies relative to the rest of the house.
2.1 Company Ownership
Write Bike is a home based business owned and operated by Kraig Guthrie.
2.2 Start-up Summary
Write Bike requires the following equipment for its article writing services.
- Macintosh G4 computer
- DSL Internet connection
- Scanner
- Laser printer
- Digital camera
- Microsoft Office, Adobe FrameMaker, Adobe PhotoShop, and Adobe Acrobat.
Start-up | |
Requirements | |
Start-up Expenses | |
Legal | $200 |
Stationery, etc. | $200 |
Insurance | $150 |
Rent | $250 |
Total Start-up Expenses | $800 |
Start-up Assets | |
Cash Required | $9,200 |
Other Current Assets | $0 |
Long-term Assets | $5,000 |
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 | $5,000 |
Cash Requirements from Start-up | $9,200 |
Additional Cash Raised | $0 |
Cash Balance on Starting Date | $9,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 | |
Kraig Guthrie-Owner | $15,000 |
Other | $0 |
Additional Investment Requirement | $0 |
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
Write Bike is a freelance article writing service dedicated to the bicycle industry. Articles are either written upon request about a specific person or subject, or are written speculatively. The following article types are representative of the content that Write Bike produces:
- Product reviews: These are reviews of new products which have recently hit the market. Write Bike applies an objective, criteria-based system for evaluating products. Generally Kraig requires a period of a couple of weeks to have enough experience with the product to produce a comprehensive analysis.
- Rider and industry personnel interviews: These interviews are generally based on networking contacts that Kraig has developed over the years. The interviews can take place in person, on the phone, or via email. The topic of the interview is usually guided by the editorial slant of magazine that the interview will be submitted to.
- Trade show reports: Twice a year there are bicycle industry trade shows held for the U.S. market. These articles will be reviews of the “happenings” at the trade show. A large component of the trade show articles are preview photos of the up-and-coming new products.
- Fitness articles: These are generally physiology and training-based articles specific to cycling. Years of cycling experience and a biology undergraduate degree has provided Kraig with expert status for this type of article.
- Repair articles: These articles typically chose a specific topic of bicycle repair or maintenance and then provide a detailed, step-by-step, how-to guide for readers on that procedure.
Market Analysis Summary
Write Bike has identified two main target customer segments for submission of articles. The two market segments are each fairly large: printed magazines and online cycling specific websites.
Both monthly and bi-monthly magazines have a need for article content to supplement that produced by the staff writers. Some of the publications have a large staff of writers and only use a small percentage of articles from outside writers, other companies rely heavily on outside, freelance writers.
Many websites are maintained by bicycling enthusiasts and so rely almost exclusively on freelance articles.
4.1 Market Segmentation
Write Bike has segmented the target market into two broad categories, print and online magazines.
Print magazines
Regional publications
These magazines are typically city or state based journals. Sometimes they use glossy paper in magazine format, more often than not, as a function of the smaller readership levels, the regional printed magazines use inexpensive newsprint. The regional ‘zines typically use a higher percentage of freelance writers. This is easily explained by the fact that the regional ‘zines have smaller budgets and consequently must maintain lower overhead, using freelance writers. The freelance writers both submit articles unsolicited as well as by request of the publication. Examples include:
- Oregon Cycling
- Boston Biking
- Seattle Cycling
National publications
These magazines are almost exclusively printed on glossy paper, magazine formatted and bound, have national circulation readership levels, and have a staff of writers. However, they also contract freelance writers for specific pieces or they accept speculative pieces. Generally the freelance work is on requested topics. Examples include:
- Bicycling
- Mountain Bike
- Mountain Bike Action
- Bike
- Velo News
- Dirt Rag
Online magazines/Websites
With the recent explosion of popularity and use rates of the Internet, there have been a number of different websites that offer bicycle specific content. The advantages of the online sites is their ability to have far more current content as well as a much larger geographic coverage. Some of the sites offer paid content, however, the majority of them offer free content with the bulk of their revenue coming from advertisers on the site. Some of the online sites are extensions of a printed magazine, others are solely Internet based. Examples include:
- Cycling News
- VeloNews.com
- MTB Review
- Cycling.com
Market Analysis | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
Potential Customers | Growth | CAGR | |||||
Print magazines | 2% | 250 | 255 | 260 | 265 | 270 | 1.94% |
Online magazines/Websites | 8% | 100 | 108 | 117 | 126 | 136 | 7.99% |
Total | 3.78% | 350 | 363 | 377 | 391 | 406 | 3.78% |
4.2 Target Market Segment Strategy
Write Bike has chosen to to target both printed and online magazines. These target customers have been chosen because of their need for articles. While some of the magazines have less of a demand for freelance writers, all magazines at some level require freelance writers. Freelance writers are an effective means for managing money, a scarce resource for magazines. Freelance writers present a level of flexibility that most staff writers, as a function of the business organization, cannot meet. Additionally, the demand for articles occurs somewhat regularly, generally at monthly or bi-monthly intervals.
The advent of online magazines and email provides a new and exciting market for articles by eliminating geographic limitations. In the past the writers would often have to be located near the publishing headquarters. Now with the Internet and email, a writer can be based in Bali and be producing work for a magazine in New York.
4.3 Service Business Analysis
The bicycle magazine/publishing industry is a large and geographically dispersed industry. There are publications through out the U.S., however, there is general concentration in the larger metropolitan areas. In the United States, there are 24 million unique readers of cycling specific publications. The industry generates $428 million in revenue annually. The printed side has stagnated a bit with the growing popularity of the Internet. Consequently, the Internet-based cycling sites have grown at encouraging rates. The bicycling magazine industry is a source of information for many different people. Other sources of information are local bicycle shops as well as clubs and local and national associations.
4.3.1 Competition and Buying Patterns
The competition takes the form of staff writers as well as other freelance writers.
- Staff writers: Staff writers are a form of direct competition because ultimately it is the editor’s choice as to whether to use a staff writer or a freelancer. The editors make decisions on who to use based on numerous variables such as: price, availability, time frame for article production, quality of writing, and the chosen business model that determines the ratio of staff writers to freelance writers.
- Freelance writers: There are other freelance writers, some of whom are specific to the cycling industry, and many others who are information generalists. As mentioned above, they can be distinguished by price, availability, production speed, quality, and area of expertise.
Strategy and Implementation Summary
Write Bike faces competition from the two previously mentioned sources, other freelance writers and staff writers. Write Bike will leverage Kraig’s competitive edge of extensive experience and wealth of contacts within the industry. Write Bike will undertake a marketing campaign that uses networking as a source of new jobs. This will be quite valuable because of the depth of Kraig’s contacts. The sales campaign will concentrate on delivering quality, expert level writing on time and at fair prices. By providing these aspects of a product, Write Bike should be able to win over most publishers after their first interaction, building a constant flow of future projects.
5.1 Competitive Edge
Write Bike’s competitive edge is Kraig’s comprehensive level of industry experience. This level of expertise is manufacturer, retailer, and individual racer based. Typically, someone in the industry comes from one area, they either have worked for a manufacturer or they are a racer, or they have managed/owned a retail establishment. It is very rare for one individual to have such a deep cross-section of experience and perspective. By drawing experience from a variety of sources, Kraig can offer a comprehensive service that has significant depth of perspective.
Kraig’s personal relationships provide him with ready access to the industry and different riders. As the industry has grown in size, it has lost to some degree, its close knit familiarity and camaraderie. Over the years Kraig has developed an extensive list of personal contacts, people whom he can use for personal favors as well as help in establishing his freelance writing company.
5.2 Marketing Strategy
Write Bike’s marketing strategy is based on the wealth of networking contacts that Kraig has developed during the years of his comprehensive involvement with the cycling industry. Kraig is able to use his network contacts to generate interest in his availability as a freelance writer. His contacts know his depth of knowledge as well as his intelligence so they are able to offer a glowing recommendations both for Kraig and his articles. The old saying “you scratch my back and I’ll scratch yours” is quite accurate within the bicycle industry. If you have a positive relationship with someone they are generally willing to go out of their way to assist you. In conclusion, Kraig will use his contacts and the contacts of his contacts as a way to get writing assignments.
5.3 Sales Strategy
The sales strategy will focus on Write Bike’s commitment to consistently produce high quality writing products on time and on price. There is a somewhat limited list of desirable customers and it will be Kraig’s need to impress each of them with his first assignments. The sales effort will therefore concentrate on impressing first time customers enough that they funnel a future stream of projects to Write Bike. This will be an effective strategy because it takes into account the reality that it requires a lot more time and money to attract a new customer than it does to impress a current customer and transition the current customer into a long-term source of revenue. The conversion of customers into long-term assets will use Kraig’s work products as well as a feedback mechanism to capture valuable information regarding the customers’ needs.
5.3.1 Sales Forecast
The sales forecast indicates that growth in revenue will be steady but slow. This is a reality since the marketing effort is based on networking. Inherent in the use of a networking system is the time necessary for it to develop. This is analogous to the building of a spider’s web. It is a somewhat slow, methodical process, but each block builds on the prior one and the end product is a widely dispersed foundation that is quite strong and valuable. There will be a couple of articles sold within the first couple of months, with the number of articles sold increasing over time. Because this is a home-based business, measures of profitability are somewhat inaccurate since the bulk of the overhead costs are absorbed in the household expenses.
Sales Forecast | |||
Year 1 | Year 2 | Year 3 | |
Sales | |||
$22,300 | $35,000 | $41,005 | |
Web based | $14,941 | $23,450 | $27,473 |
Total Sales | $37,241 | $58,450 | $68,478 |
Direct Cost of Sales | Year 1 | Year 2 | Year 3 |
$0 | $0 | $0 | |
Web based | $0 | $0 | $0 |
Subtotal Direct Cost of Sales | $0 | $0 | $0 |
5.4 Milestones
Write Bike has established a set of milestones which will serve as ambitious yet achievable goals or benchmarks. If met they will be positive indications of a healthy business.
Milestones | |||||
Milestone | Start Date | End Date | Budget | Manager | Department |
Complete business plan | 1/1/2003 | 2/1/2003 | $0 | Kraig | Planning |
First national article | 1/1/2003 | 4/15/2003 | $0 | Kraig | Marketing |
Full-time work status | 1/1/2003 | 8/30/2003 | $0 | Kraig | Sales |
Revenues exceeding $100K | 1/1/2003 | 3/30/2005 | $0 | Kraig | Sales |
Totals | $0 |
Management Summary
Kraig Guthrie has been involved in the bicycle industry for ten years. Kraig attended Brown University for an undergraduate degree in Biology and Journalism. While at Brown, Kraig raced on the cycling team and was an active writer for the student newspaper.
Upon graduation Kraig moved to Boston and worked in a bicycle shop for four years. The first year was in a sales/mechanic capacity. Kraig’s intelligence and skill set quickly became noticed and he moved into a manager’s position for his three remaining years at the shop. While working at the shop he continued to ride and write. Kraig was an excellent rider, both on the road and off road. On road he was a Category One racer and off road he raced Professional.
During his first year after graduation, Kraig cycling talents became noticed and he was invited for summer training at the Olympic Cycling Center in Colorado Springs. It was here that Kraig raced and became friends will all of the leading American cyclists. The relationships that Kraig developed were quite personal and he would remain friends with these future professional cyclists throughout his life. At the same time Kraig began to do some freelance writing for a few cycling magazines.
After four years Kraig left the bike shop and moved to a position at Shimano America. Shimano is the largest and one of the most prestigious bicycle component manufacturers. Shimano works with every major production and custom bicycle manufacturer in the USA. Kraig accepted a project manager position at Shimano.
Initially his projects were the introduction of new products. Eventually Shimano moved Kraig in to a position doing outside Public Relations. Kraig traveled extensively, meeting with manufacturers, retailers, racers, and end consumers and updating them on new gruppos, parts, accessories, technical procedures, and corporate marketing, and sponsorship activities. This was an great experience for Kraig, building a network of contacts that would soon prove to be invaluable.
The travelling took its toll however. Kraig was spending less and less time with his family. After six years Kraig decided to consider other ways to make money within the cycling industry that would provide him with more time with his family. Because Kraig had been still writing freelance articles for the last 10 years, albeit somewhat infrequently, Kraig began to work on business plan to determine the feasibility of being a full-time freelance writer. After more and more contemplative thought and analysis, it became obvious that there was a reasonable likelihood of success and that he would give it is a shot.
6.1 Personnel Plan
Write Bike is a home based business with Kraig as the single employee. As the only employee it will be Kraig’s responsibility for sales, marketing, accounting, and WRITING. Kraig’s wife Marie will help out with the business when Kraig is working in the field, however, Kraig will be doing pretty much everything. Because his work will be freelance, Kraig will have the flexibility to accomplish all the necessary activities.
Personnel Plan | |||
Year 1 | Year 2 | Year 3 | |
Steve | $31,000 | $40,000 | $44,000 |
Other | $0 | $0 | $0 |
Total People | 1 | 1 | 1 |
Total Payroll | $31,000 | $40,000 | $44,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 what monthly revenue will be needed to reach the break-even point.
Break-even Analysis | |
Monthly Revenue Break-even | $3,333 |
Assumptions: | |
Average Percent Variable Cost | 0% |
Estimated Monthly Fixed Cost | $3,333 |
7.3 Projected Profit and Loss
The following table and charts displays Projected Profit and Loss.
Pro Forma Profit and Loss | |||
Year 1 | Year 2 | Year 3 | |
Sales | $37,241 | $58,450 | $68,478 |
Direct Cost of Sales | $0 | $0 | $0 |
Other Costs of Sales | $0 | $0 | $0 |
Total Cost of Sales | $0 | $0 | $0 |
Gross Margin | $37,241 | $58,450 | $68,478 |
Gross Margin % | 100.00% | 100.00% | 100.00% |
Expenses | |||
Payroll | $31,000 | $40,000 | $44,000 |
Account Name | $0 | $0 | $0 |
Depreciation | $996 | $996 | $996 |
Rent | $3,000 | $3,000 | $3,000 |
Utilities | $1,200 | $1,200 | $1,200 |
Insurance | $900 | $900 | $900 |
Payroll Taxes | $0 | $0 | $0 |
Travel, trade shows. other expenses | $2,900 | $3,000 | $4,000 |
Total Operating Expenses | $39,996 | $49,096 | $54,096 |
Profit Before Interest and Taxes | ($2,755) | $9,354 | $14,382 |
EBITDA | ($1,759) | $10,350 | $15,378 |
Interest Expense | $0 | $0 | $0 |
Taxes Incurred | $0 | $2,806 | $4,315 |
Net Profit | ($2,755) | $6,548 | $10,068 |
Net Profit/Sales | -7.40% | 11.20% | 14.70% |
7.4 Projected Cash Flow
The following table and chart presents the Projected Cash Flow.
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $37,241 | $58,450 | $68,478 |
Subtotal Cash from Operations | $37,241 | $58,450 | $68,478 |
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 | $0 | $0 |
Subtotal Cash Received | $37,241 | $58,450 | $68,478 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $31,000 | $40,000 | $44,000 |
Bill Payments | $7,493 | $10,517 | $13,209 |
Subtotal Spent on Operations | $38,493 | $50,517 | $57,209 |
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 | $0 | $0 | $0 |
Purchase Other Current Assets | $0 | $0 | $0 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $38,493 | $50,517 | $57,209 |
Net Cash Flow | ($1,252) | $7,933 | $11,270 |
Cash Balance | $7,949 | $15,881 | $27,151 |
7.5 Projected Balance Sheet
The following table shows the Projected Balance Sheet.
Pro Forma Balance Sheet | |||
Year 1 | Year 2 | Year 3 | |
Assets | |||
Current Assets | |||
Cash | $7,949 | $15,881 | $27,151 |
Other Current Assets | $0 | $0 | $0 |
Total Current Assets | $7,949 | $15,881 | $27,151 |
Long-term Assets | |||
Long-term Assets | $5,000 | $5,000 | $5,000 |
Accumulated Depreciation | $996 | $1,992 | $2,988 |
Total Long-term Assets | $4,004 | $3,008 | $2,012 |
Total Assets | $11,953 | $18,889 | $29,163 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $508 | $896 | $1,103 |
Current Borrowing | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 |
Subtotal Current Liabilities | $508 | $896 | $1,103 |
Long-term Liabilities | $0 | $0 | $0 |
Total Liabilities | $508 | $896 | $1,103 |
Paid-in Capital | $15,000 | $15,000 | $15,000 |
Retained Earnings | ($800) | ($3,555) | $2,993 |
Earnings | ($2,755) | $6,548 | $10,068 |
Total Capital | $11,445 | $17,993 | $28,060 |
Total Liabilities and Capital | $11,953 | $18,889 | $29,163 |
Net Worth | $11,445 | $17,993 | $28,060 |
7.6 Business Ratios
Business Ratios for Write Bike are shown in the table below using the NAICS code 711510 for Independent Writers.
Ratio Analysis | ||||
Year 1 | Year 2 | Year 3 | Industry Profile | |
Sales Growth | 0.00% | 56.95% | 17.16% | 11.74% |
Percent of Total Assets | ||||
Other Current Assets | 0.00% | 0.00% | 0.00% | 49.83% |
Total Current Assets | 66.50% | 84.08% | 93.10% | 79.65% |
Long-term Assets | 33.50% | 15.92% | 6.90% | 20.35% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 4.25% | 4.75% | 3.78% | 34.02% |
Long-term Liabilities | 0.00% | 0.00% | 0.00% | 21.07% |
Total Liabilities | 4.25% | 4.75% | 3.78% | 55.09% |
Net Worth | 95.75% | 95.25% | 96.22% | 44.91% |
Percent of Sales | ||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 100.00% | 100.00% | 100.00% | 100.00% |
Selling, General & Administrative Expenses | 107.40% | 88.80% | 85.30% | 75.93% |
Advertising Expenses | 0.00% | 0.00% | 0.00% | 2.60% |
Profit Before Interest and Taxes | -7.40% | 16.00% | 21.00% | 1.62% |
Main Ratios | ||||
Current | 15.66 | 17.72 | 24.63 | 1.69 |
Quick | 15.66 | 17.72 | 24.63 | 1.37 |
Total Debt to Total Assets | 4.25% | 4.75% | 3.78% | 60.72% |
Pre-tax Return on Net Worth | -24.07% | 51.99% | 51.25% | 5.11% |
Pre-tax Return on Assets | -23.05% | 49.52% | 49.32% | 13.02% |
Additional Ratios | Year 1 | Year 2 | Year 3 | |
Net Profit Margin | -7.40% | 11.20% | 14.70% | n.a |
Return on Equity | -24.07% | 36.39% | 35.88% | n.a |
Activity Ratios | ||||
Accounts Payable Turnover | 15.76 | 12.17 | 12.17 | n.a |
Payment Days | 27 | 23 | 27 | n.a |
Total Asset Turnover | 3.12 | 3.09 | 2.35 | n.a |
Debt Ratios | ||||
Debt to Net Worth | 0.04 | 0.05 | 0.04 | n.a |
Current Liab. to Liab. | 1.00 | 1.00 | 1.00 | n.a |
Liquidity Ratios | ||||
Net Working Capital | $7,441 | $14,985 | $26,048 | n.a |
Interest Coverage | 0.00 | 0.00 | 0.00 | n.a |
Additional Ratios | ||||
Assets to Sales | 0.32 | 0.32 | 0.43 | n.a |
Current Debt/Total Assets | 4% | 5% | 4% | n.a |
Acid Test | 15.66 | 17.72 | 24.63 | n.a |
Sales/Net Worth | 3.25 | 3.25 | 2.44 | 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 | |||||||||||||
0% | $500 | $750 | $850 | $1,600 | $2,000 | $2,400 | $2,600 | $2,800 | $3,100 | $2,300 | $1,900 | $1,500 | |
Web based | 0% | $335 | $503 | $570 | $1,072 | $1,340 | $1,608 | $1,742 | $1,876 | $2,077 | $1,541 | $1,273 | $1,005 |
Total Sales | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
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 | |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||
Web based | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
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 | ||
Steve | 0% | $1,500 | $1,500 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,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 | $1,500 | $1,500 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,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 | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Gross Margin | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
Gross Margin % | 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 | $1,500 | $1,500 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Account Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | $83 | |
Rent | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Utilities | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Insurance | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Travel, trade shows. other expenses | $150 | $800 | $150 | $150 | $250 | $150 | $150 | $150 | $600 | $150 | $100 | $100 | |
Total Operating Expenses | $2,158 | $2,808 | $2,658 | $2,658 | $3,758 | $3,658 | $3,658 | $3,658 | $4,108 | $3,658 | $3,608 | $3,608 | |
Profit Before Interest and Taxes | ($1,323) | ($1,556) | ($1,239) | $14 | ($418) | $350 | $684 | $1,018 | $1,069 | $183 | ($435) | ($1,103) | |
EBITDA | ($1,240) | ($1,473) | ($1,156) | $97 | ($335) | $433 | $767 | $1,101 | $1,152 | $266 | ($352) | ($1,020) | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($1,323) | ($1,556) | ($1,239) | $14 | ($418) | $350 | $684 | $1,018 | $1,069 | $183 | ($435) | ($1,103) | |
Net Profit/Sales | -158.44% | -124.19% | -87.25% | 0.52% | -12.51% | 8.73% | 15.75% | 21.77% | 20.65% | 4.76% | -13.71% | -44.03% |
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 | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
Subtotal Cash from Operations | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
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 | $835 | $1,253 | $1,420 | $2,672 | $3,340 | $4,008 | $4,342 | $4,676 | $5,177 | $3,841 | $3,173 | $2,505 | |
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 | $1,500 | $1,500 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Bill Payments | $19 | $597 | $1,203 | $575 | $578 | $672 | $575 | $575 | $590 | $1,010 | $573 | $525 | |
Subtotal Spent on Operations | $1,519 | $2,097 | $3,203 | $2,575 | $3,578 | $3,672 | $3,575 | $3,575 | $3,590 | $4,010 | $3,573 | $3,525 | |
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 | $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 | $1,519 | $2,097 | $3,203 | $2,575 | $3,578 | $3,672 | $3,575 | $3,575 | $3,590 | $4,010 | $3,573 | $3,525 | |
Net Cash Flow | ($684) | ($844) | ($1,784) | $97 | ($238) | $336 | $767 | $1,101 | $1,587 | ($169) | ($400) | ($1,020) | |
Cash Balance | $8,516 | $7,672 | $5,888 | $5,985 | $5,747 | $6,083 | $6,850 | $7,951 | $9,538 | $9,369 | $8,969 | $7,949 |
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 | $9,200 | $8,516 | $7,672 | $5,888 | $5,985 | $5,747 | $6,083 | $6,850 | $7,951 | $9,538 | $9,369 | $8,969 | $7,949 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $9,200 | $8,516 | $7,672 | $5,888 | $5,985 | $5,747 | $6,083 | $6,850 | $7,951 | $9,538 | $9,369 | $8,969 | $7,949 |
Long-term Assets | |||||||||||||
Long-term Assets | $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 |
Accumulated Depreciation | $0 | $83 | $166 | $249 | $332 | $415 | $498 | $581 | $664 | $747 | $830 | $913 | $996 |
Total Long-term Assets | $5,000 | $4,917 | $4,834 | $4,751 | $4,668 | $4,585 | $4,502 | $4,419 | $4,336 | $4,253 | $4,170 | $4,087 | $4,004 |
Total Assets | $14,200 | $13,433 | $12,506 | $10,639 | $10,653 | $10,332 | $10,585 | $11,269 | $12,287 | $13,791 | $13,539 | $13,056 | $11,953 |
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 | $556 | $1,184 | $556 | $556 | $653 | $556 | $556 | $556 | $991 | $556 | $508 | $508 |
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 | $556 | $1,184 | $556 | $556 | $653 | $556 | $556 | $556 | $991 | $556 | $508 | $508 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $556 | $1,184 | $556 | $556 | $653 | $556 | $556 | $556 | $991 | $556 | $508 | $508 |
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 | ($1,323) | ($2,879) | ($4,117) | ($4,103) | ($4,521) | ($4,171) | ($3,487) | ($2,469) | ($1,400) | ($1,217) | ($1,652) | ($2,755) |
Total Capital | $14,200 | $12,877 | $11,322 | $10,083 | $10,097 | $9,679 | $10,029 | $10,713 | $11,731 | $12,800 | $12,983 | $12,548 | $11,445 |
Total Liabilities and Capital | $14,200 | $13,433 | $12,506 | $10,639 | $10,653 | $10,332 | $10,585 | $11,269 | $12,287 | $13,791 | $13,539 | $13,056 | $11,953 |
Net Worth | $14,200 | $12,877 | $11,322 | $10,083 | $10,097 | $9,679 | $10,029 | $10,713 | $11,731 | $12,800 | $12,983 | $12,548 | $11,445 |