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 | $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,
not 1. Do not round intermediate calculations.
CM (to two decimal places) SB/E (to the nearest dollar) $ - Calculate Spitfire's current DFL, DOL, and DTL. Round the
answers to two decimal places. Do not round intermediate
calculations.
DFL DOL DTL - 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) $
Solutions
Expert Solution
Ans.
| Sales | $ 16,000.00 |
| Less : Variable Cost | $ (6,100.00) |
| Contribution | $ 9,900.00 |
| Less: Fixed Cost | $ (8,600.00) |
| EBIT | $ 1,300.00 |
| Less : Interest | $ (500.00) |
| EBT | $ 800.00 |
| Less : Taxes | $ (320.00) |
| Net Income | $ 480.00 |
a)
Contribution Margin = Contribution / Sales = $ 9,900 / $ 16,000 = 0.61875 = 0.62
Break Even Sales ( Dollars) = Fixed Cost / Contribution margin = $8,600 / 0.61875 = $ 13,899
b)
Degree of Financial Leverage = EBIT / EBT = $ 1,300 / $800 = 1.625 or 1.63
Degree of Operating Leverage = Contribution / EBIT = $ 9,900 / $ 1,300 = 7.61538 or 7.62
Degree of Total Leverage = DOL * DFL = Contribution / EBIT * EBIT / EBT = Contribution / EBT = $ 9,900 / 800 = 12.375.
c)
Current EPS = Net Income / Number of Shares = $ 480 / 20,000 = 0.024
If sales declined by 25%
EPS (Using DTL) = 309.375% [( DTL * 25% ) = 12.375 * 25%] decrease in EPS i.e $ 0.024 - 309.375% = - $ 0.05025
EPS (using modified income statement)
| Current Forecast | If Sales are Percent 25% Lower Deviation | ||
| Sales | $ 16,000.00 | $ 12,000.00 | -25% |
| Less : Variable Cost | $ (6,100.00) | $ (4,575.00) | -25% |
| Gross Profit | $ 9,900.00 | $ 7,425.00 | -25% |
| Less: Fixed Cost | $ (8,600.00) | $ (8,600.00) | 0% |
| EBIT | $ 1,300.00 | $ (1,175.00) | -190% |
| Less : Interest | $ (500.00) | $ (500.00) | 0% |
| EBT | $ 800.00 | $ (1,675.00) | -309.375% |
| Less : Taxes | $ (320.00) | $ 670.00 | -309.375% |
| Net Income (a) | $ 480.00 | $ (1,005.00) | -309.375% |
| Number of Shares (b) | 20,000.00 | 20,000.00 | |
| EPS (a / b) | 0.024 | -0.05025 | -309.375% |
EPS (using modified income statement) = - $ 0.05025
jeff jeffy answered 2 years agoRelated 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
$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
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,...
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
$18,000
Variable Cost
5,500
Fixed Cost
11200
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...
Dynex Company had the following income statement for last year: Sales $200,000 Less: COGS 100,000 Gross...
Dynex Company had the following income statement for last
year:
Sales
$200,000
Less: COGS
100,000
Gross Profit
$100,000
Less: Selling & Admin. Expense
40,000
Operating income
$ 60,000
Beginning assets were $280,000, and ending assets were
$300,000.
Use the excel document found in the Assignments tab to answer
the questions below.
Average operating assets were:
Margin was:
Turnover was:
Return on investment was:
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...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Will iron(III) hydroxide precipitate from a pH = 1.00 solution with [Fe3+] = 1.0 x 10-5?...
- What do you believe happens during the final scene of the story between the brothers at....
- A 5.171 g sample of a solid, weak, monoprotic acid is used to make a 100.0...
- 1. Creep is one of deformation that occurred in concrete structure. Give one example that can...
- Why does a particular codon represent only one specific amino acid?
- Write a function template sort that takes two references to generic objects and switches them if...
- What 2 things happen to the melting point of a solid when an impurity is present?
ADVERTISEMENT