Thank you for your replies.
Actually as per agreemnt the folowing info is known:
Cost of the asset is 3,512,000 at the beginning of the lease. Inception
of the lease is let's say 01.01.2006 for convenience. 4 payments are to
be made IN ADVANCE. It means that e.g. 01.01.2006 - 150,000; 01.04.2006
- 150,000; 01.07.2006 - 150,000; 01.10.2006 - 150,000. Then it says that
the assset will be purchased on annivesary @ 3,200,000. My understanding
is on Jan'07. The problem is correct calculation of internal rate of
return (IRR). Based on this percentage rate I'll be able to pick out
finance charge out of each pmnt.
Thanks.
--
littleps
------------------------------------------------------------------------
littleps's Profile:
http://www.excelforum.com/member.php...o&userid=25482
View this thread:
http://www.excelforum.com/showthread...hreadid=526304