Financial Features
The Professional Edition of DreamCalc offers an extensive range of financial functions, including:
If you are familiar with advanced financial calculators, you will find the features in DreamCalc easy to
use.
Cashflow Sign Convention
When working with cash values, DreamCalc adheres to a sign convention that money received is positive, while
money paid out is negative.
For example, a cashflow in which the first value is negative indicates an initial investment (i.e. money
paid out), whereas further positive cash values indicate money earned (or received) from the investment. This
convention applies for all other calculations.
RPN & Algebraic Input
Financial calculations may be performed in any input modes. Reverse Polish Notation (RPN), however, is
supported by the many financial calculators, and therefore, example calculations will be given using RPN in the
financial sections of the User Guide unless otherwise stated. See Calculator Input Style for information about input modes.
Info. The Bond Calculations section gives the
same example using both RPN and algebraic input.
Financial Keypad Section
DreamCalc Profession Edition provides an additional set of financial keys.
Financial Keys
If these keys are not visible, select:
View->Financial Scientific
Financial calculations are not available in other editions of DreamCalc—if you haven't installed the
Professional Edition (DCP), you can download it from www.dreamcalc.com.
Date Calculations
Date values are used with several financial functions, including bond calculations.
You may find the that DreamCalc handles dates differently than other calculators. For more information,
refer to Calculating with Dates.
Fixed Digit Display
When performing financial calculations, you may choose to set DreamCalc to use fixed digit display. To set
two digit display, from the main menu select:
Modes->Precision->Fixed
Modes->Precision->2 Fixed Digits
Examples in the financial sections of the User Guide will be given using two digit precision, unless stated
otherwise.
Working with Cashflows
If you work with cashflow data, you will find that the DreamCalc Chart &
List Window allows you to quickly enter cashflows and integrates with your spreadsheet application. It will
also give you instant cashflow and cumulative cashflow charts.
To show the Chart & List Window, press F12 at any time. Now, to display the Cashflow Chart, as
shown below, click: Chart->Cashflow.

A cumulative variation may be shown by selecting: Axes->Cumulative.
Entering Cashflows in the List Window
The most convenient method of data input to use the cashflow list in the Chart & List Window. This can
be found on the "List Data" tab, to the right-hand side of the window.
Cashflow List
The main calculator interface is instantly aware of any modifications you make here, and your input can be
used in Discounted Cashflow Calculations.
Using the Keypad
Alternatively, you may enter cashflows using the main keypad.
The [CF0] button clears the data in the cashflow list and enters the current value as the first
amount. Use [CFj] to add consecutive values, and [Nj] to add multiple entries of the same
value.
Example: Key in the following:
-1000 [CF0]
800 [CFj]
500 [CFj]
3 [Nj]
The cashflow list will now contain the amounts: -1000, 800, 500, 500, 500. Additions to the cashflow list
made this way will also be visible in the Chart & List Window.
See also: Discounted Cashflow Calculations
|