Answered step by step
Verified Expert Solution
Link Copied!

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%

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Finance

Authors: Robert Holton

1st Edition

0415619165, 978-0415619165

More Books

Students also viewed these Finance questions