Note: You can use any financial calculator to do this problem, but if you want the BEST, you can get our 10bii Financial Calculator for iPhone/iPad, Android, Mac, Windows 8.1/10,
and Windows 7!


THE SCENARIO

Earlier this week, I went shopping at Costco, where I get a lot of my staple foods, paper products, cleaning supplies, gasoline, and other essentials. I knew that my “Gold Star” membership was expiring, and that I would have to pay $60 to renew it in order to buy the things I wanted to buy that day. When I went up to the Membership counter, I saw that they also have an Executive membership, which costs $120. What do you get for that extra $60? The main thing is that at the end of the year, they send you a rebate check amounting to 2% of your purchases over the year. There are other advertised benefits, but I don’t know that I’d be able to take advantage of any of them reliably, so I had to make my decision based entirely upon the rebate.

So the question is this: If I want to make 15% on my money, how much would I need to spend per month (on average) to justify getting the Executive membership instead of just renewing my Gold Star membership?


THE SOLUTION

This problem has 3 steps. First, I need to find out how big the end-of-year rebate check should be to make me 15% on the extra $60 that the executive membership costs.

Then, I need to figure out how much I’d need to spend over the year to get a end-of-year rebate check of that amount.

Then, I need to figure out how much I’d need to spend each month (on average) to add up to that total annual amount.

Let’s get started.

Step 1
First things first, make sure the calculator is using 12 Payments per Year.
N: 12 (I get the rebate check after one year)
I/YR: 15 (I want to make 15% on my money)
PV: -60 (I have to pay an extra $60 to get the Executive membership)
PMT: 0 (I only get the rebate check at the end of the year; checks don’t arrive in the meantime)
FV: (this is what I’m trying to find)

The answer to Step 1 is that my rebate check would have to be at least $69.65 for me to make 15% on my money. Note that due to monthly compounding, this number is slightly higher than 115% of $60.

Step 2

2% of [total annual spending] = $69.65
2% is another way of writing 0.02
Therefore, [total annual spending] = $69.65 / 0.02 = $3,482.26

The answer to Step 2 is that I’d have to spend at least $3,482.26 over the next year to get a rebate check that large.

Step 3

If I spend $3,482.26 over a whole year, that means that I spend $3,482.26 / 12 each month (on average).

The answer to the whole question is that I’d have to spend an average of $290.19 per month in order to get a rebate check big enough to get me 15% on the extra $60 I’d spent on the Executive membership.

I generally don’t spend $290.19 per month on staples at Costco, so upgrading to the Excecutive membership probably wouldn’t make sense for me unless I thought it likely that I’d be buying one or more big-ticket items there (like a computer, iPad, TV, etc.) in the next year. In that case, I’d adjust the amount I’d need to spend in the year based on that extraordinary planned purchase (for example, if I planned to buy $2,500 worth of iPads, computers, TVs, and other big-ticket items, my annual number would go from $3,482.26 to $982.26) and use $982.26 to determine my required average monthly spending to compare with my normal monthly spending. Obviously, I wouldn’t want to spend extra money just to get a 2% rebate, but if I’d already planned to do the spending, then setting up a rebate ahead of time might be a smart move. Does that make sense? Let us know what you think in the comments below!

Download 10bii Financial Calculator

Money Blog – Costco Executive Membership
Tagged on:                 

2 thoughts on “Money Blog – Costco Executive Membership

  • September 5, 2017 at 12:28 am
    Permalink

    I converted to the Executive Card and ended up with a check for 41.55 at the end of the year. I have 3 checking accounts and I did order checks that were cheaper than buying them at the bank. I cannot remember the difference, but I might haved saved over $20. You do not receive a any credit for the purchase of gasoline. If you did I probably would do better.

    Reply
    • September 5, 2017 at 7:25 pm
      Permalink

      Interesting, I’ll have to see if I need checks this year, and save even more money that way! Thanks for the tip! I tend to buy most or all of my gas at Costco, and even without a 2% rebate, it’s still at least 2% cheaper than anywhere else around.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *