Loan Matrix Calculator
Info...
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.
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?