Relationships – XIRR(), Amortization, Present & Future Value

Why do I seem obsessed with amortization schedules?  I  think they make it easier to understand other calculations. In this spreadsheet we will consider the relationship between the Excel XIRR() function (Internal Rate of Return), Present and Future Values, and of course an amortization schedule. The first thing to discuss is the difference between APR (Annual Percentage Rate) and APY […]