how to calculate average loan period of a 5 year loan

[Jayant]

Gentlemen,

Can any one tell, how to calculate average loan period of a 5 year loan, say
a US$5 million loan, payable in quarterly instalments at rate of 5% p.a..
The first in stalment starts at the end of 1st quarter.

 

[Ron Rosenfeld]

Gentlemen,

Can any one tell, how to calculate average loan period of a 5 year loan, say
a US$5 million loan, payable in quarterly instalments at rate of 5% p.a..
The first in stalment starts at the end of 1st quarter.

In the US, loan period would usually refer to the length of the loan, or
perhaps the time between periods.

In either case, you have already defined those in your statement.

Perhaps you mean something else?
--ron

 

[joeu2004]

Can any one tell, how to calculate average loan period of a
5 year loan, say a US$5 million loan, payable in  quarterly
instalments at rate of 5% p.a. The first in stalment starts
at the end of 1st quarter.

I presume you mean the periodic payment.

=roundup(pmt(5%/4, 5*4, -5000000), 2)

Change the rounding as you see fit.