Question

In: Finance

The income statement of XYZ Company for the 2016 financial year was below expectations be low...

The income statement of XYZ Company for the 2016 financial year was below expectations
be low

Financia l Item Total in TZS
Sales (40,000 units) 400,000,000
Cost of raw materials 80,000,000
Other variable costs 100,000,000
Fixed factory overheads 160,000,000
Fixed administrative overheads 30,000,000
Sales commission (3% sales value) 12,000,000
Variable delivery costs 20,000,000
Other fixed costs 30,000,000

a) What is the break-even point of the company?

b) The company proposes to reduce the selling price per unit by 10% and by doing so demand is expected to increase by 25%. What would be profit or loss if this proposal is implemented?

Solutions

Expert Solution

a) Contribution margin = 10,000 - 5300 = 4700

Break even point = Fixed costs/ Contribution margin per unit = 220,000,000 / 4700 = 46809 units (rounded off)

Workings:

Financial Item Per unit
Sales 400,000,000 10000
Variable Costs
Cost of raw materials 80,000,000 2000
Other variable costs 100,000,000 2500
Sales commission (3% sales value) 12,000,000 300
Variable delivery costs 20,000,000 500
Contribution 188,000,000 4,700
Fixed costs:
Fixed factory overheads 160,000,000
Fixed administrative overheads 30,000,000
Other fixed costs 30,000,000
Total fixed costs 220,000,000
Net Income -32,000,000

2.

Financial Item Per unit
Sales 450,000,000 9000
Variable Costs
Cost of raw materials 100,000,000 2000
Other variable costs 125,000,000 2500
Sales commission (3% sales value) 13,500,000 270
Variable delivery costs 25,000,000 500
Contribution 186,500,000 3,730
Fixed costs:
Fixed factory overheads 160,000,000
Fixed administrative overheads 30,000,000
Other fixed costs 30,000,000
Total fixed costs 220,000,000
Net Income -33,500,000

Related Solutions

the segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ...
the segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ COMPANY Segmented Income Statement For the Year Ended December 31, 2016 Total Company Product A Product B Product C Sales $ 592,000 $ 297,000 $ 118,000 $ 177,000 Variable expenses 273,000 154,000 49,000 70,000 Contribution margin $ 319,000 $ 143,000 $ 69,000 $ 107,000 Fixed expenses 283,000 165,000 47,000 71,000 Operating income $ 36,000 $ (22,000 ) $ 22,000 $ 36,000 The company is...
The Income Statement of XYZ Company for the most recent fiscal year is given below. Its...
The Income Statement of XYZ Company for the most recent fiscal year is given below. Its sales are projected to increase by 20% in the coming year and it always retains 60% of its net income. Use the percentage of sales method to find out the addition to retained earnings amount.   Sales                                                              $40,000 Operating costs                                                   30,000           Earnings before interests and taxes $10,000 Interest expenses                                               1,000    Earnings before taxes                                         $ 9,000   Taxes (40%)                                                      3,600    Net income   ...
The Income Statement for XYZ Company for 2016 and 2017 is as follows: 2017 Sales $4,000,000...
The Income Statement for XYZ Company for 2016 and 2017 is as follows: 2017 Sales $4,000,000 Cost of Goods Sold 2,500,000 Gross Profit 1,500,000 Selling Expense 600,000 Administrative Expense 200,000 Total Operating Expense 800,000 Income from Operations 700,000 Income Tax Expense 50,000 Net Income 650,000 2016 $3,500,000 2,400,000 1,100,000 700,000 150,000 850,000 250,000 20,000 230,000 Instructions: Using the above comparative horizontal analysis for ABC Company.
The comparative financial statements for Prince Company are below:      Year 2 Year 1 Income statement:...
The comparative financial statements for Prince Company are below:      Year 2 Year 1 Income statement: Sales revenue $ 194,000 $ 168,000 Cost of goods sold 113,000 100,400 Gross profit 81,000 67,600 Operating expenses and interest expense 56,400 53,200 Pretax income 24,600 14,400 Income tax 8,400 4,200 Net income $ 16,200 $ 10,200 Balance sheet: Cash $ 4,400 $ 7,200 Accounts receivable (net) 14,200 18,200 Inventory 40,400 34,200 Property and equipment (net) 45,600 38,400 Total assets $ 104,600 $ 98,000...
The income statement of Indigo Company is shown below. INDIGO COMPANY INCOME STATEMENT FOR THE YEAR...
The income statement of Indigo Company is shown below. INDIGO COMPANY INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2017 Sales revenue $ 6,630,000 Cost of goods sold    Beginning inventory $ 1,840,000    Purchases 4,520,000    Goods available for sale 6,360,000    Ending inventory 1,530,000    Cost of goods sold 4,830,000 Gross profit 1,800,000 Operating expenses    Selling expenses 450,000    Administrative expenses 660,000 1,110,000 Net income $ 690,000 Additional information: 1. Accounts receivable decreased $ 290,000 during the year. 2. Prepaid expenses increased $ 180,000...
The income statement of Waterway Company is shown below. WATERWAY COMPANY INCOME STATEMENT FOR THE YEAR...
The income statement of Waterway Company is shown below. WATERWAY COMPANY INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2020 Sales revenue $6,210,000 Cost of goods sold    Beginning inventory $2,070,000    Purchases 4,570,000    Goods available for sale 6,640,000    Ending inventory 1,490,000    Cost of goods sold 5,150,000 Gross profit 1,060,000 Operating expenses    Selling expenses 450,000    Administrative expenses 570,000 1,020,000 Net income $40,000 Additional information: 1. Accounts receivable decreased $300,000 during the year. 2. Prepaid expenses increased $170,000 during the year. 3. Accounts...
The financial statements for XYZ Inc. are shown below. Income Statement and other info: 2020 2019...
The financial statements for XYZ Inc. are shown below. Income Statement and other info: 2020 2019 Year-end stock price 60 50 # of shares 5600 3600 XYZ Inc. Income Statement 2020 2019 Sales 900,000 960,000 850,000 COGS 640,000 610,000 Gross Profit 320,000 240,000 Operating costs (excluding depreciation) 70,000 50000 60,000 EDITDA 180,000 270,000 180,000 Depreciation 15,000 20,000 18,000 EBIT 165,000 250,000 162,000 Interest Expense 100,000 100000 100,000 EBT 65,000 150,000 62,000 Taxes 19,500 25,000 5,000 Net Income 45,500 125,000 57,000...
Below is the 2009 contribution income statement of a company. Contribution Income Statement For Year Ended...
Below is the 2009 contribution income statement of a company. Contribution Income Statement For Year Ended December 31, 2009 Sales (12,000 units) $1,440,000 Less variable costs Cost of goods sold $480,000 Selling and administrative 132,000 (612,000) Contribution margin 828,000 Less fixed costs Manufacturing overhead 510,000 Selling and administrative 220,000 (730,000) Net income $98,000 During the coming year, the company expects an increase in variable manufacturing costs of $8 per unit and in fixed manufacturing costs of $72,000. (a) If sales...
Calculate the ratios for year 2 that are listed below: COMPANY XYZ Income Sheet Year 1...
Calculate the ratios for year 2 that are listed below: COMPANY XYZ Income Sheet Year 1 Year 2 Sales (all on credit) $1,400,000 $1,375,000 Cost of Goods sold 850,000 900,000 Gross profit $550,000 $475,000 Selling and administrative expense* 240,000 230,000 Operating profit (EBIT) $310,000 245,000 Interest expense 40,000 37,000 Net income before taxes $270,000 208,000 Taxes 81,000 62,400 Net income $189,000 145,600 Shares 30,000 30,001 Earnings per share $6.30 $4.85 *Includes $15,000 in lease payments for each year. COMPANY XYZ...
Calculate the ratios for year 2 that are listed below: COMPANY XYZ Income Sheet Year 1...
Calculate the ratios for year 2 that are listed below: COMPANY XYZ Income Sheet Year 1 Year 2 Sales (all on credit) $1,400,000 $1,375,000 Cost of Goods sold 850,000 900,000 Gross profit $550,000 $475,000 Selling and administrative expense* 240,000 230,000 Operating profit (EBIT) $310,000 245,000 Interest expense 40,000 37,000 Net income before taxes $270,000 208,000 Taxes 81,000 62,400 Net income $189,000 145,600 Shares 30,000 30,001 Earnings per share $6.30 $4.85 *Includes $15,000 in lease payments for each year. COMPANY XYZ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT