Time & Dollar Weighted Rates of Return Calculator

Most asset managers will publish their results in both time-weighted (TWRR) and dollar-weighted (DWRR) rates of return. TWRR is typically used by portfolio manages to compare their portfolio’s return to either other managed accounts or to an index. TWRR is more difficult to calculate for individuals because it requires more data. One must have not […]

Amortization – Variable Terms, Rates, & Payments

In my last post (PV & FV of Periodic Uneven Cash Flows & Rates) I created  uneven cash flows, terms, and rates for the present and future value of an annuity. I decided that I would apply these options to an amortization schedule. Two other posts and spreadsheets that allow multiple changes to amortization schedules […]

PV & FV of Periodic Uneven Cash Flows

In the last post we looked at graduated annuities, where the cash flow changes at a given rate. Imagine you need the present value of an annuity with a cash flow that changes unevenly and that change stays the same for certain periods. Take for example the cash flow below: Here we have a 10-year annuity that pays $1,000 each month for […]