Auto Rickshaw - Business Plan

Business Plan - Auto Rickshaw

Month No. No. Of Days Days Lost Effective No. of Days

2010 2010 20 2 011 2011 2011 2011 Novembe Novembe Decemb Decemb Januar Januar FebruarMarc FebruarMarch h April 1 2 3 4 5 6 30 31 31 28 31 30 5 5 5 5 5 5 25 26 26 23 26 25

No. of Shifts Per Day Rate Per Shift Total Amount Per Day/Per Ricksh

2 13 0 26 0

Total No. of Rickshaw Total Amount Per Day

Cash Inflow - Per Month

2 13 0 2 60

2 13 0 2 60

2 130 2 60

2 1 13 30 2 60

2 1 13 30 26 0

1

1

1

1

1

1

26 0

2 60

2 60

2 60

2 60

2 60

6500

6760

67 6 760

5980

6760

6500

Assumptions 1) 260Rs Per Day Per Rickshaw will be realised for next 5 Years. Generally Rent Per Day 2) According to talk with Gagan (An Auto Rickshaw Driver) Rent for 24 Hours is 150 Rs. H 3) On Road Cost of Auto Rickshaw is Assumed to be 175000. According to Mr. Gagan on 4) Discount Rate is 15% 5) Permit is generally for 5 Years. Hence all the calculation are based on the assumption 6) Rate of Interest on Bank Loan is Assumed to be 10%, Realistic Assumption

2011 2011 2011 2011 2011 2011 2011 2011 20 2 012 2012 May May June June July July AugusSepte AugusSeptemb mb OctobeNovem OctobeNovembe beDec Decemb embe eJanua Januar r Februa Februar r 7 8 9 10 11 12 13 14 15 15 16 31 30 31 3 31 1 30 31 30 31 31 28 5 5 5 5 5 5 5 5 5 5 26 25 26 2 26 6 25 26 25 26 26 23 2 13 0 26 0

2 13 0 26 0

2 130 260

2 13 1 30 26 2 60

2 13 0 26 0

2 13 0 26 0

2 13 0 26 0

2 13 0 26 0

2 13 0 26 0

2 13 0 26 0

1

1

1

1

1

1

1

1

1

1

26 0

26 0

260

26 2 60

26 0

26 0

26 0

26 0

26 0

26 0

6760 6500 6760 6760

6500

6760

6500

6760

67 6 760

5980

ecrease with the age of Auto Rickshaw. ence Assumption of Realizing Rs 260 Per Day Per Rickshaw is too optimistic oad price of Auto Rickshaw is 135000 Rs. Max (including Permit). Hence taking More that we will run the assest for 5 years.

2012 ## # ## ## ## ### ## 2012 2012 2012 2012 2012 20 2 013 Marc Marc AprilMayJune AprilMayJune July Augus Augus Septemb Septemb Octobe Octobe NovembeD NovembeDecemb ecembe eJanuar Januar 17 18 19 20 21 22 23 24 25 26 27 31 30 31 30 31 31 30 31 30 31 31 5 5 5 5 5 5 5 5 5 5 5 26 25 26 25 26 26 25 26 25 26 26 2 2 2 2 2 1 3 0 13 0 1 3 0 1 3 0 13 0 2 6 0 26 0 2 6 0 2 6 0 26 0

2 13 0 26 0

2 13 0 26 0

2 13 0 26 0

2 13 0 26 0

2 13 0 26 0

2 1 30 2 60

1

1

1

1

1

1

1

2 6 0 26 0 2 6 0 2 6 0 26 0

26 0

26 0

26 0

26 0

26 0

2 60

6760 ## # ## ## ## ### ## 6760

6500

6760

6500

6760

67 6 760

1

1

1

1

Capex expenditure is too pessimistic Assumption

2013 2013 # ## ## ###### 2013 2013 2013 2013 2013 FebruarMarc AprilMayJune July Augus Septemb Octobe NovembeDecemb 28 29 30 31 32 33 34 35 36 37 38 28 31 30 31 30 31 31 30 31 30 31 5 5 5 5 5 5 5 5 5 5 5 23 26 25 26 25 26 26 25 26 25 26 2 130 260

2 130 260

2 130 260

2 130 260

2 130 260

2 130 260

1

1

1

1

1

1

260 260 260 260 260

260

260

260

260

260

5980 6760 # ## ## ###### 6760

6500

6760

6500

6760

1 260

2 2 2 2 2 130 130 130 130 130 260 260 260 260 260 1

1

1

1

2014 2014 2014 # ## ## ###### 2014 2014 2014 2014  Januar FebruarMarc AprilMayJune July Augus SeptembOctober Novemb 39 40 41 42 43 44 45 46 47 48 49 31 28 31 30 31 30 31 31 30 31 30 5 5 5 5 5 5 5 5 5 5 5 26 23 26 25 26 25 26 26 25 26 25 2 130 260

2 130 260

1

1

260

260

6760

2 2 2 2 2 130 130 130 130 130 260 260 260 260 260

2 130 260

2 130 260

2 130 260

2 130 260

1

1

1

1

1

260 260 260 260 260

260

260

260

260

5980 6760 # ## ## ###### 6760

6500

6760

6500

1

1

1

1

2014 2015 2015 2015 2015 2015 2015 2015 Decemb January FebruaryMarch April May June July 50 51 52 53 54 55 56 57 31 31 28 31 30 31 30 31 5 5 5 5 5 5 5 5 26 26 23 26 25 26 25 26 2 130 260

2 130 260

2 130 260

2 130 260

2 130 260

2 130 260

2 130 260

2 130 260

1

1

1

1

1

1

1

1

260

260

260

260

260

260

260

260

6760

6760

5980

6760

6500

6760

6500

6760

2015 2015 2015 August SeptembOctober 58 59 60 31 30 31 5 5 5 26 25 26 2 130 260

2 130 260

2 130 260

1

1

1

260

260

260

6760

6500

6760

CAPEX & LOAN REPAYMENT SCHEDULE

Total On Road Cost of Auto Rickshaw No. of Auto Rickshaw On Road Cost Per Auto Rickshaw Down Payment Bank Loan

1 175000 75000 100000

2010 Novembe 2010 Decembe 2011 January 2011 February 2011 March 2011 April 2011 May 2011 June 2011 July 2011 August 2011 Septemb 2011 October 2011 Novembe 2011 Decembe 2012 January 2012 February 2012 March 2012 April 2012 May 2012 June 2012 July 2012 August 2012 Septemb 2012 October 2012 Novembe 2012 Decembe 2013 January 2013 February 2013 March 2013 April 2013 May 2013 June 2013 July 2013 August 2013 Septemb 2013 October 2013 Novembe 2013 Decembe 2014 January 2014 February 2014 March 2014 April 2014 May

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

2014 June 2014 July 2014 August 2014 Septemb 2014 October 2014 Novembe 2014 Decembe 2015 January 2015 February 2015 March 2015 April 2015 May 2015 June 2015 July 2015 August 2015 Septemb 2015 October

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

Opening Loan Balanc EMI Interest Loan 100000 2125 833 98709 2125 823 97407 2125 812 96094 2125 801 94770 2125 790 93435 2125 779 92089 2125 767 90731 2125 756 89363 2125 745 87983 2125 733 86591 2125 722 85188 2125 710 83773 2125 698 82347 2125 686 80908 2125 674 79458 2125 662 77995 2125 650 76520 2125 638 75033 2125 625 73534 2125 613 72022 2125 600 70498 2125 587 68960 2125 575 67410 2125 562 65847 2125 549 64271 2125 536 62682 2125 522 61080 2125 509 59464 2125 496 57835 2125 482 56192 2125 468 54536 2125 454 52866 2125 441 51181 2125 427 49483 2125 412 47771 2125 398 46044 2125 384 44303 2125 369 42548 2125 355 40778 2125 340 38993 2125 325 37193 2125 310 35378 2125 295

RepaClosing Loan Balance 1291 98709 1302 97407 1313 96094 1324 94770 1335 93435 1346 92089 1357 90731 1369 89363 1380 87983 1392 86591 1403 85188 1415 83773 1427 82347 1438 80908 1450 79458 1463 77995 1475 76520 1487 75033 1499 73534 1512 72022 1525 70498 1537 68960 1550 67410 1563 65847 1576 64271 1589 62682 1602 61080 1616 59464 1629 57835 1643 56192 1656 54536 1670 52866 1684 51181 1698 49483 1712 47771 1727 46044 1741 44303 1756 42548 1770 40778 1785 38993 1800 37193 1815 35378 1830 33548

33548 31703 29843 27967 26075 24168 22244 20305 18350 16378 14390 12385 10363 8325 6270 4197 2107

2125 2125 2125 2125 2125 2125 2125 2125 2125 2125 2125 2125 2125 2125 2125 2125 2125

280 264 249 233 217 201 185 169 153 136 120 103 86 69 52 35 18

1845 1861 1876 1892 1907 1923 1939 1955 1972 1988 2005 2021 2038 2055 2072 2090 2107

31703 29843 27967 26075 24168 22244 20305 18350 16378 14390 12385 10363 8325 6270 4197 2107 0

PRESENT VALUE CALCULATION

TIME Capex (X)

2010 2010 2011 2011 Novemb December January February 1 2 3 4 0 -75000

Cash Inflow - Per Month Asset Sold Total Cash Inflow (A)

6500

6760

6760

5980

6500

6760

6760

5980

Cash Outflow Maintenance cost

2125 1000

2125 1000

2125 1000

2125 1000

Total Cash Outflow(B)

3125

3125

3125

3125

3375

3635

3635

2855

1.01

1.03

1.04

1.05

Net Surplus (A-B)

-75000

Discounting Factor

Present Value Total PVof Net Surplus (Y)

3333.63 ###

NPV (Y-X)

###

IRR

54%

3546.09 3502.31 2716.89

2011 2011 2011 2011 2011 2011 2011 2011 March April May June July August Septembe October 5 6 7 8 9 10 11 12

6760

6500

6760

6500

6760

6760

6500

6760

6760

6500

6760

6500

6760

6760

6500

6760

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

3125

3125

3125

3125

3125

3125

3125

3125

3635

3375

3635

3375

3635

3635

3375

3635

1.06

1.08

1.09

1.1

1.12

1.13

1.15

1.16

3416.37 3132.87 3332.54 3055.99 3250.76 3210.63

2944.2 3131.84

2011 2011 2012 2012 2012 2012 2012 2012 November December January FebruaryMarch April May June 13 14 15 16 17 18 19 20

6500

6760

6760

5980

6760

6500

6760

6500

6500

6760

6760

5980

6760

6500

6760

6500

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

3125

3125

3125

3125

3125

3125

3125

3125

3375

3635

3635

2855

3635

3375

3635

3375

1.18

1.19

1.2

1.22

1.24

1.25

1.27

1.28

2871.95

3054.99 3017.27 2340.62 2943.23 2698.99 2871.01 2632.76

2012 2012 2012 2012 2012 2012 2013 2013   July August Septembe October Novemb December January February 21 22 23 24 25 26 27 28

6760

6760

6500

6760

6500

6760

6760

5980

6760

6760

6500

6760

6500

6760

6760

5980

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

3125

3125

3125

3125

3125

3125

3125

3125

3635

3635

3375

3635

3375

3635

3635

2855

1.3

1.31

1.33

1.35

1.36

1.38

1.4

1.42

2800.56 2765.98

2536.45

2698.11 2474.21

2631.9 2599.41 2016.47

2013 2013 2013 2013 2013 2013 2013 2013 March April May June July August Septembe October 29 30 31 32 33 34 35 36

6760

6500

6760

6500

6760

6760

6500

6760

6760

6500

6760

6500

6760

6760

6500

6760

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

3125

3125

3125

3125

3125

3125

3125

3125

3635

3375

3635

3375

3635

3635

3375

3635

1.43

1.45

1.47

1.49

1.51

1.53

1.54

1.56

2535.62 2325.21

2473.4 2268.15

2412.7 2382.92

2185.18 2324.44

2013 2013 2014 2014 2014 2014 2014 2014 November December January FebruaryMarch April May June 37 38 39 40 41 42 43 44

6500

6760

6760

5980

6760

6500

6760

6500

6500

6760

6760

5980

6760

6500

6760

6500

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

3125

3125

3125

3125

3125

3125

3125

3125

3375

3635

3635

2855

3635

3375

3635

3375

1.58

1.6

1.62

1.64

1.66

1.68

1.71

1.73

2131.55

2267.4 2239.41

1737.2 2184.46 2003.18 2130.85 1954.03

2014 2014 2014 2014 2014 2014 2015 2015   July August Septembe October November December January February 45 46 47 48 49 50 51 52

6760

6760

6500

6760

6500

6760

6760

5980

6760

6760

6500

6760

6500

6760

6760

5980

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

3125

3125

3125

3125

3125

3125

3125

3125

3635

3635

3375

3635

3375

3635

3635

2855

1.75

1.77

1.79

1.82

1.84

1.86

1.88

1.91

2078.57

2052.9

1882.55 2002.53

1836.35

1953.39 1929.27 1496.61

2015 2015 2015 2015 2015 2015 2015 2015 March April May June July August Septembe October 53 54 55 56 57 58 59 60

6760

6500

6760

6500

6760

6760

6500

6760

6500

6760

6500

6760

6760

6500

6760 40000 46760

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

2125 1000

3125

3125

3125

3125

3125

3125

3125

3125

3635

3375

3635

3375

3635

3635

3375

43635

1.93

1.96

1.98

2.01

2.03

2.06

2.08

2.11

1881.93 1725.76 1835.75 1683.41

1790.7

1768.6

1621.83 20707.9

Month No./Time Peri No. Of Days Rent Per Day Rent Per Month

2010 2010 2011 2011 Novemb DecembeJanuary February 0 1 2 3 4 30 31 31 28 150 150 150 150 4500 4650 4650 4200

Cash Inflow

4500

4650

4650

4200

Cash Outflow

3227

3227

3227

3227

Net Surplus

1273

1423

1423

973

1273

1423

1423

973

Capex Deposit Capex & Net Surplu

IRR

-50000 20000 -30000

34% 48078

2011 2011 2011 2011 2011 2011 2011 2011 March April May June July August Septemb October 5 6 7 8 9 10 11 12 31 30 31 30 31 31 30 31 150 150 150 150 150 150 150 150 4650 4500 4650 4500 4650 4650 4500 4650 4650

4500

4650

4500

4650

4650

4500

4650

3227

3227

3227

3227

3227

3227

3227

3227

1423

1273

1423

1273

1423

1423

1273

1423

1423

1273

1423

1273

1423

1423

1273

1423

2011 2011 2012 2012 2012 2012 2012 2012 NovembeDecembeJanuary FebruaryMarch April May June 13 14 15 16 17 18 19 20 30 31 31 28 31 30 31 30 150 150 150 150 150 150 150 150 4500 4650 4650 4200 4650 4500 4650 4500 4500

4650

4650

4200

4650

4500

4650

4500

3227

3227

3227

3227

3227

3227

3227

3227

1273

1423

1423

973

1423

1273

1423

1273

1273

1423

1423

973

1423

1273

1423

1273

2012 2012 2012 2012 2012 2012 2013 2013   July August SeptembOctober Novemb Decemb January February 21 22 23 24 25 26 27 28 31 31 30 31 30 31 31 28 150 150 150 150 150 150 150 150 4650 4650 4500 4650 4500 4650 4650 4200 4650

4650

4500

4650

4500

4650

4650

4200

3227

3227

3227

3227

3227

3227

3227

3227

1423

1423

1273

1423

1273

1423

1423

973

1423

1423

1273

1423

1273

1423

1423

973

2013 2013 2013 2013 2013 2013 2013 2013 March April May June July August SeptembOctober 29 30 31 32 33 34 35 36 31 30 31 30 31 31 30 31 150 150 150 150 150 150 150 150 4650 4500 4650 4500 4650 4650 4500 4650 4650

4500

4650

4500

4650

4650

4500

4650

3227

3227

3227

3227

3227

3227

3227

3227

1423

1273

1423

1273

1423

1423

1273

1423

1423

1273

1423

1273

1423

1423

1273

1423

CAPEX & LOAN REPAYMENT SCHEDULE

Total On Road Cost of Auto Rickshaw No. of Auto Rickshaw On Road Cost Per Auto Rickshaw Down Payment Bank Loan

EMI

1 150000 50000 100000

###

2010 November 2010 December 2011 January 2011 F ebruary 2011 March 2011 April 2011 May 2011 June 2011 July 2011 August 2011 September 2011 October 2011 November 2011 December 2012 January 2012 February 2012 March 2012 April 2012 May 2012 June 2012 July 2012 August 2012 September 2012 October 2012 November 2012 December 2013 January 2013 February 2013 March 2013 April 2013 May 2013 June 2013 July 2013 August 2013 September 2013 October

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

Opening Loan BalaEMI Interest Loan 100000 3227 833 97607 3227 813 95193 3227 793 92760 3227 773 90306 3227 753 87832 3227 732 85337 3227 711 82822 3227 690 80285 3227 669 77727 3227 648 75148 3227 626 72548 3227 605 69926 3227 583 67282 3227 561 64616 3227 538 61927 3227 516 59217 3227 493 56484 3227 471 53728 3227 448 50949 3227 425 48146 3227 401 45321 3227 378 42472 3227 354 39599 3227 330 36702 3227 306 33781 3227 282 30836 3227 257 27867 3227 232 24872 3227 207 21853 3227 182 18808 3227 157 15738 3227 131 12642 3227 105 9521 3227 79 6374 3227 53 3200 3227 27

RepaClosing Loan Balance 2393 97607 2413 95193 2433 92760 2454 90306 2474 87832 2495 85337 2516 82822 2537 80285 2558 77727 2579 75148 2600 72548 2622 69926 2644 67282 2666 64616 2688 61927 2711 59217 2733 56484 2756 53728 2779 50949 2802 48146 2825 45321 2849 42472 2873 39599 2897 36702 2921 33781 2945 30836 2970 27867 2994 24872 3019 21853 3045 18808 3070 15738 3096 12642 3121 9521 3147 6374 3174 3200 3200 0

2010 2010 2011 2011 2011 November Decemb January FebruaryMarch Month No./Time Peri 0 1 2 3 4 5 Capex & Net Surplu -30000 1273 1423 1423 973 1423 -50000 15500 4500 Cash Inflow & Outflow IIR

-30000

4650 3227 1423 43588

4650 3227 1423

4200 3227 973

4650 3227 1423

4500 3227 1273

35 2.3

34 2.25

33 2.19

32 2.14

31 2.09

2.41%

Interest From Cash Flow

PV of Interest

Cash Inflow & Outflow

-30000

1852.19 1775.11 2.3 2.25 804.83 789.92 15391.88

1162.4 1626.34 1390.74 2.19 2.14 2.09 529.73 759.03 664.71

1423.28 1423.28

973.28 1423.28 1273.28

1.02 PV

1.05

1389.79 1357.08 Total PV

Grand Total

29982.12

45374

1.07

1.1

1.13

906.17 1293.96 1130.35

2011 2011 2011 2011 2011 2011 2011 2011 April May June July August SeptembOctober Novemb 6 7 8 9 10 11 12 13 1273 1423 1273 1423 1423 1273 1423 1273

4650 3227 1423

4500 3227 1273

4650 3227 1423

4650 3227 1423

4500 3227 1273

4650 3227 1423

4500 3227 1273

4650 3227 1423

30 2.04

29 1.99

28 1.95

27 1.9

26 1.86

25 1.81

24 1.77

23 1.73

1484.5 1266.83 1349.25 1284.01 1091.69 1158.09 2.04 1.99 1.95 1.9 1.86 1.81 726.62 635.02 692.64 675.03 587.76 638.53

981.69 1038.02 1.77 1.73 554.32 600.25

1423.28 1273.28 1423.28 1423.28 1273.28 1423.28 1273.28 1423.28 1.15

1.18

1.21

1.24

1.27

1.3

1233.78 1077.77 1176.39 1148.71 1003.46 1095.28

1.33

1.36

956.79 1044.34

2011 2012 2012 2012 2012 2012 2012 2012 Decemb January FebruaryMarch April May June July 14 15 16 17 18 19 20 21 1423 1423 973 1423 1273 1423 1273 1423

4650 3227 1423

4200 3227 973

4650 3227 1423

4500 3227 1273

4650 3227 1423

4500 3227 1273

4650 3227 1423

4650 3227 1423

22 1.69

21 1.65

20 1.61

19 1.57

18 1.54

17 1.5

16 1.46

15 1.43

980.1 1.69 580.41

631.55 1.65 383.01

868.31 1.61 539.3

728.56 1.57 463.4

761.73 1.54 496.18

635.45 1.5 423.9

660.1 1.46 450.95

611.07 1.43 427.52

1423.28

973.28 1423.28 1273.28 1423.28 1273.28 1423.28 1423.28

1.4

1.43

1.46

1.5

1.54

1.57

1.61

1.65

1019.76

680.93

972.33

849.38

927.1

809.88

883.98

863.18

2012 2012 2012 2012 2012 2013 2013 2013 August SeptembOctober Novemb Decemb January FebruaryMarch 22 23 24 25 26 27 28 29 1423 1273 1423 1273 1423 1423 973 1423

4500 3227 1273

4650 3227 1423

4500 3227 1273

4650 3227 1423

4650 3227 1423

4200 3227 973

4650 3227 1423

4500 3227 1273

14 1.4

13 1.36

12 1.33

11 1.3

10 1.27

9 1.24

8 1.21

7 1.18

503.84 1.4 360.99

516.45 1.36 378.95

421.18 1.33 316.49

426.23 1.3 328

382.7 1.27 301.61

232.64 1.24 187.76

298.7 1.21 246.89

230.97 1.18 195.51

1273.28 1423.28 1273.28 1423.28 1423.28

973.28 1423.28 1273.28

1.69

1.73

1.77

1.81

1.86

1.9

1.95

1.99

754.04

823.03

718.96

784.75

766.28

511.68

730.64

638.26