CASH FLOW PROJECTION STATEMENT ( YEARLY )
( Refer Schedule 'G' of Volume -I )
Name of Work :- Construction of Funicular Railway System at Haji Malang Gad at Ambarnath, Dist. Thane, Maharashtra State (India)
1 Project Cost4591.00 Lakh 5 Rate of Interest13.00%
2 Cost of Repairs and Maintenance 2.00%91.82 Lakh 6 Rate of Inflation5.00%
3 Cost of Rope Change 1.50%68.87 Lakh 7 Annual Inspection Charges40.00 Lakh
4 Operating Cost 2.00%91.82 Lakh( Shown in Col. No. 9 )
Project Cost Toll Operation and Maintenance ChargesNET TOLL
% Cost PROJECT
COST
Cost with
inflation
Factor
Annual
Maintenance
Charges
Rope
Change
Cost
Operating
Charges
Annual
Inspection
Charges
Total
( Col. 6 + 7
+ 8 + 9 )
( Col. 2 x 4 )12.24% 13%
1 1a 2 3 4a 4 5 6 7 8 9 10 11 15 12 13 14 15 16
1.000
1 2008 9 1.050 35% 1606.85 1,6870 1,687.19 109.67 1,796.86
(1,687.19)
#NUM! 1
2 2009 12 1.103 50% 2295.50 2,5310 4,327.65 398.09 4,725.74
(2,530.79)
#NUM! 2
3 2010 12 1.158 471.48 15% 688.65 797 79.720 79.72 30.000 189.44 57.71 413.77 5,298.61 651.58 5,950.20
(572.87)
#NUM! 3
4 2011 12 1.216 659.85 0.00 0 111.608 111.61 48.620 271.84 80.77 579.09 5,642.95 753.55 6,396.50
307.25
#NUM! 4
5 2012 12 1.276 796.00 0.00 0 117.188 117.19 51.051 285.43 97.43 698.57 5,983.36 804.69 6,788.05
413.14
#NUM! 5
6 2013 12 1.340 835.63 0.00 0 123.048 92.286 123.05 53.604 391.98 102.28 733.35 6,446.69 860.26 7,306.95
341.36
#NUM! 6
7 2014 12 1.407 982.50 0.00 0 129.200 129.20 56.284 314.68 120.26 862.24 6,759.39 914.31 7,673.70
547.56
-23.65% 7
8 2015 12 1.477 1,031.53 0.00 0 135.660 135.66 59.098 330.42 126.26 905.27 7,098.85 960.22 8,059.06
574.85
-15.50% 8
9 2016 12 1.551 1,208.25 0.00 0 142.443 142.44 62.053 346.94 147.89 1,060.36 7,345.64 1,001.31 8,346.95
713.42
-9.03% 9
10 2017 12 1.629 1,268.44 0.00 0 149.565 112.174 149.57 65.156 476.46 155.26 1,113.18 7,710.23 1,043.72 8,753.95
636.72
-5.08% 10
11 2018 12 1.710 1,459.59 0.00 0 157.043 157.04 68.414 382.50178.65 1,280.94 7,855.51 1,079.61 8,935.13
898.43
-1.19% 11
12 2019 12 1.796 1,532.42 0.00 0 164.896 164.90 71.834 401.63187.57 1,344.85 7,991.90 1,100.26 9,092.15
943.23
1.64% 12
13 2020 12 1.886 1,761.11 0.00 0 173.140 173.14 75.426 421.71215.56 1,545.55 7,968.31 1,108.93 9,077.24
1,123.85
4.05% 13
14 2021 12 1.980 1,848.75 0.00 0 181.797 136.348 181.80 79.197 579.14 226.29 1,622.46 8,033.91 1,112.22 9,146.14
1,043.32
5.69% 14
15 2022 12 2.079 2,096.20 0.00 0 190.887 190.89 83.157 464.93256.58 1,839.63 7,771.44 1,099.64 8,871.08
1,374.70
7.31% 15
16 2023 12 2.183 2,200.63 0.00 0 200.432 200.43 87.315 488.18269.36 1,931.27 7,427.99 1,059.44 8,487.43
1,443.09
8.57% 16
17 2024 12 2.292 2,495.42 0.00 0 210.453 210.45 91.681 512.59305.44 2,189.98 6,810.04 994.34 7,804.38
1,677.39
9.68% 17
18 2025 12 2.407 2,619.81 0.00 0 220.976 165.732 220.98 96.265 703.95 320.66 2,299.15 6,209.18 910.88 7,120.06
1,595.20
10.49% 18
19 2026 12 2.527 2,938.99 0.00 0 232.025 232.02 101.078 565.13 359.73 2,579.26 5,105.93 794.69 5,900.62
2,014.13
11.28% 19
20 2027 12 2.653 3,085.76 0.00 0 243.626 243.63 106.132 593.38 377.70 2,708.06 3,785.94 629.63 4,415.56
2,114.68
11.93% 20
21 2028 12 2.786 3,464.71 0.00 0 255.807 255.81 111.439 623.05 424.08 3,040.63 1,997.99 416.88 2,414.87
2,417.57
12.51% 21
22 2029 12 2.925 3,637.71 0.00 0 268.597 201.448 268.60 117.010 855.65 445.26 3,192.45 78.07 162.04 240.11
2,336.80
12.96% 22
23 2030 12 3.072 4,048.71 0.00 0 282.027 282.03 122.861 686.92 495.56 3,553.15 (2,626.12) 0.00 (2,626.12)
2,866.24
13.39% 23
24 2031 12 3.225 4,063.16 0.00 0 296.129 296.13 129.004 721.26 497.33 3,565.83 (5,470.69) 0.00 (5,470.69)
2,844.57
13.74% 24
25 2032 12 3.386 4,527.54 0.00 0 310.935 233.201 310.94 135.454 990.53 554.17 3,973.37 (8,453.54) 0.00 (8,453.54)
2,982.84
14.03% 25
Total Total 297.0 44,506.6 4,591.0 5,015.2 4,377.2 941.2 4,377.2 1,902.1 11,597.7 6,001.8 43,032.4 112,786.4 17,966.0 130,752.4 26,419.5
Concession period 24 Years 8 Months 4 Days
Note :a)
b)
c)
d)
Net Income
"Yearly Cash Flow Statement" shall be worked out from the pro posed date of commencement of the project till the end conces sion period. This statement shall also indicate the calcula ted "Financial Internal Rate of Return (F.I.R.R.)" for the q uoted
concession period.
The columns Showing details of income shall show full detail s item wise such as toll income, income from other sources, Su bsidy (if any), etc, and against the column of expenditure it em wise details such as initial Investment, Interest, Maint enance
cost etc. shall be given
The bidder must be the cash flow statement in excel format along with formulas for each column in the format prescribed as a bove by the Department. If the cash flow is not submitted in th e format prescribed by the Department the offer will be
rejected.
Out of the total traffic every year it is presum that during ma nsson period ie. June to September (4 monts only) 15% tourist 's will avail the facility. For the rest of the period ie. From January To May & Octomber to December (8 months) 85% tourist's
will avail the facility.
IRR Concession
Period
( Construction for 3 Months and Trolley Operation a nd other Income for 9 Months )
Service Tax
on total
income
Outstanding
Amount
Interest on
Borrowing
Total
Outstanding
Amount
Year Months /
Days
INFLATI
ON
FACTOR
Total Income
from Form 4