Business Functions Basic Edition description
A function library for Microsoft Excel for Business Plans and Financial Analysis
Business Functions is a free function library for Microsoft Excel that is designed in order to make business plans, budgets, structured financings and cashflows.
This Excel add-on provides 102 functions for financial modeling, business planning and financial projections.
There are categories for date and time arithmetic, and discounted cashflow analysis. The system comes with a function selector, a help file, a quick reference, examples and a trace facility for finding errors in function inputs.
Business Functions is based on the principle that using a purpose-built function in a cell is more transparent, reliable, flexible and accurate than an overly long Excel formula.
This principle has been extended to a comprehensive projections
functions that project cashflows and accruals with a high degree of daycount accuracy.
Up to 500 or so functions in C++ do the dirty work of projecting costs and revenues, coping with time periods, growth etc. As a BF user you also have access to the templates, all built with Business Functions.
Here are some key features of "Business Functions Basic Edition":
· Industrial strength function performance from optimised C++ code.
· Rapid access Function Selector and searcheable Function Finder
· Debug and error Trace facility. No more unexplained #NUM! errors.
· Comprehensive function set for business planners and analysts.
· Accurate and advanced date arithmetic, offering unlimited daycount options.
· Functions either return accruals or cash (ProjMode variable).
· Choice whether to use projections functions one-per-cell or as array functions.
· Change the timebase of your entire budget by changing just one variable (Base)
· Comprehensive documentation in context-sensitive help file and online help, including limited code visibility for the pay editions.
· Spreadsheet examples of each function as well as pre-prepared templates available online (example).
· 3 tutorials.
· Many productive utilities.
· Callable from VBA, so you can use them in your own custom functions and macros.
· Forum and timely email support.
· Common-sense function names eg 'MkPmts', 'NextDateSeq, 'AnnGrow', 'FStepRent', 'Loan', 'Mortgage'.