## Internal Audit – Interactive Report

First a Warning!! To use this spreadsheet, you need excel 2013 or higher, due to the use of table slicers (not to be confused with...

Excel Solutions and Free Spreadsheets for the Financial Analyst & CFO

Latest Posts

## Internal Audit – Interactive Report

First a Warning!! To use this spreadsheet, you need excel 2013 or higher, due to the use of table slicers (not to be confused with...## Mortgage Loan Pool – Default Recovery

For those that follow my blog, you know that I have used amortization schedules extensively in my analysis. This post and spreadsheet takes a closer...## U.S. Gross Domestic Product Dashboard

First a warning. To use the linked spreadsheet, you need Excel 2013 or higher, due to the use of table slicers (not to be confused with pivot...## Add-On Interest Rate to Compensate for Financing Expenses

I was recently asked to provide a spreadsheet that would calculate the add-on interest rate (APR) that would allow the originator of a mortgage to pay...## Testing my VBA Mortgage Portfolio Cash Flows

A few weeks ago, I wrote a post called “Valuing a Mortgage Portfolio With Cash Flow Analysis” along with a spreadsheet using VBA to calculate the...## Required Minimum Distribution (RMD)

You can tell that I am running out of ideas to create new spreadsheets. I’m back to creating tax calculators. This one is concerned with...## How much to withdraw from a taxable account (IRA, 401K, etc.)

I added another calculator to the Taxes spreadsheet. The sheet is call “Withdrawals”. It is a simple calculator, but someone might find it helpful. I was...## Valuing a Mortgage Portfolio With Cash Flow Analysis

This Excel spreadsheet could help small to medium size banks, credit unions, and mortgage investors, to evaluate their mortgage portfolio. It could also be used...## MBS Math Formula. Servicing, CPR, Payment Delay, Default Rate & Loss Severity

I have made adjustments to the MBS mega formula that calculates the price of a mortgage-backed security. It now allows for default rates (CDR) and...## Tax Equivalents

In 2014 I wrote a post and Excel workbook called Tax Calculators, in which I described some of the calculations I had run across during my career....## Average Life VBA Function For MBS

This is the fourth in a series of VBA, User Defined Functions for Mortgage Backed Securities (MBS). The other three are, solve for price given yield ,...## Macaulay Duration VBA Function For MBS (or single loans), Given Market Yield

This is the third in a series of VBA, User Defined Functions for Mortgage Backed Securities. The other two solved for price given yield and...## Market Yield VBA Function For MBS (or single loans), Given Price

If this post looks familiar, it is supposed . My last post was “Market Price VBA Function For MBS (or single loans), Given Yield“. This Excel spreadsheet is...## Market Price VBA Function For MBS (or single loans), Given Yield

I now also have another function to calculate yield given price see: Market Yield VBA Function For MBS (or single loans), Given Price Many of...## Loan Pool Named Formulas, Without An Amortization Schedule

In a recent post I showed math formulas for a pool of mortgages that could calculate any amount, for any month, without an amortization schedule. This...