Often, we have no activity on a loan or an investment but we want to know the amount of interest that is accruing or compounding. You can trigger the interest to appear by adding events such as a Payment or Invest for a $0 amount. This causes TValue to calculate the interest and, depending on the compute method, either add it to the principal if you are using Normal (compound interest) or to the accrued interest balance if you are using US Rule (simple interest).
In reviewing the 2017 Berkshire Performance summary, you would be amazed at the impact that compounding has over a number of years. In their report, they show three return calculations: the Berkshire per share “book value” which was a 19.1% compounded annual return, the Berkshire per share “market value” which was a 20.9% compounded annual return, and the S&P 500 compounded annual return of 9.9%. These were from August 31, 1964 to December 31, 2017.
How many times have you had a detailed schedule in Excel and wanted to copy it into TValue instead of inputting it line by line? With TValue 6, pasting lines from Excel into the cash flow matrix can be easy with this advanced feature.
There are some penalties that are pretty straight forward and then there is the IRS Failure to File (FTF) penalty 6651(a)(1). The FTF is a 5% per month penalty to a maximum of 5 months or 25% from the due date or the extension date, whichever is later. If the FTF and the Failure to Pay (FTP) penalty run simultaneously, you only pay 4.5% for the FTF penalty and it caps out at 22.5% as the IRS is limiting the combination of the two penalties to 5% overall. That is the good news.
A customer recently asked how to use TValue to determine the balance and annual interest contributions if they invested $100,000 in an annuity that was compounded annually for 15 years.