Calculate errors
- 61 - The unknown is too large for TValue to Calculate.
Description: The unknown value cannot be calculated because the result would be too large.
Resolution: Typically, this error happens when you are missing information in the cash flow matrix or when you asked to solve a problem that would produce a very large answer.
For example, if you deposited $1.00 today and wanted $1,000,000.00 tomorrow and wanted to find an interest rate that would make this happen, you would get this error because the interest rate would be huge.
Verify your information and make sure that you are not missing information and that your assumptions about the data are valid.
Balance errors
- 100 - Event dates are out of order.
Description: Certain operations such as running an amortization schedule or calculating a balance require that all cash flow events are in chronological order.
This error indicates that one or more of your cash flow events are out of order.Resolution: On the Home ribbon select the Sort menu button and choose Merge all lines. This will put all of the cash flow events in chronological order.
Once the Sort is complete, you should be able to try the operation that caused the error again. - 101 - The balance cannot be taken before the start date of the cash flows.
Description: The Balance Date must be on or after the Date of the first cash flow Event.
Resolution: Select a Date that occurs on or after the first Date in the cash flow matrix.
- 103 - The balance cannot be taken after the end date of the last cash flow event.
Description: Under Rule of 78, balances can only be obtained between the first Loan Date and the last Payment Date.
This error indicates that you are asking for a Balance on a Date after the last payment has been made.Resolution: Enter a Balance Date that is between the first Loan Date and the last Payment Date.
- 104 - The balance is too large and must be less than $10 billion. If whole amounts are used, the balance must be less than $1 trillion.
Description: The Balance requested would result in a number that is greater than the capacity of the program.
If you are not in Whole Amounts mode, then the Balance must be less than $10 billion.
If you are in Whole Amounts mode, then the Balance must be less than $1 trillion.Resolution: This error may be the result of having an interest rate too high, asking for a Balance that is too far in the future, or working with a Balance outside of the capacity of the program. Try managing the Date, the rate, or reducing the Balance by a decimal.
- 111 - The balance date for the amount you have entered cannot be calculated.
Description: A date cannot be found when the amount you have entered will be reached.
Resolution: Please check the amortization schedule to make sure that your Balance is either increasing over time (as it would with regular deposits in a bank account) or decreasing over time (as it would when you pay off a loan).
If your Balance is increasing over time, then the amount you entered must be larger than the initial balance, and the deposits and interest rate must be high enough to allow the requested Balance to be reached.
If your Balance is decreasing over time, then the amount you entered must be smaller than the initial balance, and the payments must be large enough to pay for more than just the interest every month.
Expand errors
- 161 - Cannot expand when the number of payments is unknown.
Description: In order to Expand a series into separate lines, the Number of payments must be known.
Resolution: If you know how many payments there are, then enter this number in the Number field.
- 164 - Cannot expand a special series when the amount is unknown.
Description: In order to Expand a Special Series into separate lines, you cannot have an Unknown in a field.
Resolution: Choose Calculate from the Home ribbon to solve for the Unknown and then Expand.
Acceptable Range errors
- 2001 - The date entered (date) is outside the range of acceptable values. Please enter a date between 01/01/1600 and 12/31/2400. The value will reset to mm/dd/yyyy.
Description: When entering an Event Date, a Date was entered that falls outside the range of acceptable TValue dates.
Resolution: Click in the Date field that generated the error and enter a Date between 01/01/1600 and 12/31/2400.
Invalid entry errors
- #### - Unable to paste events. The number must be 1 or more.
Description: When pasting from Excel, each required field in the cash flow matrix must be accounted for and at least default to the basic setting.
In the case of this error message, the value of the Number field needs to be greater than or equal to 1.Resolution: In the Excel spreadsheet that you are pasting from, make sure all Number field values are 1 or more. More
- #### - Unable to paste events. Input string was not in a correct format.
Description: When pasting from Excel, each field in the cash flow matrix must be accounted for.
In the case of this error message, a value for a required field was not received.Resolution: In the Excel spreadsheet that you are pasting from, make sure there is a cell for every required cash flow matrix field. More