Investors often have confusion about the rate of return used in annuities in general and in DCF Income Payments in particular. DCF Income Payments (also known as Secondary Market Annuities) are in reality quite simple- they are nothing more than an amortizing payment stream, with each payment containing principal and interest. It is basic discounted cash flow (DCF) math that uses a discount rate and an amortization schedule to arrive at price.
The yield of the investment is also the same as the discount rate, or internal rate of return, and the price of the investment is also the same as the net present value of the payment stream at that discount rate.
UNDERSTANDING THE AMORTIZATION SCHEDULE
The amortization schedule shows the principal and interest component of each payment. Amortization refers to the reduction of a debt or investment over time by paying back the debt over the period. With amortization, each payment is comprised of both a principal repayment component and an interest component on the debt/investment.
After each payment, the remaining principal is the loan or investment balance that is still outstanding. As more principal is repaid with each passing payment, less interest is due/received on the adjusted principal balance. Over time, the interest portion of each monthly payment declines and the principal repayment portion increases.
Amortization is most commonly encountered by the general public when dealing with either mortgages or car loans but in this case, refers to the periodic principal reduction plus the interest returned to an investor over the life of the DCF Income Payment stream.
The price paid for the DCF Income Stream is calculated using the discount rate, or internal rate of return on the payments (IRR). This is the rate that is applied to the diminishing principal balance each month until all the principal and interest has been returned to the investor.
TIME VALUE OF MONEY EXAMPLE
Discounted cash flows involve the concept of Time Value of Money- a dollar tomorrow is worth less than a dollar today. How much less? That requires the ‘Discount Rate’ to calculate, and discount rate and effective rate are synonymous for these investments.
Here’s a simple example:
$100 in 1 year at a 10% discount rate will cost $90.91 today.
A $90.91 investment today at a 10% Effective rate with monthly compounding will yield $100 in 1 year.
CALCULATING EFFECTIVE RATE FOR YOURSELF
The yield, or effective rate of return, is also equivalent to the Internal Rate of Return, or IRR. To calculate IRR in in MS Excel, use the formula XIRR=((payments),(dates),0). This formula calculates the discount rate, or effective rate, for a given series of payments on definite dates. XNPV may also be used to solve for the purchase price of a series of payments on definite dates at a known discount rate.
Click Here for an Excel sheet of the example above. Note that MS Excel uses daily compounding in the XIRR function, whereas most loans and all DCF payments use monthly compounding. These slight variations in the amortization table end up with slightly different values and XIRR may vary by a few thousandth’s of a point. This industry uses actual/ 365 day year and monthly calculation methodology in our calculations.