TValue is a powerful tool for financial calculations because, provided with enough information, it can compute an unknown value. This unknown might include an interest rate, the loan or payment amount, or the number of payments. You just give TValue the information you know and it does the rest. TValue takes into account all the relationships between dollar amounts, dates, and interest rates.
If you don't know the value of a particular field such as a Payment Amount, you state it as "Unknown / [U]". If you don't specify an Unknown, but there is a discrepancy between the amount of the loan and the payments made, TValue will calculate the remaining balance. Usually this discrepancy can be resolved by changing the dates or amounts of cash flows or by altering the interest rate.
After you compute an Unknown, TValue can restore the Unknown(s) to allow you to change other variables and re-compute if needed. TValue will also compute the balance of a loan as of a given date.
You can use the Calculate and Restore Unknowns buttons from the Home ribbon's Compute group or use the keyboard equivalents [Ctrl]+[U] or [F9] and [Ctrl]+[K] respectively.
See also: