Home » Archive by category "Uncategorized" (Page 8)

Currency Risk

After the bubble burst in home prices (along with the rest of the U.S. economy), I was wondering what happened to the European investors that were buying up million dollar condos in Florida at the highs. They had two major risks if they were not...
Continue reading »

Amortization Schedule With Variable Rates

Note: I have updated this post with more options. See Variable Rate Amortization – Day/Year Count & Last Payment Options. Have you ever wanted an amortization schedule where you can set the rate for one term and then change the rate for another term, and...
Continue reading »

PSA vs. CPR

In past posts I showed you how to calculate a Constant Prepayment Rate (CPR) with an amortization schedule. This post will allow you to compare a CPR rate to a model provided by the Public Securities Association (PSA). PSA is based upon the CPR calculation. Both...
Continue reading »

Macaulay Duration Plus Balloon Payment

I was asked by a reader to add an option to the workbook “MacaulayDuration”. The option is to include a balloon payment. I added the option in a separate workbook called “MacaulayDuration_with_Balloon”. Read my post on “Macaulay Duration of an Amortizing Loan” for further information. Download...
Continue reading »

Dutch Auction

The U.S. Treasury (and other countries) uses a Dutch auction to sell securities. This workbook contains two examples of how a Dutch auction might work. One assumes the bids are on a yield basis or discount rate basis, like Treasury bills. The other sheet is the...
Continue reading »

APR – Adjustable Rate Mortgage (ARM)

Like the previous post this worksheet calculates the APR, but for an adjustable rate mortgage or ARM. The difference between the fixed rate and the ARM is that the ARM cash flow is based upon reaching the fully-indexed rate, given the information available when the loan was made, and assumes...
Continue reading »

APR – Fixed Rate Mortgage

Given the inputs in yellow cells, check boxes and option buttons, this sheet uses an amortization schedule to calculate APR (or APY) for a fixed rate mortgage. Both Loan Balance and Interest Rate need no explanations. Truth in Lending Fees are additional dollar costs to the...
Continue reading »

Time Value Of Money

 Back when financial institutions wanted your money and actually competed for your deposits, there were all kinds of gimmicks to entice you to deposit your money with them. One such gimmick was a credit union that was offering to pay the interest upfront on their certificates of deposit...
Continue reading »

Two Mortgage Payoff Tables

Assuming you don’t have a balloon payment on your fix rate mortgage, these two tables may be helpful. Table1 will tell you when your mortgage will be paid off, given making extra payments each month. Table2 is the reverse of Table1, in that you give...
Continue reading »

Credit Card Payoff

When you get your credit card bill you might see a box that tells you how long it will take to pay off the balance if you make the minimum payment. This spreadsheet shows the payoff years, give a minimum payment of the greater of:...
Continue reading »