Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step: 3

blur-text-image

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

Mein Ultimativer Weihnachts Planer

Authors: Zizo Nimane

1st Edition

B0CM2J8GTG

More Books

Students also viewed these Finance questions