548-Week 5 MBA.PM Spring 2010

548-Week 5 MBA.PM Spring 2010 - J. K. Dietrich - GSBA 548...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: J. K. Dietrich - GSBA 548 MBA.PM Spring 2010 Valuation of Capital Investments and Estimating Corporate Cash Flows Week 5: March 29 and 31 (LA) March 30 and April 1 (OCC) J. K. Dietrich - GSBA 548 MBA.PM Spring 2010 Assumptions for Cash Flows Sources of Data Basic documents Computer sources of data Financial models for valuation Entity approach Relation to spreadsheet PVFIRM06 How and why to use ratio analysis Part 2 of group project J. K. Dietrich - GSBA 548 MBA.PM Spring 2010 Projecting Corporate Cash Flows Goal is familiarity with financial analytical techniques in practice Understand structure of PVFIRM06 and be prepared to use for Part 2 of Group Project Download Compustat data from Wharton Identify relevant materials on companies, industries, and the economy for assumptions Team organized and functioning J. K. Dietrich - GSBA 548 MBA.PM Spring 2010 Know where data comes from Source of Comp ustat Data Comp ustat Denver 100 analysts Standard and Poor's Information and Ratings Business We ek + others (Dodge) DRI Econom etrics McGr aw Hill Holding Co. J. K. Dietrich - GSBA 548 MBA.PM Spring 2010 Source of Compustat Data Source documents and data entry Annual reports 10-Ks and 10-Qs Manual formatting and input Cross-checking Wharton School Library link on MyMarshall website or go to website: http://wrds-web.wharton.upenn.edu Choose COMPUSTAT, then Tools (near bottom left), then Financial Statements Annually Updated (HTML) In Steps 1 to 3 Select Complete Financial Statements, years, and enter company ticker symbol When results available (after a few minutes), right click and save to disk J. K. Dietrich - GSBA 548 MBA.PM Spring 2010 Compustat Data: Balance Sheet Source: WRDS Downloaded 3/2010 SAFEWAY INC TICKER SYMBOL: SWY PRIMARY SIC CODE: 5411 Balance Sheets ($ millions) 2000 2001 2002 2003 2004 2005 2006 2007 2008 Cash & Equivalents 91.70 $ 68.50 $ 73.70 $ 174.80 $ 266.80 $ 373.30 $ 216.60 $ 277.80 $ 382.80 $ Receivables - Total (Net) 374.50 391.40 413.10 383.20 339.00 350.60 461.20 577.90 515.10 Inventories 2,508.20 2,576.80 2,493.00 2,642.20 2,740.70 2,766.00 2,642.50 2,797.80 2,591.40 Current Assets - Other 249.10 275.10 1,279.30 307.50 251.20 212.50 245.40 354.00 486.90 Current Assets - Total 3,223.50 $ 3,311.80 $ 4,259.10 $ 3,507.70 $ 3,597.70 $ 3,702.40 $ 3,565.70 $ 4,007.50 $ 3,976.20 $ Plant, Property & Equip (Net) 7,146.10 8,141.70 8,010.20 8,405.80 8,689.40 9,097.10 9,773.30 10,622.00 10,643.10 Equity and Other Investments and Advances 166.60 242.20 208.30 191.80 187.60 201.80 219.60 216.00 207.10 Intangibles 4,709.90 5,073.80 2,846.20 2,404.90 2,406.60 2,402.40 2,393.50 2,406.30 2,390.20 Other Assets 719.20 693.10 723.50 586.50 496.10 353.20 321.70 399.20 268.10 Total Assets 15,965.30 $ 17,462.60 $ 16,047.30 $ 15,096.70 $ 15,377.40 $ 15,756.90 $ 16,273.80 $ 17,651.00 $ 17,484.70 $ Accounts Payable 1,920.20 $ 1,952.001,952....
View Full Document

This note was uploaded on 02/11/2012 for the course FBE 443 taught by Professor Imrohoroglu during the Spring '07 term at USC.

Page1 / 24

548-Week 5 MBA.PM Spring 2010 - J. K. Dietrich - GSBA 548...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online