Latest Posts
  • Even Cash Flow Calculator

    This worksheet just might make calculating things like loan payments, the amount that could be borrowed, the interest rate, etc. a little easier than the...
  • Interpolation

    There has been an addition to the spreadsheet, explained in the post:  Simplified Linear Interpolation of Treasury Rates Back in the day, when I was...
  • APR Calculator for PayDay Loans

    Most banks and credit unions offer payday loans. So do many check cashing stores and online sites. You can find payday loan calculators online, but...
  • Valuing Servicing With CPR

    Long before I wrote user defined functions for valuing servicing on a pool of mortgages, I developed amortization tables to understand the cash flows and proof...
  • Dashboard for Bonuses

    After the end of the year, it is time to start thinking about budgets and goals. It is also time to set goals for next years bonuses....
  • No XNFV Excel Function?

    You might have already used the XNPV built-in Excel function for calculating the present value of a stream of cash flows with dates. How about XNFV...