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.
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.
The minimum lease payments are the lowest amount that a lessee can expect to make over the lifetime of the lease. The minimum lease payments, including a guarantee of a residual if applicable, are used to value the lease by doing a net present value (NPV) calculation. The method of calculating minimum lease payments is laid out in the Statement of Financial Accounting Standards No. 13 (FAS 13), Accounting for Leases.
Occasionally, we get a customer that has a unique situation where they have to do daily payments. Sometimes they are only during the business week and sometimes they are 7 days a week. This is a calculation that you can do in TValue but it takes a little bit of creativity to do it.