Reducing Balance Code

[LaBam]

Please help! I am stock here. I am developing a Payroll System for my office. I am looking for a VBA code to calculate the Interest on a loan using the Reducing Balance technique. It should be such that all we need to do is supply the Principal, Interest and Duration in months (even if the duration is over a year), and the System should show the total Interest due.

Any suggestions!