Copy of FCF 9th edition Chapter 16

Copy of FCF 9th edition Chapter 16 - Chapter 16 Problems...

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

View Full Document Right Arrow Icon
Chapter 16 Problems 1-22 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."
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 16 Question 1 Input Area: Market value $250,000 EBIT $28,000 Expansion-EBIT 30% Recession-EBIT 50% Debt issue $90,000 Interest rate 7% Shares outstanding 5,000 Output Area: No debt EBIT $14,000 $28,000 $36,400 Interest $- $- $- NI $14,000 $28,000 $36,400 EPS $2.80 $5.60 $7.28 Change EPS% -50.00% 0.00% 30.00% With debt Share price = $50.00 Shares repurchased = 1,800.00 EBIT $14,000 $28,000 $36,400 Interest $6,300 ### $6,300 ### $6,300 NI $7,700 $21,700 $30,100 EPS $2.41 $6.78 $9.41 Change EPS% -64.52% 0.00% 38.71%
Background image of page 2
Chapter 16 Question 2 Input Area: Market value $250,000 EBIT $28,000 Expansion-EBIT 30% Recession-EBIT 50% Debt issue $90,000 Interest rate 7% Shares outstanding 5,000 Tax rate 35% Output Area: No debt with taxes EBIT $14,000 $28,000 $36,400 Interest - - - Taxes 4,900 9,800 12,740 NI $9,100 $18,200 $23,660 EPS $1.82 $3.64 $4.73 Change EPS% -50.00% 0.00% 30.00% With debt and taxes Share price = $50.00 Shares repurchased = 1,800.00 EBIT $14,000 $28,000 $36,400 Interest 6,300 ### 6,300 ### 6,300 Taxes 2,695 7,595 10,535 NI $5,005 $14,105 $19,565 EPS $1.56 $4.41 $6.11 Change EPS% -64.52% 0.00% 38.71%
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 16 Question 3 Input Area: No debt TE = MV = $250,000 With debt TE = $160,000 Output Area: a. ROE 5.60% 11.20% 14.56% Change ROE% -50.00% 0.00% 30.00% b. ROE 4.81% 13.56% 18.81% Change ROE % -64.52% 0.00% 38.71% c. No debt No debt, ROE 3.64% 7.28% 9.46% Change ROE % -50.00% 0.00% 30.00% With debt With debt, ROE 3.13% 8.82% 12.23% Change ROE % -64.52% 0.00% 38.71%
Background image of page 4
Chapter 16 Question 4 Input Area: Plan I: Shares outstanding 160,000 Plan II: Shares outstanding 80,000 Debt outstanding $2,800,000 Interest rate 8% a. EBIT $350,000 b. EBIT $500,000 Output Area: a. NI EPS Plan I $350,000 $2.19 Plan II $126,000 $1.58 b. Plan I $500,000 $3.13 Plan II $276,000 $3.45 c. Breakeven EBIT = $448,000.00
Background image of page 5

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

View Full DocumentRight Arrow Icon
Question 5 Input Area: Plan I: Shares outstanding 160,000 Plan II: Shares outstanding 80,000 Debt outstanding $2,800,000 Interest rate 8% a. EBIT
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/12/2012 for the course BT 1003 taught by Professor As during the Spring '11 term at American Jewish University.

Page1 / 23

Copy of FCF 9th edition Chapter 16 - Chapter 16 Problems...

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

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