Loan amount = $100,000
Annual interest = 6%
Tenure = 30yrs

Monthly rest instalment
=PMT(6%/12,30*12,100000)
=$599.55

What is the formula for Daily rest instalment
From financial calculator the answer is $600.48

Please help


--
kudos
------------------------------------------------------------------------
kudos's Profile: http://www.excelforum.com/member.php...o&userid=27866
View this thread: http://www.excelforum.com/showthread...hreadid=473724