Question

In: Finance

The Spitfire Model Airplane Company has the following modified income statement ($000) at 100,000 units of...

The Spitfire Model Airplane Company has the following modified income statement ($000) at 100,000 units of production.

Revenue $14,000
Variable Cost 6,500
Fixed Cost 6200
EBIT $1,300
Interest(@10%) 500
EBT $800
Tax (@40%) 320
EAT $480
Number of shares 20,000
  1. What are Spitfire's contribution margin and dollar breakeven point? Enter your contribution margin answer in decimals and not in percentage. Enter your break-even sales answer in whole dollars. For example, an answer of $1 thousand should be entered as 1,000, not 1. Do not round intermediate calculations.
    CM (to two decimal places)
    SB/E (to the nearest dollar) $
  2. Calculate Spitfire's current DFL, DOL, and DTL. Round the answers to two decimal places. Do not round intermediate calculations.
    DFL
    DOL
    DTL
  3. Calculate the current EPS and estimate what it would become if sales declined by 25%. Use the DTL first and then recalculate the modified income statement. (Assume a negative EBT generates a negative tax.) Round your answers to two decimal places. Use a minus sign to indicate a negative answer. Do not round intermediate calculations.
    EPS (using DTL) $
    EPS (using modified income statement) $

Feedback

Solutions

Expert Solution

Production = 100,000 Units
Income Satement
Particulars Amount Per Unit
A Revenue $     14,000,000 $        140
B Variabe Cost $       6,500,000 $          65
C Contribution (A-B) $       7,500,000 $          75
D Fixed Cost $       6,200,000
E EBIT (C-D) $       1,300,000
F Interest (@10%) $           500,000
G EBT (E-F) $           800,000
F Tax (@40%) $           320,000
G EAT (G-F) $           480,000
H No. of Shares                 20,000
i EPS (G/H)                          24
a. Contribution Margin      = Net sales - Variable Cost
= $       7,500,000
Break Even Sales (in units) = Fixed Cost/Contribution Margin per Unit
= $ 6,200,000/$ 75
=                 82,667
Break Even Sales (in $) = 82,667 Unitis * $ 140 per Unit
= $     11,573,380
b. Degree of Financial Leverage = EBIT / EBT
= $ 1,300,000/$800,000
DFL= 1.63
Degree of Operating Leverage = Contribution / EBIT
= $ 7,500,000/$ 1,300,000
DOL = 5.77
Degree of Total Leverage = EBT/ Contribution
DTL = 9.38

(c) EPS Using DTL = (DTL shows Percentage change in Earnings for a one percentage change in Sales)

For 25 % decrease in Sales, EPS will decrease by (9.375 % * 25 times) = 234%

EPS using DTL = $ 24 - ($ 24 * 234%) = -$ 32

If Sales Declined by 25%
Revised Sales = 100,000- 25% = 75,000
Modified Income Satement
Particulars Amount
A Revenue $ 10,500,000 (75,000 * $ 140)
B Variabe Cost $   4,875,000 (75,000 * $ 65)
C Contribution (A-B) $   5,625,000
D Fixed Cost $   6,200,000
E EBIT (C-D) $     (575,000)
F Interest (@10%) $       500,000
G EBT (E-F) $ (1,075,000)
F Tax (@40%) $     (430,000)
G EAT (G-F) $     (645,000)
H No. of Shares              20,000
i EPS (G/H)                   ($ 32)

EPS using DCL will be same as EPS as per Modified Income Statement.


Related Solutions

The Spitfire Model Airplane Company has the following modified income statement ($000) at 100,000 units of...
The Spitfire Model Airplane Company has the following modified income statement ($000) at 100,000 units of production. Revenue $16,000 Variable Cost 6,100 Fixed Cost 8600 EBIT $1,300 Interest(@10%) 500 EBT $800 Tax (@40%) 320 EAT $480 Number of shares 20,000 What are Spitfire's contribution margin and dollar breakeven point? Enter your contribution margin answer in decimals and not in percentage. Enter your break-even sales answer in whole dollars. For example, an answer of $1 thousand should be entered as 1,000,...
Use the following information to construct income statement for the company. • Quantity of sales $100,000...
Use the following information to construct income statement for the company. • Quantity of sales $100,000 • Price per unit $2 • Cost of one unit $1.1 • Total Sales Expenses $25,000 • Total Rent and Utilities $5,000 • Total Marketing Expenses $4,000 • Other expenses $6,000 • Interest Expenses $10,000 Equity $175,000 • Tax expenses $10,000 what is the: cost of goods sold net income sales(revenue) total other expenses EBIT internet expenses tax expenses
Model constructing an income statement and balance sheet for a furniture company based on the following...
Model constructing an income statement and balance sheet for a furniture company based on the following transaction details. Please clearly show which transactions fall under the following parts of the statement: Sales Cost of Sales SG&A Expenses Interest Income Income Expense Loss on Sale of Non-Current Asset Transactions Buy wood to build bookshelves- $500 A recently hired team member builds the bookshelves and should be paid - $25 Paid electricity bill for shop where bookshelves are made - $100 Paid...
Direct and Indirect Methods Dauve Company reported the following condensed income statement for 2016: Sales $100,000...
Direct and Indirect Methods Dauve Company reported the following condensed income statement for 2016: Sales $100,000 Cost of goods sold (58,000) Gross profit $42,000 Operating expenses: Depreciation expense $8,000 Salaries expense 12,000 (20,000) Income before income taxes $22,000 Income tax expense (6,600) Net income $15,400 During 2016, the following changes occurred in the company's current assets and current liabilities: Increase (Decrease) Cash $3,700 Accounts receivable (5,500) Inventories 8,900 Accounts payable (purchases) (4,600) Salaries payable 2,800 Required: 1. By visual inspection,...
Company prepared the following contribution format income statement based on a sales volume of 1,000 units...
Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units): Sales $ 70,000 Variable expenses 38,500 Contribution margin 31,500 Fixed expenses 23,310 Net operating income $ 8,190 5. If sales decline to 900 units, what would be the net operating income? 6. If the selling price increases by $2 per unit and the sales volume decreases by 100 units, what would be the...
A company has orders for approximately 100,000 units of a product that it can sell at...
A company has orders for approximately 100,000 units of a product that it can sell at a price of €150.00 per unit. The company operates 300 days per year. It costs €5.00 to store one unit of the product for one month. The company manufactures other products, and it must set up the manufacturing system for a production order for the product, which costs €300. The product can be produced at a rate of 600 per working day. Determine: The...
A) Company A has the following income statement information for the years 2015-2017:                             &
A) Company A has the following income statement information for the years 2015-2017:                                                 2015 Income           2016 Income           2017 Income                                                 Statement as           Statement as              Statement                                                    Reported                  Reported                  Totals       Construction Rev               10,000,000                12,500,000                17,000,000 Construction Costs            6,200,000                7,250,000                10,260,000 Gross Profit                         3,800,000                5,250,000                6,740,000 Operating Expenses         2,100,000                2,835,000                3,219,000 Income from    Operations                       1,700,000                2,415,000                3,521,000 Non-Operating Items        (220,000)                   (171,000)                  (249,000) Income from    Continuing Operations          1,480,000                2,244,000                3,272,000 Income Tax...
Condor Airplane Company has built a new model jet aircraft which it intends to sell to...
Condor Airplane Company has built a new model jet aircraft which it intends to sell to high net worth clients. This aircraft required 25,000 hours to complete. Condor believes an incremental unit-time learning model with an 82% learning curve best reflects the company's production efficiency. Condor just received a contract to make fifteen identical aircraft. What will be the expected unit time for the sixteenth aircraft?
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units
    Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units):         Sales $ 90,000 Variable expenses   49,500 Contribution margin   40,500 Fixed expenses   33,210 Net operating income $ 7,290   14. Assume that the amounts of the company’s total variable expenses and total fixed expenses were reversed. In other words, assume that the total variable...
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units):Sales$40,000Variable expenses26,000Contribution margin14,000Fixed expenses8,680Net operating income$5,3201. What is the contribution margin ratio?2. What is the variable expense ratio?3. If sales decline to 900 units, what would be the net operating income?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT