Don't bother with copy and paste.

Get this complete sample business plan as a free text document.

Download for free

Auto Sales & Parts icon Export Automobile Parts Business Plan

Start your plan

D.A.P. Exports

Executive Summary

D.A.P. Exports is a business that exports automobile parts and auto lubricants to Jamaica and other countries including Venezuela, Columbia and Ecuador. Many of the company’s shipments combine American-made products with foreign parts with some re-packaging and labeling.

Auto part sales is currently a $100 million industry in Latin America and the Caribbean. In these countries, a majority of the automobiles were manufactured in the 1980’s. Finding replacement parts for these autos has become a difficult process as auto makers focus on cars produced in the last ten years.

D.A.P. Exports has established an extensive network of customer contacts in the region. James Dunn, owner of D.A.P Exports, has twenty years of experience selling consumer products in Latin America and the Caribbean. James has been a salesperson for Axiom Food Products, Klymor Manufacturing, and Dudley Food Products. 

During those years, James used taxi services in Latin America and the Caribbean. It was during one of those trips that he became aware of the demand for auto parts and auto lubricants. James also discovered the best distribution system for auto products in the region, through the local taxi companies.

D.A.P. Exports will contract with the region’s taxi companies to provide auto parts and auto lubricants at wholesale prices. The taxi companies will either use the parts to repair their own vehicles or they will sell the parts to consumers. D.A.P Exports will also sell auto parts to auto part stores in the region.

Export automobile parts business plan, executive summary chart image

1.1 Objectives

D.A.P. Exports’ objectives are as follows:

  • Achieve handsome sales revenues during first year of operation.
  • Achieve a customer base of 100 taxi companies in the region.
  • Increase sales modestly during the second year of operation.

1.2 Mission

The mission of D.A.P. Exports is to be the auto parts provider of choice with the region’s taxi companies.

Company Summary

D.A.P. Exports is a business that exports automobile parts and auto lubricants to Jamaica and other countries including Venezuela, Columbia and Ecuador. Many of the company’s shipments combine American-made products with foreign parts with some re-packaging and labeling.

The company will be organized as a limited liability partnership.

D.A.P. Exports has an 8,000 square foot facility in Monroe, Florida. The facility is located near the South Florida transportation hub critical to our important markets. it will keep costs in control as well as enabling fast and economical access to our key markets for company-related business.

2.1 Company Ownership

D.A.P. Exports is an LLC partnership owned by James Dunn and a silent partner (name withheld).

2.2 Start-up Summary

The start-up expense for D.A.P. Exports is focused primarily on inventory and repackaging equipment. James Dunn will personally invest in the company. The silent partner will invest additional funds. In addition, Dunn will also secure a long-term loan.

Export automobile parts business plan, company summary chart image

Start-up
Requirements
Start-up Expenses
Legal $10,000
Stationery etc. $1,000
Brochures $2,000
Insurance $2,000
Rent $2,000
Expensed Equipment $50,000
Total Start-up Expenses $67,000
Start-up Assets
Cash Required $83,000
Start-up Inventory $100,000
Other Current Assets $0
Long-term Assets $0
Total Assets $183,000
Total Requirements $250,000
Start-up Funding
Start-up Expenses to Fund $67,000
Start-up Assets to Fund $183,000
Total Funding Required $250,000
Assets
Non-cash Assets from Start-up $100,000
Cash Requirements from Start-up $83,000
Additional Cash Raised $0
Cash Balance on Starting Date $83,000
Total Assets $183,000
Liabilities and Capital
Liabilities
Current Borrowing $0
Long-term Liabilities $100,000
Accounts Payable (Outstanding Bills) $0
Other Current Liabilities (interest-free) $0
Total Liabilities $100,000
Capital
Planned Investment
James Dunn $50,000
Silent Partner $100,000
Additional Investment Requirement $0
Total Planned Investment $150,000
Loss at Start-up (Start-up Expenses) ($67,000)
Total Capital $83,000
Total Capital and Liabilities $183,000
Total Funding $250,000

Products

D.A.P. Exports’ products are the following:

  • Transmission parts
  • Engine parts
  • Electrical parts
  • Engine lubricants

Market Analysis Summary

Auto part sales is a $100 million dollar industry in Latin America and the Caribbean. In these countries, a majority of the automobiles were manufactured in the 1980s. Finding replacement parts for these autos has become a difficult process as auto makers focus on cars produced in the last ten years.

Typically, old cars are used as a source of parts once they can no longer be repaired. The major obstacle to accessing the market is the sparse number of auto part stores in the region where the prices for auto parts are high. Most of these auto stores focus on the upscale customer and don’t carry a wide range of parts for the older autos.

D.A.P. Exports will sell parts to auto stores but we will also pursue a new distribution network as well. The largest buyers of auto parts in the region are taxi companies. D.A.P. Exports has established an extensive network of contacts with these companies, and we will sell directly to them.

4.1 Market Segmentation

D.A.P. Exports will focus on the following target customers:

  • Taxi companies
  • Auto part stores

It is expected that individuals will also purchase from  D.A.P., but the repeat business, lower price sensitivity and larger volume per order mean that stores and taxi services will be more attractive customers for D.A.P.

Export automobile parts business plan, market analysis summary chart image

Market Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Potential Customers Growth CAGR
Taxi Companies 10% 2,000 2,200 2,420 2,662 2,928 10.00%
Auto Part Stores 8% 4,000 4,320 4,666 5,039 5,442 8.00%
Total 8.68% 6,000 6,520 7,086 7,701 8,370 8.68%

4.2 Industry Analysis

Currently, the markets are too small to attract many competitors. The auto parts shops in the region are not expanding to meet the demand for parts for older cars. They are instead focusing on the newer cars that are being imported into the countries by wealthy individuals.

Utilizing the taxi services as a distribution network as well as primary customers is an excellent strategy to capture market share of a segment that is currently being ignored by bigger players.

4.3 Target Market Segment Strategy

It is estimated that there are over 25,000 vehicles in the region that are used by taxi services. And that number is growing.

The taxi firms are excellent target customers for D.A.P. Export products. First, they represent the largest buying block in our target countries. In addition there is no established channel for them to purchase parts for their cars at this time. 

By buying direct from D.A.P. Export, they reduce the cost of parts and they get exactly what they need quickly.

Although many of the taxi drivers are independent or work for small companies, the informal network within this group is extensive. There is a lot of downtime in this business, where drivers are waiting for fares. They will chat to friends/colleagues about their cars and their work. We will benefit from this through word-of-mouth recommendations.

4.4 Competition and Buying Patterns

Without much competition, the key to maintaining the customer base is the right parts, at a reasonable price, delivered quickly. As D.A.P. Exports meets customer’s demand for parts in a timely manner, sales will grow. The company will be able to strengthen the business relationships that will be critical when competition does emerge.

Strategy and Implementation Summary

D.A.P. Exports will offer a 15% discount on all purchases of $1,000 or more. We will also have two salespeople based in Latin America and the Caribbean. Our focus will be to establish our future on a strong relationship with the region’s taxi services.

James has established export contacts in Latin America and the Caribbean, that will make the process of developing an export channel for car parts much easier. In these countries, much business in done by a handshake and word of mouth, rather than formal contracts. His experience and contacts will be invaluable in this environment.

5.1 Competitive Edge

The products that D.A.P is selling are made for older cars, and the trend in this country is towards newer cars, therefore domestic demand for these parts is falling. For this reason, James will be able to negotiate excellent prices on the products that he will sell. He will also order in bulk which will further increase his negotiating leverage.

The other competitive edge of D.A.P. Exports is that we can assemble a product package that is exactly what a specific customer wants. When the taxi service buys directly from D.A.P. Exports, they will receive the highest quality product at the lowest price. Previously, because of the lack of an organized, established channel, car owners had to spend time shopping around for parts. Therefore their cars would be off the road for longer periods of time–every day costing them more lost revenue.

5.2 Sales Forecast

The following is the sales forecast for three years.

Export automobile parts business plan, strategy and implementation summary chart image

Export automobile parts business plan, strategy and implementation summary chart image

Sales Forecast
Year 1 Year 2 Year 3
Sales
Auto Parts $410,000 $480,000 $550,000
Auto Lubricants $186,000 $230,000 $274,000
Other $0 $0 $0
Total Sales $596,000 $710,000 $824,000
Direct Cost of Sales Year 1 Year 2 Year 3
Auto Parts $200,000 $240,000 $275,000
Auto Lubricants $93,000 $115,000 $137,000
Other $0 $0 $0
Subtotal Direct Cost of Sales $293,000 $355,000 $412,000

5.3 Milestones

The accompanying chart and table lists important program milestones, with dates and managers in charge, and budgets for each. The milestone schedule indicates our emphasis on planning for implementation.

Export automobile parts business plan, strategy and implementation summary chart image

Milestones
Milestone Start Date End Date Budget Manager Department
Facility Set-up 5/1/2002 5/20/2002 $20,000 James Dunn Marketing
Inventory Set-up 5/1/2002 5/20/2002 $100,000 James Dunn Department
Marketing Campaign 5/1/2002 6/15/2002 $20,000 James Dunn Department
Totals $140,000

5.4 Marketing Strategy

During the months of May and June the regional salespeople will deliver presentations to taxi firms and auto parts stores in the region. D.A.P. Export will offer a 15% discount on all purchases over $1,000.

The key to the marketing strategy is continuous follow-up with customers so we can anticipate the parts inventory that will be needed in the future.

Management Summary

James Dunn, owner of D.A.P Exports, will manage the business. He has twenty years of experience selling consumer products in Latin America and the Caribbean, so has extensive knowledge of this region and culture. In addition he has contacts with people and businesses that can only be gained from years of living or working in a country. James has been a salesperson for Axiom Food Products, Klymor Manufacturing, and Dudley Food Products, and during this time travelled to the Caribbean and Latin America at least three times a year.

James has excellent management skills. In his last position he managed a sales staff of five people, and each year the team beat its sales quota by more than 10%. He was successful in motivating the best performance of each staff member.

James has also had experience in running a small business in the past. He and his wife have successfully run a small catering business in their hometown for the past four years. James wife will continue to run this business while he focuses on launching D.A.P. Exports.

6.1 Personnel Plan

D.A.P. Exports’ personnel are as follows:

  • James Dunn
  • Facility staff (4)
  • Sales staff (2)
Personnel Plan
Year 1 Year 2 Year 3
James Dunn $36,000 $39,000 $42,000
4 Facility Staff $86,400 $94,000 $102,000
2 Sales Staff $72,000 $80,000 $88,000
Total People 7 7 7
Total Payroll $194,400 $213,000 $232,000

Financial Plan

The following is the financial plan for D.A.P. Exports.

7.1 Break-even Analysis

The monthly break-even point, based on average monthly running costs and estimated variable costs of sales is shown in the table and chart below.

Export automobile parts business plan, financial plan chart image

Break-even Analysis
Monthly Revenue Break-even $42,743
Assumptions:
Average Percent Variable Cost 49%
Estimated Monthly Fixed Cost $21,730

7.2 Projected Profit and Loss

The following table and charts highlight the projected profit and loss for three years.

Export automobile parts business plan, financial plan chart image

Export automobile parts business plan, financial plan chart image

Export automobile parts business plan, financial plan chart image

Export automobile parts business plan, financial plan chart image

Pro Forma Profit and Loss
Year 1 Year 2 Year 3
Sales $596,000 $710,000 $824,000
Direct Cost of Sales $293,000 $355,000 $412,000
Other Production Expenses $0 $0 $0
Total Cost of Sales $293,000 $355,000 $412,000
Gross Margin $303,000 $355,000 $412,000
Gross Margin % 50.84% 50.00% 50.00%
Expenses
Payroll $194,400 $213,000 $232,000
Sales and Marketing and Other Expenses $6,000 $10,000 $15,000
Depreciation $0 $0 $0
Leased Equipment $0 $0 $0
Utilities $7,200 $8,000 $9,000
Insurance $0 $0 $0
Rent $24,000 $24,000 $24,000
Payroll Taxes $29,160 $31,950 $34,800
Other $0 $0 $0
Total Operating Expenses $260,760 $286,950 $314,800
Profit Before Interest and Taxes $42,240 $68,050 $97,200
EBITDA $42,240 $68,050 $97,200
Interest Expense $10,000 $10,000 $10,000
Taxes Incurred $9,672 $17,415 $26,160
Net Profit $22,568 $40,635 $61,040
Net Profit/Sales 3.79% 5.72% 7.41%

7.3 Projected Cash Flow

The following table and chart highlight the projected cash flow for three years.

Export automobile parts business plan, financial plan chart image

Pro Forma Cash Flow
Year 1 Year 2 Year 3
Cash Received
Cash from Operations
Cash Sales $149,000 $177,500 $206,000
Cash from Receivables $324,550 $509,078 $594,578
Subtotal Cash from Operations $473,550 $686,578 $800,578
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 $473,550 $686,578 $800,578
Expenditures Year 1 Year 2 Year 3
Expenditures from Operations
Cash Spending $194,400 $213,000 $232,000
Bill Payments $265,680 $487,380 $533,881
Subtotal Spent on Operations $460,080 $700,380 $765,881
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 $460,080 $700,380 $765,881
Net Cash Flow $13,470 ($13,802) $34,697
Cash Balance $96,470 $82,668 $117,365

7.4 Projected Balance Sheet

The following table highlights the projected balance sheet for three years.

Pro Forma Balance Sheet
Year 1 Year 2 Year 3
Assets
Current Assets
Cash $96,470 $82,668 $117,365
Accounts Receivable $122,450 $145,872 $169,293
Inventory $46,200 $55,976 $64,964
Other Current Assets $0 $0 $0
Total Current Assets $265,120 $284,516 $351,622
Long-term Assets
Long-term Assets $0 $0 $0
Accumulated Depreciation $0 $0 $0
Total Long-term Assets $0 $0 $0
Total Assets $265,120 $284,516 $351,622
Liabilities and Capital Year 1 Year 2 Year 3
Current Liabilities
Accounts Payable $59,552 $38,313 $44,379
Current Borrowing $0 $0 $0
Other Current Liabilities $0 $0 $0
Subtotal Current Liabilities $59,552 $38,313 $44,379
Long-term Liabilities $100,000 $100,000 $100,000
Total Liabilities $159,552 $138,313 $144,379
Paid-in Capital $150,000 $150,000 $150,000
Retained Earnings ($67,000) ($44,432) ($3,797)
Earnings $22,568 $40,635 $61,040
Total Capital $105,568 $146,203 $207,243
Total Liabilities and Capital $265,120 $284,516 $351,622
Net Worth $105,568 $146,203 $207,243

7.5 Business Ratios

Business ratios for the years of this plan are shown below. Industry profile ratios based on the Standard Industrial Classification (SIC) code 5013, Moter Vehicles Supplies and New Parts, are shown for comparison.

Ratio Analysis
Year 1 Year 2 Year 3 Industry Profile
Sales Growth 0.00% 19.13% 16.06% 12.20%
Percent of Total Assets
Accounts Receivable 46.19% 51.27% 48.15% 25.10%
Inventory 17.43% 19.67% 18.48% 46.10%
Other Current Assets 0.00% 0.00% 0.00% 15.10%
Total Current Assets 100.00% 100.00% 100.00% 86.30%
Long-term Assets 0.00% 0.00% 0.00% 13.70%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 22.46% 13.47% 12.62% 46.60%
Long-term Liabilities 37.72% 35.15% 28.44% 11.50%
Total Liabilities 60.18% 48.61% 41.06% 58.10%
Net Worth 39.82% 51.39% 58.94% 41.90%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 50.84% 50.00% 50.00% 21.70%
Selling, General & Administrative Expenses 47.05% 44.28% 42.59% 13.20%
Advertising Expenses 1.01% 1.41% 1.82% 0.70%
Profit Before Interest and Taxes 7.09% 9.58% 11.80% 1.40%
Main Ratios
Current 4.45 7.43 7.92 1.98
Quick 3.68 5.97 6.46 0.78
Total Debt to Total Assets 60.18% 48.61% 41.06% 58.10%
Pre-tax Return on Net Worth 30.54% 39.71% 42.08% 3.80%
Pre-tax Return on Assets 12.16% 20.40% 24.80% 9.00%
Additional Ratios Year 1 Year 2 Year 3
Net Profit Margin 3.79% 5.72% 7.41% n.a
Return on Equity 21.38% 27.79% 29.45% n.a
Activity Ratios
Accounts Receivable Turnover 3.65 3.65 3.65 n.a
Collection Days 56 92 93 n.a
Inventory Turnover 5.31 6.95 6.81 n.a
Accounts Payable Turnover 5.46 12.17 12.17 n.a
Payment Days 28 38 28 n.a
Total Asset Turnover 2.25 2.50 2.34 n.a
Debt Ratios
Debt to Net Worth 1.51 0.95 0.70 n.a
Current Liab. to Liab. 0.37 0.28 0.31 n.a
Liquidity Ratios
Net Working Capital $205,568 $246,203 $307,243 n.a
Interest Coverage 4.22 6.81 9.72 n.a
Additional Ratios
Assets to Sales 0.44 0.40 0.43 n.a
Current Debt/Total Assets 22% 13% 13% n.a
Acid Test 1.62 2.16 2.64 n.a
Sales/Net Worth 5.65 4.86 3.98 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
Auto Parts 0% $0 $0 $20,000 $26,000 $30,000 $36,000 $40,000 $44,000 $48,000 $50,000 $56,000 $60,000
Auto Lubricants 0% $0 $0 $8,000 $12,000 $12,000 $16,000 $20,000 $20,000 $24,000 $24,000 $26,000 $24,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $0 $28,000 $38,000 $42,000 $52,000 $60,000 $64,000 $72,000 $74,000 $82,000 $84,000
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
Auto Parts $0 $0 $10,000 $13,000 $15,000 $18,000 $20,000 $22,000 $24,000 $25,000 $23,000 $30,000
Auto Lubricants $0 $0 $4,000 $6,000 $6,000 $8,000 $10,000 $10,000 $12,000 $12,000 $13,000 $12,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $14,000 $19,000 $21,000 $26,000 $30,000 $32,000 $36,000 $37,000 $36,000 $42,000
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
James Dunn 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
4 Facility Staff 0% $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200
2 Sales Staff 0% $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200

General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0

Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $0 $0 $28,000 $38,000 $42,000 $52,000 $60,000 $64,000 $72,000 $74,000 $82,000 $84,000
Direct Cost of Sales $0 $0 $14,000 $19,000 $21,000 $26,000 $30,000 $32,000 $36,000 $37,000 $36,000 $42,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $14,000 $19,000 $21,000 $26,000 $30,000 $32,000 $36,000 $37,000 $36,000 $42,000
Gross Margin $0 $0 $14,000 $19,000 $21,000 $26,000 $30,000 $32,000 $36,000 $37,000 $46,000 $42,000
Gross Margin % 0.00% 0.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 56.10% 50.00%
Expenses
Payroll $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200
Sales and Marketing and Other Expenses $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Payroll Taxes 15% $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730
Profit Before Interest and Taxes ($21,730) ($21,730) ($7,730) ($2,730) ($730) $4,270 $8,270 $10,270 $14,270 $15,270 $24,270 $20,270
EBITDA ($21,730) ($21,730) ($7,730) ($2,730) ($730) $4,270 $8,270 $10,270 $14,270 $15,270 $24,270 $20,270
Interest Expense $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Taxes Incurred ($6,769) ($6,769) ($2,569) ($1,069) ($469) $1,031 $2,231 $2,831 $4,031 $4,331 $7,031 $5,831
Net Profit ($15,794) ($15,794) ($5,994) ($2,494) ($1,094) $2,406 $5,206 $6,606 $9,406 $10,106 $16,406 $13,606
Net Profit/Sales 0.00% 0.00% -21.41% -6.56% -2.61% 4.63% 8.68% 10.32% 13.06% 13.66% 20.01% 16.20%

Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $0 $0 $7,000 $9,500 $10,500 $13,000 $15,000 $16,000 $18,000 $18,500 $20,500 $21,000
Cash from Receivables $0 $0 $0 $700 $21,250 $28,600 $31,750 $39,200 $45,100 $48,200 $54,050 $55,700
Subtotal Cash from Operations $0 $0 $7,000 $10,200 $31,750 $41,600 $46,750 $55,200 $63,100 $66,700 $74,550 $76,700
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $0 $7,000 $10,200 $31,750 $41,600 $46,750 $55,200 $63,100 $66,700 $74,550 $76,700
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 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200
Bill Payments ($406) ($798) ($266) $3,844 $5,314 $6,231 $16,894 $43,008 $43,641 $50,728 $48,778 $48,711
Subtotal Spent on Operations $15,794 $15,402 $15,934 $20,044 $21,514 $22,431 $33,094 $59,208 $59,841 $66,928 $64,978 $64,911
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 $15,794 $15,402 $15,934 $20,044 $21,514 $22,431 $33,094 $59,208 $59,841 $66,928 $64,978 $64,911
Net Cash Flow ($15,794) ($15,402) ($8,934) ($9,844) $10,236 $19,169 $13,656 ($4,008) $3,259 ($228) $9,572 $11,789
Cash Balance $67,206 $51,803 $42,869 $33,025 $43,260 $62,429 $76,085 $72,077 $75,336 $75,109 $84,681 $96,470
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 $83,000 $67,206 $51,803 $42,869 $33,025 $43,260 $62,429 $76,085 $72,077 $75,336 $75,109 $84,681 $96,470
Accounts Receivable $0 $0 $0 $21,000 $48,800 $59,050 $69,450 $82,700 $91,500 $100,400 $107,700 $115,150 $122,450
Inventory $100,000 $100,000 $100,000 $86,000 $67,000 $46,000 $28,600 $33,000 $35,200 $39,600 $40,700 $39,600 $46,200
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $183,000 $167,206 $151,803 $149,869 $148,825 $148,310 $160,479 $191,785 $198,777 $215,336 $223,509 $239,431 $265,120
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 $183,000 $167,206 $151,803 $149,869 $148,825 $148,310 $160,479 $191,785 $198,777 $215,336 $223,509 $239,431 $265,120
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 $0 $392 $4,452 $5,902 $6,482 $16,245 $42,345 $42,732 $49,885 $47,952 $47,469 $59,552
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 $0 $392 $4,452 $5,902 $6,482 $16,245 $42,345 $42,732 $49,885 $47,952 $47,469 $59,552
Long-term Liabilities $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Total Liabilities $100,000 $100,000 $100,392 $104,452 $105,902 $106,482 $116,245 $142,345 $142,732 $149,885 $147,952 $147,469 $159,552
Paid-in Capital $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000
Retained Earnings ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000)
Earnings $0 ($15,794) ($31,589) ($37,583) ($40,077) ($41,172) ($38,766) ($33,560) ($26,955) ($17,549) ($7,443) $8,962 $22,568
Total Capital $83,000 $67,206 $51,411 $45,417 $42,923 $41,828 $44,234 $49,440 $56,045 $65,451 $75,557 $91,962 $105,568
Total Liabilities and Capital $183,000 $167,206 $151,803 $149,869 $148,825 $148,310 $160,479 $191,785 $198,777 $215,336 $223,509 $239,431 $265,120
Net Worth $83,000 $67,206 $51,411 $45,417 $42,923 $41,828 $44,234 $49,440 $56,045 $65,451 $75,557 $91,962 $105,568