Business Functions Library for Excel

    1. Excels Dynamic Array Formula and the Mysterious @ sign
    2. Version 1.63
    3. New Version And Now Free
    4. Excel 2016
    5. Residual Cash and Debt Functions
    1. Library Only Install
    2. Manual Install
    3. What does the install program do?
    4. Now supporting 64 bits!
    1. New Web site virtually completed
    1. Installer error: if you get 'Access denied'
    2. BF and 64 bits
    1. Error Reports
    2. BF and 64 bits

Residual Cash and Debt Functions

Thu 04 Jun 15


The residual cash functions in BF are really useful but they are a bit trickier to use.

There is a very reasonable reason for this in that they nearly always exist as 3 lines that work together - interest, principal and balance.

However, they are really useful, and the more advanced "array function" versions do things almost certainly faster and cleverer than you could yourself.

So I made this little chart to help you through choosing which of the basic Residual Cash functions fits your needs. It helped me anyway!

(Click it to enlarge)

Business Functions Ltd, London, UK Website Design: Webpure