Taxi Car

Download as pdf or txt
Download as pdf or txt
You are on page 1of 22

2023

PROJECT
REPORT

Taxi car
finline address
Project at a glance

Name & Address of Unit

Taxi car
finline address ,123456

Activity : Taxi car

Email : sample@finline.in

Phone : 1234567891

Constitution : Proprietorship

Scheme : sme

Number of employment : 5

Total project cost : 12,50,000.00

Fixed Capital : 10,00,000.00

Working Capital : 2,50,000.00

Total Bank loan : 9,50,000.00

Promoter(s) contribution : 3,00,000.00

Term loan : 7,50,000.00 Interest : 11.00 %

Working capital loan : 2,00,000.00 Interest : 11.00 %

Name & address of promoter(s)

Name : finline sample project

Address : finline address

Phone : 1234567891

Designation : Founder

Category : na

E-mail : sample@finline.in
Project Feasibility Ratio

Debt Service Coverage Ratio (Average) : 4.36

Current ratio (Average) : 8.65

Year 1 Year 2 Year 3 Year 4 Year 5

Current ratio 2.53 5.37 8.58 11.65 15.10

Quick ratio 2.53 5.37 8.58 11.65 15.10

Interest coverage ratio 10.05 10.18 13.20 18.14 27.65

Debt equity ratio 1.53 0.61 0.31 0.17 0.08

TOL/TNW 1.53 0.61 0.31 0.17 0.08

DSCR 4.92 3.90 4.28 4.13 4.52

Gross profit Sales Percentage % 26.65 % 26.65 % 26.65 % 26.65 % 26.65 %

Net profit Sales Percentage % 21.60 % 19.22 % 19.70 % 17.62 % 17.98 %

Return On Capital Employed 0.25 0.46 0.38 0.35 0.32

Net profit Sales % Quick ratio


Project Feasibility graph
Revenue v/s Expense

Expense Splitup
Introduction

The taxi market has gained prominence over the last 2-3 years, in the backdrop of the entry of app-based
aggregators which has not only disrupted the auto-rickshaw and traditional taxi market but also forced
automotive OEMs to revise their growth and marketing strategies. A report released by ICRA stated that the
Indian passenger vehicle industry is likely to ride on the strong growth potential of the domestic taxi segment
in the near term, whereas medium to long term growth will be supported by low car penetration level and
increasing income level. “Considering strong demand and increasing penetration of such players in a smaller
town, the Indian taxi market is poised for robust double-digit growth over next 2-3 years. In FY2016, fleet sales
(including cab aggregators) accounted ~9 percent of Indian PV sales, which is expected to reach 15 per
cent-17 percent level by FY2020,” stated the report.

The Indian taxi market is still in the descent stage, with huge scope for growth given the low car penetration
level and poor public infrastructure. OEMs have also realized the market potential and have a dedicated sales
team to cater to fleet operators. The entry of aggregators like Ola and Uber has changed the competitive
dynamics of the taxi market which till now has largely been fragmented and has lacked bargaining power with
OEMs with even larger organized fleet operators typically having less than 500 cars. However, the aggregators
like Ola and Uber have over 25,000 cabs in the NCR market alone. Consequently, this segment within the PV
industry now enjoys significant clout, with some OEMs setting up a dedicated team to address the aggregator
market,” observed the report. The rise of the taxi segment however is expected to hit the second car purchase
in India in the near term, only in the medium term, the subsequent replacement demand for taxis will offset
such a loss.
Market potential & Strategy

The taxi market in India is estimated at $9 billion; the organized sector constitutes around 6% revenue share
of the overall market. The taxi market in India is highly fragmented and unorganized, The unorganized market
is constituted of individual car owners and agencies which operate in one or a few cities, Owned vehicles
segment includes pure-play car rental companies (e.g. Zoomcar) and players like Carzonrent and Meru,
Aggregators are a new phenomenon driven by the rise of start-ups like Ola & Uber.

First-time car buyers account for 40-45 percent of the Indian car market, and given low car penetration in
India, they are likely to remain a potent force. Similarly, the replacement segment is also expected to grow at a
robust pace given the shortening replacement cycle of a car in the Indian market. However, the cab
aggregator and taxi market pose a real challenge to the additional car buyer segment. Considering that the
customer segment already has a car, and can rely on a taxi for short run/limited usage. Given increasing
traffic woes, there is also a customer segment which will shift towards taxi usage due to additional comfort of
chauffeur driven car without paying out for driver salary. By providing better customer service and registering
with the aggregator can make the business so viable.
Project Cost
Sl. no Item Amount Rs.

1 Vehicle 10,00,000.00

2 Working Capital 2,50,000.00

Total 12,50,000.00
Working Capital Computation
Sl. no Item Amount Rs.

1 Working expense. 2,50,000.00

2 Total working capital 2,50,000.00

3 Own Contribution 50,000.00

4 Working capital loan 2,00,000.00


Annual Sales / Revenue
Sales is calculated from November 2023

Sl. no Item Rate Quantity Month Unit Total Rs.

1 Revenue from Sales 64.92 X 4200 X 5 Kilometer 13,63,375.00

Total 13,63,375.00
Total Yearly Expense
Expense is calculated from November 2023 .

Sl. no Item Amount Rs.

1 Repairs and maintenance charges 5,00,000.00

2 Purchase consumables/ spare part 5,00,000.00

Total 10,00,000.00
Application of Fund
Sl. no Item Subsidy % No. Rate Amount Rs.

1 Vehicle 0.00 1 10,00,000.00 10,00,000.00

Total Investment 10,00,000.00

Total Subsidy 0.00

Net Investment 10,00,000.00


Means of Finance
Sl. no Item Amount

1 Term Loan 7,50,000.00

2 Working capital Loan 2,00,000.00

3 Total loan 9,50,000.00

4 Promoters contribution on term loan 2,50,000.00

5 Promoters contribution on working capital loan 50,000.00


Profitability Statement
All figures are in lakhs
31/03/24 31/03/25 31/03/26 31/03/27 31/03/28

Revenue from operation

Revenue from Sales 13.63 35.99 39.59 43.55 47.90

Add :

Closing stock 0 0 0 0 0

Total 13.63 35.99 39.59 43.55 47.90

Less :

Opening stock 0 0 0 0 0

Purchase consumables/ spare part 5.00 13.20 14.52 15.97 17.56

Repairs and maintenance charges 5.00 13.20 14.52 15.97 17.56

Total 10.00 26.40 29.04 31.94 35.13

Gross profit 3.63 9.59 10.55 11.60 12.76

Less :

Total

Profit before interest, tax and depreciation 3.63 9.59 10.55 11.60 12.76

Depreciation 0 0 0 0 0

Interest on TL 0.27 0.72 0.58 0.42 0.24

Interest on WC 0.092 0.22 0.22 0.22 0.22

Profit before tax 3.27 8.65 9.75 10.96 12.30

Income Tax 0.33 1.73 1.95 3.29 3.69

Profit after tax 2.94 6.92 7.80 7.67 8.61


Cash flow statement
All figures are in lakhs
Cash Inflow Pre operative period 31/03/24 31/03/25 31/03/26 31/03/27 31/03/28
Capital 2.50 0.50 0 0 0 0
Subsidy 0 0 0 0 0 0
Termloan 7.50 0 0 0 0 0
Profit before tax with interest 0 3.63 9.59 10.55 11.60 12.76
Increase in WC loan 0 2.00 0 0 0 0
Depreciation 0 0 0 0 0 0
Increase in Current liability 0 0 0 0 0 0
Total Cash Inflow 10.00 6.13 9.59 10.55 11.60 12.76

Cash Outflow
Fixed Assets 10.00 0 0 0 0 0
Increase in Current asset 0 0 0 0 0
Interest on TL 0 0.27 0.72 0.58 0.42 0.24
Interest on WC 0 0.092 0.22 0.22 0.22 0.22
Income Tax 0 0.33 1.73 1.95 3.29 3.69
Decrease in Term loan 0.38 1.23 1.37 1.53 1.71
Drawing 0 0 0 0 0 0
Total Cash Outflow 10.00 1.07 3.90 4.12 5.46 5.86
Opening balance 0 0 5.06 10.74 17.17 23.31
Net Cashflow 0 5.06 5.68 6.42 6.14 6.89
Closing balance 0 5.06 10.74 17.17 23.31 30.21
Balance sheet
All figures are in lakhs
Liability Pre operative period As of 31/03/24 31/03/25 31/03/26 31/03/27 31/03/28

A. Share holders funds

Capital 2.50 3.00 3.00 3.00 3.00 3.00

Reserve & Surplus 0 2.94 9.86 17.66 25.34 33.96

B.Non current Liabilities

Termloan 7.50 7.11 5.88 4.50 2.96 1.25

C.Current Liabilities

Working capital loan 0 2.00 2.00 2.00 2.00 2.00

Account payable 0 0 0 0 0

Total Liability 10.00 15.06 20.74 27.17 33.31 40.21

Asset

A. Non current Assets

Fixed Assets 10.00 10.00 10.00 10.00 10.00 10.00

B. Current Assets

Inventory 0 0 0 0 0 0

Trade receivables 0 0 0 0 0 0

Cash and cash equivalence 0 5.06 10.74 17.17 23.31 30.21

Total Asset 10.00 15.06 20.74 27.17 33.31 40.21


Repayment of Term loan
All figures are in lakhs
Year Month Installment Outstanding at the beginning Principal repayment Interest Amount paid Outstanding at the end

1 Dec 2023 1 7.50 0.094 0.069 0.16 7.40

1 Jan 2024 2 7.40 0.095 0.068 0.16 7.31

1 Feb 2024 3 7.31 0.096 0.067 0.16 7.21

1 Mar 2024 4 7.21 0.097 0.066 0.16 7.11

2 Apr 2024 5 7.11 0.098 0.065 0.16 7.01

2 May 2024 6 7.01 0.099 0.064 0.16 6.92

2 Jun 2024 7 6.92 0.100 0.063 0.16 6.82

2 Jul 2024 8 6.82 0.10 0.063 0.16 6.72

2 Aug 2024 9 6.72 0.10 0.062 0.16 6.61

2 Sep 2024 10 6.61 0.10 0.061 0.16 6.51

2 Oct 2024 11 6.51 0.10 0.060 0.16 6.41

2 Nov 2024 12 6.41 0.10 0.059 0.16 6.30

2 Dec 2024 13 6.30 0.11 0.058 0.16 6.20

2 Jan 2025 14 6.20 0.11 0.057 0.16 6.09

2 Feb 2025 15 6.09 0.11 0.056 0.16 5.99

2 Mar 2025 16 5.99 0.11 0.055 0.16 5.88

3 Apr 2025 17 5.88 0.11 0.054 0.16 5.77

3 May 2025 18 5.77 0.11 0.053 0.16 5.66

3 Jun 2025 19 5.66 0.11 0.052 0.16 5.55

3 Jul 2025 20 5.55 0.11 0.051 0.16 5.43

3 Aug 2025 21 5.43 0.11 0.050 0.16 5.32

3 Sep 2025 22 5.32 0.11 0.049 0.16 5.21

3 Oct 2025 23 5.21 0.12 0.048 0.16 5.09

3 Nov 2025 24 5.09 0.12 0.047 0.16 4.98

3 Dec 2025 25 4.98 0.12 0.046 0.16 4.86

3 Jan 2026 26 4.86 0.12 0.045 0.16 4.74

3 Feb 2026 27 4.74 0.12 0.043 0.16 4.62

3 Mar 2026 28 4.62 0.12 0.042 0.16 4.50

4 Apr 2026 29 4.50 0.12 0.041 0.16 4.38

4 May 2026 30 4.38 0.12 0.040 0.16 4.26

4 Jun 2026 31 4.26 0.12 0.039 0.16 4.13

4 Jul 2026 32 4.13 0.13 0.038 0.16 4.01

4 Aug 2026 33 4.01 0.13 0.037 0.16 3.88

4 Sep 2026 34 3.88 0.13 0.036 0.16 3.75

4 Oct 2026 35 3.75 0.13 0.034 0.16 3.62

4 Nov 2026 36 3.62 0.13 0.033 0.16 3.49

4 Dec 2026 37 3.49 0.13 0.032 0.16 3.36


Year Month Installment Outstanding at the beginning Principal repayment Interest Amount paid Outstanding at the end

4 Jan 2027 38 3.36 0.13 0.031 0.16 3.23

4 Feb 2027 39 3.23 0.13 0.030 0.16 3.10

4 Mar 2027 40 3.10 0.13 0.028 0.16 2.96

5 Apr 2027 41 2.96 0.14 0.027 0.16 2.83

5 May 2027 42 2.83 0.14 0.026 0.16 2.69

5 Jun 2027 43 2.69 0.14 0.025 0.16 2.55

5 Jul 2027 44 2.55 0.14 0.023 0.16 2.41

5 Aug 2027 45 2.41 0.14 0.022 0.16 2.27

5 Sep 2027 46 2.27 0.14 0.021 0.16 2.13

5 Oct 2027 47 2.13 0.14 0.020 0.16 1.98

5 Nov 2027 48 1.98 0.14 0.018 0.16 1.84

5 Dec 2027 49 1.84 0.15 0.017 0.16 1.69

5 Jan 2028 50 1.69 0.15 0.016 0.16 1.55

5 Feb 2028 51 1.55 0.15 0.014 0.16 1.40

5 Mar 2028 52 1.40 0.15 0.013 0.16 1.25

6 Apr 2028 53 1.25 0.15 0.011 0.16 1.10

6 May 2028 54 1.10 0.15 0.010 0.16 0.95

6 Jun 2028 55 0.95 0.15 0.0087 0.16 0.79

6 Jul 2028 56 0.79 0.16 0.0073 0.16 0.64

6 Aug 2028 57 0.64 0.16 0.0058 0.16 0.48

6 Sep 2028 58 0.48 0.16 0.0044 0.16 0.32

6 Oct 2028 59 0.32 0.16 0.0029 0.16 0.16

6 Nov 2028 60 0.16 0.16 0.0015 0.16 0


Debt Service Coverage Ratio
All figures are in lakhs
Particulars 31/03/24 31/03/25 31/03/26 31/03/27 31/03/28

Receipts

a).Net Profit 2.94 6.92 7.80 7.67 8.61

b).Depreciation 0 0 0 0 0

c).Interest on termloan 0.27 0.72 0.58 0.42 0.24

Total 3.21 7.64 8.38 8.09 8.85

Repayments

a).Loan Principal 0.38 1.23 1.37 1.53 1.71

b).Interest on termloan 0.27 0.72 0.58 0.42 0.24

Total 0.65 1.95 1.95 1.95 1.95

DSCR 4.93 3.91 4.28 4.14 4.53

Average DSCR : 4.36


Depreciation
All figures are in lakhs
Particulars Rate 31/03/24 31/03/25 31/03/26 31/03/27 31/03/28

Total less depreciation 0 0 0 0 0

Total written down value 10.00 10.00 10.00 10.00 10.00


Assumption
The entire projection is based on the assumption that the sales for 5 years will be

All figures are in lakhs

31/03/24 31/03/25 31/03/26 31/03/27 31/03/28

13.63 35.99 39.59 43.55 47.91

Revenue from Sales : 3272100

Also the total expense for the firm during the projection years will be as follows

31/03/24 31/03/25 31/03/26 31/03/27 31/03/28

10.00 26.40 29.04 31.94 35.14

• The depreciation is as follows

Particulars Value

• Cost of Machinery is based on direct purchase from the market on deepest study

• Value of raw materials & utility charges as per the current market conditions

• All other assumptions are calculated based on the basis of experience of the promoter and deep study

on the working of similar model

This report is created using www.finline.in . Finline have bears no financial responsibility on or behalf of any of
the authorized signatories
Conclusion
The project as a whole describes the scope and viability of the Service industry and mainly of the financial,
technical and its market potential.The project guarantee sufficient fund to repay the loan and also give a good
return on capital investment. When analyzing the social- economic impact, this project is able to generate an
employment of 5 and above. It will cater the demand of Service and thus helps the other business entities to
increase the production and service which provide service and support to this industry. Thus more cyclic
employment and livelihood generation. So in all ways, we can conclude the project is technically and socially
viable and commercially sound too.

When we take a close look at the Debt Service Coverage Ratio (DSCR), the avg: DSCR is 4.36 : 1, which is at a
higher proposition and proposes a stable venture

The Profit and Loss shows a steady growth in profit throughout the year and the firm has a higher Current
Ratio (average) of 8.65, this shows the current assets and current liabilities are managed & balanced well.

You might also like