| Financial Toolbox |
  |
Analyzing and Computing Cash Flows
Annuities
annurate
|
Periodic interest rate of annuity.
|
annuterm
|
Number of periods to obtain value.
|
Amortization and Depreciation
amortize
|
Amortization.
|
depfixdb
|
Fixed declining-balance depreciation.
|
depgendb
|
General declining-balance depreciation.
|
deprdv
|
Remaining depreciable value.
|
depsoyd
|
Sum of years' digits depreciation.
|
depstln
|
Straight-line depreciation.
|
Present Value
pvfix
|
Present value with fixed periodic payments.
|
pvvar
|
Present value of varying cash flow.
|
Future Value
fvdisc
|
Future value of discounted security.
|
fvfix
|
Future value with fixed periodic payments.
|
fvvar
|
Future value of varying cash flow.
|
Payment Calculations
payadv
|
Periodic payment given number of advance payments.
|
payodd
|
Payment of loan or annuity with odd first period.
|
payper
|
Periodic payment of loan or annuity.
|
payuni
|
Uniform payment equal to varying cash flow.
|
Rates of Return
effrr
|
Effective rate of return.
|
irr
|
Internal rate of return.
|
mirr
|
Modified internal rate of return.
|
nomrr
|
Nominal rate of return.
|
taxedrr
|
After-tax rate of return.
|
xirr
|
Internal rate of return for nonperiodic cash flow.
|
Cash Flow Sensitivities
cfconv
|
Cash flow convexity.
|
cfdur
|
Cash flow duration and modified duration.
|
| | Charting Financial Data | | Fixed-Income Securities | |