Chapter_06_HWK - Chapter 6 Problems 2, 10, 15, 17, 21 Input...

Info iconThis preview shows pages 1–5. 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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Chapter 6 Problems 2, 10, 15, 17, 21 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To install these, click on "Tools|Add-Ins" and select "Analysis ToolPak and "Solver Add-In." k" Chapter 6 Question 2 Input area: Year 0 Year 1 Year 2 Year 3 Year 4 Investment $16,000 Sales revenue $8,500 $9,000 $9,500 $7,000 Operating costs $1,900 $2,000 $2,200 $1,700 Depreciation- 4,000 4,000 4,000 4,000 Net working capital 200 250 300 200 $950 Tax rate Required return Output area: Sales $8,500 $9,000 $9,500 $7,000 Costs 1,900 2,000 2,200 1,700 Depreciation 4,000 4,000 4,000 4,000 EBT $2,600 $3,000 $3,300 $1,300 Tax- - - - Net income $2,600 $3,000 $3,300 $1,300 OCF- $6,600 $7,000 $7,300 $5,300 Capital spending $(16,000)- - - - NWC (200) (250) (300) (200) 950 Incremental cash flow $(16,200) $6,350 $6,700 $7,100 $6,250 NPV $10,200.00 Chapter 6...
View Full Document

This note was uploaded on 08/30/2010 for the course MANAGEMENT 3467783 taught by Professor Langly during the Summer '10 term at University of Phoenix.

Page1 / 9

Chapter_06_HWK - Chapter 6 Problems 2, 10, 15, 17, 21 Input...

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

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