ACCT 302 - INTERMEDIATE ACCOUNTING II Comparative financial statement analysis Question Bank Set 1

ACCT 302 - INTERMEDIATE

ACCOUNTING II - Comparative

financial statement analysis

Question Bank - Set 1

Liberty University

Question 1

Question

The following table shows the income statements for two companies, A and B.

Perform a comparative financial statement analysis by calculating the common

size percentages for each company.

Category Company A Company B

Revenue $500,000 $700,000

Cost of Goods Sold $200,000 $350,000

Gross Profit $300,000 $350,000

Operating Expenses $150,000 $200,000

Net Income $150,000 $150,000

Solution

Step 1: Calculate common size percentages for Company A.

Revenue % = $500,000

$500,000 ×100% = 100%

Cost of Goods Sold % = $200,000

$500,000 ×100% = 40%

Gross Profit % = $300,000

$500,000 ×100% = 60%

Operating Expenses % = $150,000

$500,000 ×100% = 30%

Net Income % = $150,000

$500,000 ×100% = 30%

Step 2: Calculate common size percentages for Company B.

Revenue % = $700,000

$700,000 ×100% = 100%

Cost of Goods Sold % = $350,000

$700,000 ×100% = 50%

Gross Profit % = $350,000

$700,000 ×100% = 50%

Operating Expenses % = $200,000

$700,000 ×100% = 28.57%

Net Income % = $150,000

$700,000 ×100% = 21.43%

Therefore, the common size percentages for Company A and Company B

have been calculated.

Question 2

Question

Company A and Company B are two competing companies in the same industry.

Below are selected data from their comparative financial statements for the

current year:

Item Company A Company B

Net Income

500,000

700,000

Total Assets

5,000,000

6,000,000

Total Liabilities

2,000,000

3,000,000

Common Stock Equity

3,000,000

2,000,000

Based on the information provided, compare the two companies in terms of

profitability, asset utilization, financial leverage, and return on common equity.

Solution

Step 1: Profitability Analysis

Profitability can be measured using the Return on Assets (ROA) ratio:

ROA = Net Income

Total Assets

For Company A:

ROAA=500,000

5,000,000 = 0.10 = 10%

For Company B:

ROAB=700,000

6,000,000 ≈0.1167 ≈11.67%

Since Company B has a higher ROA, it is more profitable in terms of asset

utilization.

Step 2: Asset Utilization Analysis

Asset Utilization can be measured using the Asset Turnover ratio:

Asset Turnover = Net Sales

Average Total Assets

Given that we do not have net sales data, we cannot calculate the Asset

Turnover ratio for the two companies.

Step 3: Financial Leverage Analysis

Financial Leverage can be measured using the Debt-to-Equity (D/E) ratio:

D/E Ratio = Total Liabilities

Common Stock Equity

For Company A:

D/E RatioA=2,000,000

3,000,000 = 0.67

For Company B:

D/E RatioB=3,000,000

2,000,000 = 1.5

Company B has a higher D/E ratio, indicating higher financial leverage.

Step 4: Return on Common Equity Analysis

Return on Common Equity (ROE) can be calculated as:

ROE = Net Income

Common Stock Equity

For Company A:

ROEA=500,000

3,000,000 ≈0.1667 ≈16.67%

For Company B:

ROEB=700,000

2,000,000 = 0.35 = 35%

Company B has a higher ROE, indicating better return for common equity

investors.

Question 3

Question

Company X and Company Y are both in the retail industry. The income state-

ments for both companies for the year ended December 31, 2020, are shown

below:

Item Company X Company Y

Revenue $750,000 $950,000

Cost of Goods Sold $350,000 $500,000

Gross Profit ? ?

Operating Expenses $200,000 $300,000

Net Income $100,000 $120,000

Given the above data, calculate the missing values for the Gross Profit of

Company X and Company Y.

Solution

Step 1: Calculate the Gross Profit for Company X:

Gross Profit (Company X) = Revenue −Cost of Goods Sold

Gross Profit (Company X) = $750,000 −$350,000 = $400,000

Step 2: Calculate the Gross Profit for Company Y:

Gross Profit (Company Y) = Revenue −Cost of Goods Sold

Gross Profit (Company Y) = $950,000 −$500,000 = $450,000

Therefore, the missing values for the Gross Profit are:

Gross Profit (Company X) = $400,000 and Gross Profit (Company Y) = $450,000

Question 4

Question

The following data is extracted from the financial statements of two companies,

Company A and Company B, for the year ending December 31, 2020:

Company A Company B Industry Average

Net Sales

500,000

600,000 -

Cost of Goods Sold

250,000

280,000 -

Gross Profit

250,000

320,000 -

Operating Expenses

120,000

150,000 -

Net Income

80,000

120,000 -

Total Assets

800,000

1,000,000 -

Total Liabilities

400,000

500,000 -

Given the information above, analyze the financial performance and position

of Company A and Company B. Also, compare their performance with the

industry average where applicable.

Solution

Step 1: Calculate the gross profit margin for Company A and Company B. The

formula for gross profit margin is:

Gross Profit Margin = Gross Profit

Net Sales ×100%

For Company A:

Gross Profit Margin (Company A) = $250,000

$500,000 ×100% = 50%

For Company B:

Gross Profit Margin (Company B) = $320,000

$600,000 ×100% = 53.33%

Step 2: Compare the gross profit margins of Company A and Company B.

Company B has a higher gross profit margin compared to Company A. This

indicates that Company B is more efficient in managing its production costs

compared to Company A.

Step 3: Calculate the return on assets (ROA) for Company A and Company

B. The formula for ROA is:

ROA = Net Income

Total Assets ×100%

For Company A:

ROA (Company A) = $80,000

$800,000 ×100% = 10%

For Company B:

ROA (Company B) = $120,000

$1,000,000 ×100% = 12%

Step 4: Compare the ROA of Company A and Company B. Company B

has a higher ROA compared to Company A. This indicates that Company B is

more efficient in generating profits from its assets compared to Company A.

Step 5: Analyze the total liabilities of Company A and Company B. Com-

pany A has total liabilities of

400,000, while Company B has total liabilities of

500,000. This indicates that Company B has a higher level of debt compared

to Company A.

Step 6: Make overall conclusions. Company B outperforms Company A in

terms of both gross profit margin and return on assets. However, Company A

has a lower level of total liabilities compared to Company B. Further analysis is

needed to determine the reasons behind these differences and their implications

for the financial health of the companies.

Question 5

Question

You are analyzing the financial statements of two companies, Company A and

Company B. You notice that Company A has a higher net income than Company

B, but Company B has a higher return on assets (ROA). Explain how this

discrepancy could occur and what it indicates about the two companies’ financial

performance.

Solution

Step 1: Net Income vs. Return on Assets - Net income is a company’s total

profits after deducting all expenses from revenue, while return on assets (ROA)

measures how efficiently a company is using its assets to generate profit. - Com-

pany A having a higher net income than Company B suggests that Company A

is more profitable in absolute terms. - On the other hand, Company B having

a higher ROA indicates that it is more efficient in generating profits relative to

its total assets.

Step 2: Possible Reasons for Discrepancy - The discrepancy between the

two companies’ net income and ROA could be due to differences in their asset

bases. - Company B may have a lower asset base compared to Company A,

leading to a higher ROA despite a lower net income. - Alternatively, Company

A may have higher operating expenses or a higher proportion of non-operating

expenses, which could lower its ROA even with a higher net income.

Step 3: Implications for Financial Performance - The discrepancy between

net income and ROA highlights the importance of considering both absolute

profitability and efficiency in financial analysis. - Company A’s higher net in-

come may suggest stronger overall financial performance, but Company B’s

higher ROA indicates better asset utilization and efficiency. - Investors and

analysts should consider both metrics in conjunction with other financial ratios

to gain a comprehensive understanding of each company’s financial health and

performance.

Question 6

Question

Assume you are a financial analyst tasked with comparing the financial state-

ments of two companies, Company X and Company Y. Company X has a higher

net income than Company Y, but Company Y has a higher return on equity.

Explain how these seemingly contradictory results may arise in comparative

financial statement analysis.

Solution

Step 1: Net Income - Net income is the final profit figure after all expenses

have been subtracted from revenues on the income statement. - A higher net

income for Company X could indicate that it is more profitable in absolute

terms compared to Company Y.

Step 2: Return on Equity (ROE) - Return on Equity is a financial ratio that

measures a company’s profitability by revealing how much profit a company

generates with the money shareholders have invested. - The formula for ROE

is:

ROE =N et Income

Shareholders′Equity ×100%

- Company Y having a higher ROE than Company X indicates that Company

Y is utilizing shareholders’ equity more efficiently to generate profit.

Step 3: Possible Explanations for the Contradiction - It is important to note

that net income and ROE measure different aspects of a company’s financial

performance. - A higher net income for Company X may be due to higher op-

erating income or more aggressive accounting practices, while a higher ROE for

Company Y could be a result of higher financial leverage or efficient utilization

of equity. - Therefore, it is possible for Company X to have a higher net income

but a lower ROE compared to Company Y if Company Y is more efficient in

generating profits with the equity it has.

In conclusion, the seemingly contradictory results of Company X having a

higher net income but Company Y having a higher return on equity can be

explained by looking deeper into the components that drive these metrics. It

is essential for financial analysts to consider various factors and ratios when

comparing the financial performance of companies.

Question 7

Question

Company XYZ has provided the following financial data for the years 2020 and

2021:

Financial Data 2020 2021

Total Assets $500,000 $600,000

Total Liabilities $200,000 $250,000

Net Income $50,000 $70,000

Calculate the following ratios for each year: 1. Debt-to-Asset Ratio 2. Re-

turn on Assets (ROA) 3. Return on Equity (ROE)

Solution

1. Debt-to-Asset Ratio:

Debt-to-Asset Ratio = Total Liabilities

Total Assets

Step 1: Calculate for 2020

Debt-to-Asset Ratio (2020) = 200,000

500,000 = 0.4

Step 2: Calculate for 2021

Debt-to-Asset Ratio (2021) = 250,000

600,000 ≈0.4167

2. Return on Assets (ROA):

ROA = Net Income

Total Assets

Step 1: Calculate for 2020

ROA (2020) = 50,000

500,000 = 0.10

Step 2: Calculate for 2021

ROA (2021) = 70,000

600,000 ≈0.1167

3. Return on Equity (ROE):

ROE = Net Income

Total Equity

To calculate Total Equity, we can use the formula: Total Equity = Total Assets−

Total Liabilities.

Step 1: Calculate Total Equity for 2020

Total Equity (2020) = 500,000 −200,000 = 300,000

ROE (2020) = 50,000

300,000 ≈0.1667

Step 2: Calculate Total Equity for 2021

Total Equity (2021) = 600,000 −250,000 = 350,000

ROE (2021) = 70,000

350,000 = 0.2

Question 8

Question

Company X and Company Y are two competing companies in the same industry.

The following information is extracted from their financial statements:

Item Company X Company Y

Revenue

500,000

700,000

Cost of Goods Sold

200,000

350,000

Gross Profit

300,000

350,000

Operating Expenses

150,000

100,000

Net Income

100,000

200,000

Total Assets

800,000

1,000,000

Total Liabilities

400,000

600,000

Based on the information provided, compare the financial performance and

financial position of Company X and Company Y.

Solution

Step 1: Calculate important ratios for both companies:

For Company X: - Gross Profit Margin = GrossP rof it

Revenue =300,000

500,000 = 0.6 or 60-

Net Profit Margin = NetIncome

Revenue =100,000

500,000 = 0.2 or 20- Return on Assets (ROA)

=NetIncome

T otalAssets =100,000

800,000 = 0.125 or 12.5- Debt-to-Asset Ratio = T otalLiabilities

T otalAssets =

400,000

800,000 = 0.5 or 50

For Company Y: - Gross Profit Margin = GrossP rof it

Revenue =350,000

700,000 = 0.5 or

50- Net Profit Margin = N etIncome

Revenue =200,000

700,000 = 0.2857 or 28.57- Return on

Assets (ROA) = N etIncome

T otalAssets =200,000

1,000,000 = 0.2 or 20- Debt-to-Asset Ratio =

T otalLiabilities

T otalAssets =600,000

1,000,000 = 0.6 or 60

Step 2: Interpret the ratios for both companies:

- Company Y has a higher Gross Profit Margin and Net Profit Margin com-

pared to Company X, indicating that Company Y is more efficient in generat-

ing profits from its revenues. - Both companies have similar Return on Assets

(ROA), but Company Y has a higher Net Profit Margin, which means it is uti-

lizing its assets more efficiently to generate profits. - Company X has a lower

Debt-to-Asset Ratio compared to Company Y, indicating that Company X relies

less on debt to finance its assets.

In conclusion, Company Y outperforms Company X in terms of profitability

ratios, but Company X has a stronger financial position with a lower Debt-to-

Asset Ratio.

Question 9

Question

ABC Corp. and XYZ Corp. are two companies in the same industry. The

following information is extracted from their income statements for the year

ended December 31, 2021:

Item ABC Corp. XYZ Corp.

Revenue

500,000

600,000

Cost of Goods Sold

250,000

320,000

Gross Profit

250,000

280,000

Operating Expenses

120,000

150,000

Net Income

80,000

90,000

Compare and analyze the profitability of the two companies based on the

provided information.

Solution

Step 1: Find the gross profit margin for each company.

The gross profit margin is calculated as follows:

Gross Profit Margin (%) = Gross Profit

Revenue ×100

For ABC Corp.:

Gross Profit Margin (ABC) = $250,000

$500,000×100 = 50%

For XYZ Corp.:

Gross Profit Margin (XYZ) = $280,000

$600,000×100 = 46.67%

Step 2: Compare the gross profit margin of the two companies.

ABC Corp. has a higher gross profit margin (50%) compared to XYZ Corp.

(46.67%). This indicates that ABC Corp. is better at controlling its production

costs and generating profits from its sales.

Step 3: Find the net profit margin for each company.

The net profit margin is calculated as follows:

Net Profit Margin (%) = Net Income

Revenue ×100

For ABC Corp.:

Net Profit Margin (ABC) = $80,000

$500,000×100 = 16%

For XYZ Corp.:

Net Profit Margin (XYZ) = $90,000

$600,000×100 = 15%

Step 4: Compare the net profit margin of the two companies.

ABC Corp. has a higher net profit margin (16%) compared to XYZ Corp.

(15%). This indicates that ABC Corp. is more efficient in managing its overall

expenses and generating profits after all costs are accounted for.

Question 10

Question

The following data is extracted from the financial statements of Company XYZ

for the years 2019 and 2020:

Item 2019 2020

Sales Revenue

500,000

600,000

Cost of Goods Sold

300,000

350,000

Operating Expenses

100,000

120,000

Net Income

50,000

70,000

Total Assets

400,000

450,000

Total Liabilities

200,000

220,000

Calculate and interpret the following financial ratios for Company XYZ for

the years 2019 and 2020:

1. Gross Profit Margin

2. Net Profit Margin

3. Return on Assets (ROA)

4. Debt to Equity Ratio

Solution

Step 1: Calculate Gross Profit Margin



Gross Profit Margin =Sales Revenue−Cost of Goods Sold

Sales Revenue ×100%



For 2019: Gross Profit Margin = 500,000−300,000

500,000 ×100% = 40%



For 2020: Gross Profit Margin = 600,000−350,000

600,000 ×100% = 41.67%

Step 2: Calculate Net Profit Margin



Net Profit Margin =Net Income

Sales Revenue ×100%



For 2019: Net Profit Margin = 50,000

500,000 ×100% = 10%



For 2020: Net Profit Margin = 70,000

600,000 ×100% = 11.67%

Step 3: Calculate Return on Assets (ROA)



ROA =Net Income

Total Assets ×100%



For 2019: ROA = 50,000

400,000 ×100% = 12.5%



For 2020: ROA = 70,000

450,000 ×100% ≈15.56%

Step 4: Calculate Debt to Equity Ratio



Debt to Equity Ratio =Total Liabilities

Total Equity



For 2019: Debt to Equity Ratio = 200,000

200,000 = 1



For 2020: Debt to Equity Ratio = 220,000

230,000 ≈0.96

Interpreting the results:



Gross Profit Margin increased slightly from 2019 to 2020, indicating im-

proved efficiency in managing the cost of goods sold.



Net Profit Margin also increased, showing that the company’s profitability

improved.



Return on Assets increased, indicating that the company generated more

profit relative to its assets.



Debt to Equity Ratio decreased, which suggests that the company relied

less on debt financing in 2020 compared to 2019.

Question 11

Question

Company XYZ and Company ABC are two competing companies in the same

industry. The following selected information is available from their comparative

income statements for the year ending December 31, 20X9:

Item Company XYZ Company ABC

Revenue $500,000 $600,000

Costof GoodsSold $200,000 $240,000

OperatingExpenses $100,000 $150,000

InterestExpense $10,000 $5,000

IncomeT axExpense $30,000 $36,000

Using the above information, compare the profitability of Company XYZ

and Company ABC by calculating the following ratios: 1. Gross Profit Margin

2. Operating Profit Margin 3. Net Profit Margin

Solution

Step 1: Calculate the Gross Profit Margin for Company XYZ and Company

ABC.

Gross Profit Margin = 1−Cost of Goods Sold

Revenue ×100%

For Company XYZ:

Gross Profit Margin (XYZ) = 1−200,000

500,000×100% = (1 −0.4)×100% = 60%

For Company ABC:

Gross Profit Margin (ABC) = 1−240,000

600,000×100% = (1 −0.4)×100% = 60%

Step 2: Calculate the Operating Profit Margin for Company XYZ and Com-

pany ABC.

Operating Profit Margin = 1−Operating Expenses + Interest Expense

Revenue ×100%

For Company XYZ:

Operating Profit Margin (XYZ) = 1−100,000 + 10,000

500,000 ×100% = (1 −0.22)×100% = 78%

For Company ABC:

Operating Profit Margin (ABC) = 1−150,000 + 5,000

600,000 ×100% = (1 −0.258333)×100% ≈74.17%

Step 3: Calculate the Net Profit Margin for Company XYZ and Company

ABC.

Net Profit Margin = 1−Operating Expenses + Interest Expense + Income Tax Expense

Revenue ×100%

For Company XYZ:

Net Profit Margin (XYZ) = 1−100,000 + 10,000 + 30,000

500,000 ×100% = (1 −0.28)×100% = 72%

For Company ABC:

Net Profit Margin (ABC) = 1−150,000 + 5,000 + 36,000

600,000 ×100% = (1 −0.315)×100% = 68.5%

Therefore, comparing the profitability of the two companies based on the

calculated ratios, Company XYZ has a higher Gross Profit Margin and Op-

erating Profit Margin compared to Company ABC. However, Company ABC

has a higher Net Profit Margin compared to Company XYZ.

Question 12

Question

Company XYZ and Company ABC are two companies in the same industry.

The following financial information is available for both companies for the year

2020:

Company XYZ



Net income:

500,000



Total assets:

5,000,000



Total liabilities:

2,000,000

Company ABC



Net income:

600,000



Total assets:

4,000,000



Total liabilities:

1,500,000

Using this information, compare the Return on Assets (ROA) and Return

on Equity (ROE) of the two companies in 2020.

Solution

Step 1: Calculate the Return on Assets (ROA) for both companies using the

formula:

ROA =N etIncome

T otalAssets ×100%

Company XYZ

ROAXY Z =500,000

5,000,000 ×100% = 10%

Company ABC

ROAABC =600,000

4,000,000 ×100% = 15%

Step 2: Calculate the Return on Equity (ROE) for both companies using

the formula:

ROE =N etIncome

T otalEquity ×100%

Since Total Equity is calculated as Total Assets minus Total Liabilities, we

need to calculate the Total Equity for both companies first.

Company XYZ

Total Equity for XYZ:

5,000,000 -

2,000,000 =

3,000,000

ROEXY Z =500,000

3,000,000 ×100% ≈16.67%

Company ABC

Total Equity for ABC:

4,000,000 -

1,500,000 =

2,500,000

ROEABC =600,000

2,500,000 ×100% = 24%

Step 3: Comparing the results, we see that Company ABC has a higher

Return on Assets (15

Question 13

Question

Company XYZ and Company ABC are both in the retail industry. Below are

the income statements for both companies for the year ending December 31,

2021:

Company XYZ ABC

Revenue $500,000 $750,000

Cost of Goods Sold $300,000 $450,000

Gross Profit $200,000 $300,000

Using the information provided, compare the gross profit margin for both

companies and explain which one seems to be performing better in terms of

profitability. Assume all other expenses are equal for both companies.

Solution

Step 1: Calculate the Gross Profit Margin for Company XYZ. The formula for

Gross Profit Margin is:

Gross Profit Margin = Gross Profit

Revenue ×100

Substitute the values for Company XYZ:

Gross Profit Margin (XYZ) = 200,000

500,000×100 = 40%

Step 2: Calculate the Gross Profit Margin for Company ABC. Using the

formula:

Gross Profit Margin (ABC) = 300,000

750,000×100 = 40%

Step 3: Analysis and Conclusion Both companies have a gross profit margin

of 40

In terms of profitability based on their gross profit margin alone, there is no

difference between Company XYZ and Company ABC. Both companies seem

to be performing equally well in terms of generating profits from their revenue.

Question 14

Question

The following table shows the financial statements of two companies, Company

A and Company B, for the year ended December 31, 2021:

Item Company A Company B

Total Assets $500,000 $600,000

Total Liabilities $200,000 $250,000

Total Equity ? ?

Net Income $50,000 $60,000

Given the information above, calculate the missing values for the total equity

of both Company A and Company B.

Solution

Step 1: Calculate the total equity for Company A. Total Equity for Company

= Total Assets - Total Liabilities Total EquityCompany A =

500,000 -

200,000

300,000

Step 2: Calculate the total equity for Company B. Total Equity for Company

= Total Assets - Total Liabilities Total EquityCompany B =

600,000 -

250,000

350,000

Therefore, the total equity for Company A is

300,000 and for Company B

350,000.

Question 15

Question

The following data is extracted from the financial statements of two different

companies, A and B, for the years ending December 31, 20X1 and 20X2:

Company A:



Total Assets (20X1):

500,000



Total Assets (20X2):

600,000



Net Income (20X1):

50,000



Net Income (20X2):

70,000

Company B:



Total Assets (20X1):

1,000,000



Total Assets (20X2):

1,200,000



Net Income (20X1):

80,000



Net Income (20X2):

100,000

Compare the financial performance and efficiency of companies A and B

using total asset turnover ratio for both years.

Solution

Step 1: Calculate the total asset turnover ratio for both companies for the

years 20X1 and 20X2.

Company A:



Total Asset Turnover (20X1): Net Sales (20X1)

Total Assets (20X1)



Total Asset Turnover (20X2): Net Sales (20X2)

Total Assets (20X2)

Company B:



Total Asset Turnover (20X1): Net Sales (20X1)

Total Assets (20X1)



Total Asset Turnover (20X2): Net Sales (20X2)

Total Assets (20X2)

Step 2: Calculate the total asset turnover ratio using the provided data.

Company A:



Total Asset Turnover (20X1): $50,000

$500,000 = 0.10



Total Asset Turnover (20X2): $70,000

$600,000 = 0.1167

Company B:



Total Asset Turnover (20X1): $80,000

$1,000,000 = 0.08



Total Asset Turnover (20X2): $100,000

$1,200,000 = 0.0833

Step 3: Compare the total asset turnover ratios for both companies over

the two years.

In 20X1, Company A had a higher total asset turnover ratio compared

to Company B (0.10 vs. 0.08). However, in 20X2, Company B’s total asset

turnover ratio increased to 0.0833, surpassing Company A’s ratio of 0.1167.

This indicates that Company B became more efficient in generating sales

relative to its total assets in 20X2, compared to Company A.

Question 16

Question

Company ABC and Company XYZ are two competitors in the retail indus-

try. The following information is extracted from their comparative financial

statements for the year ended December 31, 20X7:

Company ABC Company XYZ

Net Sales

1,500,000

1,200,000

Cost of Goods Sold

800,000

700,000

Operating Expenses

300,000

250,000

Net Income

200,000

150,000

Calculate and compare the following financial ratios for both companies: 1.

Gross Profit Margin 2. Operating Profit Margin 3. Net Profit Margin

Solution

Step 1: Calculate the Gross Profit Margin for both companies.

Gross Profit Margin = Net Sales −Cost of Goods Sold

Net Sales ×100%

For Company ABC:

Gross Profit Margin (ABC) = $1,500,000 −$800,000

$1,500,000 ×100% = $700,000

$1,500,000×100% = 46.67%

For Company XYZ:

Gross Profit Margin (XYZ) = $1,200,000 −$700,000

$1,200,000 ×100% = $500,000

$1,200,000×100% = 41.67%

Step 2: Calculate the Operating Profit Margin for both companies.

Operating Profit Margin = Net Income + Operating Expenses

Net Sales ×100%

For Company ABC:

Operating Profit Margin (ABC) = $200,000 + $300,000

$1,500,000 ×100% = $500,000

$1,500,000×100% = 33.33%

For Company XYZ:

Operating Profit Margin (XYZ) = $150,000 + $250,000

$1,200,000 ×100% = $400,000

$1,200,000×100% = 33.33%

Step 3: Calculate the Net Profit Margin for both companies.

Net Profit Margin = Net Income

Net Sales ×100%

For Company ABC:

Net Profit Margin (ABC) = $200,000

$1,500,000×100% = 13.33%

For Company XYZ:

Net Profit Margin (XYZ) = $150,000

$1,200,000×100% = 12.5%

Question 17

Question

Company A and Company B both operate in the same industry. The following

information is extracted from their income statements:

Item Company A Company B

Revenue $800,000 $950,000

Cost of Goods Sold (COGS) $400,000 $500,000

Operating Expenses $200,000 $230,000

Interest Expense $20,000 $25,000

Income Tax Expense $50,000 $60,000

Use the information provided to compare the profitability and efficiency of

Company A and Company B.

Solution

Step 1: Calculate the Gross Profit Margin for both companies.

Gross Profit Margin = Revenue −COGS

Revenue ×100%

Company A:

Gross Profit Margin = 800,000 −400,000

800,000 ×100% = 400,000

800,000 ×100% = 50%

Company B:

Gross Profit Margin = 950,000 −500,000

950,000 ×100% = 450,000

950,000 ×100% ≈47.4%

Step 2: Calculate the Operating Profit Margin for both companies.

Operating Profit Margin = Revenue −COGS −Operating Expenses

Revenue ×100%

Company A:

Operating Profit Margin = 800,000 −400,000 −200,000

800,000 ×100% = 200,000

800,000×100% = 25%

Company B:

Operating Profit Margin = 950,000 −500,000 −230,000

950,000 ×100% = 220,000

950,000×100% ≈23.2%

Step 3: Compare the profitability of Company A and Company B. - Com-

pany A has a higher Gross Profit Margin (50- Company A also has a higher

Operating Profit Margin (25

Therefore, based on these metrics, Company A appears to be more profitable

and efficient compared to Company B.

Question 18

Question

The following information pertains to two companies, A and B, for the year

ended December 31, 2021:

Items Company A Company B

Sales

500,000

600,000

Cost of Goods Sold

250,000

280,000

Gross Profit

250,000

320,000

Operating Expenses

100,000

120,000

Net Income

150,000

200,000

Total Assets

800,000

1,000,000

Total Liabilities

400,000

500,000

Shareholders’ Equity

400,000

500,000

Assuming all other factors remain constant, analyze and compare the finan-

cial performance and position of Companies A and B based on the provided

information.

Solution

Step 1: Calculate the profit margin for each company.

Profit Margin = Net Income

Sales ×100%

Company A:

Profit Margin for A = 150,000

500,000×100% = 30%

Company B:

Profit Margin for B = 200,000

600,000×100% ≈33.33%

Step 2: Compare the profit margins of the two companies.

Company B has a higher profit margin (33.33%) compared to Company A

(30%). This indicates that Company B is more efficient in converting sales into

actual profit.

Step 3: Calculate the return on assets (ROA) for each company.

ROA = Net Income

Total Assets ×100%

Company A:

ROA for A = 150,000

800,000×100% = 18.75%

Company B:

ROA for B = 200,000

1,000,000×100% = 20%

Step 4: Compare the return on assets of the two companies.

Company B has a higher return on assets (20%) compared to Company A

(18.75%). This indicates that Company B is more efficient in generating profit

from its assets.

Step 5: Based on the profit margin and return on assets analyses, it can

be concluded that Company B outperforms Company A in terms of financial

performance. Company B has higher profitability ratios and is more efficient in

utilizing its assets to generate profit.

Question 19

Question

You are given the following financial data for Company XYZ:

Item 2019 2020

Sales

500,000

600,000

Cost of Goods Sold

300,000

350,000

Gross Profit ? ?

Operating Expenses

150,000

180,000

Net Income

30,000

45,000

Calculate the missing values for Gross Profit in both 2019 and 2020.

Solution

Step 1: Calculate Gross Profit for 2019

Gross Profit 2019 = Sales−Cost of Goods Sold = $500,000−$300,000 = $200,000

Step 2: Calculate Gross Profit for 2020

Gross Profit 2020 = Sales−Cost of Goods Sold = $600,000−$350,000 = $250,000

Question 20

Question

Company ABC and Company XYZ are two competing firms in the same indus-

try. The following data is extracted from their financial statements for the year

ended December 31, 2021:

Item Company ABC Company XYZ

Net Sales

500,000

600,000

Cost of Goods Sold

250,000

320,000

Gross Profit

250,000

280,000

Operating Expenses

150,000

180,000

Net Income

70,000

90,000

Total Assets

800,000

1,200,000

Total Liabilities

400,000

600,000

Equity

400,000

600,000

Compare the financial performance and position of Company ABC and Com-

pany XYZ based on the above data.

Solution

To compare the financial performance and position of Company ABC and Com-

pany XYZ, we will analyze various financial ratios that provide insights into

profitability, efficiency, and solvency.

Step 1: Calculate the Gross Profit Margin for both companies.

The Gross Profit Margin is calculated as:

Gross Profit Margin = Gross Profit

Net Sales ×100%

For Company ABC:

Gross Profit Margin (ABC) = 250,000

500,000 ×100% = 50%

For Company XYZ:

Gross Profit Margin (XYZ) = 280,000

600,000 ×100% = 46.67%

Step 2: Calculate the Net Profit Margin for both companies. The

Net Profit Margin is calculated as:

Net Profit Margin = Net Income

Net Sales ×100%

For Company ABC:

Net Profit Margin (ABC) = 70,000

500,000 ×100% = 14%

For Company XYZ:

Net Profit Margin (XYZ) = 90,000

600,000 ×100% = 15%

Step 3: Analyze the solvency of both companies using the Debt-

to-Equity ratio. The Debt-to-Equity ratio is calculated as:

Debt-to-Equity Ratio = Total Liabilities

Equity

For Company ABC:

Debt-to-Equity Ratio (ABC) = 400,000

400,000 = 1

For Company XYZ:

Debt-to-Equity Ratio (XYZ) = 600,000

600,000 = 1

Step 4: Evaluate the efficiency of both companies using the Total

Asset Turnover ratio. The Total Asset Turnover ratio is calculated as:

Total Asset Turnover = Net Sales

Total Assets

For Company ABC:

Total Asset Turnover (ABC) = 500,000

800,000 = 0.625

For Company XYZ:

Total Asset Turnover (XYZ) = 600,000

1,200,000 = 0.5

Based on the analysis of the financial ratios, Company ABC has a higher

Gross Profit Margin, while Company XYZ has a higher Net Profit Margin.

Both companies have the same Debt-to-Equity ratio, indicating similar levels of

leverage. Company ABC has a higher Total Asset Turnover, suggesting better

efficiency in generating revenue from its assets.

Question 21

Question

Company A and Company B are two competitors in the same industry. Below

are selected financial data for both companies:

Company A:



Net Income:

500,000



Total Assets:

2,500,000



Total Equity:

1,000,000

Company B:



Net Income:

600,000



Total Assets:

3,000,000



Total Equity:

1,200,000

Considering these figures, which company appears to be more efficient in

generating profits relative to its total assets? Justify your answer with appro-

priate financial ratios.

Solution

Step 1: Calculate the Return on Assets (ROA) for both companies using the

formula:

ROA =N etIncome

T otalAssets

For Company A:

ROA =500,000

2,500,000 = 0.20 or 20%

For Company B:

ROA =600,000

3,000,000 = 0.20 or 20%

Step 2: Compare the ROA of both companies. Since both companies have

an ROA of 20

Question 22

Question

Company A and Company B are both in the same industry. The comparative

balance sheets for the two companies are as follows:

Assets Company A Company B

Cash $50,000 $70,000

Accounts Receivable $90,000 $60,000

Inventory $80,000 $100,000

Property, Plant, and Equipment $300,000 $200,000

Liabilities Company A Company B

Accounts Payable $40,000 $30,000

Notes Payable $60,000 $40,000

Accrued Expenses $20,000 $10,000

Use the information provided to calculate the following ratios for each com-

pany: - Current ratio - Quick ratio - Debt to equity ratio - Inventory turnover

ratio

Solution

Step 1: Calculate the Current Ratio

The current ratio is calculated by dividing current assets by current liabilities. It

measures a company’s ability to pay off short-term liabilities with its short-term

assets.

For Company A:

Current Ratio = $50,000 + $90,000 + $80,000

$40,000 =$220,000

$40,000 = 5.5

For Company B:

Current Ratio = $70,000 + $60,000 + $100,000

$30,000 =$230,000

$30,000 = 7.67

Step 2: Calculate the Quick Ratio

The quick ratio (acid-test ratio) is calculated by dividing quick assets by cur-

rent liabilities. Quick assets include cash, accounts receivable, and marketable

securities.

For Company A:

Quick Ratio = $50,000 + $90,000

$40,000 =$140,000

$40,000 = 3.5

For Company B:

Quick Ratio = $70,000 + $60,000

$30,000 =$130,000

$30,000 = 4.33

Step 3: Calculate the Debt to Equity Ratio

The debt to equity ratio is calculated by dividing total liabilities by total equity.

It measures the proportion of equity and debt used to finance a company’s assets.

For Company A:

Debt to Equity Ratio = $60,000 + $20,000

$220,000 =$80,000

$220,000 = 0.364

For Company B:

Debt to Equity Ratio = $40,000 + $10,000

$260,000 =$50,000

$260,000 = 0.192

Step 4: Calculate the Inventory Turnover Ratio

The inventory turnover ratio is calculated by dividing the cost of goods sold by

average inventory. It measures how many times a company’s inventory is sold

and replaced over a period.

For Company A: Assuming the cost of goods sold is 150,000,Inventory Turnover Ratio =

$150,000

($80,000+$100,000)/2=$150,000

$90,000 = 1.67

For Company B: Assuming the cost of goods sold is 140,000,Inventory Turnover Ratio =

$140,000

($70,000+$100,000)/2=$140,000

$85,000 ≈1.65

Question 23

Question

Assume you are a financial analyst tasked with conducting a comparative anal-

ysis of two companies’ financial statements. Company A and Company B are

in the same industry and have provided you with their income statements for

the current year. Below are summarized figures from both companies’ income

statements:

Item Company A Company B

Revenue

500,000

600,000

Cost of Goods Sold

250,000

280,000

Gross Profit

250,000

320,000

Operating Expenses

150,000

180,000

Income Before Tax

100,000

140,000

Net Income

70,000

100,000

Based on the information provided, analyze the financial performance of

both companies and identify which company appears to be more profitable.

Provide a justification for your answer.

Solution

Step 1: Calculate the Gross Profit Margin for both Company A and Company

B. The Gross Profit Margin is calculated as:

Gross Profit Margin = Gross Profit

Revenue ×100%

For Company A:

Gross Profit Margin (Company A) = 250,000

500,000 ×100% = 50%

For Company B:

Gross Profit Margin (Company B) = 320,000

600,000 ×100% = 53.33%

Step 2: Compare the Gross Profit Margin of both companies. Company B

has a higher Gross Profit Margin (53.33

Step 3: Calculate the Net Profit Margin for both Company A and Company

B. The Net Profit Margin is calculated as:

Net Profit Margin = Net Income

Revenue ×100%

For Company A:

Net Profit Margin (Company A) = 70,000

500,000 ×100% = 14%

For Company B:

Net Profit Margin (Company B) = 100,000

600,000 ×100% = 16.67%

Step 4: Compare the Net Profit Margin of both companies. Company B also

has a higher Net Profit Margin (16.67

Therefore, based on the analysis of both Gross Profit Margin and Net Profit

Margin, Company B appears to be more profitable and financially efficient com-

pared to Company A.

Question 24

Question

Company A and Company B are two competitors in the same industry. Below

are selected financial ratios for both companies:

Ratio Company A Company B

Return on Assets (ROA) 10% 15%

Return on Equity (ROE) 20% 25%

Profit Margin 8% 10%

Debt-to-Equity Ratio 0.5 0.8

Based on the provided information, compare the financial performance and

leverage of Company A and Company B.

Solution

Step 1: Calculate Return on Equity (ROE)

ROE measures a company’s profitability by showing how much profit the

company generates with the money shareholders have invested.

Company A:

ROEA=N et IncomeA

Shareholders′EquityA

=20

100 = 20%

Company B:

ROEB=N et IncomeB

Shareholders′EquityB

=25

100 = 25%

Therefore, Company B has a higher Return on Equity (ROE) compared to

Company A.

Step 2: Analyze Profit Margin

Profit Margin measures how much a company earns from each dollar of sales.

Company A:

P rofit MarginA= 8%

Company B:

P rofit MarginB= 10%

Company B has a higher Profit Margin compared to Company A, indicating

that Company B is more efficient in converting sales into profits.

Step 3: Evaluate Debt-to-Equity Ratio

The Debt-to-Equity Ratio indicates the proportion of a company’s financing

that comes from debt versus shareholders’ equity.

Company A:

Debt −to −Equity RatioA= 0.5

Company B:

Debt −to −Equity RatioB= 0.8

Company A has a lower Debt-to-Equity Ratio compared to Company B,

suggesting that Company A is less leveraged.

Conclusion: Company B outperforms Company A in terms of ROE and

Profit Margin, but Company A has a lower Debt-to-Equity Ratio. This indicates

that Company B is more profitable and efficient, but Company A has a more

conservative capital structure with lower leverage.

Question 25

Question

The following data are available for two companies, Company X and Company

Y, for the years 2019 and 2020:

Company Year Net Income (in

)

X 2019 500,000

X 2020 600,000

Y 2019 700,000

Y 2020 800,000

Using this data, compare the growth rate of Net Income for Company X and

Company Y between 2019 and 2020.

Solution

Step 1: Calculate the growth rate of Net Income for Company X.

Growth Rate (Company X) = Net Income2020 −Net Income2019

Net Income2019 ×100%

Growth Rate (Company X) = 600,000 −500,000

500,000 ×100%

Growth Rate (Company X) = 100,000

500,000×100%

Growth Rate (Company X) = 0.2×100% = 20%

Step 2: Calculate the growth rate of Net Income for Company Y.

Growth Rate (Company Y) = Net Income2020 −Net Income2019

Net Income2019 ×100%

Growth Rate (Company Y) = 800,000 −700,000

700,000 ×100%

Growth Rate (Company Y) = 100,000

700,000×100%

Growth Rate (Company Y) = 0.1429 ×100% ≈14.29%

Step 3: Compare the growth rates of Net Income for Company X and Com-

pany Y. Company X had a growth rate of 20% in Net Income, while Company

Y had a growth rate of approximately 14.29%. Therefore, Company X expe-

rienced a higher growth rate in Net Income compared to Company Y between

2019 and 2020.

Question 26

Question

Company A and Company B are both in the same industry and are competitors.

The following data was extracted from their financial statements:

Item Company A Company B

Sales $500,000 $600.000

Cost of Goods Sold $200,000 $250,000

Operating Expenses $100,000 $120,000

Income Tax Expense $20,000 $25,000

Interest Expense $10,000 $15,000

Net Income $170,000 $190,000

Using the information provided, perform a comparative financial statement

analysis to evaluate the performance of Company A and Company B.

Solution

Step 1: Calculate Gross Profit Margin

The Gross Profit Margin is calculated as:

Gross Profit Margin = Sales −Cost of Goods Sold

Sales ×100

For Company A:

Gross Profit Margin (Company A) = 500,000 −200,000

500,000 ×100 = 60%

For Company B:

Gross Profit Margin (Company B) = 600,000 −250,000

600,000 ×100 = 58.33%

Step 2: Calculate Operating Profit Margin

The Operating Profit Margin is calculated as:

Operating Profit Margin = Sales −Cost of Goods Sold −Operating Expenses

Sales ×100

For Company A:

Operating Profit Margin (Company A) = 500,000 −200,000 −100,000

500,000 ×100 = 40%

For Company B:

Operating Profit Margin (Company B) = 600,000 −250,000 −120,000

600,000 ×100 = 38.33%

Step 3: Analyze Net Income

Comparing the Net Income of Company A and Company B: Company A

has a Net Income of

170,000 while Company B has a Net Income of

190,000.

This indicates that Company B is more profitable in terms of Net Income.

Question 27

Question

Company XYZ has provided the following financial information for the years

2019 and 2020:

Item 2019 2020

Total Assets $500,000 $600,000

Total Liabilities $200,000 $250,000

Total Equity $300,000 $350,000

Net Income $50,000 $60,000

Compute the following for Company XYZ based on the given financial in-

formation for the years 2019 and 2020:

1. Return on Assets (ROA)

2. Return on Equity (ROE)

3. Debt-to-Equity Ratio

Solution

Step 1: Calculate Return on Assets (ROA)

ROA = Net Income

Total Assets

ROA2019 =$50,000

$500,000 = 0.10 = 10%

ROA2020 =$60,000

$600,000 = 0.10 = 10%

Step 2: Calculate Return on Equity (ROE)

ROE = Net Income

Total Equity

ROE2019 =$50,000

$300,000 ≈0.1667 = 16.67%

ROE2020 =$60,000

$350,000 ≈0.1714 = 17.14%

Step 3: Calculate Debt-to-Equity Ratio

Debt-to-Equity Ratio = Total Liabilities

Total Equity

Debt-to-Equity Ratio2019 =$200,000

$300,000 = 0.6667

Debt-to-Equity Ratio2020 =$250,000

$350,000 ≈0.7143

Question 28

Question

The financial statements of two companies, Company A and Company B, are

provided below. You have been asked to perform a comparative financial state-

ment analysis to assess the financial performance of the two companies.

Company A

2019 2020

Revenue

500,000

600,000

Expenses

350,000

400,000

Net Income

150,000

200,000

Company B

2019 2020

Revenue

700,000

800,000

Expenses

500,000

600,000

Net Income

200,000

Based on the provided data, compare the financial performance of Company

A and Company B in terms of profitability and provide a recommendation for

potential investors.

Solution

Step 1: Calculate Profit Margin for Company A and Company B

The profit margin is calculated as:

Profit Margin = Net Income

Revenue ×100%

For Company A:

Profit Margin2019 =150,000

500,000 ×100% = 30%

Profit Margin2020 =200,000

600,000 ×100% = 33.33%

For Company B:

Profit Margin2019 =200,000

700,000 ×100% = 28.57%

Profit Margin2020 =200,000

800,000 ×100% = 25%

Step 2: Compare Profitability

Company A has shown an improvement in profitability from 2019 to 2020

with an increase in profit margin from 30

Step 3: Recommendation for Potential Investors

Based on the profitability analysis, Company A’s performance has been im-

proving over the years compared to Company B, which has shown a decline

in profitability. Therefore, potential investors may consider Company A as a

better investment option due to its increasing profitability.

Question 29

Question

Company XYZ is analyzing its financial statements for the years 2019 and 2020.

The company’s net income increased by 20

Solution

To analyze the changes in the company’s financial performance indicators, we

need to consider the components and formulas for each metric.

Step 1: Calculate Return on Assets (ROA)

ROA =N et Income

T otal Assets ×100%

Step 2: Analyze the changes in the company’s financial indicators

Let’s break down the changes in the company’s financial performance indicators

from 2019 to 2020: - Net income increased by 20- Total assets increased by 15-

Return on Assets (ROA) decreased from 8

Step 3: Possible reasons for the changes 1. Increase in net income:

The 20

2. Increase in total assets: The 15

3. Decrease in Return on Assets (ROA): The decrease in ROA from 8

In summary, the increase in net income and total assets shows growth, but

the decrease in ROA indicates that the company may need to focus on improving

profitability relative to its asset base and ensuring efficient asset utilization.

Question 30

Question

Company A and Company B are two firms in the same industry. The following

financial data is available for both companies:

Item Company A Company B

Revenue

500,000

600,000

Cost of Goods Sold

250,000

350,000

Operating Expenses

100,000

120,000

Interest Expense

15,000

20,000

Depreciation Expense

30,000

40,000

Calculate the operating income margin for both companies and interpret the

results.

Solution

Step 1: Calculate the Operating Income for each company using the formula:

Operating Income = Revenue −Cost of Goods Sold −Operating Expenses

For Company A:

Operating Income (A) = 500,000 −250,000 −100,000

= $150,000

For Company B:

Operating Income (B) = 600,000 −350,000 −120,000

= $130,000

Step 2: Calculate the Operating Income Margin for each company using the

formula:

Operating Income Margin = Operating Income

Revenue ×100%

For Company A:

Operating Income Margin (A) = 150,000

500,000 ×100%

= 30%

For Company B:

Operating Income Margin (B) = 130,000

600,000 ×100%

≈21.67%

Step 3: Interpretation of results: - Company A has a higher operating income

margin of 30% compared to Company B’s 21.67%. This indicates that Company

A is more efficient in generating operating profit relative to its revenue than

Company B. - Company A may have better cost control, higher sales prices, or

lower operating expenses compared to Company B. This could make Company

A a potentially more profitable and valuable company in the industry.

Question 31

Question

Company XYZ has provided the following financial information for two consec-

utive years:

Item Year 2 Year 1

Sales Revenue $500,000 $400,000

Cost of Goods Sold $200,000 $150,000

Operating Expenses $100,000 $80,000

Interest Expense $10,000 $8,000

Income Tax Expense $40,000 $32,000

Using this information, analyze and compare the financial performance of

Company XYZ between Year 2 and Year 1.

Solution

Step 1: Calculate the Gross Profit for each year.

Gross Profit Year 2 = Sales Revenue Year 2 −Cost of Goods Sold Year 2

Gross Profit Year 2 = $500,000 −$200,000 = $300,000

Gross Profit Year 1 = Sales Revenue Year 1 −Cost of Goods Sold Year 1

Gross Profit Year 1 = $400,000 −$150,000 = $250,000

Step 2: Calculate the Operating Income (EBIT) for each year.

Operating Income Year 2 = Gross Profit Year 2 −Operating Expenses Year 2

Operating Income Year 2 = $300,000 −$100,000 = $200,000

Operating Income Year 1 = Gross Profit Year 1 −Operating Expenses Year 1

Operating Income Year 1 = $250,000 −$80,000 = $170,000

Step 3: Calculate the Net Income for each year.

Net Income Year 2 = Operating Income Year 2−Interest Expense Year 2−Income Tax Expense Year 2

Net Income Year 2 = $200,000 −$10,000 −$40,000 = $150,000

Net Income Year 1 = Operating Income Year 1−Interest Expense Year 1−Income Tax Expense Year 1

Net Income Year 1 = $170,000 −$8,000 −$32,000 = $130,000

Step 4: Analyzing the financial performance of Company XYZ between Year

2 and Year 1: - Sales Revenue increased from

400,000 to

500,000. - Cost of

Goods Sold increased from

150,000 to

200,000. - Operating Expenses in-

creased from

80,000 to

100,000. - Net Income increased from

130,000 to

150,000.

Overall, Company XYZ showed growth in Sales Revenue and Net Income

from Year 1 to Year 2, despite an increase in expenses.

Question 32

Question

Company XYZ and Company ABC are both in the same industry. You are

given the following information from their financial statements for the year

ending December 31, 20X9:

Company XYZ Company ABC

Net Income

500,000

750,000

Total Assets

5,000,000

10,000,000

Total Liabilities

2,000,000

3,000,000

Shareholder’s Equity

3,000,000

7,000,000

Based on this information, compare the return on assets (ROA) and return

on equity (ROE) for both companies.

Solution

Step 1: Calculate the Return on Assets (ROA) for both companies using the

formula:

ROA =N etIncome

T otalAssets

For Company XYZ:

ROAXY Z =500,000

5,000,000 = 0.10or10%

For Company ABC:

ROAABC =750,000

10,000,000 = 0.075or7.5%

Therefore, Company XYZ has a higher Return on Assets.

Step 2: Calculate the Return on Equity (ROE) for both companies using

the formula:

ROE =N etIncome

Shareholder′sEquity

For Company XYZ:

ROEXY Z =500,000

3,000,000 = 0.1667or16.67%

For Company ABC:

ROEABC =750,000

7,000,000 = 0.1071or10.71%

Therefore, Company XYZ also has a higher Return on Equity.

Question 33

Question

Company XYZ provides you with the following financial information for the

years 2019 and 2020:

2019 2020

Revenue

500,000

550,000

Cost of Goods Sold

200,000

240,000

Operating Expenses

100,000

110,000

Net Income

80,000

90,000

Calculate the following for Company XYZ for both years:

1. Gross Profit Margin

2. Operating Profit Margin

3. Net Profit Margin

Solution

1. Gross Profit Margin:

Gross Profit Margin = Revenue −Cost of Goods Sold

Revenue ×100%

For 2019:

Gross Profit Margin (2019) = $500,000 −$200,000

$500,000 ×100%

=$300,000

$500,000×100%

= 60%

For 2020:

Gross Profit Margin (2020) = $550,000 −$240,000

$550,000 ×100%

=$310,000

$550,000×100%

= 56.36%

2. Operating Profit Margin:

Operating Profit Margin = Revenue - Cost of Goods Sold - Operating Expenses

Revenue ×100%

For 2019:

Operating Profit Margin (2019) = $500,000 −$200,000 −$100,000

$500,000 ×100%

=$200,000

$500,000×100%

= 40%

For 2020:

Operating Profit Margin (2020) = $550,000 −$240,000 −$110,000

$550,000 ×100%

=$200,000

$550,000×100%

= 36.36%

3. Net Profit Margin:

Net Profit Margin = Net Income

Revenue ×100%

For 2019:

Net Profit Margin (2019) = $80,000

$500,000×100%

= 16%

For 2020:

Net Profit Margin (2020) = $90,000

$550,000×100%

≈16.36%

Question 34

Question

You are given the following financial information for Company A and Company

B for the year 2021:

Company A



Net Income:

500,000



Total Assets:

5,000,000



Total Liabilities:

2,000,000

Company B



Net Income:

550,000



Total Assets:

7,000,000



Total Liabilities:

3,000,000

Compare the two companies’ financial situation in terms of profitability,

asset utilization, and financial leverage.

Solution

Step 1: Calculate the Return on Assets (ROA) for each company.



For Company A:

ROA =N et Income

T otal Assets =500,000

5,000,000 = 0.1 = 10%



For Company B:

ROA =N et Income

T otal Assets =550,000

7,000,000 ≈0.0786 = 7.86%

Step 2: Compare the ROA of the two companies. Company A has a higher

ROA of 10

Step 3: Calculate the Return on Equity (ROE) for each company.



For Company A:

ROE =N et Income

T otal Equity =500,000

5,000,000 −2,000,000 =500,000

3,000,000 = 0.1667 = 16.67%



For Company B:

ROE =N et Income

T otal Equity =550,000

7,000,000 −3,000,000 =550,000

4,000,000 = 0.1375 = 13.75%

Step 4: Compare the ROE of the two companies. Company A has a higher

ROE of 16.67

Step 5: Calculate the Debt to Equity ratio for each company.



For Company A:

Debt to Equity ratio =T otal Liabilities

T otal Equity =2,000,000

3,000,000 = 0.6667 = 66.67%



For Company B:

Debt to Equity ratio =T otal Liabilities

T otal Equity =3,000,000

4,000,000 = 0.75 = 75%

Step 6: Compare the Debt to Equity ratio of the two companies. Company

A has a lower Debt to Equity ratio of 66.67

Question 35

Question

Company XYZ is analyzing the financial statements of two competitors, Com-

pany A and Company B, in the same industry. The analysts noticed that the

net income of Company A increased by 20

Solution

Step 1: Calculation of Return on Equity (ROE) ROE is calculated using the

formula:

ROE =N et Income

Shareholders′Equity ×100%

Step 2: Analysis 1. **Increase in Net Income** - Company A reported a 20

2. **Decrease in Net Income** - Company B reported a 10

Step 2: Calculate common size percentages for Company B.

Revenue % = $700,000

$700,000 ×100% = 100%

Cost of Goods Sold % = $350,000

$700,000 ×100% = 50%

Gross Profit % = $350,000

$700,000 ×100% = 50%

Operating Expenses % = $200,000

$700,000 ×100% = 28.57%

Net Income % = $150,000

$700,000 ×100% = 21.43%

Therefore, the common size percentages for Company A and Company B

have been calculated.

Question 2

Question

Company A and Company B are two competing companies in the same industry.

Below are selected data from their comparative financial statements for the

current year:

Item Company A Company B

Net Income

500,000

700,000

Total Assets

5,000,000

6,000,000

Total Liabilities

2,000,000

3,000,000

Common Stock Equity

3,000,000

2,000,000

Based on the information provided, compare the two companies in terms of

profitability, asset utilization, financial leverage, and return on common equity.

Solution

Step 1: Profitability Analysis

Profitability can be measured using the Return on Assets (ROA) ratio:

ROA = Net Income

Total Assets

For Company A:

ROAA=500,000

5,000,000 = 0.10 = 10%

For Company B:

ROAB=700,000

6,000,000 ≈0.1167 ≈11.67%

Since Company B has a higher ROA, it is more profitable in terms of asset

utilization.

Step 2: Asset Utilization Analysis

Asset Utilization can be measured using the Asset Turnover ratio:

Asset Turnover = Net Sales

Average Total Assets

Given that we do not have net sales data, we cannot calculate the Asset

Turnover ratio for the two companies.

Step 3: Financial Leverage Analysis

Financial Leverage can be measured using the Debt-to-Equity (D/E) ratio:

D/E Ratio = Total Liabilities

Common Stock Equity

For Company A:

D/E RatioA=2,000,000

3,000,000 = 0.67

For Company B:

D/E RatioB=3,000,000

2,000,000 = 1.5

Company B has a higher D/E ratio, indicating higher financial leverage.

Step 4: Return on Common Equity Analysis

Return on Common Equity (ROE) can be calculated as:

ROE = Net Income

Common Stock Equity

For Company A:

ROEA=500,000

3,000,000 ≈0.1667 ≈16.67%

For Company B:

ROEB=700,000

2,000,000 = 0.35 = 35%

Company B has a higher ROE, indicating better return for common equity

investors.

Question 3

Question

Company X and Company Y are both in the retail industry. The income state-

ments for both companies for the year ended December 31, 2020, are shown

below:

Item Company X Company Y

Revenue $750,000 $950,000

Cost of Goods Sold $350,000 $500,000

Gross Profit ? ?

Operating Expenses $200,000 $300,000

Net Income $100,000 $120,000

Given the above data, calculate the missing values for the Gross Profit of

Company X and Company Y.

Solution

Step 1: Calculate the Gross Profit for Company X:

Gross Profit (Company X) = Revenue −Cost of Goods Sold

Gross Profit (Company X) = $750,000 −$350,000 = $400,000

Step 2: Calculate the Gross Profit for Company Y:

Gross Profit (Company Y) = Revenue −Cost of Goods Sold

Gross Profit (Company Y) = $950,000 −$500,000 = $450,000

Therefore, the missing values for the Gross Profit are:

Gross Profit (Company X) = $400,000 and Gross Profit (Company Y) = $450,000

Question 4

Question

The following data is extracted from the financial statements of two companies,

Company A and Company B, for the year ending December 31, 2020:

Company A Company B Industry Average

Net Sales

500,000

600,000 -

Cost of Goods Sold

250,000

280,000 -

Gross Profit

250,000

320,000 -

Operating Expenses

120,000

150,000 -

Net Income

80,000

120,000 -

Total Assets

800,000

1,000,000 -

Total Liabilities

400,000

500,000 -

Given the information above, analyze the financial performance and position

of Company A and Company B. Also, compare their performance with the

industry average where applicable.

Solution

Step 1: Calculate the gross profit margin for Company A and Company B. The

formula for gross profit margin is:

Gross Profit Margin = Gross Profit

Net Sales ×100%

For Company A:

Gross Profit Margin (Company A) = $250,000

$500,000 ×100% = 50%

For Company B:

Gross Profit Margin (Company B) = $320,000

$600,000 ×100% = 53.33%

Step 2: Compare the gross profit margins of Company A and Company B.

Company B has a higher gross profit margin compared to Company A. This

indicates that Company B is more efficient in managing its production costs

compared to Company A.

Step 3: Calculate the return on assets (ROA) for Company A and Company

B. The formula for ROA is:

ROA = Net Income

Total Assets ×100%

For Company A:

ROA (Company A) = $80,000

$800,000 ×100% = 10%

For Company B:

ROA (Company B) = $120,000

$1,000,000 ×100% = 12%

Step 4: Compare the ROA of Company A and Company B. Company B

has a higher ROA compared to Company A. This indicates that Company B is

more efficient in generating profits from its assets compared to Company A.

Step 5: Analyze the total liabilities of Company A and Company B. Com-

pany A has total liabilities of

400,000, while Company B has total liabilities of

500,000. This indicates that Company B has a higher level of debt compared

to Company A.

Step 6: Make overall conclusions. Company B outperforms Company A in

terms of both gross profit margin and return on assets. However, Company A

has a lower level of total liabilities compared to Company B. Further analysis is

needed to determine the reasons behind these differences and their implications

for the financial health of the companies.