Show me all the calculations in excel format , with correct methods You...
60.1K
Verified Solution
Link Copied!
Question
Finance
Show me all the calculations in excel format , with correct methods
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) 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)
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!