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

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.