# Loan Matrix Calculator

Save time from doing "what-ifs?"

advertisement

Ad horizontal-1

For best results, turn your device

×

#### Info...

Original Size

advertisement

Ad horizontal-2

advertisement

Ad horizontal-3

## Help with a Loan Matrix

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.

## 4 Comments on “Loan Matrix”

Join the conversation. Tell me what you think.

## R. Venkata Krishnayya says:

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

## Ricky Molosiwa says:

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

## Karl says:

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.

## Ricky Molosiwa says:

yes, what should be used for particular problem?