Excel decision modeling tools

There are numerous Excel decision modeling functions including:

IPMT – used for the calculation of interest payment on an investment or a loan
PMT – used when you want to establish the periodic payment on an annuity
RATE – applicable when you need to calculate the interest rate for specific periods
NPV – calculates the Net Present Value
MIRR- is used to the Modified Internal Rate of Return
IRR – is perfect for the calculation of the Internal Rate of Return
FV – calculates the Future Value of an investment

From the above it is clear that there are already a few built-in Excel decision modeling tools that can be used in business. Other useful tools are the What if, COUNTIF/SUMIF and VLOOKUP functions. Help on using the tools are available at our free training pages.

Additional help is available

In addition you will find the AssumeIT Sensitivity Analysis Software Tool available from us extremely useful in Excel decision modeling. The tool allows for the selection of sensitivities to be run, the inputs and outputs, and whether or not to run them all at once.

The AssumeIT tool has several advanced features including that of saving sensitivities for later use in other spreadsheets and a one click adjustment for the #Div/0! Errors. The AssumeIT Sensitivity Analysis Software can be run on Excel 2003 and 2007. It is furthermore operational on most XP and Vista operating systems. Ensure cleaner spreadsheets, perfect formulas, and excellent Excel decision modeling for the modern day business environment by downloading a free 30 day trial version of the AssumeIT Sensitivity Analysis Tool.