Save time from doing "what-ifs?"

Original Size

On the "Payment Amount" tab you can calculate a matrix of potential periodic payments for a given loan amount while varying the term and interest rate for the loan.

The "Loan Amount" tab allows you to calculate a matrix of various loan amounts that can be borrowed for a given payment amount for different terms and interest rates.

The "step values" on either tab control by what amount the interest rate and term are going to increase.

Note: It is not necessary to clear one calculation before doing the next. You can change one value and recalculate.

Very useful for check. Thank you very much for supporting public

kindly assist here, i am given a case studies and i have been asked to appraise it and advise the management. below is the case study, objective: Indicative to terms for sovereign financing

Case 1 Case 2 Case 3 Case 4

amount (Million EUR or 50 50 100 100

million USD)

Duration(year) 15 20 15 20

Grace period 5 5 5 5

Appraisal fee at signature

(% of loan amount) 0.5 0.5 0.5 0.5

yearly commitment fee (%

of undisbursed amount) 0.5 0.5 0.5 0.5

Margin over Euribor 6M

(bps) 1 105 99 101 96

Eq. fixed (%) as of

26/04/2017 1.92 2.05 1.88 2.02

Margin over Libor 6M

(bps), as of 26/04/2017 185 168 170 164

Eq. fixed rate (%), as of

26/04/2017 4.10 4 3.95 3.96

Case 1 Case 2 Case 3 Case 4

amount (Million EUR or 50 50 100 100

million USD)

Duration(year) 15 20 15 20

Grace period 5 5 5 5

Appraisal fee at signature

(% of loan amount) 0.5 0.5 0.5 0.5

yearly commitment fee (%

of undisbursed amount) 0.5 0.5 0.5 0.5

Margin over Euribor 6M

(bps) 1 105 99 101 96

Eq. fixed (%) as of

26/04/2017 1.92 2.05 1.88 2.02

Margin over Libor 6M

(bps), as of 26/04/2017 185 168 170 164

Eq. fixed rate (%), as of

26/04/2017 4.10 4 3.95 3.96

* Margin over Euribor 6 m (bps) is valid until 13 July 2017 only, and is subject to revision afterwards

Do you have a question? There is no question here. I’m happy to answer two types of questions, how does a calculator or feature work, or what calculator should be used for a particular problem.

yes, what should be used for particular problem?