This is a call our Support team gets often. A customer is trying to reconcile their Excel worksheet to their amortization schedule in TValue and they ask “Why doesn’t TValue agree with my Excel schedule?”
The answer is usually that the formula’s methodology in Excel needs to be replicated in TValue so we have the same calculation basis to get the same numbers. This would be step one. Once this is resolved and if there are differences, it is often the formulas in Excel that are the issue as the user has copied and pasted, written an incorrect formula, or has inconsistent dates in Excel versus TValue. Generally, we find that TValue calculates the correct schedule 100% of the time with the same assumptions.
TValue amortization software is the bedrock product of TimeValue Software. TValue is a relatively simple program to use but can perform simple to very complex time value of money calculations. TimeValue Software offers a wide range of training and educational tools that are highlighted below to facilitate the usage of the TValue product line.
Modifications and forbearance are hot terms in finance today. Modification is changing the terms on the loan. Forbearance is an agreement where the lender delays their right to exercise foreclosure if the borrower can either catch up to their payment schedule by a certain time or agree to extend the term of the loan.
All versions of TValue amortization software will handle variable rate loans. Normally, loan payments change as the rates change and the term stays the same. Here is a simple calculation to show you the process for doing rate changes in TValue.