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

ACCT 302 - INTERMEDIATE

ACCOUNTING II - Comparative

financial statement analysis

Question Bank - Set 4

Liberty University

Question 1

Question

The following are the comparative income statements for Company XYZ for the

years 2020 and 2021:

Item 2020 2021

Revenue $500,000 $600,000

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

Gross Profit $300,000 $350,000

Operating Expenses $150,000 $180,000

Net Income $150,000 $170,000

Calculate the following for Company XYZ for the year 2021:

1. Gross profit margin

2. Operating profit margin

3. Net profit margin

Solution

Step 1: Calculate the Gross Profit Margin

Gross Profit Margin = Revenue −Cost of Goods Sold

Revenue ×100%

Gross Profit Margin = $600,000 −$250,000

$600,000 ×100%

Gross Profit Margin = $350,000

$600,000×100%

Gross Profit Margin ≈58.33%

Step 2: Calculate the Operating Profit Margin

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

Revenue ×100%

Operating Profit Margin = $600,000 −$250,000 −$180,000

$600,000 ×100%

Operating Profit Margin = $170,000

$600,000×100%

Operating Profit Margin ≈28.33%

Step 3: Calculate the Net Profit Margin

Net Profit Margin = Net Income

Revenue ×100%

Net Profit Margin = $170,000

$600,000×100%

Net Profit Margin ≈28.33%

Therefore, for the year 2021, Company XYZ has:

1. Gross profit margin of approximately 58.33%

2. Operating profit margin of approximately 28.33%

3. Net profit margin of approximately 28.33%

Question 2

Question

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

provided below. Perform a comparative financial statement analysis to deter-

mine which company is in a better financial position.

Company A:

Item 2019 2020

Revenue

500,000

600,000

Expenses

350,000

400,000

Net Income

150,000

200,000

Company B:

Item 2019 2020

Revenue

700,000

800,000

Expenses

500,000

600,000

Net Income

200,000

Solution

Step-by-step financial statement analysis for Company A and Company B:

1. Calculate Net Profit Margin:



Company A:

Net Profit MarginA=Net IncomeA

RevenueA×100

Net Profit MarginA=200,000

600,000×100 = 33.33%



Company B:

Net Profit MarginB=Net IncomeB

RevenueB×100

Net Profit MarginB=200,000

800,000×100 = 25.00%

2. Calculate Return on Assets (ROA):



Company A:

ROAA=Net IncomeA

T otal AssetsA×100

(Total Assets information is not provided)



Company B:

ROAB=Net IncomeB

T otal AssetsB×100

(Total Assets information is not provided)

3. Analyze Liquidity:



Liquidity ratios such as Current Ratio or Quick Ratio can be calcu-

lated using Balance Sheet data (not provided).

4. Conclusion: Based on the given information, Company A has a higher

Net Profit Margin compared to Company B. However, further analysis is

needed, including liquidity ratios and ROA, to determine which company

is in a better financial position overall.

Question 3

Question

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

mance of two companies, Company A and Company B. You are provided with

the following financial information:

Company A:



Net Income:

500,000



Total Assets:

3,000,000



Total Liabilities:

1,500,000

Company B:



Net Income:

700,000



Total Assets:

5,000,000



Total Liabilities:

2,000,000

Based on the information provided, which company has a better return on

assets (ROA) ratio? Briefly explain your answer.

Solution

Step 1: Calculate the Return on Assets (ROA) ratio for Company A and Com-

pany B using the formula:

ROA = Net Income

Total Assets

For Company A:

ROAA=$500,000

$3,000,000 = 0.1667 or 16.67%

For Company B:

ROAB=$700,000

$5,000,000 = 0.14 or 14%

Step 2: Compare the ROA ratios of Company A and Company B.

Since Company A has a higher ROA of 16.67%, compared to Company B’s

ROA of 14

Question 4

Question

Company XYZ and Company ABC are two competitors in the retail industry.

The following comparative financial statements provide information for both

companies for the year ended December 31, 20X9:

Company XYZ Company ABC

Sales Revenue

500,000

700,000

Cost of Goods Sold

300,000

400,000

Gross Profit

200,000

300,000

Operating Expenses

100,000

150,000

Net Income

100,000

150,000

Total Assets

600,000

800,000

Total Liabilities

200,000

250,000

Shareholders’ Equity

400,000

550,000

Assuming everything else remains constant, which company is in a better

financial position based on the provided information?

Solution

Step 1: Calculate Profit Margin The profit margin is a measure of a com-

pany’s profitability. It is calculated by dividing the net income by the sales

revenue and multiplying by 100 to express it as a percentage.

For Company XYZ: Profit Margin = ($100,000/$500,000) ×100% = 20%

For Company ABC: Profit Margin = ($150,000/$700,000)×100% ≈21.43%

Therefore, Company ABC has a higher profit margin than Company XYZ.

Step 2: Analyze Operating Efficiency Operating efficiency can be eval-

uated based on the company’s gross profit margin. It is calculated by dividing

the gross profit by the sales revenue and multiplying by 100 to express it as a

percentage.

For Company XYZ: Operating Efficiency = ($200,000/$500,000) ×100% =

40%

For Company ABC: Operating Efficiency = ($300,000/$700,000) ×100% ≈

42.86%

Company ABC has a higher operating efficiency than Company XYZ.

Step 3: Evaluate Financial Stability Financial stability can be assessed

based on the debt-to-equity ratio. It is calculated by dividing total liabilities by

shareholders’ equity.

For Company XYZ: Debt-to-Equity Ratio = $200,000/$400,000 = 0.5

For Company ABC: Debt-to-Equity Ratio = $250,000/$550,000 ≈0.45

Company ABC has a lower debt-to-equity ratio, indicating better financial

stability compared to Company XYZ.

Step 4: Conclusion Based on the profit margin, operating efficiency, and

debt-to-equity ratio calculations, Company ABC appears to be in a better fi-

nancial position compared to Company XYZ.

Question 5

Question

The financial statements for Company XYZ for two consecutive years are given

below:

Year 1 - Revenue:

500,000 - Cost of Goods Sold:

200,000 - Gross Profit:

300,000 - Operating Expenses:

100,000 - Net Income:

200,000

Year 2 - Revenue:

600,000 - Cost of Goods Sold:

240,000 - Gross Profit:

360,000 - Operating Expenses:

120,000 - Net Income:

240,000

Compare the financial performance of Company XYZ for Year 1 and Year 2

using the provided information.

Solution

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

Gross Profit Margin = Gross Profit

Revenue ×100

Year 1:

Gross Profit Margin (Year 1) = 300,000

500,000 ×100 = 60%

Year 2:

Gross Profit Margin (Year 2) = 360,000

600,000 ×100 = 60%

Step 2: Interpretation of Gross Profit Margin: - The Gross Profit Margin

for both years is 60%. This indicates that the company is able to maintain the

same level of profit from its revenue in both years.

Step 3: Calculate the Operating Profit Margin for both years.

Operating Profit Margin = Operating Income

Revenue ×100

Year 1:

Operating Profit Margin (Year 1) = 200,000

500,000 ×100 = 40%

Year 2:

Operating Profit Margin (Year 2) = 240,000

600,000 ×100 = 40%

Step 4: Interpretation of Operating Profit Margin: - The Operating Profit

Margin for both years is 40%. This indicates that the company is able to

maintain the same level of profit after operating expenses from its revenue in

both years.

Step 5: Compare Net Income: - The net income increased from

200,000

in Year 1 to

240,000 in Year 2. This indicates an improvement in the overall

profitability of the company.

Overall, Company XYZ showed consistent performance in maintaining gross

profit and operating profit margins while also achieving an increase in net income

from Year 1 to Year 2.

Question 6

Question

You are given the following financial statements for Company XYZ for two

consecutive years:

Income Statement

Items Year 2 Year 1

Revenue $500,000 $400,000

Expenses $300,000 $240,000

NetIncome $200,000 $160,000

Balance Sheet

Assets Year 2 Year 1

Cash $50,000 $40,000

AccountsReceivable $80,000 $70,000

Inventory $60,000 $50,000

T otalAssets $190,000 $160,000

Liabilities Year 2 Year 1

AccountsP ayable $30,000 $20,000

LoansP ayable $40,000 $50,000

T otalLiabilities $70,000 $70,000

As a financial analyst, evaluate and compare Company XYZ’s financial per-

formance and position between Year 1 and Year 2.

Solution

Step 1: Calculate financial ratios for each year.

1. Gross Profit Margin:

Gross Profit Margin = Revenue −Expenses

Revenue ×100%

For Year 1:

Gross Profit Margin = $400,000 −$240,000

$400,000 ×100% = $160,000

$400,000×100% = 40%

For Year 2:

Gross Profit Margin = $500,000 −$300,000

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

$500,000×100% = 40%

Both Year 1 and Year 2 have a gross profit margin of 40%.

2. Current Ratio:

Current Ratio = Current Assets

Current Liabilities

For Year 1:

Current Ratio = $160,000

$70,000 = 2.29

For Year 2:

Current Ratio = $190,000

$70,000 = 2.71

The current ratio increased from 2.29 in Year 1 to 2.71 in Year 2, indicating

improved liquidity.

Step 2: Analyze the results.

- The gross profit margin remained the same in both years, suggesting con-

sistent profitability. - The increase in the current ratio from Year 1 to Year

2 indicates improved liquidity for Company XYZ. - Company XYZ’s financial

performance and position have shown positive trends between Year 1 and Year

Question 7

Question

The following information is extracted from the financial statements of Company

XYZ for the years 2019 and 2020:

Item 2019 2020

Revenue

500,000

600,000

Cost of Goods Sold

300,000

350,000

Operating Expenses

100,000

120,000

Interest Expense

10,000

15,000

Income Tax Expense

20,000

25,000

Given this information, calculate the following for Company XYZ for the

years 2019 and 2020: 1. Gross Profit Margin 2. Operating Profit Margin 3. Net

Profit Margin

Solution

1. Gross Profit Margin:

Gross Profit = Revenue −Cost of Goods Sold

2019: $500,000 −$300,000 = $200,000

2020: $600,000 −$350,000 = $250,000

Gross Profit Margin = Gross Profit

Revenue ×100%

2019: 200,000

500,000 ×100% = 40%

2020: 250,000

600,000 ×100% = 41.67%

2. Operating Profit Margin:

Operating Profit = Gross Profit −Operating Expenses

2019: $200,000 −$100,000 = $100,000

2020: $250,000 −$120,000 = $130,000

Operating Profit Margin = Operating Profit

Revenue ×100%

2019: 100,000

500,000 ×100% = 20%

2020: 130,000

600,000 ×100% = 21.67%

3. Net Profit Margin:

Net Profit = Operating Profit −Interest Expense −Income Tax Expense

2019: $100,000 −$10,000 −$20,000 = $70,000

2020: $130,000 −$15,000 −$25,000 = $90,000

Net Profit Margin = Net Profit

Revenue ×100%

2019: 70,000

500,000 ×100% = 14%

2020: 90,000

600,000 ×100% = 15%

Question 8

Question

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

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

Item Company A Company B

Revenue

500,000

600,000

Cost of Goods Sold

200,000

250,000

Operating Expenses

100,000

120,000

Interest Expense

20,000

15,000

Income Tax Expense

30,000

40,000

Calculate the following ratios for both companies and discuss which com-

pany appears to be in a stronger financial position: 1. Gross Profit Margin 2.

Operating Profit Margin 3. Net Profit Margin

Solution

Step 1: Calculate Ratios

1. Gross Profit Margin:

Gross Profit Margin = 1−Cost of Goods Sold

Revenue ×100%

Company A:

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

$500,000×100% = 60%

Company B:

Gross Profit Margin (B) = 1−$250,000

$600,000×100% = 58.33%

2. Operating Profit Margin:

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

Revenue ×100%

Company A:

Operating Profit Margin (A) = 1−$100,000 + $20,000 + $30,000

$500,000 ×100% = 50%

Company B:

Operating Profit Margin (B) = 1−$120,000 + $15,000 + $40,000

$600,000 ×100% = 41.67%

3. Net Profit Margin:

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

Revenue ×100%

Company A:

Net Profit Margin (A) = 1−$100,000 + $20,000 + $30,000

$500,000 ×100% = 50%

Company B:

Net Profit Margin (B) = 1−$120,000 + $15,000 + $40,000

$600,000 ×100% = 35%

Step 2: Analysis

- Company A has a higher Gross Profit Margin (60- Company A also has

higher Operating Profit Margin (50

Based on the calculated ratios, it appears that Company A is in a stronger

financial position compared to Company B.

Question 9

Question

The following data is taken from the financial statements of Company XYZ for

the years 20X1 and 20X2:

Item 20X1 20X2

Total Assets $500,000 $600,000

Total Liabilities $200,000 $250,000

Net Income $50,000 $70,000

Assuming all other things remain constant, calculate the following financial

ratios for Company XYZ for both years: (a) Debt-to-Asset Ratio, (b) Return

on Assets (ROA), and (c) Return on Equity (ROE).

Solution

Step 1: Calculate the Debt-to-Asset Ratio for both years.

Debt-to-Asset Ratio = Total Liabilities

Total Assets

a) For 20X1:

Debt-to-Asset Ratio20X1 =$200,000

$500,000 = 0.40 or 40%

b) For 20X2:

Debt-to-Asset Ratio20X2 =$250,000

$600,000 = 0.4167 or 41.67%

Step 2: Calculate the Return on Assets (ROA) for both years.

ROA = Net Income

Total Assets

a) For 20X1:

ROA20X1 =$50,000

$500,000 = 0.10 or 10%

b) For 20X2:

ROA20X2 =$70,000

$600,000 = 0.1167 or 11.67%

Step 3: Calculate the Return on Equity (ROE) for both years.

ROE = Net Income

Total Equity

Since Total Equity is calculated as Total Assets - Total Liabilities, we have:

Total Equity20X1 = $500,000 −$200,000 = $300,000

Total Equity20X2 = $600,000 −$250,000 = $350,000

a) For 20X1:

ROE20X1 =$50,000

$300,000 = 0.1667 or 16.67%

b) For 20X2:

ROE20X2 =$70,000

$350,000 = 0.20 or 20%

Therefore, the calculated ratios for Company XYZ for the years 20X1 and

20X2 are: (a) Debt-to-Asset Ratio: 40(b) Return on Assets (ROA): 10(c) Return

on Equity (ROE): 16.67

Question 10

Question

The following information is taken from the financial statements of two compa-

nies, A and B. Compute the debt-to-equity ratio for each company.

Company A Company B

Total Assets

500,000

750,000

Total Liabilities

200,000

300,000

Total Equity ? ?

Solution

Step 1: Calculate the total equity for each company using the formula: Total

Equity = Total Assets - Total Liabilities.

For Company A: Total Equity =

500,000 -

200,000 =

300,000

For Company B: Total Equity =

750,000 -

300,000 =

450,000

Step 2: Calculate the debt-to-equity ratio for each company using the for-

mula: Debt-to-Equity Ratio = Total Liabilities / Total Equity.

For Company A: Debt-to-Equity Ratio =

200,000 /

300,000 = 0.67

For Company B: Debt-to-Equity Ratio =

300,000 /

450,000 = 0.67

Therefore, the debt-to-equity ratio for Company A is 0.67 and for Company

B is also 0.67.

Question 11

Question

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

The financial statements of both companies are provided below:

Company XYZ

Category 2020 2021

Revenue

500,000

600,000

Expenses

350,000

400,000

Net Income

150,000

200,000

Company ABC

Category 2020 2021

Revenue

450,000

550,000

Expenses

300,000

350,000

Net Income

150,000

200,000

Based on the information provided, which company would you consider more

efficient in managing its expenses? Justify your answer.

Solution

To determine which company is more efficient in managing expenses, we will

analyze their expense ratios for 2020 and 2021.

Step 1: Calculate Expense Ratio for Company XYZ The expense

ratio is calculated using the formula:

Expense Ratio = Expenses

Revenue ×100%

For Company XYZ in 2020:

Expense Ratio = 350,000

500,000 ×100% = 70%

For Company XYZ in 2021:

Expense Ratio = 400,000

600,000 ×100% = 66.67%

Step 2: Calculate Expense Ratio for Company ABC For Company

ABC in 2020:

Expense Ratio = 300,000

450,000 ×100% = 66.67%

For Company ABC in 2021:

Expense Ratio = 350,000

550,000 ×100% = 63.64%

Step 3: Compare Expense Ratios Comparing the expense ratios for

both companies: - In 2020, Company XYZ had an expense ratio of 70- In 2021,

Company XYZ had an expense ratio of 66.67

Based on the analysis, Company ABC is more efficient in managing its ex-

penses as it has lower expense ratios in both years compared to Company XYZ.

Question 12

Question

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

following data was extracted from their financial statements for the year ending

December 31, 2021:

Company A Company B

Net Sales

500,000

450,000

Cost of Goods Sold

200,000

180,000

Operating Expenses

100,000

120,000

Net Income

80,000

60,000

Total Assets

600,000

700,000

Total Liabilities

200,000

250,000

Perform a comparative financial statement analysis to evaluate and compare

the financial performance of Company A and Company B.

Solution

Step 1: Calculate the gross profit margin for both companies using the formula:

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

Net Sales ×100%

For Company A:

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

$500,000 ×100% = 60%

For Company B:

Gross Profit Margin (B) = $450,000 −$180,000

$450,000 ×100% = 60%

Step 2: Calculate the operating profit margin for both companies using the

formula:

Operating Profit Margin = Net Income

Net Sales ×100%

For Company A:

Operating Profit Margin (A) = $80,000

$500,000×100% = 16%

For Company B:

Operating Profit Margin (B) = $60,000

$450,000×100% = 13.33%

Step 3: Calculate the return on assets (ROA) for both companies using the

formula:

ROA = Net Income

Total Assets×100%

For Company A:

ROA (A) = $80,000

$600,000×100% = 13.33%

For Company B:

ROA (B) = $60,000

$700,000×100% ≈8.57%

By comparing these financial metrics, we can see that Company A outper-

forms Company B in terms of gross profit margin, operating profit margin, and

return on assets. Company A is operating more efficiently and generating more

profit for each dollar of sales and assets.

Question 13

Question

The following data relates to Company X:

Item 2019 2020 2021

Sales

500,000

600,000

700,000

Cost of Goods Sold

300,000

360,000

420,000

Gross Profit

200,000

240,000

280,000

Operating Expenses

100,000

120,000

140,000

Net Income Before Taxes

100,000

120,000

140,000

Assuming all other factors remain constant, what is the percentage increase

in net income before taxes from 2019 to 2021?

Solution

Step 1: Calculate the net income before taxes for each year.



For 2019: Net Income Before Taxes = Sales - Cost of Goods Sold - Oper-

ating Expenses =

500,000 -

300,000 -

100,000 =

100,000



For 2020: Net Income Before Taxes = Sales - Cost of Goods Sold - Oper-

ating Expenses =

600,000 -

360,000 -

120,000 =

120,000



For 2021: Net Income Before Taxes = Sales - Cost of Goods Sold - Oper-

ating Expenses =

700,000 -

420,000 -

140,000 =

140,000

Step 2: Calculate the percentage increase in net income before taxes from

2019 to 2021.

Net Income Increase = Net Income in 2021 −Net Income in 2019

= $140,000 −$100,000

= $40,000

Percentage Increase = Net Income Increase

Net Income in 2019 ×100%

=$40,000

$100,000×100%

= 40%

Therefore, the percentage increase in net income before taxes from 2019 to

2021 is 40

Question 14

Question

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

comparative financial statements for both companies are given below:

Company A

Year 2 Year 1

Net Sales

500,000

400,000

Cost of Goods Sold

200,000

180,000

Gross Profit

300,000

220,000

Operating Expenses

150,000

120,000

Net Income

150,000

100,000

Company B

Year 2 Year 1

Net Sales

600,000

500,000

Cost of Goods Sold

250,000

200,000

Gross Profit

350,000

300,000

Operating Expenses

200,000

160,000

Net Income

150,000

140,000

Which company shows an improvement in gross profit margin and operating

profit margin from Year 1 to Year 2, and why? Provide your analysis based on

the data given above.

Solution

Step 1: Calculate the Gross Profit Margin for Year 1 and Year 2 for both

companies using the formula:

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

Net Sales ×100%

Company A: For Year 1:

Gross Profit Margin = 400,000 −180,000

400,000 ×100% = 55%

For Year 2:

Gross Profit Margin = 500,000 −200,000

500,000 ×100% = 60%

Company B: For Year 1:

Gross Profit Margin = 500,000 −200,000

500,000 ×100% = 60%

For Year 2:

Gross Profit Margin = 600,000 −250,000

600,000 ×100% = 58.33%

Step 2: Calculate the Operating Profit Margin for Year 1 and Year 2 using

the formula:

Operating Profit Margin = Net Income

Net Sales ×100%

Company A: For Year 1:

Operating Profit Margin = 100,000

400,000×100% = 25%

For Year 2:

Operating Profit Margin = 150,000

500,000×100% = 30%

Company B: For Year 1:

Operating Profit Margin = 140,000

500,000×100% = 28%

For Year 2:

Operating Profit Margin = 150,000

600,000×100% = 25%

Based on the calculations above, Company A shows an improvement in both

gross profit margin and operating profit margin from Year 1 to Year 2. The gross

profit margin increased from 55

Question 15

Question

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

industry. The following data is extracted from their comparative income state-

ments:

Item Company XYZ Company ABC

Sales $450,000 $500,000

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

Gross Profit $250,000 $270,000

Operating Expenses $100,000 $110,000

Net Income $150,000 $160,000

Calculate and compare the following financial ratios for the two companies:

1. Gross profit margin 2. Operating profit margin 3. Net profit margin

Solution

Step 1: Calculate the financial ratios for Company XYZ.



Gross profit margin:

Gross Profit Margin = Gross Profit

Sales ×100%

Gross Profit (XYZ) =

250,000

Sales (XYZ) =

450,000

Gross Profit Margin (XYZ) = 250,000

450,000 ×100% = 5

9×100% ≈55.56%



Operating profit margin:

Operating Profit Margin = Operating Income

Sales ×100%

Operating Income (XYZ) = Sales - Cost of Goods Sold - Operating Ex-

penses

Operating Expenses (XYZ) =

100,000

Operating Income (XYZ) = 450,000 −200,000 −100,000 = 150,000

Sales (XYZ) =

450,000

Operating Profit Margin (XYZ) = 150,000

450,000 ×100% = 1

3×100% = 33.33%



Net profit margin:

Net Profit Margin = Net Income

Sales ×100%

Net Income (XYZ) =

150,000

Sales (XYZ) =

450,000

Net Profit Margin (XYZ) = 150,000

450,000 ×100% = 1

3×100% = 33.33%

Step 2: Calculate the financial ratios for Company ABC. (Follow similar

steps as above)

Step 3: Compare the ratios for the two companies to analyze their financial

performance.

Question 16

Question

Company XYZ had the following financial information for the years 2020 and

2021:

2020 2021

Net Income

150,000

180,000

Total Assets

1,500,000

1,700,000

Total Liabilities

600,000

800,000

Total Equity

900,000

Calculate the following financial ratios for Company XYZ for the years 2020

and 2021: 1. Return on Assets (ROA) 2. Return on Equity (ROE) 3. Debt to

Equity Ratio

Solution

1. Return on Assets (ROA):

ROA = Net Income

Total Assets ×100%

Step 1: Calculate ROA for 2020

ROA2020 =150,000

1,500,000 ×100% = 10%

Step 2: Calculate ROA for 2021

ROA2021 =180,000

1,700,000 ×100% ≈10.59%

2. Return on Equity (ROE):

ROE = Net Income

Total Equity ×100%

Step 1: Calculate ROE for 2020

ROE2020 =150,000

900,000 ×100% ≈16.67%

Step 2: Calculate ROE for 2021

ROE2021 =180,000

900,000 ×100% = 20%

3. Debt to Equity Ratio:

Debt to Equity Ratio = Total Liabilities

Total Equity

Step 1: Calculate Debt to Equity Ratio for 2020

Debt to Equity Ratio2020 =600,000

900,000 = 0.67

Step 2: Calculate Debt to Equity Ratio for 2021

Debt to Equity Ratio2021 =800,000

900,000 ≈0.89

Question 17

Question

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

The following data has been extracted from their financial statements:

Item Company A Company B

Net Income

500,000

600,000

Total Assets

4,000,000

3,500,000

Total Liabilities

1,500,000

1,200,000

Total Equity ?

2,300,000

Determine the missing value for the Total Equity of Company A.

Solution

Step 1: Calculate the Total Equity of Company A using the accounting equation:

Total Equity = Total Assets −Total Liabilities

Step 2: Substitute the given values into the equation:

Total Equity of Company A = $4,000,000 −$1,500,000

Step 3: Perform the subtraction:

Total Equity of Company A = $2,500,000

Therefore, the missing value for the Total Equity of Company A is

2,500,000.

Question 18

Question

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

The following are selected income statement data for both companies:

Item Company A Company B

Revenue $500,000 $450,000

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

Gross Profit ? $150,000

Operating Expenses $100,000 $75,000

Net Income $60,000 $45,000

Calculate the missing value for Company A’s gross profit.

Solution

Step 1: Calculate Company A’s Gross Profit.

Gross Profit (A) = Revenue (A) −Cost of Goods Sold (A)

Step 2: Substitute the given values.

Gross Profit (A) = $500,000 −$200,000

Step 3: Perform the calculation.

Gross Profit (A) = $300,000

Therefore, the missing value for Company A’s gross profit is

300,000.

Question 19

Question

The following data represents the balance sheet of Company XYZ for the years

2020 and 2021:

2020 2021

Current assets $150,000 $180,000

Non-current assets $250,000 $280,000

Current liabilities $90,000 $120,000

Non-current liabilities $130,000 $150,000

Using this information, calculate the working capital and debt-to-equity ratio

for Company XYZ for the years 2020 and 2021. Interpret the results in the

context of financial performance and risk management.

Solution

Step 1: Calculate the working capital for Company XYZ in the years 2020 and

2021.

Working Capital = Current Assets −Current Liabilities

Working Capital (2020) = $150,000 −$90,000 = $60,000

Working Capital (2021) = $180,000 −$120,000 = $60,000

Step 2: Calculate the debt-to-equity ratio for Company XYZ in the years

2020 and 2021.

Debt-to-Equity Ratio = Total Liabilities

Total Equity

Total Liabilities (2020) = $90,000 + $130,000 = $220,000

Total Equity (2020) = $150,000 + $250,000 = $400,000

Debt-to-Equity Ratio (2020) = $220,000

$400,000 = 0.55

Total Liabilities (2021) = $120,000 + $150,000 = $270,000

Total Equity (2021) = $180,000 + $280,000 = $460,000

Debt-to-Equity Ratio (2021) = $270,000

$460,000 ≈0.59

Interpretation: - The working capital for Company XYZ remained constant

60,000 from 2020 to 2021, indicating stability in the company’s short-term

financial health. - The debt-to-equity ratio increased from 0.55 in 2020 to ap-

proximately 0.59 in 2021, suggesting that the company took on more debt rel-

ative to equity. This may signify increased financial risk for the company in

2021.

Question 20

Question

Company X and Company Y are two competing firms in the same industry. Be-

low are selected financial data for both companies for the year ending December

31, 20X9:

Company X



Net Sales:

500,000



Cost of Goods Sold:

250,000



Gross Profit:

250,000



Operating Expenses:

100,000



Net Income:

80,000

Company Y



Net Sales:

450,000



Cost of Goods Sold:

200,000



Gross Profit:

250,000



Operating Expenses:

110,000



Net Income:

65,000

Compare the profitability of Company X and Company Y based on the

provided financial data.

Solution

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



Company X:

Gross Profit Margin for X = Gross Profit for X

Net Sales for X ×100% = 250,000

500,000×100% = 50%



Company Y:

Gross Profit Margin for Y = Gross Profit for Y

Net Sales for Y ×100% = 250,000

450,000×100% ≈55.56%

Step 2: Compare the Operating Profit Margin for both companies:



Company X:

Operating Profit Margin for X = Net Income for X

Net Sales for X ×100% = 80,000

500,000×100% = 16%



Company Y:

Operating Profit Margin for Y = Net Income for Y

Net Sales for Y ×100% = 65,000

450,000×100% ≈14.44%

Step 3: Based on the calculations, Company X has a higher Gross Profit Mar-

gin (50%) compared to Company Y (approximately 55.56%). However, Com-

pany Y has a slightly higher Operating Profit Margin (approximately 14.44%)

compared to Company X (16%). Overall, based on these metrics, Company X

seems to be more profitable in terms of gross profit, while Company Y has a

slightly better operating profit margin.

Question 21

Question

In comparing the financial statements of two companies, Company A and Com-

pany B, you notice that Company A has a higher return on equity (ROE) than

Company B. Discuss possible reasons for this difference in ROE between the

two companies.

Solution

To analyze the difference in return on equity (ROE) between Company A and

Company B, we must consider various factors that could be influencing this

discrepancy.

Step 1: Understand the ROE formula The return on equity (ROE)

formula is:

ROE = Net Income

Shareholders’ Equity ×100%

Step 2: Analyze the possible reasons for the difference in ROE

Possible reasons for the difference in ROE between Company A and Com-

pany B could include: - Differences in profitability: Company A may have higher

profit margins or better cost control measures in place compared to Company

B, leading to a higher net income. - Differences in leverage: Company A may

use more debt financing, which can amplify returns when profitability is high

but can also increase risk. If Company A has higher financial leverage, it may

result in higher ROE. - Differences in asset turnover: Company A may generate

more sales from a given level of assets compared to Company B, resulting in

higher ROE. - Differences in capital structure: Company A may have a higher

proportion of equity in its capital structure compared to Company B, which

could result in higher ROE due to lower interest expenses.

Step 3: Further analysis To gain a deeper understanding of the difference

in ROE between Company A and Company B, it would be beneficial to conduct

a thorough comparative financial statement analysis, looking at key financial

ratios, industry benchmarks, and qualitative factors that could be impacting

each company’s performance.

By evaluating these factors, we can better understand why Company A has

a higher return on equity than Company B and identify areas where Company

B could potentially improve its performance to narrow the gap in ROE.

Question 22

Question

A company has provided the following comparative financial statements for the

years ending December 31, 2019 and 2020. Use this information to analyze the

company’s financial performance and position:

Item 2019 2020

Sales $500,000 $600,000

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

Gross Profit $200,000 $240,000

Operating Expenses $120,000 $140,000

Net Income $80,000 $100,000

Based on the provided information, analyze the company’s financial perfor-

mance and position from 2019 to 2020.

Solution

Step 1: Calculate the percentage increase in sales from 2019 to 2020.

600,000 −500,000

500,000 ×100% = 20%

The sales increased by 20

Step 2: Calculate the percentage increase in cost of goods sold (COGS) from

2019 to 2020. 360,000 −300,000

300,000 ×100% = 20%

The cost of goods sold increased by 20

Step 3: Analyze the gross profit margin from 2019 to 2020.

Gross Profit Margin = Gross Profit

Sales ×100%

For 2019: 200,000

500,000 ×100% = 40%

For 2020: 240,000

600,000 ×100% = 40%

The gross profit margin remained constant at 40

Step 4: Calculate the percentage increase in operating expenses from 2019

to 2020. 140,000 −120,000

120,000 ×100% = 16.67%

The operating expenses increased by 16.67

Step 5: Analyze the net income margin from 2019 to 2020.

Net Income Margin = Net Income

Sales ×100%

For 2019: 80,000

500,000 ×100% ≈16%

For 2020: 100,000

600,000 ×100% ≈16.67%

The net income margin increased slightly from approximately 16

In conclusion, the company experienced a 20

Question 23

Question

The financial statements of Company A and Company B are given below:

Company A

2020 2021

Sales

500,000

600,000

Cost of Goods Sold

250,000

300,000

Gross Profit

250,000

300,000

Operating Expenses

100,000

120,000

Net Income

150,000

180,000

Company B

2020 2021

Sales

700,000

800,000

Cost of Goods Sold

350,000

400,000

Gross Profit

350,000

400,000

Operating Expenses

150,000

180,000

Net Income

200,000

220,000

Assuming that both companies are in the same industry, compare the finan-

cial performance of Company A and Company B for the years 2020 and 2021.

Evaluate which company showed stronger performance over the two years.

Solution

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

B for 2020 and 2021.

Gross Profit Margin is calculated as:

Gross Profit Margin = Gross Profit

Sales ×100%

For 2020:

For Company A:

Gross Profit Margin = 250,000

500,000×100% = 50%

For Company B:

Gross Profit Margin = 350,000

700,000×100% = 50%

For 2021:

For Company A:

Gross Profit Margin = 300,000

600,000×100% = 50%

For Company B:

Gross Profit Margin = 400,000

800,000×100% = 50%

Step 2: Compare the Gross Profit Margin trends for both compa-

nies.

Both Company A and Company B maintained a consistent Gross Profit

Margin of 50

Step 3: Calculate Net Income Margin for Company A and Com-

pany B for 2020 and 2021.

Net Income Margin is calculated as:

Net Income Margin = Net Income

Sales ×100%

For 2020:

For Company A:

Net Income Margin = 150,000

500,000×100% = 30%

For Company B:

Net Income Margin = 200,000

700,000×100% ≈28.57%

For 2021:

For Company A:

Net Income Margin = 180,000

600,000×100% = 30%

For Company B:

Net Income Margin = 220,000

800,000×100% = 27.5%

Step 4: Compare the Net Income Margin trends for both compa-

nies.

Company A was able to maintain a Net Income Margin of 30

Question 24

Question

The financial statements of Company XYZ for the years 2019 and 2020 are given

below. Use comparative financial statement analysis to analyze the company’s

performance over the two years:

Income Statement

2019 2020

Revenue

500,000

600,000

Cost of Goods Sold

300,000

350,000

Gross Profit

200,000

250,000

Operating Expenses

120,000

140,000

Net Income

80,000

110,000

Balance Sheet

2019 2020

Assets

Cash

50,000

60,000

Accounts Receivable

70,000

80,000

Inventory

30,000

35,000

Total Assets

150,000

175,000

Liabilities

Accounts Payable

25,000

30,000

Total Liabilities

25,000

30,000

Equity

Common Stock

50,000

Retained Earnings

75,000

95,000

Total Equity

125,000

145,000

Solution

Step 1: Calculate the percentage change in revenue

The percentage change in revenue can be calculated using the formula:

Percentage Change = New Value −Old Value

Old Value ×100

For Company XYZ:

Percentage Change in Revenue = 600,000 −500,000

500,000 ×100 = 20%

Step 2: Analyze the gross profit margin

The gross profit margin can be calculated using the formula:

Gross Profit Margin = Gross Profit

Revenue ×100

For Company XYZ:

Gross Profit Margin (2019) = 200,000

500,000×100 = 40%

Gross Profit Margin (2020) = 250,000

600,000×100 ≈41.67%

The gross profit margin has increased slightly from 2019 to 2020.

Step 3: Evaluate the change in net income

The change in net income can be calculated by subtracting the net income

of the previous year from the net income of the current year.

110,000 −80,000 = 30,000

The net income has increased by

30,000 from 2019 to 2020.

Step 4: Assess the change in total assets

The percentage change in total assets can be calculated using the formula

mentioned in Step 1.

Percentage Change in Total Assets = 175,000 −150,000

150,000 ×100 ≈16.67%

Company XYZ’s total assets have increased by approximately 16.67% from

2019 to 2020.

Step 5: Examine the change in total equity

The percentage change in total equity can be calculated using the formula

mentioned in Step 1.

Percentage Change in Total Equity = 145,000 −125,000

125,000 ×100 = 16%

Company XYZ’s total equity has increased by 16% from 2019 to 2020.

Question 25

Question

Company XYZ and Company ABC are two similar companies in the same in-

dustry. You are provided with the following financial information for both com-

panies:

Company XYZ: - Net Income: 350,000 −T otalAssets :2,500,000 - Total

Liabilities: 800,000 −T otalEquity :1,700,000

Company ABC: - Net Income: 420,000 −T otalAssets :3,000,000 - Total

Liabilities: 1,200,000 −T otalEquity :1,800,000

Based on the provided information, compare the financial performance and

financial position of Company XYZ and Company ABC. Provide a detailed

analysis highlighting the strengths and weaknesses of each company.

Solution

To compare the financial performance and financial position of Company XYZ

and Company ABC, we will analyze various financial ratios and metrics.

Financial Performance Analysis:



Return on Assets (ROA):

Company XYZ:

ROA =NetIncomeXY Z

T otalAssetsXY Z

=350,000

2,500,000 = 0.14 or 14%

Company ABC:

ROA =NetIncomeABC

T otalAssetsABC

=420,000

3,000,000 = 0.14 or 14%

Both companies have the same Return on Assets at 14



Return on Equity (ROE):

Company XYZ:

ROE =NetIncomeXY Z

T otalEquityXY Z

=350,000

1,700,000 ≈0.206 or 20.6%

Company ABC:

ROE =NetIncomeABC

T otalEquityABC

=420,000

1,800,000 = 0.233 or 23.3%

Company ABC has a higher Return on Equity compared to Company

XYZ, indicating that ABC generates more income with each dollar of

shareholder equity.

Financial Position Analysis:



Debt to Equity Ratio:

Company XYZ:

Debt to Equity Ratio =T otalLiabilitiesXY Z

T otalEquityXY Z

=800,000

1,700,000 ≈0.471

Company ABC:

Debt to Equity Ratio =T otalLiabilitiesABC

T otalEquityABC

=1,200,000

1,800,000 ≈0.667

Company XYZ has a lower Debt to Equity ratio compared to Company

ABC, indicating that XYZ is less leveraged and has a stronger financial

position in terms of debt.

Summary: - Both companies have the same Return on Assets, but Com-

pany ABC has a higher Return on Equity. - Company XYZ has a lower Debt

to Equity ratio, indicating a stronger financial position in terms of debt.

In conclusion, Company ABC outperforms Company XYZ in terms of Re-

turn on Equity, but Company XYZ has a stronger financial position with lower

leverage ratio.

Question 26

Question

Company A and Company B are both in the retail industry. The following are

selected financial data for the two companies for the current year:

Company A - Net Sales:

500,000 - Cost of Goods Sold:

300,000 - Gross

Profit:

200,000 - Operating Expenses:

80,000 - Net Income:

90,000

Company B - Net Sales:

600,000 - Cost of Goods Sold:

360,000 - Gross

Profit:

240,000 - Operating Expenses:

100,000 - Net Income:

110,000

Compare the two companies based on gross profit margin, operating profit

margin, and net profit margin.

Solution

Step 1: Calculate the gross profit margin for both companies: - Gross Profit

Margin = Gross Profit

Net Sales ×100%

For Company A: - Gross Profit Margin = 200,000

500,000 ×100% = 40%

For Company B: - Gross Profit Margin = 240,000

600,000 ×100% = 40%

Step 2: Calculate the operating profit margin for both companies: - Oper-

ating Profit Margin = Operating Income

Net Sales ×100%

For Company A: - Operating Profit Margin = 90,000

500,000 ×100% = 18%

For Company B: - Operating Profit Margin = 110,000

600,000 ×100% = 18.33%

Step 3: Calculate the net profit margin for both companies: - Net Profit

Margin = Net Income

Net Sales ×100%

For Company A: - Net Profit Margin = 90,000

500,000 ×100% = 18%

For Company B: - Net Profit Margin = 110,000

600,000 ×100% = 18.33%

Based on the calculations, both companies have the same gross profit mar-

gin of 40%. However, Company B has slightly higher operating profit margin

(18.33% compared to 18%) and net profit margin (18.33% compared to 18%)

than Company A.

Question 27

Question

The comparative financial statements of Company XYZ for the years 2020 and

2021 are given below:

Item 2020 2021

Total Assets $500,000 $650,000

Total Liabilities $200,000 $300,000

Total Equity ? ?

Net Income $50,000 $70,000

Calculate the Total Equity for both 2020 and 2021 based on the given infor-

mation.

Solution

Step 1: Calculate Total Equity for 2020 using the formula:

Total Equity = Total Assets −Total Liabilities

Total Equity2020 = $500,000 −$200,000 = $300,000

Step 2: Calculate Total Equity for 2021 using the same formula:

Total Equity2021 = $650,000 −$300,000 = $350,000

Therefore, the Total Equity for Company XYZ in 2020 was

300,000 and in

2021 was

350,000.

Question 28

Question

Company XYZ provided the following financial information for the years 2019

and 2020:

Financial Item 2019 2020

Revenue $500,000 $600,000

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

Gross Profit $300,000 $350,000

Calculate the gross profit margin for Company XYZ in 2019 and 2020. In-

terpret the results and explain any trend you observe.

Solution

Step 1: Calculate the Gross Profit Margin for 2019.

Step 2: Calculate the Gross Profit Margin for 2020.

Step 3: Interpretation and Trend Analysis - The gross profit margin for Com-

pany XYZ decreased from 60- This indicates that the company’s profitability

relative to its revenue decreased slightly in 2020 compared to 2019. - Further in-

vestigation may be needed to determine the factors contributing to this decrease

in gross profit margin.

Question 29

Question

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

You are given the following information from their financial statements for the

year ending December 31, 20X1:

Company A Company B

Revenue

500,000

600,000

Cost of Goods Sold

300,000

360,000

Operating Expenses

120,000

100,000

Interest Expense

10,000

15,000

Income Tax Expense

15,000

18,000

Total Assets

700,000

800,000

Total Liabilities

400,000

350,000

Shareholders’ Equity

300,000

450,000

Calculate and compare the following financial ratios for Company A and

Company B: 1. Gross Profit Margin 2. Net Profit Margin 3. Return on Assets

(ROA) 4. Return on Equity (ROE)

Solution

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

Gross Profit Margin = Revenue −Cost of Goods Sold

Revenue ×100%

For Company A:

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

500,000 ×100% = 40%

For Company B:

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

600,000 ×100% = 40%

Step 2: Calculate the Net Profit Margin for Company A and Company B.

Net Profit Margin = Revenue - Cost of Goods Sold - Operating Expenses - Interest Expense - Income Tax Expense

Revenue ×100%

For Company A:

Net Profit Margin (Company A) = 500,000 −300,000 −120,000 −10,000 −15,000

500,000 ×100% = 11%

For Company B:

Net Profit Margin (Company B) = 600,000 −360,000 −100,000 −15,000 −18,000

600,000 ×100% = 4.5%

Step 3: Calculate the Return on Assets (ROA) for Company A and Company

ROA = Net Income

Total Assets×100%

For Company A:

ROA (Company A) = 500,000 −300,000 −120,000 −10,000 −15,000

700,000 ×100% = 4.29%

For Company B:

ROA (Company B) = 600,000 −360,000 −100,000 −15,000 −18,000

800,000 ×100% = 4.13%

Step 4: Calculate the Return on Equity (ROE) for Company A and Company

ROE = Net Income

Shareholders’ Equity×100%

For Company A:

ROE (Company A) = 500,000 −300,000 −120,000 −10,000 −15,000

300,000 ×100% = 16.67%

For Company B:

ROE (Company B) = 600,000 −360,000 −100,000 −15,000 −18,000

450,000 ×100% = 14.44%

Question 30

Question

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

provided below. Analyze the financial statements and compare the financial

performance of the two companies.

Company A

Item Amount Percentage

Revenue

500,000 -

Cost of Goods Sold

200,000 -

Gross Profit

300,000 -

Operating Expenses

150,000 -

Net Income

150,000 -

Company B

Item Amount Percentage

Revenue

800,000 -

Cost of Goods Sold

320,000 -

Gross Profit

480,000 -

Operating Expenses

250,000 -

Net Income

230,000 -

Solution

Step 1: Calculate Percentages To compare the financial performance of the

two companies, we need to calculate the percentage of each item relative to

revenue for both Company A and Company B.

Company A

Item Amount Percentage

Revenue

500,000 100%

Cost of Goods Sold

200,000 40%

Gross Profit

300,000 60%

Operating Expenses

150,000 30%

Net Income

150,000 30%

Company B

Item Amount Percentage

Revenue

800,000 100%

Cost of Goods Sold

320,000 40%

Gross Profit

480,000 60%

Operating Expenses

250,000 31.25%

Net Income

230,000 28.75%

Step 2: Analysis From the analysis, we can see that Company B has higher

revenue, higher gross profit margin, higher net income margin, but also higher

operating expenses as a percentage of revenue compared to Company A. This

indicates that Company B is more profitable but also potentially less efficient

in managing its operating expenses.

Question 31

Question

Company A and Company B are both in the same industry. Company A re-

ported a net profit margin of 10

Solution

To analyze the difference in net profit margins between Company A and Com-

pany B, we can break down the components that contribute to the net profit

margin.

Step 1: Calculate the Gross Profit Margin The gross profit margin is

calculated as:

Gross Profit Margin = Gross Profit

Revenue ×100%

Step 2: Discuss the Gross Profit Margin Difference Since Company A

has a higher gross profit margin than Company B, this indicates that Company

A is more efficient in controlling its production costs and generating revenue.

Step 3: Analyze Operating Expenses Operating expenses include sell-

ing, general, and administrative expenses that a company incurs to run its op-

erations. If Company A has higher operating expenses compared to Company

B, this could be a reason for the lower net profit margin despite having a higher

gross profit margin.

Step 4: Discuss Possible Reasons for Operating Expense Differ-

ence Possible reasons for Company A having higher operating expenses than

Company B could include higher marketing expenses, research and development

costs, labor costs, or other overhead expenses. These higher expenses can eat

into the gross profit, leading to a lower net profit margin.

Step 5: Summarize the Difference in Net Profit Margin In summary,

the difference in net profit margins between Company A and Company B can be

attributed to Company A’s higher operating expenses despite having a higher

gross profit margin. This highlights the importance of managing operating costs

effectively to improve overall profitability.

Question 32

Question

Company X and Company Y are two competitors in the retail industry. The

following information is extracted from their income statements:

Item Company X Company Y

Sales $500,000 $750,000

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

Gross Profit $200,000 $300,000

Operating Expenses $100,000 $120,000

Net Income $100,000 $180,000

Compare Company X and Company Y in terms of profitability based on the

given information.

Solution

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



Company X: Gross Profit Margin = Gross Profit

Sales =200,000

500,000 = 0.4 or 40%.



Company Y: Gross Profit Margin = 300,000

750,000 = 0.4 or 40%.

Step 2: Compare the gross profit margin of both companies. Both companies

have the same gross profit margin of 40%. This implies that both companies

are equally efficient in managing their cost of goods sold relative to their sales.

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



Company X: Net Profit Margin = Net Income

Sales =100,000

500,000 = 0.2 or 20%.



Company Y: Net Profit Margin = 180,000

750,000 = 0.24 or 24%.

Step 4: Compare the net profit margin of both companies. Company Y has a

higher net profit margin of 24% compared to Company X’s net profit margin of

20%. This indicates that Company Y is more efficient in managing its operating

expenses and generating profit compared to Company X.

Question 33

Question

The following information is extracted from the financial statements of two

companies, A and B:

Company A - Net Income:

300,000 - Total Assets:

2,500,000 - Total

Liabilities:

1,000,000

Company B - Net Income:

400,000 - Total Assets:

3,000,000 - Total

Liabilities:

1,200,000

Compare the Return on Assets (ROA) for both companies and discuss which

company is more efficient in generating profit relative to their assets.

Solution

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

formula:

ROA =Net Income

T otal Assets

For Company A:

ROAA=300,000

2,500,000 = 0.12 or 12%

For Company B:

ROAB=400,000

3,000,000 = 0.1333 or 13.33%

Step 2: Compare the ROA for both companies.

Company A has an ROA of 12

Question 34

Question

Company XYZ has provided the following financial information for the years

2019 and 2020:

Item 2019 2020

Revenue

500,000

600,000

Cost of Goods Sold

250,000

320,000

Gross Profit

250,000

280,000

Operating Expenses

100,000

120,000

Net Income

150,000

160,000

Using the data provided, perform a comparative financial statement analysis

for Company XYZ.

Solution

Step 1: Calculate the gross profit margin for each year The gross profit

margin is calculated using the formula:

Gross Profit Margin = Gross Profit

Revenue ×100%

For 2019:

Gross Profit Margin (2019) = 250,000

500,000 ×100% = 50%

For 2020:

Gross Profit Margin (2020) = 280,000

600,000 ×100% = 46.67%

Step 2: Calculate the operating profit margin for each year The

operating profit margin is calculated using the formula:

Operating Profit Margin = Operating Income

Revenue ×100%

For 2019:

Operating Profit Margin (2019) = 150,000

500,000 ×100% = 30%

For 2020:

Operating Profit Margin (2020) = 160,000

600,000 ×100% = 26.67%

Step 3: Analyze the results From the calculations, we can see that the

gross profit margin decreased from 2019 to 2020, indicating that the company’s

cost of goods sold increased relative to revenue. Similarly, the operating profit

margin also decreased from 2019 to 2020, suggesting that the company’s oper-

ating expenses increased relative to revenue. Though the net income increased

from 2019 to 2020, the decreasing profit margins indicate potential challenges

in the company’s profitability.

Question 35

Question

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

2020:

Item 2019 2020

Sales Revenue $500,000 $600,000

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

Operating Expenses $100,000 $120,000

Net Income $50,000 $60,000

Calculate the following ratios for Company XYZ for the years 2019 and 2020:

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

Solution

Step 1: Calculate Gross Profit Margin

Gross Profit Margin is calculated using the formula:

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

Sales 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) = $600,000 −$250,000

$600,000 ×100%

=$350,000

$600,000×100% = 58.33%

Step 2: Calculate Operating Profit Margin

Operating Profit Margin is calculated using the formula:

Operating Profit Margin = Operating Income

Sales Revenue ×100%

In this case, Operating Income can be calculated as:

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

For 2019:

Operating Income (2019) = $500,000 −$200,000 −$100,000 = $200,000

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

$500,000×100% = 40%

Similarly, for 2020:

Operating Income (2020) = $600,000 −$250,000 −$120,000 = $230,000

Operating Profit Margin (2020) = $230,000

$600,000×100% ≈38.33%

Step 3: Calculate Net Profit Margin