Computer_lab_5

Computer_lab_5 - A 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

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

View Full Document Right Arrow Icon
(in thousands of $) 2008 2009 2010 2011 2012 2013 2014 2015 0 1 2 3 4 5 6 7 Assumptions Tax Rate 0 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% 30.0% MACRS 10-year 10.0% 18.0% 14.4% 11.5% 9.2% 7.4% 6.6% WACC 9.3% Resale value of PPE $0 Balance Sheet Items Net Working Capital $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $0 Net PPE $20,000 $18,000 $14,400 $11,520 $9,216 $7,372 $5,898 $4,588 Cash Flow Forecasts Sales Revenue $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 Operating Expense $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 Depreciation $0 $2,000 $3,600 $2,880 $2,304 $1,844 $1,474 $1,310 Operating Profit (EBIT) $2,000 $400 $1,120 $1,696 $2,156 $2,526 $2,690 Taxes $600 $120 $336 $509 $647 $758 $807 Net Profit (EBIT(1-t)) $0 $1,400 $280 $784 $1,187 $1,509 $1,768 $1,883 Investment in PPE (CAPX) $20,000 Sale of PPE (Terminal value) $1,376.40 Investment in Working Capital (ΔNWC) $5,000 $0 $0 $0 $0 $0 $0 ($5,000) Cash Flows ($25,000) $3,400 $3,880 $3,664 $3,491 $3,353 $3,242
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.

This note was uploaded on 03/17/2011 for the course BUS M 401 taught by Professor Toddmitton during the Fall '10 term at BYU.

Page1 / 4

Computer_lab_5 - A 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

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