Quick Links
Home
. . Introduction
. . Why Business Functions
. . Whats New
. . For Property People
. . . . Why For Property
. . . . PCS Seminar
. . Why Free
. . Awards
. . Key Users
. . Forum
. . Excel 12
Products
. . Overview
. . Business Functions
. . . . Summary
. . . . Function Selector
. . . . Function Finder
. . . . Trace
. . . . Help
. . . . Function Examples
. . . . Tutorials
. . . . Monte Carlo
. . . . GoalSeek
. . . . Utilities
. . . . Callable from VBA
. . . . Array Functions
. . . . CashFlow Administrator
. . . . Select Function
. . . . Number Formats
. . . . Excel 2007 Version
. . . . Functions Overview
. . CashFlow Administrator
. . SelectFunction
. . NumberFormats
Services
. . Services Overview
. . Bespoke Model Development
. . Implementation Assistance
. . Custom Editions
Download
Reference
. . Function Categories
. . Function Families
. . Data Types
. . Variables
. . Topics
. . Features
. . Version History
. . Technical
Forum
Templates
. . Templates Home
. . Loans
. . Interest Rates
. . Finance
. . Math and Stats
. . Budgeting
. . Dates
. . Accounting
. . Real Estate
. . Real Estate (UK Specific)
. . Petroleum Economics
. . Techniques
. . Non Business Functions
Resources
. . Resources
. . Bookshop
. . Support
. . Tips & Articles
. . . . Tips
. . . . Business Functions
. . . . Excel
Company
. . Company
:: Reference
:: Function Categories
Home
Introduction
Why Business Functions
Whats New
For Property People
Why Free
Awards
Key Users
Forum
Excel 12
Products
Overview
Business Functions
CashFlow Administrator
SelectFunction
NumberFormats
Services
Services Overview
Bespoke Model Development
Implementation Assistance
Custom Editions
Download
Reference
Function Categories
Function Families
Data Types
Variables
Topics
Features
Version History
Technical
Forum
Templates
Templates Home
Loans
Interest Rates
Finance
Math and Stats
Budgeting
Dates
Accounting
Real Estate
Real Estate (UK Specific)
Petroleum Economics
Techniques
Non Business Functions
Resources
Resources
Bookshop
Support
Tips & Articles
Forum
Company
Function Categories
Function Families
Data Types
Variables
Topics
Features
Version History
Technical
[Categories]
[Families]
[Data Types]
[Variables]
[Topics]
Date and Time Calculations category
Calculations on Dates and TimePeriods
Special Dates category
Date calculations using or taking account of special days in the calendar such as holidays.
Discrete Amount Projections category
Project one or a series of amounts that are paid at discrete times
Distributed Amount Projections category
Project an amount that is spread over a period of time
Constant Rate Projections category
Project using a constant rate of payment
Stepped Rate Projections category
Project using a stepped or changing level of payment
Interpolated and Curve-Fitted Projections category
Project using a changing level of payment
Instantaneous Level Projections category
Project a level of something at a certain time by reference to one or a series of levels that change with time.
Levels Over Time Projections category
Project a level of something during a certain time period by reference to one or a series of levels that change with time.
Projections NPV category
Calculate Present Value"s of the Projections functions
Time Value Of Money Analysis category
Analyse cash flows using Discounted CashFlow analysis, NPV and convert between different bases of Interest Rates
Discounted Cash Flow category
Calculate Discounted Cash Flow economic indicators
Accounting And Tax category
Accounting and Tax
Mathematical Calculations category
Do mathematical calculations
Range Operations category
Do calculations on one or more ranges.
Simulation Modelling category
Simulation Modelling
Real Estate category
Project business forecasts for the Property Industry, such as Rent.
Banking category
Calculations to do with all aspects of banking
Petroleum Economics category
Petroleum Economics
Text category
Do text manipulations
Miscellaneous category
Miscellaneous functions
Any comments on this documentation? Send us your suggestions below.
Your Email Address (required)
Subject
Message
9