What are some of the things to look for when reconciling from Excel? First is the computation methodology. Generally, we find that TValue calculates the correct schedule 100% of the time with the same assumptions. 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. 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. 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?” ![]() This is a call our Support team gets often.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |