Times Interest Earned:
Times interest earned measures whether the company is in position to pay its debt obligations or not. It is also known as interest coverage ratio.
1.
To compute: Times interest earned of M Company.
Explanation of Solution
Given,
For M company
Income before interest is $200,000.
Interest expense is $60,000.
Times interest earned
Formula to calculate times interest earned,
Substitute $200,000 for income before interest and tax and $60,000 for interest expense.
Thus, times interest earned of M Company is 3.33 times.
2.
To compute: Times interest earned of W Company.
2.
Explanation of Solution
Given,
For W company
Income before interest is $400,000.
Interest expense is $260,000.
Times interest earned
Formula to calculate times interest earned,
Substitute $400,000 for income before interest and tax and $260,000 for interest expense.
Thus, times interest earned of W company is 1.54 times.
3.
To compute: Net income if sales increase by 30%.
3.
Explanation of Solution
Net income if sales increase by 30%.
Particulars | M Company ($)(given) | M Company ($)(30% increased sales) | W Company ($)(given) | W Company ($)(30% increased sales) |
Sales | 1000,000 | 1,300,000 | 1,000,000 | 1,300,000 |
Variable expenses | 800,000 | 1,040,000 | 600,000 | 780,000 |
Income before interest | 200,000 | 260,000 | 400,000 | 520,000 |
Interest expense | 60,000 | 60,000 | 260,000 | 260,000 |
Net income | 140,000 | 200,000 | 140,000 | 260,000 |
Increase in net income | 43% | 86% |
Table (1)
Working note:
Formula to calculate percentage increase in net income,
For Company M
For Company W
Thus, net income of Company M gets increased by 43% and Company W by 86%.
4.
To compute: Net income if sales increase by 50%.
4.
Explanation of Solution
Net income if sales increase by 50%.
Particulars | M Company ($)(given) | M Company ($)(50% increased sales) | W Company ($)(given) | W Company ($)(50% increased sales) |
Sales | 1000,000 | 1,500,000 | 1,000,000 | 1,500,000 |
Variable expenses | 800,000 | 1,200,000 | 600,000 | 900,000 |
Income before interest | 200,000 | 300,000 | 400,000 | 600,000 |
Interest expense | 60,000 | 60,000 | 260,000 | 260,000 |
Net Income | 140,000 | 240,000 | 140,000 | 340,000 |
Increase in net income | 71% | 143% |
Table (1)
Working Note:
Formula to calculate percentage increase in net income,
For Company M
For Company W
Thus, net income of Company M gets increased by 71% and Company W by 143%.
5.
To compute: Net income if sales increase by 80%.
5.
Explanation of Solution
Net income if sales increase by 80%.
Particulars | M Company ($)(given) | M Company ($)(80% increased sales) | W Company ($)(given) | W Company ($)(80% increased sales) |
Sales | 1000,000 | 1,800,000 | 1,000,000 | 1,800,000 |
Variable expenses | 800,000 | 1,440,000 | 600,000 | 1,080,000 |
Income before interest | 200,000 | 360,000 | 400,000 | 720,000 |
Interest expense | 60,000 | 60,000 | 260,000 | 260,000 |
Net Income | 140,000 | 300,000 | 140,000 | 460,000 |
Increase in net income | 114% | 229% |
Table (1)
Working Note:
Formula to calculate percentage increase in net income,
For Company M
For Company W
Thus, net income of Company M gets increased by 114% and Company W by 229%.
6.
To compute: Net income if sales decrease by 10%.
6.
Explanation of Solution
Net income if sales decrease by 10%.
Particulars | M Company ($)(given) | M Company ($)(10% decreased sales) | W Company ($)(given) | W Company ($)(10% decreased sales) |
Sales | 1000,000 | 900,000 | 1,000,000 | 900,000 |
Variable expenses | 800,000 | 720,000 | 600,000 | 540,000 |
Income before interest | 200,000 | 180,000 | 400,000 | 360,000 |
Interest expense | 60,000 | 60,000 | 260,000 | 260,000 |
Net Income | 140,000 | 120,000 | 140,000 | 100,000 |
Increase in net income | -14% | -29% |
Table (1)
Working note:
Formula to calculate percentage increase in net income,
For Company M
For Company W
Thus, net income of Company M gets decreased 14% and Company W by 29%.
7.
To compute: Net income if sales decrease by 20%.
7.
Explanation of Solution
Net income if sales decrease by 20%.
Particulars | M Company ($)(given) | M Company ($)(20% decreased sales) | W Company ($)(given) | W Company ($)(20% decreased sales) |
Sales | 1000,000 | 800,000 | 1,000,000 | 800,000 |
Variable expenses | 800,000 | 640,000 | 600,000 | 480,000 |
Income before interest | 200,000 | 160,000 | 400,000 | 320,000 |
Interest expense | 60,000 | 60,000 | 260,000 | 260,000 |
Net Income | 140,000 | 100,000 | 140,000 | 60,000 |
Increase in net income | -29% | -57% |
Table (1)
Working Note:
Formula to calculate percentage increase in net income,
For Company M
For Company W
Thus, net income of Company M gets decreased 29% and Company W by 57%.
8.
To compute: Net income if sales decrease by 40%.
8.
Explanation of Solution
Net income if sales decrease by 40%.
Particulars | M Company ($)(given) | M Company ($)(40% decreased sales) | W Company ($)(given) | W Company ($)(40% decreased sales) |
Sales | 1000,000 | 600,000 | 1,000,000 | 600,000 |
Variable expenses | 800,000 | 480,000 | 600,000 | 360,000 |
Income before interest | 200,000 | 120,000 | 400,000 | 240,000 |
Interest expense | 60,000 | 60,000 | 260,000 | 260,000 |
Net Income | 140,000 | 60,000 | 140,000 | (20,000) |
Increase in net income | -57% | -114% |
Table (1)
Working note:
Formula to calculate percentage increase in net income,
For Company M
For Company W
Thus, net income of Company M gets decreased 57% and Company W by 114%.
9.
Relation to fixed cost strategies of the two companies.
9.
Explanation of Solution
Relation to fixed cost strategies of the two companies,
- Here in this case fixed cost refers to interest expenses.
- Interest expenses in Company M are $ 60,000 and in Company W are $260,000. Interest expenses are higher in company W than in Company M.
- Due to higher interest expenses, change in net income gets more effected due to change in sales.
- Higher fixed cost is inversely related to times interest earned method.
- So if sales get increased, W Company enjoys higher percent increase in income in comparison to Company M.
- If sales get decreased, M Company experiences smaller percent change in net income in comparison to Company W.
Want to see more full solutions like this?
Chapter 9 Solutions
FINANCIAL ACCT.FUND.(LOOSELEAF)
- Lewis Company has a condensed income statement as shown below. Sales Wages expense Rent expense Utilities expense Total operating expenses Net income Year 2 $178,400 $100,000 33,000 30,000 Sales Wages expense Rent expense Utilities expense $163,000 $15,400 Required: Prepare a horizontal analysis of Lewis Company's Income statements. Comment on the trends, both favorable and unfavorable. If required, round your answers to one decimal place. For those boxes in which you must enter subtractive or negative numbers use a minus sign. Year 1 $162,500 $92,500 30,000 25,000 $147,500 $15,000 Lewis Company Income Statement Year 2 Year 1 Increase/ (Decrease) Amount Percent Change 600 Garrow_forwardTASK THREЕ: Income Statement for the year ended 31 December 2020 Edward Frankie Company Company $ Sales 100,000 80,000 Less: Cost of goods sold 60,000 50,000 Gross Profit 40,000 30,000 Less: Expenses 36.000 18,000 Net Profit 4.000 12,000 1. Calculate the gross profit ratio, net profit ratio and expense to sales ratio for each of the company respectively. 2. Comment the profitability of the two companies.arrow_forwardQuestion 2Alex is currently considering to invest his money in one of the companies between Company A and Company B. The summarized final accounts of the companies for their last completed financial year are as follows: a. Calculate the following ratios for Company A and Company B. State clearly the formulae used for each ratio: i. Gross Profit Marginii. Net Profit Marginiii. Inventory Turnover Period (days)iv. Receivables Collection Period (days)arrow_forward
- Comparative Income Statements Consider the following income statement data from the Mono Company: Sales revenue Cost of goods sold Selling expenses Administrative expenses Income tax expense 2019 2018 $600,000 $450,000 336,000 279,000 105,000 99,000 60,000 50,000 4,000 3,000 Prepare a contparative income statement, showing increases, and decreases in dollars and in percentages. Note: Round "Percent Change" answers to one decimal place (ex: 0.2345 = 23.5%). Sales Revenue Cost of Goods Sold MONO COMPANY Comparative Income Statements ♦ Selling Expenses Administrative Expenses Total Income before Income Taxes ◆ → $ $ 2019 0 $ 0 0 0 0 oooo 0 0 $ 2018 Increase (Decrease) 0 $ 0 0 0 0 0 0 0 0 $ 0 0 0 0 0 0 0 0 0 Percent Change 0% 0% 0% 0% 0% 0% 0% 0% 0 %arrow_forwardAssume the following sales data for a company: Current year $861,289 Preceding year 512,943 What is the percentage increase in sales from the preceding year to the current year? a.67.91% b.59.56% c.40.44% d.167.91%arrow_forwardRequirement 1. Prepare a horizontal analysis of the comparative income statement of McCormick Designs, Inc. Round percentage changes to one decimal place. (Round the percentages to one decimal place, X.X%. Use a minus sign or parentheses to indicate a decrease.) McCormick Designs, Inc. Comparative Income Statement Years Ended December 31, 2024 and 2023 Increase (Decrease) 2024 2023 Amount Percentage Net Sales Revenue $429,000 $373,750 % Expenses: Cost of Goods Sold 204,000 190,450 % Selling and Administrative Expenses 96,000 91,050 % Other Expenses 7,450 5,750 % Total Expenses 307,450 287,250 % Net Income $121,550 $86,500 % Requirement 2. Why did 2024 net income increase by a higher percentage than net sales revenue? Net income increased by a higher percentage than total net…arrow_forward
- Horizontal analysis of the income statement Income statement data for Winthrop Company for two recent years ended December 31 are as follows: Current Year Previous Year Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income tax expense Income tax expense Net income $2,240,000 (1,925,000) $315,000 $(152,500) (118,000) $(270,500) $44,500 (17,800) $26,700 $2,000,000 (1,750,000) $250,000 $(125,000) (100,000) $(225,000) $25,000 (10,000) $15,000arrow_forwardAssume the following sales data for a company: Current year $896,005 Preceding year 607,844 What is the percentage increase in sales from the preceding year to the current year (rounded to one decimal place)? Oa. 47.4% Ob. 15.3% Oc. 32.2% Od. 79.6%arrow_forwardPrepare DBR Corporation's income statement for the year ended December 31, 2025. Omit earnings per share. Use the multi-step format. Prepare the income statement through the income before taxes, then complete the income statement through the net income. (Use parentheses or a minus sign to enter amounts for Other Expenses.) DBR Corporation Income Statement Year Ended December 31, 2025 Net Sales Revenue $ 183,600 Cost of Goods Sold Gross Profit 93,000 90,600 59,000 Operating Expenses Operating Income Other Income and (Expenses) Income Before Income Taxes Income Tax Expense Income from Continuing Operations Discontinued Operations (less applicable tax) Net Income 31,600 (12,000) 19,600arrow_forward
- b. Complete the income statement and balance sheet for a Company by using following additional information: Additional Information Current ratio 3:1 $ 500 Depreciation Net Profit margin Total Liabilities to Total Equity Average collection period Inventory Turnover ratio No of Days in a year 7% 1:1 45 days 3:1 360 days Income statement for the Year 20XX (In thousands) Sales $ 100,000 Cost of Goods sold Gross profit Selling ? and administrative expenses Interest expense 4,000 Profit before tax ? Taxes (30% rate) Profit after taxes 1 Balance Sheet As on June 30, 20XX (In thousands) Cash $ 5,000 Accounts payable $ 4,000 Accounts receivable ? Bank loan ? Inventories ? Accruals 2,000 Current Assets ? Current Liabilities ? Long-term Debt 26,500 Net Fixed Assets ? Common stock & Retained 37,500 Earnings Total Assets ? Total Liabilities and Equity ?arrow_forwardAssume Marigold Company has the following reported amounts: Sales revenue $ 500,000, Sales returns and allowances $ 21,000, Cost of goods sold $ 325,000, and Operating expenses $ 75,000. (a) Compute net sales. Net sales $ (b) Compute gross profit. Gross profit $ (c) Compute income from operations. Income from operations (d) Compute the gross profit rate. (Round answer to 1 decimal place, e.g. 25.2%.) Gross profit ratearrow_forwardAssume the following sales data for a company: Current year $1,025,000 Preceding year 820,000 What is the percentage increase in sales from the preceding year to the current year? Oa. 125% Ob. 25% Oc. 75% Od. 100%arrow_forward