# Calculate average loan life of a term loan?

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.
3 people found this useful

# How to calculate a loan of 275000 with a 25 years loan term and at a 5.750 percent?

Answer . Hello, How are you doing? I have an important annoucement for you.. Willscott Loan Agency is currently giving out loans at an interest rate of 0.4% per

# How is interest on a car loan calculated?

It is typically calculated on a rule of 78s a.k.a sum of the digits method.

# 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

# What is term loan?

Mortgage loans may be taken out for any length of time. The most common terms are 15 and 30 years.

# How do you calculate a loan payment?

One may calculate a loan payment by using a loan calculator. One would need to know the interest rate, the length of the loan, and the amount borrowed. There are several pla

# How do you calculate a 12 month average balance on a loan?

The answer depends on when interest is calculated, how frequently payments are made, the interest rate being charged and the life time of the loan. There are a number of "inte

# How do you calculate zero interest loan?

There is no calculation involved. You pay back the amount you borrow.

# What can you do when a loan officer misrepresents the terms of a loan?

It may be hard to prove that anyone misrepresented the terms if you signed a contract acknowleging the terms. I realize that contracts can be pages and pages of fine print, bu

# Does Carmax have an auto loan calculator?

They have a calculator at this address It will estimate your car payment. If you want to see if you can afford a car this calculator is a great place to start

# Are loan consolidation calculators reliable?

Loan Consolidation Calculators give the loanee information on how consolidating his or her loans will affect both their loan payment, loan balance, total interest, and time to

# How can you calculate your car loan by myself?

(car loan * APR + car loan) / 12/ amount of years. i think

# Where can you go to calculate your car loan?

The quickest option open to you is probably to check out a dew price comparison websites like Money Supermarket, or, along a more specific vein CarLoansCalculator.Be careful,

# How do you use a calculator for auto loans?

There is a very simple way to use auto loan calculators. You simply can visit a direct auto dealership website and the will be one on the website. You put in all the detailed

# What is a car loan payment calculation?

The easy-to-use auto loan calculator helps car buyers plan monthly car loan payments. Calculate car financing and car payments in advance to make a smart decision on how much
In Loans

# What does a loan calculator do?

A loan calculator calculates how much money it will take you over a set period of time to pay back the loan you have taken out. It will help you find the amount of money you c
In Loans

# How is a student loan calculator different from a regular loan calculator?

The student loan calculators shows the repayment amount and the salary needed to afford the repayment. Traditional loan calculators only show the repayment amount and schedule

# How accurate is a loan calculator for home loans?

A home loan calculator give the exact amount of loan you can getbased on your income and other criteria. You must try it out inorder to get a loan.