Business Plan Sample.docx

Executive summary Kabul Minicab is an Afghan Owned company based in Kabul capital of Afghanistan, whose mission is to provide reliable, timely, and safe taxi services. Kabul Minicab will provide complete taxi cab services using the latest equipment and technology to facilitate the travel of individuals in and around the Kabul area. The company's products and services show that we are an innovative, forward thinking company that recognizes the need to move with ever-changing customer needs. At Kabul Minicab, our philosophy is one that emphasizes service, and a realization that effective communication is a key component in our business. The company also realizes that, in a competitive environment, flexibility and professionalism maintain that leading edge. The company has drivers and employees that are helpful, courteous, and fully trained on the use of the computer dispatch system. As an added safety measure for both drivers and passengers, Kabul Minicab are fitted with Global Positioning Systems (GPS), which enable the cabs to be tracked or located in an emergency. All Kabul Minicab`s cars will be cleaned, well maintained, and inspected regularly for safety and comfort. Companies with whom Kabul Minicab competes are Kabul cab, Afghan Turk, Saber Bus , and Life Star. Their weaknesses are that they do not have the credit/debit card payment option, and some still use the radio dispatch system. The company has a competitive advantage, however, because our technology is unique to the taxi industry in Kabul. The GPS will enable the company to provide timely service by giving an accurate estimated time of arrival (ETA). The credit/debit card feature will give customers convenience and privacy during the transaction period. One of the other weakness that the above companies have is that Afghan Turk is only transporting foreign visitors, they are not available for the locals.

1

Table of Contents Topic

Page Number

Group Members ............................................................................................................... 1 Declaration Form ............................................................................................................. 2 Executive Summary ......................................................................................................... 3 Table of Contents ............................................................................................................. 4 Introduction .....................................................................................................................

6

1.0

Mission Statement ...............................................................................................

6

1.1

Objectives ............................................................................................................. 6

2.0

Feasibility Study ..................................................................................................

6

2.1

Company Strategy .................................................................................................

8

3.0

Technology ..........................................................................................................

8

3.1

GPI System ............................................................................................................ 8

3.2

Radio System ......................................................................................................... 8

4.0

Marketing Strategy .............................................................................................

4.1

Marketing Program ................................................................................................ 9

8

4.1.1 Trade Shows ........................................................................................................... 9 4.1.2 Advertisement Programs ........................................................................................ 9 4.2

Target Market.......................................................................................................... 10

4.3

Promotion Plan ...................................................................................................... 10

5.0

Human Resources ................................................................................................ 10

6.0

Findings and Analysis .......................................................................................... 12

6.1

Interpretation and Explanation of Regression Line .............................................. 21

7.0

Financial Plan ...................................................................................................... 23

7.1

Important Assumptions ......................................................................................... 23

7.2

Sensitivity Analysis ............................................................................................... 23 2

7.3

Key Financial Indicators ........................................................................................ 23

7.4

Investment ............................................................................................................... 24

7.5

Sales Forecast .......................................................................................................... 26

7.5.1 Pricing ..................................................................................................................... 27 7.5.2

Direct Cost of Sales ................................................................................................ 27

7.6

Profit and Loss Statement ........................................................................................ 28

7.7

Cash flow Analysis .................................................................................................. 29

7.8

Balance Sheet ........................................................................................................... 30

7.9

Ratio Analysis ......................................................................................................... 31

Conclusion .......................................................................................................................... 32 References .......................................................................................................................... 33 Appendixes ......................................................................................................................... 34 Questionnaire Design ........................................................................................................ 46 Questionnaire .................................................................................................................... 47

3

Introduction Transportation system in Afghanistan does not exists, since the last 3 decade no source governmental or private sector have focused on in transport sector and this is one of the major problem of people living in capital and provinces. Lack of transport system and trusted taxies has created a chance for robbery, kidnaps, killings and injuries. An organized and managed transportation system plays a vital role in a country. There hasn't been much investment in the small transport. If we look over the last 30 years the taxi and public transport hasn't changed, it is still operating in the traditional way. Kabul Minicab will introduce modern and easy ways of public transport. People will not be standing on roads any more, taxi will arrive at your place with a few buttons to push.

1. Mission Statement Kabul Minicab's mission statement is to provide reliable, timely and safe taxi services to all our target customers in the country with ecologically friendly and environmentally safe automobiles.

1.1 Objectives The company's objective for the coming 6 months is to pursue aggressive marketing in order to cover the residents of Shahre Now, Wazir Akbar khan Macroryan 1,2,3,4 and Hamid Karzai International Airport passengers. Looking over to the feedback we receive will extend our services to the other locations of Kabul city and main cities of the country, which will be the goal for the 3rd and 4th quarter. Fundamental components of Kabul Minicab initial strategy can be summarized as follows. Establish Relationship with Ministry of Transport and Civil Aviation. The company is currently working to establish and develop a working relationship with MoTCA. This will enable Kabul Minicab to look into the many services that they offer including, but not limited to: 

Supervisory



Call center and customer service efficiency



Management consulting

4



Skill consulting



Product management



Continuous improvement

2. Feasibility analysis: Transportation is coming under first need, unfortunately Afghanistan is lacking an organized transportation system and in the past 14 years there hasn't been any basic plan or strategy for public pick & drop. Afghanistan is a mountainous country with having less/limited flat land for living; many cities are built or located between hills and mountains, especially Kabul. That is why we see a very good opportunity for launching this business (Kabul Minicab a it will not only help Afghans with their pick & drop inside the city 24/7 but will also have a competitive pricing policy. At the moment there are only four private transport companies, Life star which carries the big and mini busses for public transport from different locations and available mostly in capital of Kabul, 2nd is Kabul cab, 3rdAfghan Turk which is only providing transport and pick and drop facility for foreigners and4th is Saber Bus. I can keep writing the weakness and problems but I’ll take this chance to write and give you detail on benefits, positive points and needs of Kabul Minicab. Kabul Minicab aims at the moment to cover the residents of Macroryan 1, 2, 3, 4; Wazir Akbar Khan, Share Now and Shahrak Aria pick & drop to Airport on call 24/7. The available resources limit us to provide service for the mentioned location and test our product for a period of 6-9 months, later the next phase will expand locations to Taimani, KololaPoshta, Jalalabad Road and 80 Meter Street. For the communication purpose will be working with Ministry of Telecommunication, especially with Aimal Marjan to help us with a GPS system or software that we can track our drivers/vehicles and pass them messages. For the marketing, we will be using radios announcement, TVs, brochures to be disturbed on door to door, plus all vehicles will be colored same with logo and name of company (Kabul 5

Minicab). This provides security, pick & drop from home to airport and any other places depends on pre booking, very well trained, education driver. We are trying to launch it a very a minimum amount at first phase just to recover the cost operation cost then once we grab the targeted market share in 2nd phase will be charging 10% admin fee.

2.1 Company Strategy

The Kabul Minicab`s strategy is to saturate the market with television ads representing the company as a first taxi service. The company will influence the newest in car technology to dominate the GPS. Kabul Minicab will control the market because no other company has this unique feature. The company's strategy is to build reputation and market share in our target market by establishing our business offering as a possible alternative to existing Kabul Minicab services. Kabul Minicab aims to get the confidence of customers and establish itself as a company that provides superior customer service by using up to date skill to provide timely and reliable services.

3.0 Technology Kabul Minicab will be equipped with the up to date and modern technologies in order to facilitate timely and reliable services to the clients. Those equipment includes: 3.1 Global Positioning System: Kabul Minicab has a unique Global Positioning System (GPS) that identifies the nearing driver thus allowing the driver to give an accurate estimated time of arrival. 3.2 Radio System: Reliable communications are essential under all circumstances. Kabul Minicab will use the KDT 5000 system design because it provides multiple levels of reliability to assure communications will be maintained under the hardest condition.

4.0 Marketing Strategy Kabul Minicab will start as a new company into the public passenger industry. We plan to have our name on the TV, Radio, and Magazines and on Morning and Evening news. Kabul Minicab wants to divert the attentions to new business as well as to bring knowledge about becoming more environmentally aware. We want to organize brand positioning for our 6

new service as being an economical and eco-friendly way of transportation. Kabul Minicab will advertise its ideas throughout the Kabul City. Additionally, Kabul Minicab will look to alternative media opportunities to get our name and message out like organizing special promotions with other business that support our mission of being an eco-friendly company. The company will market its products and services as solutions to transportation needs in the city of Kabul. Other target markets include customers in the low to mid income range. Direct mailings and television advertising will be the company's main marketing channels. These channels ensure that target customers are reached repeatedly and effectively on commercials on Cable Networks in Kabul, FM radio transmissions and TV guide/Info channel.

4.1 Marketing Program Kabul Minicab plans to communicate through Radio and television advertising to generate sales. The key message associated with our products and services is cleaner, efficient, flexible, and convenient taxi cabs. The company also has additional promotional plans which are diverse and include a range of marketing communications described below:

4.1.1 Trade shows: Company representatives will attend and participate in several trade shows to keep up with changes in the industry.

4.1.2 Print advertising and article publishing: The company's print advertising program will include advertisements in local newspapers and local journal publications like the Daily Outlook Afghanistan, Daily Anees, hashtet Sub and etc. There is usually a meter on the dash of each taxicab that calculates how many miles a passenger goes and then determines the cost of that ride. The passenger is charged per mile, with additional surcharges, such as number of bags or extra passengers. We are considering the mentioned points in pricing model for Kabul Minicab, which well be categorized in the following methods. 

Initial price must be lower as compare to the other competing companies



The price should be reasonable and affordable for the public.



The price payment method can be in the following types Cash Payment, Contract and Credit/Debit cards payments via POS machines 7

4.2 Target Market As mentioned above for the first stage we are going to cover the Kabul city's below locations initially which are Shahre Now, Wazir Akbar khan Macroryan 1,2,3,4 and Hamid Karzai International Airport. After successful coverage of Kabul city then we plan to target the other major cities of the country like, Jalalabad, Kandahar, Herat, Mazar, and Kunduz.

4.3 Promotion Plan Kabul Minicab will not only be having clean and tidy taxis but will play a role model in the country that we didn't have such examples before. A group of friendly, polite, professional and uniformed drivers will accompany the passengers to their destinations with careful driving. Kabul Minicab will form relationships with wireless carriers and the smart phone applications providers that are aligned with our goals and use these relationships to communicate our image of a new, clean, innovative cab company with a great value.

5.0 Human Resources The company will have 7 permanent employees in its first two years of operation. In 2017 it will raise the numbers to 9 by adding one more call center agent and an additional supervisor. Moreover it will have 15 contractors as drivers and will raise to 20 and 30 respectively in 2016 and 2017. Chart 5.0.1 - Organizational Chart

CEO

Officer Manager (1)

Supervisor (1)

Operations Manager (1)

Accountant (1)

Call Center Agent (2)

Drivers (15)

8

Table: Personnel Plan – Yearly Personnel Plan - Yearly Year

2015

CEO

360,000.00

480,000.00

600,000.00

Operation Officer

240,000.00

300,000.00

360,000.00

Supervisor

180,000.00

216,000.00

480,000.00

Office Manager

180,000.00

216,000.00

240,000.00

Accountant

144,000.00

180,000.00

216,000.00

Call Center

240,000.00

288,000.00

540,000.00

1,344,000.00

1,680,000.00

2,436,000.00

Year

2015

2016

2017

CEO

1

1

1

Operation Officer

1

1

1

Supervisor

1

1

2

Office Manager

1

1

1

Accountant

1

1

1

Call Center

2

2

3

Total

7

7

9

Total

2016

2017

Numbers of Personnel

Chart: Personal Expenses Breakdown

Personnel Expense Breakdown 18%

27% CEO

11% 13%

18% 13%

Operation Officer Supervisor Office Manager Accountant

Call Center

9

6.0 Findings and Data Analysis Data is collected through questionnaires as a sample distributed to 98 people living in Kabul City. It was then loaded to SPSS for further analysis and as a result the below reports were generated. 

Regression Line



R-Squire



Frequency Analysis



Charts and graphs explaining the different variables

These reports are used to have a summarized view of the study and gives a clear picture for decision making purpose. Table: Variable View

10

Table: Data View

Pe rsona l Tra ve l

Profe ssio na l Tra ve l

Tw ice a w e e k

Curre nt ta x i fa re s

Ava ilibility comfort a nd sa fe of ta x i

Cle a nlin e ss a nd a ttitude

ve hicle mode l

De ma nd of our se rvice

3.00

1.00

1.00

1.00

1.00

3.00

1.00

2.00

4.00

4.00

1.00

3.00

2.00

1.00

2.00

3.00

4.00

3.00

4.00

1.00

3.00

3.00

3.00

1.00

3.00

3.00

4.00

3.00

1.00

1.00

3.00

1.00

3.00

3.00

1.00

2.00

4.00

1.00

4.00

1.00

3.00

1.00

1.00

2.00

4.00

3.00

1.00

1.00

3.00

1.00

3.00

3.00

1.00

2.00

1.00

1.00

1.00

3.00

1.00

1.00

1.00

3.00

3.00

1.00

1.00

1.00

3.00

1.00

1.00

1.00

3.00

3.00

3.00

1.00

2.00

3.00

3.00

2.00

2.00

2.00

4.00

3.00

3.00

4.00

3.00

3.00

3.00

3.00

2.00

3.00

3.00

1.00

3.00

3.00

4.00

2.00

4.00

2.00

3.00

1.00

1.00

4.00

2.00

2.00

4.00

3.00

1.00

4.00

4.00

3.00

4.00

1.00

4.00

3.00

3.00

3.00

4.00

1.00

1.00

4.00

2.00

2.00

4.00

3.00

1.00

4.00

3.00

3.00

2.00

3.00

1.00

3.00

3.00

3.00

4.00

3.00

3.00

2.00

3.00

1.00

3.00

3.00

3.00

4.00

4.00

4.00

4.00

1.00

3.00

1.00

1.00

1.00

4.00

3.00

1.00

3.00

4.00

3.00

3.00

4.00

3.00

2.00

3.00

1.00

4.00

1.00

3.00

1.00

1.00

1.00

4.00

3.00

3.00

2.00

3.00

2.00

3.00

3.00

1.00

3.00

3.00

3.00

2.00

3.00

2.00

3.00

3.00

1.00

3.00

1.00

1.00

3.00

1.00

3.00

1.00

3.00

1.00

3.00

3.00

4.00

2.00

1.00

3.00

1.00

3.00

1.00

4.00

4.00

4.00

4.00

3.00

3.00

1.00

1.00

1.00

4.00

4.00

4.00

2.00

3.00

4.00

4.00

1.00

1.00

4.00

4.00

4.00

2.00

3.00

4.00

4.00

1.00

1.00

4.00

4.00

2.00

3.00

2.00

3.00

1.00

1.00

2.00

4.00

4.00

2.00

3.00

2.00

1.00

3.00

3.00

1.00

4.00

1.00

1.00

3.00

1.00

3.00

1.00

1.00

2.00

3.00

4.00

4.00

1.00

1.00

3.00

3.00

2.00

3.00

4.00

1.00

1.00

4.00

1.00

4.00

1.00

2.00

1.00

4.00

1.00

1.00

3.00

2.00

2.00

2.00

2.00

2.00

2.00

4.00

3.00

1.00

1.00

3.00

3.00

3.00

2.00

4.00

4.00

3.00

1.00

2.00

4.00

2.00

3.00

2.00

3.00

1.00

1.00

4.00

3.00

1.00

3.00

3.00

2.00

2.00

1.00

1.00

4.00

3.00

1.00

3.00

3.00

2.00

2.00

4.00

1.00

3.00

1.00

4.00

3.00

1.00

3.00

4.00

4.00

4.00

4.00

1.00

4.00

1.00

1.00

4.00

4.00

4.00

1.00

2.00

1.00

2.00

1.00

2.00

1.00

4.00

3.00

3.00

2.00

3.00

2.00

2.00

1.00

2.00

3.00

3.00

3.00

2.00

3.00

1.00

4.00

2.00

2.00

4.00

1.00

1.00

1.00

3.00

1.00

1.00

3.00

2.00

2.00

1.00

1.00

1.00

3.00

3.00

3.00

1.00

3.00

3.00

3.00

3.00

3.00

1.00

3.00

3.00

1.00

3.00

3.00

3.00

4.00

4.00

3.00

3.00

2.00

3.00

3.00

3.00

4.00

3.00

3.00

2.00

1.00

1.00

2.00

2.00

3.00

4.00

2.00

4.00

3.00

4.00

1.00

1.00

1.00

4.00

3.00

1.00

2.00

1.00

1.00

3.00

2.00

2.00

4.00

3.00

1.00

3.00

1.00

1.00

3.00

2.00

2.00

4.00

3.00

1.00

1.00

1.00

1.00

3.00

1.00

2.00

4.00

4.00

1.00

3.00

2.00

1.00

2.00

3.00

4.00

3.00

4.00

1.00

3.00

3.00

3.00

1.00

3.00

3.00

4.00

3.00

1.00

1.00

3.00

1.00

3.00

3.00

1.00

2.00

4.00

1.00

4.00

1.00

3.00

1.00

1.00

2.00

4.00

3.00

1.00

1.00

3.00

1.00

3.00

3.00

1.00

2.00

1.00

1.00

1.00

3.00

1.00

1.00

1.00

3.00

3.00

1.00

1.00

1.00

3.00

1.00

1.00

1.00

3.00

3.00

3.00

1.00

2.00

3.00

3.00

2.00

2.00

2.00

4.00

3.00

3.00

4.00

3.00

3.00

3.00

3.00

2.00

3.00

3.00

1.00

3.00

3.00

4.00

2.00

4.00

2.00

3.00

1.00

1.00

4.00

2.00

2.00

4.00

3.00

1.00

4.00

4.00

3.00

4.00

1.00

4.00

3.00

3.00

3.00

4.00

1.00

1.00

4.00

2.00

2.00

4.00

3.00

1.00

4.00

3.00

3.00

2.00

3.00

1.00

3.00

3.00

3.00

4.00

3.00

3.00

2.00

3.00

1.00

3.00

3.00

3.00

4.00

4.00

4.00

4.00

1.00

3.00

1.00

1.00

1.00

4.00

3.00

1.00

3.00

4.00

3.00

3.00

4.00

3.00

2.00

3.00

1.00

4.00

1.00

3.00

1.00

1.00

1.00

4.00

3.00

3.00

2.00

3.00

2.00

3.00

3.00

1.00

3.00

3.00

3.00

2.00

3.00

2.00

3.00

3.00

1.00

3.00

1.00

1.00

3.00

1.00

3.00

1.00

3.00

1.00

3.00

3.00

4.00

2.00

1.00

3.00

1.00

3.00

1.00

4.00

4.00

4.00

4.00

3.00

3.00

1.00

1.00

1.00

4.00

4.00

4.00

2.00

3.00

4.00

4.00

1.00

1.00

4.00

4.00

4.00

2.00

3.00

4.00

4.00

1.00

1.00

4.00

4.00

2.00

3.00

2.00

3.00

1.00

1.00

2.00

4.00

4.00

2.00

3.00

2.00

1.00

3.00

3.00

1.00

4.00

1.00

1.00

3.00

1.00

3.00

1.00

1.00

2.00

3.00

4.00

4.00

1.00

1.00

3.00

3.00

2.00

3.00

4.00

1.00

1.00

4.00

1.00

4.00

1.00

2.00

1.00

4.00

1.00

1.00

3.00

2.00

2.00

2.00

2.00

2.00

2.00

4.00

3.00

1.00

1.00

3.00

3.00

3.00

2.00

4.00

4.00

3.00

1.00

2.00

4.00

2.00

3.00

2.00

3.00

1.00

1.00

4.00

3.00

1.00

3.00

3.00

2.00

2.00

1.00

1.00

4.00

3.00

1.00

3.00

3.00

2.00

2.00

4.00

1.00

3.00

1.00

4.00

3.00

1.00

3.00

4.00

4.00

4.00

4.00

1.00

4.00

1.00

1.00

4.00

4.00

4.00

1.00

2.00

1.00

2.00

1.00

2.00

1.00

4.00

3.00

3.00

2.00

3.00

2.00

2.00

1.00

2.00

3.00

3.00

3.00

2.00

3.00

1.00

4.00

2.00

2.00

4.00

1.00

1.00

1.00

3.00

1.00

1.00

3.00

2.00

2.00

1.00

1.00

1.00

3.00

3.00

3.00

1.00

3.00

3.00

3.00

3.00

3.00

1.00

3.00

3.00

1.00

3.00

3.00

3.00

4.00

4.00

3.00

3.00

2.00

3.00

3.00

3.00

4.00

3.00

3.00

2.00

1.00

1.00

2.00

2.00

3.00

4.00

2.00

4.00

3.00

4.00

1.00

1.00

1.00

4.00

3.00

1.00

2.00

1.00

1.00

3.00

2.00

2.00

4.00

3.00

1.00

3.00

1.00

1.00

3.00

2.00

2.00

4.00

11

12

13

14

15

16

17

18

6.1 Interpretation and Explanation of the Regression Lines QX = 3.301 + 0.215 (Personal Travel) + 0.041 (Prf. Travel) + 0.062 (Weekly use) – 0.263 (Cfares) + 0.46 (availability) + 0.110 (C&S) – 0.189 (Cleanness) – 0.070 (Model)

Personal Travel = 282 Professional Travel = 200 People who use twice a week = 258 Current taxi fares = 212 Availability of taxi = 234 Comfort and safe = 222 Cleanliness and attitude = 212 Vehicle model = 194

QX = 3.301 + 0.215 (282) + 0.041 (200) + 0.062 (258) – 0.263 (212) + 0.46 (234) + 0.110 (222) – 0.189 (212) – 0.070 (194) = QX = 3.301 + 60.63 + 8.2 + 15.99 – 55.75 + 107.64 + 24.42 – 40.06 – 13.58 = 110.791 19

01)

^Q/^P*PX/QX EP = 0.215 x 282 / 110.791 = 0.54

1% increase in customer who uses taxi for his personal use will increase 0.54% the demand for KABUL MINICAB service. 02) EP = 0.041 x 200 / 110.791 = 0.074 1% increase in customer who uses taxi for his personal use will increase 0.074% the demand for KABUL MINICAB service. 03) EP = 0.062 x 258 / 110.791 = 0.14 1% increase in customer who uses taxi twice a week will increase 0.14% the demand for KABUL MINICAB service. 04) EP = – 0.263 x 212 / 110.791 = -0.50 1% Decrease in current taxi fares will decrease 0.50% the demand for KABUL MINICAB service. 05) EP = 0.46 x 234 / 110.791 = 0.97 1% increase in experienced difficulty with the availability of taxi will increase 0.97% the demand for KABUL MINICAB service. 06) EP = 0.110 x 222 / 110.791 = 0.22 1% Increase in experienced comfort and safe while traveling on taxi will increase 0.22% the demand for KABUL MINICAB service. 07) EP = – 0.189 x 212 / 110.791 = - 0.36 1% Decrease in cleanliness of the vehicle and driver attitudewill decrease 0.36% the demand for KABUL MINICAB service. 08) EP = – 0.070 x 194 / 110.791 = - 0.12 1% Decrease in model of the vehicle used for the taxi will decrease 0.12% the demand for KABUL MINICAB service.

7.0 Financial Plan.

20

7.1 Important Assumptions 

The owners will require AFN8.9 Million for Business Start-up



Kabul Minicab will have 67% and 65% Annual Sales Growth Rate in years 2016 and 2017 respectively ( Based on successful implementation of Marketing strategies and raise in number of cabs for targeting more areas of Kabul )



Harmful changes in economy will have negative impacts on sales forecast



2% Tax on revenue will be paid quarterly while 20% Income Tax will be paid annually



Company will have AFN120,000 per month Marketing Cost at Start-up which will gradually decrease to AFN50,000 per month



Company estimates AFN2,000 monthly Repair and Maintenance Cost per vehicle

7.2 Sensitivity Analysis As stated earlier, downturn in economic situation will have negative impact on annual revenue. However, we believe that people will continue to use cab service until harmful changes happen to economy. This is especially true among people that frequent nighttime venues and require a ride home upon exiting. As such, this and the high margins earned from services will ensure that the Taxi Cab Service can keep its gross margin at higher level. 7.3 Key Financial Indicators The key financial indicators focus on cash flow. There is virtually no inventory. On time billing and collection of receivables will play critical role. All expenses are tracked on a monthly basis, recorded in the accounting software, and will be compared to our business plan budget. Company will use Cash Basis method of accounting. 7.4 Investment. 21

Kabul Minicab will start its business with an initial capital of AFN 8.9 Million which equals about USD156,140.00. The source for initial investment will be the 9 Business Partners with equal contribution. This investment is planned to meet requirements of fund to start up Longterm assets and start-up expenditures. Below is the summary of start-up. Table: Start-up Summary Start-up

Requirements

Start-up Expenses Legal

AFN 35,000.00

Stationery etc.

AFN 20,000.00

Brochures

AFN 15,000.00

Other Marketing Expenses

AFN 200,000.00

Lease and agreements

AFN 20,000.00

Other

AFN 52,500.00

Total Start-up Expenses

AFN 342,500.00

Start-up Assets Cash Required Other Current Assets

AFN 300,000.00 AFN 0.00

Long-term Assets

AFN 8,257,500.00

Total Assets

AFN 8,557,500.00

Total Requirements

AFN 8,900,000.00

Table: Start-up Funding

22

Start-up Funding

Start-up Expenses to Fund

AFN 342,500.00

Start-up Assets to Fund

AFN 8,557,500.00

Total Funding Required

AFN 8,900,000.00

Assets Non-cash Assets from Start-up Cash Requirements from Start-up Additional Cash Raised

AFN 8,257,500.00 AFN 300,000.00 AFN 0.00

Cash Balance on Starting Date

AFN 8,257,500.00

Total Assets

AFN 8,557,500.00

Liabilities and Capital

Liabilities Current Borrowing

AFN 0.00

Long-term Liabilities

AFN 0.00

Accounts Payable (Outstanding Bills)

AFN 0.00

Other Current Liabilities (interest-free)

AFN 0.00

Total Liabilities

AFN 0.00

Capital

Planned Investment Investment by Business Partners Additional Investment Requirement Total Planned Investment

Loss at Start-up (Start-up Expenses)

AFN 8,900,000.00 AFN 0.00 AFN 8,900,000.00

-AFN 342,500.00

Total Capital

AFN 8,557,500.00

Total Capital and Liabilities

AFN 8,557,500.00

Total Funding

AFN 8,900,000.00

7.5 Sales Forecast.

23

As a Start-up company is taking the current economic situation into consideration, Kabul Minicab estimates a revenue of AFN1,300.00 per taxi per day in first two months which will gradually increase to AFN2,400 with a monthly average of AFN1,966.67 throughout the first year of Operation. At the start of 2nd and 3rd year of operation, after implementing marketing strategies and receiving customer satisfaction, company is looking forward for expansion of their business. Company will acquire further 5 taxies in year 2016 and 10 taxies in year 2017 and estimates25% increase in monthly average revenue per taxi for year 2016 and 10% increase in monthly average revenue per taxi for year 2017 which will result 67% and 65% increase in annual sales in years 2016 and 2017 respectively. Below table shows sales forecast for three years. Table: Sales Forecast Sales Forecast Year

2015

2016

2017

Sales

10,620,000.00

17,700,000.00

29,205,000.00

Other

0.00

0.00

0.00

10,620,000.00

17,700,000.00

29,205,000.00

Fuel

3,186,000.00

5,310,000.00

8,761,500.00

Drivers' wages

1,440,000.00

2,160,000.00

3,600,000.00

Total Sales

Direct Cost of Sales

Other Subtotal Direct Cost of Sales

0.00

0.00

0.00

4,626,000.00

7,470,000.00

12,361,500.00

Chart: Sales Forecast

7.5.1

Pricing

24

As per company strategies, Kabul Minicab will offer lower prices than current market to their customers. As per our survey conducted in Kabul market, normal rate for 6km ride is AFN150.00 which is equal to AFN25.00 per kilometer. For better attraction of customers, Kabul Minicab will charge AFN20.00 per kilometer.

7.5.2 Direct Cost of Sales There are two main factors of direct cost: Fuel and Driver’s wages. Normally, vehicle used for taxi purpose consumes 1 liter fuel for 8km mileage which costs AFN6.25 per kilometer (where cost of one liter fuel is equal to AFN50). Comparatively, fuel cost is approximately 30% of revenue generated (6.25/20). Company will pay monthly wages of AFN8,000.00 to each driver in year 2015. In year 2016 and 2017, driver’s wages will be increased to AFN9,000.00 and AFN10,000.00 respectively.

7.6 Profit and Loss Statements 25

Pro Forma Profit and Loss Year

2015

2016

2017

Sales

10,620,000.00

17,700,000.00

29,205,000.00

4,626,000.00

7,470,000.00

12,361,500.00

Direct Cost of Sales Other

0.00

0.00

0.00

Total Cost of Sales

4,626,000.00

7,470,000.00

12,361,500.00

Gross Margin

5,994,000.00

10,230,000.00

16,843,500.00

56%

58%

58%

Gross Margin %

Expenses Payroll

1,344,000.00

1,680,000.00

2,436,000.00

Sales and Marketing and Other Expenses

910,000.00

600,000.00

720,000.00

Repair and maintenance expenses

360,000.00

480,000.00

720,000.00

Stationery

12,000.00

14,400.00

18,000.00

Utilities

60,000.00

60,000.00

60,000.00

communication expenses

180,000.00

240,000.00

264,000.00

Food and entertainment

156,000.00

180,000.00

192,000.00

Rent expenses

240,000.00

300,000.00

360,000.00

Depreciation

2,080,475.00

2,705,475.00

4,015,125.00

Total Operating Expenses

5,342,475.00

6,259,875.00

8,785,125.00

Profit before Taxes

651,525.00

3,970,125.00

8,058,375.00

2% BRT

212,400.00

354,000.00

584,100.00

20% Income Tax

224,603.33

723,225.00

1,494,855.00

Total Taxes Incurred

437,003.33

1,077,225.00

2,078,955.00

Net Profit

214,521.67

2,892,900.00

5,979,420.00

2%

16%

20%

Net Profit/Sales

7.7

Cash

Flow

Analysis 26

Proforma Cash Flow Year

2015

2016

2017

10,620,000.00

17,700,000.00

29,205,000.00

Cash Inflow

Cash from Operations Cash Sales Cash from Receivables Subtotal Cash from Operations

0.00

0.00

0.00

10,620,000.00

17,700,000.00

29,205,000.00

0.00

0.00

0.00

Additional Cash Received Sales of Long-term Assets New Investment Received

8,900,000.00

0.00

0.00

19,520,000.00

17,700,000.00

29,205,000.00

Month 1

Month 2

Month 3

Cash Spending

3,262,000.00

3,554,400.00

4,770,000.00

Bill Payments

4,626,000.00

7,470,000.00

12,361,500.00

Subtotal Spent on Operations

7,888,000.00

11,024,400.00

17,131,500.00

127,800.00

320,600.00

507,400.00

0.00

224,603.33

723,225.00

Total Cash Inflow

Cash Outflow

Expenditures from Operations

Additional Cash Spent Payment of BRT Payment of Income Tax Purchase Other Current Assets Purchase Long-term Assets Dividends

0.00

0.00

0.00

8,257,500.00

2,500,000.00

5,233,000.00

0.00

0.00

0.00

16,273,300.00

14,069,603.33

23,595,125.00

Net Cash Flow

3,246,700.00

3,630,396.67

5,609,875.00

Cash Balance

3,246,700.00

6,877,096.67

12,486,971.67

Total Cash Outflow

27

7.8 Balance Sheet Performa Balance Sheet Year

2015

2016

2017

3,246,700.00

6,877,096.67

12,486,971.67

Accounts Receivable

0.00

0.00

0.00

Other Current Assets

0.00

0.00

0.00

Total Current Assets

3,246,700.00

6,877,096.67

12,486,971.67

Long-term Assets

8,257,500.00

10,757,500.00

15,990,500.00

Accumulated Depreciation

2,080,475.00

4,785,950.00

8,801,075.00

Total Long-term Assets

6,177,025.00

5,971,550.00

7,189,425.00

Total Assets

9,423,725.00

12,848,646.67

19,676,396.67

Assets Current Assets Cash

Long-term Assets

Liabilities and Capital Current Liabilities Accounts Payable

0.00

0.00

0.00

84,600.00

118,000.00

194,700.00

20% Income Tax

224,603.33

723,225.00

1,494,855.00

Subtotal Current Liabilities

309,203.33

841,225.00

1,689,555.00

2% BRT

Long-term Liabilities

0.00

0.00

0.00

Total Liabilities

309,203.33

841,225.00

1,689,555.00

Paid-in Capital

8,900,000.00

8,900,000.00

8,900,000.00

0.00

214,521.67

3,107,421.67

Retained Earnings Earnings

214,521.67

2,892,900.00

5,979,420.00

Total Capital

9,114,521.67

12,007,421.67

17,986,841.67

Total Liabilities and Capital

9,423,725.00

12,848,646.67

19,676,396.67

Net Worth

9,114,521.67

12,007,421.67

17,986,841.67

28

7.9 Ratio Analysis Ratio Analysis Year

Year 1

Year 2

Year 3

n.a.

66.67%

65.00%

Accounts Receivable

0.00%

0.00%

0.00%

Other Current Assets

0.00%

0.00%

0.00%

Total Current Assets

34.45%

53.52%

63.46%

Long-term Assets

65.55%

46.48%

36.54%

Total Assets

100.00%

100.00%

100.00%

Current Liabilities

100.00%

100.00%

100.00%

Sales Growth

Percent of Total Assets

Long-term Liabilities Total Liabilities Net Worth

0.00%

0.00%

0.00%

100.00%

100.00%

100.00%

96.72%

93.45%

91.41%

Percent of Sales Sales

100.00%

100.00%

100.00%

Gross Margin

56.44%

57.80%

57.67%

Selling, General & Administrative Expenses

41.74%

31.98%

27.62%

Advertising Expenses

8.57%

3.39%

2.47%

Profit Before Interest and Taxes

6.13%

22.43%

27.59%

Current

10.50

8.18

7.39

Quick

10.50

8.18

7.39

0

0

0

Main Ratios

Dividend Payout

29

Conclusion This business plan which includes a research part as well concludes that 75.5% of the respondents uses taxi for their personal travels at least twice a week. current fares of the taxi are not reasonable because there isn't' any decent and organized city transport system. Anyone can buy a vehicle and work on it as a taxi, that is why 34.7% of the participants strongly agree that there has to be some reduction in the taxi fares. The other problem that the society is facing is the availability of the taxies, most of the time they cannot find them specially at the late hours of the day, 53.1% of the respondents strongly agree that they have difficulty finding taxies. Ultimately we can say that according to the current situation of the Kabul City and the other 5 big cities of the country launching this business would be an excellent idea and point to start with. The participants were from the different areas of the Kabul City, mainly the target areas whose responses are supporting this business.

30

References

31

Appendix Table: Sales forecast for three years Sales Forecast year 2015 Sales Taxi Services Other Total Sales

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

585,000.00

585,000.00

675,000.00

675,000.00

900,000.00

990,000.00

990,000.00

990,000.00

1,035,000.00

1,035,000.00

1,080,000.00

1,080,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

585,000.00

585,000.00

675,000.00

675,000.00

900,000.00

990,000.00

990,000.00

990,000.00

1,035,000.00

1,035,000.00

1,080,000.00

1,080,000.00

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

Fuel

175,500.00

175,500.00

202,500.00

202,500.00

270,000.00

297,000.00

297,000.00

297,000.00

310,500.00

310,500.00

324,000.00

324,000.00

Drivers' wages

120,000.00

120,000.00

120,000.00

120,000.00

120,000.00

120,000.00

120,000.00

120,000.00

120,000.00

120,000.00

120,000.00

120,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

295,500.00

295,500.00

322,500.00

322,500.00

390,000.00

417,000.00

417,000.00

417,000.00

430,500.00

430,500.00

444,000.00

444,000.00

Other Subtotal Direct Cost of Sales

Sales Forecast year 2016 Sales Taxi Services Other

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

Fuel

442,500.00

442,500.00

442,500.00

442,500.00

442,500.00

442,500.00

442,500.00

442,500.00

442,500.00

442,500.00

442,500.00

442,500.00

Drivers' wages

180,000.00

180,000.00

180,000.00

180,000.00

180,000.00

180,000.00

180,000.00

180,000.00

180,000.00

180,000.00

180,000.00

180,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

Total Sales

Direct Cost of Sales

Other Subtotal Direct Cost of Sales

32

Sales Forecast year 2017 Sales Taxi Services

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

Other

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

Fuel

730,125.00

730,125.00

730,125.00

730,125.00

730,125.00

730,125.00

730,125.00

730,125.00

730,125.00

730,125.00

730,125.00

730,125.00

Drivers' wages

300,000.00

300,000.00

300,000.00

300,000.00

300,000.00

300,000.00

300,000.00

300,000.00

300,000.00

300,000.00

300,000.00

300,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

Total Sales

Direct Cost of Sales

Other Subtotal Direct Cost of Sales

Table: Personnel Plan for three years Personnel Plan 2015 Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

CEO

1.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

Operation Officer

1.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

Supervisor

1.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

Office Manager

1.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

Accountant

1.00

12,000.00

12,000.00

12,000.00

12,000.00

12,000.00

12,000.00

12,000.00

12,000.00

12,000.00

12,000.00

12,000.00

12,000.00

Call Center

2.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

Total People

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

Total Payroll

33

Personnel Plan 2016 Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

CEO

1.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

Operation Officer

1.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

Supervisor

1.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

Office Manager

1.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

Accountant

1.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

Call Center

2.00

24,000.00

24,000.00

24,000.00

24,000.00

24,000.00

24,000.00

24,000.00

24,000.00

24,000.00

24,000.00

24,000.00

24,000.00

Total People

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

7.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

Total Payroll

Personnel Plan 2017 Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

CEO

1.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

Operation Officer

1.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

Supervisor

2.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

Office Manager

1.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

Accountant

1.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

18,000.00

Call Center

3.00

45,000.00

45,000.00

45,000.00

45,000.00

45,000.00

45,000.00

45,000.00

45,000.00

45,000.00

45,000.00

45,000.00

45,000.00

Total People

9.00

9.00

9.00

9.00

9.00

9.00

9.00

9.00

9.00

9.00

9.00

9.00

9.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

Total Payroll

34

Table: Profit and Loss for three years Pro Forma Profit and Loss 2015 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

585,000.00

585,000.00

675,000.00

675,000.00

900,000.00

990,000.00

990,000.00

990,000.00

1,035,000.00

1,035,000.00

1,080,000.00

1,080,000.00

Direct Cost of Sales

295,500.00

295,500.00

322,500.00

322,500.00

390,000.00

417,000.00

417,000.00

417,000.00

430,500.00

430,500.00

444,000.00

444,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Total Cost of Sales

295,500.00

295,500.00

322,500.00

322,500.00

390,000.00

417,000.00

417,000.00

417,000.00

430,500.00

430,500.00

444,000.00

444,000.00

Gross Margin

289,500.00

289,500.00

352,500.00

352,500.00

510,000.00

573,000.00

573,000.00

573,000.00

604,500.00

604,500.00

636,000.00

636,000.00

49%

49%

52%

52%

57%

58%

58%

58%

58%

58%

59%

59%

Payroll

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

112,000.00

Sales and Marketing and Other Expenses

120,000.00

120,000.00

100,000.00

100,000.00

80,000.00

60,000.00

60,000.00

60,000.00

60,000.00

50,000.00

50,000.00

50,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

Stationery

1,000.00

1,000.00

1,000.00

1,000.00

1,000.00

1,000.00

1,000.00

1,000.00

1,000.00

1,000.00

1,000.00

1,000.00

Utilities

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

communication expenses

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

Food and entertainment

13,000.00

13,000.00

13,000.00

13,000.00

13,000.00

13,000.00

13,000.00

13,000.00

13,000.00

13,000.00

13,000.00

13,000.00

Rent expenses

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

Depreciation

173,372.92

173,372.92

173,372.92

173,372.92

173,372.92

173,372.92

173,372.92

173,372.92

173,372.92

173,372.92

173,372.92

173,372.92

Total Operating Expenses

489,372.92

489,372.92

469,372.92

469,372.92

449,372.92

429,372.92

429,372.92

429,372.92

429,372.92

419,372.92

419,372.92

419,372.92

Profit before Taxes

199,872.92

199,872.92

116,872.92

116,872.92

60,627.08

143,627.08

143,627.08

143,627.08

175,127.08

185,127.08

216,627.08

216,627.08

11,700.00

11,700.00

13,500.00

13,500.00

18,000.00

19,800.00

19,800.00

19,800.00

20,700.00

20,700.00

21,600.00

21,600.00

0.00

0.00

0.00

0.00

8,525.42

24,765.42

24,765.42

24,765.42

30,885.42

32,885.42

39,005.42

39,005.42

11,700.00

11,700.00

13,500.00

13,500.00

26,525.42

44,565.42

44,565.42

44,565.42

51,585.42

53,585.42

60,605.42

60,605.42

211,572.92

211,572.92

130,372.92

130,372.92

34,101.67

99,061.67

99,061.67

99,061.67

123,541.67

131,541.67

156,021.67

156,021.67

-36%

-36%

-19%

-19%

4%

10%

10%

10%

12%

13%

14%

14%

Other

Gross Margin % Expenses

Repair and maintenance expenses

2% BRT 20% Income Tax Total Taxes Incurred

Net Profit Net Profit/Sales

35

Pro Forma Profit and Loss 2016 Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

Direct Cost of Sales

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

Total Cost of Sales

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

Gross Margin

852,500.00

852,500.00

852,500.00

852,500.00

852,500.00

852,500.00

852,500.00

852,500.00

852,500.00

852,500.00

852,500.00

852,500.00

58%

58%

58%

58%

58%

58%

58%

58%

58%

58%

58%

58%

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

140,000.00

Sales and Marketing and Other Expenses

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

50,000.00

Repair and maintenance expenses

Sales

Gross Margin % Expenses Payroll

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

40,000.00

Stationery

1,200.00

1,200.00

1,200.00

1,200.00

1,200.00

1,200.00

1,200.00

1,200.00

1,200.00

1,200.00

1,200.00

1,200.00

Utilities

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

communication expenses

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

20,000.00

Food and entertainment

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

15,000.00

Rent expenses

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

25,000.00

Depreciation

225,456.25

225,456.25

225,456.25

225,456.25

225,456.25

225,456.25

225,456.25

225,456.25

225,456.25

225,456.25

225,456.25

225,456.25

Total Operating Expenses

521,656.25

521,656.25

521,656.25

521,656.25

521,656.25

521,656.25

521,656.25

521,656.25

521,656.25

521,656.25

521,656.25

521,656.25

Profit before Taxes

330,843.75

330,843.75

330,843.75

330,843.75

330,843.75

330,843.75

330,843.75

330,843.75

330,843.75

330,843.75

330,843.75

330,843.75

2% BRT

29,500.00

29,500.00

29,500.00

29,500.00

29,500.00

29,500.00

29,500.00

29,500.00

29,500.00

29,500.00

29,500.00

29,500.00

20% Income Tax

60,268.75

60,268.75

60,268.75

60,268.75

60,268.75

60,268.75

60,268.75

60,268.75

60,268.75

60,268.75

60,268.75

60,268.75

Total Taxes Incurred

89,768.75

89,768.75

89,768.75

89,768.75

89,768.75

89,768.75

89,768.75

89,768.75

89,768.75

89,768.75

89,768.75

89,768.75

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

16%

16%

16%

16%

16%

16%

16%

16%

16%

16%

16%

16%

Net Profit Net Profit/Sales

36

Pro Forma Profit and Loss 2017 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

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

Direct Cost of Sales

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

Total Cost of Sales

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

Gross Margin

1,403,625.00

1,403,625.00

1,403,625.00

1,403,625.00

1,403,625.00

1,403,625.00

1,403,625.00

1,403,625.00

1,403,625.00

1,403,625.00

1,403,625.00

1,403,625.00

58%

58%

58%

58%

58%

58%

58%

58%

58%

58%

58%

58%

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

203,000.00

Sales and Marketing and Other Expenses

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

Repair and maintenance expenses

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

60,000.00

1,500.00

1,500.00

1,500.00

1,500.00

1,500.00

1,500.00

1,500.00

1,500.00

1,500.00

1,500.00

1,500.00

1,500.00

Gross Margin % Expenses Payroll

Stationery Utilities

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

5,000.00

communication expenses

22,000.00

22,000.00

22,000.00

22,000.00

22,000.00

22,000.00

22,000.00

22,000.00

22,000.00

22,000.00

22,000.00

22,000.00

Food and entertainment

16,000.00

16,000.00

16,000.00

16,000.00

16,000.00

16,000.00

16,000.00

16,000.00

16,000.00

16,000.00

16,000.00

16,000.00

Rent expenses

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

30,000.00

Depreciation

334,593.75

334,593.75

334,593.75

334,593.75

334,593.75

334,593.75

334,593.75

334,593.75

334,593.75

334,593.75

334,593.75

334,593.75

Total Operating Expenses

732,093.75

732,093.75

732,093.75

732,093.75

732,093.75

732,093.75

732,093.75

732,093.75

732,093.75

732,093.75

732,093.75

732,093.75

Profit before Taxes

671,531.25

671,531.25

671,531.25

671,531.25

671,531.25

671,531.25

671,531.25

671,531.25

671,531.25

671,531.25

671,531.25

671,531.25

2% BRT

48,675.00

48,675.00

48,675.00

48,675.00

48,675.00

48,675.00

48,675.00

48,675.00

48,675.00

48,675.00

48,675.00

48,675.00

20% Income Tax

124,571.25

124,571.25

124,571.25

124,571.25

124,571.25

124,571.25

124,571.25

124,571.25

124,571.25

124,571.25

124,571.25

124,571.25

Total Taxes Incurred

173,246.25

173,246.25

173,246.25

173,246.25

173,246.25

173,246.25

173,246.25

173,246.25

173,246.25

173,246.25

173,246.25

173,246.25

Net Profit

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

20%

20%

20%

20%

20%

20%

20%

20%

20%

20%

20%

20%

Net Profit/Sales

37

Table: Cash Flow for three years Pro Forma Cash Flow 2015 Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

585,000.00

585,000.00

675,000.00

675,000.00

900,000.00

990,000.00

990,000.00

990,000.00

1,035,000.00

1,035,000.00

1,080,000.00

1,080,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

585,000.00

585,000.00

675,000.00

675,000.00

900,000.00

990,000.00

990,000.00

990,000.00

1,035,000.00

1,035,000.00

1,080,000.00

1,080,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Sales of Long-term Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

New Investment Received

8,900,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Total Cash Inflow

9,485,000.00

585,000.00

675,000.00

675,000.00

900,000.00

990,000.00

990,000.00

990,000.00

1,035,000.00

1,035,000.00

1,080,000.00

1,080,000.00

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 Spending

316,000.00

316,000.00

296,000.00

296,000.00

276,000.00

256,000.00

256,000.00

256,000.00

256,000.00

246,000.00

246,000.00

246,000.00

Bill Payments

295,500.00

295,500.00

322,500.00

322,500.00

390,000.00

417,000.00

417,000.00

417,000.00

430,500.00

430,500.00

444,000.00

444,000.00

Subtotal Spent on Operations

611,500.00

611,500.00

618,500.00

618,500.00

666,000.00

673,000.00

673,000.00

673,000.00

686,500.00

676,500.00

690,000.00

690,000.00

Payment of BRT

0.00

0.00

0.00

0.00

50,400.00

0.00

0.00

0.00

77,400.00

0.00

0.00

0.00

Payment of Income Tax

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Purchase Other Current Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

8,257,500.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

8,869,000.00

611,500.00

618,500.00

618,500.00

716,400.00

673,000.00

673,000.00

673,000.00

763,900.00

676,500.00

690,000.00

690,000.00

Net Cash Flow

616,000.00

-26,500.00

56,500.00

56,500.00

183,600.00

317,000.00

317,000.00

317,000.00

271,100.00

358,500.00

390,000.00

390,000.00

Cash Balance

616,000.00

589,500.00

646,000.00

702,500.00

886,100.00

1,203,100.00

1,520,100.00

1,837,100.00

2,108,200.00

2,466,700.00

2,856,700.00

3,246,700.00

Cash Inflow Cash from Operations Cash Sales Cash from Receivables Subtotal Cash from Operations Additional Cash Received Sales of Other Current Assets

Cash Outflow Expenditures from Operations

Additional Cash Spent

Purchase Long-term Assets Dividends Total Cash Outflow

38

Pro Forma Cash Flow 2016 Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

Cash Inflow Cash from Operations Cash Sales Cash from Receivables

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

Sales of Other Current Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Sales of Long-term Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Subtotal Cash from Operations Additional Cash Received

New Investment Received

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

1,475,000.00

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 Spending

296,200.00

296,200.00

296,200.00

296,200.00

296,200.00

296,200.00

296,200.00

296,200.00

296,200.00

296,200.00

296,200.00

296,200.00

Bill Payments

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

622,500.00

Subtotal Spent on Operations

918,700.00

918,700.00

918,700.00

918,700.00

918,700.00

918,700.00

918,700.00

918,700.00

918,700.00

918,700.00

918,700.00

918,700.00

Total Cash Inflow Cash Outflow Expenditures from Operations

Additional Cash Spent Payment of BRT Payment of Income Tax Purchase Other Current Assets

84,600.00

0.00

0.00

0.00

118,000.00

0.00

0.00

0.00

118,000.00

0.00

0.00

0.00

224,603.33

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2,500,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Total Cash Outflow

3,727,903.33

918,700.00

918,700.00

918,700.00

1,036,700.00

918,700.00

918,700.00

918,700.00

1,036,700.00

918,700.00

918,700.00

918,700.00

Net Cash Flow

2,252,903.33

556,300.00

556,300.00

556,300.00

438,300.00

556,300.00

556,300.00

556,300.00

438,300.00

556,300.00

556,300.00

556,300.00

Cash Balance

993,796.67

1,550,096.67

2,106,396.67

2,662,696.67

3,100,996.67

3,657,296.67

4,213,596.67

4,769,896.67

5,208,196.67

5,764,496.67

6,320,796.67

6,877,096.67

Purchase Long-term Assets Dividends

39

Pro Forma Cash Flow 2017 Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

Cash Inflow Cash from Operations Cash Sales Cash from Receivables

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

Sales of Other Current Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Sales of Long-term Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Subtotal Cash from Operations Additional Cash Received

New Investment Received

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

2,433,750.00

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

397,500.00

397,500.00

397,500.00

397,500.00

397,500.00

397,500.00

397,500.00

397,500.00

397,500.00

397,500.00

397,500.00

397,500.00

Bill Payments

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

1,030,125.00

Subtotal Spent on Operations

1,427,625.00

1,427,625.00

1,427,625.00

1,427,625.00

1,427,625.00

1,427,625.00

1,427,625.00

1,427,625.00

1,427,625.00

1,427,625.00

1,427,625.00

1,427,625.00

Payment of BRT

118,000.00

0.00

0.00

0.00

194,700.00

0.00

0.00

0.00

194,700.00

0.00

0.00

0.00

Payment of Income Tax

723,225.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Total Cash Inflow Cash Outflow Expenditures from Operations Cash Spending

Additional Cash Spent

Purchase Other Current Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

5,233,000.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Total Cash Outflow

7,501,850.00

1,427,625.00

1,427,625.00

1,427,625.00

1,622,325.00

1,427,625.00

1,427,625.00

1,427,625.00

1,622,325.00

1,427,625.00

1,427,625.00

1,427,625.00

Net Cash Flow

5,068,100.00

1,006,125.00

1,006,125.00

1,006,125.00

811,425.00

1,006,125.00

1,006,125.00

1,006,125.00

811,425.00

1,006,125.00

1,006,125.00

1,006,125.00

Cash Balance

1,808,996.67

2,815,121.67

3,821,246.67

4,827,371.67

5,638,796.67

6,644,921.67

7,651,046.67

8,657,171.67

9,468,596.67

10,474,721.67

11,480,846.67

12,486,971.67

Purchase Long-term Assets Dividends

40

Table: Balance Sheet for three years Pro Forma Balance Sheet 2015 Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Assets Current Assets Cash

616,000.00

589,500.00

646,000.00

702,500.00

886,100.00

1,203,100.00

1,520,100.00

1,837,100.00

2,108,200.00

2,466,700.00

2,856,700.00

3,246,700.00

Accounts Receivable

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Other Current Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

616,000.00

589,500.00

646,000.00

702,500.00

886,100.00

1,203,100.00

1,520,100.00

1,837,100.00

2,108,200.00

2,466,700.00

2,856,700.00

3,246,700.00

8,257,500.00

8,257,500.00

8,257,500.00

8,257,500.00

8,257,500.00

8,257,500.00

8,257,500.00

8,257,500.00

8,257,500.00

8,257,500.00

8,257,500.00

8,257,500.00

173,372.92

346,745.83

520,118.75

693,491.67

866,864.58

1,040,237.50

1,213,610.42

1,386,983.33

1,560,356.25

1,733,729.17

1,907,102.08

2,080,475.00

Total Long-term Assets

8,084,127.08

7,910,754.17

7,737,381.25

7,564,008.33

7,390,635.42

7,217,262.50

7,043,889.58

6,870,516.67

6,697,143.75

6,523,770.83

6,350,397.92

6,177,025.00

Total Assets

8,700,127.08

8,500,254.17

8,383,381.25

8,266,508.33

8,276,735.42

8,420,362.50

8,563,989.58

8,707,616.67

8,805,343.75

8,990,470.83

9,207,097.92

9,423,725.00

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

11,700.00

23,400.00

36,900.00

50,400.00

18,000.00

37,800.00

57,600.00

77,400.00

20,700.00

41,400.00

63,000.00

84,600.00

0.00

0.00

0.00

0.00

8,525.42

33,290.83

58,056.25

82,821.67

113,707.08

146,592.50

185,597.92

224,603.33

11,700.00

23,400.00

36,900.00

50,400.00

26,525.42

71,090.83

115,656.25

160,221.67

134,407.08

187,992.50

248,597.92

309,203.33

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Total Current Assets Long-term Assets Long-term Assets Accumulated Depreciation

Liabilities and Capital Current Liabilities Accounts Payable 2% BRT 20% Income Tax Subtotal Current Liabilities Long-term Liabilities Total Liabilities Paid-in Capital Retained Earnings Earnings

11,700.00

23,400.00

36,900.00

50,400.00

26,525.42

71,090.83

115,656.25

160,221.67

134,407.08

187,992.50

248,597.92

309,203.33

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

0.00

-211,572.92

-423,145.83

-553,518.75

-683,891.67

-649,790.00

-550,728.33

-451,666.67

-352,605.00

-229,063.33

-97,521.67

58,500.00

-211,572.92

-211,572.92

-130,372.92

-130,372.92

34,101.67

99,061.67

99,061.67

99,061.67

123,541.67

131,541.67

156,021.67

156,021.67

Total Capital

8,688,427.08

8,476,854.17

8,346,481.25

8,216,108.33

8,250,210.00

8,349,271.67

8,448,333.33

8,547,395.00

8,670,936.67

8,802,478.33

8,958,500.00

9,114,521.67

Total Liabilities and Capital

8,700,127.08

8,500,254.17

8,383,381.25

8,266,508.33

8,276,735.42

8,420,362.50

8,563,989.58

8,707,616.67

8,805,343.75

8,990,470.83

9,207,097.92

9,423,725.00

Net Worth

8,688,427.08

8,476,854.17

8,346,481.25

8,216,108.33

8,250,210.00

8,349,271.67

8,448,333.33

8,547,395.00

8,670,936.67

8,802,478.33

8,958,500.00

9,114,521.67

41

Pro Forma Balance Sheet 2016 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 Current Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

993,796.67

1,550,096.67

2,106,396.67

2,662,696.67

3,100,996.67

3,657,296.67

4,213,596.67

4,769,896.67

5,208,196.67

5,764,496.67

6,320,796.67

6,877,096.67

Accounts Receivable

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Other Current Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

993,796.67

1,550,096.67

2,106,396.67

2,662,696.67

3,100,996.67

3,657,296.67

4,213,596.67

4,769,896.67

5,208,196.67

5,764,496.67

6,320,796.67

6,877,096.67

10,757,500.00

10,757,500.00

10,757,500.00

10,757,500.00

10,757,500.00

10,757,500.00

10,757,500.00

10,757,500.00

10,757,500.00

10,757,500.00

10,757,500.00

10,757,500.00

Accumulated Depreciation

2,305,931.25

2,531,387.50

2,756,843.75

2,982,300.00

3,207,756.25

3,433,212.50

3,658,668.75

3,884,125.00

4,109,581.25

4,335,037.50

4,560,493.75

4,785,950.00

Total Long-term Assets

8,451,568.75

8,226,112.50

8,000,656.25

7,775,200.00

7,549,743.75

7,324,287.50

7,098,831.25

6,873,375.00

6,647,918.75

6,422,462.50

6,197,006.25

5,971,550.00

Total Assets

9,445,365.42

9,776,209.17

10,107,052.92

10,437,896.67

10,650,740.42

10,981,584.17

11,312,427.92

11,643,271.67

11,856,115.42

12,186,959.17

12,517,802.92

12,848,646.67

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

Total Current Assets Long-term Assets Long-term Assets

Liabilities and Capital Current Liabilities Accounts Payable

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2% BRT

29,500.00

59,000.00

88,500.00

118,000.00

29,500.00

59,000.00

88,500.00

118,000.00

29,500.00

59,000.00

88,500.00

118,000.00

20% Income Tax

60,268.75

120,537.50

180,806.25

241,075.00

301,343.75

361,612.50

421,881.25

482,150.00

542,418.75

602,687.50

662,956.25

723,225.00

Subtotal Current Liabilities

89,768.75

179,537.50

269,306.25

359,075.00

330,843.75

420,612.50

510,381.25

600,150.00

571,918.75

661,687.50

751,456.25

841,225.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Long-term Liabilities Total Liabilities Paid-in Capital Retained Earnings Earnings

89,768.75

179,537.50

269,306.25

359,075.00

330,843.75

420,612.50

510,381.25

600,150.00

571,918.75

661,687.50

751,456.25

841,225.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

214,521.67

455,596.67

696,671.67

937,746.67

1,178,821.67

1,419,896.67

1,660,971.67

1,902,046.67

2,143,121.67

2,384,196.67

2,625,271.67

2,866,346.67

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

241,075.00

Total Capital

9,355,596.67

9,596,671.67

9,837,746.67

10,078,821.67

10,319,896.67

10,560,971.67

10,802,046.67

11,043,121.67

11,284,196.67

11,525,271.67

11,766,346.67

12,007,421.67

Total Liabilities and Capital

9,445,365.42

9,776,209.17

10,107,052.92

10,437,896.67

10,650,740.42

10,981,584.17

11,312,427.92

11,643,271.67

11,856,115.42

12,186,959.17

12,517,802.92

12,848,646.67

Net Worth

9,355,596.67

9,596,671.67

9,837,746.67

10,078,821.67

10,319,896.67

10,560,971.67

10,802,046.67

11,043,121.67

11,284,196.67

11,525,271.67

11,766,346.67

12,007,421.67

42

Pro Forma Balance Sheet 2017 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 Current Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

1,808,996.67

2,815,121.67

3,821,246.67

4,827,371.67

5,638,796.67

6,644,921.67

7,651,046.67

8,657,171.67

9,468,596.67

10,474,721.67

11,480,846.67

12,486,971.67

Accounts Receivable

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Other Current Assets

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

1,808,996.67

2,815,121.67

3,821,246.67

4,827,371.67

5,638,796.67

6,644,921.67

7,651,046.67

8,657,171.67

9,468,596.67

10,474,721.67

11,480,846.67

12,486,971.67

15,990,500.00

15,990,500.00

15,990,500.00

15,990,500.00

15,990,500.00

15,990,500.00

15,990,500.00

15,990,500.00

15,990,500.00

15,990,500.00

15,990,500.00

15,990,500.00

Cash

Total Current Assets Long-term Assets Long-term Assets Accumulated Depreciation

5,120,543.75

5,455,137.50

5,789,731.25

6,124,325.00

6,458,918.75

6,793,512.50

7,128,106.25

7,462,700.00

7,797,293.75

8,131,887.50

8,466,481.25

8,801,075.00

Total Long-term Assets

10,869,956.25

10,535,362.50

10,200,768.75

9,866,175.00

9,531,581.25

9,196,987.50

8,862,393.75

8,527,800.00

8,193,206.25

7,858,612.50

7,524,018.75

7,189,425.00

Total Assets

12,678,952.92

13,350,484.17

14,022,015.42

14,693,546.67

15,170,377.92

15,841,909.17

16,513,440.42

17,184,971.67

17,661,802.92

18,333,334.17

19,004,865.42

19,676,396.67

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

Liabilities and Capital Current Liabilities Accounts Payable

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

48,675.00

97,350.00

146,025.00

194,700.00

48,675.00

97,350.00

146,025.00

194,700.00

48,675.00

97,350.00

146,025.00

194,700.00

20% Income Tax

124,571.25

249,142.50

373,713.75

498,285.00

622,856.25

747,427.50

871,998.75

996,570.00

1,121,141.25

1,245,712.50

1,370,283.75

1,494,855.00

Subtotal Current Liabilities

173,246.25

346,492.50

519,738.75

692,985.00

671,531.25

844,777.50

1,018,023.75

1,191,270.00

1,169,816.25

1,343,062.50

1,516,308.75

1,689,555.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

2% BRT

Long-term Liabilities Total Liabilities

173,246.25

346,492.50

519,738.75

692,985.00

671,531.25

844,777.50

1,018,023.75

1,191,270.00

1,169,816.25

1,343,062.50

1,516,308.75

1,689,555.00

Paid-in Capital

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

8,900,000.00

Retained Earnings

3,107,421.67

3,605,706.67

4,103,991.67

4,602,276.67

5,100,561.67

5,598,846.67

6,097,131.67

6,595,416.67

7,093,701.67

7,591,986.67

8,090,271.67

8,588,556.67

Earnings

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

498,285.00

Total Capital

12,505,706.67

13,003,991.67

13,502,276.67

14,000,561.67

14,498,846.67

14,997,131.67

15,495,416.67

15,993,701.67

16,491,986.67

16,990,271.67

17,488,556.67

17,986,841.67

Total Liabilities and Capital

12,678,952.92

13,350,484.17

14,022,015.42

14,693,546.67

15,170,377.92

15,841,909.17

16,513,440.42

17,184,971.67

17,661,802.92

18,333,334.17

19,004,865.42

19,676,396.67

Net Worth

12,505,706.67

13,003,991.67

13,502,276.67

14,000,561.67

14,498,846.67

14,997,131.67

15,495,416.67

15,993,701.67

16,491,986.67

16,990,271.67

17,488,556.67

17,986,841.67

43

Questionnaire Design: The company's products and services show that we are an innovative, forward thinking company that recognizes the need to move with ever-changing customer needs. Our target markets include customers in the low to mid income range and we have to collect the data from the general citizens of KABUL city including female, male, teenagers and old. So we kept the questions in the questionnaire very simple and with simple answers. (See Appendix1 for details). We tried to keep maximum questions like Multiple Choice Questions, instead of open-ended questions. The reason behind this strategy was that people feel easy to give answers of MCQs as they do not have to think much and do not have to give more time. They just answer by ticking one of the available options. The next challenge was to collect the respondents of the questionnaire. It was very difficult task but the strategy we adopted, proved to be successful.

44

Questionnaires The idea of venture is to transport people on latest taxi cap whose aim is to provide comfortable, reliable, timely, and safe cab services by using computer aided dispatch. KABUL MINICAB will provide complete taxi cab services using the latest equipment and technology to facilitate the travel of individuals in and around the Kabul area. Answering this survey will help us to provide you the best Taxi services which you have never experience in Kabul City.

4

3

2

1

1. I use taxi for my personal travel.

SA

AG

DK

DA

2. I use taxi for my professional travel.

SA

AG

DK

DA

3. I am using taxi at least twice on a week.

SA

AG

DK

DA

4. Taxi fares are reasonable in Kabul city?

SA

AG

DK

DA

5. I have experienced difficulty with the availability of taxi.

SA

AG

DK

DA

6. I have experienced comfort and safe while traveling on taxi.

SA

AG

DK

DA

SA

AG

DK

DA

SA

AG

DK

DA

SA

AG

DK

DA

7. The Kabul taxi cleanliness, driver attitude and presentation in general Isgood. 8. The vehicles currently use for taxi services are impressive. 9. Would you be interested by providing you reliable, timely, And safe cab services by using computer aided dispatch.

Abbreviations: SA -

Strongly Agree

AG-

Agree

DK-

Don’t Know

DA-

Disagree

Thank you for giving your precious time in answering this Questionnaire

45