Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how much is the LLCR from the data attached? interest rate is 7% ol 1 2 5 el 91 101 12 13 Year Revenue Fuel
how much is the LLCR from the data attached? interest rate is 7%
ol 1 2 5 el 91 101 12 13 Year Revenue Fuel Operation Exp Depreciation Interest Payment Tax (305) Not Income 152 56 11 14 25.2 13.7 32.1 243 98 22 37 48.3 11.3 26.4 253 99 23 35 44.1 15.6 36.3 255 100 24 33 39.9 17.4 40.7 256 101 25 31 35.7 19.0 44.3 259 102 25 30 31.5 212 49.4 257 103 26 28 27.3 21.8 50.9 264 104 26 27 23.1 222 51.7 254 105 28 25 18.9 23.1 54.0 252 106 29 24 14.7 23.5 54.8 243 107 30 23 241 108 29 22 6.3 22.7 53.0 221 109 30 21 O 18.3 42.7 10.5 21.8 50.9 Equity Investment Debt Construction Payment 80 720 800 Net Income Depraciation Operating CF Debt Payment FOF for equity Investor Outstanding Debt 321 14 46.1 30 16 06 690 26.4 37 63.4 60 3.39 630 36.3 35 71.3 60 11.33 570 40.7 33 73.7 60 13.7 510 44.3 31 75.3 60 15.3 450 49.4 30 79.4 60 19.4 390 50.9 28 78.9 60 18.9 330 51.7 27 78.7 60 18.7 270 54.0 25 79.0 60 19.0 210 54.8 24 78.8 BO 18.8 150 50,8 23 738 60 13.8 90 53.0 22 75.0 60 15.0 30 42.7 21 63.7 30 33.7 0 -80 720 Equity IRR 19.85 CF available for Debt payment Debt and Interest Payment 71.26 55.2 112 1083 115 104 114 100 111 96 111 92 TO2 106 87 98 79 94 75 84 71 81 66 64 o
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started