Hey @Anonymous User and anyone else that might be able to help.

I am trying to create a loan repayment calculator in CRM. So far I have wasted days on this! 

It is a very simple PMT formula in Excel, but it seems to be impossible to recreate in CRM. Neither a function nor a formula field is working. I don't need the schedule of payments, just the payment. 

Does ANYONE have a solution they can give me, pretty please with a cherry on top!

Thanks