User Manual
Index 139
Examples
accrued interest, 79
accumulated interest and loan
balance, 56
amortization, 55
amortization schedule, 50, 54, 55,
56, 57
annual savings, 44
annuities, 42, 43
bond price, 79
bond price and accrued interest, 79
Canadian mortgage, 57
cash flow, 67
compound interest, 102
compounding periods, 53
correcting an entry error, 12
cost savings, 40
cost-sell-markup, 103
days between dates, 107
declining balance with straight-line
crossover, 85
down payment, 52
editing cash flow data, 68
entering cash flow data, 67
future value, 53
interest conversion, 105
internal rate of return, 69
Last Answer, 20
lease or buy, 46
lease with uneven payments, 70
loan amortization, 55
loan amount, 52
memory, 17
monthly deposits, 51
monthly payments, 49
mortgage payments, 54
net present value, 67, 69, 71
one-variable statistics, 95
percent change, 102, 103
perpetual annuity, 42, 43
present value, 43, 44, 48
profit-margin calculations, 109
regular deposits, 53
residual value, 48
saving for future, 51
straight-line depreciation, 86
two-variable statistics, 96
variable cash flows, 44
yield to maturity, 50
EXP
(exponential regression), 88, 89, 90
Exponential regression (
EXP
), 88, 89, 90
—F—
Face value, 76
Factorial, 14, 15
FC
(fixed cost), 110, 111
Fixed cost (
FC
), 110, 111
Floating-decimal format, 6, 7
F
nn (frequency of nth cash flow), 60
Forecasting, 90
Formats
angle units, 6, 7
calculation method, 10
dates, 8, 106
decimal places, 6, 7
number separator, 9
setting, 6
Formulas
30/360 day-count method, 124
actual/actual day-count method, 123
amortization, 118
bonds, 119
breakeven, 123
cash flow, 118
days between dates, 123
declining-balance depreciation, 121
depreciation, 121
interest-rate conversions, 122
percent change, 123
profit margin, 123
regressions, 122
statistics, 122
straight-line depreciation, 121
sum-of-the-years’-digits
depreciation, 121
time value of money, 116
French declining balance (
DBF
), 82, 83,
84
French straight line (
SLF
), 82, 83, 84
Frequency, 60, 63, 64, 65, 74, 75, 77, 88,
89, 91, 95, 118, 126
Frequency of nth cash flow (
F
nn), 60
Frequency of X value (
Y
nn), 88, 89
Future value (
FV
), 28, 29, 30
FV
(future value), 28, 29, 30
—G—
Grouped cash flows, 62
—H—
HYP
(hyperbolic function), 5, 14
Hyperbolic function (
HYP
), 5, 14