17
Chapter 3
Financial Functions
General Information
Financial calculations
The following fi nancial functions are available. Use NORMAL
mode to perform fi nancial calculations.
TVM (Time Value of Money) solver:
Analyze equal and regular
cash fl ows. These include calculations for mortgages, loans,
leases, savings, annuities and contracts or investments with
regular payments.
Amortization calculations:
Calculate and create amortization
schedules using values stored in the TVM solver.
Discounted cash fl ow analysis:
Analyze unequal cash fl ows
and calculate NPV (net present value) and IRR (internal rate of
return).
Bond calculations:
Solve bond prices or yields to maturity with
accrued interest.
Depreciation calculations:
Obtain depreciation base values
using three types of calculation methods.
Conversion between APR and EFF:
Interest rates can be
converted between APR (annual, or nominal percentage rate)
and EFF (effective interest rate).
Day and date calculations:
Calculate dates and the number of
days between dates.
Percent change/Compound interest calculations:
Calculate
percent change (increase or decrease) and compound interest
rates.
Cost/Sell/Margin/Markup calculations:
Calculate cost, selling
price and margin/markup.
Breakeven calculations:
Calculate breakeven points (quantity)
using fi xed costs, variable costs per unit, unit prices, and profi t.
3 Financial FunctionsCurrent.indd 17
3 Financial FunctionsCurrent.indd 17
06.7.10 8:38:07 PM
06.7.10 8:38:07 PM