6_Quality Metal Ex. 4 & 5

6_Quality Metal Ex. 4 & 5 - Quality Metal Service...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
11/09/2011 16:59:11 d61cb5aaffb471fe247a99d413e36cdaf820fc0e.xls Cash Flows ($000) 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 Sales $600 $1,375 $1,510 $1,665 $1,830 $2,010 $2,215 $2,435 $2,680 $2,945 Cost of Sales $560 $1,145 $1,236 $1,355 $1,490 $1,660 $1,845 $2,051 $2,290 $2,545 Earnings before Taxes $40 $230 $274 $310 $340 $350 $370 $384 $390 $400 Tax at 50% $20 $115 $137 $155 $170 $175 $185 $192 $195 $200 50% Earnings after Taxes $20 $115 $137 $155 $170 $175 $185 $192 $195 $200 Depreciation $110 $100 $85 $75 $65 $55 $45 $35 $20 $10 Working Capital Invest. $(120) $(155) $(25) $(35) $(30) $(35) $(45) $(40) $(50) $535 Cash Flow $10 $60 $197 $195 $205 $195 $185 $187 $165 $745 Initial Investment $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 Cumul. W/C $(120) $(275) $(300) $(335) $(365) $(400) $(445) $(485) $(535) $- NPV $286 IRR 22% Ken's Bonus Without Investment Profit $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/08/2011 for the course MA 827 taught by Professor Wain during the Summer '11 term at BC.

Ask a homework question - tutors are online