modelling guidance/insights - newb alert..

Water Cooler Investing
#1

hey guys…

im going to be purchasing a modelling course here in the next month or so, but wanted to start taking a stab at some things using some free material i have to see what i could come up with, and then make adjustments as i learn more throughout the self study.

so im working on TGT right now and im curious how i should handle the credit card business. they provide revenues separately in the 10-k for the credit cards, but i just projected out using total revenues. im having more of a problem with the balance sheet as one of the items is “credit card receivables net of inventory”. having trouble with this…

  1. the credit card revenues led me to believe this was money they are making off of the target card, but what would "credit card receivables net of inventory "be? this may be a lack of my understanding of the business, but i dont think that its them waiting for visa, mastercard, amex, or whoever to pay them for purchases made on cards in general, i would think its the outstanding balances on the target card only. if so, i get it, and then does that mean that if they didnt have a credit card division then they wouldn’t have any receivables because there is no “accounts receivable”??? is that typical in retailers? also, for the first time at least in the last 5 years it is being shifted from credit card receivables “net of inventory” to “held for sale”…are they selling their receivables to collect sooner?

full disclosure - i have not read the 10k yet. i was trying to get a working model going and then was going to read it and make any adjustments i felt were necessary after the fact. i am starting to realize that maybe this isn’t the best idea, like trying to run a marathon without ever having attempted a 5k, but again this is for leisure/practice and my first stab at it.

any insight would be appreciated!

#2

Start training for the 5 k.

#3

jesus nevermind…decided to open the 10k and within the first paragraph some of this is covered…fail

#4

This is a good experience. Don’t worry about looking stupid some of the time (hopefully not all the time!!). I like the initiative to just go at it.

I’ve had “doh” situations in the past too, so it happens.

#5

yeah…i thought about deleting it before some of our more vocal friends on here called me out, but i figured its the internet…unlike some people i have nothing to prove

#6

^ You aight. We need more detailed discussion here. In anycase, taking on TGT for practice is pretty daunting. A more simple business under $1B would probably help you get your head around modeling faster.

Don’t let the 10k scare you. It’s written well for an average dumb charterholder like me to read.

#7

appreciated CvM…yeah it might be daunting, but its actually kinda interesting…and i dont expect to be accurate as much as just trying to get one up and running…my interest is in retail so i may shift to some small retail shops after messing around with this.

ive learned some good stuff so far (14 pgs in out of 70ish)…they sold their red card business to TD Bank and will now share in the profit, which is why credit card receivables is HFS, and their shared profit will be an offset to SGA going forward…totally wouldn’t have even modelled SGA intelligently without knowing that…and they are expanding majorly in canada this year…

i wish this was my day job… (i know some of you who’s day job this is probably chuckle at that)