How To Calculate Blended Interest Rates by jim on November 12, 2008

A blended interest rate is an interest rate over an amount where parts of that amount are charged, or earning, different interest rates. Blended interest rates are useful in making important comparisons between different offerings such as mortgages or high yield savings accounts.

With mortgages, the math is simple. You’re calculating the rate based on two separate sums. With a bank, it’s slightly more complicated because you are often accruing interest at one rate for part of the year and then accruing it at another rate for the rest of the year. We’ll explain both.

Mortgages

In the home mortgage example, let’s say you have the choice of getting one loan at $100,000 for 6.00% APY or two loans - one at $80,000 for 5.75% APY and one at $20,000 for 6.50% APY. Which is better? In order to make the comparison, you need to calculate the blended interest rate. Fortunately, it’s an easy calculation.

Take each amount and multiply it by the interest rate. Then add all those numbers together and divide by the total amount. In the above example, that would be:

($80,000 x 0.0575 + $20,000 x 0.065) / $100,000 = 0.0590

The blended rate is 5.9%. It is better to get the two loans.

Mortgages Blended Rate Calculator:
Of course I couldn’t leave you hanging without an easy way to calculate this (no commas or dollar signs please):


First Loan: Amount: , Interest Rate: %
Second Loan: Amount: , Interest Rate: %
Third Loan: Amount: , Interest Rate: %
The blended rate is: %

NOTE: You can also use the above calculator to figure out your blended rate of return on multiple investments with different interest rates, it’s the same equation whether you are earning or paying interest.

Bank Interest

Now we get to the example of one sum accruing interest at one rate for part of the year and at another rate for the rest of the year. This is common if your bank offers a promotional rate for new account holders. Everbank is good example - they offer 4.01% APY for the first three months, then 3.21% APY thereafter.

The first step is determining the APR of both rates. Assuming a monthly period, the APR - APY Calculator tells us that the rates are 3.93% APR and 3.16% APR. Dividing each by twelve, we learn that for the first three months your balance will increase by 0.3792% and then increase by 0.2942% thereafter. The blended rate is:

= ( (1+r1/tp)^r1p x (1+r2/tp)^r2p ) - 1
= ( (1.003275)^3 x (1.002633)^9 ) - 1
= ( 1.00985721200 x 1.0239481162 ) - 1
= ( 1.0340414 ) - 1
= 3.40% APY

Legend:

  • tp is the total number of periods, in our case it was 12,
  • r1 is the first period’s interest rate (APR),
  • r1p is the number of periods you get that promotional interest rate,
  • r2 is the second period’s interest rate (APR),
  • r2p is the number of periods you get that second interest rate (we limit it to 12 months to calculate APY).

To makes things simple, here’s a quick and dirty blended interest rate calculator.


First Period: Interest Rate: % Periods:
Second Period: Interest Rate: % Periods:
The blended rate is: %


{ 6 comments }

APR to APY (And Back!) Calculator by jim on November 05, 2008

I’ve been on a simple calculator making kick lately and built up another one that you might find useful.

The difference between APR and APY is pretty important to understand (but not difficult to understand) but the math can be a pain. Enter: The APR to APY (and back!) Calculator!.

It’s fairly straight forward, enter in an APR or an APY, confirm the number of compounding periods, and click on the button you want to do. The only limitation in the calculator is that it won’t do continuous compounding. You can just put some large number and that’ll be good enough because its rounded to two decimal points anyway. Another point to confirm is whether “daily compounding” is 360 periods a year or 365 periods, banks may use either one (it won’t matter which one you use because of how the calculator is rounding, it’ll give you the same answer).

APR to APY Calculator (and back!)


Annual Percentage
Rate (APR)
Annual Percentage
Yield (APY)
APR: % APY: %
Periods:


{ 1 comment }

Converting APR to APY, What’s The Difference? by jim on September 25, 2008

Cutting Your Ratez, Making a BubbleIf you’ve ever seen any interest rates, chances are you’ve seen the tandem of APR and APY splashed across brochures, flyers, banners, and computer screens. If you didn’t know what the difference was, as I didn’t when I first started reading about this stuff, I’ll give you the quick explanation.

  • APR stands for Annual Percentage Rate.
  • APY stands for Annual Percentage Yield.

What’s the difference between APR and APY?

It’s in how they account for compounding. APR doesn’t consider compounding and APY does, meaning APY will almost always be a slightly higher number.

The short answer is that you can ignore APR and simply compare APYs. If you only get APRs, then you’ll need to do some math and find out how interest is compounded (daily, monthly, annually).

What is Compounding?

Compounding refers to how often interest is accrued on your savings. If your bank does monthly compounding, they will calculate how much you earn in interest every month and add it to your balance (in reality they calculate it daily, but add it onto your balance at the end of the month). If they do daily compounding, they will calculate how much you earn in interest every day and add it to your balance every day. The more frequent the compounding, the more interest you earn. The best type of compounding is known as continuous compounding which takes the number of periods to infinity and calculates interest based on limits (I can’t think of a bank that offers this).

Most banks compound monthly.

Converting APR into APY (and back)

Usually banks will advertise APRs when talking loans and APYs when talking deposits, that’s because APRs are naturally lower and APYs are naturally higher due to compounding. Sometimes they give you both, but in the event you have to calculate one or the other, it’s fairly simple. All you need to know the compounding frequency. For most, that frequency is monthly, or 12 times a year.

APR to APY: If you have APR, simply divide the APR by 12 to get what’s known as the periodic rate. That’s how much interest is calculated per period (in this case, each month). Since you are working with percentages, add 1 to that value and then take it to the power of 12 (the number of periods). Then subtract one

The equations looks like this:

  1. Periodic Rate = APR / Periods
  2. APY = ((1 + Periodic Rate) ^ (Periods)) - 1

APY to APR: If you’re comparing two values, convert the APR to an APY and compare them that way. However, if you really want to do this, just take the second equation above and solve for Periodic Rate given APY, then use that to calculate APR.

  1. Periodic Rate = (APY + 1)^(1 / Periods)
  2. APR = Periodic Rate x Periods

If that math makes your head hurt, just ask for APYs. :)

(Totally Irrelevant Photo: mjkmjk)


{ 3 comments }

Predicting Federal Reserve Rate Changes by jim on June 16, 2008

Ben Bernanke Fed Reserve ChairDo you ever read the news or watch television and wonder what those speakers mean when they say “the market predicts the Fed will [increase rates/cut rates/do nothing]?” I have.

What they are referring to is the federal funds futures market where traders buy and sell options contracts linked to the federal funds rate. Unlike other options, where an actual asset could be delivered (an oil futures contract is actually a contract to buy or sell oil at a future date), the federal funds futures contract is a little different. Rather than butcher the definition, according to the Federal Reserve Bank of Cleveland:

A fed funds futures contract is an interest rate futures; i.e. a futures contract whose value is based on a fixed-income security or interest rate. The underlying interest rate for the fed funds futures contract is the average daily effective federal funds rate for the delivery month. The final settlement price for a contract is 100 minus this average rate.

When the market “predicts” the next Fed action, it’s really what the wisdom of the masses (the fed futures trading masses) believe, based on their trading actions, what the future federal funds rate will be in the delivery month of the option.

Where can you find this information easily? The Federal Reserve Bank of Cleveland’s Fed Funds Rate Predictions page! It’s updated daily and has tons of information (check out the excel spreadsheet you can download).

How can you use this? Outside of fun trivia, one way to take advantage of this is to avoid buying long term CDs if the prediction says the rates will go up and to buy CDs when the rates are going down. While the predictive ability spans only a few meetings in the future, it can give you a better idea if you’re deciding what to do. Of course, since everything is measured in probabilities, anything can happen.

(Photo by NCRC)

###

This week is the third anniversary of the Carnival of Personal Finance at Consumerism Commentary, its daddy.


{ 1 comment }

HSBC Direct Interest Rate APY to 3.50% by jim on June 02, 2008

HSBC DirectHSBC Direct just raised their interest rate to 3.50% APY, leading many of their competitors. By comparison, ING Direct sits at at 3.00% and E*Trade remains at 3.15% (they are three of the five online banks I considered the best online savings accounts).

Is it worth it for you to move your funds from a 3.00% APY interest rate bank account to a 3.50% APY interest rate bank account? No, because the time your funds are in limbo, not earning interest, will make the effort not worth it (unless you have a ton of money). However, the cost to open a new bank account is practically nil and HSBC used to be one the leaders prior to the recent string of Fed interest rate cuts.

Also, this rate is guaranteed through September 15th, which means they can increase or decrease it over the next three+ months. So, use HSBC Direct if you don’t have an account but don’t bother opening one to transfer funds in for this rate.

(Photo by superciliousness)


{ 14 comments }

Remember Certificates of Deposit During Fed Rate Cuts by jim on May 23, 2008

If you think interest rates are falling, put some of your savings into a CD. Since last August (2007), the Federal Reserve, haunted by the spectre of a slowing economy, had been hacking and slashing the Federal Funds and Discount rates. During that run, and until just recently, the prevailing attitude on Wall Street was that the Fed was going to continue cutting the rate until the threat of future inflation balanced out the threat of a recession. With this last twenty five basis point cut at the end of April, the prevailing attitude changed. Analysts now believe the Fed will stand pat and potentially even raise rates in the future.

During those rate cuts, all of the high interest online banks dropped their savings account interest rates dramatically. Since January of this year, the interest rate on E*Trade’s online savings account fell from 4.95% to 3.01% (only to increase, just recently, to 3.15%). ING Direct account holders saw their rates fall from 4.10% to their current rate of 3.00%. If you were able to purchase a CD at the prevailing higher yield online savings account rates for even a year, you’d be sitting pretty on those funds right now and that’s why CDs become popular during a falling interest rate environment.

This is where you say: “Jim, I’m not an idiot, I know that if the rates are going lower then I want to lock in good rates.” Yes, you are not an idiot but the point is I didn’t lock in any funds in CDs, except for my laddered emergency fund, because I didn’t recognize that I should have (or at least should have considered it). It wasn’t an error of judgment but one of ignorance.

Everyone knew rates were going to be cut but not everyone realized they should’ve considered putting a little bit away in certificates of deposit. (I can confidently say that because I know I didn’t) So, the next time you think rates are going to stagnate or fall, lock a little away in CDs.


{ 1 comment }

Don’t Rate Chase High Yield Savings Accounts by jim on January 23, 2008

Stack of GoldThe Fed just dropped the federal funds rates, a ton of banks recently dropped their high yield rates on their high yield savings accounts, and now you’re thinking about switching banks, right? Well … don’t be tempted. There are two huge reasons why rate chasing is a foolish endeavor:

  • Rates are not guaranteed.
  • You lose interest in the interim.

(Case in point, when I opened an E*Trade account three weeks ago, the rate was 5.05% - it’s only 4.40% now. That’s a drop of 0.65%!)

Rates Aren’t Guaranteed

Just because you signed up for a 5.05% APY savings account at E*Trade doesn’t mean that the rate will stay there for any period of time. These bank accounts aren’t CDs and the rate can drop just as easily as you can transfer your funds. While it’s tempting to swap your bank account for another one with a higher rate, the higher rate might disappear in a few days simply because that bank was slow to update their rates! Some banks anticipated the Fed rate drop and lowered their rates, other banks will wait until after the Fed move to shift their rates, you have no guarantee which one your prospective bank is. Banks can and will lower rates to as low as they are able to get away with so chasing is never as valuable as you think it is.

Interest Lost

When you transfer the funds between two accounts, you lose the interest that would’ve been earned during that time. The transfer usually will take about a week so that’s 1/52th of your interest gone. While that may not seem like a lot, you start moving your funds around every few months and that 1/52th becomes 1/26th, then 1/13th… you get the picture.

So, let’s say you still want to rate chase, is there anything you can do to ensure the rates stick? No, but you can do the next best thing, start analyzing their CD rates and consider putting some funds into those. What I do at ING is ladder my CDs in $500-$1000 increments such that I create a psuedo-liquid situation (click thru for an explanation of CD laddering). The laddering gives me some downside protection against a big rate drop and you should be looking for something like that. For example, right now I have several CDs in the 4.90% to 5.25% range - the ING rate is currently 4.1%.

So if you want to chase, look for banks that will let you take a no-minimum CD with a decent rate so you can give yourself some protection against a drop.

(Photo by Shoeless Joe/64)


{ 14 comments }

ING Direct To Return to 3.80% by jim on March 30, 2006

As an affiliate, ING Direct sends me periodic emails regarding the promotions they’ll be running and with the winding down of their 4.75% Winter Save Up event they’ve notified us that they’ll be returning to the pre-promotion rate of 3.80%. So my prediction that ING would lower to around 4.25% to remain competitive was too ambitious.

Update: It appears that the new rate will be 4.0% and not 3.8%. My apologies for the mistake, perhaps their affiliate program needs a little work… today they sent me another email that said the Orange Savings Account would go to 4.0%.

If you’re looking to get a quick $25, hit up this $25 ING referral page. You’ll get $25 for depositing $250 and they get $10.


{ 3 comments }
Send questions, ideas, tips, or monetary gifts to
Get posts by e-mail:


RSS Subscribe  Subscribe
(What is this?)
Copyright © 2005-2008 by JW Enterprise. All rights reserved.