ACCT 302 - INTERMEDIATE
ACCOUNTING II - Comparative
financial statement analysis
Question Bank - Set 5
Liberty University
Question 1
Question
Assume you are analyzing two companies, Company A and Company B, using
their financial statements. Company A has a higher net income than Company
B, but Company B has a higher return on equity (ROE) than Company A. Ex-
plain how this can happen and discuss what this indicates about the companies’
financial performance.
Solution
Step 1: Net Income and Return on Equity - Net Income: Net income is a measure
of a company’s profitability and is calculated by subtracting total expenses from
total revenues. - Return on Equity (ROE): ROE is a measure of how effectively
a company is using its shareholders’ equity to generate profits. It is calculated
by dividing net income by average shareholders’ equity.
Step 2: Reasons for the Discrepancy - Company A has a higher net income
than Company B, which traditionally indicates higher profits for Company A.
- However, Company B has a higher return on equity than Company A, which
means that Company B generates a higher profit relative to its shareholders’
equity. - This discrepancy can happen if Company B has a lower amount of
shareholders’ equity compared to Company A. This would result in a higher
ROE for Company B even with a lower net income.
Step 3: Financial Performance Implications - A higher net income for Com-
pany A indicates that it is making more profits overall compared to Company
B. - On the other hand, the higher ROE for Company B suggests that it is
more efficient in generating profits using the equity invested by shareholders. -
This could mean that Company B is more adept at generating a higher return
for shareholders’ equity, which could be appealing to investors. However, it is
important to consider the overall financial health and growth potential of both
companies when making investment decisions.
Question 2
Question
A company reported the following financial information for Year 2 and Year 1:
Ratio Year 2 Year 1
Profit Margin 15% 10%
Return on Assets 12% 8%
Current Ratio 2.5 2.0
Debt-to-Equity Ratio 0.6 0.5
Based on the information provided, analyze the company’s financial perfor-
mance in Year 2 compared to Year 1.
Solution
Step 1: Interpretation of Ratios
Profit Margin: This ratio indicates the percentage of each dollar of sales
that results in profit. An increase in profit margin indicates improved
efficiency in managing expenses and costs.
Return on Assets (ROA): This ratio shows how efficiently a company
is using its assets to generate profit. An increase in ROA indicates better
asset utilization.
Current Ratio: This ratio measures the company’s ability to cover short-
term liabilities with its short-term assets. An increase in current ratio
indicates improved liquidity.
Debt-to-Equity Ratio: This ratio assesses the company’s leverage and
risk exposure. An increase in the debt-to-equity ratio may signify higher
financial risk.
Step 2: Analysis of Financial Performance
Profit Margin: The profit margin increased from 10% in Year 1 to 15% in
Year 2, indicating that the company managed its expenses more effectively
in Year 2, resulting in higher profitability.
Return on Assets: The ROA increased from 8% in Year 1 to 12% in
Year 2, showing that the company generated more profit for each dollar
of assets employed in Year 2.
2
Current Ratio: The current ratio improved from 2.0 in Year 1 to 2.5 in
Year 2, suggesting that the company’s liquidity position strengthened in
Year 2.
Debt-to-Equity Ratio: The debt-to-equity ratio increased from 0.5 in
Year 1 to 0.6 in Year 2, indicating that the company relied more on debt
financing in Year 2, which may increase financial risk.
Step 3: Conclusion Overall, the company’s financial performance im-
proved in Year 2 compared to Year 1. The increase in profit margin, return on
assets, and current ratio reflects better efficiency, asset utilization, and liquidity.
However, the rise in the debt-to-equity ratio signals increased financial risk due
to higher reliance on debt financing in Year 2.
Question 3
Question
The following information is extracted from the financial statements of two
companies, A and B, for the year ended 31 December.
Item Company A Company B
Revenue
$
500,000
$
750,000
Cost of Goods Sold
$
200,000
$
300,000
Gross Profit
$
300,000
$
450,000
Operating Expenses
$
150,000
$
200,000
Interest Expense
$
20,000
$
30,000
Net Income
$
130,000
$
220,000
Assuming all other factors remain constant, which company is more prof-
itable and why?
Solution
Step 1: Calculate the Gross Profit Margin for both companies. The Gross Profit
Margin is calculated using the formula:
Gross Profit Margin = Gross Profit
Revenue ×100%
For Company A:
Gross Profit Margin (A) = 300,000
500,000 ×100% = 60%
For Company B:
Gross Profit Margin (B) = 450,000
750,000 ×100% = 60%
3
Step 2: Compare the Gross Profit Margin. Both Company A and Company
B have the same Gross Profit Margin of 60%. This means that they both
generate the same percentage of profit from their revenue after accounting for
the cost of goods sold.
Step 3: Calculate the Net Profit Margin for both companies. The Net Profit
Margin is calculated using the formula:
Net Profit Margin = Net Income
Revenue ×100%
For Company A:
Net Profit Margin (A) = 130,000
500,000 ×100% = 26%
For Company B:
Net Profit Margin (B) = 220,000
750,000 ×100% = 29.33%
Step 4: Compare the Net Profit Margin. Company B has a higher Net Profit
Margin (29.33%) compared to Company A (26
Question 4
Question
Company X and Company Y are two competitors in the same industry. You
are given the following information from their income statements for the year
20X1:
Item Company X Company Y
Revenue
$
500,000
$
600,000
Cost of Goods Sold
$
300,000
$
350,000
Gross Profit
$
200,000
$
250,000
Operating Expenses
$
100,000
$
120,000
Net Income
$
80,000
$
100,000
Assuming all other factors are equal, which company would you consider
to be in a better financial position based on the information provided above?
Justify your answer with a comparative financial statement analysis.
Solution
Step 1: Calculating Profit Margin for Company X and Company Y
Profit Margin = Net Income
Revenue ×100%
4
For Company X:
Profit Margin (X) = 80,000
500,000 ×100% = 16%
For Company Y:
Profit Margin (Y) = 100,000
600,000 ×100% ≈16.67%
Step 2: Analyzing Profit Margin Company Y has a higher profit margin
(16.67%) compared to Company X (16%). This indicates that Company Y is
more efficient in generating profits for every dollar of revenue earned.
Step 3: Comparing Gross Profit Margin
Gross Profit Margin = Gross Profit
Revenue ×100%
For Company X:
Gross Profit Margin (X) = 200,000
500,000 ×100% = 40%
For Company Y:
Gross Profit Margin (Y) = 250,000
600,000 ×100% ≈41.67%
Step 4: Analyzing Gross Profit Margin Company Y has a higher gross profit
margin (41.67%) compared to Company X (40%). This indicates that Company
Y is better at controlling the cost of goods sold and generating higher profits
from its core business activities.
In conclusion, based on the profit margin and gross profit margin analysis,
Company Y appears to be in a better financial position compared to Company
X.
Question 5
Question
Suppose you are analyzing two companies, Company A and Company B, using
their financial statements. You observe that Company A has a higher net profit
margin than Company B. However, Company B has a higher return on assets
(ROA) than Company A. Explain how this discrepancy could occur and what
it may indicate about the financial health of the two companies.
5
Solution
Step 1: The net profit margin is calculated as the ratio of net income to total
revenue, while the return on assets (ROA) is calculated as the ratio of net
income to total assets. Let’s denote the net profit margin as NP M and the
return on assets as ROA. Step 2: Let’s assume that Company A has a higher
net profit margin (NP MA> N P MB) but Company B has a higher return
on assets (ROAB> ROAA). Step 3: Company A having a higher net profit
margin could indicate that it is more efficient in managing its expenses relative
to its revenue, resulting in higher profitability per dollar of sales compared to
Company B. Step 4: On the other hand, Company B having a higher return on
assets could indicate that it is generating more profit from its assets compared
to Company A. This may suggest that Company B is more effective in utilizing
its assets to generate income. Step 5: The discrepancy between the higher
net profit margin of Company A and the higher return on assets of Company
B could be due to differences in their asset bases. Company B may have a
more efficient asset utilization strategy, resulting in higher profitability despite
a lower net profit margin. Step 6: In terms of financial health, while a higher net
profit margin for Company A may seem favorable, a higher return on assets for
Company B indicates better efficiency in generating profit from assets. It could
imply that Company B is using its resources more effectively to generate income
and potentially create more value for its shareholders. Step 7: Ultimately,
a comprehensive analysis of both companies’ financial statements, along with
other relevant factors such as industry trends and market conditions, would
be necessary to draw definitive conclusions about their financial health and
performance.
Question 6
Question
Company A and Company B are two similar companies operating in the same
industry. The following are selected financial data for both companies from the
past three years:
Company A: - Year 1 Sales:
$
500,000 - Year 2 Sales:
$
550,000 - Year 3
Sales:
$
600,000
Company B: - Year 1 Sales:
$
400,000 - Year 2 Sales:
$
600,000 - Year 3
Sales:
$
800,000
Which company has shown a more consistent growth rate in sales over the
past three years? Justify your answer with appropriate calculations and expla-
nations.
Solution
Step 1: Calculate the year-over-year growth rate for each company.
6
Company A:
–Year 1 to Year 2 Growth Rate:
550,000 −500,000
500,000 ×100% = 10%
–Year 2 to Year 3 Growth Rate:
600,000 −550,000
550,000 ×100% ≈9.09%
Company B:
–Year 1 to Year 2 Growth Rate:
600,000 −400,000
400,000 ×100% = 50%
–Year 2 to Year 3 Growth Rate:
800,000 −600,000
600,000 ×100% ≈33.33%
Step 2: Analyze the growth rates. - Company A has shown a consistent but
slower growth rate, averaging around 9.55% per year. - Company B has shown
a higher but more volatile growth rate, averaging around 41.67% per year.
Step 3: Conclusion - Company A has demonstrated a more consistent growth
rate in sales over the past three years compared to Company B. Although Com-
pany B had higher growth rates, they were more erratic, indicating potential
fluctuations in performance.
Question 7
Question
Company A and Company B are both in the same industry. The following
information is extracted from their financial statements:
Ratio Company A Company B
Current Ratio 2.5 1.8
Quick Ratio 1.4 1.2
Debt-to-Equity Ratio 1.2 1.5
Based on the information provided, which company appears to be more
financially stable? Justify your answer with reference to the ratios.
7
Solution
To determine which company is more financially stable, we will analyze the
provided ratios for both Company A and Company B.
Step 1: Current Ratio Analysis The current ratio measures a company’s
ability to pay its short-term liabilities with its short-term assets. A higher
current ratio indicates better liquidity.
For Company A: Current Ratio = 2.5
For Company B: Current Ratio = 1.8
Company A has a higher current ratio, indicating better short-term liquidity
compared to Company B.
Step 2: Quick Ratio Analysis The quick ratio (acid-test ratio) is a mea-
sure of a company’s ability to pay off its current liabilities without relying on
the sale of inventory. A higher quick ratio is desirable.
For Company A: Quick Ratio = 1.4
For Company B: Quick Ratio = 1.2
Company A has a higher quick ratio, reflecting a better ability to cover its
short-term obligations using more liquid assets.
Step 3: Debt-to-Equity Ratio Analysis The debt-to-equity ratio mea-
sures a company’s financial leverage, indicating how much of its operations are
financed by debt versus equity. A lower debt-to-equity ratio is favorable.
For Company A: Debt-to-Equity Ratio = 1.2
For Company B: Debt-to-Equity Ratio = 1.5
Company A has a lower debt-to-equity ratio, suggesting less reliance on debt
financing compared to Company B.
Conclusion: Based on the analysis of the current ratio, quick ratio, and
debt-to-equity ratio, Company A appears to be more financially stable than
Company B. Company A has higher liquidity ratios and a lower debt-to-equity
ratio, indicating stronger financial health and stability.
Question 8
Question
The following data was extracted from the financial statements of Company
XYZ for the years ending December 31, 20X1 and 20X2:
Item 20X1 20X2
Total Assets $500,000 $600,000
Total Liabilities $200,000 $250,000
Net Income $50,000 $60,000
Dividends Declared $10,000 $15,000
Assuming all other factors remain constant, analyze the financial perfor-
mance and position of Company XYZ from 20X1 to 20X2.
8
Solution
Step 1: Calculate the following ratios for both years:
Debt-to-Asset Ratio = Total Liabilities / Total Assets
Return on Assets (ROA) = Net Income / Total Assets
Dividend Payout Ratio = Dividends Declared / Net Income
For 20X1:
Debt-to-Asset Ratio = $200,000
$500,000 = 0.4
ROA = $50,000
$500,000 = 0.1
Dividend Payout Ratio = $10,000
$50,000 = 0.2
For 20X2:
Debt-to-Asset Ratio = $250,000
$600,000 ≈0.417
ROA = $60,000
$600,000 = 0.1
Dividend Payout Ratio = $15,000
$60,000 = 0.25
Step 2: Analyze the ratios calculated in Step 1:
Debt-to-Asset Ratio increased from 0.4 to approximately 0.417, indicating
that the company took on more debt relative to its assets in 20X2.
ROA remained constant at 0.1, suggesting that the company maintained
its ability to generate profit from its assets.
Dividend Payout Ratio increased from 0.2 to 0.25, signifying that the
company distributed a larger portion of its profits as dividends in 20X2.
Step 3: Overall, Company XYZ increased its debt levels, maintained its prof-
itability, and increased its dividend payout percentage from 20X1 to 20X2. This
indicates a mixed performance in terms of financial position and performance
over the two years.
Question 9
Question
Company XYZ and Company ABC are both in the same industry. The com-
parative financial statements for the two companies are given below:
Company XYZ
9
2020 2021
Revenue
$
500,000
$
550,000
Expenses
$
350,000
$
400,000
Net Income
$
150,000
$
150,000
Company ABC
2020 2021
Revenue
$
700,000
$
800,000
Expenses
$
500,000
$
600,000
Net Income
$
200,000
$
200,000
Based on the information provided, which company do you think is perform-
ing better financially over the two-year period and why?
Solution
Step 1: Calculate the percentage increase in revenue and expenses for each
company from 2020 to 2021.
For Company XYZ: - Percentage increase in revenue = 550,000−500,000
500,000 ×
100% = 10% - Percentage increase in expenses = 400,000−350,000
350,000 ×100% =
14.29%
For Company ABC: - Percentage increase in revenue = 800,000−700,000
700,000 ×
100% = 14.29% - Percentage increase in expenses = 600,000−500,000
500,000 ×100% =
20%
Step 2: Analyze the performance of each company based on the percentage
changes.
- Company XYZ had a 10- Company ABC had a 14.29
Step 3: Compare the net income performance of both companies.
- Company XYZ maintained its net income at
$
150,000 from 2020 to 2021.
- Company ABC also maintained its net income at
$
200,000 from 2020 to 2021.
Step 4: Conclusion
Based on the analysis, Company ABC performed better financially over the
two-year period because it achieved a higher percentage increase in revenue
compared to Company XYZ. Despite a higher increase in expenses, Company
ABC was able to maintain its net income at a higher level than Company XYZ.
Question 10
Question
Company A and Company B are two competing firms in the same industry.
You are provided with the financial statements of both companies for the year
ending December 31, 2021. Analyze the comparative financial performance of
both companies using the following information:
10
Company A’s net income in 2021 was
$
500,000, while Company B’s net
income was
$
600,000.
Company A’s total assets at the end of 2021 were
$
3,000,000, while Com-
pany B’s total assets were
$
4,000,000.
Company A’s total revenue in 2021 was
$
1,000,000, while Company B’s
total revenue was
$
1,200,000.
Company A’s cost of goods sold in 2021 was
$
400,000, while Company B’s
cost of goods sold was
$
450,000.
Based on this information, evaluate and compare the profitability, asset uti-
lization, and efficiency of both companies.
Solution
Step 1: Calculate Profitability Ratios
Company A:
–Profit Margin = NetIncome
T otalRevenue
–Profit Margin = 500,000
1,000,000 = 0.50 or 50%
Company B:
–Profit Margin = NetIncome
T otalRevenue
–Profit Margin = 600,000
1,200,000 = 0.50 or 50%
Both companies have the same profit margin of 50%.
Step 2: Calculate Asset Utilization Ratios
Company A:
–Asset Turnover = T otalRevenue
AverageT otalAssets
–Average Total Assets = BeginningT otalAssets+EndingT otalAssets
2
–Average Total Assets = 3,000,000+3,000,000
2= 3,000,000
–Asset Turnover = 1,000,000
3,000,000 = 0.33
Company B:
–Asset Turnover = T otalRevenue
AverageT otalAssets
–Average Total Assets = BeginningT otalAssets+EndingT otalAssets
2
–Average Total Assets = 4,000,000+4,000,000
2= 4,000,000
–Asset Turnover = 1,200,000
4,000,000 = 0.30
11
Company A has a higher asset turnover of 0.33 compared to Company B’s
0.30.
Step 3: Evaluate Efficiency
By looking at the cost of goods sold for both companies, we can see that
Company A has a lower cost of goods sold compared to its revenue, indicating
better cost efficiency in managing its expenses compared to Company B.
In conclusion, Company A has a higher asset turnover and is more cost-
efficient compared to Company B, despite both companies having the same
profit margin.
Question 11
Question
The following are selected financial data for two companies, Company A and
Company B, for the year ending December 31, 2021:
Item Company A Company B
Revenue
$
800,000
$
700,000
Net Income
$
120,000
$
90,000
Total Assets
$
600,000
$
500,000
Total Liabilities
$
200,000
$
150,000
Shareholder’s Equity
$
400,000
$
350,000
Calculate the following ratios for both companies and discuss which company
is performing better in terms of profitability, liquidity, and solvency: 1. Profit
Margin 2. Return on Assets 3. Debt-to-Equity Ratio
Solution
1. Profit Margin: The profit margin is calculated as the ratio of net income
to revenue, multiplied by 100%.
Company A:
Profit Margin = $120,000
$800,000×100% = 15%
Company B:
Profit Margin = $90,000
$700,000×100% = 12.86%
Company A has a higher profit margin, indicating better profitability com-
pared to Company B.
2. Return on Assets (ROA): ROA is calculated as the ratio of net income
to total assets, multiplied by 100%.
12
Company A:
ROA = $120,000
$600,000×100% = 20%
Company B:
ROA = $90,000
$500,000×100% = 18%
Company A has a higher return on assets, indicating better efficiency in
generating profit from its assets.
3. Debt-to-Equity Ratio: The debt-to-equity ratio is calculated as the
ratio of total liabilities to shareholder’s equity.
Company A:
Debt-to-Equity Ratio = $200,000
$400,000 = 0.5
Company B:
Debt-to-Equity Ratio = $150,000
$350,000 = 0.43
Company B has a lower debt-to-equity ratio, indicating lower financial risk
compared to Company A.
Question 12
Question
Company ABC and Company XYZ are both in the same industry. The following
financial information is available for both companies:
Company ABC
Net Income:
$
500,000
Total Assets:
$
5,000,000
Total Liabilities:
$
2,000,000
Equity:
$
3,000,000
Company XYZ
Net Income:
$
800,000
Total Assets:
$
8,000,000
Total Liabilities:
$
4,000,000
Equity:
$
4,000,000
Compare the financial performance and financial position of Company ABC
and Company XYZ based on the information provided.
13
Solution
Step 1: Calculate the Return on Assets (ROA) for both companies. ROA is a
measure of how efficiently a company is using its assets to generate profit.
ROA = Net Income
Total Assets
For Company ABC:
ROAABC =500,000
5,000,000 = 0.1 or 10%
For Company XYZ:
ROAXY Z =800,000
8,000,000 = 0.1 or 10%
Both companies have the same Return on Assets of 10%, indicating that
they are equally efficient in generating profit from their assets.
Step 2: Analyze the financial position by calculating the Debt-to-Equity
ratio for both companies. The Debt-to-Equity ratio shows how much debt a
company is using to finance its assets relative to its equity.
Debt-to-Equity ratio = Total Liabilities
Equity
For Company ABC:
Debt-to-Equity ratioABC =2,000,000
3,000,000 =2
3
For Company XYZ:
Debt-to-Equity ratioXY Z =4,000,000
4,000,000 = 1
Company ABC has a Debt-to-Equity ratio of 2
3, while Company XYZ has a
ratio of 1. This means that Company ABC is using less debt financing compared
to equity financing, while Company XYZ is using an equal amount of debt and
equity financing.
In conclusion, both companies have the same Return on Assets, but Com-
pany ABC is less leveraged compared to Company XYZ.
Question 13
Question
Company XYZ and Company ABC are both in the same industry. Company
XYZ reported a net income of
$
500,000, total assets of
$
2,000,000, and total
equity of
$
1,200,000. Company ABC reported a net income of
$
800,000, total
assets of
$
5,000,000, and total equity of
$
3,500,000. Compare the profitabil-
ity and financial leverage of Company XYZ and Company ABC based on the
information provided.
14
Solution
To compare the profitability and financial leverage of Company XYZ and Com-
pany ABC, we will calculate the return on assets (ROA), return on equity
(ROE), debt-to-equity ratio, and the equity multiplier for each company.
Step 1: Calculate ROA for Company XYZ and Company ABC For
Company XYZ:
ROAXYZ =Net IncomeXYZ
Total AssetsXYZ
=500,000
2,000,000 = 0.25 = 25%
For Company ABC:
ROAABC =Net IncomeABC
Total AssetsABC
=800,000
5,000,000 = 0.16 = 16%
Step 2: Calculate ROE for Company XYZ and Company ABC For
Company XYZ:
ROEXYZ =Net IncomeXYZ
Total EquityXYZ
=500,000
1,200,000 ≈0.417 ≈41.7%
For Company ABC:
ROEABC =Net IncomeABC
Total EquityABC
=800,000
3,500,000 ≈0.229 ≈22.9%
Step 3: Calculate Debt-to-Equity Ratio for Company XYZ and
Company ABC For Company XYZ:
Debt-to-Equity RatioXYZ =Total AssetsXYZ −Total EquityXYZ
Total EquityXYZ
=2,000,000 −1,200,000
1,200,000 ≈0.6667 ≈0.67
For Company ABC:
Debt-to-Equity RatioABC =Total AssetsABC −Total EquityABC
Total EquityABC
=5,000,000 −3,500,000
3,500,000 ≈0.4286 ≈0.43
Step 4: Calculate Equity Multiplier for Company XYZ and Com-
pany ABC For Company XYZ:
Equity MultiplierXYZ = 1 + Debt-to-Equity RatioXYZ = 1 + 0.67 = 1.67
For Company ABC:
Equity MultiplierABC = 1 + Debt-to-Equity RatioABC = 1 + 0.43 = 1.43
Therefore, based on the calculations: - Company ABC has a higher ROA
and ROE compared to Company XYZ, indicating better profitability. - Com-
pany XYZ has a higher debt-to-equity ratio and equity multiplier compared to
Company ABC, indicating higher financial leverage.
15
Question 14
Question
Company XYZ has provided its financial statements for the years 2019 and
2020. You are tasked with conducting a comparative analysis of the financial
performance of the company. The following key financial ratios are available:
Ratio 2019 2020
Return on Assets (ROA) 8% 10%
Net Profit Margin 15% 12%
Current Ratio 2.5 3.0
Debt to Equity Ratio 0.6 0.5
Discuss the financial performance of Company XYZ based on the given in-
formation.
Solution
Step 1: Interpretation of Return on Assets (ROA)
Return on Assets (ROA) measures the profitability of a company relative
to its total assets.
The ROA for Company XYZ increased from 8% in 2019 to 10% in 2020,
indicating that the company generated more profit for every dollar of
assets in 2020 compared to 2019. This suggests improved efficiency in
asset utilization.
Step 2: Analyzing Net Profit Margin
Net Profit Margin is a profitability ratio that measures the percentage of
revenue that translates into profit.
Company XYZ’s Net Profit Margin declined from 15% in 2019 to 12% in
2020. This decrease could be a concern as it indicates a lower ability to
convert sales into profit. It would be important to further investigate the
reasons behind this decline.
Step 3: Evaluating Current Ratio
The Current Ratio assesses a company’s ability to cover its short-term
liabilities with its short-term assets.
Company XYZ’s Current Ratio improved from 2.5 in 2019 to 3.0 in 2020.
This indicates that the company’s liquidity position strengthened in 2020,
as it now has more current assets to cover its current liabilities.
Step 4: Understanding Debt to Equity Ratio
16
The Debt to Equity Ratio reflects the proportion of debt and equity used
to finance a company’s assets.
Company XYZ’s Debt to Equity Ratio decreased from 0.6 in 2019 to 0.5
in 2020. A lower ratio signifies less reliance on debt financing relative
to equity. This reduction could indicate improved financial stability and
lower financial risk.
Based on the analysis of the financial ratios, Company XYZ shows improve-
ment in asset efficiency, liquidity, and a reduced reliance on debt financing.
However, the decline in Net Profit Margin warrants further investigation to
understand the reasons behind the decrease in profitability.
Question 15
Question
Company XYZ and Company ABC are two competitors in the retail industry.
Below are their income statements for the year ended December 31, 20X1:
Company XYZ ABC
Revenue
$
500,000
$
600,000
Cost of Goods Sold
$
300,000
$
320,000
Gross Profit
$
200,000
$
280,000
Operating Expenses
$
100,000
$
120,000
Net Income
$
100,000
$
160,000
Assuming all other factors are equal, analyze and compare the profitability
of Company XYZ and Company ABC based on their income statements.
Solution
Step 1: Calculate the gross profit margin for each company. Gross Profit Margin
is calculated as follows:
Gross Profit Margin = Gross Profit
Revenue ×100%
For Company XYZ:
Gross Profit Margin for XYZ = 200,000
500,000 ×100% = 40%
For Company ABC:
Gross Profit Margin for ABC = 280,000
600,000 ×100% = 46.67%
Step 2: Compare the gross profit margins of both companies. - Company
ABC has a higher gross profit margin (46.67%) compared to Company XYZ
17
(40%). - This indicates that Company ABC is better at controlling its produc-
tion costs relative to its revenue.
Step 3: Calculate the net profit margin for each company. Net Profit Margin
is calculated as follows:
Net Profit Margin = Net Income
Revenue ×100%
For Company XYZ:
Net Profit Margin for XYZ = 100,000
500,000 ×100% = 20%
For Company ABC:
Net Profit Margin for ABC = 160,000
600,000 ×100% = 26.67%
Step 4: Compare the net profit margins of both companies. - Company ABC
has a higher net profit margin (26.67%) compared to Company XYZ (20%). -
This suggests that Company ABC is more efficient in managing its operating
expenses relative to its revenue, resulting in higher net income.
In conclusion, based on the income statements provided, Company ABC
appears to be more profitable and efficient in managing its costs compared to
Company XYZ.
Question 16
Question
Assume you are a financial analyst comparing the financial statements of two
companies in the same industry. Company A has a current ratio of 2.5, while
Company B has a current ratio of 1.8. Which company would you consider to
be in a better position to meet its short-term obligations and why?
Solution
To determine which company is in a better position to meet its short-term
obligations, we need to analyze the current ratios of both companies.
Step 1: Calculate the current ratio for each company.
The current ratio is calculated as:
Current Ratio = Current Assets
Current Liabilities
For Company A:
Current Ratio = Current AssetsA
Current LiabilitiesA
= 2.5
18
For Company B:
Current Ratio = Current AssetsB
Current LiabilitiesB
= 1.8
Step 2: Analyze the current ratios.
A higher current ratio indicates a better ability to cover short-term obliga-
tions. Company A’s current ratio of 2.5 is higher than Company B’s current
ratio of 1.8. This means that Company A has more current assets relative to
its current liabilities compared to Company B. Therefore, Company A is in a
better position to meet its short-term obligations as it has more liquidity to
cover its short-term debt.
Conclusion: Based on the current ratio analysis, Company A is in a better
position to meet its short-term obligations compared to Company B.
Question 17
Question
Company XYZ is comparing its financial statements for the years 2020 and
2021. The following information is obtained from the comparative financial
statements:
Item 2020 (
$
) 2021 (
$
)
Total Assets 500,000 600,000
Total Liabilities 200,000 250,000
Net Sales 300,000 320,000
Cost of Goods Sold 150,000 170,000
Net Income 50,000 55,000
Calculate and interpret the following financial ratios for Company XYZ
based on the information provided: 1. Current Ratio for 2020 and 2021. 2.
Gross Profit Margin for 2020 and 2021. 3. Return on Assets (ROA) for 2020
and 2021.
Solution
1. Current Ratio: The current ratio is calculated as:
Current Ratio = Total Assets
Total Liabilities
Step 1: For 2020:
Current Ratio (2020) = 500,000
200,000 = 2.5
Step 2: For 2021:
Current Ratio (2021) = 600,000
250,000 = 2.4
19
2. Gross Profit Margin: The gross profit margin is calculated as:
Gross Profit Margin = 1−Cost of Goods Sold
Net Sales ×100%
Step 1: For 2020:
Gross Profit Margin (2020) = 1−150,000
300,000×100% = 50%
Step 2: For 2021:
Gross Profit Margin (2021) = 1−170,000
320,000×100% ≈46.88%
3. Return on Assets (ROA): The ROA is calculated as:
ROA = Net Income
Total Assets ×100%
Step 1: For 2020:
ROA (2020) = 50,000
500,000 ×100% = 10%
Step 2: For 2021:
ROA (2021) = 55,000
600,000 ×100% ≈9.17%
Question 18
Question
Company A and Company B are two competitors in the same industry. Ana-
lyze the following financial ratios for both companies based on the information
provided:
Ratio Company A Company B
Return on Assets 10% 8%
Net Profit Margin 15% 12%
Current Ratio 2.5 3.0
Debt-to-Equity Ratio 0.8 0.6
Based on this information, which company seems to be more financially
stable and efficient? Justify your answer.
20
Solution
Step 1: Return on Assets (ROA) Analysis
Company A: 10%
Company B: 8%
Company A has a higher ROA compared to Company B, indicating that Com-
pany A is more efficient in generating profit relative to its assets.
Step 2: Net Profit Margin Analysis
Company A: 15%
Company B: 12%
Company A has a higher net profit margin, which means it retains a larger por-
tion of revenue as profit after expenses. This indicates better cost management
by Company A.
Step 3: Current Ratio Analysis
Company A: 2.5
Company B: 3.0
Company B has a higher current ratio, implying a better ability to cover its
short-term liabilities with its current assets.
Step 4: Debt-to-Equity Ratio Analysis
Company A: 0.8
Company B: 0.6
Both companies have relatively low debt-to-equity ratios, but Company B has
a lower ratio indicating that it relies less on debt financing.
Conclusion: Based on the analysis of the financial ratios, Company A
appears to be more financially stable and efficient compared to Company B.
Company A has higher ROA, net profit margin, and lower debt-to-equity ratio.
However, Company B has a better current ratio which signifies better liquidity.
Question 19
Question
Company XYZ and Company ABC are two companies in the same industry.
The following information is taken from their financial statements:
Ratio Company XYZ Company ABC
Current Ratio 2.5 3.0
Quick Ratio 1.5 1.0
Debt to Equity Ratio 0.8 1.2
Net Profit Margin 10% 5%
Return on Assets 6% 8%
21
Based on the above ratios, which company appears to be performing better
in terms of liquidity, leverage, profitability, and efficiency? Justify your answer.
Solution
Step 1: Liquidity Analysis
Company XYZ has a current ratio of 2.5, indicating that it has 2.50of currentassetsforevery1.00
of current liabilities.
Company ABC has a higher current ratio of 3.0, suggesting it has better
short-term liquidity than Company XYZ.
When comparing quick ratios, Company XYZ’s quick ratio of 1.5 is higher
than Company ABC’s quick ratio of 1.0, showing that Company XYZ has
better liquidity in terms of more readily available assets to cover immediate
liabilities.
Step 2: Leverage Analysis
Looking at the Debt to Equity Ratio, Company XYZ has a lower ratio of
0.8 compared to Company ABC’s ratio of 1.2. Thus, Company XYZ is
less leveraged and considered less risky in terms of debt obligations.
Step 3: Profitability Analysis
Company XYZ has a higher Net Profit Margin of 10% compared to Com-
pany ABC’s 5%, indicating that Company XYZ is more efficient at gen-
erating profit from its revenue.
However, when considering Return on Assets, Company ABC has a higher
percentage of 8%, suggesting it is utilizing its assets more effectively to
generate profit compared to Company XYZ.
Based on the analysis: - Company ABC performs better in terms of liquidity
due to higher current and quick ratios. - Company XYZ has better leverage as
it has a lower debt to equity ratio. - Company XYZ is more profitable with
a higher net profit margin, but Company ABC is more efficient at generating
profit based on return on assets.
In summary, while Company ABC has better liquidity, Company XYZ has
better leverage and profitability. It ultimately depends on the specific priori-
ties and strategies of investors or analysts when determining which company is
performing better overall.
Question 20
Question
Company A and Company B are two firms in the same industry. The following
information is extracted from their balance sheets:
22
Item Company A (in
$
) Company B (in
$
)
Total Assets 500,000 750,000
Total Liabilities 300,000 450,000
Total Equity ? 300,000
If Company B has total equity of
$
300,000, what is the total equity for
Company A?
Solution
Step 1: Calculate the total equity for Company A using the formula:
Total Equity = Total Assets −Total Liabilities
Step 2: Substitute the given values to find the total equity for Company A:
Total EquityA= 500,000 −300,000 = 200,000
Therefore, the total equity for Company A is
$
200,000.
Question 21
Question
The following table presents income statement information for two companies,
A and B, for the year ending December 31, 2021:
Item Company A Company B
Revenue $500,000 $400,000
Cost of Goods Sold $200,000 $160,000
Gross Profit $300,000 $240,000
Operating Expenses $150,000 $120,000
Net Income $150,000 $120,000
Assuming both companies have the same amount of shares outstanding,
calculate the earnings per share (EPS) for each company.
Solution
Step 1: Calculate Earnings Per Share (EPS) for Company A
EPSA=Net IncomeA
Shares Outstanding
=$150,000
Shares Outstanding
23
Step 2: Calculate Earnings Per Share (EPS) for Company B
EPSB=Net IncomeB
Shares Outstanding
=$120,000
Shares Outstanding
Since both companies have the same amount of shares outstanding:
EPSA= EPSB
Therefore, the earnings per share for both Company A and Company B is
$150,000/Shares Outstanding or $120,000/Shares Outstanding.
Question 22
Question
Company A and Company B are both in the same industry and have provided
the following financial information for the year ended December 31, 2021:
Item Company A Company B
Net Income
$
250,000
$
300,000
Total Assets
$
1,500,000
$
2,000,000
Total Liabilities
$
800,000
$
1,100,000
Total Equity - -
Earnings per Share
$
2.50
$
3.00
Compare the financial performance of Company A and Company B based
on the information provided.
Solution
Step 1: Calculate Total Equity for both companies using the Total Assets and
Total Liabilities information.
For Company A:
Total Equity = Total Assets−Total Liabilities = $1,500,000−$800,000 = $700,000
For Company B:
Total Equity = Total Assets−Total Liabilities = $2,000,000−$1,100,000 = $900,000
Step 2: Calculate Return on Equity (ROE) for both companies using the
Net Income and Total Equity information.
24
For Company A:
ROEA=Net IncomeA
Total EquityA
=$250,000
$700,000 ≈0.3571 or 35.71%
For Company B:
ROEB=Net IncomeB
Total EquityB
=$300,000
$900,000 ≈0.3333 or 33.33%
Step 3: Analyze Earnings per Share (EPS) for both companies.
Company A has an EPS of
$
2.50, while Company B has an EPS of
$
3.00.
This indicates that Company B has higher earnings per share, which may
be more attractive to investors.
Based on the analysis above, Company A has a higher Return on Equity
(ROE) compared to Company B. However, Company B has a higher Earnings
per Share (EPS) which may indicate better profit allocation to its shareholders.
Question 23
Question
The following information is extracted from the comparative financial state-
ments of Company XYZ for the years 2020 and 2021:
Item 2020 2021
Net Sales $500,000 $600,000
Cost of Goods Sold $250,000 $300,000
Gross Profit $250,000 $300,000
Calculate the gross profit margin for Company XYZ for the years 2020 and
2021. Interpret the trend revealed by the change in the gross profit margin from
2020 to 2021.
Solution
Step 1: Calculate the gross profit margin for the years 2020 and 2021 using the
formula:
Gross Profit Margin = Net Sales −Cost of Goods Sold
Net Sales ×100%
For 2020:
Gross Profit Margin (2020) = 500,000 −250,000
500,000 ×100%
25
=250,000
500,000×100%
= 0.5×100%
= 50%
For 2021:
Gross Profit Margin (2021) = 600,000 −300,000
600,000 ×100%
=300,000
600,000×100%
= 0.5×100%
= 50%
Step 2: Interpret the trend in the gross profit margin from 2020 to 2021. The
gross profit margin remained the same at 50% in both years. This indicates that
Company XYZ was able to maintain the same level of efficiency in generating
profits from its sales in both years.
Question 24
Question
Company A and Company B are two competing companies in the same industry.
The following are selected financial data for both companies for the year ended
December 31, 2021:
Item Company A Company B
Net Sales
$
500,000
$
400,000
Cost of Goods Sold
$
280,000
$
200,000
Gross Profit
$
220,000
$
200,000
Operating Expenses
$
120,000
$
100,000
Net Income
$
100,000
$
80,000
Total Assets
$
700,000
$
600,000
Total Liabilities
$
300,000
$
250,000
Based on the information provided, analyze and compare the financial per-
formance of Company A and Company B.
Solution
Step 1: Calculate the profitability ratios for both companies:
For Company A:
Gross Profit Margin = Gross Profit
Net Sales ×100% = 220,000
500,000 ×100% = 44%
26
Net Profit Margin = Net Income
Net Sales ×100% = 100,000
500,000 ×100% = 20%
For Company B:
Gross Profit Margin = Gross Profit
Net Sales ×100% = 200,000
400,000 ×100% = 50%
Net Profit Margin = Net Income
Net Sales ×100% = 80,000
400,000 ×100% = 20%
Step 2: Analyze the profitability ratios for both companies.
- Company A has a gross profit margin of 44
- Both companies have the same net profit margin of 20
Step 3: Calculate the return on assets (ROA) for both companies:
For Company A:
ROA =Net Income
Total Assets ×100% = 100,000
700,000 ×100% ≈14.29%
For Company B:
ROA =Net Income
Total Assets ×100% = 80,000
600,000 ×100% ≈13.33%
Step 4: Analyze the return on assets for both companies.
- Company A has a higher ROA of 14.29
In conclusion, while Company B has a higher gross profit margin, Company
A shows better efficiency in generating profit from its assets. Both companies
have the same net profit margin, indicating similar profitability levels.
Question 25
Question
The following data is extracted from the financial statements of two companies,
A and B:
Company A Company B
Net Income
$
500,000
$
600,000
Total Assets
$
5,000,000
$
7,000,000
Total Liabilities
$
2,000,000
$
3,000,000
Total Equity ? ?
Calculate the missing values for Total Equity for both companies A and B.
Solution
Step 1: Calculate Total Equity for Company A:
Total Equity A = Total Assets A −Total Liabilities A
27
Total Equity A = $5,000,000 −$2,000,000 = $3,000,000
Step 2: Calculate Total Equity for Company B:
Total Equity B = Total Assets B −Total Liabilities B
Total Equity B = $7,000,000 −$3,000,000 = $4,000,000
Therefore, the missing values for Total Equity for both companies A and B
are: - Company A:
$
3,000,000 - Company B:
$
4,000,000
Question 26
Question
Company ABC and Company XYZ are two companies in the same industry.
The following information was extracted from their financial statements:
Company ABC’s current ratio is 2.5, while Company XYZ’s current ratio
is 1.8.
Company ABC’s quick ratio is 1.2, while Company XYZ’s quick ratio is
0.9.
Company ABC’s inventory turnover ratio is 5, while Company XYZ’s
inventory turnover ratio is 4.
Based on this information, compare the liquidity and efficiency of Company
ABC and Company XYZ.
Solution
Step 1: Current Ratio The current ratio is calculated by dividing current
assets by current liabilities. It measures a company’s ability to pay its short-
term obligations.
For Company ABC:
Current RatioABC = 2.5
For Company XYZ:
Current RatioXY Z = 1.8
Since Company ABC has a higher current ratio than Company XYZ, we can
conclude that Company ABC has better liquidity in the short term.
Step 2: Quick Ratio The quick ratio, also known as the acid-test ratio, is a
more stringent measure of liquidity that excludes inventory from current assets.
For Company ABC:
Quick RatioABC = 1.2
28
For Company XYZ:
Quick RatioXY Z = 0.9
Again, Company ABC has a higher quick ratio compared to Company XYZ,
indicating better ability to meet short-term obligations without relying on in-
ventory.
Step 3: Inventory Turnover Ratio The inventory turnover ratio measures
how many times a company sells and replaces its inventory during a period.
For Company ABC:
Inventory Turnover RatioABC = 5
For Company XYZ:
Inventory Turnover RatioXY Z = 4
Company ABC has a higher inventory turnover ratio than Company XYZ,
implying that ABC sells its inventory more frequently, which is a sign of oper-
ational efficiency.
Overall, based on the provided ratios, Company ABC appears to have better
liquidity and efficiency compared to Company XYZ.
Question 27
Question
Company A and Company B are two competing firms that operate in the same
industry. The financial statements of both companies for the year ended De-
cember 31, 20X1, are compared below:
Company A:
Income Statement Amount
Revenue
$
500,000
Cost of Goods Sold
$
200,000
Operating Expenses
$
150,000
Net Income
$
150,000
Company B:
Income Statement Amount
Revenue
$
450,000
Cost of Goods Sold
$
180,000
Operating Expenses
$
130,000
Net Income
$
140,000
Assuming all other factors are equal, provide a comparative analysis of the
financial statements of these two companies.
29
Solution
Step 1: Calculate Gross Profit Margin
Gross Profit Margin = 1−Cost of Goods Sold
Revenue ×100%
For Company A:
Gross Profit MarginA=1−200,000
500,000×100% = 60%
For Company B:
Gross Profit MarginB=1−180,000
450,000×100% = 60%
Since the gross profit margins for both companies are the same at 60
Question 28
Question
The financial statements of two companies, Company A and Company B, are
provided below for the current year:
Company A
Item Amount (
$
)
Revenue 500,000
Expenses 350,000
Net Income 150,000
Company B
Item Amount (
$
)
Revenue 450,000
Expenses 275,000
Net Income 175,000
Which company is more profitable based on the information provided?
Solution
To determine which company is more profitable, we need to compare their net
incomes. Step 1: Calculate the profit margin for each company. The profit
margin is calculated as:
Profit Margin = Net Income
Revenue ×100%
30
Company A:
Profit Margin for Company A = 150,000
500,000×100% = 30%
Company B:
Profit Margin for Company B = 175,000
450,000×100% ≈38.89%
Step 2: Compare the profit margins of both companies. Company B has a
higher profit margin (38.89
Question 29
Question
The following data is taken from the financial statements of two companies, A
and B, for the year ending 2020:
Company A Company B
Net Income
$
150,000
$
200,000
Total Assets
$
1,000,000
$
1,500,000
Total Liabilities
$
400,000
$
600,000
Shareholders’ Equity ? ?
Calculate the missing values for Shareholders’ Equity for Companies A and
B.
Solution
Step 1: Calculate Shareholders’ Equity for Company A.
Shareholders’ Equity (A) = Total Assets (A) −Total Liabilities (A)
Shareholders’ Equity (A) = $1,000,000 −$400,000 = $600,000
Step 2: Calculate Shareholders’ Equity for Company B.
Shareholders’ Equity (B) = Total Assets (B) −Total Liabilities (B)
Shareholders’ Equity (B) = $1,500,000 −$600,000 = $900,000
Therefore, the Shareholders’ Equity for Company A is
$
600,000 and for
Company B is
$
900,000.
31
Question 30
Question
The following is the balance sheet of Company XYZ Ltd. as of December 31,
2020 and 2021:
Assets 2020 2021
Cash $50,000 $40,000
Accounts Receivable $30,000 $25,000
Inventory $40,000 $50,000
Property, Plant & Equipment $200,000 $180,000
Total Assets $320,000 $295,000
The following is the income statement of Company XYZ Ltd. for the year
ended December 31, 2021:
Revenue $500,000
Cost of Goods Sold $300,000
Gross Profit $200,000
Operating Expenses $100,000
Net Income $100,000
Calculate the following ratios for Company XYZ Ltd. for the year ended
December 31, 2021: 1. Current Ratio 2. Inventory Turnover Ratio 3. Gross
Profit Margin 4. Return on Assets (ROA)
Solution
Step 1: Calculate the Current Ratio The Current Ratio is calculated as follows:
Current Ratio = Current Assets
Current Liabilities
Given that:
Current Assets = Cash+Accounts Receivable+Inventory = $40,000+$25,000+$50,000 = $115,000
And assuming Current Liabilities are not provided in the question, we cannot
calculate the Current Ratio without this information.
Step 2: Calculate the Inventory Turnover Ratio The Inventory Turnover
Ratio is calculated as:
Inventory Turnover Ratio = Cost of Goods Sold
Average Inventory
Given that:
Average Inventory = Inventory2020 + Inventory2021
2=$40,000 + $50,000
2= $45,000
32
Inventory Turnover Ratio = $300,000
$45,000 = 6.67 times
Step 3: Calculate the Gross Profit Margin The Gross Profit Margin is cal-
culated as:
Gross Profit Margin = Gross Profit
Revenue ×100%
Gross Profit Margin = $200,000
$500,000 ×100% = 40%
Step 4: Calculate the Return on Assets (ROA) The Return on Assets (ROA)
is calculated as:
ROA = Net Income
Total Assets ×100%
ROA = $100,000
$295,000 ×100% ≈33.9%
Therefore, for the year ended December 31, 2021, Company XYZ Ltd. has:
1. Inventory Turnover Ratio of 6.67 times 2. Gross Profit Margin of 40% 3.
Return on Assets (ROA) of approximately 33.9%
Question 31
Question
Company A and Company B are two competitors in the retail industry. The
following information is extracted from their financial statements for the year
ended December 31, 2021:
Company A Company B
Revenue
$
800,000
$
700,000
Cost of Goods Sold
$
400,000
$
350,000
Gross Profit
$
400,000
$
350,000
Operating Expenses
$
200,000
$
180,000
Net Income
$
150,000
$
120,000
Total Assets
$
1,000,000
$
900,000
Total Liabilities
$
400,000
$
350,000
Based on this information, perform a comparative financial statement analy-
sis to evaluate and compare the financial performance and position of Company
A and Company B.
Solution
Step 1: Calculate the gross profit margin for both companies.
The gross profit margin is calculated using the formula:
Gross Profit Margin = Gross Profit
Revenue ×100%
33
For Company A:
Gross Profit Margin (Company A) = 400,000
800,000 ×100% = 50%
For Company B:
Gross Profit Margin (Company B) = 350,000
700,000 ×100% = 50%
Step 2: Calculate the net profit margin for both companies.
The net profit margin is calculated using the formula:
Net Profit Margin = Net Income
Revenue ×100%
For Company A:
Net Profit Margin (Company A) = 150,000
800,000 ×100% = 18.75%
For Company B:
Net Profit Margin (Company B) = 120,000
700,000 ×100% ≈17.14%
Step 3: Calculate the return on assets (ROA) for both companies.
The return on assets is calculated using the formula:
ROA = Net Income
Total Assets ×100%
For Company A:
ROA (Company A) = 150,000
1,000,000 ×100% = 15%
For Company B:
ROA (Company B) = 120,000
900,000 ×100% ≈13.33%
Step 4: Compare the financial performance and position of Com-
pany A and Company B based on the calculated ratios.
- Company A and Company B have the same gross profit margin, indicating
both companies are equally efficient in generating profits from sales. - Company
A has a higher net profit margin (18.75- Company A also has a higher ROA (15
In conclusion, based on the comparative financial statement analysis, Com-
pany A appears to have performed better in terms of profitability and asset
utilization compared to Company B in the year 2021.
34
Question 32
Question
The financial statements of Company A and Company B are provided below for
the year ended December 31, 2021:
Company A
Items Company A Company B
Revenue
$
500,000
$
400,000
Cost of Goods Sold
$
200,000
$
150,000
Operating Expenses
$
100,000
$
80,000
Net Income
$
200,000
$
170,000
Using the information provided, analyze and compare the profitability of
Company A and Company B.
Solution
Step 1: Calculate the Gross Profit Margin for Company A and Company B.
Gross Profit Margin is calculated using the formula:
Gross Profit Margin = Revenue −Cost of Goods Sold
Revenue ×100%
For Company A:
Gross Profit Margin (Company A) = 500,000 −200,000
500,000 ×100% = 300,000
500,000×100% = 60%
For Company B:
Gross Profit Margin (Company B) = 400,000 −150,000
400,000 ×100% = 250,000
400,000×100% = 62.5%
Step 2: Compare the Gross Profit Margin of Company A and Company B.
Company B has a higher Gross Profit Margin (62.5
Step 3: Calculate the Net Profit Margin for Company A and Company B.
Net Profit Margin is calculated using the formula:
Net Profit Margin = Net Income
Revenue ×100%
For Company A:
Net Profit Margin (Company A) = 200,000
500,000 ×100% = 40%
For Company B:
Net Profit Margin (Company B) = 170,000
400,000 ×100% = 42.5%
35
Step 4: Compare the Net Profit Margin of Company A and Company B.
Company B also has a higher Net Profit Margin (42.5
In conclusion, based on the Gross Profit Margin and Net Profit Margin
analysis, Company B appears to be more profitable and efficient than Company
A in the year ended December 31, 2021.
Question 33
Question
The financial statements of Company X for two consecutive years are given
below:
Income Statement
Item Year 1 Year 2
Revenue $500,000 $600,000
Expenses $350,000 $420,000
Balance Sheet
Item Year 1 Year 2
Assets $700,000 $800,000
Liabilities $400,000 $450,000
Equity $300,000 $350,000
Based on the given information, perform a comparative financial statement
analysis for Company X by calculating the following financial ratios for Year 1
and Year 2:
1. Gross Profit Margin
2. Net Profit Margin
3. Return on Assets
4. Return on Equity
Solution
Step 1: Calculate the financial ratios for Year 1 and Year 2.
1. Gross Profit Margin:
Gross Profit Margin = Revenue −Expenses
Revenue ×100%
For Year 1:
Gross Profit Margin Year 1 = $500,000 −$350,000
$500,000 ×100% = 30%
36
For Year 2:
Gross Profit Margin Year 2 = $600,000 −$420,000
$600,000 ×100% = 30%
2. Net Profit Margin:
Net Profit Margin = Revenue −Expenses
Revenue ×100%
For Year 1:
Net Profit Margin Year 1 = $500,000 −$350,000
$500,000 ×100% = 30%
For Year 2:
Net Profit Margin Year 2 = $600,000 −$420,000
$600,000 ×100% = 30%
3. Return on Assets:
Return on Assets = Net Income
Average Total Assets
For Year 1:
Return on Assets Year 1 = $150,000
($700,000 + $800,000)/2= 15.38%
For Year 2:
Return on Assets Year 2 = $180,000
($800,000 + $900,000)/2= 18.00%
4. Return on Equity:
Return on Equity = Net Income
Average Shareholders’ Equity
For Year 1:
Return on Equity Year 1 = $150,000
($300,000 + $350,000)/2= 42.86%
For Year 2:
Return on Equity Year 2 = $180,000
($350,000 + $400,000)/2= 47.37%
37
Question 34
Question
Company X and Company Y are two competing firms in the same industry.
Analyze the comparative financial statements of both companies for the year
ending December 31, 20X8, and answer the following questions:
1. Which company has a higher profit margin?
2. Which company has better efficiency in managing its assets?
3. Which company has a stronger liquidity position?
Solution
To compare the financial performance of Company X and Company Y, we will
analyze their financial statements for the year ending December 31, 20X8.
Step 1: Calculate Profit Margin Profit Margin is calculated as Net In-
come divided by Total Revenue, expressed as a percentage. Let’s assume: -
Company X has Net Income of 500,000andT otalRevenueof 2,000,000 - Com-
pany Y has Net Income of 600,000andT otalRevenueof 3,000,000
For Company X: Profit Margin = 500,000
2,000,000 ×100% = 25%.
For Company Y: Profit Margin = 600,000
3,000,000 ×100% = 20%.
Thus, Company X has a higher profit margin of 25
Step 2: Analyze Asset Management Efficiency Asset Turnover Ratio
is calculated as Total Revenue divided by Average Total Assets. Let’s assume: -
Company X has Total Revenue of 2,000,000andAverageT otalAssetsof 1,000,000
- Company Y has Total Revenue of 3,000,000andAverageT otalAssetsof 1,500,000
For Company X: Asset Turnover Ratio = 2,000,000
1,000,000 = 2.
For Company Y: Asset Turnover Ratio = 3,000,000
1,500,000 = 2.
Both companies have the same asset turnover ratio of 2, indicating equal
efficiency in managing assets.
Step 3: Evaluate Liquidity Position Current Ratio is calculated as
Current Assets divided by Current Liabilities. Let’s assume: - Company X has
Current Assets of 800,000andCurrentLiabilitiesof400,000 - Company Y has
Current Assets of 1,200,000andCurrentLiabilitiesof600,000
For Company X: Current Ratio = 800,000
400,000 = 2.
For Company Y: Current Ratio = 1,200,000
600,000 = 2.
Both companies have the same current ratio of 2, indicating similar liquidity
positions.
In conclusion, Company X has a higher profit margin than Company Y, while
both companies exhibit equal efficiency in managing assets and have similar
liquidity positions.
38
Question 35
Question
Company XYZ provides you with the following financial data for the years 2019
and 2020:
Item 2019 2020
Revenue
$
500,000
$
600,000
Expenses
$
350,000
$
420,000
Net Income
$
150,000
$
180,000
Total Assets
$
800,000
$
900,000
Total Liabilities
$
400,000
$
450,000
Shareholders’ Equity
$
400,000
$
450,000
Calculate and interpret the following financial ratios for Company XYZ for
the years 2019 and 2020: 1. Profit Margin 2. Return on Assets (ROA) 3.
Return on Equity (ROE)
Solution
1. Profit Margin:
Profit Margin = Net Income
Revenue ×100%
Step 1: Calculate the profit margin for 2019:
Profit Margin2019 =150,000
500,000 ×100% = 30%
Step 2: Calculate the profit margin for 2020:
Profit Margin2020 =180,000
600,000 ×100% = 30%
Interpretation: Company XYZ maintained a consistent profit margin of
30% from 2019 to 2020.
2. Return on Assets (ROA):
ROA = Net Income
Total Assets ×100%
Step 1: Calculate the ROA for 2019:
ROA2019 =150,000
800,000 ×100% = 18.75%
Step 2: Calculate the ROA for 2020:
ROA2020 =180,000
900,000 ×100% = 20%
39
Interpretation: Company XYZ’s ROA improved from 18.75% in 2019 to
20% in 2020, indicating more efficient use of assets to generate profits.
3. Return on Equity (ROE):
ROE = Net Income
Shareholders’ Equity ×100%
Step 1: Calculate the ROE for 2019:
ROE2019 =150,000
400,000 ×100% = 37.5%
Step 2: Calculate the ROE for 2020:
ROE2020 =180,000
450,000 ×100% = 40%
Interpretation: Company XYZ’s ROE increased from 37.5% in 2019 to
40% in 2020, showcasing improved profitability relative to shareholders’ equity.
40
