1
BUSINESS PLAN XXXXXXXXXXX XXXXXXX, LLC Laredo, Texas.
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
I.
2
TABLE OF CONTENTS
I.
Table of Contents
2
II.
Executive Summary
3
II.I Financial Objectives_____________________________________________ 4 III. General Company Description
6
IV. Products and Service
7
V. Marketing Plan
9
VI. Operational Plan
10
VII. Management and Organization
11
VIII. Startup Expenses and Capitalization
12
IX. Financial Indicators
13
IX.I
Revenue Forecast_____________________________________________ 14
IX.II
Year 1 Profit & Loss___________________________________________ 15
IX.III Breakeven analysis____________________________________________ 16 IX.IV Projected Profit and Loss_______________________________________ 17 IX.V
Projected Cash Flow__________________________________________ 18
IX.VI Projected Balance Sheet________________________________________ 19 X.
Appendix
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
20
II. EXECUTIVE SUMMARY
XXXXXXXXXXX. With address at XXXX E. Hillside Rd, Laredo, Texas., Zip Code 78041. It is a RESTAURANT company, created with the purpose of producing pleasure through flavor, aesthetic, freshness; quality and professionalism which allows generate a service of excellence at a competitive price. “XXXXXXXX”, is a brand with more than 14 years of being established in Laredo, Texas, in Japanese cuisine through the commercial brand we will work strongly to reinvent us in new areas of opportunity. Currently, there is XXXXXXXXXX through its founder XXXXXXXXXXXX with more than 17 years of experience in the field of International Fine cuisine. XXXXXXXXXXXX AND XXXXXXXX, are committed in being part of the continuous and demanding growth of our clients in the North of Laredo, Texas. Our key for success in this project is based in the philosophy of “THE PLEASURE OF SAVORING THROUGH SENSES”. Our commitment is to be different than our competitors. Through the investment partnerships of XXXX AND XXXX, it is created XXXXXX LLC. XXXXXXXXXXX. This new service will be focused to the medium high class of Laredo, Texas; a place to lunch and have dinner with the family, through our International cuisine. A fresh place due to its perfectionist design, as well as the presentation of its colorful dishes, which invite our clients to a new visit. The difference in our service is in the fully knowledge of the quality of fresh consumables prepared by our highly trained professional personnel, as well as in the communication technology in order to be at all times guaranteeing the operation process. Through the years we have gained broad experience in Customer Service, it is for this reason that we value our clients’ time. Our personnel’s training goes beyond dishes preparation, our commitment is to create confidence, quality and swiftness in service. Our goal is to be among the 3 main restaurants of international cuisine in Laredo, Texas. In order to achieve it we have key staff and wide experience in the Restaurant Service “International Cuisine”. Our investment Project is of $XXX,XXX Dollars starting operations on October, 2012, achieving our breakeven point in the third week of its opening operation. The expected sales average during the first five years is of $X,XXX,XXX, and a profit after taxes of $XXX,XXX, the payback period of investment will be in XX months, with an average margin net profit of XX.X%. Without anything further and at your service for any explanation regarding to this matter. Sincerely, XXXXXXXXX
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
3
4
II.I FINANCIAL OBJECTIVES
The following table and graphs illustrate the financial goals of the Company during the next five years. FINANCIAL HIGHLIGHTS ($000) r4
a Ye
r3
a Ye
r2
Projected)Opera-ng)Highlights)By)Year)($000))
a Ye
$11.35 $163.73
r1
29% 20% 12%
12
29% 20% 12%
a Ye
h
11
$82.10 $23.79 $7.68 $16.11 $10.02
$10.40 $152.38
t on M
h
$82.10 $23.79 $7.68 $16.11 $10.02
31% 22% 14% $16.97 $141.98
t on M
10
$102.62 $31.98 $8.90 $23.08 $14.78
28% 19% 12% $10.82 $125.01
h
9
$82.10 $23.12 $7.68 $15.44 $9.73
t on M
8
$9.89 $114.19
h
h
28% 19% 12%
t on M
$82.10 $23.12 $7.68 $15.44 $9.56
30% 21% 14% $16.34 $104.30
t on M
$9.78 $87.96
$102.62 $30.89 $8.90 $21.99 $14.03
7
$16.23 $78.18
28% 19% 11%
h
30% 21% 14%
t on M
$82.10 $22.92 $7.68 $15.24 $9.43
6
$10.64 $61.95
h
$51.31 $51.31
28% 18% 11%
5
Cash Balance-Ending
$102.62 $30.89 $9.05 $21.83 $13.93
t on M
Net Cash Flow
h
Net Profit/Revenue
28% 18% 11%
4
EBITDA/Revenue
$82.10 $22.92 $7.84 $15.08 $9.31
t on M
Gross Margin/Revenue
h
Net Profit
3
EBITDA
h
2
1 Operating Expenses
t on M
h
h
Gross Margin
t on M
t on M
t on M
$82.10 $22.92 $7.84 $15.08 $9.31
Revenue
Year 5
$102.62 $31.98 $8.90 $23.08 $14.78
$82.10 $1,067.25 $23.79 $312.09 $7.68 $97.52 $16.11 $214.57 $10.02 $134.93
31% 22% 14% $17.06 $180.79
29% 20% 12% $10.40 $191.20
29% 20% 13%
$1,113.78 $337.19 $99.35 $237.84 $144.86
$1,162.34 $363.72 $101.67 $262.04 $165.62
30% 21% 13%
$191.20 $167.65 $191.20 $ 358.85
$1,213.01 $391.62 $104.13 $287.48 $183.71
31% 23% 14%
$
$177.76 536.61
$1,265.89 $420.94 $106.73 $314.21 $201.06
32% 24% 15%
$
$191.18 727.79
33% 25% 16%
$
$206.33 934.12
Projected)Revenue)By)Year)($000))
!$1,400.00!!
!$1,300.00!!
!$1,200.00!!
!$1,250.00!!
!$1,000.00!!
!$1,200.00!! Revenue!
!$800.00!!
Gross!Margin! !$600.00!!
EBITDA!
!$1,150.00!! Revenue!
!$1,100.00!!
Net!Profit!
!$400.00!!
!$1,050.00!!
!$200.00!!
!$1,000.00!!
!$#!!!! Year!1!
Year!2!
Year!3!
Year!4!
!$950.00!!
Year!5!
Year!1!
Projected)Cash)Flow)By)Year)($000))
Year!2!
Year!3!
Year!4!
Year!5!
Projected)Net)Income)By)Year)($000))
$1,000.00$$
!$250.00!!
$900.00$$ $800.00$$
!$200.00!!
$700.00$$ $600.00$$
!$150.00!!
$500.00$$
Net$Cash$Flow$
$400.00$$
Cash$Balance$?Ending$
Net!Profit! !$100.00!!
$300.00$$
!$50.00!!
$200.00$$ $100.00$$
!$#!!!!
$0.00$$ Year$1$
Year$2$
Year$3$
Year$4$
Year$5$
Year!1!
Year!2!
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
Year!3!
Year!4!
Year!5!
III. GENERAL COMPANY DESCRIPTION
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX “XXXXX”. Started in the year of 1999 by its owners XXXX X. XXXXXX and XXXX XXXXX XXXXX. It is a company committed with its clients; it has been developed mainly in the city of Nuevo Laredo, Tamaulipas, Mexico. Its main service is Air Conditioning maintenance of the Residential-Commercial-Industrial fields, as well as the sale and installation of Air Conditioning Equipment. It has highly trained team of technicians for our most demanding clients, through which it has guaranteed throughout the years reliability and efficiency in the process. Its main founder XXXX X. XXXX, is a person with 27 years of experience in the knowledge of Customer Service of Air Conditioning. In the year of 1989 he obtains the degree of “Mechanical Electrical Engineer” in the City of Monterrey, Nuevo Leon. Likewise, he worked for several private companies in Monterrey during three years in which he acquired experience, same which gave him knowledge, force and character in order to establish his own business. In the year of 1991 he begins his own business in the city of Nuevo Laredo, Tamaulipas; in Air Conditioning as XXXX X. XXXXX as a fiscal taxpayer, one of the characteristics of XXXX X. is the tenacity and character and business growth vision. In accordance to market development and quality service which he is known for, in the year of 1999 he created the company IXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXS.A. through the years he has enter into the business environment in Mexico with the Service of Residential-Commercial-Industrial Air Conditioning in the Border of Mexico-United States. This has provided him knowledge and maturity to carry out a business with continuous growth in the Operational and Administrative areas. One of the most important values of XXXX X. XXXXX, is the service difference, same which he has achieved through honesty, ethics, professionalism and service attitude. Our goal is to diversify and expand in Laredo, Texas; and to become a corporation with different investment segments. Through this opening to be geographically located and capitalize it as a competitive advantage and with this become more appealing for our investors. Our partner, XXXX XXXXXXXX in XXXX XXX LLC. Company in Laredo, Texas; is guarantee for his expertise of 17 years in the knowledge of the Restaurant operation, we do not doubt the success of our company with the mixture of talents in different areas. We are experts in this matter, we have qualified personnel to take care of our clients.
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
5
6
III. GENERAL COMPANY DESCRIPTION
Our most important value is the experience and talent in Administration and Operation of Businesses. Our commitment is with ourselves, most of all with the focus in inventing and reinventing new ways of providing services to our clients. The enterprise was established by XXXXX X. XXXXXXX and XXXXX XXXXXX, in the month of September 14, 2012, in the City of Laredo, Texas, in the legal form of a corporation XXXXXX, LLC. YEAR 1 PERSONNEL FORECAST XXXXXXXXXX.LLC Week Personnel Count Cashier Waiter Dishwasher Captain Waiter Cook (Cold) Bartender Assistant Cook Cook (Suchi) Manager Operating Driver (Delivery) Accountant General Manager Total Personnel
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
4
4
5
4
5
4
4
5
4
4
5
4
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
3 6 1 1 2 1 2 3 1 1 1 1 23
Personnel Wage per Week Cashier Waiter Dishwasher Captain Waiter Cook (Cold) Bartender Assistant Cook Cook (Suchi) Manager Operating Driver (Delivery) Accountant General Manager
$ $ $ $ $ $ $ $ $ $ $ $
Personnel Cost: Cashier Waiter Dishwasher Captain Waiter Cook (Cold) Bartender Cook (Suchi) Manager Operating Driver (Delivery) Accountant General Manager Total Payroll
$ 3,672.00 $ 2,400.00 $ 1,160.00 $ 1,320.00 $ 2,320.00 $ 1,160.00 $ 6,000.00 $ 2,400.00 $ 1,160.00 $ 1,600.00 $ 3,000.00 $ 26,192.00
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ 3,672.00 $ 2,400.00 $ 1,160.00 $ 1,320.00 $ 2,320.00 $ 1,160.00 $ 6,000.00 $ 2,400.00 $ 1,160.00 $ 1,600.00 $ 3,000.00 $26,192.00
$ $ $ $ $ $ $ $ $ $ $ $
4,590.00 3,000.00 1,450.00 1,650.00 2,900.00 1,450.00 7,500.00 3,000.00 1,450.00 2,000.00 3,750.00 32,740.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ 3,672.00 $ 2,400.00 $ 1,160.00 $ 1,320.00 $ 2,320.00 $ 1,160.00 $ 6,000.00 $ 2,400.00 $ 1,160.00 $ 1,600.00 $ 3,000.00 $26,192.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ 4,590.00 $ 3,000.00 $ 1,450.00 $ 1,650.00 $ 2,900.00 $ 1,450.00 $ 7,500.00 $ 3,000.00 $ 1,450.00 $ 2,000.00 $ 3,750.00 $ 32,740.00
$ $ $ $ $ $ $ $ $ $ $ $
3,672.00 2,400.00 1,160.00 1,320.00 2,320.00 1,160.00 6,000.00 2,400.00 1,160.00 1,600.00 3,000.00 26,192.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ 3,672.00 $ 2,400.00 $ 1,160.00 $ 1,320.00 $ 2,320.00 $ 1,160.00 $ 6,000.00 $ 2,400.00 $ 1,160.00 $ 1,600.00 $ 3,000.00 $26,192.00
$ $ $ $ $ $ $ $ $ $ $ $
4,590.00 3,000.00 1,450.00 1,650.00 2,900.00 1,450.00 7,500.00 3,000.00 1,450.00 2,000.00 3,750.00 32,740.00
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ 3,672.00 $ 2,400.00 $ 1,160.00 $ 1,320.00 $ 2,320.00 $ 1,160.00 $ 6,000.00 $ 2,400.00 $ 1,160.00 $ 1,600.00 $ 3,000.00 $26,192.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ 3,672.00 $ 2,400.00 $ 1,160.00 $ 1,320.00 $ 2,320.00 $ 1,160.00 $ 6,000.00 $ 2,400.00 $ 1,160.00 $ 1,600.00 $ 3,000.00 $ 26,192.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ $ $ $ $ $ $ $ $ $ $ $
306.00 100.00 290.00 330.00 290.00 290.00 290.00 500.00 600.00 290.00 400.00 750.00
$ 4,590.00 $ 3,000.00 $ 1,450.00 $ 1,650.00 $ 2,900.00 $ 1,450.00 $ 7,500.00 $ 3,000.00 $ 1,450.00 $ 2,000.00 $ 3,750.00 $ 32,740.00
$ $ $ $ $ $ $ $ $ $ $ $
3,672.00 2,400.00 1,160.00 1,320.00 2,320.00 1,160.00 6,000.00 2,400.00 1,160.00 1,600.00 3,000.00 26,192.00
IV. PRODUCTS AND SERVICES
Our services are focused in satisfying the needs of our most demanding clients. The approach of our Business Model is to create a Complete Satisfaction in Customer Service through of our philosophy of “The pleasure of Savoring through Senses”. But we will achieve this through hygiene, quality and swiftness; same that will set us apart from our competitors. Our Services:
MENU: PHOTOS IN HERE
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
7
V. MARKETING PLAN
The state of Texas has a forecast growth during the following years in accordance to Eagle Ford Shale (EFS) is possibly the single economic development in the history of the State of Texas, in 2011 had an impact of more than $25 Billion of Dollars in the local economy of the South of Texas. Laredo, Texas is at a strategic location to provide service with labor and services to the economic demand of the following 10 years. This is why for XXXXX XXX, LLC., is quite significant to establish connections with our clients of Laredo, Texas., with the purpose of taking advantage of the growth of the local economy of the South of Texas. We will have our marketing plan guaranteed through our business strategies of synergy with our clients. We know our goal market, high and medium class which are at the North of the city of Laredo, Texas. In order to get to them we will conduct ourselves through segmented magazines, radio, television, as well as Chambers Commerce and billboards in geographically strategic sites. Financial Data: The City of Laredo, Texas, has a financially active population of 155,821 persons from which 48% are men and 52% women with an annual income per capita of $11,084 and an annual income per house of $29,108 Dollars. The economy of Laredo, Texas is mainly based in two productive sectors: International Freight Transportation, Storage and Custom Agencies, same which had an annual accelerated growth of 10%. On the other hand, authorities work very close with authorities of Nuevo Laredo, Tamaulipas, México, to open the bridge for freight 24 hours, and as result of this it will increase the economic flow in Laredo, Texas, as well as the retail trade. Both activities do not seem very affected by the economic conditions of the United States, due that they depend not only of the local consumption, but it is influenced greatly by the consumption of Mexicans who travel to the city for shopping, in case of retail trade and transportation they are influenced by the requirements of Mexican companies that use this border. (The main port of entrance of International Trade for Mexico and the largest customs of Latin America).
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
8
V. MARKETING PLAN
Barriers to entry: a. b. c. d. e. f. g. h. i.
High sense of service. Difference in the quality of our products. High quality in our services so that our clients are more competitive. New marketing strategies. Training and skills. Low costs. Competitive fees. Added value in the operational part (Personalized service). Cutting-edge technology in customer service.
Observing Barriers to entry: The way to observe barriers to entry from competitors is through a continuous improvement and efficient communication with our clients, by knowing at first hand their needs and of our employees through continuous training and instruction. Difference in our Service: Our proposal is to provide “The pleasure of savoring through senses”, creating repetitive experiences and visits through the consistency in our quality processes and the level of instruction and motivation of our human team. Our Clients Profile: Our goal is in the high and medium class of the community of Laredo, Texas. Our goal market is quite large same which we will be developing in strategic points of the city, as well as in important cities such as San Antonio, Texas and the Valley of Texas. Same which we will attain through the difference in our service of “Complete Satisfaction of our Clients”.
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
9
VI. OPERATIONAL PLAN
In order to initiate our operations, we have all of the equipment elements such as: Kitchen Equipment, Point of Sales Systems, Vehicles, Computer Equipment, Software, Decoration Equipment, Furniture, Chairs, Tables, Electronic Equipment, Communication Equipment and all of the accessories needed to operate XXXXXXXXX, LLC. We will have an area of 3,000 square feet which includes restaurant, offices and yard, we will be in a geographic strategic location of the City with high traffic with the purpose of satisfying our clients’ needs. Our business hours will be: Monday thru Sunday from 10:00 A.M. – 11:00 P.M Legal Requirements: a. Insurance of Delivery Equipment. b. Building Insurance. c. Employees’ Insurance. d. Security Fire Alarm. e. Security Alarm of Building. f. Articles of Incorporation of Company. g. Tax Registry (TaxID). Personnel Recruitment: a. b. c. d. e. f.
Number of employees 23. Skills in the knowledge of Restaurant. Knowledge in: (Sushi Preparation). Knowledge of Health regulations. Weekly wage payment. Training and instruction of one week required before operations begin.
g. Training in job profiles and procedures.
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
10
VII. MANAGEMENT AND ORGANIZATION
The leader of this Project has studies of specialization in several subjects specified in Administration per Objectives, Customer Service, Sales, and Marketing. He is a person with broad experience in Business Administration and with a high sense of entrepreneurship. As well as in the automation of evaluation processes of investment projects and business models. With a high responsibility in new business opportunities, a driven person as an entrepreneur in the organization and with a clear focus of the market’s needs. Organizational chart of XXXXXXX, LLC.
Professional Counsel: a. Board of Directors –
XXXXXXXXXXXXXXX and XXXXXXXXX.
b. Attorney –
M.A. Ramos & Associates. PC
c. Accountant-‐
Cuellar, Saldana, Cuellar, Morales & Co., P.L.L.C.
d. Insurance Agent-‐
Julio L. Delgado Insurance Services.
e. Consultant-‐
Laredo Consulting Group Inc.
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
11
12
VIII. STARTUP EXPENSES AND CAPITALIZATION
The initial Operating expenses are based in the Market’s research in other similar companies of equal size, at the same time our salaries are based according to the market and number of monthly operations. Percentages are equally measured based on standards such as it is the case of average costs, the fixed costs represent 43% over sales and 28% the variable cost over sales. Therefore, Operating Expenses represent 2% and Administration Expenses 8% over sales, for the first year. Discount Rate NPV (Net Present Value 5 Years) IRR (Internal Rate of Return) Payback
10% $496,544 USD 114% 10 Months XXXXXXXXXX.LLC START - UP
START-UP EXPENSES Advertising $ 1,000.00 Rent $ Architect & Enginering $ 25,000.00 Permits Fee $ Utility Deposit $ 67.42 Total Start-up Expenses $ 26,067.42
START-UP LIABILITIES Liabilities and Capital: Current borrowing $ 158,418.64 Lon-Term Liabilities $ Accounts Payable $ Other current Liabilities $ Total Start-up Liabilities $ 158,418.64
START-UP ASSETS Equitment: Improvements $ 38,516.51 Kitchen Equitment $ 28,288.78 Dinning Room Furniture $ 10,046.86 Computer/Printer $ 985.02 Software POS $ 13,423.00 Desk/Chair/Others $ 5,511.30 Working Capital $ 35,579.75 Total Start-up Assets $ 132,351.22
START-UP INVESTMENTS Planned Investment: Owner $ Investor $ $ $ $ $ $ Total Planned Investment $
TOTAL REQUIREMENTS Start-up Expenses $ 26,067.42 Star-up Assets $ 132,351.22
START-UP FUNDING Total Liabilities $ Total Planned Investment $
158,418.64 -
Total Start-up Expenses
Total Start-up Expenses
158,418.64
$
158,418.64
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
$
-
13
IX. FINANCIAL INDICATORS
The Following table summarizes the Company’s projected financial performance with standardized measurement indicators used to evaluate profitability, liquidity and leverage. As with any long-range projection, accuracy is based on reasonable estimates of return on investment. The company believes the following numbers are attainable and reasonable. However actual results will vary. XXXXXXXXXX.LLC Profitability % ' S: Gross Margin Net Profit Margin EBITDA Return on Assets Return on Equity Assets Turnover Liquidity Ratios: Current Ratio Current Debt to total Assets Ratio Acid-Test Ratio Accounts Payable Turnover Days' Sales in Receivable Accounts Receivable Turnover Inventory Turnover Leverage Ratios: Debt to Equity Debt to Assets Ratio Interest Coverage Ratio
FINANCIAL INDICATORS Year 2 Year 3 Year 4
Year 1
Year 5
29% 13% 20% 64% 100% 3.45
30% 13% 21% 47% 52% 2.44
31% 14% 23% 40% 37% 1.87
32% 15% 24% 35% 29% 1.50
33% 16% 25% 31% 24% 1.26
1.16 56% 1.13 0.50 0.00 N/A 3.94
2.11 39% 2.07 0.45 0.00 N/A 4.07
3.11 28% 3.07 0.45 0.00 N/A 4.13
4.18 22% 4.14 0.44 0.00 N/A 4.19
5.32 18% 5.28 0.43 0.00 N/A 4.25
1.29 56% N/A
0.63 39% N/A
0.40 28% N/A
0.28 22% N/A
0.21 18% N/A
Financial Indicators 60% 50% 40%
Net Profit Margin EBITDA
30%
Debt to Assets Ratio 20%
Current Debt to total Assets Ratio
10% 0% Year 1
Year 2
Year 3
Year 4
Year 5
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
14
IX.I REVENUE FORECAST
Sales budget was prepared based on our potential clients of Laredo, Texas. We initiated our operations through a comprehensive analysis of XXX clients per day, from which 51% are lunch and 49% dinner, consumption average is of $XX.XX per client for the first year. Year 1 Revenue Monthly $120,000
Thousands of Dollars
$100,000
$80,000
$60,000
$40,000
$20,000
$-
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Dinner
$44,755
$44,755
$55,944
$44,755
$55,944
$44,755
$44,755
$55,944
$44,755
$44,755
$55,944
$44,755
Lunch
$37,341
$37,341
$46,677
$37,341
$46,677
$37,341
$37,341
$46,677
$37,341
$37,341
$46,677
$37,341
Revenue By Year 1,400,000
Thousands of Dollars
1,200,000 1,000,000 800,000 600,000 400,000 200,000 -
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
Dinner
581,814
607,179
633,649
661,274
690,103
Lunch
485,437
506,600
528,686
551,735
575,788
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
15
IX.II YEAR 1 PROFIT & LOSS
The Financial Plan is of 5 years, in the first year it is expected a growth in Sales based on a study of our potential clients of Laredo, Texas. Costs and Expenses are based on standards of similar companies in the market, but our yield is based in our Service Formula of all of our Clients, finding a breakeven point in the first three weeks of operations. Month Profit and Loss Projection: XXXXXXXXXX.LLC
INCOME STATEMENT YEAR 1
Income
$
Month 1 82,096
$
Month 2 82,096
$
Month 3 102,620
$
Month 4 82,096
$
Month 5 102,620
$
Month 6 82,096
$
Month 7 82,096
$
Month 8 102,620
$
Month 9 82,096
$
Month 10 82,096
$
Month 11 102,620
$
Month 12 82,096
$
YEAR 1 1,067,251
Cost of Goods Sold Variable Costs: Fixed Costs:
$ $ $
59,178 22,987 36,191
$ $ $
59,178 22,987 36,191
$ $ $
71,735 28,734 43,001
$ $ $
59,178 22,987 36,191
$ $ $
71,735 28,734 43,001
$ $ $
58,979 22,987 35,992
$ $ $
58,979 22,987 35,992
$ $ $
70,643 28,734 41,910
$ $ $
58,305 22,987 35,318
$ $ $
58,305 22,987 35,318
$ $ $
70,643 28,734 41,910
$ $ $
58,305 22,987 35,318
$ $ $
755,163 298,830 456,333
Gross Profit % Operating Expenses Administrative Expenses Total Expenses
$
22,918 28% 1,425 6,418 7,843
$
22,918 28% 1,425 6,418 7,843
$
30,885 30% 1,425 7,627 9,052
$
22,918 28% 1,425 6,257 7,682
$
30,885 30% 1,425 7,472 8,897
$
23,118 28% 1,425 6,257 7,682
$
23,118 28% 1,425 6,257 7,682
$
31,977 31% 1,425 7,472 8,897
$
23,791 29% 1,425 6,257 7,682
$
23,791 29% 1,425 6,257 7,682
$
31,977 31% 1,425 7,472 8,897
$
23,791 29% 1,425 6,257 7,682
$
$ $ $
$ $ $
312,088 29% 17,100 80,416 97,516
EBITDA % Interes expenses Amort and Dep
$ $
$15,075 18% $ 1,330 $
$15,075 18% $ 1,330 $
$21,833 21% $ 1,330 $
$15,236 19% $ 1,330 $
$21,989 21% $ 1,330 $
$15,436 19% $ 1,330 $
$15,436 19% $ 1,089 $
$23,081 22% $ 1,330 $
$16,110 20% $ 1,330 $
$16,110 20% $ 1,330 $
$23,081 22% $ 1,330 $
$16,110 $ 20% $ 1,330 $
214,572 20% 15,715
Taxable Income (Loss) % Income Tax Franshice Tax
$ $
$13,746 17% 4,203 $ 229 $
$13,746 17% 4,203 $ 229 $
$20,504 20% 6,269 $ 309 $
$13,907 17% 4,252 $ 229 $
$20,659 20% 6,317 $ 309 $
$14,106 17% 4,313 $ 231 $
$14,347 17% 4,387 $ 231 $
$21,751 21% 6,651 $ 320 $
$14,780 18% 4,519 $ 238 $
$14,780 18% 4,519 $ 238 $
$21,751 21% 6,651 $ 320 $
$14,780 $ 18% 4,519 $ 238 $
198,857 19% 60,804 3,121
$14,780
$10,023
$10,023
$14,780
$10,023
$134,932
Net Income (Loss)
$ $ $
$9,314
$ $ $
$9,314
$ $ $
$13,926
$ $ $
$9,425
$ $ $
$14,033
$ $ $
$9,562
$ $ $
$9,729
$ $ $
$ $ $
$ $ $
$ $ $
Projected Cash Flow: XXXXXXXXXX.LLC Cash Flow From Operating Activities: Net Income Depreciation and Amortization Income charges not affecting cash Cash provided by Operating Activities
CASH FLOW YEAR 1 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 YEAR 1 $9,314 $9,314 $13,926 $9,425 $14,033 $9,562 $9,729 $14,780 $10,023 $10,023 $14,780 $10,023 $134,932 $ 1,330 $ 1,330 $ 1,330 $ 1,330 $ 1,330 $ 1,330 $ 1,089 $ 1,330 $ 1,330 $ 1,330 $ 1,330 $ 1,330 $ 15,715 $ $ $ $ $ $ $ $ $ $ $ $ $ $10,643 $10,643 $15,255 $10,755 $15,363 $10,892 $10,818 $16,110 $11,353 $11,353 $16,110 $11,353 $ 150,647
-(+) Changes in certain Working Capital
($5,086)
Net Cash provided by Operating Activities
$15,729
$0 $10,643
(+) Cash Provided (Used) by Investing Activities: Total Cash used by investing activities
$
158,419
$
(-) Cash Provided (Used) by Financing Activities: Total Cash used by Financing Activities
$
122,839
$
Cash and Equivalents, Beginning of year Cash and Equivalents, end of year
$51,309 $51,309
-
$
-
$
$10,643 $61,952
($977)
$977
($977)
$16,232
$9,778
$16,340
-
$
-
$
$16,232 $78,184
-
$
-
$
$9,778 $87,962
$1,003
$0
$9,888
-
$
-
$
$16,340 $104,302
$10,818
-
$
-
$
$9,888 $114,190
-
$
-
$
$10,818 $125,008
($860)
$948
$16,970
$10,404
-
$
-
$
$16,970 $141,978
$0 $11,353
-
$
-
$
$10,404 $152,382
-
$
-
$
$11,353 $163,735
($948)
$948
$17,058
$10,404
-
$
-
$
$17,058 $180,793
-$4,971 $155,618
-
$
158,419
-
$
122,839
$10,404 $ $191,198 $
191,198 191,198
Projected Balance Sheet: XXXXXXXXXX.LLC
BALANCE SHEET YEAR 1
Cash and Equivalents Short-Term Investment Accounts Receivable Total Current Assets
$ $ $ $
Month 1 5,401 51,309 62,550
$ $ $ $
Month 2 5,401 61,952 73,193
$ $ $ $
Month 3 6,751 78,184 92,015
$ $ $ $
Month 4 5,401 87,962 99,203
$ $ $ $
Month 5 6,751 104,302 118,133
$ $ $ $
Month 6 5,401 114,190 125,412
$ $ $ $
Month 7 5,401 125,008 136,230
$ $ $ $
Month 8 6,751 141,978 155,701
$ $ $ $
Month 9 5,401 152,382 163,537
$ $ $ $
Month 10 5,401 163,735 174,890
$ $ $ $
Month 11 6,751 180,793 194,516
$ $ $ $
Month 12 5,401 191,198 202,352
$ $ $ $
YEAR 1 5,401 191,198 202,352
Machinery & Equipment Furniture & Equipment Transport & Equipment Electronic & Equipment Net Fixed Assets Total Assests
$ $ $ $ $ $
81,383 14,168 95,551 184,059
$ $ $ $ $ $
80,402 13,928 94,330 193,373
$ $ $ $ $ $
79,421 13,688 93,109 210,865
$ $ $ $ $ $
78,440 13,447 91,888 216,724
$ $ $ $ $ $
77,459 13,207 90,667 234,324
$ $ $ $ $ $
76,479 12,967 89,446 240,273
$ $ $ $ $ $
75,498 12,967 88,465 250,002
$ $ $ $ $ $
74,517 12,727 87,244 268,143
$ $ $ $ $ $
73,536 12,487 86,023 274,650
$ $ $ $ $ $
72,555 12,247 84,802 284,673
$ $ $ $ $ $
71,575 12,007 83,581 302,970
$ $ $ $ $ $
70,594 11,767 82,360 309,477
$ $ $ $ $ $
70,594 11,767 82,360 309,477
Total Current Liabilities
$
174,746
$
174,746
$
178,312
$
174,746
$
178,312
$
174,700
$
174,700
$
178,061
$
174,545
$
174,545
$
178,061
$
174,545
$
174,545
Total Liabilities
$
174,746
$
174,746
$
178,312
$
174,746
$
178,312
$
174,700
$
174,700
$
178,061
$
174,545
$
174,545
$
178,061
$
174,545
$
174,545
Common Stock Retained Earnings Earnings Total Equity
$ $ $ $
9,314 9,314
$ $ $ $
9,314 9,314 18,627
$ $ $ $
18,627 13,926 32,553
$ $ $ $
32,553 9,425 41,978
$ $ $ $
41,978 14,033 56,011
$ $ $ $
56,011 9,562 65,573
$ $ $ $
65,573 9,729 75,302
$ $ $ $
75,302 14,780 90,083
$ $ $ $
90,083 10,023 100,106
$ $ $ $
100,106 10,023 110,129
$ $ $ $
110,129 14,780 124,909
$ $ $ $
124,909 10,023 134,932
$ $ $
$0 134,932 134,932
Total Liabilities and Shareholders' Equity
$
184,059
$
193,373
$
210,865
$
216,724
$
234,324
$
240,273
$
250,002
$
268,143
$
274,650
$
284,673
$
302,970
$
309,477
$
309,477
Current'Assets:
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
16
IX.III BREAKEVEN ANALYSIS
XXXXXXXXXX.LLC YEAR$1 Week$1 Week$2 Week$3 $$$$$$$$$$$$$$ 1,068 1068 1068 $$$$$$$$$$$ 20,555 $$$$$$$$$$$$$$ 20,555 $$$$$$$$$$$$$$ 20,555 $$$$$$$$$$$$$ 5,755 $$$$$$$$$$$$$$$$ 5,755 $$$$$$$$$$$$$$$$ 5,755 $$$$$$$$$$$ 44,034 $$$$$$$$$$$$$$ 29,235 $$$$$$$$$$$$$$ 14,435 $$$$$$$$$$$ 49,789 $$$$$$$$$$$$$$ 34,990 $$$$$$$$$$$$$$ 20,190 B$29,235 B$14,435 $364
Customer$Number Sales Variable$Costs Fixed$Costs Total$Costs EBITDA Break&even X $&&&&&&&&&&&&&&&& 3,178
Break&Even Label $ $&&&&&61,161.40 BEU&APROX=3178
Wek$4 1068 $$$$$$$$$$$$$$ 20,555 $$$$$$$$$$$$$$$$ 5,755 $$$$$$$$$$$$$$$$$$$ B $$$$$$$$$$$$$$$$ 5,755 $14,799
Break)Even)Analysis) Sales!
!$100,000!!
Fixed!
Total!Cost!
BEU!APROX=3178!
!$90,000!! !$80,000!! !$70,000!! !$60,000!! !$50,000!! !$40,000!! !$30,000!! !$20,000!! !$10,000!! !$#!!!! 0!
1000!
2000!
3000!
4000!
5000!
6000!
Customer)Number)
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
17
IX.IV PROJECTED PROFIT AND LOSS
FIVE YEAR FINANCIAL PLAN A Financial Plan was prepared for 5 years, for the first year our Direct Cost is of 71% with an EBITDA of 20%, and in the following years it will reach a Direct Cost of 67% and an EBITDA average of 22%. In summary, our Average Net Profit after taxes will be of 14.2% during the next years. XXXXXXXXXX.LLC
INCOME STATEMENT
Income
$
YEAR 1 1,067,251
Cost of Goods Sold Variable Costs: Fixed Costs:
$ $ $
755,163 298,830 456,333
71% $ 28% $ 43% $
776,592 311,858 464,733
70% $ 28% $ 42% $
798,616 325,454 473,162
69% $ 28% $ 41% $
821,393 339,642 481,750
68% $ 28% $ 40% $
844,949 354,449 490,500
67% 28% 39%
Gross Profit % Operating Expenses Administrative Expenses Total Expenses
$
312,088 29% 17,100 80,416 97,516
29% $
337,187 30% 17,326 82,022 99,347
30% $
363,719 31% 17,554 84,120 101,674
31% $
391,616 32% 17,786 86,346 104,132
32% $
420,941 33% 18,021 88,714 106,735
33%
EBITDA % Interes expenses Amort and Dep
$
214,572 20% 15,715
20% $
237,840 21% 22,292
21% $
262,045 23% 12,036
23% $
287,484 24% 7,356
24% $
314,207 25% 5,158
25%
Taxable Income (Loss) % Income Tax Franshice Tax
$
198,857 19% 60,804 3,121
19% $
19% $
8% $ 0% $
309,049 24% 103,779 4,209
24%
7% $ 0% $
280,128 23% 92,500 3,916
23% $
6% $ 0% $
250,009 22% 80,754 3,637
22% $
6% $ 0% $
215,548 19% 67,314 3,372
$134,932
13% $
144,863
13% $
165,618
14% $
183,712
15% $
201,061
16%
$ $ $
$ $
$ $
Net Income (Loss)
% YEAR 2 100% $ 1,113,779
2% $ 8% $ 9% $
0% $ $
% YEAR 3 100% $ 1,162,335
2% $ 7% $ 9% $
0% $ $
% YEAR 4 100% $ 1,213,008
2% $ 7% $ 9% $
0% $ $
% YEAR 5 100% $ 1,265,891
1% $ 7% $ 9% $
0% $ $
% 100%
1% 7% 8%
0%
8% 0%
Gross Margin & Profit Yearly $1,400,000
Thousands!of!Dollars!
$1,200,000 $1,000,000 $800,000
Revenue
$600,000
Total Cost Gross Margin
$400,000
Net Profit
$200,000 $Year 1
Year 2
Year 3
Year 4
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
Year 5
18
IX.V PROJECTED CASH FLOW XXXXXXXXXX.LLC
CASH FLOW
Cash Flow From Operating Activities: Net Income Depreciation and Amortization Income charges not affecting cash Cash provided by Operating Activities
YEAR 1 $134,932 $ 15,715 $ $ 150,647
-(+) Changes in certain Working Capital
$ $ $ $
-$4,971
Net Cash provided by Operating Activities
YEAR 2 144,863 22,292 167,155
$ $ $ $
YEAR 3 165,618 12,036 177,654
-$494
$155,618
$
$ $ $ $
YEAR 4 183,712 7,356 191,068
-$108
167,649
$
177,762
$ $ $ $
YEAR 5 201,061 5,158 206,218
-$111 $
191,178
-$113 $
206,332
(+) Cash Provided (Used) by Investing Activities: Total Cash used by investing activities
$
158,419
$
-
$
-
$
-
$
-
(-) Cash Provided (Used) by Financing Activities: Total Cash used by Financing Activities
$
122,839
$
-
$
-
$
-
$
-
Cash and Equivalents, Beginning of year Cash and Equivalents, end of year
$ $
191,198 191,198
$ $
167,649 358,847
$ $
177,762 536,609
$ $
191,178 727,787
$ $
206,332 934,119
Cash Flow Yearly $1,000,000 $900,000 Thousands!of!Dollars!
$800,000 $700,000 $600,000
Net Cash Flow
$500,000
Cash Balance
$400,000 $300,000 $200,000 $100,000 $0 Year 1
Year 2
Year 3
Year 4
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
Year 5
19
IX.VI PROJECTED BALANCE SHEET XXXXXXXXXX.LLC
BALANCE SHEET
Cash and Equivalents Short-Term Investment Accounts Receivable Total Current Assets
$ $ $ $
YEAR 1 5,401 191,198 202,352
2% 62% 0% 65%
$ $ $ $
YEAR 2 6,106 358,847 371,336
Machinery & Equipment Furniture & Equipment Transport & Equipment Electronic & Equipment Net Fixed Assets Total Assests
$ $ $ $ $ $
70,594 11,767 82,360 309,477
0% 23% 0% 4% 27% 100%
$ $ $ $ $ $
53,305 8,001 61,307 456,168
Total Current Liabilities
$
174,545
56% $
Total Liabilities
$
174,545
Common Stock Retained Earnings Earnings Total Equity
$ $ $
$0 134,932 134,932
Total Liabilities and Shareholders' Equity
$
309,477
Current'Assets:
1% 79% 0% 81%
$ $ $ $
YEAR 3 6,372 536,609 549,545
12% 0% 2% 2% 13% 100%
$ $ $ $ $ $
43,982 6,465 50,447 622,342
176,373
39% $
56% $
176,373
0% 0% 44% 44%
$ $ $ $
134,932 144,863 279,795
100% $
456,168
%
1% 86% 0% 88%
$ $ $ $
YEAR 4 6,650 727,787 741,189
0% 7% 0% 1% 8% 100%
$ $ $ $ $ $
38,489 5,720 44,209 806,630
176,929
28% $
39% $
176,929
0% 30% 32% 61%
$ $ $ $
279,795 165,618 445,413
100% $
622,342
%
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
1% 90% 0% 92%
$ $ $ $
YEAR 5 6,940 934,119 948,004
1% 93% 0% 94%
0% 5% 0% 1% 5% 100%
$ $ $ $ $ $
35,052 5,061 40,113 1,008,288
0% 3% 0% 1% 4% 100%
177,505
22% $
178,102
18%
28% $
177,505
22% $
178,102
18%
0% 45% 27% 72%
$ $ $ $
445,413 183,712 629,125
0% 55% 23% 78%
$ $ $ $
629,125 201,061 830,185
0% 62% 20% 82%
100% $
806,630
100% $
1,008,288
100%
%
%
%
X. APPENDIX
Support and Business Plan Analysis: •
Maps and Building Pictures.
•
Detail of the Purchased Equipment List.
•
Lease agreement copies.
•
Letters and connections of future clients.
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
20
21 !
! !
XXXXXXXXXX.LLC Data: number of weeks Numer of Days Percent increase Number of Seats Dayli Average Customer Lunch/Average/Week/Day Dinner/Average/Week/Day Lunch/Table turns/Average/Week/Day Dinners/Table Turns/Average/Week/Day Lunch/Covers/Average/Week/Day Dinner/Covers/Average/Week/Day
Month 1
Rates:
Lunch Dinner
$ $
Month 2
Month 3
Month 4
Month 5
YEAR 1 Month 7
Month 6
Month 8
Month 9
Month 10
Month 11
Month 12
4 31
4 30
5 31
4 31
5 28
4 31
4 30
5 31
4 30
4 31
5 31
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 $ 21.26 $
YEAR 1
YEAR 2
4 30
52 365
64 153 51% 49% 1.21 1.17 77.38 75.20 0% 17.24 21.26
64 153 51% 49% 1.21 1.17 77.38 75.20 0%
YEAR 3
$ $
YEAR 4
YEAR 5
52
52
52
3% 64.00 157 51% 49% 1.25 1.21 79.70 77.45 0% 17.46 $ 21.54 $
3% 64.00 162 51% 49% 1.28 1.25 82.09 79.78 0% 17.69 $ 21.82 $
3% 64.00 167 51% 49% 1.32 1.28 84.55 82.17 0% 17.93 $ 22.11 $
52 3% 64.00 172 51% 49% 1.36 1.32 87.09 84.64 0% 18.16 22.40
Sales:
Lunch Dinner Total Sales
$ $ $
37,341.34 44,754.90 82,096.24
$ 37,341.34 $ 44,754.90 $ 82,096.24
$ 46,676.67 $ 55,943.63 $ 102,620.30
$ 37,341.34 $ 44,754.90 $ 82,096.24
$ 46,676.67 $ 55,943.63 $ 102,620.30
$ $ $
37,341.34 44,754.90 82,096.24
$ $ $
37,341.34 44,754.90 82,096.24
$ $ $
46,676.67 55,943.63 102,620.30
$ $ $
37,341.34 44,754.90 82,096.24
$ $ $
37,341.34 44,754.90 82,096.24
$ $ $
46,676.67 55,943.63 102,620.30
$ $ $
37,341.34 44,754.90 82,096.24
$ $ $
485,437.37 581,813.75 1,067,251.12
$ $ $
506,600.50 607,178.51 1,113,779.00
$ $ $
#REF!
Cost of Goods Sold Variable Costs:
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
59,178.29 22,986.95 22,986.95 36,191.35 3,250.00 24,956.80 361.87 1,048.19 199.65 673.83 2,283.55 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Gross Profit %
$
Operating Expenses Meals and entertainment Telephone(nextel) Advertising Repairs & Maint. Cars Gas Insurance Administrative Expenses Bank service charges Repairs & Maint. Building Manteinance computer Internet Mail Service Insurance Workman Compensation Salaries & Wages Medi car Soc. Sec Futa Suta Payroll tax Office Supplies Legal & Profesional Taxes & Licenses Total Expenses % EBITDA % Interes expenses Amort and Dep
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
22,917.95 28% $22,918 1,425.00 240.00 1,085.00 100.00 6,417.57 50.00 80.00 4,600.00 66.70 193.20 36.80 124.20 420.90 200.00 650.00 416.67 7,842.57 10% $15,075 18% 1,330
$ 22,917.95 28% 45835.89139 $ 1,425.00 $ 240.00 $ $ 1,085.00 $ $ 100.00 $ $ 6,417.57 $ 50.00 $ $ $ $ 80.00 $ $ 4,600.00 $ 66.70 $ 193.20 $ 36.80 $ 124.20 $ 420.90 $ 200.00 $ 650.00 $ 416.67 $ 7,842.57 10% $15,075 18% $ $ 1,330
$
$13,746 $13,746 $20,504 $13,907 17% 17% 20% 17% 13,745.82 $ 27,491.64 $ 47,995.47 $ 61,902.29 $
Food Purchase Fixed Costs: Rent Salaries & Wages Medi car Soc. Sec Futa Suta Payroll tax Maintenance (Kitchen) Restaurant Supplies Property Taxes(Assets) Insurance Building Insurance (Equipment) Equipment Rent (Auto) Equipment Rent (Dishwasher) Telephone Trash Removal Water Utilities Security systems fumigation Insurance Workman Compensation
Taxable Income (Loss) %
59,178.29 22,986.95 22,986.95 36,191.35 3,250.00 24,956.80 361.87 1,048.19 199.65 673.83 2,283.55 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
71,735.12 28,733.68 28,733.68 43,001.43 3,250.00 31,196.00 452.34 1,310.23 249.57 842.29 2,854.43 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ 30,885.18 30% $76,721 $ 1,425.00 $ 240.00 $ $ 1,085.00 $ $ 100.00 $ $ 7,626.79 $ 50.00 $ $ $ $ 80.00 $ $ 5,750.00 $ 83.38 $ 241.50 $ $ 155.25 $ 480.13 $ 200.00 $ 650.00 $ 416.67 $ 9,051.79 9% $21,833 21% $ $ 1,330
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
59,178.29 22,986.95 22,986.95 36,191.35 3,250.00 24,956.80 361.87 1,048.19 199.65 673.83 2,283.55 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ 22,917.95 28% $99,639 $ 1,425.00 $ 240.00 $ $ 1,085.00 $ $ 100.00 $ $ 6,256.57 $ 50.00 $ $ $ $ 80.00 $ $ 4,600.00 $ 66.70 $ 193.20 $ $ $ 259.90 $ 200.00 $ 650.00 $ 416.67 $ 7,681.57 9% $15,236 19% $ $ 1,330
528,686.25 633,649.06 1,162,335.31
$ $ $
#REF!
551,734.86 661,273.63 1,213,008.48
$ $ $
#REF!
575,788.29 690,102.51 1,265,890.80 #REF!
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
71,735.12 28,733.68 28,733.68 43,001.43 3,250.00 31,196.00 452.34 1,310.23 249.57 842.29 2,854.43 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
58,978.64 22,986.95 22,986.95 35,991.69 3,250.00 24,956.80 361.87 1,048.19 673.83 2,083.89 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
58,978.64 22,986.95 22,986.95 35,991.69 3,250.00 24,956.80 361.87 1,048.19 673.83 2,083.89 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
70,643.26 28,733.68 28,733.68 41,909.57 3,250.00 31,196.00 452.34 1,310.23 1,762.57 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
58,304.81 22,986.95 22,986.95 35,317.86 3,250.00 24,956.80 361.87 1,048.19 1,410.06 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
58,304.81 22,986.95 22,986.95 35,317.86 3,250.00 24,956.80 361.87 1,048.19 1,410.06 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
70,643.26 28,733.68 28,733.68 41,909.57 3,250.00 31,196.00 452.34 1,310.23 1,762.57 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
58,304.81 22,986.95 22,986.95 35,317.86 3,250.00 24,956.80 361.87 1,048.19 1,410.06 300.00 1,000.00 250.00 400.00 100.00 300.00 192.00 500.00 245.00 250.00 2,050.00 32.00 82.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
755,163.33 298,830.31 298,830.31 456,333.02 39,000.00 324,438.40 4,704.36 13,626.41 1,098.10 5,053.75 24,482.62 3,600.00 12,000.00 3,000.00 4,800.00 1,200.00 3,600.00 2,304.00 6,000.00 2,940.00 3,000.00 24,600.00 384.00 984.00 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
776,591.51 311,858.12 311,858.12 464,733.39 39,514.80 330,927.17 4,798.44 13,898.94 1,176.00 5,103.00 24,976.38 3,647.52 12,158.40 3,039.60 4,863.36 1,215.84 3,647.52 2,334.41 6,079.20 2,978.81 3,039.60 24,924.72 389.07 996.99 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
798,616.32 325,453.89 325,453.89 473,162.44 40,036.40 337,545.71 4,894.41 14,176.92 1,176.00 5,103.00 25,350.33 3,695.67 12,318.89 3,079.72 4,927.56 1,231.89 3,695.67 2,365.23 6,159.45 3,018.13 3,079.72 25,253.73 394.20 1,010.15 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
821,392.67 339,642.37 339,642.37 481,750.29 40,564.88 344,296.63 4,992.30 14,460.46 1,176.00 5,103.00 25,731.76 3,744.45 12,481.50 3,120.38 4,992.60 1,248.15 3,744.45 2,396.45 6,240.75 3,057.97 3,120.38 25,587.08 399.41 1,023.48 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
844,949.43 354,449.42 354,449.42 490,500.01 41,100.33 351,182.56 5,092.15 14,749.67 1,176.00 5,103.00 26,120.81 3,793.88 12,646.26 3,161.56 5,058.50 1,264.63 3,793.88 2,428.08 6,323.13 3,098.33 3,161.56 25,924.82 404.68 1,036.99 -
$
30,885.18 30% $130,524 1,425.00 240.00 1,085.00 100.00 7,471.54 50.00 80.00 5,750.00 83.38 241.50 324.88 200.00 650.00 416.67 8,896.54 9% $21,989 21% 1,330
$
23,117.60 28% $153,642 1,425.00 240.00 1,085.00 100.00 6,256.57 50.00 80.00 4,600.00 66.70 193.20 259.90 200.00 650.00 416.67 7,681.57 9% $15,436 19% 1,330
$
23,117.60 28% $176,759 1,425.00 240.00 1,085.00 100.00 6,256.57 50.00 80.00 4,600.00 66.70 193.20 259.90 200.00 650.00 416.67 7,681.57 9% $15,436 19% 1,089
$
31,977.04 31% $208,736 1,425.00 240.00 1,085.00 100.00 7,471.54 50.00 80.00 5,750.00 83.38 241.50 324.88 200.00 650.00 416.67 8,896.54 9% $23,081 22% 1,330
$
23,791.43 29% $232,528 1,425.00 240.00 1,085.00 100.00 6,256.57 50.00 80.00 4,600.00 66.70 193.20 259.90 200.00 650.00 416.67 7,681.57 9% $16,110 20% 1,330
$
23,791.43 29% $256,319 1,425.00 240.00 1,085.00 100.00 6,256.57 50.00 80.00 4,600.00 66.70 193.20 259.90 200.00 650.00 416.67 7,681.57 9% $16,110 20% 1,330
$
31,977.04 31% $288,296 1,425.00 240.00 1,085.00 100.00 7,471.54 50.00 80.00 5,750.00 83.38 241.50 324.88 200.00 650.00 416.67 8,896.54 9% $23,081 22% 1,330
$
$
312,087.79 29% $312,088 17,100.00 2,880.00 13,020.00 1,200.00 80,415.95 600.00 960.00 59,800.00 867.10 2,511.60 73.60 403.65 3,855.95 2,400.00 7,800.00 5,000.00 97,515.95 9% $214,572 20% 15,715
$
337,187.49 30% $337,187 17,325.72 2,918.02 13,191.86 1,215.84 82,021.51 607.92 972.67 60,996.00 884.44 2,561.83 112.00 486.00 4,044.27 2,431.68 7,902.96 5,066.00 99,347.23 9% $237,840 21% 22,291.90
$
363,718.99 31% $363,719 17,554.42 2,956.53 13,366.00 1,231.89 84,119.96 615.94 1,099.12 62,215.92 902.13 2,613.07 112.00 486.00 4,097.66 2,463.78 7,902.96 5,724.58 101,674.38 9% $262,045 23% 12,035.63
$
391,615.81 32% $391,616 17,786.14 2,995.56 13,542.43 1,248.15 86,346.10 624.08 1,242.00 63,460.24 920.17 2,665.33 112.00 486.00 4,151.75 2,496.30 7,902.96 6,468.78 104,132.24 9% $287,484 24% 7,355.63
$
$ $
23,791.43 29% $312,088 1,425.00 240.00 1,085.00 100.00 6,256.57 50.00 80.00 4,600.00 66.70 193.20 259.90 200.00 650.00 416.67 7,681.57 9% $16,110 20% 1,330
420,941.36 33% $420,941 18,020.91 3,035.10 13,721.19 1,264.63 88,713.70 632.31 1,403.47 64,729.44 938.58 2,718.64 112.00 486.00 4,206.55 2,529.25 7,902.96 7,309.72 106,734.61 8% $314,207 25% 5,157.63
$21,751 21% 184,076.95 $
$14,780 18% 198,857.26
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$20,659 20% 82,561.37 $
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$14,106 17% 96,667.85 $
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$14,347 17% 111,014.45 $
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$21,751 $14,780 21% 18% 132,765.39 $ 147,545.70 $
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$14,780 18% 162,326.01 $
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$198,857 19%
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$215,548 19% $215,548
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$250,009 22% $250,009
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$280,128 23% $280,128
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
$ $
$309,049 24% $309,049
22 Income Tax Franchice Tax
$ $
4,203.04 229.18
Net Income (Loss) Accumulated Net Income % Key$Assumptions Exchange)Rate End)Exchange Average)Inflation)Mexico Inflation)end)Mexico Average)Inflation)USA Inflation)end)USA Rate: Interest)Rate)(MEX) Credit)Rate)(MEX) Interest)Rate)(USA) Interest)Credit)(USA) Ratios %)Cost)of)Goods)Sold %)Dep)(Furniture)&)Equipment))/F.A. %)Dep)(Machinery)&)Equipment))/)F.A. %)Dep)(Transport)Equipment)/F.A. %)Dep)(Electronic)Equipment)/F.A. %)Amortization)/)D.A. %)Expenses)Operative %)Administrative)Expenses Tax)Rate Day's)Cash/Sales Day's)Sales)in)Receivable Day's)Sales)in)Other)Receivable Day's)Sales)in)Inventory Day's)Cost)of)goods)sold/)Accounts)payable Day's)Cost)of)goods)sold)/Other)payable Day's)Other)current)Assets/Sales Day's)Other)current))Liabilities/Sales Staff
Loans: Short$Term Portion)of)LongYTerm)Debt Amortizations Increases Total LongDTerm Other)LongYTerm)M.N. Amortizations Increases total LongYTerm)USA Amortizations Increases total
$9,314 $9,314 11% Month$1
$ $
4,203.04 229.18 $9,314 $18,627 11%
Month$2
$ $
6,269.43 308.85 $13,926 $32,553 14%
Month$3
$ $
4,252.27 229.18 $9,425 $41,978 11%
Month$4
$ $
6,316.90 308.85 $14,033 $56,011 14%
Month$5
$ $
4,313.32 231.18
$ $
4,386.74 231.18
$9,562 $65,573 12% Month$6
$ $
6,650.76 319.77
$9,729 $75,302 12% Month$7
$14,780 $90,083 14% Month$8
$ $
4,519.36 $ 237.91 $ #VALUE! $10,023 $100,106 12%
Month$9
4,519.36 237.91 $10,023 $110,129 12%
Month$10
$ $
6,650.76 319.77 $14,780 $124,909 14%
Month$11
$ $
4,519.36 237.91
$ $
60,804.33 3,120.88
$10,023 $134,932 12% Month$12
$ $
67,313.86 3,371.87
$134,932 13% YEAR$1
$ $
80,753.50 3,637.19
$144,863 $279,795 13% YEAR$2
$ $
92,499.90 3,916.16
$165,618 $445,413 14% YEAR$3
$ $
103,779.16 4,209.41
$183,712 $629,125 15% YEAR$4
$201,061 $830,185 16% YEAR$5
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 0.003% 0.003% 0.001% 0.001%
13.50 13.50 3.48% 3.48% 1.32% 1.32%
13.50 13.50 3.83% 3.83% 1.32% 1.32%
13.50 13.50 3.83% 3.83% 1.32% 1.32%
13.50 13.50 3.83% 3.83% 1.32% 1.32%
13.50 13.50 3.83% 3.83% 1.32% 1.32%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
0.40% 1.08% 0.08% 0.38%
4.85% 13.00% 1.00% 4.50%
4.85% 13.00% 1.00% 4.50%
4.85% 13.00% 1.00% 4.50%
4.85% 13.00% 1.00% 4.50%
4.85% 13.00% 1.00% 4.50%
72% 1.19% 1.67% 1.67% 1.67% 0.42% 1.74% 7.82% 34.00% )))))))))))))))))))))))) 2 ))))))))))))))))))))) Y ))))))))))))))))))))) Y )))))))))))))))))))))))) 3 )))))))))))))))))))))))) 6 )))))))))))))))))))))))) 1 ))))))))))))))))))))) Y )))))))))))))))))))))))) 1 22
72% 1.19% 1.67% 1.67% 1.67% 0.42% 1.74% 7.82% 34.00% )))))))))))))))))))))) 2 ))))))))))))))))))) Y ))))))))))))))))))) Y )))))))))))))))))))))) 3 )))))))))))))))))))))) 6 )))))))))))))))))))))) 1 ))))))))))))))))))) Y )))))))))))))))))))))) 1 22
70% 1.19% 1.67% 1.67% 1.67% 0.42% 1.39% 7.43% 34.00% )))))))))))))))))))))) 2 ))))))))))))))))))) Y ))))))))))))))))))) Y )))))))))))))))))))))) 3 )))))))))))))))))))))) 6 )))))))))))))))))))))) 1 ))))))))))))))))))) Y )))))))))))))))))))))) 1 22
72% 1.19% 1.67% 1.67% 1.67% 0.42% 1.74% 7.62% 34.00% )))))))))))))))))))))) 2 ))))))))))))))))))) Y ))))))))))))))))))) Y )))))))))))))))))))))) 3 )))))))))))))))))))))) 6 )))))))))))))))))))))) 1 ))))))))))))))))))) Y )))))))))))))))))))))) 1 22
70% 1.19% 1.67% 1.67% 1.67% 0.42% 1.39% 7.28% 34.00% ))))))))))))))))))))))) 2 )))))))))))))))))))) Y )))))))))))))))))))) Y ))))))))))))))))))))))) 3 ))))))))))))))))))))))) 6 ))))))))))))))))))))))) 1 )))))))))))))))))))) Y ))))))))))))))))))))))) 1 22
72% 1.19% 1.67% 1.67% 1.67% 0.42% 1.74% 7.62% 34.00% ))))))))))))))))))))))) 2 )))))))))))))))))))) Y )))))))))))))))))))) Y ))))))))))))))))))))))) 3 ))))))))))))))))))))))) 6 ))))))))))))))))))))))) 1 )))))))))))))))))))) Y ))))))))))))))))))))))) 1 22
72% 1.19% 1.67% 1.67% 1.67% 0.42% 1.74% 7.62% 34.00% )))))))))))))))))))))))))) 2 ))))))))))))))))))))))) Y ))))))))))))))))))))))) Y )))))))))))))))))))))))))) 3 )))))))))))))))))))))))))) 6 )))))))))))))))))))))))))) 1 ))))))))))))))))))))))) Y )))))))))))))))))))))))))) 1 22
69% 1.19% 1.67% 1.67% 1.67% 0.42% 1.39% 7.28% 34.00% ))))))))))))))))))))))))) 2 )))))))))))))))))))))) Y )))))))))))))))))))))) Y ))))))))))))))))))))))))) 3 ))))))))))))))))))))))))) 6 ))))))))))))))))))))))))) 1 )))))))))))))))))))))) Y ))))))))))))))))))))))))) 1 22
71% 1.19% 1.67% 1.67% 1.67% 0.42% 1.74% 7.62% 34.00% )))))))))))))))))))))))) 2 ))))))))))))))))))))) Y ))))))))))))))))))))) Y )))))))))))))))))))))))) 3 )))))))))))))))))))))))) 6 )))))))))))))))))))))))) 1 ))))))))))))))))))))) Y )))))))))))))))))))))))) 1 22
71% 1.19% 1.67% 1.67% 1.67% 0.42% 1.74% 7.62% 34.00% )))))))))))))))))))))))))) 2 ))))))))))))))))))))))) Y ))))))))))))))))))))))) Y )))))))))))))))))))))))))) 3 )))))))))))))))))))))))))) 6 )))))))))))))))))))))))))) 1 ))))))))))))))))))))))) Y )))))))))))))))))))))))))) 1 22
69% 1.19% 1.67% 1.67% 1.67% 0.42% 1.39% 7.28% 34.00% ))))))))))))))))))))))))) 2 )))))))))))))))))))))) Y )))))))))))))))))))))) Y ))))))))))))))))))))))))) 3 ))))))))))))))))))))))))) 6 ))))))))))))))))))))))))) 1 )))))))))))))))))))))) Y ))))))))))))))))))))))))) 1 22
71% 1.19% 1.67% 1.67% 1.67% 0.42% 1.74% 7.62% 34.00% ))))))))))))))))))))))))) 2 )))))))))))))))))))))) Y )))))))))))))))))))))) Y ))))))))))))))))))))))))) 3 ))))))))))))))))))))))))) 6 ))))))))))))))))))))))))) 1 )))))))))))))))))))))) Y ))))))))))))))))))))))))) 1 22
71% 14.29% 20.00% 20.00% 20.00% 5.00% 1.60% 7.53% 34.00% )))))))))))))))))))))))))))))) 2 ))))))))))))))))))))))))))) Y ))))))))))))))))))))))))))) Y )))))))))))))))))))))))))))))) 3 )))))))))))))))))))))))))))))) 6 )))))))))))))))))))))))))))))) 1 ))))))))))))))))))))))))))) Y )))))))))))))))))))))))))))))) 1 22
70% 24.49% 32.00% 32.00% 32.00% 5.00% 1.56% 7.36% 34.00% ))))))))))))))))))))))))))))))) 2 )))))))))))))))))))))))))))) Y )))))))))))))))))))))))))))) Y ))))))))))))))))))))))))))))))) 3 ))))))))))))))))))))))))))))))) 6 ))))))))))))))))))))))))))))))) 1 )))))))))))))))))))))))))))) Y ))))))))))))))))))))))))))))))) 1 22
69% 17.49% 19.20% 19.20% 19.20% 5.00% 1.51% 7.24% 34.00% ))))))))))))))))))))))))))))))) 2 )))))))))))))))))))))))))))) Y )))))))))))))))))))))))))))) Y ))))))))))))))))))))))))))))))) 3 ))))))))))))))))))))))))))))))) 6 ))))))))))))))))))))))))))))))) 1 )))))))))))))))))))))))))))) Y ))))))))))))))))))))))))))))))) 1 22
68% 12.49% 11.52% 11.52% 11.52% 5.00% 1.47% 7.12% 34.00% )))))))))))))))))))))))))))))))) 2 ))))))))))))))))))))))))))))) Y ))))))))))))))))))))))))))))) Y )))))))))))))))))))))))))))))))) 3 )))))))))))))))))))))))))))))))) 6 )))))))))))))))))))))))))))))))) 1 ))))))))))))))))))))))))))))) Y )))))))))))))))))))))))))))))))) 1 22
67% 8.93% 11.52% 11.52% 11.52% 5.00% 1.42% 7.01% 34.00% ))))))))))))))))))))))))))))))) 2 )))))))))))))))))))))))))))) Y )))))))))))))))))))))))))))) Y ))))))))))))))))))))))))))))))) 3 ))))))))))))))))))))))))))))))) 6 ))))))))))))))))))))))))))))))) 1 )))))))))))))))))))))))))))) Y ))))))))))))))))))))))))))))))) 1 22
Month$1
Month$2
Month$3
Month$4
Month$5
Month$6
Month$7
Month$8
Month$9
Month$10
Month$11
Month$12
YEAR 1
YEAR 2
YEAR 3
YEAR 4
YEAR 5
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
158,419 0 0 158,419
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
LongDTerm LongYTerm)M.N Long)Term)USA Short$Term ShortY)Term)Banks)Loans Other)Accounts)Payable Portion)of)LongYTerm)Debt Total)Financial)Payments Month$1
Month$2
Month$3
Month$4
Month$5
Month$6
Month$7
Month$8
Month$9
Month$10
Month$11
Month$12
YEAR$1
YEAR$2
YEAR$3
YEAR$4
YEAR$5
Historical$Cost$of$Land Purchase Sales Total)Historial)Cost Revaluation)Annual Revaluation)Accumulated Net)Value)of)the)Land
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
Historical$Cost$of$Machinery$and$Equipment Purchase Sales Total)Historial)Cost Monthly)Depreciation Accumulated)Depreciation Net)Value)of)Machinery
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 82,363 0 82,363 981 981 81,383
82,363 0 0 82,363 981 1,962 80,402
82,363 0 0 82,363 981 2,942 79,421
82,363 0 0 82,363 981 3,923 78,440
82,363 0 0 82,363 981 4,904 77,459
82,363 0 0 82,363 981 5,885 76,479
82,363 0 0 82,363 981 6,866 75,498
82,363 0 0 82,363 981 7,846 74,517
82,363 0 0 82,363 981 8,827 73,536
82,363 0 0 82,363 981 9,808 72,555
82,363 0 0 82,363 981 10,789 71,575
82,363 0 0 82,363 981 11,770 70,594
0 82,363 0 82,363 11,770 11,770 70,594
70,594 0 0 70,594 17,288 17,288 53,305
53,305 0 0 53,305 9,323 9,323 43,982
43,982 0 0 43,982 5,493 5,493 38,489
38,489 0 0 38,489 3,437 3,437 35,052
0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
Historical$Cost$of$Furniture$and$Equipment Purchase Sales Total)Historial)Cost Monthly)Depreciation Accumulated)Depreciation Net)Value)of)Furniture Historical$Cost$of$Transport$Equipment Purchase
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
23 Sales Total*Historial*Cost Monthly*Depreciation Accumulated*Depreciation Net*Value*of*Transport
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Historical*Cost*of*Electronic*Equipment Purchase Sales Total*Historial*Cost Monthly*Depreciation Accumulated*Depreciation Net*Value*of*electronic
0 14,408 0 14,408 240 240 14,168
14,408 0 0 14,408 240 480 13,928
14,408 0 0 14,408 240 720 13,688
14,408 0 0 14,408 240 961 13,447
14,408 0 0 14,408 240 1,201 13,207
14,408 0 0 14,408 240 1,441 12,967
14,408 0 0 14,408 0 1,441 12,967
14,408 0 0 14,408 240 1,681 12,727
14,408 0 0 14,408 240 1,921 12,487
14,408 0 0 14,408 240 2,161 12,247
14,408 0 0 14,408 240 2,401 12,007
14,408 0 0 14,408 240 2,641 11,767
0 14,408 0 14,408 2,641 2,641 11,767
11,767 0 0 11,767 3,765 3,765 8,001
8,001 0 0 8,001 1,536 1,536 6,465
6,465 0 0 6,465 745 745 5,720
5,720 0 0 5,720 659 659 5,061
Historical*Deferred*Assets Purchase Sales Total*Historial*Cost Monthly*Depreciation Accumulated*Depreciation Net*Value*Deferred
0 26,067 0 26,067 109 109 25,959
26,067 0 0 26,067 109 217 25,850
26,067 0 0 26,067 109 326 25,742
26,067 0 0 26,067 109 434 25,633
26,067 0 0 26,067 109 543 25,524
26,067 0 0 26,067 109 652 25,416
26,067 0 0 26,067 109 760 25,307
26,067 0 0 26,067 109 869 25,199
26,067 0 0 26,067 109 978 25,090
26,067 0 0 26,067 109 1,086 24,981
26,067 0 0 26,067 109 1,195 24,873
26,067 0 0 26,067 109 1,303 24,764
0 26,067 0 26,067 1,303 1,303 24,764
24,764 0 0 24,764 1,238 1,238 23,526
23,526 0 0 23,526 1,176 1,176 22,350
22,350 0 0 22,350 1,117 1,117 21,232
21,232 0 0 21,232 1,062 1,062 20,170
Working*Capital Cash*and*Equivalents Accounts*Receivable Other*Accounts*Receivable Inventory Other*Current*Assets Total*Assets
Month*1 5,401 0 0 5,840 0 11,241
Month*2 5,401 0 0 5,840 0 11,241
Month*3 6,751 0 0 7,079 0 13,830
Month*4 5,401 0 0 5,840 0 11,241
Month*5 6,751 0 0 7,079 0 13,830
Month*6 5,401 0 0 5,820 0 11,221
Month*7 5,401 0 0 5,820 0 11,221
Month*8 6,751 0 0 6,971 0 13,723
Month*9 5,401 0 0 5,754 0 11,155
Month*10 5,401 0 0 5,754 0 11,155
Month*11 6,751 0 0 6,971 0 13,723
Month*12 5,401 0 0 5,754 0 11,155
Accounts*Payable Other*Accounts*payable Other*Current*Liabilities Total*Liabilities
11,680 1,947 2,701 16,327 *
Working*Capital
11,680 1,947 2,701 16,327 *
(5,086)
14,158 2,360 3,376 19,894 *
(5,086)
11,680 1,947 2,701 16,327 *
(6,063)
14,158 2,360 3,376 19,894 *
(5,086)
11,641 1,940 2,701 16,281 *
(6,063)
11,641 1,940 2,701 16,281 *
(5,060)
13,943 2,324 3,376 19,642 *
(5,060)
11,508 1,918 2,701 16,126 *
(5,919)
11,508 1,918 2,701 16,126 *
(4,971)
13,943 2,324 3,376 19,642 *
(4,971)
YEAR*1
11,508 1,918 2,701 16,126 *
YEAR*2
5,401 0 0 5,754 0 11,155 ********************** 11,508 ************************ 1,918 ************************ 2,701 16,126 *
(5,919)
YEAR*3
6,106 0 0 6,383 0 12,489 *********************** 12,773 ************************* 2,129 ************************* 3,053 17,955 *
(4,971)
YEAR*4
6,372 0 0 6,564 0 12,936 *********************** 13,135 ************************* 2,189 ************************* 3,186 18,511 *
(4,971)
YEAR*5 6,650 0 0 6,751 0 13,401
*********************** 13,510 ************************* 2,252 ************************* 3,325 19,087 *
(5,466)
6,940 0 0 6,945 0 13,885 *********************** 13,897 ************************* 2,316 ************************* 3,470 19,683 *
(5,574)
(5,685)
(5,799)
Month*1
Month*2
Month*3
Month*4
Month*5
Month*6
Month*7
Month*8
Month*9
Month*10
Month*11
Month*12
YEAR*1
YEAR*2
YEAR*3
YEAR*4
YEAR*5
$**************** 5,401 $************** 51,309 $******************** V $******************** V $**************** 5,840 $******************** V $******************** V $************** 62,550
$************** 5,401 $************ 61,952 $****************** V $****************** V $************** 5,840 $****************** V $****************** V $************ 73,193
$************** 6,751 $************ 78,184 $****************** V $****************** V $************** 7,079 $****************** V $****************** V $************ 92,015
$************** 5,401 $************ 87,962 $****************** V $****************** V $************** 5,840 $****************** V $****************** V $************ 99,203
$************** 6,751 $***********104,302 $****************** V $****************** V $************** 7,079 $****************** V $****************** V $***********118,133
$************** 5,401 $***********114,190 $****************** V $****************** V $************** 5,820 $****************** V $****************** V $***********125,412
$***************** 5,401 $************** 125,008 $********************* V $********************* V $***************** 5,820 $********************* V $********************* V $************** 136,230
$**************** 6,751 $************* 141,978 $******************** V $******************** V $**************** 6,971 $******************** V $******************** V $************* 155,701
$**************** 5,401 $************ 152,382 $******************** V $******************** V $**************** 5,754 $******************** V $******************** V $************ 163,537
$***************** 5,401 $************** 163,735 $********************* V $********************* V $***************** 5,754 $********************* V $********************* V $************** 174,890
$***************** 6,751 $************* 180,793 $******************** V $******************** V $***************** 6,971 $******************** V $******************** V $************* 194,516
$***************** 5,401 $************* 191,198 $******************** V $******************** V $***************** 5,754 $******************** V $******************** V $************* 202,352
$********************** 5,401 $****************** 191,198 $************************* V $************************* V $********************** 5,754 $************************* V $************************* V $****************** 202,352
$*********************** 6,106 $******************* 358,847 $*************************** V $*************************** V $*********************** 6,383 $*************************** V $*************************** V $******************* 371,336
$*********************** 6,372 $******************* 536,609 $*************************** V $*************************** V $*********************** 6,564 $*************************** V $*************************** V $******************* 549,545
$*********************** 6,650 $******************** 727,787 $*************************** V $*************************** V $*********************** 6,751 $*************************** V $*************************** V $******************** 741,189
$*********************** 6,940 $******************* 934,119 $************************** V $************************** V $*********************** 6,945 $************************** V $************************** V $******************* 948,004
Machinery*&*Equipment Furniture*&*Equipment Land Transport*&*Equipment Electronic*&*Equipment Net*Fixed*Assets Deferred*Assets Total*Assests Current*Liabilities: Accounts*Payable ShortV*Term*Banks*Loans Other*Current*Liabilities Portion*of*LongV*Term*Debt* Accrued*Expenses Accrued*Tax Other*Current*Liabilities Total*Current*Liabilities
$******************** V $************** 81,383 $******************** V $******************** V $************** 14,168 $************** 95,551 $************** 25,959 $************ 184,059
$****************** V $************ 80,402 $****************** V $****************** V $************ 13,928 $************ 94,330 $************ 25,850 $********** 193,373
$****************** V $************ 79,421 $****************** V $****************** V $************ 13,688 $************ 93,109 $************ 25,742 $********** 210,865
$****************** V $************ 78,440 $****************** V $****************** V $************ 13,447 $************ 91,888 $************ 25,633 $********** 216,724
$****************** V $*************77,459 $****************** V $****************** V $*************13,207 $*************90,667 $*************25,524 $***********234,324
$****************** V $*************76,479 $****************** V $****************** V $*************12,967 $*************89,446 $*************25,416 $***********240,273
$********************* V $**************** 75,498 $********************* V $********************* V $**************** 12,967 $**************** 88,465 $**************** 25,307 $************** 250,002
$******************** V $*************** 74,517 $******************** V $******************** V $*************** 12,727 $*************** 87,244 $*************** 25,199 $************* 268,143
$******************** V $************** 73,536 $******************** V $******************** V $************** 12,487 $************** 86,023 $************** 25,090 $************ 274,650
$********************* V $**************** 72,555 $********************* V $********************* V $**************** 12,247 $**************** 84,802 $**************** 24,981 $************** 284,673
$******************** V $*************** 71,575 $******************** V $******************** V $*************** 12,007 $*************** 83,581 $*************** 24,873 $************* 302,970
$******************** V $*************** 70,594 $******************** V $******************** V $*************** 11,767 $*************** 82,360 $*************** 24,764 $************* 309,477
$************************* V $******************** 70,594 $************************* V $************************* V $******************** 11,767 $******************** 82,360 $******************** 24,764 $****************** 309,477
$*************************** V $********************* 53,305 $*************************** V $*************************** V $*********************** 8,001 $********************* 61,307 $********************* 23,526 $******************* 456,168
$*************************** V $********************* 43,982 $*************************** V $*************************** V $*********************** 6,465 $********************* 50,447 $********************* 22,350 $******************* 622,342
$*************************** V $********************** 38,489 $*************************** V $*************************** V $*********************** 5,720 $********************** 44,209 $********************** 21,232 $******************** 806,630
$************************** V $********************* 35,052 $************************** V $************************** V $*********************** 5,061 $********************* 40,113 $********************* 20,170 $**************** 1,008,288
$************** 11,680 $******************** V $**************** 1,947 $************ 158,419 $******************** V $******************** V $**************** 2,701 $************ 174,746
$************ 11,680 $****************** V $************** 1,947 $********** 158,419 $****************** V $****************** V $************** 2,701 $********** 174,746
$************ 14,158 $****************** V $************** 2,360 $********** 158,419 $****************** V $****************** V $************** 3,376 $********** 178,312
$************ 11,680 $****************** V $************** 1,947 $********** 158,419 $****************** V $****************** V $************** 2,701 $********** 174,746
$*************14,158 $****************** V $************** 2,360 $***********158,419 $****************** V $****************** V $************** 3,376 $***********178,312
$*************11,641 $****************** V $************** 1,940 $***********158,419 $****************** V $****************** V $************** 2,701 $***********174,700
$**************** 11,641 $********************* V $***************** 1,940 $************** 158,419 $********************* V $********************* V $***************** 2,701 $************** 174,700
$*************** 13,943 $******************** V $**************** 2,324 $************* 158,419 $******************** V $******************** V $**************** 3,376 $************* 178,061
$************** 11,508 $******************** V $**************** 1,918 $************ 158,419 $******************** V $******************** V $**************** 2,701 $************ 174,545
$**************** 11,508 $********************* V $***************** 1,918 $************** 158,419 $********************* V $********************* V $***************** 2,701 $************** 174,545
$*************** 13,943 $******************** V $***************** 2,324 $************* 158,419 $******************** V $******************** V $***************** 3,376 $************* 178,061
$*************** 11,508 $******************** V $***************** 1,918 $************* 158,419 $******************** V $******************** V $***************** 2,701 $************* 174,545
$******************** 11,508 $************************* V $********************** 1,918 $****************** 158,419 $************************* V $************************* V $********************** 2,701 $****************** 174,545
$********************* 12,773 $*************************** V $*********************** 2,129 $******************* 158,419 $*************************** V $*************************** V $*********************** 3,053 $******************* 176,373
$********************* 13,135 $*************************** V $*********************** 2,189 $******************* 158,419 $*************************** V $*************************** V $*********************** 3,186 $******************* 176,929
$********************** 13,510 $*************************** V $*********************** 2,252 $******************** 158,419 $*************************** V $*************************** V $*********************** 3,325 $******************** 177,505
$********************* 13,897 $************************** V $*********************** 2,316 $******************* 158,419 $************************** V $************************** V $*********************** 3,470 $******************* 178,102
LongVTerm*Debt*USA LongVTerm*Debt*M.N. Total*LongVTerm*Debt Total*Liabilities
$******************** V $******************** V $******************** V $************ 174,746
$****************** V $****************** V $****************** V $********** 174,746
$****************** V $****************** V $****************** V $********** 178,312
$****************** V $****************** V $****************** V $********** 174,746
$****************** V $****************** V $****************** V $***********178,312
$****************** V $****************** V $****************** V $***********174,700
$********************* V $********************* V $********************* V $************** 174,700
$******************** V $******************** V $******************** V $************* 178,061
$******************** V $******************** V $******************** V $************ 174,545
$********************* V $********************* V $********************* V $************** 174,545
$******************** V $******************** V $******************** V $************* 178,061
$******************** V $******************** V $******************** V $************* 174,545
$************************* V $************************* V $************************* V $****************** 174,545
$*************************** V $*************************** V $*************************** V $******************* 176,373
$*************************** V $*************************** V $*************************** V $******************* 176,929
$*************************** V $*************************** V $*************************** V $******************** 177,505
$************************** V $************************** V $************************** V $******************* 178,102
Common*Stock Additional*PaidV*In*Capital Retained*Earnings Earnings Revaluation Total*Equity
$******************** V $******************** V $******************** V $**************** 9,314 $******************** V $**************** 9,314
$****************** V $****************** V $************** 9,314 $************** 9,314 $****************** V $************ 18,627
$****************** V $****************** V $************ 18,627 $************ 13,926 $****************** V $************ 32,553
$****************** V $****************** V $************ 32,553 $************** 9,425 $****************** V $************ 41,978
$****************** V $****************** V $*************41,978 $*************14,033 $****************** V $*************56,011
$****************** V $****************** V $*************56,011 $************** 9,562 $****************** V $*************65,573
$********************* V $********************* V $**************** 65,573 $***************** 9,729 $********************* V $**************** 75,302
$******************** V $******************** V $*************** 75,302 $*************** 14,780 $******************** V $*************** 90,083
$******************** V $******************** V $************** 90,083 $************** 10,023 $******************** V $************ 100,106
$********************* V $********************* V $************** 100,106 $**************** 10,023 $********************* V $************** 110,129
$******************** V $******************** V $************* 110,129 $*************** 14,780 $******************** V $************* 124,909
$******************** V $******************** V $************* 124,909 $*************** 10,023 $******************** V $************* 134,932
$************************* V $************************* V $************************* V $****************** 134,932 $************************* V $****************** 134,932
$*************************** V $*************************** V $******************* 134,932 $******************* 144,863 $*************************** V $******************* 279,795
$*************************** V $*************************** V $******************* 279,795 $******************* 165,618 $*************************** V $******************* 445,413
$*************************** V $*************************** V $******************** 445,413 $******************** 183,712 $*************************** V $******************** 629,125
$************************** V $************************** V $******************* 629,125 $******************* 201,061 $************************** V $******************* 830,185
Total*Liabilities*and*Shareholders'*Equity NO*MATCH
$************ 184,059 $******************** V
$********** 193,373 $****************** V
$********** 210,865 $****************** V
$********** 216,724 $****************** V
$***********234,324 $****************** V
$***********240,273 $****************** V
$************** 250,002 $********************* V
$************* 268,143 $******************** V
$************ 274,650 $******************** V
$************** 284,673 $********************* V
$************* 302,970 $******************** V
$************* 309,477 $******************** V
$****************** 309,477 $************************* V
$******************* 456,168 $*************************** V
$******************* 622,342 $*************************** V
$******************** 806,630 $*************************** V
$**************** 1,008,288 $************************** V
Month*1
Month*2
Month*3
Month*4
Month*5
Month*6
Month*7
Month*8
Month*9
Month*10
Month*11
Month*12
YEAR*1
YEAR*2
YEAR*3
YEAR*4
YEAR*5
Cash*Flow*From*Operating*Activities: Net*Income Depreciation*and*Amortization Income*charges*not*affecting*cash Cash*provided*by*Operating*Activities
$**************** 9,314 $**************** 1,330 $******************** V $************** 10,643
$************** 9,314 $************** 1,330 $****************** V $************ 10,643
$************ 13,926 $************** 1,330 $****************** V $************ 15,255
$************** 9,425 $************** 1,330 $****************** V $************ 10,755
$*************14,033 $************** 1,330 $****************** V $*************15,363
$************** 9,562 $************** 1,330 $****************** V $*************10,892
$***************** 9,729 $***************** 1,089 $********************* V $**************** 10,818
$*************** 14,780 $**************** 1,330 $******************** V $*************** 16,110
$************** 10,023 $**************** 1,330 $******************** V $************** 11,353
$**************** 10,023 $***************** 1,330 $********************* V $**************** 11,353
$*************** 14,780 $***************** 1,330 $******************** V $*************** 16,110
$*************** 10,023 $***************** 1,330 $******************** V $*************** 11,353
$****************** 134,932 $******************** 15,715 $************************* V $****************** 150,647
$******************* 144,863 $********************* 22,292 $*************************** V $******************* 167,155
$******************* 165,618 $********************* 12,036 $*************************** V $******************* 177,654
$******************** 183,712 $*********************** 7,356 $*************************** V $******************** 191,068
$******************* 201,061 $*********************** 5,158 $************************** V $******************* 206,218
*V(+)*Changes*in**certain*Working*Capital
$*************** (5,086) $****************** V
$**************** (977) $***************** 977
$**************** (977) $************** 1,003
$********************* V
$****************** (860) $******************* 948
$********************* V
$****************** (948) $******************* 948
$********************* (4,971) $************************* (494) $************************* (108) $************************* (111) $************************ (113)
Net*Cash*provided*by*Operating*Activities
$************** 15,729
$************ 10,643
$************ 16,232
$************** 9,778
$*************16,340
$************** 9,888
$**************** 10,818
$*************** 16,970
$************** 10,404
$**************** 11,353
$*************** 17,058
$*************** 10,404
$****************** 155,618
$******************* 167,649
$******************* 177,762
$******************** 191,178
$******************* 206,332
(+)*Cash*Provided*(Used)*by*Investing*Activities: Additional*PaidV*In*Capital
$******************** V
$****************** V
$****************** V
$****************** V
$****************** V
$****************** V
$********************* V
$******************** V
$******************** V
$********************* V
$******************** V
$******************** V
$************************* V
$*************************** V
$*************************** V
$*************************** V
$************************** V
Current*Assets: Cash*and*Equivalents ShortVTerm*Investment Accounts*Receivable Other*Accounts*Receivable Inventory Prepaid*and*Deferred Other*Current*Assets Total*Current*Assets
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
24 Increase(Long,term(debt(current Increase(Long,term(debt( Extraordinary(Sources Sale(of(Fixed(Assets Total(Cash(used(by(investing(activities
$(((((((((((( 158,419 $(((((((((((((((((((( , $(((((((((((((((((((( , $(((((((((((((((((((( , $(((((((((((( 158,419
$(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( ,
$(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( ,
$(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( ,
$(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $((((((((((((((((((
, , , , ,
$(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $((((((((((((((((((
, , , , ,
$((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $(((((((((((((((((((((
, , , , ,
$(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $((((((((((((((((((((
, , , , ,
$(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $((((((((((((((((((((
, , , , ,
$((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $(((((((((((((((((((((
, , , , ,
$(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $((((((((((((((((((((
, , , , ,
$(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $((((((((((((((((((((
, , , , ,
$(((((((((((((((((( 158,419 $((((((((((((((((((((((((( , $((((((((((((((((((((((((( , $((((((((((((((((((((((((( , $(((((((((((((((((( 158,419
$((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $(((((((((((((((((((((((((((
, , , , ,
$((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $(((((((((((((((((((((((((((
, , , , ,
$((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $(((((((((((((((((((((((((((
, , , , ,
$(((((((((((((((((((((((((( $(((((((((((((((((((((((((( $(((((((((((((((((((((((((( $(((((((((((((((((((((((((( $((((((((((((((((((((((((((
, , , , ,
(")$Cash$Provided$(Used)$by$Financing$Activities: Dividends Reduction(in(Long,Term(current(portion Reduction(in(Long,Term(Debt Extraordinary(Expenses Purchase(of(Fixed(Assets Total(Cash(used(by(Financing(Activities
$(((((((((((((((((((( , $(((((((((((((((((((( , $(((((((((((((((((((( , $(((((((((((((((((((( , $(((((((((((( 122,839 $(((((((((((( 122,839
$(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( ,
$(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( ,
$(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( , $(((((((((((((((((( ,
$(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $((((((((((((((((((
, , , , , ,
$(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $(((((((((((((((((( $((((((((((((((((((
, , , , , ,
$((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $(((((((((((((((((((((
, , , , , ,
$(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $((((((((((((((((((((
, , , , , ,
$(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $((((((((((((((((((((
, , , , , ,
$((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $((((((((((((((((((((( $(((((((((((((((((((((
, , , , , ,
$(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $((((((((((((((((((((
, , , , , ,
$(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $(((((((((((((((((((( $((((((((((((((((((((
, , , , , ,
$((((((((((((((((((((((((( , $((((((((((((((((((((((((( , $((((((((((((((((((((((((( , $((((((((((((((((((((((((( , $(((((((((((((((((( 122,839 $(((((((((((((((((( 122,839
$((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $(((((((((((((((((((((((((((
, , , , , ,
$((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $(((((((((((((((((((((((((((
, , , , , ,
$((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $((((((((((((((((((((((((((( $(((((((((((((((((((((((((((
, , , , , ,
$(((((((((((((((((((((((((( $(((((((((((((((((((((((((( $(((((((((((((((((((((((((( $(((((((((((((((((((((((((( $(((((((((((((((((((((((((( $((((((((((((((((((((((((((
, , , , , ,
Cash(and(Equivalents,(Beginning(of(year Cash(and(Equivalents,(end(of(year
$(((((((((((((( 51,309 $(((((((((((((( 51,309
$(((((((((((( 10,643 $(((((((((((( 61,952
$(((((((((((( 16,232 $(((((((((((( 78,184
$(((((((((((((( 9,778 $(((((((((((( 87,962
$(((((((((((((16,340 $(((((((((((104,302
$(((((((((((((((((( 191,198 $(((((((((((((((((( 191,198
$((((((((((((((((((( 167,649 $((((((((((((((((((( 358,847
$(((((((((((((( 9,888 $(((((((((((114,190
$(((((((((((((((( 10,818 $(((((((((((((( 125,008
$((((((((((((((( 16,970 $((((((((((((( 141,978
$(((((((((((((( 10,404 $(((((((((((( 152,382
$(((((((((((((((( 11,353 $(((((((((((((( 163,735
$((((((((((((((( 17,058 $((((((((((((( 180,793
$((((((((((((((( 10,404 $((((((((((((( 191,198
LAREDO CONSULTING GROUP BUSINESS PLAN-‐EXAMPLE, LLC. 2012
$((((((((((((((((((( 177,762 $((((((((((((((((((( 536,609
$(((((((((((((((((((( 191,178 $(((((((((((((((((((( 727,787
$((((((((((((((((((( 206,332 $((((((((((((((((((( 934,119