Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the Free Cash Flow Leveraged included in the Excel Spread Sheep attached (Assignment 5 Empty), and knowing that the minimum Annual Debt Service Coverage
Given the Free Cash Flow Leveraged included in the Excel Spread Sheep attached (Assignment 5 Empty), and knowing that the minimum Annual Debt Service Coverage Ratio accepted by the financial institutions is 1.25.
How many years will be necessary to pay back a 650,38 million project finance loan (interest rate 4%)?
What will be the loan reimbursement and interest paid over the loan term?
Minimum ADSCR | 1.25 | |||||||||||||||||||||
Outstanding amount (beginning) | 4% | |||||||||||||||||||||
Loan profile | ||||||||||||||||||||||
Million Euros | total | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
Loan drawdown | 630.38 | 650.38 | ||||||||||||||||||||
% of the loan reimbursed (-) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
-Outstanding amount (beginning) | 0 | |||||||||||||||||||||
Outstanding amount (end) | 650.38 | |||||||||||||||||||||
Interest rate paid | -234.12 | |||||||||||||||||||||
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | ||
Free Cash Flow leveraged | 59.19 | 60.94 | 62.76 | 64.65 | 66.60 | 68.62 | 70.72 | 72.89 | 75.14 | 77.47 | 79.89 | 82.39 | 84.98 | 87.66 | 90.44 | 93.32 | 96.30 | 99.39 | 102.59 | 105.90 | ||
Debt Service (+) | ||||||||||||||||||||||
ADSCR | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
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