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. |
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 |
how to calculate average loan period of a 5 year loan
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. |
All times are GMT +1. The time now is 11:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com