Thank you for your inquiries. 1) Oftentimes, we will indeed model out CP as the revolver. Some companies, including WMT, use CP market as their revolver (of course, they still have an actual revolver facility in place as well). 2) Depending on the nature of the investments, we like to place Short-... Thank you for your inquiries.

1) Oftentimes, we will indeed model out CP as the revolver. Some companies, including WMT, use CP market as their revolver (of course, they still have an actual revolver facility in place as well).

2) Depending on the nature of the investments, we like to place Short-Term Investments as a cash equivalent. If you don't want to do that, create new line items in Current and Long-Term Assets for the Short and Long-Term Investments. You'll then have to figure out if you want to keep the balances constant (recommended) or if you want to mark-to-market. If MTM, then decide if it's AFS or Trading. Usually for a non-financial institution, it'll be AFS, so unrealized gains/losses will also flow thru OCI account to offset any changes (double entry) and allow your model to balance still. Any purchases/sales will flow through here as well.

3) As discussed in class, asset sales are usually considered one-time, non-recurring. Acquisitions require proper M&A accounting treatment and purchase price allocation rules (take our M&A courses: http://www.wallst-training.com/self-stu ... l#package5). Purchases/sales of securities will flow through your Investments accounts (see #2 above) and again for non-banks/insurance companies only.

4) The Debt footnotes in the financial statements will usually provide future debt paydowns required in the next 5 years. For borrowings/refinancings, our assumption is to refi any large amounts that are coming due (absent guidance from footnotes). Also, we tend to check the historical level of new debt issuances (borrowings) for a company on bloomberg or other data vendor - that usually provides a clue to a company's historical trend. Read More

Thank you, I appreciate your feedback. I am finding the class very helpful in my analysis and look forward to investigating some of the online offerings. I will also stay tuned for any of your other course offerings in Chicago.

You're quite welcome. We're glad you enjoyed.
Don't forget to contact us for a discount, especially if you're interested in multiple online packages.