Case study - due in 3 hours only
Year 1%Year 2%Year 3%Year 4%Year 5%
Revenues$612,145100%$1,783,851100%$2,922,020100%$4,168,457100%$5,793,191100%
Cost of Sales$266,28944%$860,85148%$1,439,09649%$1,955,87947%$2,586,22345%
Gross Profit$345,85656%$923,00052%$1,482,92451%$2,212,57853%$3,206,96855%
Expenses
Sales & Marketing$121,37920%$354,76820%$559,58119%$861,46721%$1,180,66220%
Salaries & Benefits40,2507%80,5005%242,9328%322,5038%335,4036%
Advertising15,0002%50,0003%60,0002%150,0004%300,0005%
Direct Mail Campaign20,0003%150,0008%150,0005%250,0006%350,0006%
Free Kit15,0082%31,4292%42,4291%57,2791%77,3271%
Web Expenses Marketing25,0004%25,0001%35,0001%40,0001%60,0001%
Other Marketing Expenses6,1211%17,8391%29,2201%41,6851%57,9321%
General and Administration$103,33317%$201,58311%$369,86713%$424,27610%$531,2549%
Salaries & Benefits90,00015%178,25010%319,53411%367,2769%449,5878%
Depreciation1,3330%3,3330%10,3330%17,0000%21,6670%
Rent & Utilities5,0001%10,0001%20,0001%20,0000%35,0001%
Corporate Office7,0001%10,0001%20,0001%20,0000%25,0000%
Product Development (R&D)$61,00010%$227,32413%$288,01710%$318,9388%$450,0958%
Salaries & Benefits0%142,3248%148,0175%153,9384%160,0953%
Testing1,0000%5,0000%10,0000%15,0000%20,0000%
Product Development60,00010%80,0004%130,0004%150,0004%270,0005%
Other Expenses$91,30415%$112,0966%$120,5514%$129,2113%$169,8303%
Legal 15,0002%20,0001%25,0001%25,0001%25,0000%
Relocation0%10,0001%0%0%0%
Other1,0000%0%0%0%0%
Insurance15,3043%44,5962%73,0513%104,2112%144,8303%
Interest 60,00010%37,5002%22,5001%0%0%
Total Expenses$377,01662%$895,77150%$1,338,01646%$1,733,89242%$2,331,84140%
Profit Before Taxes($31,160)-5%$27,2292%$144,9085%$478,68611%$875,12715%
Taxes0%5,4460%28,9821%95,7372%175,0253%
Net Income($31,160)-5%$21,7831%$115,9264%$382,9499%$700,10212%
Confidential Information
Business Plan - Dated May-2005
Woburn, Massachusetts – USA
9 Financial Plan
9.1 Basis of Presentation
This plan contains five-year projected financial information for our company. While management believes that the assumptions underlying the projections are reasonable, there can be no assurance that these results can be realized or that actual results will meet management expectations. It is important to notice that our first month of operations is expected to be April 2005, causing the holiday season to be reflected in the financial statement as the third quarter in our projections. Monthly financial statements for the first two years are available on request.
9.2 Income Statement Assumptions – Revenues
The number of tables sold each month is the main driver of revenues for P’kolino. This number is estimated based on the expected outcome of the marketing efforts the company has planned for each year. At the beginning the company will sell two different types of tables targeting the high-end segment of the market. However, at the beginning of the third year the company plans to introduce a third table that will target the mid segment.
For the Storage Unit, management assumes that 30% of those customers that purchase tables are likely to buy the Storage Unit as well. The Storage Unit is designed so that it holds up to 10 toy kits (three are offered as a bundled package with the Storage Unit).
Every time a new table is sold, a new customer has been gained. P’kolino projections assume that one out of every two customers will purchase one Toy Kit every 12 months for a period of 3 to 4 years. Gift purchases of the Toy Kits are also estimated as a percentage of the existing customer base. One out of every two existing customers will trigger (influence) one Toy Kit gift purchase every 12 months.
Accessories will enter the revenue stream at the 2nd year of operations. It is estimated that as the product line expands accessories will eventually represent up to 25% of our sales.
The numbers of new customers are expected to increase at an average rate of 35% for years 3,4 & 5 for products targeting the high-end segment and at 45% for those targeting the mid-segment of the market (as a benchmark Pottery Barn Kids sales increased 35% in 2004).
P’kolino will remain in the high-end segment of the market for its first 2 years of operations and has priced its products accordingly. All products are priced as a function of both their manufacturing costs and their marketing positioning strategies. At year 3 a $400 table with a 45% contribution margin will be introduced to the mid-segment.
P’kolino will sell its products both online (direct) and through specialty retailers. Retailers are expected to markup our products by 50% (according to our primary research). Thus, our wholesale price will need to account for this markup. Management estimates that even though 80% (30% after year 2) of the units sold will be sold through retailers, only 23% of the revenue will come from this distribution channel. The percentage sold through retailers will drop over time as P’kolino gains brand recognition and further develops its direct distribution channel.
As stated earlier in this document the Toy kits and accessories are the main vehicles for generating recurrent revenue from existing customers.
Revenues for P’kolino will increase significantly during the winter holiday season. As is the case in the toy industry, playroom products are seasonal and more than 50% of total revenues will be generated during this period. Summer will be the second best season because children are out of school and spending more time at home.
Note: the Third quarter represents the holiday season.
9.3 Income Statement Assumptions – Cost of Sales
Our business model assumes that manufacturing of all P’kolino products will be outsourced to Brazil and then eventually to an Asian manufacturer. The average cost of sales will be 47% of revenues. Cost of sales is estimated based on manufactured units.
9.4 Income Statement Assumptions – Expenses
Expenses for P’kolino are centered on three main areas: 1) Sales and Marketing, 2) General Administration Expenses and 3) Research and Development.
For the first year, sales and marketing expenses are close to 20% of sales. Developing our website, generating initial marketing materials and a direct mail campaign are the main uses of these funds. Again after year 3, marketing efforts intensify as P’kolino makes an effort to enter the mid-segment of the market with a new product.
Over time, General and Administration expenses converge towards the industry average. However, P’kolino’s business model calls for a lean organization that concentrates on sales, product development and marketing. Management will make every effort to outsource all areas of the business not directly related to the core competency of the company. By year 5, the company will have 10 employees. The company will open an office at a business incubator during its first and second year of operations. P’kolino will relocate to a new facility by the end of year 2.
Product development (or R&D) is central to the P’kolino business model. It will require 10% of revenues during the first and second year and 9% on average thereafter (the R&D for the first year has been partially funded and executed prior to starting operations). During years 1&2 the company will develop a table for the mid-segment of the market as well as new Toy kits and accessories.
Other expenses such as legal expenses, insurance, etc. are estimated based on industry averages.
9.5 Balance Sheet Assumptions
P’kolino outsources manufacturing of their products allowing it to minimize investment on fixed assets. Inventory is assumed at 45 days (meaning 8 inventory turns per year, equal to the industry average according to Hoover’s online database). Management believes it will be able to maintain this level due to its emphasis on direct distribution.
Accounts receivable will average 30 days due to expected receivables from sales to retailers. Direct sales will have limited receivables, occurring mostly by credit card.
Table designs will be considered intangible assets and supported by constant product development efforts.
Accounts payable will be 25 days during the first few years because vendors will require most of our purchases to be paid in advance. Over time, accounts payable will lengthen as we develop a credit history.
9.6 Funding Assumptions
The company will fund its operations through equity and convertible long-term debt. Founders have issued $50.7K worth of equity. Proceeds will be used to pay for the product development of the initial product line. Additional funding will come in the form of long-term convertible debt (convertible into equity at the lender’s discretion) for up to $400K over the next five years, at a 15% annual interest rate. Friends and family will be the primary investors initially.
9.7 Cash Flow Assumptions
Investments will maintain positive cash flow the first 2 years. After this period, P’kolino estimates that it will generate enough cash from operations to repay the long-term debt and finance future growth.
9.8 Breakeven Analysis
CONFIDENTIAL INFORMATION
Business Plan
May-2005
Prepared by:
J.B. Schneider &
Antonio Turco-Rivas N.
Contact Information:
Phone: (781) 497-0913
Email: [email protected]
Address:
600 West Cummings Park
Suite 5350�Woburn, MA 01801
The information contained in this document is highly confidential. Except if stated herein, none of the material may be copied, reproduced, distributed, republished, downloaded, displayed, posted or transmitted in any form or by any means, including, but not limited to, electronic, mechanical, photocopying, recording, or otherwise, without the prior written authorization from P’kolino, LLC.
Exhibit 9-A
The Playroom Furniture Market
� EMBED Word.Picture.8 ���
Exhibit 9-B
Prices and Manufacturing Cost
� EMBED Word.Picture.8 ���
Exhibit 9-C
% of Revenues by Distribution Channel
� EMBED Word.Picture.8 ���
Exhibit 9-D
Revenue Mix (% of revenue by type of product)
� EMBED Word.Picture.8 ���
Exhibit 9-E
Seasonal Sales – Number of tables sold per month Year 1 & 2
� EMBED Word.Picture.8 ���
Exhibit 9-F
Revenue Forecast
� EMBED Word.Picture.8 ���
Exhibit 9-G
Revenue Monthly Forecast
� EMBED Word.Picture.8 ���
Exhibit 9-H
Cost of Sales
Manufacturing Costs�
Year 1�
Year 2�
Year 3�
Year 4�
Year 5�
�
Table A�
�
$116,610�
$244,205�
$329,677�
$445,064�
$600,836�
�
Table B�
�
$62,790�
$131,495�
$177,518�
$239,650�
$323,527�
�
Table C�
�
$0�
$0�
$84,000�
$140,000�
$168,000�
�
�
�
�
�
�
�
�
�
Storage Unit�
�
$31,878�
$66,759�
$115,325�
$163,668�
$214,652�
�
Kits�
�
$25,818�
$85,988�
$95,251�
$157,954�
$237,232�
�
Accessories�
�
$0�
$277,900�
$436,968�
$589,907�
$796,374�
�
Other�
�
$29,193�
$54,504�
$200,357�
$219,636�
$245,602�
�
Total COGS�
�
$266,289�
$860,851�
$1,439,096�
$1,955,879�
$2,586,223�
�
�
�
�
�
�
�
�
�
Exhibit 9-I
Projected Financial Statements
� EMBED Excel.Sheet.8 ���
Exhibit 9-J
Projected Balance Sheet Statements
� EMBED Word.Picture.8 ���
Exhibit 9-K
Use of Funds (average)
� EMBED Word.Picture.8 ���
Exhibit 9-M
Projected Cash Flow Statements
� EMBED Word.Picture.8 ���
Exhibit 9-N
Break-even vs. Revenues
� EMBED Word.Picture.8 ���
_1181023805.unknown
_1181023817.unknown
_1181023821.unknown
_1205318577.xls
Sheet2
| Year 1 | % | Year 2 | % | Year 3 | % | Year 4 | % | Year 5 | % | |
| Revenues | $612,145 | 100% | $1,783,851 | 100% | $2,922,020 | 100% | $4,168,457 | 100% | $5,793,191 | 100% |
| Cost of Sales | $266,289 | 44% | $860,851 | 48% | $1,439,096 | 49% | $1,955,879 | 47% | $2,586,223 | 45% |
| Gross Profit | $345,856 | 56% | $923,000 | 52% | $1,482,924 | 51% | $2,212,578 | 53% | $3,206,968 | 55% |
| Expenses | ||||||||||
| Sales & Marketing | $121,379 | 20% | $354,768 | 20% | $559,581 | 19% | $861,467 | 21% | $1,180,662 | 20% |
| Salaries & Benefits | 40,250 | 7% | 80,500 | 5% | 242,932 | 8% | 322,503 | 8% | 335,403 | 6% |
| Advertising | 15,000 | 2% | 50,000 | 3% | 60,000 | 2% | 150,000 | 4% | 300,000 | 5% |
| Direct Mail Campaign | 20,000 | 3% | 150,000 | 8% | 150,000 | 5% | 250,000 | 6% | 350,000 | 6% |
| Free Kit | 15,008 | 2% | 31,429 | 2% | 42,429 | 1% | 57,279 | 1% | 77,327 | 1% |
| Web Expenses Marketing | 25,000 | 4% | 25,000 | 1% | 35,000 | 1% | 40,000 | 1% | 60,000 | 1% |
| Other Marketing Expenses | 6,121 | 1% | 17,839 | 1% | 29,220 | 1% | 41,685 | 1% | 57,932 | 1% |
| General and Administration | $103,333 | 17% | $201,583 | 11% | $369,867 | 13% | $424,276 | 10% | $531,254 | 9% |
| Salaries & Benefits | 90,000 | 15% | 178,250 | 10% | 319,534 | 11% | 367,276 | 9% | 449,587 | 8% |
| Depreciation | 1,333 | 0% | 3,333 | 0% | 10,333 | 0% | 17,000 | 0% | 21,667 | 0% |
| Rent & Utilities | 5,000 | 1% | 10,000 | 1% | 20,000 | 1% | 20,000 | 0% | 35,000 | 1% |
| Corporate Office | 7,000 | 1% | 10,000 | 1% | 20,000 | 1% | 20,000 | 0% | 25,000 | 0% |
| Product Development (R&D) | $61,000 | 10% | $227,324 | 13% | $288,017 | 10% | $318,938 | 8% | $450,095 | 8% |
| Salaries & Benefits | 0% | 142,324 | 8% | 148,017 | 5% | 153,938 | 4% | 160,095 | 3% | |
| Testing | 1,000 | 0% | 5,000 | 0% | 10,000 | 0% | 15,000 | 0% | 20,000 | 0% |
| Product Development | 60,000 | 10% | 80,000 | 4% | 130,000 | 4% | 150,000 | 4% | 270,000 | 5% |
| Other Expenses | $91,304 | 15% | $112,096 | 6% | $120,551 | 4% | $129,211 | 3% | $169,830 | 3% |
| Legal | 15,000 | 2% | 20,000 | 1% | 25,000 | 1% | 25,000 | 1% | 25,000 | 0% |
| Relocation | 0% | 10,000 | 1% | 0% | 0% | 0% | ||||
| Other | 1,000 | 0% | 0% | 0% | 0% | 0% | ||||
| Insurance | 15,304 | 3% | 44,596 | 2% | 73,051 | 3% | 104,211 | 2% | 144,830 | 3% |
| Interest | 60,000 | 10% | 37,500 | 2% | 22,500 | 1% | 0% | 0% | ||
| Total Expenses | $377,016 | 62% | $895,771 | 50% | $1,338,016 | 46% | $1,733,892 | 42% | $2,331,841 | 40% |
| Profit Before Taxes | ($31,160) | -5% | $27,229 | 2% | $144,908 | 5% | $478,686 | 11% | $875,127 | 15% |
| Taxes | 0% | 5,446 | 0% | 28,982 | 1% | 95,737 | 2% | 175,025 | 3% | |
| Net Income | ($31,160) | -5% | $21,783 | 1% | $115,926 | 4% | $382,949 | 9% | $700,102 | 12% |