Question: Please go through all the tiny details in the question and provide me the solution in Excel format with calculations You have been provided the

Please go through all the tiny details in the question and provide me the solution in Excel format with calculations

Please go through all the tiny details in the question and provide

You have been provided the data for a six-lane of 65Kms BOT Toll Road. The capital expenditure (capex) required is 325 crores to be incurred over a period of one year. The capex in t0 will be 125 crores and in t1 will be 200 crores. The concession period including the construction period is six years. The project cost has to be financed with 60% debt and 40% equity. The debt can be raised at 11% with a maturity of four years. The debt principal amount has to be repaid in four equal installments with a moratorium period of one year. The toll revenue per year will be 500 crores with operating and maintenance expenses of 40%. The applicable corporate income tax rate is 30%. Required to estimate: i) Cash available for Debt Service (CADS) for the period t2 to t6 ii) Equity Cash Flows (ECFs) for the period t0 to t6 iii) Project IRR iv) Equity IRR v) Debt Service Coverage ratio (DSCR) vi) Loan Life Cover ratio (LLCR) vii) Project Life Cover ratio (PLCR)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!