Excel Problem Set 4 impairments and restructurings 2008

Excel Problem Set 4 impairments and restructurings 2008 -...

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

View Full Document Right Arrow Icon
Excel Problem Set 4, Impairments and Restructurings 2008 2009 2010 2011 2012 Revenue $6,860,000 $6,420,000 $6,020,000 $5,635,000 $5,235,000 COGS $3,975,000 $3,720,000 $3,540,000 $3,380,000 $3,150,000 Gross margin $2,885,000 $2,700,000 $2,480,000 $2,255,000 $2,085,000 $1,080,000 $1,000,000 $970,000 $940,000 $925,000 Net income before tax $1,805,000 $1,700,000 $1,510,000 $1,315,000 $1,160,000 $667,850 $629,000 $558,700 $486,550 $429,200 Net income after tax $1,137,150 $1,071,000 $951,300 $828,450 $730,800 Depreciation in COGS $255,000 $248,000 $242,000 $235,000 $220,000 $78,000 $74,000 $71,000 $66,000 $62,000 Decrease in working capital $22,000 $20,000 $23,000 $26,000 $29,000 Capital expenditures $135,000 $120,000 $110,000 $95,000 $85,000 Free cash flows $1,627,150 $1,533,000 $1,397,300 $1,250,450 $1,126,800 Terminal value (after tax) $3,200,000 Adjusted free cash flows $1,627,150 $1,533,000 $1,397,300 $1,250,450 $4,326,800 20% higher cash flows $1,952,580 $1,839,600 $1,676,760 $1,500,540 $5,192,160 1 Sum of Undiscounted Cash Flows $10,134,700 Book Value $11,900,000 NPV $7,336,658 Impairment Loss $4,563,342 Subsidiary $4,563,342 2 Sum of Undiscounted Cash Flows
Background image of page 1

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

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

Page1 / 2

Excel Problem Set 4 impairments and restructurings 2008 -...

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

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