FCF 9th edition Chapter 10

FCF 9th edition Chapter 10 - Chapter 10 Problems 1-36 Input...

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

View Full Document Right Arrow Icon
Chapter 10 Problems 1-36 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 the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK."
Background image of page 1

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

View Full DocumentRight Arrow Icon
Chapter 10 Question 1 Input area: Purchase price $6,000,000 Appraised value $6,400,000 Cost to build $14,200,000 Grading costs $890,000 Output area: The acquisition cost is a sunk cost. The appraisal value is an opportunity cost and should be included. The cost to build and grading costs are investments in fixed assets and are included. Total initial cost $21,490,000
Background image of page 2
Chapter 10 Question 2 Input area: Camper quantity 19,000 Camper price $13,000 Increased motor home quantity 4,500 Motor home price $53,000 Lost motor coach quantity 900 Motor coach price $91,000 Output area: Camper sales $247,000,000 Increased motor home sales 238,500,000 Lost motor coach sales (81,900,000) Total sales $403,600,000
Background image of page 3

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

View Full DocumentRight Arrow Icon
Chapter 10 Question 3 Input area: Projected sales $830,000 Variable cost (% of sales) 60% Fixed cost $181,000 Depreciation $77,000 Tax rate 35% Output area: Sales $830,000 Variable costs 498,000 Fixed costs 181,000 Depreciation 77,000 EBT $74,000 Taxes (35%) 25,900 Net Income $48,100
Background image of page 4
Chapter 10 Question 4 Input area: Sales $824,500 Variable cost $538,900 Depreciation $126,500 Tax rate 34% Output area: Sales $824,500 Variable costs 538,900 Depreciation 126,500 EBT $159,100 Taxes (34%) 54,094 Net Income $105,006 OCF $231,506 Depreciation tax shield $43,010
Background image of page 5

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

View Full DocumentRight Arrow Icon
Chapter 10 Question 5 Input area: Projected sales $108,000 Costs $51,000 Depreciation $6,800 Tax rate 35% Output area: Sales $108,000 Variable costs 51,000 Depreciation 6,800 EBT $50,200 Taxes (35%) 17,570 Net Income $32,630 OCF $39,430 OCF $39,430 OCF $39,430 OCF $39,430
Background image of page 6
Chapter 10 Question 6 Input area: Costs $1,080,000 *7-year property under MACRS Output area: Yr. Beginning Book Value MACRS Depreciation Ending Book value 1 $1,080,000.00 0.1429 $154,332.00 $925,668.00 2 925,668.00 0.2449 264,492.00 661,176.00 3 661,176.00 0.1749 188,892.00 472,284.00 4 472,284.00 0.1249 134,892.00 337,392.00 5 337,392.00 0.0893 96,444.00 240,948.00 6 240,948.00 0.0892 96,336.00 144,612.00 7 144,612.00 0.0893 96,444.00 48,168.00 8 48,168.00 0.0446 48,168.00 -
Background image of page 7

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

View Full DocumentRight Arrow Icon
Chapter 10 Question 7 Input area: Costs $548,000 Pretax salvage value $105,000 Tax rate 35% *Depreciation straight line 8 *Asset used in years 5 Output area: Annual depreciation $68,500 Accumulated depreciation $342,500 Book value $205,500 Aftertax cash flow $140,175
Background image of page 8
Chapter 10 Question 8 Input area: Acquisition costs $7,900,000 Pretax salvage value $1,400,000 Tax rate 35% *MACRS class for taxes 0.2000 0.3200 0.1920 0.1152 Output area: Book Value $1,365,120 Aftertax cash flow $1,387,792
Background image of page 9

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

View Full DocumentRight Arrow Icon
Chapter 10 Question 9 Input area: Asset investment $3,900,000 Estimated annual sales $2,650,000 Costs $840,000 Tax rate 35% *Depreciation straight-line to zero over tax life 3 Output area: OCF $1,631,500
Background image of page 10
Chapter 10 Question 10 Input area: Asset investment $3,900,000 Estimated annual sales $2,650,000 Costs $840,000 Tax rate 35% *Depreciation straight-line to zero over tax life 3 OCF $1,631,500 Required return 12% Output area: NPV $18,587.71
Background image of page 11

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

View Full DocumentRight Arrow Icon
Chapter 10 Question 11 Input area: Asset investment $3,900,000 Estimated annual sales $2,650,000 Costs $840,000 Tax rate 35% Required return 12% *Depreciation straight-line to zero over tax life 3 OCF $1,631,500 Initial investment in NWC $300,000 Fixed asset value at end $210,000 Output area: Year Cash flow 0 $(4,200,000) 1 $1,631,500 2 $1,631,500 3 $2,068,000 NPV $29,279.79
Background image of page 12
Chapter 10 Question 12 Input area: Asset investment $3,900,000 Estimated annual sales $2,650,000 Costs $840,000 Tax rate 35% Required return 12% Initial investment in NWC $300,000 Fixed asset value at end $210,000 *3 yr MACRS 0.3333 0.4445 0.1481 Output area: Year Depreciation
Background image of page 13

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

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

This note was uploaded on 02/09/2012 for the course BMGT 340 taught by Professor None during the Spring '11 term at Shoreline.

Page1 / 35

FCF 9th edition Chapter 10 - Chapter 10 Problems 1-36 Input...

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

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