Financial Functions in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Are there any functions in VBA that calculate EMI (Equated Monthly
Installments) ?
Also, any functions to calculate Theoretical Balance of an Account after
'n'th period if all the 'n' EMIs are ideally paid ?
If not, do someone have some custom code to do that ?

I've written some custom code to do these, but the results are far from
perfect. In a precision Accounting Application I'm currently developing,
these inaccuracies are simply unacceptable.

Any help is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accounting Application with MS Access ? 8
Excel function XIRR in VBA 2
VBA script for mathtype equations 0
VBA code to perform calculations 7
Problem with common VBA functions when installing a new system 2
[newbie] financial accounting problem 1
Coding the "yield" function in Access 2
VBA Calculation - taking forever 1

Back
Top