What would you like to do?

Calculate average loan life of a term loan?

already exists.

Would you like to merge this question into it?

already exists as an alternate of this question.

Would you like to make it the primary and merge this question into it?

exists and is an alternate of .

It will be different from final maturity, in case this is an amortising loan.
In essence, you should be looking at this particular term loan as a series of shorter term loans with different final maturities.

So to calculate the average life, you should calculate the average of these multiple maturities weighted by the debt sums (aka debt amortisation sums).

- - - - -

Say if you have borrowed £100 with semi-annual amortisation over a period of 10 years, £5 is due in 6 months, another £5 in 1 year... another £5 in 9.5 years and the final £5 in 10 years.

In Excel use SUMPRODUCT function to multiply an array of maturities (0.5,1,...,9.5,10.0) by an array of debt sums (£5,£5,...,£5,£5). You'll then divide the result over the total amount (£100). The result should be 5.25 years.

This is a reflection of the fact that your liability decreases over time.
+ 10 others found this useful
Thanks for the feedback!

The question and answer are locked and cannot be edited.

What is loan?

Loan is an amount of money advanced to a borrower, to be repaid at a later date, usually with interest. legally, a loan is a contrat between a buyer (the borrower) and a selle

How do you calculate the percent in a loan?

% over 100 = is over of. the % divided by 100 is the same as loan over the total. do cross multiplication...% x total = 100 x loan. divide both sides by the coeficient (which

What are the benefits of a home loan calculator?

You are able to find out what monthly payment you will have to make. Simply put in loan amount the loan term in months or years, the interest rate and the start date of the lo

How are home loan rates calculated?

Home loan rates are calculated based on the buyers financial history, fiscal responsibility, and past home buying experiences. Martial status and age may also be factored in.

How do i calculate loan payments?

Cut & pase this link into your browser: http://rws.rwstools.com/templateroot/Calculators.asp?PVLID=26316 Or you can do it the hard way: payment = Balance*(int/(1-(1/(1+i

What is the average interest on a payday loan?

Interest rates for payday loans vary, but they are always at least three digits. These rates start at 300% and can go above 1000%. Stay away if you can.

What is a loan holiday for term loans?

A loan holiday is some period of time (e.g., one payment period, two payment periods, etc.) where the borrower is not required to make a payment and will not be penalized as a

How do get a loan?

You are looking for the fastest solution of current financial problems? Well, stop searching for the best option as it's obvious - cash advance no credit check - quick and pro

What is the average cost of a title loan?

The cost of a title loan will be whatever the difference is that you need on your car. You will qualify for a specified amount depending on how good your credit is. Title loan

What is the best personal loan calculator?

While there are many programs and sites that can calculate loans the best option is probably someone at a bank. I say this because a banker will always be up to date on all fa

What is the process of calculating loan emi?

With the help of mathematical formula, you can calculate the loan  EMI, Just you need to follow bellow steps   A calculation process works on three main criteria such as