Perhaps this will help:
I also came up with the following calc which should do the trick, although I take no credit for the formula itself.
_rate = 30.21 / 1200 ;
_nper = 47 ;
_pv = 55000 - 10000- 5000 ;
_fv = 5000 ;
_type = 1
( _rate * ( _pv * ( (_rate+1) ^ _nper ) + _fv ) ) / ( ( _rate * _type + 1 ) * ( ( (_rate+1) ^ _nper) -1 ) )
Result = 1480.63
Message was edited by: Steve Wright - Added _ prefix to prevent conflict with FM functions
I have been Googling for about 2 weeks without success. Shows how much info is out there!
I'll give your sugggestions a try.
This is exactly what I was looking for.
Searched the FM help files but was obviously looking in the wrong place.
Thanks again for your help.
Now for the fun bit - working and scripting in FM. Love it!!