{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Document Right Arrow Icon

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

View Full Document Right Arrow Icon

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

View Full Document Right 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

{[ snackBarMessage ]}

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 bookmark
Ask a homework question - tutors are online