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 HP-12C calculator, with Reverse Polish Notation, you have been holding onto for the last 30 years. Their are five inputs to the calculator: Rate Cash Flow (Payment) Number of Cash Flows Present […]

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 my VBA. The amortization schedule provided below is not the typical amortization. It has a number of uses besides explaining the math of constant prepayment rates (CPR) and servicing. For example, if you […]

Total the amount for each date, on multiple sheets

I ran into this problem in accounting. A workbook was being generated by the general ledger that created separate sheets for each ATM, with dates and deposits.  There were a total of 19 ATMs. Individual dates for each sheet were in column A and amounts in column C. The dates did not necessarily show up in the same […]