Our biggest savings of the year
Tucson Electronics
Executive Summary
Tucson is a start-up business located in the West end of Tucson Arizona. The company specializes in the repair and sales of home electronics, specifically home entertainment electronics, including TV, DVDs VCRs and CD players.
We will target people who place great importance in their entertainment equipment and own higher-end electronics, where repairing them would be more cost effective than replacing them. Many low end VCRs for example, are priced so low, people find it more cost effective and convenient to purchase a new product than to get the existing one repaired.
The company is owned and managed by James Munroe, a retired Navy Commander with a degree in electrical engineering from the University of Texas-Austin. He is a certified electronics technician with various brand companies. He will also employ his son to help with running and growing the business.
1.1 Objectives
Tucson Electronics (TE) is a growth-oriented business. Its ten year goal is to become a regional leader in TV/VCR/home stereo repair, with shops in the Tucson and Phoenix area. With this in mind, the objectives over the next three years for Tucson Electronics are the following:
- Achieve steady growth in sales revenues by year three.
- Achieve local market share (in the Tucson area) of approximately 20% by year five.
- Expand product line to include authorized satellite service installation and new home entertainment electronics sales.
1.2 Mission
The mission of Tucson Electronics is to provide high quality, convenient and comprehensive TV/DVD/VCR and home electronics repair at a low cost. The most important aspect of our business is trust. It is the goal of our firm to have 100% customer satisfaction in regards to quality, friendliness and time to completion, and discover new ways to exceed the expectations of our customers while doing so at the lowest possible cost.
1.3 Keys to Success
In the TV/VCR repair industry a company builds its client base one customer at a time and mostly through established marketing practices (ads, billboards, etc.). With this in mind, the keys to success for Tucson Electronics are:
- High-quality work.
- Attention to professional appearances at all times.
- Knowledgeable technicians that are friendly, customer oriented, and will take the time to explain to customers the intricate nature of our business and our work.
- Maintaining a highly aggressive managerial oversight on costs to provide our services at the lowest price.
Company Summary
Tucson Electronics is envisioned to be the low cost leader in TV/DVD/VCR and home stereo repair for the Tucson area that will also be able to eventually provide satellite TV installation/servicing and new electronics sales, making it the local leader in comprehensive electronic sales/services.
The company will be a sole proprietorship registered in the state of Arizona and owned by Mr. James Munroe. The firm will have facilities on 530 W. Prince Ave. The initial facilities will contain a sales area, repair room in the back of the shop, office space and storage for parts and equipment.
The company is seeking a loan in order to finance the start of operations for the company. The owners will be putting up additional capital of their own as equity.
2.1 Start-up Summary
The data obtained for the start-up table comes from research done in the Tucson area with other small electronics shops who have started their own business, in addition to Mr. Munroe’s previous experience within the industry. Inflation has been taken into account between the estimates of these fellow business owners (and when they started) and the current prices for expensed items. Much of the equipment to go into the facilities such as tools, are currently owned by Mr. Munroe.
Start-up Funding | |
Start-up Expenses to Fund | $26,300 |
Start-up Assets to Fund | $51,200 |
Total Funding Required | $77,500 |
Assets | |
Non-cash Assets from Start-up | $15,000 |
Cash Requirements from Start-up | $36,200 |
Additional Cash Raised | $0 |
Cash Balance on Starting Date | $36,200 |
Total Assets | $51,200 |
Liabilities and Capital | |
Liabilities | |
Current Borrowing | $0 |
Long-term Liabilities | $15,400 |
Accounts Payable (Outstanding Bills) | $0 |
Other Current Liabilities (interest-free) | $13,600 |
Total Liabilities | $29,000 |
Capital | |
Planned Investment | |
James Munroe | $26,500 |
Janet Munroe | $22,000 |
Additional Investment Requirement | $0 |
Total Planned Investment | $48,500 |
Loss at Start-up (Start-up Expenses) | ($26,300) |
Total Capital | $22,200 |
Total Capital and Liabilities | $51,200 |
Total Funding | $77,500 |
Start-up | |
Requirements | |
Start-up Expenses | |
Legal | $500 |
Stationery etc. | $200 |
Advertising | $10,000 |
Phone | $200 |
Insurance | $400 |
Rent | $4,000 |
Utilities | $400 |
Facilities refurbishment | $8,000 |
Computer | $2,000 |
Other | $600 |
Total Start-up Expenses | $26,300 |
Start-up Assets | |
Cash Required | $36,200 |
Start-up Inventory | $3,000 |
Other Current Assets | $8,000 |
Long-term Assets | $4,000 |
Total Assets | $51,200 |
Total Requirements | $77,500 |
Products and Services
Tucson Electronics offers a wide range of services as outlined in the detailed sections below. It is ultimately the goal of the company to offer a one-stop facility for all home entertainment needs, including both sales and servicing. In this way the company can offer greater perceived value for the customer than many other shops which only offer sales or services.
The industry is highly competitive with suppliers having a great deal of power in setting and negotiating the prices of their products and services to repair shops. In addition, because the customers see the service as undifferentiated and a “commodity” with little value separation between competitors, buyer power is also very high. Finally, the barriers to entry are moderately low, and the large number of competitors in this field, including substitutes (such as do-it-yourself work) mean that the pricing for such services is very competitive. The only way to have an advantage in this industry is a low cost leadership principal applied aggressively or to create higher switching costs through the building of strong business-to-customer ties. It is the aim of Tucson Electronics to create a competitive advantage through both the low cost strategy and by offering greater value through its broader product and service line.
Tucson Electronics will initially have only one factory trained and certified technician in the person of Mr. Munroe. As the company grows and expands, Mr. Munroe will hire trained and certified technicians who are able to prove they have superior customer awareness and interaction. It is the company’s professional people who will fulfill the firm’s contracts and goals. The largest part of the company’s expenses will be in labor costs.
3.1 Product and Service Description
Tucson Electronics provides a wide range of home entertainment repair services. These include:
- Repair and cleaning of home and car stereos and CB radios.
- Repair and cleaning of TVs.
- Repair and cleaning of VCRs and DVDs.
- Sale of used TVs, stereos, VCRs and DVDs.
- Free estimates on repair jobs.
- Authorized warranty servicing on all major brands of home entertainment systems.
- House calls and free pickup and delivery.
Future products and services that Tucson Electronics will prepare to institute include TV/VCR/DVD rental, satellite TV installation and servicing, sales of new TVs, DVDs, VCRs and stereos, and repair/sale of microwave ovens. Mr. Munroe is also investigating the possibility of offering a new product line of home entertainment cabinets at some future date.
3.2 Sourcing
Tucson Electronics will be obtaining most of its parts through established dealers and directly through the manufacturers of the relevant electronics. As part of the company’s low cost strategy, the company will seek to purchase parts in large quantities whenever possible to take advantage of volume discounts. In addition, the company will aggressively seek to procure its parts from local suppliers in order to start forming close relations with such companies. It is the ultimate aim of Tucson Electronics to form strategic partnerships with such companies in order to lower overall costs of parts.
A large part of Tucson Electronics enhanced services will be free pickup and delivery of electronics to a person’s home. Mr. Munroe’s cousin, Mr. Thomas Porter, owns Caesar Courier Services, a local company providing pickup and delivery services. Mr. Porter has agreed to provide these services to Tucson Electronics’ clients at discounted prices to Mr. Munroe.
3.3 Technology
The technological revolution in computers has enhanced our abilities to diagnose and repair our clients home electronics. Tucson Electronics will remain on the cutting edge by instituting the use of computer diagnostic equipment in its shop. The company will continue to seek new ways to provide a better service through technology.
3.4 Competitive Comparison
The electronics repair industry is highly competitive. Each company within this field has high labor costs, low margins, and a high intensity of competition.
Suppliers have a great deal of power in setting and negotiating the prices of their products and services to repair shops. This is due to the fact that the suppliers who absorb the greatest amounts of cash from repair shops are large electronic manufacturing companies such as Panasonic, Emerson, Toshiba, etc. These companies are more consolidated than the repair industry, have deeper pockets, an almost limitless number of substitute customers, and finally they are the single most important supplier to the electronic repair industry. Therefore, these companies can set whatever price they wish to. Furthermore, labor is the single most important expense in this industry, and salaries for such individuals are well known and not very flexible.
In addition, because the customers see the service as undifferentiated and a “commodity” with little value separation between competitors (if they offer a suitable level of quality) buyer power is also very high. Additionally, the costs of our services are not cheap, and buyers are willing to search for the most favorable combination of price and acceptable service.
The barriers to entry and exit are moderately low in this industry. Switching costs are virtually non-existent and the costs to entry and exist the market are low. The large number of competitors in this field including substitutes mean that pricing for such services are very competitive. The only way to have an advantage in this industry is a low cost leadership principal applied aggressively to all aspects of the business or to build up customer relations to a point where the switching costs are raised.
Based on this analysis, Tucson Electronics will pursue a low cost leadership strategy as its primary competitive advantage. Furthermore, the company will simultaneously build up its product and service line to take advantage of the limited opportunity to create higher switching costs through enhanced value creation and to spread out costs.
3.5 Future Products and Services
Future products and services that Tucson Electronics will prepare to institute include TV/VCR/DVD rental, satellite TV installation and servicing, sales of new TVs, DVDs VCRs and stereos, and repair/sale of microwave ovens. Mr. Munroe is also investigating the possibility of offering a new product line of home entertainment cabinets at some future date.
Tucson Electronics will start implementing these new products or services in the following time periods:
- Repair/sale of microwave ovens (3rd Qtr 2004).
- Satellite TV installation and servicing (3rd Qtr 2005).
- TV/VCR/DVD rental (2nd Qtr 2006).
- Sales of new TVs/DVDs/VCRs (4th Qtr 2006).
The capital investment needed for such expansion will primarily come from the company’s accumulated operating cash account. It is anticipated that some of these product/service expansions that require significant inventory, such as new sales, may require additional cash inflow such as loans. The company will be preparing proposals for various lending institutions in anticipation of this need.
Presently the product that is really driving the electronics repair market is computers. While Tucson Electronics is not currently positioned to take advantage of this situation, it is the long-term goal of Tucson electronics to incorporate computer repair services within the company. Once the firm is able to generate enough cash to retain the services of a computer repair technician, the company will evaluate the viability of such a move. It is anticipated that this service will be offered sometime after 1st Qtr 2007.
Market Analysis Summary
There are approximately 332,500 households in the greater Tucson area, which includes suburbs such as Green Valley, Ina, and South Tucson. Virtually all of these households have TVs, VCRs, etc. Tucson Electronics segments its market into product categories that reflect the estimated number of each electronic device currently being used in the greater Tucson area, since each of these devices may fail at any time and require our services. In addition the growth rate of each product emplaced in the home is based on the current sales growth of each product. Presently, the fastest growing product, in terms of sales, is the DVD player. It is anticipated that the DVD will replace the VCR within the next three to five years as movie rental stores replace their existing VHS movies with DVD. The largest segment is the home and car stereo segment, since usually a household has more than one of these systems. The company will be focusing on servicing all of these systems, and not focusing on one over the other.
4.1 Market Segmentation
Tucson Electronics has segmented the households in the Tucson area as follows:
- Couples with children.
- Couples without children (including Baby Boomers).
- Retired people.
- Students living in multi-unit housing.
- Single people living alone.
- Single people living with roommates.
Tucson will target the following segments.
Middle class couples without children. This group will tend to have a higher disposable income since they have two incomes but do not have the expense of children. They prioritize socializing and spend a fair amount of time entertaining in their home and in the homes of their friends. For this reason they will spend more on their electronic equipment.
Single men living alone or with roommates. This group is not the largest segment for us, but potentially one of the most profitable, since single men tend to prioritize their home entertainment equipment. They will spend a greater percentage of their income on high-quality TV and stereo equipment.
Baby boomers. Baby boomers are reaching the age where their children have left home and they have more disposable income than when their children were young and living at home. They are more tech savvy than the generation before them and appreciate the good things in life. They like to spend time in their homes, now that the children are out of the house.
Market Analysis | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
Potential Customers | Growth | CAGR | |||||
TVs | 3% | 415,875 | 428,351 | 441,202 | 454,438 | 468,071 | 3.00% |
VCRs | -2% | 310,645 | 304,432 | 298,343 | 292,376 | 286,528 | -2.00% |
DVDs | 25% | 106,400 | 133,000 | 166,250 | 207,813 | 259,766 | 25.00% |
Stereo Systems | 12% | 875,500 | 980,560 | 1,098,227 | 1,230,014 | 1,377,616 | 12.00% |
Microwave Ovens | 8% | 282,625 | 305,235 | 329,654 | 356,026 | 384,508 | 8.00% |
Total | 8.67% | 1,991,045 | 2,151,578 | 2,333,676 | 2,540,667 | 2,776,489 | 8.67% |
4.1.1 Market Trends
The market demand for electronics repair has been relatively stable over the past decade. With the advent of DVD players, the market is seeing more highly trained technicians needed. As technology progresses, long-term planners within this market expect to see new opportunities for electronics repair quickly arise. Such devices as cellular telephones, PDAs and other new electronics may have a role to play in the people who have a broad vision in this field.
4.2 Service Business Analysis
Much of the electronics repair industry analysis is contained in the competitive comparison section. However, the key points are that the industry is highly competitive and that most firms have little power to affect the forces that influence them or to affect the price levels that the market determines. In essence, Tucson Electronics operates in a purely competitive environment where the demand curve is horizontal. In other words the company is free to service electronics at maximum capacity without effecting the price or demand for its services. With this type of environment, and with customers seeing such services as a “commodity” the only strategy open to companies in this field is the low cost leadership approach.
Tucson Electronics is fortunate in that Janet Munroe, Mr. Munroe’s wife works in cost analysis for Wal-Mart, one of the country’s best low cost companies. Mrs. Munroe has agreed to furnish cost analysis services to Tucson Electronics for free.
The low cost leadership strategy will not be simple to achieve. Realistically speaking, because of the fragmented nature of the industry, Tucson Electronics will only seek a low cost leadership in the Tucson region for the first seven to ten years of operations. In order to capture this position and achieve its benefits of high market share and profitability, the company is expected to have higher start-up costs and lower profits within the first few years as the company invests in better and more efficient facilities and equipment than most competitors and engages in aggressive pricing to capture market share. The company will rigorously evaluate every aspect of the company to improve efficiency and lower costs. Mrs. Munroe is preparing an analysis of the company’s value chain and cost drivers to identify where costs can be lowered and which aspects of the business Mr. Munroe must focus on. It is expected that management will expend a great deal of energy in cost management and the reduction of things such as marginal customer accounts and marketing expenses. Once in operation, management will concentrate on developing established procedures that will create the most effective service experience. Finally, as part of this low cost leadership strategy, the company plans to vertically integrate to include original sales and broad services that will spread costs and serve all major customer types so as to build volume.
4.2.1 Competition and Buying Patterns
Customers traditionally purchase services in this industry because of effective advertising and reputation. The customers wish to be reassured that they will receive prompt and reliable service and have an understanding service representative will listen to their problems and seek to solve them in a fast and professional manner. Therefore image during the entire service experience is crucial to maintain word-of-mouth marketing and keep a low curn rate. Currently the largest problem that faces small firms is product/service awareness. By the use of effective and widespread advertising, Tucson Electronics expects to be able to capitalize on the weakness of the the “mom and pop” outfits style of passive promotion (such as Yellow Page ads) and to leverage greater product awareness into higher market share. There is no seasonality to this industry although there is some slight increase in servicing sales during the Christmas season.
4.2.2 Business Participants
As stated before, the electronic repair industry is highly fragmented. In fact, there are so many small providers that any company in this industry is facing a purely competitive environment. Approximately 23,700 electronic repair firms exist in the country today. Firms within this field range in sizes from the “mom and pop” outfits such as Dave’s Electronics and Kachina Repair in downtown Tucson to regional companies like Magnolia Hi-Fi and the national chains such as Circuit City. Not all of these firms are purely repair outfits. In fact all of the larger firms make the majority of their revenue in original sales. It is these companies that have the largest market share and have the opportunity to compete by differentiating on customer service or product/service range.
As stated before, Tucson Electronics will seek a low cost leadership approach in the local Tucson region first. Its goals are not to directly compete with the larger companies who could effectively out compete Tucson Electronics. Instead, the company will seek to outprice the local “mom and pop” outfits and acquire their market share in order to then compete with the regional firms. There are eight such “mom & pop” firms that will be Tucson Electronics’ main competitors in its first few years of operation. They are:
- Dave’s Electronics.
- Kachina Repair.
- Cactus Repair and Appliance.
- Miller TV.
- Robb’s Repair.
- Sam the TV Man.
- Teletron Service Co.
- Ferndale TV Shoppe.
Strategy and Implementation Summary
The following sections outline Tucson Electronic’s strategy and implementation summary.
5.1 Marketing Strategy
The company has a strong program of marketing its services that include the following:
- Flyers.
- Direct mailers.
- Discounts.
- Newspaper ads.
- Yellow Pages.
- Referrals through other local businesses.
- Radio ads.
- Billboards.
- Web banners on local information sites.
The company’s aim is to overcome the traditional small firm’s passive form of advertising and promotion by sending our message to the customer, instead of having the customer look for a firm when they need our services. The share development graph below shows how the company plans to build market share through service awareness, value creation, competitive price, availability, and attractive service experience, all leading to the purchasing of our services. The numbers given in the graph give the estimated percentages of those customers who respond favorably to each marketing step. These numbers multiplied together give us an estimated aggregate market share of approximately 16%. The company expects to achieve this by year four.
5.1.1 Pricing Strategy
Tucson Electronics exists in a purely competitive environment where each firm must be a price taker. In other words, the firm has no ability to affect the market price of its services, regardless of how many TVs/DVDs or VCRs it repairs. In this case, therefore, marginal revenue (the revenue incurred by producing or servicing one more unit) is equal to the price charged. Furthermore, because the demand curve is essentially horizontal, Tucson Electronics can service electronics at total capacity without effecting the price.
What all of this means for the company is that the we must seek to charge our clients at the market price (or lower). Research has shown that the average price is approximately $75 per electronic device. As long as marginal costs do not exceed revenues, the company’s method to maximize short-run profits is to service the various electronic devices at maximum capacity. This means that Tucson Electronics can expect an long-term ROA of approximately 14%.
5.1.2 Promotion Strategy
The company’s promotion strategy will take the form of flyers, direct mailers, price discounts, billboards, radio ads and advertisements in newspapers and yellow pages. TE expects to spend a large amount on marketing in the first two years in order to build up product awareness and service value in the minds of our customers.
5.2 Competitive Edge
Tucson Electronics’ competitive edge lies in its ability to provide quality and fast electronic repair at lower cost than any local small competitor. This positioning of the company provides protection against the power of suppliers by creating more flexibility to cope with increasing costs. In addition, this approach will provide returns even during economic downturns and when other unforeseen problems arise.
Sales Forecast
Since the electronic repair industry is, operationally, a job-shop environment, it is somewhat difficult to estimate sales. For job-shops, each individual product or service is tailored or unique to that job, and is only initiated once an order is made. However, the sales forecast reflect the professional opinion of Mr. Munroe in how many sales he will make.
The sales forecast is based on the estimated number of electronics the company could service that are currently emplaced in the homes in Tucson. This is conservatively estimated at about two million units. From that number it is assumed that approximately 3% of all those will fail in any year. These two numbers multiplied together give us yearly market demand for our services. With an aggressive promotional strategy, a 10% market share is assumed by year three and multiplied by the estimated market demand. This is then multiplied by the estimated price per unit to arrive at the yearly sales figure assumed for year three (once the company’s marketing efforts have paid off). This number is then decreased by a logical amount to estimate the first two years of revenue.
Sales Forecast | |||
Year 1 | Year 2 | Year 3 | |
Sales | |||
TVs | $46,250 | $49,025 | $52,604 |
VCRs | $51,600 | $54,696 | $58,689 |
DVDs | $36,500 | $38,690 | $41,514 |
Stereo Systems | $57,700 | $61,162 | $65,627 |
Microwave Ovens | $5,900 | $84,000 | $90,132 |
Total Sales | $197,950 | $287,573 | $308,566 |
Direct Cost of Sales | Year 1 | Year 2 | Year 3 |
TVs | $4,625 | $6,000 | $6,000 |
VCRs | $5,160 | $7,200 | $7,200 |
DVDs | $3,650 | $8,400 | $8,400 |
Stereo Systems | $5,770 | $7,200 | $7,200 |
Microwave Ovens | $590 | $7,200 | $7,200 |
Subtotal Direct Cost of Sales | $19,795 | $36,000 | $36,000 |
Management Summary
Mr. James Munroe is a retired Navy Commander with a degree in electrical engineering from the University of Texas-Austin. During his naval career, Mr. Munroe gained extensive experience in project management, engineering, and electronics systems. During his leisure time, Mr. Munroe sought to expand his experiences in electronics by becoming a certified electronics technician with various brand companies. Mr. Munroe is now seeking to leverage this experience into a growth-oriented business that will be able to eventually compete with the largest firms in the industry.
Mr. Munroe will also be employing the services of his son Samuel, who desires to eventually take over the business. Samuel Munroe has been attending a local trade school and is expected to graduate with a degree in electronics in the summer of 2002.
7.1 Personnel Plan
Tucson Electronics’ initial staffing will consist of Mr. Munroe, his son, and two part-time technician trainees. Accounting, bookkeeping, and marketing consulting services will be outsourced. The company’s intermediate goal is to have four full-time, fully trained technicians at the original facility, plus a full-time office manager. However, management has decided to await future developments before determining the best time to bring on such personnel.
Personnel Plan | |||
Year 1 | Year 2 | Year 3 | |
Mr. James Munroe | $36,000 | $36,000 | $36,000 |
Mr. Samuel Munroe | $24,000 | $28,000 | $32,000 |
Part-time technician | $14,400 | $28,000 | $28,000 |
Part-time technician | $14,400 | $28,000 | $28,000 |
Part-time technician | $0 | $15,000 | $15,000 |
Total People | 4 | 5 | 5 |
Total Payroll | $88,800 | $135,000 | $139,000 |
Financial Plan
The following sections outline the financial plan for Tucson Electronics.
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 |
8.1 Break-even Analysis
The company’s break-even analysis is based on an average company’s running costs within this industry, including payroll, and its fixed costs for such things as rent, utilities, etc. As Tucson Electronics operates as a job-shop, with each task a unique, customized service, it is difficult to estimate revenue per unit and variable costs. The reader must understand that there is a high degree of variance within these estimates.
The reader will also note that the company is not expected to reach its break-even point until the last three months of sales of the first year.
Break-even Analysis | |
Monthly Revenue Break-even | $17,844 |
Assumptions: | |
Average Percent Variable Cost | 10% |
Estimated Monthly Fixed Cost | $16,059 |
8.2 Projected Profit and Loss
The following table and charts are the projected profit and loss for Tucson Electronics.
Pro Forma Profit and Loss | |||
Year 1 | Year 2 | Year 3 | |
Sales | $197,950 | $287,573 | $308,566 |
Direct Cost of Sales | $19,795 | $36,000 | $36,000 |
Other Production Expenses | $0 | $0 | $0 |
Total Cost of Sales | $19,795 | $36,000 | $36,000 |
Gross Margin | $178,155 | $251,573 | $272,566 |
Gross Margin % | 90.00% | 87.48% | 88.33% |
Expenses | |||
Payroll | $88,800 | $135,000 | $139,000 |
Sales and Marketing and Other Expenses | $28,600 | $36,000 | $26,000 |
Depreciation | $1,992 | $2,000 | $2,000 |
Leased Equipment | $6,000 | $2,000 | $2,000 |
Utilities | $4,800 | $5,000 | $5,000 |
Insurance | $7,200 | $7,400 | $7,400 |
Rent | $42,000 | $44,000 | $44,000 |
Payroll Taxes | $13,320 | $20,250 | $20,850 |
Other | $0 | $0 | $0 |
Total Operating Expenses | $192,712 | $251,650 | $246,250 |
Profit Before Interest and Taxes | ($14,557) | ($77) | $26,316 |
EBITDA | ($12,565) | $1,923 | $28,316 |
Interest Expense | $1,370 | $1,000 | $640 |
Taxes Incurred | $0 | $0 | $7,703 |
Net Profit | ($15,927) | ($1,077) | $17,973 |
Net Profit/Sales | -8.05% | -0.37% | 5.82% |
8.3 Projected Cash Flow
The following chart and table is the projected cash flow for Tucson Electronics.
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $197,950 | $287,573 | $308,566 |
Subtotal Cash from Operations | $197,950 | $287,573 | $308,566 |
Additional Cash Received | |||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 |
New Current Borrowing | $1,000 | $0 | $0 |
New Other Liabilities (interest-free) | $0 | $0 | $0 |
New Long-term Liabilities | $0 | $0 | $0 |
Sales of Other Current Assets | $0 | $0 | $0 |
Sales of Long-term Assets | $0 | $0 | $0 |
New Investment Received | $0 | $3,000 | $0 |
Subtotal Cash Received | $198,950 | $290,573 | $308,566 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $88,800 | $135,000 | $139,000 |
Bill Payments | $111,148 | $153,016 | $149,950 |
Subtotal Spent on Operations | $199,948 | $288,016 | $288,950 |
Additional Cash Spent | |||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 |
Principal Repayment of Current Borrowing | $1,000 | $0 | $0 |
Other Liabilities Principal Repayment | $3,600 | $3,600 | $3,600 |
Long-term Liabilities Principal Repayment | $3,600 | $3,600 | $3,600 |
Purchase Other Current Assets | $0 | $2,000 | $3,000 |
Purchase Long-term Assets | $0 | $5,000 | $5,000 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $208,148 | $302,216 | $304,150 |
Net Cash Flow | ($9,198) | ($11,643) | $4,416 |
Cash Balance | $27,002 | $15,359 | $19,775 |
8.4 Projected Balance Sheet
The following table is the projected balance sheet for Tucson Electronics.
Pro Forma Balance Sheet | |||
Year 1 | Year 2 | Year 3 | |
Assets | |||
Current Assets | |||
Cash | $27,002 | $15,359 | $19,775 |
Inventory | $2,794 | $5,081 | $5,081 |
Other Current Assets | $8,000 | $10,000 | $13,000 |
Total Current Assets | $37,796 | $30,440 | $37,856 |
Long-term Assets | |||
Long-term Assets | $4,000 | $9,000 | $14,000 |
Accumulated Depreciation | $1,992 | $3,992 | $5,992 |
Total Long-term Assets | $2,008 | $5,008 | $8,008 |
Total Assets | $39,804 | $35,448 | $45,864 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $11,731 | $12,652 | $12,295 |
Current Borrowing | $0 | $0 | $0 |
Other Current Liabilities | $10,000 | $6,400 | $2,800 |
Subtotal Current Liabilities | $21,731 | $19,052 | $15,095 |
Long-term Liabilities | $11,800 | $8,200 | $4,600 |
Total Liabilities | $33,531 | $27,252 | $19,695 |
Paid-in Capital | $48,500 | $51,500 | $51,500 |
Retained Earnings | ($26,300) | ($42,227) | ($43,304) |
Earnings | ($15,927) | ($1,077) | $17,973 |
Total Capital | $6,273 | $8,196 | $26,169 |
Total Liabilities and Capital | $39,804 | $35,448 | $45,864 |
Net Worth | $6,273 | $8,196 | $26,169 |
8.5 Business Ratios
The Business ratios give an overall idea of how profitable, and at what risk level, Tucson Electronics will operate at. The ratio table gives both time series analysis and cross-sectional analysis by including industry average ratios. Industry Profile ratios are based on Standard Industrial Classification (SIC) code 7622, Radio and Television Repair. As can be seen from the comparison between industry standards and Tucson Electronics own ratios, there are some differences. Most of these are due to the fact that there is a very large variance in assets, liabilities, financing, and net income between companies in this industry due to the vast differences in company size. The reader will also note that there is a fair amount of variability between the various years. This is due to the fact that the company is expected to grow quickly and have a large variance in profitability from year to year at first.
Overall the company’s projections show a company that faces the usual risks of companies in this industry and one that will be profitable in the long-run. The company shows that it has higher advertising and start-up costs than other competitors, however management has deliberately overstated costs and minimized profits in order to create a “safe” or “buffer” zone in case of hard times or other unforeseeable problems. Pre-tax return on net worth and pre-tax return on assets appears to be very high, especially within the first two years, however again this is due to the fact that the company will be facing highly variable revenue and costs over the first few years.
Ratio Analysis | ||||
Year 1 | Year 2 | Year 3 | Industry Profile | |
Sales Growth | 0.00% | 45.28% | 7.30% | 6.10% |
Percent of Total Assets | ||||
Inventory | 7.02% | 14.33% | 11.08% | 19.00% |
Other Current Assets | 20.10% | 28.21% | 28.34% | 27.50% |
Total Current Assets | 94.96% | 85.87% | 82.54% | 76.90% |
Long-term Assets | 5.04% | 14.13% | 17.46% | 23.10% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 54.59% | 53.75% | 32.91% | 36.90% |
Long-term Liabilities | 29.65% | 23.13% | 10.03% | 15.80% |
Total Liabilities | 84.24% | 76.88% | 42.94% | 52.70% |
Net Worth | 15.76% | 23.12% | 57.06% | 47.30% |
Percent of Sales | ||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 90.00% | 87.48% | 88.33% | 0.00% |
Selling, General & Administrative Expenses | 97.70% | 87.54% | 82.32% | 83.50% |
Advertising Expenses | 7.07% | 8.69% | 4.86% | 0.50% |
Profit Before Interest and Taxes | -7.35% | -0.03% | 8.53% | 3.10% |
Main Ratios | ||||
Current | 1.74 | 1.60 | 2.51 | 2.26 |
Quick | 1.61 | 1.33 | 2.17 | 1.47 |
Total Debt to Total Assets | 84.24% | 76.88% | 42.94% | 52.70% |
Pre-tax Return on Net Worth | -253.90% | -13.14% | 98.12% | 7.00% |
Pre-tax Return on Assets | -40.01% | -3.04% | 55.98% | 14.70% |
Additional Ratios | Year 1 | Year 2 | Year 3 | |
Net Profit Margin | -8.05% | -0.37% | 5.82% | n.a |
Return on Equity | -253.90% | -13.14% | 68.68% | n.a |
Activity Ratios | ||||
Inventory Turnover | 10.71 | 9.14 | 7.08 | n.a |
Accounts Payable Turnover | 10.47 | 12.17 | 12.17 | n.a |
Payment Days | 27 | 29 | 30 | n.a |
Total Asset Turnover | 4.97 | 8.11 | 6.73 | n.a |
Debt Ratios | ||||
Debt to Net Worth | 5.35 | 3.33 | 0.75 | n.a |
Current Liab. to Liab. | 0.65 | 0.70 | 0.77 | n.a |
Liquidity Ratios | ||||
Net Working Capital | $16,065 | $11,388 | $22,761 | n.a |
Interest Coverage | -10.63 | -0.08 | 41.12 | n.a |
Additional Ratios | ||||
Assets to Sales | 0.20 | 0.12 | 0.15 | n.a |
Current Debt/Total Assets | 55% | 54% | 33% | n.a |
Acid Test | 1.61 | 1.33 | 2.17 | n.a |
Sales/Net Worth | 31.56 | 35.09 | 11.79 | 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 | |||||||||||||
TVs | 0% | $3,000 | $3,200 | $3,400 | $3,550 | $3,550 | $3,550 | $3,700 | $3,700 | $4,000 | $4,800 | $4,800 | $5,000 |
VCRs | 0% | $3,500 | $3,600 | $3,700 | $3,900 | $3,900 | $3,900 | $4,000 | $4,200 | $4,500 | $5,100 | $5,400 | $5,900 |
DVDs | 0% | $2,000 | $2,200 | $2,200 | $2,400 | $2,400 | $2,400 | $2,600 | $2,600 | $3,000 | $4,200 | $5,000 | $5,500 |
Stereo Systems | 0% | $4,000 | $4,000 | $4,100 | $4,400 | $4,400 | $4,400 | $4,600 | $4,800 | $5,400 | $5,600 | $6,000 | $6,000 |
Microwave Ovens | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $400 | $2,500 | $3,000 |
Total Sales | $12,500 | $13,000 | $13,400 | $14,250 | $14,250 | $14,250 | $14,900 | $15,300 | $16,900 | $20,100 | $23,700 | $25,400 | |
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 | |
TVs | $300 | $320 | $340 | $355 | $355 | $355 | $370 | $370 | $400 | $480 | $480 | $500 | |
VCRs | $350 | $360 | $370 | $390 | $390 | $390 | $400 | $420 | $450 | $510 | $540 | $590 | |
DVDs | $200 | $220 | $220 | $240 | $240 | $240 | $260 | $260 | $300 | $420 | $500 | $550 | |
Stereo Systems | $400 | $400 | $410 | $440 | $440 | $440 | $460 | $480 | $540 | $560 | $600 | $600 | |
Microwave Ovens | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $40 | $250 | $300 | |
Subtotal Direct Cost of Sales | $1,250 | $1,300 | $1,340 | $1,425 | $1,425 | $1,425 | $1,490 | $1,530 | $1,690 | $2,010 | $2,370 | $2,540 |
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 | ||
Mr. James Munroe | 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 |
Mr. Samuel Munroe | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Part-time technician | 0% | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 |
Part-time technician | 0% | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 |
Part-time technician | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
Total Payroll | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 |
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 | $12,500 | $13,000 | $13,400 | $14,250 | $14,250 | $14,250 | $14,900 | $15,300 | $16,900 | $20,100 | $23,700 | $25,400 | |
Direct Cost of Sales | $1,250 | $1,300 | $1,340 | $1,425 | $1,425 | $1,425 | $1,490 | $1,530 | $1,690 | $2,010 | $2,370 | $2,540 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $1,250 | $1,300 | $1,340 | $1,425 | $1,425 | $1,425 | $1,490 | $1,530 | $1,690 | $2,010 | $2,370 | $2,540 | |
Gross Margin | $11,250 | $11,700 | $12,060 | $12,825 | $12,825 | $12,825 | $13,410 | $13,770 | $15,210 | $18,090 | $21,330 | $22,860 | |
Gross Margin % | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | |
Expenses | |||||||||||||
Payroll | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | |
Sales and Marketing and Other Expenses | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $3,400 | $3,200 | |
Depreciation | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | $166 | |
Leased Equipment | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Utilities | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Insurance | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
Rent | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | |
Payroll Taxes | 15% | $1,110 | $1,110 | $1,110 | $1,110 | $1,110 | $1,110 | $1,110 | $1,110 | $1,110 | $1,110 | $1,110 | $1,110 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $15,876 | $15,876 | $15,876 | $15,876 | $15,876 | $15,876 | $15,876 | $15,876 | $15,876 | $15,876 | $17,076 | $16,876 | |
Profit Before Interest and Taxes | ($4,626) | ($4,176) | ($3,816) | ($3,051) | ($3,051) | ($3,051) | ($2,466) | ($2,106) | ($666) | $2,214 | $4,254 | $5,984 | |
EBITDA | ($4,460) | ($4,010) | ($3,650) | ($2,885) | ($2,885) | ($2,885) | ($2,300) | ($1,940) | ($500) | $2,380 | $4,420 | $6,150 | |
Interest Expense | $126 | $123 | $121 | $118 | $116 | $113 | $111 | $108 | $114 | $112 | $109 | $98 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($4,752) | ($4,299) | ($3,937) | ($3,169) | ($3,167) | ($3,164) | ($2,577) | ($2,214) | ($780) | $2,102 | $4,145 | $5,886 | |
Net Profit/Sales | -38.01% | -33.07% | -29.38% | -22.24% | -22.22% | -22.21% | -17.29% | -14.47% | -4.62% | 10.46% | 17.49% | 23.17% |
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 | $12,500 | $13,000 | $13,400 | $14,250 | $14,250 | $14,250 | $14,900 | $15,300 | $16,900 | $20,100 | $23,700 | $25,400 | |
Subtotal Cash from Operations | $12,500 | $13,000 | $13,400 | $14,250 | $14,250 | $14,250 | $14,900 | $15,300 | $16,900 | $20,100 | $23,700 | $25,400 | |
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 | $1,000 | $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 | $12,500 | $13,000 | $13,400 | $14,250 | $14,250 | $14,250 | $14,900 | $15,300 | $17,900 | $20,100 | $23,700 | $25,400 | |
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 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | $7,400 | |
Bill Payments | $281 | $8,469 | $9,445 | $9,800 | $9,944 | $9,851 | $9,853 | $9,983 | $10,002 | $10,307 | $10,837 | $12,377 | |
Subtotal Spent on Operations | $7,681 | $15,869 | $16,845 | $17,200 | $17,344 | $17,251 | $17,253 | $17,383 | $17,402 | $17,707 | $18,237 | $19,777 | |
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 | $1,000 | |
Other Liabilities Principal Repayment | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Long-term Liabilities Principal Repayment | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
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 | $8,281 | $16,469 | $17,445 | $17,800 | $17,944 | $17,851 | $17,853 | $17,983 | $18,002 | $18,307 | $18,837 | $21,377 | |
Net Cash Flow | $4,219 | ($3,469) | ($4,045) | ($3,550) | ($3,694) | ($3,601) | ($2,953) | ($2,683) | ($102) | $1,793 | $4,863 | $4,023 | |
Cash Balance | $40,419 | $36,950 | $32,904 | $29,354 | $25,661 | $22,060 | $19,107 | $16,425 | $16,322 | $18,116 | $22,979 | $27,002 |
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 | $36,200 | $40,419 | $36,950 | $32,904 | $29,354 | $25,661 | $22,060 | $19,107 | $16,425 | $16,322 | $18,116 | $22,979 | $27,002 |
Inventory | $3,000 | $1,750 | $1,450 | $1,474 | $1,568 | $1,568 | $1,568 | $1,639 | $1,683 | $1,859 | $2,211 | $2,607 | $2,794 |
Other Current Assets | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 |
Total Current Assets | $47,200 | $50,169 | $46,400 | $42,378 | $38,922 | $35,228 | $31,628 | $28,746 | $26,108 | $26,181 | $28,327 | $33,586 | $37,796 |
Long-term Assets | |||||||||||||
Long-term Assets | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Accumulated Depreciation | $0 | $166 | $332 | $498 | $664 | $830 | $996 | $1,162 | $1,328 | $1,494 | $1,660 | $1,826 | $1,992 |
Total Long-term Assets | $4,000 | $3,834 | $3,668 | $3,502 | $3,336 | $3,170 | $3,004 | $2,838 | $2,672 | $2,506 | $2,340 | $2,174 | $2,008 |
Total Assets | $51,200 | $54,003 | $50,068 | $45,880 | $42,258 | $38,398 | $34,632 | $31,584 | $28,780 | $28,687 | $30,667 | $35,760 | $39,804 |
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 | $8,155 | $9,119 | $9,468 | $9,615 | $9,522 | $9,520 | $9,650 | $9,659 | $9,947 | $10,424 | $11,972 | $11,731 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $0 |
Other Current Liabilities | $13,600 | $13,300 | $13,000 | $12,700 | $12,400 | $12,100 | $11,800 | $11,500 | $11,200 | $10,900 | $10,600 | $10,300 | $10,000 |
Subtotal Current Liabilities | $13,600 | $21,455 | $22,119 | $22,168 | $22,015 | $21,622 | $21,320 | $21,150 | $20,859 | $21,847 | $22,024 | $23,272 | $21,731 |
Long-term Liabilities | $15,400 | $15,100 | $14,800 | $14,500 | $14,200 | $13,900 | $13,600 | $13,300 | $13,000 | $12,700 | $12,400 | $12,100 | $11,800 |
Total Liabilities | $29,000 | $36,555 | $36,919 | $36,668 | $36,215 | $35,522 | $34,920 | $34,450 | $33,859 | $34,547 | $34,424 | $35,372 | $33,531 |
Paid-in Capital | $48,500 | $48,500 | $48,500 | $48,500 | $48,500 | $48,500 | $48,500 | $48,500 | $48,500 | $48,500 | $48,500 | $48,500 | $48,500 |
Retained Earnings | ($26,300) | ($26,300) | ($26,300) | ($26,300) | ($26,300) | ($26,300) | ($26,300) | ($26,300) | ($26,300) | ($26,300) | ($26,300) | ($26,300) | ($26,300) |
Earnings | $0 | ($4,752) | ($9,051) | ($12,988) | ($16,157) | ($19,324) | ($22,489) | ($25,065) | ($27,280) | ($28,060) | ($25,958) | ($21,813) | ($15,927) |
Total Capital | $22,200 | $17,448 | $13,149 | $9,212 | $6,043 | $2,876 | ($289) | ($2,865) | ($5,080) | ($5,860) | ($3,758) | $387 | $6,273 |
Total Liabilities and Capital | $51,200 | $54,003 | $50,068 | $45,880 | $42,258 | $38,398 | $34,632 | $31,584 | $28,780 | $28,687 | $30,667 | $35,760 | $39,804 |
Net Worth | $22,200 | $17,448 | $13,149 | $9,212 | $6,043 | $2,876 | ($289) | ($2,865) | ($5,080) | ($5,860) | ($3,758) | $387 | $6,273 |