Case Problem Project Finance

  • Uploaded by: Saurabh Suman
  • 0
  • 0
  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Case Problem Project Finance as PDF for free.

More details

  • Words: 2,486
  • Pages: 37
Financial Model for the Bridge Project A COST ESTIMATES B ASSUMPTIONS FOR FINANCIAL MODEL C TRAFFIC AND TOLL RATE PROJECTIONS D PROJECT TIME TABLE E FINANCIAL PLAN F OPERATION AND MAINTENANCE CALCULATIONS G DEPRECIATION SCHEDULE H TERM LOAN REPAYMENT I PROFIT AND LOSS ACCOUNT & WACC J CASHFLOW, NPV, IRR & EIRR FOR THE PROJECT K DEBT SERVICE COVERAGE RATIO L COMMENT ON PROJECT VIABILITY Instructions Above mentioned links are provided to navigate through the financial model Values mentioned in RED color are negative values Values Mentioned in BLUE Color Are Assumptions Made by the modeler

A

B

C

D

E

F

G

COST ESTIMATES Consultant Fees 2% Expert Fees (Deployed By State Govt) 1% Environmental Clearence 5% Pre Operative Expences 3% Contingencies 5% Increase in manpower cost 10% Cost Of Engineers (Rs.) ### cost of supervisior (Rs.) ### Cost of Permenant Staff (Rs.) ### Cost of Administrative Office 0% Cost of Construction Toll Plaza 1% The general Lighting cost of the Bridge is assumed to be covered in the Per Km cost of Bridge Land will be transferred by the state govt to the developer as free of cost. TRAFFIC PROJECTIONS Average Annual Growth Rate 4% Inflation Rate (Every 3rd Year) 10% Bridge Length 2.5 Toll Rates 2-Wheelers 7.5 4-Wheelers 10 S.T. Bus 1000 Advertisement Revenue 1% Inflation rate is also applied to the per annum payment of State Transport Buses FINANCIAL PLAN Interest During Construction is payed back quarterly Moratorium Period is considered as 3 years for both the debts OPERATION AND MAINTENANCE Inflation 4% Operation and Maintenance of Bridge 2% Periodic Re-surfacing 4% Increase in Operations of Toll Plaza 10% Cost of Operating Toll Plazas 5% DEPRECIATION Written Down Value Method 15% Straight line Method 10% PROFIT AND LOSS ACCOUNT Minimum Alternative Tax 0% Corporate Tax 40% Repayment of the principal for Debt Amount is not considered in the Profit and Loss Account CASHFLOW Method of Depreciation considered for preparing the cash flow is Straight line Method WACC is considered as Discounting rate for Project NPV

Cost of Equity is Considered as Discounting rate for Equity NPV

of total construction of total construction of construction cost of total construction of total construction Per Annum Per Annum Per Annum Per Annum of construction cost of construction cost m cost of Bridge

cost cost cost cost

Km. per km perkm per vehicle per annum of Total Vehicular Toll Revenue

every year of Initial Investment every 3rd Year every year of O&M for Bridge

d Loss Account

0

COST ESTIMATES A

Assumptions Consultant Fees 2% of total construction cost Expert Fees (Deployed By State Govt) 1% of total construction cost Environmental Clearence 5% of construction cost Pre Operative Expences 3% of total construction cost Contingencies 5% of total construction cost Increase in manpower cost 10% Per Annum Cost Of Engineers (Rs.) ### Per Annum cost of supervisior (Rs.) ### Per Annum Cost of Permenant Staff (Rs.) ### Per Annum Cost of Administrative Office 0.50% of construction cost Cost of Construction Toll Plaza 1% of construction cost The general Lighting cost of the Bridge is assumed to be covered in the Per Km cost of Bridg Land will be transferred by the state govt to the developer as free of cost.

A

Construction Costs Description Land Cost Site Clearances Bridge Construction Site Office Construction of Toll Plaza Environmental Clearence Total (Bridge Cost)

B

Unit Sqm. Km. L.S. L.S. L.S.

2 1

Length 500 2.5

2

Man Power

Description Engineer Supervisor Permanent staff

Unit Persons Persons Persons

Total (Man Power) C

No

Expert & Consultancy Description Technical Consultancy fees Expert employed by State Govt. Total (Expert & Consultancy)

Period No (Years) 4 1 1 1 2 1

Breadth

Height 20 1

1 1

D E

Pre Operative Expenses Contengencies

(A+B+C +D+E) Total Project Cost (In INR)

Per Km cost of Bridge

Quantity

Rate (Rs.)/Sq.mAmount (Rs.) 0 0 20000 100 2,000,000 2.5 12,000,000 30,000,000 160,000 640,000 1,640,000 32,800,000

Rate / Rate / Amount Annum(INR.) Annum(INR.) Amount (INR) (INR) Year I Year I Year II Year II 500,000.00 550,000 2,000,000 2200000 300,000.00 330,000 300,000 330000 150,000.00 165,000 300,000 330000 2,600,000 ### ###

Amount (INR) 656,000 328,000 984,000

1,177,320 1,962,200

43,570,825

TRAFFIC PROJECTIONS Assumptions Average Annual Growth Rate 4% rd Inflation Rate (Every 3 Year) 10% Bridge Length 2.5 Km. Toll Rates 2-Wheelers 7.5 per km 4-Wheelers 10 perkm S.T. Bus 1000 per vehicle per annum Advertisement Revenue 1% of Total Vehicular Toll Revenue Inflation rate is also applied to the per annum payment of State Transport Buses

Traffic Projection 2-Wheelers 4-Wheelers S.T. Bus Toll Rate Projection 2-Wheelers (Rs) 4-Wheelers (Rs) S.T. Bus (Rs./each)

1 2013

2 2014

3 2015

4 2016

5 2017

6 2018

20000 75000 1000

20800 78000 1040

21632 81120 1082

22497 84365 1125

23397 87740 1170

24333 91250 1217

19 25 1000

19 25 1000

19 25 1000

21 28 1100

21 28 1100

21 28 1100

Toll & Advertizement Revenue Generation (INR) 2-Wheelers 375000 390000 405600 464001 482563 501868 4-Wheelers 1875000 ### ### ### ### ### S.T. Bus 1000000 ### ### ### ### ### Advertisement Revenue 32500 33800 35156 40215 41824 43499 Total Revenue Generation 3282500 ### ### ### ### ###

ansport Buses 7 2019

10 2022

11 2023

12 2024

13 2025

26318 27371 28466 98696 102644 106750 1317 1370 1425

29605 111020 1482

30789 115461 1541

32021 120079 1603

25 33 1331

25 33 1331

25 33 1331

28 37 1464

582038 605314 629533 720190 ### ### ### ### ### ### ### ### 49846 51844 53922 61690 ### ### ### ###

749007 3694191 1972542 64157 6479897

778962 3841965 2051071 66720 6738718

891144 4395192 2346792 76331 7709459

25306 94900 1266

23 30 1210

8 2020

23 30 1210

9 2021

23 30 1210

14 2026

15 2027

33302 124882 1667

34634 129877 1734

28 37 1464

28 37 1464

926795 4570993 2440488 79383 8017659

963864 4753823 2538576 82563 8338826

PROJECT TIME TABLE

Financial Close Operations Period Considered (Months) Construction Schedule Start of Construction Period Construction Period (months) End of Construction Period Operations: Commercial Operations Date Project Period Ends First Financial Year Begins First Financial Year Ends Concession Period: Concession Period Starts Concession Period Ends

31-Dec-10 180 1-Jan-11 24 31-Dec-12 1-Jan-13 31-Dec-27 1-Jan-11 31-Dec-11 1-Jan-13 31-Dec-27

FINANCIAL PLAN Assumptions Interest During Construction is payed back quarterly Moratorium Period is considered as 3 years for both the debts

Contribution 50% 25% 15% 10% 50% 10% 40%

Cost

INTEREST DURING CONSTRUCTION

Q1-1 5446353

Contribution of Equity Contribution of Sub Ordinated Debt Contribution of Senior Debt

5446353

Q1-2 5446353 16339059 5446353

Total Interest During Construction Sub Ordinated Senior Debt by Senior Lender Total Grand TOTAL IDC

5446353

5446353

EQUITY Private operator Authority state government DEBT Sub Ordinated Senior Debt by Senior Lender Total Project Cost

1187305 Senior

Proportion of Total Debt Proportion of Total Debt (Amount in INR)

Prime Lending Rate Interest Rate (During Construction Period) Interest Rate (During Operations Period) Drawdown Starts Repayment (years ) Repayment per year No. of Instalments

6% 10%

Sub-ordinated 40%

10%

0 10% 10% 10% 1-Jan-2012

0

10 1

10

6%

6% 6% 1-Jan-2012 10 1 10

Repayment / Redemption Starts Repayment / Redemption Ends Moratorium Period- 3 years

1-Jan-2016 ###

1-Jan-2016 31-Dec-2025

3

3

Share

Total Equity/Debt 21785412

10892706 6535624 4357082 21785412 4357082 17428330 43570825 ok Q1-3 5446353 10892706 5446353

Q1-4 5446353 5446353 5446353

Q2-1 5446353 0 4357082 1089271

5446353

5446353

5446353 261425 108927 370352

Q2-2 5446353

Q2-3 Q2-4 5446353 5446353

5446353 5446353 5446353

5446353 5446353 5446353

408476 408476

272318 272318

136159 136159

ok

INTEREST ON SENIOR AND SUB-ORDINATED DEBT 2011

2012 0

Interest On Senior Debt Principal Senior Debt (Repayment) Repayment of Senior Debt Interest On Subordinated Debt Principal Sub-Ordinated Debt (Repayment) Repayment of Sub-Ordinated Debt

2013 1

0

2014 2

0

2015 3

0

2016 4 ### ### ### ###

0

0

435708 0 ###

2017 5 ###

2018 6 ###

2019 7 ###

2020 2021 2022 2023 2024 2025 8 9 10 11 12 13 ### 871416 697133 522850 348567 174283

### ###

### ###

### ###

### ###

### ###

2026 14 0

### ###

### ###

### ###

### ###

235282 209140 182997 156855 130712 104570

78427

52285

26142

0

435708 435708 435708 435708 435708 435708 435708 435708 435708 ### ### ### ### ### ### ### ### ###

0

2027 15

A

OPERATION AND MAINTENANCE Assumptions Inflation 4.00% every year Operation and Maintenance of Bridge 1.50% of Initial Investment Periodic Re-surfacing 4.00% every 3rd Year Increase in Operations of Toll Plaza10.00% every year Cost of Operating Toll Plazas 5.00% of O&M for Bridge

B

Operation and Maintenance

Initial Investment O&M Bridge Periodic Re-surfacing Operating Toll Plazas

###

2011 0

2012 1

2013 2 653562 32678

cost of periodic resurfacng has to be considered in referenece with construction cost

2014 2015 3 4 679705 706893 35946

onstruction cost

39541

2016 2017 2018 5 6 7 ### 764576 795159 ### 43495 47844 52628

2019 2020 2021 8 9 10 ### 860043 894445 ### 57891 63680 70048

2022 2023 11 12 ### 967432 ### 77053 84759

2024 13 ###

2025 2026 2027 14 15 16 ### ### ### ### 93234 102558 112814 124095

DEPRECIATION Assumptions Method of Depreciation Rate of Depreciation

WDM 15%

SLM 10%

Depreciation 2011 Depreciation (WDV) Written Down Value Depreciation (SLM)

2012 0

2013 1 ### ### ###

2014 2 ### ### ###

2015 3 ### ### ###

2016 4 ### ### ###

2017 5 ### ### ###

2018 6 ### ### ###

2019 7 ### ### ###

2020 8 ### ### ###

2021 9 ### ### ###

2022 10 ### ### ###

2023 11 ### ### ###

2024 2025 2026 2027 12 13 14 15 ### 929639 790193 671664 ### ### ### ### ### ### ### ###

PROFIT AND LOSS ACCOUNT Assumptions Minimum Alternative Tax 0% Corporate Tax 40% Repayment of the principal for Debt Amount is not considered in the Profit and Loss Account

Profit and Loss Account 2011 EXPENDITURES O&M Bridge Periodic Re-surfacing Operating Toll Plazas Non-Operating Expenses Interest On Senior Debt Interest On Subordinated Debt TOTAL EXPENSES

2012

2013 ### 0.00 32678.12

###

REVENUES Operating Revenues Toll Revenues Advertisement Revenue

### 32500.00

TOTAL REVENUES

###

PROFIT BEFORE DEPRE & TAX DEPRECIATION PROFIT BEFORE TAX Corporate Tax PROFIT AFTER DEPRE & TAX

### ### ### 0.00 ###

WACC Cost Of Equity Cost of Debt WACC

Cost

Share 15% 50% 10% 50% 12.50%

the Profit and Loss Account

2014

2015

2016

2017

2018

2019

2020

2021

### ### 735168.79 ### ### ### ### ### 0.00 0.00 ### 0.00 0.00 ### 0.00 0.00 35945.93 39540.52 43494.58 47844.03 52628.44 57891.28 63680.41 70048.45

###

###

### ### 33800.00 35156.00

### ### ###

### ### ###

### ### ###

### ### ###

### ### ###

### ### ###

### ### ### ### ### ### 40215.39 41824.13 43499.43 49846.23 51844.38 53922.14

###

###

###

###

###

###

###

###

### ### ### 0.00 ###

### ### ### 0.00 ###

### ### ### 0.00 ###

### ### ### 0.00 ###

### ### ### 0.00 ###

### ### ### 0.00 ###

### ### ### ### ###

### ### ### ### ###

2022

2023

2024

2025

2026

2027

### ### ### ### 0.00 0.00 77053.29 84758.62 93234.49

### ### ###

### 0.00 ###

### 0.00 ###

### ### ### ### ### 78427.48 52284.99 26142.49 ### ### ### ###

0.00 0.00 ###

###

### ### ### ### ### ### 61689.71 64157.40 66719.98 76331.28 79382.76 82562.63 ###

###

###

###

###

###

### ### ### ### ###

### ### ### ### ###

### ### ### ### ###

### ### ### ### ###

### ### ### ### ###

### ### ### ### ###

CASHFLOW AND EIRR Assumptions Method of Depreciation considered for preparing the cash flow is Straight line Method WACC is considered as Discounting rate for Project NPV Cost of Equity is Considered as Discounting rate for Equity NPV 2011 0 Depreciation Initial Investment Cash Flow NPV IRR

27,227,476 2%

EQUITY IRR Initial Investment Depreciation (SLM) Principal Repayment

###

Cashflow NPV EIRR

### 15,785,345 4%

Comment on Project viability

Project's Net present value of the project is negative and also the project The Net present value of the Equity is also negative and the Internal rate

The Net Present Value is negative, coupled up with a very low level of Internal Rat With regard to this we can conclude that the Project is not Viable enough to be tak The project IRR and NPV not yeilding better results, Equity IRR has been worked ou

w is Straight line Method

2012 0

2013 1 4,357,082.50

2014 2 ###

2015 3 ###

2016 4 ###

2017 5 ###

2018 6 ###

417,718.26

###

###

###

###

###

4,357,082.50

###

###

### ###

### ###

### ###

417,718.26

###

###

### 374,890.21

###

### ###

###

###

tive and also the project IRR is also not attractive hence the project is not viable for con ive and the Internal rate of return of the Equity is Very much Lower than the Cost of Eq INFERENCES

ery low level of Internal Rate of Return at 2% as compared to the Weighted Average Cost of Capital not Viable enough to be taken, in accordance with the conditions and assumptions taken for compu uity IRR has been worked out to check the return on Equity investments

2019 7 ###

2020 8 ###

2021 9 ###

2022 10 ###

2023 11 ###

2024 12 ###

2025 13 ###

###

###

###

###

###

###

###

### ###

### ###

### ###

### ###

### ###

### ###

### ###

255,026.66

###

###

###

###

###

###

not viable for consideration an the Cost of Equity hence the project is not viable for investment.

age Cost of Capital at 12.5%. ons taken for computing the Financial Model

2026 14 ###

2027 15 ###

###

###

###

###

###

###

DEBT SERVICE COVERAGE RATIO

Debt Service Coverage Ratio

PROFIT AFTER DEPRE & TAX Depreciation (SLM) Interest On Senior Debt Interest On Subordinated Debt Amount Available For Repayment Interest Repayment Principal Repayment Amount required for Debt Service DSCR Average DSCR

2011 0 0

2012 0 0

2013 1 ### ###

2014 2 ### ###

###

###

2015 3 ### ###

###

2016 4 ### ### ### ### ### ### ### ###

2017 5 ### ### ### ### ### ### ### ###

2018 6 ### ### ### ### ### ### ### ###

2019 7 ### ### ### ### ### ### ### ###

2020 8 ### ### ### ### ### ### ### ###

2021 9 ### ### ### ### ### ### ### ###

2022 10 ### ### ### ### ### ### ### ###

0.16 1.72

1.09

1.32

1.07

1.82

2.01

1.82

2023 2024 2025 11 12 13 ### ### ### ### ### ### ### ### ### 78427.48 52284.99 26142.49 ### ### ### ### ### ### ### ### ### ### ### ### 2.55

2.81

2.58

2026 14 ### ###

2027 15 ### ###

###

###

0.00

0.00

Related Documents

Project Finance Case
June 2020 9
Case Problem
August 2019 19
Finance Project
June 2020 8
Project Finance
November 2019 28
Finance Project
May 2020 17

More Documents from ""