Loading ...
Loading ...
Loading ...
APPENDIX - Reference Information 93
Error 4
Out of range
• Amortization worksheet: the value entered for
P1
or
P2 is outside the range 1-9,999.
• TVM worksheet: the
P/Y or C/Y value 0.
• Cash Flow worksheet: the
Fnn value is outside the
range 0.5-9,999.
• Bond worksheet: the
RV, CPN, or PRI value 0.
• Date worksheet: the computed date is outside the
range January 1, 1950 through December 31, 2049.
• Depreciation worksheet: the value entered for:
declining balance percent 0;
LIF 0; YR 0; CST < 0;
SAL < 0; or M01 1 M01 13.
• Interest Conversion worksheet: the
C/Y value 0.
•The
DEC value is outside the range 0-9.
Error 5
No solution
exists
• TVM worksheet: the calculator computed
I/Y when
FV, (N Q PMT), and PV all have the same sign.
(Make sure cash inflows are positive and outflows
are negative.)
• TVM, Cash Flow, and Bond worksheets: the
LN
(logarithm) input is not > 0 during calculations.
• Cash Flow worksheet: the calculator computed
IRR
without at least one sign change in the cash-flow
list.
Error 6
Invalid date
• Bond and Date worksheets: a date is invalid (for
example, January 32) or in the wrong format (for
example, MM.DDYYYY instead of MM.DDYY.
• Bond worksheet: the calculator attempted a
calculation with a redemption date earlier than or
the same as the settlement date.
Error 7
Iteration limit
exceeded
• TVM worksheet: the calculator computed
I/Y for a
very complex problem involving many iterations.
• Cash Flow worksheet: the calculator computed IRR
for a complex problem with multiple sign changes
or PB/DPB with no payback period based on input
cash flow values.
• Bond worksheet: the calculator computed YLD for
a very complex problem.
Error Possible Causes
Loading ...
Loading ...
Loading ...