answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Calculate average loan life of a term loan?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Finance

What is the average length of a short term loan?

The average length of a short term loan will depend on what type of loan is being taken out. In general a short term loan may be over a period of time of between one and five years.


Is it better to get a high interest short term loan or a low interest long term loan?

It depends on how long you need the loan for and how long it would take for you to complete the payment. But in general a low interest long term loan means a higher interest payment over the life of the loan where as a high interest short term loan means less amount of interest payment over the life of the loan.


Can you take money out and then switch from whole life insurance to term life insurance?

Only whole life insurance, not term, accumulates cash value from which a loan may be taken While the loan does not have to be repaid, if it is not, the loan plus accrued interest will be deducted from the death benefit. If you are changing from whole life to term within the same company, it may permit you to pay a higher premium for the term in order to pay off the policy loan on the whole life, but this would be unusual. It would make for a far cleaner transaction to pay off the loan and switch to term coverage.


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 loan term.


What is the average interest rate on a short term loan with great credit?

The average interest rate on a short term loan is 4.5% if you have great credit. You may need to shop around to find this, but you'll be able to.

Related questions

What is the average length of a short term loan?

The average length of a short term loan will depend on what type of loan is being taken out. In general a short term loan may be over a period of time of between one and five years.


Is it better to get a high interest short term loan or a low interest long term loan?

It depends on how long you need the loan for and how long it would take for you to complete the payment. But in general a low interest long term loan means a higher interest payment over the life of the loan where as a high interest short term loan means less amount of interest payment over the life of the loan.


What are the average loan rates at the Bank of New Zealand?

The loan rates at the Bank of New Zealand range from 4.95% to 6.99%. The average loan rate is around 5.70%. Loan rates highly depend on the term of the loan.


Can you take money out and then switch from whole life insurance to term life insurance?

Only whole life insurance, not term, accumulates cash value from which a loan may be taken While the loan does not have to be repaid, if it is not, the loan plus accrued interest will be deducted from the death benefit. If you are changing from whole life to term within the same company, it may permit you to pay a higher premium for the term in order to pay off the policy loan on the whole life, but this would be unusual. It would make for a far cleaner transaction to pay off the loan and switch to term coverage.


What information does an amortization calculator calculate?

Looks to be a free online resource that allows you to calculate roughly your monthly loan repayments based on loan amount, interest rate, term and start date


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 loan term.


What is the average interest rate on a short term loan with great credit?

The average interest rate on a short term loan is 4.5% if you have great credit. You may need to shop around to find this, but you'll be able to.


Are you looking for a long term loan?

No; I am looking for a longterm life


How does one calculate the interest rate on a loan?

Calculating the interest rate on a loan isn't that difficult. A person will need to take the principal amount and multiply it by the term of the loan and the annual percentage rate.


Calculate monthly payment?

the monthly payment is calculated based on the following: 1. loan amount 2. loan interest rate 3. term of loan Use the easy loan calculator below with your own figures.


How do you calculate APR?

You calculate APR based on your credit score, loan size and term of loan. Typically the shorter the loan life the lower APR you will get . Annual Percentage Rate APR (Annual Percentage Rate) is a standardized term used to compare loans, mortgage loans and credit card rates. It is a compilation of the compound interest, finance charges and lender fees calculated annually. For more detailed information and to use an APR calculator visit the link in related links.


How do you calculate your car payment by hand?

Take the amount of loan and including interest charges. Then determine the length of the loan. Then divide it by the number of months it takes to complete term of loan. This will give you the monthly payments.