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.

On Tue, 25 Mar 2008 04:03:01 -0700, Jayant
wrote:

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

On Mar 25, 4:03*am, Jayant wrote:
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.