Question

In: Finance

You have developed the following analytical profit and loss statement for your company. It represents the...

You have developed the following analytical profit and loss statement for your company. It represents the most recent year’s operations, which ended yesterday.

Sales	$45,750,000
Variable costs	22,800,000
Revenue before fixed costs	$		22,950,000
Fixed costs	9,200,000
Earnings before interest and taxes (EBIT)				13,750,000
Interest expense	1,350,000
Earnings before taxes	$	12,400,000
Taxes (50%)		6,200,000
Net income	$ 6,200,000

Required

Your supervisor in the controller’s office has just handed you a memo asking for written responses to the following questions:

a At this level of output, what is the degree of operating leverage (DOL)?

b What is the degree of financial leverage (DFL)?

c What is the degree of combined leverage (DTL)?

What is the firm’s break-even point if it sold 915,000 units in the most recent year’s operations.

If sales increase by 25%, by what percentage would the following increase by (i) Earnings before interest and taxes and (ii) Net income?

Expert Solution

a. Contribution margin = Revenue before fixed costs = $22950000

Earnings before interest and tax = EBIT = 13750000

Degree of operating leverage at this output = Contribution margin / EBIT = 22950000 / 13750000 = 1.6690

b. Earnings before taxes = EBT = EBIT - interest = 12400000,

Earnings before interest and tax = EBIT = 13750000

Degree of financial leverage = EBIT / EBT = 13750000 / 12400000 = 1.1088

c. Degree of operating leverage = 1.6690 and Degree of financial leverage = 1.1088

Degree of total leverage = Degree of operating leverage x degree of financial leverage = 1.6690 x 1.1088 = 1.8505

d. No of units sold = 915000 , Contribution margin = 22950000

Contribution margin per unit = Contribution margin / No of units sold = 22950000 / 915000 = 25.0819 = 25.08

Let Q = Breakeven Units

Then Q = Breakeven point units = (Fixed cost + interest expense) / (Contribution margin per unit) = (9200000 + 1350000) / 25.08 = 10550000 / 25.08 = 420653.90 = 420654 (rounding to next whole number)

Hence breakeven point units = 420654 units

e. i) Percentage Increase in sales = 25%

We know that

Degree of operating leverage = Percentage change in EBIT / Percentage change in sales

1.6690 = Percentage change in EBIT / 25%

Percentage change in EBIT = 25% x 1.6690 = 41.725%

Hence earnings before interest and tax will increase by 41.725%

ii) Percentage Increase in sales = 25%

We know that

Degree of Total leverage = Percentage change in net income / Percentage change in sales

1.8505 = Percentage change in net income / 25%

Percentage change in net income = 25% x 1.8505 = 46.2625%

Hence Net income will increase by 46.2625%

jeff jeffy answered 1 year ago

You have developed the following pro forma income statement for your corporation: LOADING.... It represents the...

You have developed the following pro forma income statement for your corporation: LOADING.... 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 should decrease by 25 percent, by what percent would earnings before interest and...

You need to describe these financial statements. The statements are the profit and loss statement, statement...

You need to describe these financial statements. The statements are the profit and loss statement, statement if retained earnings, banalce sheet and the cash flow statement. For each of these reports describe what they are, what is involved in their preparation and how they are dealt with in preparing the financial reports. 800 words

on statement for profit and loss . based on formula why sales have to less with...

on statement for profit and loss . based on formula why sales have to less with discount ? discount is under expenses right ?

Explain the purpose and use of the Statement of profit or loss, Statement of changes in...

Explain the purpose and use of the Statement of profit or loss, Statement of changes in equity, Statement of financial position (also known as the Balance Sheet) and of the Statement of cash flows. Explain why the Statement of cash flows differs from the Statement of profit or loss (125 words).

The profit before tax, as reported in the statement of profit or loss and other comprehensive...

The profit before tax, as reported in the statement of profit or loss and other comprehensive income of Andreas Ltd for the year ended 30 June 2020, amounted to $85 000, including the following revenue and expense items: Rent revenue $4 500 Bad debts expense 6 000 Depreciation of plant 5 000 Annual leave expense Long service leave expense 2 500 3 500 Entertainment costs (non-deductible) 2 800 Depreciation of buildings (non-deductible) 800 Fines and penalties (non-deductible) 1 500 The...

The profit before tax, as reported in the Statement of Profit or Loss and Other Comprehensive...

The profit before tax, as reported in the Statement of Profit or Loss and Other Comprehensive Income of Diamond Ltd for the year ended 30 June 2019, amounted to $50,000 including the following revenue and expense items. June 2019 $ Interest revenue 4,000 Bad debts expense 4,000 Depreciation expense - plant 5,000 Annual Leave Expense 3,000 Long service leave expense 2,500 Fines and Penalties (non-deductible) 600 Depreciation expense - buildings (non-deductible) 1,000 Government grant (exempt from tax) 3,000 The Statement...

The profit before tax, as reported in the statement of profit and loss for Aileen Ltd...

The profit before tax, as reported in the statement of profit and loss for Aileen Ltd for the year ended 30 June 2020, amounted to $150,000, including the following revenue and expense items: Revenues Sales revenue $600,000 Interest revenue 60,000 Government grant 40,000 Expenses Cost of goods sold 300,000 Bad debts expense 8,000 Depreciation expense – equipment 6,000 Depreciation expense – plant 25,000 Research and development expense 51,000 Wages expense 120,000 Long service leave expense 40,000 The draft statement of...

Research and find a balance sheet and profit and loss statement for an insurance company. Explain...

Research and find a balance sheet and profit and loss statement for an insurance company. Explain what makes these statements different from companies in other industries.

Profit or Loss Account (Income Statement) of a business shows a net profit of 500,000. The...

Profit or Loss Account (Income Statement) of a business shows a net profit of 500,000. The owner of the business says, ‘Where is the money? My business does not have an increase in cash by $500,000 in the bank account. Where is the $500,000 profit? Required: Provide an explanation to the owner of the business about why net profit of a Profit or Loss Account (Income Statement) is not necessarily equal to the cash inflow. Your explanation must include two...

Can you find a break-even point analysis and profit analysis? Profit and loss income statement projected...

Can you find a break-even point analysis and profit analysis? Profit and loss income statement projected for the next 3 years first year monthly •R&D Expenses $7000 each year •S&A $3000 each month •Salaries 10 people with $9000 each month •Costumer Satisfaction $8000 each month •Rent of office $5000 each month •Cost of recipes $2000 each month