Search form

Content: 

TimeValue Software Blog

Reconciling TValue to Excel

By Martel Pellerin

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.

Read More

Actual over Actual Calculation

By Martel Pellerin

In the various versions of TValue, we currently do not do an actual over actual computation where the days and the year length factor in a 366 day year.

There is a workaround in TValue that may be a little painful but will do the proper calculation. Effectively, you need to adjust the interest rate on the first day of the leap year based on a 365/366 basis and then change the interest rate back to the normal Nominal Annual Rate at the beginning of the non leap year. If you cross over multiple leap years, you would have to do it for each leap year.

Read More

TValue Training and Educational Tools

By Martel Pellerin

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.

Read More

Lease Accounting Regulations

By Martel Pellerin

The new Lease Accounting Regulations (ASC 842) require organizations that lease assets, or “Lessees” to recognize the assets and liabilities of those leases on their balance sheets. Most leases, including most operating leases, are now capitalized on the balance sheet.

Read More

Modification, Restructuring, Forbearance on a Loan

By Martel Pellerin

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.

Read More

Pages

Archive