(leverage and EPS) You have developed the following pro forma income statement f
ID: 2382764 • Letter: #
Question
(leverage and EPS) You have developed the following pro forma income statement for your corporation:
Sales $ 45,805,000
Variable cost (22,712,000)
Revenue before fixed costs $ 23,093,000
Fixed costs (9,293,000)
EBIT $13,800,000
Interest expense (1,375,000)
Earnings before taxes $12,425,000
Taxes (50%) (6,212,500)
Net Income $6,212,500
It Represents the most recent year’s operations, which ended yesterday. Your supervisor in the controller’s office has just handed you a memorandum asking for written responses to the following questions:
a. If sales should increase by 25 percent, by what percent would earnings before interest and taxes and net income increase
b. If sales decrease by 25 percent, by what percent would earnings before interest and taxes and net income decrease?
c. If the firm were to reduce its reliance on debt financing such that interest expense were cut in half, how would this affect your answers to parts a and b?
——————
a. If sales should increase by 25 percent, the percent change in earnings before interest and taxes is ____% (round to two decimal places)
If sales should increase by 25% the percentage change in net income is ___% (round to two decimal places)
b. If sales should decrease by 25 percent, the percent change in earnings before interest and taxes is ____% (round to two decimal places)
If sales should decrease by 25% the percentage change in net income is ___% (round to two decimal places)
c. If sales should increase by 25% and interest expense should decrease by 50%, the percentage change in earnings before interest and taxes is ___% (round to two decimal places)
If sales should increase by 25% and interest expense should decrease by 50%, the percentage change net income is ___% (round to two decimal places)
If sales should decrease by 25% and interest expense should decrease by 50%, the percentage change in earnings before interest and taxes is ___% (round to two decimal places)
If sales should decrease by 25% and interest expense should decrease by 50%, the percentage change in net income is ___% (round to two decimal places.)
Explanation / Answer
The calculation table is as follows.
So:
a. If sales should increase by 25 percent, the percent change in earnings before interest and taxes is _41.85___% (round to two decimal places)
If sales should increase by 25% the percentage change in net income is _46.48__% (round to two decimal places)
b. If sales should decrease by 25 percent, the percent change in earnings before interest and taxes is _- 41.82___% (round to two decimal places)
If sales should decrease by 25% the percentage change in net income is _- 46.45__% (round to two decimal places)
c. If sales should increase by 25% and interest expense should decrease by 50%, the percentage change in earnings before interest and taxes is _41.85__% (round to two decimal places)
If sales should increase by 25% and interest expense should decrease by 50%, the percentage change net income is _52.02__% (round to two decimal places)
If sales should decrease by 25% and interest expense should decrease by 50%, the percentage change in earnings before interest and taxes is _- 41.82__% (round to two decimal places)
If sales should decrease by 25% and interest expense should decrease by 50%, the percentage change in net income is _- 40.92__% (round to two decimal places.)
In $'000 Base Case Sales Increase 25% % Change Sales Decrease 25% % Change Sales Increase 25% Interest Decrease 50% % Change Sales Decrease 25% Interest Decrease 50% % Change Sales 45,805 57,256 25.00 34,354 -25.00 57,256 25.00 34,354 -25.00 Variable Cost (49.58%) -22,712 -28,388 24.99 -17,033 -25.01 -28,388 24.99 -17,033 -25.01 Fixed Cost -9,293 -9,293 0.00 -9,293 0.00 -9,293 0.00 -9,293 0.00 EBIT 13,800 19,576 41.85 8,028 -41.82 19,576 41.85 8,028 -41.82 Interest expense -1,375 -1,375 0.00 -1,375 0.00 -687.5 -50.00 -687.5 -50.00 Earning before taxes 12,425 18,201 46.48 6,653 -46.45 18,888 52.02 7,341 -40.92 Tax @50% -6,212.5 -9,100.3 46.48 -3,326.6 -46.45 -9,444.1 52.02 -3,670.3 -40.92 Net Income 6,212.5 9,100.3 46.48 3,326.6 -46.45 9,444.1 52.02 3,670.3 -40.92Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.