Musical Instrument Store Business Plan

There is an exciting opportunity for a full-service musical instrument retailer in Albuquerque. While there are several musical instrument retailers in this city of over 500,000 people, there are only three small school band and orchestral instrument dealers with limited selections and hours. On the other hand, big chains with a focus on guitars and electrical instruments are competing on prices, neglecting customer service.

MusicWest will provide a superior shopping experience with a vast selection of school band and orchestra instruments, as well as guitars, keyboards, and accessories, at reasonable prices. Our products will be backed by skilled repair services and a knowledgeable and friendly staff who prioritize customer education. We will stand out from our competitors by offering ongoing music community events, such as free lessons, music clubs, and after-sale follow-ups to cultivate long-term customer relationships. Our unique marketing schemes include “You Play, We Pay” (donating a portion of instrument sales and rentals to local school band programs) and “100% Money Back” trade-up programs, allowing customers to upgrade their instruments within a year by receiving 100% of their purchase price as credit.

MusicWest will cater to the novice, hobbyist, and semi-professional musicians who value customer service, knowledgeable assistance, and affordable options when making significant purchases. By differentiating ourselves from competitors, we will quickly gain a sizable market share. Our branding will be established through superior service, an inviting retail environment, interactive merchandising, and a compelling motto: Stop Dreaming, Start Playing. Once customers experience our store, they will want to return for the exceptional treatment they won’t find elsewhere.

Co-owner, David Moore, brings over seven years of experience as a store manager at two successful local music stores. He has firsthand knowledge of missed opportunities due to lack of follow-through or planning and understands the needs of local customers.

Based on experience at other local music stores, David Moore conservatively projects sales of over $500,000 in the first year, increasing to nearly $700,000 by year three. We anticipate generating a profit starting in September, with increasing profits thereafter.

Although MusicWest may not become the largest, our goal is to become a “Must-Shop Destination” for anyone looking to buy a new or used musical instrument in Albuquerque!

Musical Instrument Store Business Plan Example

MusicWest is a musical instrument retailer in Albuquerque’s Westside. We set ourselves apart from competitors by providing personal attention and educating customers about our products. We also offer loyalty programs and on-site repair services. Our goal is to have the largest selection of School Band and Orchestral instruments in New Mexico.

Musical Instrument Store Business Plan Example

Start-up Expenses:

– Legal: $1,000

– Stationery etc.: $500

– Space Renovation/Preparation/Signage: $20,000

– Miscellaneous Expenses: $1,500

– Insurance: $500

– Rent & Deposits: $4,000

– Pre-Opening Salaries: $4,000

– Phone System: $2,500

– Other: $0

– Total Start-up Expenses: $34,000

Start-up Assets:

– Cash Required: $68,500

– Start-up Inventory: $150,000

– Other Current Assets: $0

– Long-term Assets: $7,500

– Total Assets: $226,000

Total Requirements: $260,000

Start-up Funding:

– Start-up Expenses to Fund: $34,000

– Start-up Assets to Fund: $226,000

– Total Funding Required: $260,000

Assets:

– Non-cash Assets from Start-up: $157,500

– Cash Requirements from Start-up: $68,500

– Additional Cash Raised: $0

– Cash Balance on Starting Date: $68,500

– Total Assets: $226,000

Liabilities and Capital:

– Liabilities:

– Current Borrowing: $0

– Long-term Liabilities: $200,000

– Accounts Payable (Outstanding Bills): $0

– Other Current Liabilities (interest-free): $0

– Total Liabilities: $200,000

– Capital:

– Planned Investment

– Investment by Dave & Kayle Moore: $50,000

– Investment by Ray Himes: $10,000

– Additional Investment Requirement: $0

– Total Planned Investment: $60,000

– Loss at Start-up (Start-up Expenses): ($34,000)

– Total Capital: $26,000

– Total Capital and Liabilities: $226,000

– Total Funding: $260,000

Company Locations and Facilities:

We have chosen a site at Ladera Shopping Center on Coors Blvd. near I-40 for several reasons:

– Close proximity to Interstate 40.

– Safe and plentiful parking area.

– Near high-traffic tenants such as Home Depot and Staples, and anchored by a WalMart Supercenter.

– Beneficial demographics: over 150,000 households within a 5-mile radius, 85,000+ cars per day on the two cross-streets, and no direct competitors within 10 miles.

– All of the above qualities are consistent with MusicWest’s goal of providing a fresh approach to musical instrument retailing. We are looking at leasing approximately 3,500 sq.ft. of space, which will allow sufficient room for up to six lesson studios, a repair area, and necessary storage and office space. We expect usable selling space to end up being around 2,400 sq.ft.

Company Ownership:

MusicWest will be a partnership. The principles of the business are Kayle and David Moore. Kayle Moore will assume the position of President/Office Manager, while David Moore will assume the duties of Store Manager.

Products and Services:

MusicWest will sell new and used musical instruments and accessories. Our primary items will be new band and orchestral instruments, electric and acoustic guitars, amplifiers, and electronic keyboards. In addition, we will have a full-service, on-site repair and customization department (band instruments, guitars, and electronics).

We will offer a music lesson program featuring top degreed instructors, including private and group lessons. We will also develop music clubs geared towards children and seniors to serve our local community.

Although offering school band and orchestral instruments, service and lessons will be our main competitive advantage. Guitars will remain the primary revenue producer for musical instrument stores.

Product and Service Description:

MusicWest will offer several name brand instruments such as a large selection of band instruments by Selmer/Bach, Yamaha, and Leblanc with an emphasis on the intermediate level instruments. In addition to complete repair services, we will emphasize upgrades and customization items to develop other income streams. We will always pursue the product that best suits our client’s interest.

Competitive Comparison:

MusicWest is different from its competitors in several key areas. Our three largest competitors do not carry band and orchestral instruments, one of our primary focuses. We must offer varied services and product mixes and be competitively priced as well, in order to survive. Accessories are the highest profit center for the store, and we must keep our department well-stocked to take advantage of our competitors’ flaws and avoid this pitfall ourselves.

Fulfillment:

MusicWest will buy its inventory directly from the manufacturer when feasible to obtain the lowest price possible. We will frequently compare prices of distributors to ensure we are getting the best price per item. MusicWest will always put the quality/value of the product ahead of price. We intend to buy key items in bulk to obtain a pricing advantage over our direct competitors. Common discounts in the industry consist of free freight, repayment term incentives, additional free merchandise, or incremental percentage discounts on quantity purchases. We should not risk over-stocking new or unproven merchandise just to get a small advantage in price over competitors.

Technology:

The Music Industry is currently riding a trend toward high-tech electronics, notably in guitar related effects and multi-track recording hard/software. Digital keyboards are also seeing increased market share as technology becomes more accessible. However, prices in this industry are dropping sharply, so we must bundle products together as packages to increase profits and build sales.

READ MORE  Office Consulting Business Plan Example

Future Products and Services:

MusicWest will rotate its stock to ensure new products are always available. We will institute programs such as the “Weekend Warrior” program to raise income opportunities.

Musical Instrument Store Business Plan Example

MusicWest is a leading musical instrument retailer in Albuquerque, catering to novices, hobbyists, and semi-professionals. Our goal is to provide top-notch service and support to our customers, creating an educational and enjoyable shopping experience. We stand out from our competitors by offering a wide selection of instruments, fair pricing, and excellent customer service. With our unique programs like the "100% of purchase price trade-up guarantee" and "You play, we pay" incentives, we aim to exceed our customers’ expectations and build long-term relationships with them. MusicWest is dedicated to bringing back the local market and providing a one-stop shopping experience for all musicians in the area.

For our target clientele, MusicWest will provide a complete one-stop shopping experience that addresses all the needs of aspiring musicians. Offering repairs and unique marketing programs like our "You play, we pay" and our "100% of purchase price trade-up policy," we aim to exceed the expectations of the local client base. Unlike our competitors, MusicWest will selectively stock products with value in mind, not just the lowest price, and we will strive to provide the highest level of attention to customers to gain their trust and purchasing power.

MusicWest operates under the assumption that any customer entering our store is a potential customer of our competitors. We give each client our utmost attention and try to accommodate their needs in a low-pressure relaxed atmosphere. Through modern eye-catching displays designed to maximize impulse buying, we stimulate their senses. MusicWest caters to professionals, novices, parents, and children alike. Our goal is to obtain the largest market share and we will do anything in our power to achieve it.

In short, nobody walks out unless we are satisfied we did everything possible to gain their business today or in the future!

Our sales projections are mainly based on Dave Moore’s experiences as manager of King Music and Marc’s Guitar Center. We believe we can easily meet the projected sales figures for the first year and may be conservative in our projections for the following two years. With only two weak band instrument dealers in our targeted territory, we have a great opportunity to establish instant credibility in the market. Mr. Moore has a list of over 4,000 musicians he has helped, allowing us to draw in proven customers for the store’s opening and operate from an established client base during the initial months.

Musical Instrument Store Business Plan Example

Musical Instrument Store Business Plan Example

Sales Forecast
Year 1 Year 2 Year 3
Sales
Guitar Sales $195,000 $263,500 $283,000
Band and Orchestral Instruments $58,144 $79,000 $85,000
Amplifiers, Keyboards etc. $27,600 $26,200 $27,500
Accessories $196,274 $243,000 $259,000
Print & DVD $15,550 $13,500 $14,000
Rentals $4,950 $4,950 $5,900
Repair Labor $17,260 $20,000 $22,500
Total Sales $514,778 $650,150 $696,900
Direct Cost of Sales Year 1 Year 2 Year 3
Guitar Sales $117,000 $158,100 $169,800
Band and Orchestral Instruments $29,072 $39,500 $42,500
Amplifiers, Keyboards etc. $16,560 $15,720 $16,500
Accessories $78,510 $97,200 $103,600
Print & DVD $9,330 $8,100 $8,400
Rentals $4,950 $4,950 $5,900
Repair Labor $2,589 $3,000 $3,375
Subtotal Direct Cost of Sales $258,011 $326,570 $350,075

5.5.2 Sales Programs

MusicWest offers programs to increase sales and reward customer loyalty:

  1. MusicWest’s “100% Of Purchase Price Trade Up Policy” on fretted instruments. Within the first year of purchase, MusicWest will give a consumer 100% of what they paid for a fretted instrument less tax toward a step-up instrument that is currently in stock. The trade can have normal wear and tear. MusicWest will be the sole judge of what qualifies as a step-up instrument.

5.6 Strategic Alliances

MusicWest becomes a member of N.A.M.M. (National Association of Music Merchants). This organization plans events throughout the year, such as “International Guitar Month.” MusicWest will follow this group’s promotion schedule and tie it in to our own advertising campaigns. No local storefront currently takes full advantage of these offerings. By taking advantage of this trade organization’s expertise, we can save time and money on developing an effective advertisement campaign from day one. Some manufacturers also have advertising co-ops that we will use when feasible. Additionally, these manufacturers provide nationally known musicians on a fee basis to their dealers, for informational/instructional clinics and to drive additional sales opportunities.

Web Plan Summary

MusicWest will have an informational website containing hyperlinks to our main manufacturers’ home pages. We will also offer promotional coupons to entice Web surfers to visit our storefront. We have purposely chosen to avoid a sales engine, as we believe our major Web competitors could easily beat our local price. The User Interface we envision will be easy to page through, with exciting graphics, and geared toward steering visitors to our storefront. We will work with an outside website design and hosting service to create and maintain our website.

Management Summary

MusicWest will initially maintain a small staff of experienced employees to take advantage of the higher overhead of our key competitors. We will operate with four full-time employees and one to three part-time employees as needed. Each employee should be empowered to make crucial decisions on the spot for customer satisfaction. This staffing approach allows for only one manager for day-to-day decisions, keeping hierarchy to a minimum. MusicWest will be selective in future hiring and will reward employees as the store prospers in future years. It is crucial to keep employee turnover at a minimum, as consumers in this business like to develop long-term relationships with their sales representative. Our key employees will be experienced musicians known in the community.

7.1 Organizational Structure

MusicWest requires its staff to be multi-skilled. Each employee will likely oversee many aspects of the business on a given day. The main divisions will be Sales, Service, and Administration. Our focus on customer service depends on all employees knowing as much about each area of the business as possible. A complete book of structures and policies, along with successful actions, will be created and maintained from the date of opening to streamline the process of adding new employees as they become necessary. Ongoing training for all employees will be necessary to keep our edge on the competition.

7.2 Management Team

Kayle Moore – Co-Owner
Operations Manager

Kayle is a 16-year veteran of the wholesale jewelry industry. Over her 16-year tenure, Kayle took the company from 60 to over 300 employees and from $1 to over $15 million dollars in sales. Kayle’s strengths are writing and carrying out sales programs, and keeping a company within its financial limitations. Kayle, who plays the clarinet, has had a lifelong interest in music and plans to translate that enthusiasm, along with her management skills, into making MusicWest a successful long-term investment.

Related Management Strengths:

  • CEO/COO level responsibility.
  • Ability to get others to produce to their potential.
  • Writing sales programs to generate and maintain consistent sales goals.
  • Excellent communication skills.
  • Maintains mutually beneficial vendor relations.
  • Ability to anticipate and adapt to changing economic conditions.
  • Experience negotiating complex sales contracts, including financing and shipment options with large corporate clients such as Wal-Mart and Target.
  • Implemented the use of EDT computerized ordering software with clients to streamline the ordering process and allow the manufacturer to stock less raw inventory, simultaneously reducing overhead and increasing profits.
READ MORE  Gift Basket Business Plan Example

David Moore – Co-Owner
Store Manager

Dave is currently the Store Manager of Marc’s Guitar Center in Albuquerque. Dave was previously Store Manager for King Music’s Westside location, where he was able to turn around a declining location and outsell the company’s flagship store for two years straight, despite fewer customers and staff. Dave has been a musician for over 23 years and toured professionally in the 80’s. Dave has been involved in sales and sales management since the age of eight. Dave has taken many sales/management courses and has had full profit and loss experience. Dave was the co-owner of a 7,500 sq.ft. retail furniture store in the early 1980’s.

Related, industry-specific strengths:

  • Music Store Management. (7 years +)
  • Direct purchasing of up to $400,000 in inventory annually.
  • Top sales producer in the musical instrument combo department, in addition to his full-time management responsibilities at both music stores where he has worked.
  • Outstanding employee relations, with lower-than-industry-average turnover.
  • Excellent relations with vendors.
  • Vast knowledge of Musical Instruments and the Musical Instrument Industry locally and nationally.
  • Superior customer interaction/retention skills.
  • Sales, Sales Manager, and Finance Manager in the automotive industry.
  • Trade show management and Sales in the Wholesale Jewelry Trade.
  • Certified computer skills.

C. Ray Himes
Service Department – Manager

  • Graduate of the prestigious Roberto Venn School of Luthiery in Phoenix, Arizona.
  • Trained in all aspects of fretted instrument repair, including re-frets, neck resets, crack repair, wiring, and modification work.
  • Completely versed in the new construction of electric and acoustic guitars.
  • Instructed in all phases of managing a full-service repair shop.
  • Trained personally by Dave Moore in guitar sales and accessory sales.
  • Good at improvising and solving difficult problems.
  • Good woodworking skills essential to this position.
  • Ongoing commitment to furthering his skills and knowledge of fretted instruments.
  • Plays in a local band: “Tanuki.”

7.3 Management Team Gaps

We believe we have assembled an excellent team of employees that will complement each other’s knowledge and skill levels. We feel weakest in the band instrument repair department. As soon as finances permit, a knowledgeable repairman with this background would be highly desirable. We already know of one excellent candidate, currently working for Albuquerque public schools. The addition of this person will be a huge benefit for our store.

7.4 Personnel Plan

The personnel plan highlights our intent to hire as few employees as possible to keep control over how our customers are treated during the crucial first stages of our business. We will have two full-time salespeople and two to three part-time employees to call upon as traffic demands. In addition, all key employees have agreed to work at lower pay structures to keep personnel costs at a minimum during the critical first two years.

Personnel Plan
Year 1 Year 2 Year 3
Dave Moore $31,000 $31,000 $35,000
Kayle Moore $31,000 $31,000 $35,000
C. Ray Himes $26,400 $27,000 $32,000
Full-time Employee #1 $20,400 $22,000 $25,000
Full-time Employee #2 $20,400 $22,000 $25,000
Part-time Employee #1 $6,600 $6,800 $7,200
Part-time Employee #2 $6,600 $6,800 $7,200
Seasonal Employee #1 $1,750 $2,350 $2,450
Total People 7 8 8
Total Payroll $144,150 $148,950 $168,850

Financial Plan

We expect revenues and sales to increase dramatically between the second and fourth years of operation. After that high-growth period, we expect growth to be steady and stable for the foreseeable future. This industry is very susceptible to consumers’ judgments about the store based on inventory, brands offered, pricing, and staffing. It is crucial that we generate sufficient cash reserves during the growth years to be able to jump on future opportunities, allowing us to increase our market share.

8.1 Important Assumptions

The financial plan depends on certain assumptions, most of which are shown in the following table. The key assumptions are:

  • Economy proceeding, as in recent trends, of 2 to 4% annual growth.
  • No new major band and orchestral competitors on a large scale within the next two years in our direct vicinity.
  • No unforeseen changes with our major vendors in regards to lines carried.
  • No major change in our relationship with China or other foreign governments that would hinder product supply.
General Assumptions
Year 1 Year 2 Year 3
Plan Month 1 2 3
Current Interest

Musical Instrument Store Business Plan Example

Musical Instrument Store Business Plan Example

Musical Instrument Store Business Plan Example

Musical Instrument Store Business Plan Example

Pro Forma Profit and Loss:

Pro Forma Profit and Loss
Year 1 Year 2 Year 3
Sales $514,778 $650,150 $696,900
Direct Cost of Sales $258,011 $326,570 $350,075
Other Production Expenses $0 $0 $0
Total Cost of Sales $258,011 $326,570 $350,075
Gross Margin $256,767 $323,580 $346,825
Gross Margin % 49.88% 49.77% 49.77%
Expenses
Payroll $144,150 $148,950 $168,850
Sales and Marketing and Other Expenses $51,200 $55,400 $58,900
Depreciation $0 $0 $0
Accountant Expense $5,200 $5,500 $6,000
Utilities $17,120 $18,000 $19,000
Insurance $4,800 $5,200 $5,700
Rent $30,000 $30,000 $30,000
Payroll Taxes $0 $0 $0
Website Maintenance $300 $325 $350
Total Operating Expenses $252,770 $263,375 $288,800
Profit Before Interest and Taxes $3,997 $60,205 $58,025
EBITDA $3,997 $60,205 $58,025
Interest Expense $11,746 $9,526 $7,210
Taxes Incurred $0 $15,204 $15,244
Net Profit ($7,748) $35,475 $35,570
Net Profit/Sales -1.51% 5.46% 5.10%

8.3 Break-even Analysis:

For break-even analysis purposes, the assumed monthly running costs are shown below. Payroll alone constitutes a significant portion of these costs. The break-even assumptions rely on the personal experience of co-owner David Moore, gleaned from his time as manager of King Music Centers, Inc., and Marc’s Guitar Center. We expect to achieve above-average margins by selectively choosing products that enable these margins and by employing value-added marketing strategies for these products and related services.

Musical Instrument Store Business Plan Example

Break-even Analysis:

Monthly Revenue Break-even: $42,230.

Assumptions:

– Average Percent Variable Cost: 50%

– Estimated Monthly Fixed Cost: $21,064.

8.4 Projected Cash Flow:

Our cash flow projections indicate a slight negative cash flow. However, our existing funds are sufficient to cover this without relying on additional credit financing. We expect to maintain a positive cash balance going forward.

Musical Instrument Store Business Plan Example

Pro Forma Cash Flow

Pro Forma Cash Flow
Year 1 Year 2 Year 3
Cash Received
Cash from Operations
Cash Sales $514,778 $650,150 $696,900
Subtotal Cash from Operations $514,778 $650,150 $696,900
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 $514,778 $650,150 $696,900
Expenditures Year 1 Year 2 Year 3
Expenditures from Operations
Cash Spending $144,150 $148,950 $168,850
Bill Payments $229,463 $454,298 $492,649
Subtotal Spent on Operations $373,613 $603,248 $661,499
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 $35,628 $35,628 $35,628
Purchase Other Current Assets $0 $0 $0
Purchase Long-term Assets $0 $0 $0
Dividends $0 $0 $0
Subtotal Cash Spent $409,241 $638,876 $697,127
Net Cash Flow $105,537 $11,274 ($227)
Cash Balance $174,037 $185,311 $185,084

8.5 Projected Balance Sheet

The projections in the balance sheet are solid. We anticipate no trouble meeting our debt obligations if we follow through with the plans and strategies outlined in this business plan.

Pro Forma Balance Sheet
Year 1 Year 2 Year 3
Assets
Current Assets
Cash $174,037 $185,311 $185,084
Inventory $22,460 $28,429 $30,475
Other Current Assets $0 $0 $0
Total Current Assets $196,498 $213,740 $215,559
Long-term Assets
Long-term Assets $7,500 $7,500 $7,500
Accumulated Depreciation $0 $0 $0
Total Long-term Assets $7,500 $7,500 $7,500
Total Assets $203,998 $221,240 $223,059
Liabilities and Capital Year 1 Year 2 Year 3
Current Liabilities
Accounts Payable $21,374 $38,769 $40,646
Current Borrowing $0 $0 $0
Other Current Liabilities $0 $0 $0
Subtotal Current Liabilities $21,374 $38,769 $40,646
Long-term Liabilities $164,372 $128,744 $93,116
Total Liabilities $185,746 $167,513 $133,762
Paid-in Capital $60,000 $60,000 $60,000
Retained Earnings ($34,000) ($41,748) ($6,273)
Earnings ($7,748) $35,475 $35,570
Total Capital $18,252 $53,727 $89,297
Total Liabilities and Capital $203,998 $221,240 $223,059
Net Worth $18,252 $53,727 $89,297
READ MORE  Carpet and Upholstery Cleaning Services Financial Plan

8.6 Business Ratios

The following table shows industry relevant ratios for Musical Instrument Stores (SIC code 5736).

Ratio Analysis
Year 1 Year 2 Year 3 Industry Profile
Sales Growth 0.00% 26.30% 7.19% 4.64%
Percent of Total Assets
Inventory 11.01% 12.85% 13.66% 37.97%
Other Current Assets 0.00% 0.00% 0.00% 27.27%
Total Current Assets 96.32% 96.61% 96.64% 79.90%
Long-term Assets 3.68% 3.39% 3.36%

Dave Moore: 0%, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $3,500, $2,500, $2,500

Kayle Moore: 0%, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $3,500, $2,500, $2,500

C. Ray Himes: 0%, $2,200, $2,200, $2,200, $2,200, $2,200, $2,200, $2,200, $2,200, $2,200, $2,200, $2,200, $2,200, $2,200

Full-time Employee #1: 0%, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700

Full-time Employee #2: 0%, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700, $1,700

Part-time Employee #1: 0%, $450, $450, $450, $450, $450, $450, $450, $550, $750, $950, $750, $450

Part-time Employee #2: 0%, $450, $450, $450, $450, $450, $450, $450, $550, $750, $950, $750, $450

Seasonal Employee #1: 0%, $0, $0, $0, $0, $0, $0, $0, $0, $0, $700, $700, $350, $0

Total People: 7, 7, 7, 7, 7, 7, 7, 7, 7, 8, 8, 8, 7

Total Payroll: $11,500, $11,500, $11,500, $11,500, $11,500, $11,500, $11,500, $11,700, $12,800, $15,200, $12,450, $11,500

General Assumptions

Plan Month: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12

Current Interest Rate: 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%

Long-term Interest Rate: 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%, 6.50%

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%, 30.00%

Other: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0

Pro Forma Profit and Loss

Sales: $21,050, $25,854, $28,676, $31,496, $34,105, $39,676, $47,547, $46,490, $56,600, $88,500, $54,100, $40,684

Direct Cost of Sales: $10,353, $12,777, $14,404, $15,647, $17,111, $20,018, $23,578, $23,351, $28,645, $44,925, $26,785, $20,419

Other Production Expenses: $0, $0, $0, $0, $0, $0, $0, $0, $0, $0, $0, $0, $0

Total Cost of Sales: $10,353, $12,777, $14,404, $15,647, $17,111, $20,018, $23,578, $23,351, $28,645, $44,925, $26,785, $20,419

Gross Margin: $10,698, $13,077, $14,272, $15,849, $16,994, $19,658, $23,969, $23,139, $27,955, $43,575, $27,315, $20,265

Gross Margin %: 50.82%, 50.58%, 49.77%, 50.32%, 49.83%, 49.55%, 50.41%, 49.77%, 49.39%, 49.24%, 50.49%, 49.81%

Expenses

Payroll: $11,500, $11,500, $11,500, $11,500, $11,500, $11,500, $11,500, $11,700, $12,800, $15,200, $12,450, $11,500

Sales and Marketing and Other Expenses: $6,400, $3,400, $3,400, $3,400, $5,900, $3,400, $3,400, $2,400, $4,500, $5,700, $5,900, $3,400

Depreciation: $0, $0, $0, $0, $0, $0, $0, $0, $0, $0, $0, $0

Accountant Expense: $800, $400, $400, $400, $400, $400, $400, $400, $400, $400, $400, $400, $400

Utilities: $1,040, $1,040, $1,130, $1,380, $1,790, $1,460, $1,370, $1,460, $1,760, $2,210, $1,400, $1,080

Insurance: $400, $400, $400, $400, $400, $400, $400, $400, $400, $400, $400, $400, $400

Rent: $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500, $2,500

Payroll Taxes: 15%, $0, $0, $0, $0, $0, $0, $0, $0, $0, $0, $0, $0

Website Maintenance: $25, $25, $25, $25, $25, $

Pro Forma Cash Flow:

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 $21,050 $25,854 $28,676 $31,496 $34,105 $39,676 $47,547 $46,490 $56,600 $88,500 $54,100 $40,684
Subtotal Cash from Operations $21,050 $25,854 $28,676 $31,496 $34,105 $39,676 $47,547 $46,490 $56,600 $88,500 $54,100 $40,684
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $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 $21,050 $25,854 $28,676 $31,496 $34,105 $39,676 $47,547 $46,490 $56,600 $88,500 $54,100 $40,684
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 $11,500 $11,500 $11,500 $11,500 $11,500 $11,500 $11,500 $11,700 $12,800 $15,200 $12,450 $11,500
Bill Payments $408 $12,118 $8,819 $8,898 $9,220 $11,923 $9,168 $9,466 $21,860 $45,992 $73,103 $18,487
Subtotal Spent on Operations $11,908 $23,618 $20,319 $20,398 $20,720 $23,423 $20,668 $21,166 $34,660 $61,192 $85,553 $29,987
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $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 $2,969 $2,969 $2,969 $2,969 $2,969 $2,969 $2,969 $2,969 $2,969 $2,969 $2,969 $2,969
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 $14,877 $26,587 $23,288 $23,367 $23,689 $26,392 $23,637 $24,135 $37,629 $64,161 $88,522 $32,956
Net Cash Flow $6,173 ($733) $5,388 $8,129 $10,416 $13,284 $23,910 $22,355 $18,971 $24,339 ($34,422) $7,728
Cash Balance $74,673 $73,940 $79,328 $87,457 $97,873 $111,157 $135,067 $157,422 $176,392 $200,732 $166,310 $174,037

Pro Forma Balance Sheet:

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 $68,500 $74,673 $73,940 $79,328 $87,457 $97,873 $111,157 $135,067 $157,422 $176,392 $200,732 $166,310 $174,037
Inventory $150,000 $139,648 $126,871 $112,467 $96,820 $79,710 $59,692 $36,114 $25,686 $31,510 $49,418 $29,464 $22,460

Leave a Reply

Your email address will not be published. Required fields are marked *