BUSINESS PLAN UNILAK MOTORS UK LIMITED “Our plans miscarry because they have no aim.” (Seneca)
UNILAK MOTORS UK LTD
BUSINESS PLAN
Table of Contents Page 1. Executive Summary a. Mission Statement b. Character & Location c. Main Objectives d. Management team 2. General Company Description a. Organizational Structure b. Key Advantages c. Business Goal 3. Marketing Plan a. Current Product Mix b. Marketing Goals c. Marketing Strategy d. SWOT Analysis 4. Project Development a. Development Process b. Project Plan c. Project Cost Summary 5. Financial Plan a. The Investment Budget b. Assumptions c. Financial Projections
1
2
3
6
9
11
UNILAK MOTORS UK LTD
BUSINESS PLAN
EXECUTIVE SUMMARY Mission Statement Unilak Motors UK Limited is committed to provide vehicles to their valued customers, which could fulfil their wants & need at the right price. Together, excellent customer care along with vast knowledge of auto industry, company management is proud to establish a successful business within short period of one year and has aimed to take it to the next level of investment.
Character & Location Unilak Motors UK Limited was formed in March 2010, with a view to be established as a successful business within west midlands. Since start of the business company have seen its used cars sales rising on monthly basis. Opportunity of a functional maintenance workshop and a car wash alongside the main showroom have raised sales and loyal customer base from the community. Showroom of the company is located on Bromford Lane which is only 3 miles away from Junction 5 & 6 of M6 Motorway, thus accessible to the surrounding areas of Birmingham. Company have fully functional workshop where all kind of mechanical and body repair works are undertaken. Other uses of workshop is to check used cars bought for resale, run a check list and maintain the quality of vehicles sold to end consumer. In house maintenance team have significant effect on the reduction of cost thus maximizing the profits and maintaining prices with other competitors in area.
Main Objective Unilak Motors UK Limited started business selling used vehicles. Management team have planned it to take it to next level, by having an alliance with a main stream world car manufacturer and start selling new cars. Though the market for used cars is on the rise due to the state of economy but on the other hand due to innovations in technology and fuel efficient new cars are selling in wide range. Management have done its market research and have seen new cars sale rising with the passage of time. Plan to have a dealership of Mitsubishi Motors is implementation of the business model, which was originally planned at the inception of business.
Management Team Unilak Motors UK Limited has three experienced and energetic directors. They have a life long experience in car sales, vehicle maintenance, workshop operations and business management. Mr. Madhura Manawickrama professionally a consultant doctor at NHS has experience in administration and business management. He has the core responsibility of setting up the business, its development, planning operations and maintaining finances of the company. Mr. Manawickrama is a highly organised person and takes his responsibilities professionally and proudly. Mr. Talat Riaz, a graduate in business administration has over seven years of experience in car sales. He has gained experience and achieved record sales for his previous employers. His selling techniques are second to none. Maintenance of quality is his priority and selling a quality product is his art. Mr. Riaz’s hard work has resulted in as growth of the business and excellence to achieve its profiled targets. Mr. Raja Usman, contributes his efforts as maintenance man of the business. He has a degree in business & economics but having experience in cars and maintenance over a period of 10 years, has given company an established resource to reduce costs and maintain the quality of their cars. Mr. Usman is also helping hand in purchasing and valuation of part exchange vehicles. His work is major and can be regarded as backbone of the operational structure.
2
BUSINESS PLAN
UNILAK MOTORS UK LTD
GENERAL COMPANY DESCRIPTION Organizational Structure Unilak Motors UK Limited since its incorporation have seen a high rise in the sale of used cars and maintenance is a day to day job for used cars, not only to maintain quality but also to provide due care towards safety of the customers. Directors of the company have undertaken the jobs and responsibilities of the management and operations of the company. There is currently two full time staff employed by the company and work as mechanics in the workshop. Now due to expansion as if the business milestone towards dealership is achieved, management has planned to hire following staff immediately before the opening of business to fulfil the needs of the business. 1. Administration Staff a. Reception Staff b. Accountant c. Cleaner 2. Sales Staff a. Sales Supervisor b. Sales Representative 3. Service Staff a. Diagnostics Manager b. Parts Manager c. Service Mechanics
01 01 01 01 02 01 01 02
Company have already service mechanics, and it will arrange for proper training and development for the service staff if needed for Mitsubishi Motors. Sales supervisor & parts manager will be hired initially on a part time basis and will become full time by month six of first year of trading. Management intend to organise the business structure in the following way. Managing Director Mr. Manawickrama
Sales Director Mr. Riaz
Service Director Mr. Usman
Sales Supervisor Diagnostic Manager Sales Representative 1
Sales Representative 2
Parts Manager Mechanic 1 Mechanic 2
Administration
Finance
Operations Used Car Purchase
3
BUSINESS PLAN
UNILAK MOTORS UK LTD
In subsequent years management indent to employee more staff as per following head count matrix. Staff Grade
Year 1
Year 2
Year 3
Year 4
Year 5
01
01
02
02
03
01
01
02
02
02
Operations
0
01
01
01
01
Supervisor
01
02
02
02
03
Representative
02
02
04
04
04
Assistants
0
01
01
02
02
Diagnostics
01
01
02
02
02
Mechanics
02
02
03
04
04
MOT Engineers
0
0
02
02
02
Purchase
0
01
01
01
01
Spare Parts
01
01
01
01
01
Reception Administration Accounts
Sales
Service
Procurement
Unilak Management have plans to develop a fully integrated MOT centre by year three of trading and will hire VOSA qualified engineers for running MOT centre. Cost has been established and it is integrated within the capital expenditure in year three.
Key Advantages Unilak Motors UK Limited has seen exceptional rise in sales and business during the past year. Economic downturn and overall reduction in economy have changed people trend to buy used cars in the past years. Introduction of scrap scheme by the government of UK back in 2008-09 somehow ease the pressure on the sales of used cars but alongside consumer have developed taste for fuel efficient and modern cars. Besides macro advantage of become a dealer of Mitsubishi motors, there are many other factors which make Unilak stand high in the competitive market of car sales. Management takes advantage of the following ‘as is’ factors and consider them a valuable natural resource for the high sales and success of the company. 1. Location of the business plays a vital role in its success. Unilak is situated right in the centre of an area where other company car showrooms are present. Customers have enjoyed variety of prices by comparing both new cars from other dealers in the area and a product mix of Unilak. This opportunity has boosted the sales of Unilak. 2. Ease of access to the showroom and not being on a junction; have made significance importance of the location. Customers are compelled to view cars of Unilak first before they visit any other garage. This advantage is fully utilised by the sales staff to maximum and no customer is left unattended. 3. Mechanical and body repair workshop is another advantage, where customers enjoy lower quotes and they are guaranteed full satisfaction. This enables customers to look around for a car of their choice and this has an impact of an increase in sales. 4. Cars sold by Unilak are guaranteed a cost effective service. Presence of workshop with two ramps makes service quick and cost effective.
4
BUSINESS PLAN
UNILAK MOTORS UK LTD
Management have agreed to include following factors as Key Advantages while taking on the dealership of Mitsubishi Motors. 1. There are ten car dealers including Mazda & Nissan within 1.5 miles radius of the location of company. A presence of a new brand will compel customers to come and see the new models of Mitsubishi. 2. Mitsubishi Motors have two dealers in Birmingham area which are around 11 miles away from the location of Unilak. Key advantage of having a big customer base with 6 miles radius will automatically boost sales. 3. Old customers of Unilak, if by choice want to by a new car they can part exchange their old car and that amount can be treated as deposit for finance if needed. Management have made provisions in the financials for this arrangement. 4. Mitsubishi Motors have seen an increase of 10% in sales in 2010 with total units of 12,209 sold in UK. Market share has been 0.6% which is promising for imported cars. In 2011 due to earthquake in Japan, car sales dropped domestically and it had an effect internationally as well. Now sales have been picking up as seen from the following data obtained from Japanese Automobile Manufacturer Association. Mitsubishi Passenger Cars UK Import Period
Standard
Small
Mini
Total
Apr 2010 – Jun 2010
24,667
4,452
29,209
Jul 2010 – Sep 2010
18,470
3,874
22,614
Oct 2010 – Dec 2010
19,372
8,457
150
27,979
Jan 2011 – Mar 2011
17,669
4,701
50
22,420
5. Mitsubishi new innovated electric 660cc vehicle i-MIEV has zero CO2 g/km emissions and as announced by UK Government this model is entitled to a 25% discount off the list price. This makes Mitsubishi one of five car manufacturers who are currently enjoying the fruits of this discount. 6. Close ties of Mitsubishi with Europe for supply of engines to Diamler (Germany) and finished vehicles to Peugeot makes it a world class manufacturer in automotive industry. Technical support for procurement of parts for local production and evaluation of parts being present in UK are the advantages that Unilak can enjoy for after sales service and complying with manufacturer warranties.
Business Goal With New Year approaching Unilak is committed to initiate S.M.A.R.T* road map for their business and achieve targets set forth in this business plan. Used car sales will be targeted as facilitator to sell new cars. Price comparison is not a match but domestic budgets and affordability of consumers can be highlighted along with fuel efficiency and free manufacturer warranty in selling approach while discussing finance and monthly payments on new cars. Of course the low interest rate will be one of the main factors encouraging customers to get a new Mitsubishi car on finance with low monthly payments. Management understands that group meetings and resolutions are not goals and know new business goals must also involve clear thinking about the action steps required to accomplish targets in a clear cut time frame. Keeping the above rules in view management set froths following targets for the business.
5
BUSINESS PLAN
UNILAK MOTORS UK LTD
1. The territory is worth 200 Mitsubishi Cars per annum once business is established and management with proper advertising and prominent loyal customer base is committed to achieve this target in year four of trading. 2. Currently Unilak sells 20-25 used cars a month. With the inception of new Mitsubishi cars, used car sales will be 20-22 cars a month along with six new Mitsubishi cars sold monthly. 3. Parts sale of vehicles which include accessories is a big market and worth £37.00 of parts and £750.00 of accessories per car will be sold to customers buying new Mitsubishi cars. 4. After sales service and customer satisfaction surveys will be taken out each quarter to ensure and maintain high quality of business ethics and sales approach. Following table gives a snapshot of sales of new and used cars per year during the next five years. Car Sales
Year 1
Year 2
Year 3
Year 4
Year 5
70
245
300
380
450
26
95
125
200
270
Q1
Q2
Q3
Q4
Used Cars
66
68
65
New Cars
18
20
24
* Specific, Measurable, Attainable, Realistic, Time Based
MARKETING PLAN Current Product Mix Automotive industry specifically when it comes to used car sales, specifically changes every now and then and shifts the taste of consumers. From bestselling to worst selling cars and written off to slightly damaged vehicles, used car sales are dependent on the cars presented for auctions in a year. Due to changing business environment, along with other factors like fuel prices, road tax, spare parts availability, mileage on the cars and availability of best selling cars through auctions, put car dealers in a constant struggle to get a better deal in order to maximise profits. Unilak over the past period have successfully attained its market share within this constant changing business environment. Management have adapted to different techniques to have a range of vehicles at the showroom which are best selling and their strategy have proven to meet its targets in past. Unilak have a range of different passenger vehicles of different brands including seven seat’s and family cars. Unilak have neither confined itself to a specific brand nor to a specific engine size. Unilak have seen an increase in the sale which in turn has helped to maintain cash flow of the company. Management of the company do a monthly review of their stock and market prices in order to maintain its sales targets. This also helps in drafting the forecast for purchase of used vehicles and ascertains used vehicle trade in values. Unilak is committed to maintain its current sales and increase it alongside new Mitsubishi Car sales.
6
UNILAK MOTORS UK LTD
BUSINESS PLAN
Marketing Goals Unilak management have set forth its marketing goals based on ‘Unique Selling Propositions’. Promoting USP’s will give incredible market advantage and can create a huge growth in business. Understanding consumer needs and ensuring that it is articulated in marketing message will boost the sales. Marketing goals have been carefully thought on in conjunction with business goals and Advertising and Promotion Budgets. Unilak Management is committed to achieve following goals within first two quarters of trading. 1. 2. 3. 4. 5. 6.
Spreading out word of presence of Mitsubishi Motors in area. Increase Mitsubishi Car awareness among targeted customers within region. Inform targeted customers about features and benefits of Mitsubishi cars. Spread out word on competitive and quality advantage of Mitsubishi Cars. Promotion of after sales service and on site workshop to build consumer confidence. Recognizing when proposition is working and marketing it fast, first and aggressively in sector to achieve an unassailable lead over competitors.
After first two quarters advertising budgets have been setup to ensure that consumers are constantly reminded of the presence of Mitsubishi Motors. Once marketing strategy is tested, budget will be increased to 50% of last year spent in order to increase sales.
Marketing Strategy Marketing is the major key to a dealership success. Unilak management has brain stormed on marketing strategy. It has compiled every detail for the last year which includes customer needs and market research data. Keeping in view of the Mitsubishi brand introduction and consumer’s taste of new cars, a comprehensive marketing strategy is designed to achieve goals and objectives. Different advertising segments have been chosen as to target different communities within the target areas. Following principals have been set forth as commandments’ for designing advertising material and communicating it to future customers. a. Promotion of New Mitsubishi cars along with range of services provided by the business. No promotion will be left out as service only. b. Advertising for spreading the word out will be closely watched and monitored and results will be calculated as response from the customers. c. Public relations will be of much importance. Contacting existing customer base will draw attention to the new look of the business and thus will have an impact on marketing by word of mouth. d. Instead of persuading prospects, marketing will be targeted to find genuine prospects. e. Contacting prospects when they think of a car instead contacting them when they are in for an inquiry about a car. This means tracking and managing data imaginatively. f. Advertising should target customers and sales team should make extra effort to close the deal. These results will be monitored quarterly basis and forecast will be updated accordingly. Keeping in view above mentioned principals Unilak Management have set aside £15,000.00 in addition to current spent of £1,800 per month, for the first year and it will be increased in the next three years by 50%. This amount is in addition to the £20,000 offered by Mitsubishi Motors for promotion of their brand in the targeted area.
7
BUSINESS PLAN
UNILAK MOTORS UK LTD
Distribution of budget to different sectors in advertising media will be as follows. Year 1
Year 2
Year 3
Year 4
Year 5
Weekly Newspaper
15%
20%
20%
20%
20%
Radio & TV
25%
30%
30%
50%
50%
Give Outs
10%
10%
10%
10%
10%
Online SEO
50%
40%
40%
20%
10%
SWOT Analysis Unilak management recognises the importance of SWOT analysis. With the fast changing world of automotive industry together with the economic factors effecting sales of used and new cars, Unilak operations has been put to the test. An honest and excellent research into SWOT has enabled the company and team to achieve its targets and strengthen its weaknesses and abolish threats with the passage of time. Internal factors of SWOT are determined as follows: Strengths:
Excellent Location, near to the motorway M6. Situated on main Bromford Lane. Established and prominent loyal customer base. Fully equipped mechanical and service workshop. Large variety of Used Cars available at the garage. Trained and efficient sales and after sale service staff.
Weakness:
Increase in Used car sales business established locally. Lack of used cars stock, as best selling used cars have become harder to find. Closure of local auction business, an increase in the cost of transportation of cars.
External factors effecting business can be listed as below: Opportunities: Middle income families within locality are targeted customers. Brand ambassador for Mitsubishi Motors in Birmingham. Variety of new models of Mitsubishi Motors including i-MiEV. As a Mitsubishi Dealer target locality of six miles radius. Threats:
Economic conditions and European markets downturn. Rising fuel prices may affect sales. Innovation of new models by Toyota & Nissan.
Besides that there are weakness of having lack of used cars stock but Management is determined to overcome by registering online with different auction houses and purchase used stock online. This will enable to reduce the cost significantly.
8
BUSINESS PLAN
UNILAK MOTORS UK LTD
By having Mitsubishi Motors on board company will see an increase in used car sales as trade in cars will be sold after proper servicing and care. Along side showroom sales, online sales will be boosted as marketing plan is implemented. Unilak is currently selling cars on Auto trader, one of the large online selling sites for used cars. If there is a choice of buying new cars prospective clients will trade in old car for cash or even as for a deposit for new car. This action will help in increasing the number of used car sales.
Development Plan Development Process Unilak Management has carefully drafted business development plan with the help of Chartered Building Surveyors and Project Managers. Time schedules being drafted and cost of building along with regulations needed to be followed before and during the development of the project. Management have drafted a flow chart for the building and structural works to be done on the site, to be followed as below.
Planning Permission 8 Weeks
Start of Project
Chartered Surveyor & Project planning coordinator appointed
Building Regulations 5 Weeks
Tenders & Contractors Quotations 5 Weeks
Award of Contract
Principal Contractor reports
Demolition Process
Sub Structure Building
Structural Frame
External Cladding
Time Frame: 24 Weeks
Roof & Finishing
WC & Kitchen
Mechanical & Electrical
End of Project
All stages of the project have been designed in a way so that the targets are met within time schedules assigned. Unilak management have already ascertained the cost of construction through various quotes from Chartered Surveyors and Building Contractors. These measures will same significant time once the project has been started.
9
BUSINESS PLAN
UNILAK MOTORS UK LTD
Project Plan Unilak Management has taken following decisions while construction is underway. This will help the company to maintain its sales during this time period and will not affect the normal operations of the company. 1. Area of the garage is more than enough to maintain 25-30 cars on site while building work is being done on the front. A sign posted ‘Business as usual’ on the road and current continuity of advertising campaigns will maintain sales of the company.
2. Company management have planned to subcontract its maintenance services to a garage just 500 yards away from the site. Management have first priority to complete its new workshop structure and that will start as soon as all regulatory requirements have completed. 3. Workshop Structure has been designed to be completely autonomous of other building structure. MOT centre will be established in year three, so there will be enough room for the cars to be stored for repairs and service. Unilak Management has drafted following mile stones to plan their project.
Application for Mitsubishi Dealership
Mitsubishi Finance
Directors Equity Induction
Approved
Not Approved
Purchase Land Lease 20 Years
Application for Bank Finance
Revised Application & Resubmission
Approved
Not Approved
Building works
Unilak management have letter of intent from Mitsubishi motors’ that they will do a partnership induction of £50,000 towards building cost upon the approval of application. Land lease have been negotiated and will be transferred to the company as soon as the application is passed.
10
BUSINESS PLAN
UNILAK MOTORS UK LTD
Project Cost Summary Unilak have adopted itself to the quality cautious available option for construction of building and service bays. As quoted by the Chartered Building Surveyors Building cost will be in the region of £260,000 when showroom height is maximum to 3.6 meters. Following is the breakdown cost of capital investment in building & works. 1. 2. 3. 4. 5. 6. 7. 8.
Demolition Substructure Structural Frame External Cladding Roof & Finishing WC & Kitchen Mechanical & Electrical Works Drainage
£ 15,000.00 £ 40,000.00 £ 45,000.00 £ 55,000.00 £ 75,000.00 £ 5,000.00 £ 20,000.00 £ 5,000.00
Management have decided to start MOT centre in year three of trading and additional cost of MOT centre is estimated at £20,000.00. This includes VOSA approved software system to check vehicles and produce MOT certificates.
Financial Plan The Investment Budget Unilak management have drafted a financial plan with carefully thought assumptions drawn from analysing data of past year financial performance and comparing it with relevant industry financial ratios. They have kept the revenue overheads near to realistic and capital structure have been revised to include existing stock of used cars. Used car stock as of year ending 30th October 2011 stands at £149,000. Current facilities of workshop like ramps and tools, which will be utilised, value to £15,000.00. Addition to the above stock and assets shareholders have decided to contribute £ 160,000.00 towards the business in order to compete as centre for excellence for Mitsubishi Motors. A snapshot of total invested budget (start-up capital) of business including previous fixed assets can be summarised as follows. Existing Used Car Stock
£ 149,000
Existing Workshop Machinery & Tools
£ 15,000
Cash in Hand & at Bank
£ 45,000
Directors proposed investment in business
£ 160,000
Mitsubishi Partnership Finance for building
£ 50,000
Bank Loan
£ 50,000
11
BUSINESS PLAN
UNILAK MOTORS UK LTD Allocation of start-up capital will be as follows. Land Lease Expenses (Security + Legal Cost) Building Works Furniture & Fixture First Month Expenses Start-up Cash
£ 4,000 £ 260,000 £ 5,000 £ 31,500 £ 4,500
Assumptions Financial plan and projections have been based on assumptions carefully drawn from historical financial data of business and including industry research of different setups of company dealerships within west midlands. Sales and gross profit assumptions have been mentioned in Business Goals and additional information is been provided below. An uplift ratio is added to the sales of service, repair and MOT sales for 2-5 years in financial projections. Revenue Assumptions Year 1
Year 2
Year 3
Year 4
Year 5
New Car Used Car New Car Used Car New Car Used Car New Car Used Car New Car Used Car
Sales (Units) 88 269 95 245 125 300 200 380 270 470
Parts £37.00 per car 5% of car sales £38.40 per car 5% of car sales £39.90 per car 5% of car sales £41.50 per car 5% of car sales £43.20 per car 5% of car sales
Accessory
Services & Repairs
£750 Per car -
20% of car sales
£780 Per car -
20% of car sales
£811 Per car £844 Per car £877 Per car -
20% of car sales £ 150 per car 20% of car sales £ 150 per car 20% of car sales
MOT Sales
-
150 Cars Per month 200 Cars Per month 250 Cars Per month
Gross Profit Cars
Parts
15%
30%
18%
5%
15%
30%
18%
5%
15%
30%
18%
5%
15%
30%
18%
5%
15%
30%
18%
5%
Accessory 70%
Service -
-
-
60%
70%
-
-
60%
70%
-
-
60%
70%
60%
-
60%
70%
60%
-
60%
Salaries & Wages are summarised as selling and support. Selling and service personal salaries are charged to cost of sales. Table of basic salaries has been drawn keeping in view changing minimum wage over period of five years. A bonus scheme for achieving sales targets will be started in year two of trading to motivate the staff. Sales staff will be offered positions on basic and commission on sales deals closed. Selling & administrative expenses have been calculated as a percentage of the turnover as per normal industry practice to maintain gross profits for budgeting.
12
MOT
-
60%
60%
60%
Unilak Motors (UK) Limited Projected Trading and Profit & Loss Account Year 1
Year 2
Year 3
Year 4
Year 5
901,735 1,060,646 48,328 66,000 180,347 2,257,056
991,909 1,140,000 49,866 74,100 198,382 2,454,256
1,091,099 1,501,400 54,825 101,375 300,280 63,000 3,111,979
1,200,209 2,410,895 60,281 168,800 270,042 84,000 4,194,227
1,500,262 3,013,619 75,283 236,790 340,552 105,000 5,271,506
153,690 136,835 9,420 1,251 301,196 155,740 145,456
149,000 1,603,083 113,040 18,035 1,883,158 155,740 1,727,418
155,740 1,740,331 132,160 19,838 2,048,070 165,270 1,882,800
165,270 2,118,226 269,646 30,028 2,583,170 172,540 2,410,630
172,540 2,954,702 321,783 27,004 3,476,028 185,420 3,290,608
185,420 3,701,070 354,076 34,055 4,274,622 200,100 4,074,522
42,686
44,359
529,638
571,456
701,350
903,618
1,196,984
4,500 3,501 821 2,083 666 250 800 75 100 150 150 250 85 350 500 4,800 300 19,381
4,500 3,501 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 300 16,381
4,500 3,501 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 300 16,381
54,000 42,012 9,852 24,996 7,992 3,000 9,600 900 1,200 1,800 1,200 2,000 1,020 4,200 8,000 36,600 500 3,600 212,472
60,000 73,273 14,812 28,745 9,191 3,450 11,040 1,035 1,380 2,070 1,380 2,300 1,173 4,830 9,200 40,260 575 4,140 268,854
84,000 108,698 22,541 33,057 10,569 3,968 12,696 1,190 1,587 2,381 1,587 2,645 1,349 5,555 10,580 46,299 5,000 4,761 358,462
120,000 114,133 32,677 39,669 12,683 4,761 15,235 1,428 1,904 2,857 1,904 3,174 1,619 6,665 12,696 64,819 500 5,713 442,437
150,000 135,894 39,212 47,602 15,220 5,713 18,282 1,714 2,285 3,428 2,285 3,809 1,942 7,998 15,235 77,782 500 6,856 535,759
24,903
33,462
26,305
27,978
317,166
302,602
342,888
461,181
661,225
329 417 746
329 417 746
329 417 746
329 417 746
329 417 746
3,950 5,000 8,950
3,950 5,000 8,950
3,950 9,600 13,550
3,950 9,600 13,550
3,950 9,600 13,550
26,241
31,635
24,157
32,715
25,559
27,232
308,216
293,652
329,338
447,631
647,675
5,511 20,731
6,643 24,991
5,073 19,084
6,870 25,845
5,367 20,191
5,719 21,513
64,725 243,491
61,667 231,985
69,161 260,177
94,003 353,628
136,012 511,663
1
2
3
4
5
6
7
8
9
10
11
12
Used Cars New Cars Parts Accessory Services & Repair MOT Sales
65,842 72,500 3,562 4,500 13,168 159,573
78,541 71,540 4,197 4,500 15,708 174,486
76,154 72,580 4,078 4,500 15,231 172,543
80,200 80,254 4,280 5,000 16,040 185,774
81,247 80,143 4,332 5,000 16,249 186,972
78,554 80,950 4,198 5,000 15,711 184,413
75,250 96,540 4,033 6,000 15,050 196,873
74,127 96,147 3,976 6,000 14,825 195,076
75,140 96,342 4,027 6,000 15,028 196,537
81,600 104,250 4,350 6,500 16,320 213,020
72,540 104,530 3,897 6,500 14,508 201,975
62,540 104,870 3,397 6,500 12,508 189,815
Opening Stock Purchases Salaries & Wages Workshop & Car Consumables
149,000 113,022 9,420 1,317 272,759 151,427 121,332
151,427 122,572 9,420 1,571 284,990 152,411 132,579
152,411 121,465 9,420 1,523 284,819 155,471 129,348
155,471 131,041 9,420 1,604 297,536 156,874 140,662
156,874 131,803 9,420 1,625 299,722 152,711 147,011
152,711 130,261 9,420 1,571 293,963 153,471 140,492
153,471 140,348 9,420 1,505 304,744 155,240 149,504
155,240 139,121 9,420 1,483 305,264 158,950 146,314
158,950 140,100 9,420 1,503 309,973 154,720 155,253
154,720 151,826 9,420 1,632 317,598 157,420 160,178
157,420 144,688 9,420 1,451 312,979 153,690 159,289
38,241
41,907
43,195
45,112
39,961
43,921
47,368
48,762
41,284
52,843
4,500 3,501 821 2,083 666 250 800 75 100 150 85 350 2,500 5,800 500 300 22,481
4,500 3,501 821 2,083 666 250 800 75 100 150 85 350 500 1,800 300 15,981
4,500 3,501 821 2,083 666 250 800 75 100 150 85 350 500 1,800 300 15,981
4,500 3,501 821 2,083 666 250 800 75 100 150 85 350 500 5,800 300 19,981
4,500 3,501 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 300 16,381
4,500 3,501 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 300 16,381
4,500 3,501 821 2,083 666 250 800 75 100 150 150 250 85 350 500 5,800 300 20,381
4,500 3,501 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 300 16,381
4,500 3,501 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 300 16,381
15,760
25,926
27,214
25,131
23,580
27,540
26,987
32,381
329 413 742
329 417 746
329 417 746
329 417 746
329 417 746
329 417 746
329 417 746
EBT
15,017
25,180
26,468
24,385
22,834
26,794
Provision for Corporation Tax Net Profit for the period
3,154 11,864
5,288 19,892
5,558 20,909
5,121 19,264
4,795 18,039
5,627 21,167
Sales
Total Sales
Closing Stock Cost of Goods Sold Gross Profit
Total
Administrative Expenses Directors' Salaries Salaries & Wages Emploter NI & Taxes Rent Rates Insurance Utilities Water Rates Telephone Accountancy Building Repair Workshop Repair Cleaning Travelling Expenses Printing & Stationery Advertising Legal & Professional Fee Bank Charges EBITDA Interest on Loan Depriciation
Unilak Motors (UK) Limited Projected Balance Sheet Year 1
Year 2
Year 3
Year 4
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 35,000 8,000 5,000 308,000
260,000 35,000 8,000 5,000 308,000
260,000 35,000 8,000 5,000 308,000
5,000 280,000
5,000 280,000
5,000 280,000
9,600 298,400
9,600 298,400
9,600 298,400
151,190 2,500 2,716 246,248 402,654
153,240 2,500 19,644 182,058 357,442
153,240 2,500 19,644 182,058 357,441
162,270 3,000 27,170 339,512 531,953
168,940 3,600 53,020 559,019 784,579
181,100 4,320 6,855 899,368 1,091,643
194,916 5,184 35,046 1,395,951 1,631,097
140,348 139,121 140,100 151,826 144,688 21,756 18,729 22,822 20,967 30,472 305,000 275,000 275,000 245,000 245,000 467,104 432,851 437,923 417,793 420,160 105,953 - 81,378 - 62,710 - 37,281 - 17,506
136,835 2,016 215,000 353,851 3,591
136,835 2,016 215,000 353,851 3,590
145,028 6,249 155,000 306,277 225,676
176,519 5,508 145,000 327,027 457,552
246,225 44,137 290,362 801,280
308,423 19,631 328,053 1,303,044
40,833
40,000
40,000
30,000
20,000
10,000
0
201,887
222,078
243,591
243,591
475,676
735,952
1,089,680
1,601,444
156,957
176,041
201,886
222,078
19,084 176,041
25,845 201,886
20,191 222,078
21,513 243,591
100 243,491 243,591
243,591 100 231,985 475,675
475,675 100 260,177 735,952
735,952 100 353,628 1,089,681
1,089,681 100 511,663 1,601,444
1
2
3
4
5
6
7
8
9
10
11
12
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
260,000 15,000 5,000 5,000 285,000
413 284,587
830 284,170
1,247 283,753
1,664 283,336
2,081 282,919
2,498 282,502
2,915 282,085
3,332 281,668
3,749 281,251
4,166 280,834
4,583 280,417
148,927 2,500 6,716 46,708 204,851
149,911 2,500 3,042 70,488 225,941
152,971 2,500 3,697 93,479 252,647
154,374 2,500 8,682 116,044 281,600
150,211 2,500 5,996 142,624 301,331
150,971 2,500 7,640 168,242 329,353
152,740 2,500 13,614 192,298 361,152
156,450 2,500 2,716 189,806 351,472
152,220 2,500 2,716 217,777 375,213
154,920 2,500 5,716 217,376 380,512
113,022 10,285 305,000 428,307 - 223,457 -
122,572 2,349 305,000 429,921 203,981 -
121,465 9,670 305,000 436,135 183,488 -
131,041 10,199 305,000 446,240 164,640 -
131,803 11,546 305,000 448,349 147,018 -
130,261 20,359 305,000 455,620 126,267 -
Long Term Liabilities Bank Loan
49,167
48,333
47,500
46,667
45,833
45,000
44,167
43,333
42,500
41,667
Net Assets
11,964
31,856
52,765
72,029
90,068
111,235
131,966
156,957
176,041
100 11,864 11,964
11,964
31,856
52,766
72,029
90,068
111,235
131,966
19,892 31,856
20,909 52,766
19,264 72,029
18,039 90,068
21,167 111,235
20,731 131,966
24,991 156,957
Tangible Assets Land & Building Mechanical Assets Furniture & Fixture Parts & Tools Depriciation Net Book Value Current Assets Stock - Old Cars Stock Spares & Tolls Prepayments Cash In Hand & Bank
Current Libilities Trade Creditors Accrued Expenses Directors Loan Account Net Current Assets
CAPITAL ACCOUNT Brought Forward Share Capital Profit & Loss Account
Year 1
Year 5
Unilak Motors (UK) Limited Projected Cash Flow 0 Opening Balance B/F
Year 1 1
2
3
4
5
6
7
8
9
10
11
12
Year 1
Year 2
Year 3
Year 4
Year 5
45,000
34,538
46,708
70,488
93,479
116,044
142,624
168,242
192,298
189,806
217,777
217,376
246,248
34,538
182,058
339,512
559,019
899,368
50,000 160,000 50,000 260,000
159,573
174,486
172,543
185,774
186,972
184,413
196,873
195,076
196,537
213,020
201,975
189,815
2,454,256
3,111,979
4,194,227
5,271,506
159,573
174,486
172,543
185,774
186,972
184,413
196,873
195,076
196,537
213,020
201,975
189,815
2,257,056 2,257,056
2,454,256
3,111,979
4,194,227
5,271,506
4,000 329
114,339 4,500 12,921 821 2,083 666 250 800 75 100 150 85 350 2,500 5,800 500 329
124,143 4,500 12,921 821 2,083 666 250 800 75 100 150 85 350 500 1,800 329
122,988 4,500 12,921 821 2,083 666 250 800 75 100 150 85 350 500 1,800 329
132,645 4,500 12,921 821 2,083 666 250 800 75 100 150 85 350 500 5,800 329
133,428 4,500 12,921 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 329
131,832 4,500 12,921 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 329
141,853 4,500 12,921 821 2,083 666 250 800 75 100 150 150 250 85 350 500 5,800 329
140,604 4,500 12,921 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 329
141,603 4,500 12,921 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 329
153,458 4,500 12,921 821 2,083 666 250 800 75 100 150 150 250 85 350 500 4,800 329
146,139 4,500 12,921 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 329
300 4,629
300 146,569
300 149,873
300 148,718
300 162,375
300 159,558
300 157,962
300 171,983
300 166,734
300 167,733
300 182,588
300 172,269
138,086 4,500 12,921 821 2,083 666 250 800 75 100 150 150 250 85 350 500 1,800 329 58,956 300 223,172
1,621,118 54,000 155,052 9,852 24,996 7,992 3,000 9,600 900 1,200 1,800 1,200 2,000 1,020 4,200 8,000 36,600 500 3,950 58,956 3,600 2,009,536
1,760,169 60,000 205,434 14,812 28,745 9,191 3,450 11,040 1,035 1,380 2,070 1,380 2,300 1,173 4,830 9,200 40,260 575 3,950 61,667 4,140 2,226,801
2,148,254 84,000 378,343 22,541 33,057 10,569 3,968 12,696 1,190 1,587 2,381 1,587 2,645 1,349 5,555 10,580 46,299 5,000 3,950 69,161 4,761 2,849,473
2,981,706 120,000 435,915 32,677 39,669 12,683 4,761 15,235 1,428 1,904 2,857 1,904 3,174 1,619 6,665 12,696 64,819 500 3,950 94,003 5,713 3,843,878
3,735,125 150,000 489,970 39,212 47,602 15,220 5,713 18,282 1,714 2,285 3,428 2,285 3,809 1,942 7,998 15,235 77,782 500 3,950 136,012 6,856 4,764,923
10,000 10,000
10,000 10,000
899,368
1,395,951
RECEIPTS Sales Mitsubishi Funding Director Loan Bank Loan
REVENUE EXPENDITURE Purchases Directros Remuneration Salaries & Wages
Emploter NI & Taxes Rent Rates Insurance Utilities Water Rates Telephone Accountancy Building Repair Workshop Repair Cleaning Travelling Expenses Printing & Stationery Advertising Legal & Professional Fee Interest On Loan Corporation Tax Bank Charges
CAPITAL EXPENDITURE Land & Building Plant & Machinery Furniture & Fixture Director Loan Repayment Capital Payment - Loan
Closing Balance C/F
260,000 5,000 833 265,833
833 833
833 833
833 833
833 833
833 833
833 833
833 833
30,000 833 30,833
833 833
30,000 833 30,833
833 833
30,000 833 30,833
90,000 10,000 100,000
60,000 10,000 70,000
20,000 3,000 10,000 10,000 43,000
34,538
46,708
70,488
93,479
116,044
142,624
168,242
192,298
189,806
217,777
217,376
246,248
182,058
182,058
339,512
559,019