View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default how to calculate average loan period of a 5 year loan

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