Author Topic: Accountants! Huddle up.  (Read 6135 times)

pravata

  • Guest
Accountants! Huddle up.
« on: April 20, 2007, 01:17:21 pm »
Lets pretend that Forbes is correct, and the Astros are "worth" $442 million.  Forbes list

Steinbenner says that sounds about right, Marlins front office says bull. 

On 11/10/92, the Astros changed hands.  Mclane paid, give or take, (and to make it a round number) $100 million for the team.  WalMart stock opened at 62.63 on that date.  However, because it has split a few times, the adjusted price was 14.04.  WalMart is at 49.02 today.  If Mclane had just bought $100 million of stock, how much would that be worth today?  We will leave out 15 years of dividends, again for the sake of brevity.

Limey

  • Contributor
  • High Order of the Ferret
  • *****
  • Posts: 32079
  • Tally Ho!
    • View Profile
Re: Accountants! Huddle up.
« Reply #1 on: April 20, 2007, 01:19:42 pm »
Lets pretend that Forbes is correct, and the Astros are "worth" $442 million.  Forbes list

Steinbenner says that sounds about right, Marlins front office says bull. 

On 11/10/92, the Astros changed hands.  Mclane paid, give or take, (and to make it a round number) $100 million for the team.  WalMart stock opened at 62.63 on that date.  However, because it has split a few times, the adjusted price was 14.04.  WalMart is at 49.02 today.  If Mclane had just bought $100 million of stock, how much would that be worth today?  We will leave out 15 years of dividends, again for the sake of brevity.

Not wanting to steal your thunder, or anything, but there's no running costs involved in owning WalMart stock.  Of course, if Drayton has also been making a profit on the Astros (which I don't know one way or the other), then this isn't a problem.
Courage is what it takes to stand up and speak; courage is also what it takes to sit down and listen.

Lurch

  • Pope
  • Posts: 5931
    • View Profile
Re: Accountants! Huddle up.
« Reply #2 on: April 20, 2007, 01:20:20 pm »
$350M
I wish the first word I had said when I was born was 'quote'. Then before I die, I could say, 'unquote.' --Steven Wright

pravata

  • Guest
Re: Accountants! Huddle up.
« Reply #3 on: April 20, 2007, 01:23:21 pm »
Not wanting to steal your thunder, or anything, but there's no running costs involved in owning WalMart stock.  Of course, if Drayton has also been making a profit on the Astros (which I don't know one way or the other), then this isn't a problem.

Yeah, leave out costs too.  I just want to know what the stock would be worth.  Do you divide the 100 million by 14.04 or 62.63?  What would all that be worth now? In 2007 dollars.  

pravata

  • Guest
Re: Accountants! Huddle up.
« Reply #4 on: April 20, 2007, 01:24:15 pm »
$350M

Good answer.  Would you like to show your work? (briefly)

Trey

  • Should Have Quit 500 Posts Ago
  • Posts: 1249
    • View Profile
Re: Accountants! Huddle up.
« Reply #5 on: April 20, 2007, 01:27:11 pm »
Yeah, leave out costs too.  I just want to know what the stock would be worth.  Do you divide the 100 million by 14.04 or 62.63?  What would all that be worth now? In 2007 dollars.  

For $100 Million dollars, you can buy 7.12 million shares at $14.04.  (What he actually would have "bought" on that day was 1.6 million shares for $62.63, but the splits would have turned that into the 7.12 million shares.)  Today those 7.12 million shares would be worth almost $350 million.  (which is what joshd put above, I just felt the need to expound and hear myself type)
Let me explain something to you. Um, I am not "Mr. Lebowski". You're Mr. Lebowski. I'm the Dude. So that's what you call me. You know, that or, uh, His Dudeness, or uh, Duder, or El Duderino if you're not into the whole brevity thing.

Lurch

  • Pope
  • Posts: 5931
    • View Profile
Re: Accountants! Huddle up.
« Reply #6 on: April 20, 2007, 01:27:49 pm »
Good answer.  Would you like to show your work? (briefly)

$100M buys 7.1M shares of stock @$14/each in '92.  7.1M shares of stock worth $49 today = $350M on today's market.
I wish the first word I had said when I was born was 'quote'. Then before I die, I could say, 'unquote.' --Steven Wright

Lurch

  • Pope
  • Posts: 5931
    • View Profile
Re: Accountants! Huddle up.
« Reply #7 on: April 20, 2007, 01:28:25 pm »
I wish the first word I had said when I was born was 'quote'. Then before I die, I could say, 'unquote.' --Steven Wright

pravata

  • Guest
Re: Accountants! Huddle up.
« Reply #8 on: April 20, 2007, 01:29:19 pm »
For $100 Million dollars, you can buy 7.12 million shares at $14.04.  (What he actually would have "bought" on that day was 1.6 million shares for $62.63, but the splits would have turned that into the 7.12 million shares.)  Today those 7.12 million shares would be worth almost $350 million.  (which is what joshd put above, I just felt the need to expound and hear myself type)

Just looked up the splits, yep, it split 2 for 1 twice since 92, so about $313 is what I get.  Not counting dividends.   That's money in his pocket, not projected value. 

Trey

  • Should Have Quit 500 Posts Ago
  • Posts: 1249
    • View Profile
Re: Accountants! Huddle up.
« Reply #9 on: April 20, 2007, 01:34:10 pm »
Just looked up the splits, yep, it split 2 for 1 twice since 92, so about $313 is what I get.  Not counting dividends.   That's money in his pocket, not projected value. 

Right.  So, ignoring profit/losses of running the team, time investments, and being associated with Bud Selig, the Astros are a better deal than Wal-Mart.
Let me explain something to you. Um, I am not "Mr. Lebowski". You're Mr. Lebowski. I'm the Dude. So that's what you call me. You know, that or, uh, His Dudeness, or uh, Duder, or El Duderino if you're not into the whole brevity thing.

Lurch

  • Pope
  • Posts: 5931
    • View Profile
Re: Accountants! Huddle up.
« Reply #10 on: April 20, 2007, 01:34:24 pm »
Of course, he could also have sold his WMT in 2000 for $500M instead of watching 72-90 baseball...
I wish the first word I had said when I was born was 'quote'. Then before I die, I could say, 'unquote.' --Steven Wright

pravata

  • Guest
Re: Accountants! Huddle up.
« Reply #11 on: April 20, 2007, 01:44:54 pm »
Right.  So, ignoring profit/losses of running the team, time investments, and being associated with Bud Selig, the Astros are a better deal than Wal-Mart.

Yeah, and ignoring that he would have made about $62.6 million on Wal-Mart's last dividend of 22 cents per share.

Trey

  • Should Have Quit 500 Posts Ago
  • Posts: 1249
    • View Profile
Re: Accountants! Huddle up.
« Reply #12 on: April 20, 2007, 01:49:02 pm »
$62.6 million

That's pocket change to guys like me and Drayton.
Let me explain something to you. Um, I am not "Mr. Lebowski". You're Mr. Lebowski. I'm the Dude. So that's what you call me. You know, that or, uh, His Dudeness, or uh, Duder, or El Duderino if you're not into the whole brevity thing.

Lurch

  • Pope
  • Posts: 5931
    • View Profile
Re: Accountants! Huddle up.
« Reply #13 on: April 20, 2007, 01:55:39 pm »
Yeah, and ignoring that he would have made about $62.6 million on Wal-Mart's last dividend of 22 cents per share.

7.1M * .22 = $1.56M.  And the .22 was high.  .10 more typical.  So, .40/year for 15 years * 7.1M = $42M in dividends for this time period (although the splits probably make it more like $30M)
I wish the first word I had said when I was born was 'quote'. Then before I die, I could say, 'unquote.' --Steven Wright

pravata

  • Guest
Re: Accountants! Huddle up.
« Reply #14 on: April 20, 2007, 02:02:08 pm »
7.1M * .22 = $1.56M.  And the .22 was high.  .10 more typical.  So, .40/year for 15 years * 7.1M = $42M in dividends for this time period (although the splits probably make it more like $30M)

7.1 was how much he could have bought in 92, it has split 2:1 twice, wouldnt he have about 28 million shares at this point?

Lurch

  • Pope
  • Posts: 5931
    • View Profile
Re: Accountants! Huddle up.
« Reply #15 on: April 20, 2007, 02:06:57 pm »
7.1 was how much he could have bought in 92, it has split 2:1 twice, wouldnt he have about 28 million shares at this point?

Once you used adjusted price at the beginning of the equation, splits no longer mattered.  He bought 7.1M adjusted price shares (or 1.77M unadjusted price)
I wish the first word I had said when I was born was 'quote'. Then before I die, I could say, 'unquote.' --Steven Wright

Limey

  • Contributor
  • High Order of the Ferret
  • *****
  • Posts: 32079
  • Tally Ho!
    • View Profile
Re: Accountants! Huddle up.
« Reply #16 on: April 20, 2007, 02:09:35 pm »
Yeah, and ignoring that he would have made about $62.6 million on Wal-Mart's last dividend of 22 cents per share.

That's $62.6 million before tax.  After tax, it's $62.6 million.  Wait!  What?  Fuck.

Bonus ire:  My effective tax rate = 17.8%.  Walmart's effective tax rate = 3.2%
Courage is what it takes to stand up and speak; courage is also what it takes to sit down and listen.

BizidyDizidy

  • Pope
  • Posts: 8836
    • View Profile
Re: Accountants! Huddle up.
« Reply #17 on: April 20, 2007, 02:12:47 pm »
A better way to value the investments in on their internal rate of return

Assuming the Astros have gone from 100MM to 442MM in 15 years, the IRR is 10.4% (not bad).

For the Wal-Mart stock (not including Dividends), the IRR is 8.7%.

Over the same period, the S&P500 has returned roughly the same as Wal-Mart (maybe a touch more but I believe this figures include dividend reinvestment).

Now, I don't know how to estimate the risk profile of a baseball team relative to the S&P 500; my gut feeling is that a baseball team is a safer investment (has anyone ever lost money on a sale?) That would make his return even better.

Of course, this gets all the more complicated when you factor in dividends vs. net operating income of the team; if they are running at a loss (does anyone still believe that? I forget), then obviously the IRR is decreased (vs. the actual return being slightly higher for Wal-Mart).
"My doctor told me to stop having intimate dinners for four. Unless there are three other people."
  -  Orson Welles

Lurch

  • Pope
  • Posts: 5931
    • View Profile
Re: Accountants! Huddle up.
« Reply #18 on: April 20, 2007, 02:14:33 pm »
That's $62.6 million before tax.  After tax, it's $62.6 million.  Wait!  What?  Fuck.

Bonus ire:  My effective tax rate = 17.8%.  Walmart's effective tax rate = 3.2%

Back off!  They underpay MILLIONS of US employees!
I wish the first word I had said when I was born was 'quote'. Then before I die, I could say, 'unquote.' --Steven Wright

Bench

  • Illuminati
  • Posts: 16476
    • View Profile
Re: Accountants! Huddle up.
« Reply #19 on: April 20, 2007, 02:17:09 pm »
Back off!  They underpay MILLIONS of US employees!

Don't forget about the fantastic benefits they give their legions of "part-time" employees.
"Holy shit, Mozart. Get me off this fucking thing."

Bench

  • Illuminati
  • Posts: 16476
    • View Profile
Re: Accountants! Huddle up.
« Reply #20 on: April 20, 2007, 02:20:05 pm »
A better way to value the investments in on their internal rate of return

Assuming the Astros have gone from 100MM to 442MM in 15 years, the IRR is 10.4% (not bad).

For the Wal-Mart stock (not including Dividends), the IRR is 8.7%.

Over the same period, the S&P500 has returned roughly the same as Wal-Mart (maybe a touch more but I believe this figures include dividend reinvestment).

Now, I don't know how to estimate the risk profile of a baseball team relative to the S&P 500; my gut feeling is that a baseball team is a safer investment (has anyone ever lost money on a sale?) That would make his return even better.

Of course, this gets all the more complicated when you factor in dividends vs. net operating income of the team; if they are running at a loss (does anyone still believe that? I forget), then obviously the IRR is decreased (vs. the actual return being slightly higher for Wal-Mart).

All of that, and he still wouldn't pony up for Beltran or Pettitte. 'Neck.

Seriously though, quite an investment, and we haven't even mentioned the priceless value of enjoyment derived from owning the team. He certainly always seems to me to be having fun.
"Holy shit, Mozart. Get me off this fucking thing."

Lurch

  • Pope
  • Posts: 5931
    • View Profile
Re: Accountants! Huddle up.
« Reply #21 on: April 20, 2007, 02:24:07 pm »
Don't forget about the fantastic benefits they give their legions of "part-time" employees.

The cute old lady that welcomes me with a cart sure seems happy. 

I doubledog dare you to spend 5 minutes here.
I wish the first word I had said when I was born was 'quote'. Then before I die, I could say, 'unquote.' --Steven Wright

Trey

  • Should Have Quit 500 Posts Ago
  • Posts: 1249
    • View Profile
Re: Accountants! Huddle up.
« Reply #22 on: April 20, 2007, 02:30:13 pm »
The cute old lady that welcomes me with a cart sure seems happy. 

I doubledog dare you to spend 5 minutes here.

Triple dog dare here: http://walmartwatch.com/about

There's tons of information on both sides.  This isn't going to be resolved by spending five minutes reading one website or another about it.  If you really care, read a bunch of stuff on both sides (and maybe even some neutral ones) and come to your own conclusions.  But, overall, remember that 99% of the world and 99.9999% of this messageboard doesn't give a shit.
Let me explain something to you. Um, I am not "Mr. Lebowski". You're Mr. Lebowski. I'm the Dude. So that's what you call me. You know, that or, uh, His Dudeness, or uh, Duder, or El Duderino if you're not into the whole brevity thing.

Limey

  • Contributor
  • High Order of the Ferret
  • *****
  • Posts: 32079
  • Tally Ho!
    • View Profile
Re: Accountants! Huddle up.
« Reply #23 on: April 20, 2007, 02:35:47 pm »
Triple dog dare here: http://walmartwatch.com/about

There's tons of information on both sides.  This isn't going to be resolved by spending five minutes reading one website or another about it.  If you really care, read a bunch of stuff on both sides (and maybe even some neutral ones) and come to your own conclusions.  But, overall, remember that 99% of the world and 99.9999% of this messageboard doesn't give a shit.

Not to hijack the thread, I think the venom normally directed at WalMart is misguided.  What they do isn't illegal (mostly), so they are doing what they are required to do by law - maximise returns for shareholders.  The problem lies with the invertebrates in Washington.

If you owned a chicken plucking factory, you'd know what I'm talking about.
Courage is what it takes to stand up and speak; courage is also what it takes to sit down and listen.

Froback

  • Should Have Quit 500 Posts Ago
  • Posts: 2253
    • View Profile
Re: Accountants! Huddle up.
« Reply #24 on: April 20, 2007, 02:36:56 pm »
But, overall, remember that 99% of the world and 99.9999% of this messageboard doesn't give a shit.
Wait... Someone on this site does?

pravata

  • Guest
Re: Accountants! Huddle up.
« Reply #25 on: April 20, 2007, 02:39:58 pm »
Not to hijack the thread, I think the venom normally directed at WalMart is misguided.  What they do isn't illegal (mostly), so they are doing what they are required to do by law - maximise returns for shareholders.  The problem lies with the invertebrates in Washington.

If you owned a chicken plucking factory, you'd know what I'm talking about.

Now this is veering into a lane I never intended.  I was looking for some perspective on the Forbes valuation and what Mclane could have reaped by an alternate and obvious investment.  It's possible he could have taken his $100 million to Poland and practically owned the place by now.

Lurch

  • Pope
  • Posts: 5931
    • View Profile
Re: Accountants! Huddle up.
« Reply #26 on: April 20, 2007, 02:41:03 pm »
Now this is veering into a lane I never intended.  I was looking for some perspective on the Forbes valuation and what Mclane could have reaped by an alternate and obvious investment.  It's possible he could have taken his $100 million to Poland and practically owned the place by now.

Oh, dont get me started on the Poles!
I wish the first word I had said when I was born was 'quote'. Then before I die, I could say, 'unquote.' --Steven Wright

JackAstro

  • Key Member of the Conspiracy
  • Posts: 3824
    • View Profile
    • Twitter
Re: Accountants! Huddle up.
« Reply #27 on: April 20, 2007, 02:47:37 pm »
To answer the original question, and throw my hat into the brevity competition:

49.02 / 14.04 * $100,000,000 = $349,145,299

Simply, if its adjusted starting price is really 14.04 per share, then it's worth 349% of its original value ($100,000,000).
"We live in a society of laws. Why do you think I took you to all those Police Academy movies? For fun? Well, I didn't hear anybody laughing, did you?"
Say hi on the Twitter

BUWebguy

  • Should Have Quit 500 Posts Ago
  • Posts: 2118
    • View Profile
Re: Accountants! Huddle up.
« Reply #28 on: April 20, 2007, 02:57:37 pm »
I first thought this:

Wait... Someone on this site does?

Was a reply to this:

If you owned a chicken plucking factory, you'd know what I'm talking about.
"If you can't figure out that Astros doesn't have an apostrophe, you shouldn't be able to comment." - Ron Brand, June 9, 2010

homer

  • Pope
  • Posts: 6509
    • View Profile
Re: Accountants! Huddle up.
« Reply #29 on: April 20, 2007, 03:18:08 pm »
Quote
Now this is veering into a lane I never intended.

Got to hate it when that happens.
Oye. Vamos, vamos.

Mr. Happy

  • Fantasy Team Owner
  • High Order of the Ferret
  • *****
  • Posts: 23232
  • It's a beautiful day; let's play two
    • View Profile
Re: Accountants! Huddle up.
« Reply #30 on: April 20, 2007, 03:29:07 pm »
Accountants count, but they don't count.
People who cannot recognize a palpable absurdity are very much in the way of civilization. Agnes Rupellier

Caedite eos. Novit enim Dominus qui sunt eius

Trey

  • Should Have Quit 500 Posts Ago
  • Posts: 1249
    • View Profile
Re: Accountants! Huddle up.
« Reply #31 on: April 20, 2007, 03:59:17 pm »
Wait... Someone on this site does?

I do.  But that's why we have PM and I have an email address.
Let me explain something to you. Um, I am not "Mr. Lebowski". You're Mr. Lebowski. I'm the Dude. So that's what you call me. You know, that or, uh, His Dudeness, or uh, Duder, or El Duderino if you're not into the whole brevity thing.

Foghorn

  • Key Member of the Conspiracy
  • Posts: 2839
    • View Profile
Re: Accountants! Huddle up.
« Reply #32 on: April 20, 2007, 04:02:19 pm »
couple other things to note...

(1)  it would be hard for a single investor to buy up $100M worth of stock in one day and not cause the price to trickle upwards.  Especially one who would have been considered an "insider" back in 1991

(2)  when he bought the astros he also got a couple of hotels and the lease to the Astrodome, which was worth something.  

(3)  he now owns Sheriff Blaylock's secret recipe.  can you really put a price tag on that?

(4)  hard to do a 3-way with a couple of silicone enhanced double d's strippers when Wal-Mart has a kick ass earnings release.  at least when compared to the night the Astros won the NL Pennant.
You see pal, that's who I am, and you're nothing. Nice guy, I don't give a shit. Good father, fuck you. Go home and play with your kids. You wanna work here, close. You think this is abuse? You think this is abuse, you cocksucker? You can't take this, how can you take the abuse you get on a sit?

Limey

  • Contributor
  • High Order of the Ferret
  • *****
  • Posts: 32079
  • Tally Ho!
    • View Profile
Re: Accountants! Huddle up.
« Reply #33 on: April 20, 2007, 04:03:53 pm »
(4)  hard to do a 3-way with a couple of silicone enhanced double d's strippers when Wal-Mart has a kick ass earnings release.  at least when compared to the night the Astros won the NL Pennant.
If you have $100 mill, I don't think this is hard to arrange at any time.
Courage is what it takes to stand up and speak; courage is also what it takes to sit down and listen.

pravata

  • Guest
Re: Accountants! Huddle up.
« Reply #34 on: April 20, 2007, 04:09:31 pm »
couple other things to note...

(1)  it would be hard for a single investor to buy up $100M worth of stock in one day and not cause the price to trickle upwards.  Especially one who would have been considered an "insider" back in 1991

(2)  when he bought the astros he also got a couple of hotels and the lease to the Astrodome, which was worth something.  

(3)  he now owns Sheriff Blaylock's secret recipe.  can you really put a price tag on that?

(4)  hard to do a 3-way with a couple of silicone enhanced double d's strippers when Wal-Mart has a kick ass earnings release.  at least when compared to the night the Astros won the NL Pennant.

1) Very true but, as I said, this exercise is for illustration purposes only.  There are way too many ifs and buts.  It's like a 9th grade physics problem where you're told to ignore the effects of gravity. 

2)Yes, the total price was $125 but then he sold off some stuff.  Eventually the actual cost to Mclane was closer to $92, but again for illustrative purposes...

3) Yes, I have an exact price, out to two decimal places what I would pay for Sheriff B's recipe.

4)Polish girls get very excited when you finish building a paved road.  Very.

BudGirl

  • Contributor
  • Illuminati
  • Posts: 17776
  • Brad Ausmus' Slave
    • View Profile
Re: Accountants! Huddle up.
« Reply #35 on: April 20, 2007, 04:17:40 pm »
Oh, dont get me started on the Poles!

You got a problem with the Poles???
''I just did an interview with someone I like more than you. I used a lot of big words on him. I don't have anything left for you.'' --Brad Ausmus

Well behaved women rarely make history.

Andyzipp

  • Guest
Re: Accountants! Huddle up.
« Reply #36 on: April 20, 2007, 04:43:02 pm »
You got a problem with the Poles???

Everyone has a problem with the Poles.  Why just look at how under represented they are in MLB front offices.