What would you like to do?

# 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.
+ 10 others found this useful
Thanks for the feedback!

# How do home loan calculators work?

A home loan calculator determines the amount of loan payment one must pay. This calculator is found online. Once one enters variables such as interest rate and repayment term,

# 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

# What is a reverse auto loan calculator?

A reverse auto loan allows you to enter monthly amount you want to spend, anticipated interest rate and trade-in value of your existing car, in order to calculate how much you

# How is a refund calculated on a precomputed loan?

  A precomputed account is one in which the debt is expressed as a sum comprising the principal and the amount of the finance charge computed in advance.   The total am

# 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 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

# What is car loan calculator?

A car loan calculator is a tool used to figure out how much your monthly car payment will be, based upon the cost of the vehicle, the number of years you'll be making the paym

# 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

# How interest is calculated in loan syndication?

interest=princibal x rate x time

# 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

# What is a home loans calculator?

A home loans calculator is an online tool designed by mortgage  lenders to help you calculate your monthly installment. It will  enable you to work out how much you can borr

# What is a personal loan calculator used for?

Personal Loan calculator is used for calculating the monthly  installments one has to pay after taking the Loan. It gives you  clarity on the principal amount, interest rate

# What is the purpose of an amortization loan calculator?

The purpose of an amortization loan calculator, is to calculate the information including price and payment options regarding popular loans for mortgage, and others.

# What is a loan payment calculator?

This Loan Payment Calculator computes an estimate of the size of your monthly loan payments and the annual salary required to manage them without too much financial difficulty

# How can a mortgage loan calculator be useful?

Like other types of payment calculators, a mortgage calculator is helpful to determine the exact cost and the monthly payment of a mortgage. It is helpful because good calcula

# Where can one calculate interest of a loan?

The interest of a loan can be calculated by using the 'Loan Calculator' facility at the Bankrate website. One would need to know details, such as the interest rate and the loa

# How can one calculate auto loan?

There are many ways one can calculate their auto loan. One can calculate auto loans by visiting popular on the web sources such as Capital One and Bank Rate.