Author Topic: Did I make a sound financial Decision? (Math nerds help)  (Read 4584 times)

nomoreuntdebt

  • 5 O'Clock Shadow
  • *
  • Posts: 7
  • Age: 36
  • Location: Denton, TX
Did I make a sound financial Decision? (Math nerds help)
« on: January 19, 2013, 11:47:31 AM »
So my wife decided she was no longer satisfied with her current gym. We have been paying $32.46 a month for her membership (includes taxes).

After talking her off the ledge of the local Lifetime Fitness and Yoga studios, we settled on a really nice 24 Hour Fitness that offered everything she needed, and was the same distance from our apartment as the old gym. Here's where you help me with math to see if I actually made a good decision with the membership fees.

Here were the two best options, I chose option B:

A) $120.07 extra upfront fees, 29.99 / month for first year, then $24.99/ month after that. Potentially, the $120 upfront could have been negotiated down.

B) 2-year membership for flat upfront payment of $519.59. This works out to $21.65 a month


In a direct comparison, option A would cost me $779.83 over 2 years, or $260.24 more than option B.

What I am unsure of how to calculate is the indirect cost in interest of not paying $429.51 (option B less first month of option A) towards my student loans this month. My loan balances, that I've been paying off high interest to low are as follows:

$7,405.83 @ %6.55
$9,208.38 @ %6.3
$14,999 @ %6.0
$968.62 @ %5.35
$5,229.61 @ %4.25

I've been paying off between 2 - 2.5k a month on top of regularly scheduled payments, although this amount should increase with the increase in my side hustle profits and a probable 1.5k/mo pay increase for my wife. All will be paid off by April 2014, one way or another.

Is the interest that will accumulate a negligible consideration, or is it significant? I don't really know the best way to go about figuring this out, especially with multiple interest rates on my loans. Did I actually get a good deal, or is the opportunity cost of having to pay more money upfront make option A and B about the same?


Richard3

  • Bristles
  • ***
  • Posts: 292
Re: Did I make a sound financial Decision? (Math nerds help)
« Reply #1 on: January 19, 2013, 12:10:05 PM »
I did a quick Present Value calculation in excel, and unless I messed something up, the cost in today dollars of option a is 737.98

a is 149.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99

formula is =NPV((6.55%/12),B2:Y2)

This assumes all the money goes to the highest interest rate debt. I'm pretty hungover though (thank you $4 beers at hockey) so may well be wrong.

MustacheMike

  • 5 O'Clock Shadow
  • *
  • Posts: 48
  • Location: Canada
Re: Did I make a sound financial Decision? (Math nerds help)
« Reply #2 on: January 19, 2013, 01:04:44 PM »
As a life-long gym-goer I'd say anything involving a fitness club is a waste of money.

To anyone out there who hasn't made a decision yet, if you can't fit in your own gym equipment/bodyweight routines at home, and there are no other options, I would recommend a public recreation centre.

Jamesqf

  • Magnum Stache
  • ******
  • Posts: 4038
Re: Did I make a sound financial Decision? (Math nerds help)
« Reply #3 on: January 19, 2013, 01:26:11 PM »
To anyone out there who hasn't made a decision yet, if you can't fit in your own gym equipment/bodyweight routines at home, and there are no other options, I would recommend a public recreation centre.

Your implicit assumption being that there is one close enough that you don't spend more time & money getting to it than you'd save over a commercial one.

nomoreuntdebt

  • 5 O'Clock Shadow
  • *
  • Posts: 7
  • Age: 36
  • Location: Denton, TX
Re: Did I make a sound financial Decision? (Math nerds help)
« Reply #4 on: January 19, 2013, 03:14:26 PM »
My wife's a big swimmer, the YMCA's only got an outdoor pool with weird hours, and there's no natatorium around here. That and the group classes (body pump, zumba, spin) are her primary reason for going. Also, she is the less-mustachian of the two of us, and I concede to her wishes in some areas for the sake of marital harmony.

Obviously, option C of no gym membership would be the cheapest route. Hijacking the thread into a debate about the wastefulness of fitness clubs wasn't really the point.

nomoreuntdebt

  • 5 O'Clock Shadow
  • *
  • Posts: 7
  • Age: 36
  • Location: Denton, TX
Re: Did I make a sound financial Decision? (Math nerds help)
« Reply #5 on: January 19, 2013, 03:23:31 PM »
I did a quick Present Value calculation in excel, and unless I messed something up, the cost in today dollars of option a is 737.98

a is 149.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   29.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99   24.99

formula is =NPV((6.55%/12),B2:Y2)

This assumes all the money goes to the highest interest rate debt. I'm pretty hungover though (thank you $4 beers at hockey) so may well be wrong.

I'm not quite sure I understand. Are you saying that if I had chosen option A and used 100% of the money I didn't spend on option B towards the high interest debt then the PV is $737.98?

That makes for a more accurate comparison of B to A, but doesn't really answer my question of how much B is really costing me.


marty998

  • Walrus Stache
  • *******
  • Posts: 7372
  • Location: Sydney, Oz
Re: Did I make a sound financial Decision? (Math nerds help)
« Reply #6 on: January 19, 2013, 03:58:12 PM »
If you took $429.51 and paid off the highest rate loan you would save about $56 in interest over the 2 years.

Option A therefore costs $779.83 - $56.27 = $723.56. All else being equal, and assuming your wife is a good girl and does pay off the loan with the difference.

There's a small problem with the question though. You have deemed student loans as your opportunity cost. In economic theory you should choose whatever delivers you the highest utility (satisfaction) as your opportunity cost.

Edit: Ok just re-read that, you're projected to pay off the student loans in April 2014, which means you save about $30 in interest, not $56

Richard3

  • Bristles
  • ***
  • Posts: 292
Re: Did I make a sound financial Decision? (Math nerds help)
« Reply #7 on: January 19, 2013, 04:01:02 PM »
I'm not quite sure I understand either. I was in rougher shape than I thought this morning.

Putting the extra $400 on the loan will save you about $32 in loan interest till April '14   6.50% * $400 * 1.25 (since it's a year and a quarter). Not quite right but close enough for free maths :)


MustacheMike

  • 5 O'Clock Shadow
  • *
  • Posts: 48
  • Location: Canada
Re: Did I make a sound financial Decision? (Math nerds help)
« Reply #8 on: January 19, 2013, 08:01:33 PM »
Hijacking the thread into a debate about the wastefulness of fitness clubs wasn't really the point.

Sorry.