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 1 year 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,...
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
Latest Questions
- 2. Show the trace of the RTL code for Booth's algorithm for X = 0111 and...
- Write an Java/C program code to perform known-plaintext attack on Permutation Cipher. This program can be...
- what kinds of patterns do you ovserve in the last few days of future contracts? what...
- Write a mini essay on the following: (a) “Culture defines the rules of the game.” (Robbins...
- Using draw.io diagram tool, design a database schema for an application that tracks and manages students’...
- Question 1: Write a Java program that prompts the user to input a file name (existing...
- In C++ Write a function that took in SIZE and array [size] and counted the number...
ADVERTISEMENT