ACCT 302 - INTERMEDIATE
ACCOUNTING II - Comparative
financial statement analysis
Question Bank - Set 3
Liberty University
Question 1
Question
You are provided with the following financial information for Company XYZ
for two consecutive years:
Year 1:
Total Assets:
$
500,000
Total Liabilities:
$
200,000
Total Equity:
$
300,000
Net Income:
$
50,000
Year 2:
Total Assets:
$
600,000
Total Liabilities:
$
250,000
Total Equity:
$
350,000
Net Income:
$
60,000
Using this information, perform a comparative financial statement analysis
to assess the financial performance and position of Company XYZ over the two
years.
Solution
Step 1: Calculate the debt-to-equity ratio for each year.
Year 1:
Debt-to-Equity Ratio = Total Liabilities
Total Equity =200,000
300,000 = 0.67
Year 2:
Debt-to-Equity Ratio = Total Liabilities
Total Equity =250,000
350,000 ≈0.71
Step 2: Analyze the change in the debt-to-equity ratio.
The debt-to-equity ratio increased from 0.67 in Year 1 to approximately
0.71 in Year 2. This indicates that the company took on more debt relative
to its equity over the two years.
Step 3: Calculate the return on assets for each year.
Year 1:
Return on Assets = Net Income
Total Assets =50,000
500,000 = 0.10 = 10%
Year 2:
Return on Assets = Net Income
Total Assets =60,000
600,000 = 0.10 = 10%
Step 4: Compare the return on assets for both years.
The return on assets remained the same at 10% for both Year 1 and Year
2. This indicates that the company was able to maintain its profitability
relative to its total assets over the two years.
By analyzing the debt-to-equity ratio and return on assets, we can see that
Company XYZ took on more debt relative to its equity but was able to maintain
its profitability over the two years.
Question 2
Question
The following data is extracted from the financial statements of two companies,
Company A and Company B:
2
Company A Company B
Revenue
$
500,000
$
650,000
Operating Expenses
$
300,000
$
400,000
Net Income
$
100,000
$
150,000
Total Assets
$
1,000,000
$
1,200,000
Total Liabilities
$
400,000
$
500,000
Compare the two companies based on their profitability, asset utilization,
and financial leverage.
Solution
Step 1: Calculate Profitability Ratios
Profit Margin:
For Company A:
Profit Margin = Net Income
Revenue =$100,000
$500,000 = 0.20 = 20%
For Company B:
Profit Margin = Net Income
Revenue =$150,000
$650,000 ≈0.23 = 23%
Return on Assets (ROA):
For Company A:
ROA = Net Income
Total Assets =$100,000
$1,000,000 = 0.10 = 10%
For Company B:
ROA = Net Income
Total Assets =$150,000
$1,200,000 ≈0.125 = 12.5%
Step 2: Calculate Asset Utilization Ratios
Asset Turnover:
For Company A:
Asset Turnover = Revenue
Total Assets =$500,000
$1,000,000 = 0.50
For Company B:
Asset Turnover = Revenue
Total Assets =$650,000
$1,200,000 ≈0.54
3
Step 3: Calculate Financial Leverage Ratios
Debt-to-Assets Ratio:
For Company A:
Debt-to-Assets Ratio = Total Liabilities
Total Assets =$400,000
$1,000,000 = 0.40 = 40%
For Company B:
Debt-to-Assets Ratio = Total Liabilities
Total Assets =$500,000
$1,200,000 ≈0.42 = 42%
After analyzing the ratios, Company B appears to have higher profitabil-
ity, better asset utilization, and slightly higher financial leverage compared to
Company A.
Question 3
Question
The financial statements of two companies, Company A and Company B, are
given below. Use horizontal analysis to compare the performance of the two
companies.
Item Company A Company B
Revenue $500,000 $700,000
Expenses $350,000 $480,000
Net Income $150,000 $220,000
Solution
Step 1: Calculate the dollar change for each item
Change in Revenue for Company A: $700,000 −$500,000 = $200,000
Change in Expenses for Company A: $480,000 −$350,000 = $130,000
Change in Net Income for Company A: $220,000 −$150,000 = $70,000
Step 2: Calculate the percentage change for each item
Percentage Change in Revenue for Company A: $200,000
$500,000 ×100% = 40%
Percentage Change in Expenses for Company A: $130,000
$350,000 ×100% = 37.14%
Percentage Change in Net Income for Company A: $70,000
$150,000 ×100% =
46.67%
Step 3: Analyze the results Company A experienced a 40
4
Question 4
Question
Company X and Company Y are two competitors in the same industry. The
following financial information is available for both companies:
Company X:
Net Income:
$
500,000
Total Assets:
$
3,000,000
Total Liabilities:
$
1,200,000
Company Y:
Net Income:
$
800,000
Total Assets:
$
5,000,000
Total Liabilities:
$
2,500,000
Compare the financial performance of Company X and Company Y based
on the Return on Assets (ROA) ratio. Which company seems to be utilizing its
assets more efficiently?
Solution
Step 1: Calculate the Return on Assets (ROA) ratio for Company X and Com-
pany Y.
The formula for ROA is:
ROA =Net Income
T otal Assets ×100%
For Company X:
ROAX=500,000
3,000,000 ×100% = 1
6×100% = 16.67%
For Company Y:
ROAY=800,000
5,000,000 ×100% = 4
25 ×100% = 16%
Step 2: Compare the ROA for both companies.
Company X has an ROA of 16.67
5
Question 5
Question
You are given the following financial information for Company X and Company
Y:
Company X
Net Income:
$
500,000
Total Assets:
$
2,000,000
Total Liabilities:
$
800,000
Equity:
$
1,200,000
Company Y
Net Income:
$
400,000
Total Assets:
$
1,500,000
Total Liabilities:
$
600,000
Equity:
$
900,000
Determine which company is more profitable and has a stronger financial
position based on this information.
Solution
To compare the profitability and financial position of Company X and Company
Y, we will analyze their financial ratios.
Step 1: Calculate Return on Assets (ROA)
ROA is a profitability ratio that shows how efficiently a company is using
its assets to generate profit.
ROA = Net Income
Total Assets
Company X:
ROAX=$500,000
$2,000,000 = 0.25 or 25%
Company Y:
ROAY=$400,000
$1,500,000 ≈0.2667 or 26.67%
Step 2: Calculate Return on Equity (ROE)
6
ROE is a profitability ratio that indicates how well a company is utilizing
its shareholders’ equity to generate profit.
ROE = Net Income
Equity
Company X:
ROEX=$500,000
$1,200,000 ≈0.4167 or 41.67%
Company Y:
ROEY=$400,000
$900,000 ≈0.4444 or 44.44%
Step 3: Analyze the Results
Based on the calculated ratios, Company Y is slightly more profitable than
Company X as it has a higher ROA and ROE. However, financial position also
depends on the level of risk and liquidity, which can be further analyzed using
additional financial ratios.
Question 6
Question
The following data was gathered from the comparative financial statements of
Company XYZ:
Ratio Year 1 Year 2
Current Ratio 2.5 3.0
Quick Ratio 1.5 1.8
Debt to Equity Ratio 0.6 0.8
Net Profit Margin 15% 12%
Return on Equity 20% 18%
Based on this information, analyze the financial performance of Company
XYZ between Year 1 and Year 2.
Solution
Step 1: Current Ratio Analysis
The current ratio is a liquidity ratio that measures a company’s ability to
meet its short-term obligations.
The current ratio can be calculated as:
Current Ratio = Current Assets
Current Liabilities
7
In Year 1:
Current Ratio (Year 1) = 2.5
1= 2.5
In Year 2:
Current Ratio (Year 2) = 3.0
1= 3.0
The increase in the current ratio from 2.5 in Year 1 to 3.0 in Year 2 indicates
an improvement in the company’s liquidity position.
Step 2: Quick Ratio Analysis
The quick ratio is a more stringent measure of liquidity as it excludes inven-
tory from current assets.
The quick ratio can be calculated as:
Quick Ratio = Current Assets −Inventory
Current Liabilities
In Year 1:
Quick Ratio (Year 1) = 2.5−1
1= 1.5
In Year 2:
Quick Ratio (Year 2) = 3.0−1
1= 1.8
The increase in the quick ratio from 1.5 in Year 1 to 1.8 in Year 2 also
indicates an improvement in the company’s liquidity position.
Step 3: Debt to Equity Ratio Analysis
The debt to equity ratio measures the company’s financial leverage and risk.
The debt to equity ratio can be calculated as:
Debt to Equity Ratio = Total Debt
Shareholders’ Equity
In Year 1:
Debt to Equity Ratio (Year 1) = 0.6
In Year 2:
Debt to Equity Ratio (Year 2) = 0.8
The increase in the debt to equity ratio from 0.6 in Year 1 to 0.8 in Year
2 indicates that the company took on more debt relative to equity, which may
increase financial risk.
Step 4: Net Profit Margin Analysis
The net profit margin measures the company’s profitability.
The net profit margin can be calculated as:
Net Profit Margin = Net Profit
Revenue ×100%
In Year 1:
Net Profit Margin (Year 1) = 15%
8
In Year 2:
Net Profit Margin (Year 2) = 12%
The decrease in the net profit margin from 15% in Year 1 to 12% in Year 2
indicates a decrease in profitability.
Step 5: Return on Equity Analysis
The return on equity measures the return earned on the shareholders’ equity.
The return on equity can be calculated as:
Return on Equity = Net Income
Average Shareholders’ Equity ×100%
In Year 1:
Return on Equity (Year 1) = 20%
In Year 2:
Return on Equity (Year 2) = 18%
The decrease in the return on equity from 20% in Year 1 to 18% in Year 2
indicates a decrease in the return
Question 7
Question
Company A and Company B are both in the same industry. Company A’s cur-
rent ratio decreased from 2.5 to 1.8, while Company B’s current ratio increased
from 1.6 to 1.9. Discuss the implications of these changes in the context of
comparative financial statement analysis.
Solution
To analyze the implications of the changes in current ratios for Company A and
Company B, we need to consider the liquidity position of each company.
Step 1: Understand the Current Ratio The current ratio is calculated
as:
Current Ratio = Current Assets
Current Liabilities
This ratio indicates a company’s ability to pay its short-term obligations
with its short-term assets.
Step 2: Analyze Company A’s Current Ratio Change Company A’s
current ratio decreased from 2.5 to 1.8. This implies that Company A’s current
liabilities have increased relative to its current assets. The decrease in current
ratio may indicate potential liquidity issues for Company A. It could mean that
Company A is struggling to meet its short-term obligations with its current
assets.
9
Step 3: Analyze Company B’s Current Ratio Change Company B’s
current ratio increased from 1.6 to 1.9. This increase suggests that Company
B’s current assets have increased relative to its current liabilities. The higher
current ratio indicates improved liquidity position for Company B. It implies
that Company B is in a better position to cover its short-term liabilities with
its current assets.
Step 4: Comparative Analysis Comparing the changes in current ratios
for Company A and Company B, we can infer that Company B has shown better
performance in managing its liquidity compared to Company A. Company B’s
increased current ratio indicates a stronger liquidity position, while Company
A’s decreased current ratio raises concerns about its ability to meet short-term
obligations. This analysis suggests that Company B may be in a more favorable
financial position compared to Company A in terms of liquidity.
Question 8
Question
Company X and Company Y are two competing companies in the same in-
dustry. You have been provided with their financial statements for the past
three years. Compare their financial performance using horizontal and vertical
analysis. Discuss any trends or significant differences that you observe.
Solution
To compare the financial performance of Company X and Company Y, we will
conduct both horizontal analysis (comparing line items across the years) and
vertical analysis (comparing line items within a single year).
Horizontal Analysis:
Step 1: Calculate the percentage change for key line items for each com-
pany over the past three years.
Step 2: Compare the percentage changes for Company X and Company Y
to identify any significant differences in their financial performance trends.
Vertical Analysis:
Step 1: Calculate the percentage of each line item relative to a base item
(usually total revenue or total assets) within each year for both companies.
Step 2: Compare the vertical analysis percentages between Company X
and Company Y to identify any significant differences in their financial
structure.
After conducting both horizontal and vertical analysis for Company X and
Company Y, we will be able to identify trends, strengths, weaknesses, and
differences in their financial performance and financial structures.
10
Question 9
Question
Company XYZ provides you with the following financial information for the
years 2019 and 2020:
2019 2020
Net Sales
$
500,000
$
600,000
Cost of Goods Sold
$
300,000
$
350,000
Operating Expenses
$
80,000
$
90,000
Interest Expense
$
10,000
$
12,000
Income Tax Expense
$
15,000
$
18,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 = Net Sales−Cost of Goods Sold
Net Sales ×100%
For 2019:
Gross Profit Margin2019 =$500,000 −$300,000
$500,000 ×100% = 40%
For 2020:
Gross Profit Margin2020 =$600,000 −$350,000
$600,000 ×100% = 41.67%
Step 2: Calculate Operating Profit Margin
Operating Profit Margin = Net Sales−Cost of Goods Sold−Operating Expenses
Net Sales ×
100%
For 2019:
Operating Profit Margin2019 =$500,000 −$300,000 −$80,000
$500,000 ×100% = 24%
For 2020:
Operating Profit Margin2020 =$600,000 −$350,000 −$90,000
$600,000 ×100% = 21.67%
Step 3: Calculate Net Profit Margin
11
Net Profit Margin = Net Income
Net Sales ×100%
To calculate net income, we need to subtract interest expense and income
tax expense from operating profit.
For 2019:
Net Income2019 = $500,000−$300,000−$80,000−$10,000−$15,000 = $95,000
Net Profit Margin2019 =$95,000
$500,000 ×100% = 19%
For 2020:
Net Income2020 = $600,000−$350,000−$90,000−$12,000−$18,000 = $140,000
Net Profit Margin2020 =$140,000
$600,000 ×100% = 23.33%
Therefore, the calculated ratios for Company XYZ for the years 2019 and
2020 are as follows:
1. Gross Profit Margin: 40
2. Operating Profit Margin: 24
3. Net Profit Margin: 19
Question 10
Question
Company X and Company Y are two competitors in the same industry. Evaluate
and compare Company X and Company Y’s financial performance using the
following financial ratios:
Profit Margin
Return on Assets (ROA)
Debt-to-Equity Ratio
Current Ratio
Use the information provided in the financial statements of both companies to
calculate these ratios and provide an analysis based on your calculations.
12
Solution
Step 1: Calculate Profit Margin
Profit Margin = (Net Income / Revenue) * 100%
Step 2: Calculate Return on Assets (ROA)
ROA = (Net Income / Average Total Assets) * 100%
Step 3: Calculate Debt-to-Equity Ratio
Debt-to-Equity Ratio = Total Debt / Total Equity
Step 4: Calculate Current Ratio
Current Ratio = Current Assets / Current Liabilities
Step 5: Analysis
Compare Company X and Company Y’s profit margins to see which com-
pany is more efficient in generating profit from its revenue.
Calculate and compare the return on assets to determine which company
is more effective in generating profit from its assets.
Analyze the debt-to-equity ratio to assess the financial risk of each com-
pany.
Lastly, compare the current ratios of both companies to evaluate their
liquidity positions.
Based on the calculations and analysis of these financial ratios, you can
provide a comprehensive comparative analysis of the financial performance of
Company X and Company Y in the industry.
Question 11
Question
Assume you are a financial analyst analyzing two companies, Company A and
Company B. You are reviewing their financial statements and notice the follow-
ing information for both companies:
Company A had a higher net income than Company B in the current year.
Company B had a higher return on assets (ROA) than Company A in the
current year.
Both companies had the same total assets.
Company A had a higher return on equity (ROE) than Company B in the
current year.
Given this information, which company do you think is performing better
financially, and why?
13
Solution
To determine which company is performing better financially based on the infor-
mation provided, we need to analyze the different financial ratios and consider
how they relate to each company’s financial performance.
Step 1: Define the Ratios
Net Income: This measures the profitability of a company.
Return on Assets (ROA): This ratio shows how efficiently a company is
using its assets to generate profit.
Total Assets: The total value of a company’s assets.
Return on Equity (ROE): This ratio shows how effectively a company is
using its shareholders’ equity to generate profit.
Step 2: Analysis
Company A having a higher net income than Company B indicates that
Company A is more profitable in absolute terms.
Company B having a higher ROA means that Company B is more efficient
at using its assets to generate profit compared to Company A.
Both companies having the same total assets means they are of equal size
in terms of assets.
Company A having a higher ROE than Company B suggests that Com-
pany A is more effective at generating profit from shareholders’ equity.
Step 3: Conclusion Based on the information provided, it can be con-
cluded that Company A is performing better financially compared to Company
B. This conclusion is drawn from the fact that Company A has a higher net
income and ROE, indicating better profitability and more effective use of share-
holders’ equity. Company B’s higher ROA is important but does not outweigh
the significance of higher net income and ROE in this case.
Question 12
Question
A company reported the following financial information for two consecutive
years:
Year 1:
Net Sales:
$
500,000
Cost of Goods Sold:
$
300,000
Operating Expenses:
$
100,000
14
Year 2:
Net Sales:
$
600,000
Cost of Goods Sold:
$
350,000
Operating Expenses:
$
120,000
Perform a comparative financial statement analysis for the two years by
calculating the following ratios: 1. Gross Profit Margin 2. Operating Profit
Margin
Solution
Step 1: Calculate Gross Profit Margin
Year 1:
–Gross Profit = Net Sales - Cost of Goods Sold
–Gross Profit =
$
500,000 -
$
300,000 =
$
200,000
–Gross Profit Margin = Gross Profit
Net Sales ×100% = 200,000
500,000 ×100% = 40%
Year 2:
–Gross Profit = Net Sales - Cost of Goods Sold
–Gross Profit =
$
600,000 -
$
350,000 =
$
250,000
–Gross Profit Margin = Gross Profit
Net Sales ×100% = 250,000
600,000 ×100% = 41.67%
Step 2: Calculate Operating Profit Margin
Year 1:
–Operating Profit = Gross Profit - Operating Expenses
–Operating Profit =
$
200,000 -
$
100,000 =
$
100,000
–Operating Profit Margin = Operating Profit
Net Sales ×100% = 100,000
500,000 ×100% =
20%
Year 2:
–Operating Profit = Gross Profit - Operating Expenses
–Operating Profit =
$
250,000 -
$
120,000 =
$
130,000
–Operating Profit Margin = Operating Profit
Net Sales ×100% = 130,000
600,000 ×100% ≈
21.67%
15
Question 13
Question
Company XYZ reported the following information for two consecutive years:
Year 2 Year 1
Net Sales
$
500,000
$
450,000
Cost of Goods Sold
$
300,000
$
260,000
Operating Expenses
$
100,000
$
80,000
Income Tax Expense
$
20,000
$
15,000
Calculate the following financial ratios for both years and state whether the
company’s financial performance improved or deteriorated from Year 1 to Year
2:
1. Gross Profit Margin
2. Operating Profit Margin
3. Net Profit Margin
4. Return on Assets
5. Return on Equity
Solution
Step 1: Calculate the financial ratios for Year 1:
Gross Profit Margin = Net Sales −Cost of Goods Sold
Net Sales ×100%
=$450,000 −$260,000
$450,000 ×100%
= 42.22%
Operating Profit Margin = Operating Income −Operating Expenses
Net Sales ×100%
=$190,000 −$80,000
$450,000 ×100%
= 24.44%
Net Profit Margin = Net Income −Income Tax Expense
Net Sales ×100%
=$150,000 −$15,000
$450,000 ×100%
= 31.11%
16
Return on Assets = Net Income
Average Total Assets ×100%
= $150,000
$1,000,000+$800,000
2!×100%
= 15.79%
Return on Equity = Net Income
Average Shareholders’ Equity×100%
= $150,000
$600,000+$500,000
2!×100%
= 28.57%
Step 2: Calculate the financial ratios for Year 2:
Gross Profit Margin = $500,000 −$300,000
$500,000 ×100%
= 40.00%
Operating Profit Margin = $200,000 −$100,000
$500,000 ×100%
= 20.00%
Net Profit Margin = $180,000 −$20,000
$500,000 ×100%
= 32.00%
Return on Assets = $180,000
$1,200,000+$900,000
2!×100%
= 11.54%
Return on Equity = $180,000
$800,000+$700,000
2!×100%
= 23.08%
Step 3: Analyzing the results:
17
Question 14
Question
You are given the following income statements for Company A and Company
B:
Income Statement Company A Company B
Revenue $500,000 $700,000
Cost of Goods Sold $200,000 $350,000
Operating Expenses $100,000 $150,000
Net Income $200,000 $200,000
Which company is more profitable based on the information provided? Jus-
tify your answer.
Solution
To determine which company is more profitable, we will compare their net
income.
Step 1: Calculate the Net Profit Margin for each company.
The Net Profit Margin formula is:
Net Profit Margin = Net Income
Revenue ×100
Company A:
Net Profit Margin = 200,000
500,000×100 = 40%
Company B:
Net Profit Margin = 200,000
700,000×100 ≈28.57%
Step 2: Compare the Net Profit Margins.
Company A has a net profit margin of 40%, while Company B has a net profit
margin of approximately 28.57%. Therefore, based on the net profit margin,
Company A is more profitable than Company B. Company A generates
more profit for every dollar of revenue compared to Company B.
Question 15
Question
Company XYZ and Company ABC are both in the manufacturing industry.
The following are selected financial data for the two companies:
Company XYZ
18
Net Income:
$
500,000
Total Assets:
$
4,000,000
Total Liabilities:
$
1,500,000
Shareholders’ Equity:
$
2,500,000
Company ABC
Net Income:
$
700,000
Total Assets:
$
6,000,000
Total Liabilities:
$
2,000,000
Shareholders’ Equity:
$
4,000,000
Perform a comparative financial statement analysis for Company XYZ and
Company ABC. Analyze their profitability, liquidity, and solvency based on the
given data.
Solution
Step 1: Calculate Return on Assets (ROA) for Company XYZ and
Company ABC
ROA is a measure of profitability and is calculated as follows:
ROA =Net Income
T otal Assets ×100%
For Company XYZ:
ROAXY Z =500,000
4,000,000 ×100% = 12.5%
For Company ABC:
ROAABC =700,000
6,000,000 ×100% = 11.67%
Step 2: Calculate Return on Equity (ROE) for Company XYZ and
Company ABC
ROE is a measure of profitability and is calculated as follows:
ROE =Net Income
Shareholders′Equity ×100%
For Company XYZ:
ROEXY Z =500,000
2,500,000 ×100% = 20%
19
For Company ABC:
ROEABC =700,000
4,000,000 ×100% = 17.5%
Step 3: Calculate Current Ratio for Company XYZ and Company
ABC
The current ratio is a measure of liquidity and is calculated as follows:
Current Ratio =Current Assets
Current Liabilities
Since the current assets and liabilities are not provided, we cannot calculate
the current ratio for both companies.
Step 4: Calculate Debt-to-Equity Ratio for Company XYZ and
Company ABC
The debt-to-equity ratio is a measure of solvency and is calculated as follows:
Debt −to −Equity Ratio =T otal Liabilities
Shareholders′Equity
For Company XYZ:
Debt −to −EquityXY Z =1,500,000
2,500,000 = 0.6
For Company ABC:
Debt −to −EquityABC =2,000,000
4,000,000 = 0.5
Based on the analysis, Company XYZ has a higher ROA, ROE, and debt-
to-equity ratio compared to Company ABC, indicating better profitability and
leverage but it might have more financial risk due to higher debt levels.
Question 16
Question
Company ABC and Company XYZ are two competitors in the same industry.
The following data is extracted from their financial statements:
Financial Ratios Company ABC Company XYZ
Current Ratio 2.5 1.8
Debt-to-Equity Ratio 0.6 0.5
Return on Equity 15% 18%
Based on this information, which company appears to be in a better financial
position? Justify your answer with reasons.
20
Solution
To determine which company appears to be in a better financial position, we
will analyze each financial ratio provided.
Step 1: Current Ratio Comparison
Company ABC has a current ratio of 2.5, while Company XYZ has a
current ratio of 1.8.
The current ratio indicates a company’s ability to pay its short-term obli-
gations.
A higher current ratio is generally preferred as it suggests a stronger ability
to cover short-term liabilities.
Therefore, based on the current ratio, Company ABC appears to be in a
better financial position than Company XYZ.
Step 2: Debt-to-Equity Ratio Comparison
Company ABC has a debt-to-equity ratio of 0.6, while Company XYZ has
a debt-to-equity ratio of 0.5.
The debt-to-equity ratio measures the proportion of debt a company uses
to finance its operations relative to shareholders’ equity.
A lower debt-to-equity ratio indicates lower financial risk and a stronger
capital structure.
Therefore, based on the debt-to-equity ratio, Company XYZ appears to
be in a better financial position than Company ABC.
Step 3: Return on Equity Comparison
Company ABC has a return on equity of 15
Return on equity measures the profitability of a company in relation to
shareholders’ equity.
A higher return on equity indicates better profitability for shareholders.
Therefore, based on the return on equity, Company XYZ appears to be in
a better financial position than Company ABC.
Conclusion:
Company ABC performs better in terms of liquidity with a higher current
ratio.
Company XYZ has a stronger capital structure with a lower debt-to-equity
ratio.
21
However, Company XYZ is more profitable for its shareholders with a
higher return on equity.
In conclusion, Company XYZ appears to be in a better overall financial
position due to its better return on equity, despite having a lower current
ratio than Company ABC.
Question 17
Question
Company A and Company B are competitors in the same industry. The follow-
ing are selected financial statement data for the two companies:
Company A:
Net Income:
$
500,000
Total Assets:
$
5,000,000
Shareholders’ Equity:
$
3,000,000
Company B:
Net Income:
$
600,000
Total Assets:
$
7,000,000
Shareholders’ Equity:
$
4,000,000
Compare the profitability and financial leverage of Company A and Com-
pany B using the given financial statement data.
Solution
Step 1: Calculate Return on Assets (ROA) for both companies. ROA is calcu-
lated as net income divided by total assets.
For Company A:
ROAA=500,000
5,000,000 = 0.10 or 10%
For Company B:
ROAB=600,000
7,000,000 =6
70 ≈0.0857 or 8.57%
Step 2: Interpretation of ROA results. Company A has a higher ROA (10
Step 3: Calculate Return on Equity (ROE) for both companies. ROE is
calculated as net income divided by shareholders’ equity.
22
For Company A:
ROEA=500,000
3,000,000 =1
6≈0.1667 or 16.67%
For Company B:
ROEB=600,000
4,000,000 = 0.15 or 15%
Step 4: Interpretation of ROE results. Company A has a higher ROE (16.67
Step 5: Calculate Debt-to-Equity ratio for both companies. Debt-to-Equity
ratio is calculated as total liabilities divided by shareholders’ equity.
For Company A:
D/EA=5,000,000 −3,000,000
3,000,000 =2,000,000
3,000,000 =2
3≈0.67
For Company B:
D/EB=7,000,000 −4,000,000
4,000,000 =3,000,000
4,000,000 = 0.75
Step 6: Interpretation of Debt-to-Equity ratio results. Company A has a
lower Debt-to-Equity ratio (0.67) compared to Company B (0.75). This indi-
cates that Company A relies less on debt funding than Company B.
Question 18
Question
Company A and Company B are two competing companies in the same indus-
try. You have been provided with the following financial information for both
companies for two consecutive years:
Company A
Year 1 Revenue:
$
500,000
Year 2 Revenue:
$
600,000
Year 1 Net Income:
$
50,000
Year 2 Net Income:
$
70,000
Company B
Year 1 Revenue:
$
700,000
Year 2 Revenue:
$
800,000
Year 1 Net Income:
$
60,000
Year 2 Net Income:
$
75,000
Based on this information, which company showed a better increase in both
revenue and net income between the two years?
23
Solution
Step 1: Calculate the increase in revenue for both companies.
Company A revenue increase = $600,000 −$500,000
= $100,000
Company B revenue increase = $800,000 −$700,000
= $100,000
Step 2: Compare the revenue increases for both companies. Since both
companies had the same increase in revenue (
$
100,000), they showed an equal
increase in revenue between the two years.
Step 3: Calculate the increase in net income for both companies.
Company A net income increase = $70,000 −$50,000
= $20,000
Company B net income increase = $75,000 −$60,000
= $15,000
Step 4: Compare the net income increases for both companies. Company
A showed a better increase in net income (
$
20,000) compared to Company
B (
$
15,000) between the two years. Thus, Company A demonstrated better
growth in net income over the period.
Question 19
Question
Company XYZ provided the following information from its financial statements
for the years ended December 31, 20X1 and December 31, 20X2:
Item 20X1 ($) 20X2 ($)
Total assets 500,000 600,000
Total liabilities 200,000 250,000
Net income 50,000 70,000
Calculate the following ratios for Company XYZ for the years ended Decem-
ber 31, 20X1 and December 31, 20X2: 1. Debt-to-Asset Ratio 2. Return on
Assets (ROA) 3. Return on Equity (ROE)
24
Solution
Step 1: Calculate the Debt-to-Asset Ratio.
Debt-to-Asset Ratio = Total liabilities
Total assets
20X1: = 200,000
500,000 = 0.40
20X2: = 250,000
600,000 ≈0.42
Step 2: Calculate the Return on Assets (ROA).
ROA = Net income
Total assets
20X1: = 50,000
500,000 = 0.10 = 10%
20X2: = 70,000
600,000 ≈0.12 = 12%
Step 3: Calculate the Return on Equity (ROE).
ROE = Net income
Total equity
Total equity = Total assets −Total liabilities
20X1: = 50,000
500,000 −200,000 =50,000
300,000 ≈0.17 = 17%
20X2: = 70,000
600,000 −250,000 =70,000
350,000 = 0.20 = 20%
Question 20
Question
The following information pertains to Company XYZ for the years 2020 and
2021:
Item 2020 2021
Net Sales
$
500,000
$
600,000
Cost of Goods Sold
$
350,000
$
420,000
Gross Profit
$
150,000
$
180,000
Operating Expenses
$
80,000
$
90,000
Net Income
$
50,000
$
60,000
Total Assets
$
600,000
$
700,000
Total Liabilities
$
200,000
$
250,000
Calculate the following for Company XYZ for the years 2020 and 2021:
25
a) Gross profit margin
b) Net profit margin
c) Return on total assets
d) Debt to equity ratio
Solution
a) To calculate the gross profit margin, we use the formula:
Gross Profit Margin = Gross Profit
Net Sales ×100%
Step 1: Calculate the gross profit margin for 2020 and 2021.
For 2020:
Gross Profit Margin (2020) = 150,000
500,000 ×100% = 30%
For 2021:
Gross Profit Margin (2021) = 180,000
600,000 ×100% = 30%
b) To calculate the net profit margin, we use the formula:
Net Profit Margin = Net Income
Net Sales ×100%
Step 2: Calculate the net profit margin for 2020 and 2021.
For 2020:
Net Profit Margin (2020) = 50,000
500,000 ×100% = 10%
For 2021:
Net Profit Margin (2021) = 60,000
600,000 ×100% = 10%
c) To calculate the return on total assets, we use the formula:
Return on Total Assets = Net Income
Total Assets ×100%
Step 3: Calculate the return on total assets for 2020 and 2021.
For 2020:
Return on Total Assets (2020) = 50,000
600,000 ×100% ≈8.33%
For 2021:
Return on Total Assets (2021) = 60,000
700,000 ×100% ≈8.57%
26
d) To calculate the debt to equity ratio, we use the formula:
Debt to Equity Ratio = Total Liabilities
Total Equity
Step 4: Calculate the debt to equity ratio for 2020 and 2021.
For 2020:
Debt to Equity Ratio (2020) = 200,000
600,000 = 0.33
For 2021:
Debt to Equity Ratio (2021) = 250,000
700,000 ≈0.36
Question 21
Question
The following is the income statement for Company XYZ for the years 20X1
and 20X2:
Item 20X1 20X2
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
Calculate the following ratios for Company XYZ for the years 20X1 and
20X2: 1. Gross Profit Margin 2. Operating Margin 3. Net Profit Margin
Solution
Step 1: Calculate the Gross Profit Margin
For year 20X1:
Gross Profit Margin20X1=Gross Profit20X1
Revenue20X1
×100%
Gross Profit Margin20X1=$200,000
$500,000 ×100% = 40%
For year 20X2:
Gross Profit Margin20X2=Gross Profit20X2
Revenue20X2
×100%
Gross Profit Margin20X2=$250,000
$600,000 ×100% ≈41.67%
27
Step 2: Calculate the Operating Margin
For year 20X1:
Operating Margin20X1=Operating Income20X1
Revenue20X1
×100%
Operating Margin20X1=($200,000 −$120,000)
$500,000 ×100% = 16%
For year 20X2:
Operating Margin20X2=Operating Income20X2
Revenue20X2
×100%
Operating Margin20X2=($250,000 −$140,000)
$600,000 ×100% = 18.33%
Step 3: Calculate the Net Profit Margin
For year 20X1:
Net Profit Margin20X1=Net Income20X1
Revenue20X1
×100%
Net Profit Margin20X1=$80,000
$500,000 ×100% = 16%
For year 20X2:
Net Profit Margin20X2=Net Income20X2
Revenue20X2
×100%
Net Profit Margin20X2=$110,000
$600,000 ×100% ≈18.33%
Question 22
Question
Assume you are analyzing the financial statements of two companies, Company
A and Company B. You notice that Company A has a higher profit margin
compared to Company B. What factors could explain this difference in profit
margins between the two companies?
28
Solution
To explain the difference in profit margins between Company A and Company
B, we need to consider various factors that could impact profitability. Here are
some possible reasons for the difference:
1. Revenue Levels: Company A may have higher revenue levels compared
to Company B, resulting in a higher profit margin even if their expenses
are similar.
2. Cost Structure: Company A may have a more efficient cost structure,
with lower costs of goods sold, operating expenses, or interest expenses,
compared to Company B.
3. Operating Efficiency: Company A may have higher operating efficiency
in terms of production processes, inventory management, or supply chain
management, leading to lower costs and higher profits.
4. Product Mix: Company A may have a more profitable product mix, with
higher-margin products contributing a larger share of revenue compared
to Company B.
5. Economies of Scale: Company A may benefit from economies of scale,
operating at a larger scale that allows them to spread fixed costs over a
larger output, resulting in higher profitability.
6. Debt Levels: Company A may have lower debt levels or more favorable
debt terms, leading to lower interest expenses and higher profitability
compared to Company B.
Considering these factors can help in understanding why Company A has a
higher profit margin compared to Company B. Additionally, a detailed financial
analysis of both companies’ income statements, balance sheets, and cash flow
statements would provide further insights into the reasons behind the difference
in profit margins.
Question 23
Question
The following data is extracted from the comparative financial statements of
Company XYZ for the years ending December 31, 20X2 and 20X1:
Item 20X2 20X1
Sales $500,000 $400,000
Costof GoodsSold $200,000 $150,000
GrossP rofit $300,000 $250,000
OperatingExpenses $120,000 $100,000
NetIncome $100,000 $80,000
29
Calculate the following ratios based on the given data for Company XYZ for
the years 20X2 and 20X1: 1. Gross Profit Margin 2. Operating Profit Margin
3. Net Profit Margin
Solution
Step 1: Calculate the Gross Profit Margin
Gross Profit Margin = Gross Profit
Sales ×100%
20X2: = 300,000
500,000×100% = 60%
20X1: = 250,000
400,000×100% = 62.5%
Step 2: Calculate the Operating Profit Margin
Operating Profit Margin = Operating Income
Sales ×100%
20X2: = 180,000
500,000×100% = 36%
20X1: = 150,000
400,000×100% = 37.5%
Step 3: Calculate the Net Profit Margin
Net Profit Margin = Net Income
Sales ×100%
20X2: = 100,000
500,000×100% = 20%
20X1: = 80,000
400,000×100% = 20%
Question 24
Question
Company XYZ and Company ABC are two competitors in the same industry.
You have been provided with their financial statements for the past three years.
Perform a comparative financial statement analysis for both companies and
identify which company seems to be in a better financial position. Justify your
answer with relevant financial ratios and trends.
30
Solution
To compare the financial performance of Company XYZ and Company ABC,
we will analyze their financial statements for the past three years and calculate
key financial ratios.
Step 1: Gather Financial Statements First, we need to gather the
income statements and balance sheets of Company XYZ and Company ABC
for the past three years.
Step 2: Calculate Financial Ratios Next, we will calculate key financial
ratios such as profitability ratios, liquidity ratios, and solvency ratios for both
companies. Some important ratios to consider include:
1. Profitability Ratios: - Return on Assets (ROA) - Return on Equity (ROE)
2. Liquidity Ratios: - Current Ratio - Quick Ratio
3. Solvency Ratios: - Debt-to-Equity Ratio
Step 3: Analyze Trends After calculating the financial ratios for both
companies, we will analyze the trends over the past three years. It is important
to look for any consistent patterns or changes in the ratios.
Step 4: Compare Companies Based on the financial ratios and trends
identified, we can compare Company XYZ and Company ABC to determine
which company seems to be in a better financial position. This comparison
should be supported with the calculated ratios and trends analysis.
By following these steps, we can perform a comprehensive comparative fi-
nancial statement analysis of Company XYZ and Company ABC to assess their
financial performance and determine which company is in a better financial
position.
Question 25
Question
The financial statements of Company X for the current and previous year are
given below:
Current Year
Net sales:
$
500,000
Cost of goods sold:
$
300,000
Operating expenses:
$
100,000
Net income:
$
40,000
Previous Year
Net sales:
$
450,000
Cost of goods sold:
$
270,000
Operating expenses:
$
95,000
31
Net income:
$
35,000
Calculate and analyze the following ratios for both years:
Gross profit margin
Operating profit margin
Net profit margin
Solution
Step 1: Calculate the ratios for the current year.
Gross profit margin:
Gross profit margin = 1−Cost of goods sold
Net sales ×100%
Gross profit margin = 1−300,000
500,000×100% = 40%
Operating profit margin:
Operating profit margin = 1−Operating expenses
Net sales ×100%
Operating profit margin = 1−100,000
500,000×100% = 80%
Net profit margin:
Net profit margin = 1−Net income
Net sales ×100%
Net profit margin = 1−40,000
500,000×100% = 92%
Step 2: Calculate the ratios for the previous year.
Gross profit margin:
Gross profit margin = 1−270,000
450,000×100% = 40%
Operating profit margin:
Operating profit margin = 1−95,000
450,000×100% = 78.89%
32
Net profit margin:
Net profit margin = 1−35,000
450,000×100% = 92.22%
Step 3: Analyze the ratios for both years.
The gross profit margin remained the same at 40% for both years.
The operating profit margin increased from 78.89% to 80%.
The net profit margin also increased from 92.22% to 92%.
These ratios suggest that Company X improved its operational efficiency
and profitability in the current year compared to the previous year.
Question 26
Question
Company A and Company B are both in the same industry. You are provided
with the following information from their financial statements:
Company A:
Revenue:
$
800,000
Cost of Goods Sold:
$
350,000
Operating Expenses:
$
200,000
Net Income:
$
150,000
Company B:
Revenue:
$
1,200,000
Cost of Goods Sold:
$
500,000
Operating Expenses:
$
300,000
Net Income:
$
250,000
Compare the profitability of Company A and Company B using relevant
financial ratios and explain which company is more profitable.
33
Solution
To compare the profitability of Company A and Company B, we will calculate
the following financial ratios: gross profit margin, operating profit margin, and
net profit margin.
Step 1: Calculate Gross Profit Margin
Gross Profit Margin = 1−Cost of Goods Sold
Revenue ×100%
Company A:
Gross Profit Margin A = 1−350,000
800,000×100% = 56.25%
Company B:
Gross Profit Margin B = 1−500,000
1,200,000×100% = 58.33%
Step 2: Calculate Operating Profit Margin
Operating Profit Margin = 1−Operating Expenses
Revenue ×100%
Company A:
Operating Profit Margin A = 1−200,000
800,000×100% = 75%
Company B:
Operating Profit Margin B = 1−300,000
1,200,000×100% = 75%
Step 3: Calculate Net Profit Margin
Net Profit Margin = 1−Net Income
Revenue ×100%
Company A:
Net Profit Margin A = 1−150,000
800,000×100% = 81.25%
Company B:
Net Profit Margin B = 1−250,000
1,200,000×100% = 79.17%
Conclusion: Company A has a slightly higher gross profit margin and net
profit margin compared to Company B. However, both companies have the same
operating profit margin. Overall, Company A is more profitable than Company
B based on the calculated financial ratios.
34
Question 27
Question
The following data is extracted from the financial statements of two companies,
Company A and Company B, for the year ended December 31, 2020:
Item Company A Company B
Sales
$
500,000
$
750,000
Cost of Goods Sold
$
200,000
$
300,000
Gross Profit
$
300,000
$
450,000
Operating Expenses
$
150,000
$
200,000
Net Income
$
150,000
$
250,000
Assuming all other factors are consistent, analyze and compare the financial
performance of Company A and Company B.
Solution
Step 1: Calculate the Gross Profit Margin The Gross Profit Margin is
calculated as:
Gross Profit Margin = Gross Profit
Sales ×100%
For Company A:
Gross Profit MarginA=300,000
500,000 ×100% = 60%
For Company B:
Gross Profit MarginB=450,000
750,000 ×100% = 60%
Step 2: Analyze the Gross Profit Margin Both companies have the
same Gross Profit Margin of 60%, indicating that both companies are able to
generate equivalent gross profit as a percentage of sales.
Step 3: Calculate the Operating Profit Margin The Operating Profit
Margin is calculated as:
Operating Profit Margin = Operating Income
Sales ×100%
For Company A:
Operating Profit MarginA=150,000
500,000 ×100% = 30%
For Company B:
Operating Profit MarginB=250,000
750,000 ×100% = 33.33%
35
Step 4: Analyze the Operating Profit Margin Company B has a
higher Operating Profit Margin of 33.33% compared to Company A’s 30%. This
indicates that Company B is more efficient in managing its operating expenses
relative to its sales.
Step 5: Compare the Net Income Company B has a higher net income
of
$
250,000 compared to Company A’s
$
150,000. This suggests that Company
B is more profitable after accounting for all expenses.
In conclusion, Company B outperforms Company A in terms of operating
efficiency and overall profitability.
Question 28
Question
The financial statements of two companies, Company A and Company B, are
provided below. Use this information to analyze and compare the financial
performance of the two companies.
Company A:
Item Amount (in
$
) % of Sales
Sales 500,000 100%
Cost of Goods Sold 300,000 60%
Gross Profit 200,000 40%
Operating Expenses 120,000 24%
Net Income 80,000 16%
Company B:
Item Amount (in
$
) % of Sales
Sales 800,000 100%
Cost of Goods Sold 440,000 55%
Gross Profit 360,000 45%
Operating Expenses 160,000 20%
Net Income 200,000 25%
Based on the information provided, analyze and compare the financial per-
formance of Company A and Company B.
Solution
Step 1: Calculate Operating Income
For Company A: Operating Income = Gross Profit - Operating Expenses
OperatingIncome = $200,000 −$120,000 = $80,000
For Company B: Operating Income = Gross Profit - Operating Expenses
OperatingIncome = $360,000 −$160,000 = $200,000
36
Step 2: Compare Profitability Ratios
Profit Margin for Company A:
P rofitMargin =NetIncome
Sales ×100% = $80,000
$500,000 ×100% = 16%
Profit Margin for Company B:
P rofitMargin =NetIncome
Sales ×100% = $200,000
$800,000 ×100% = 25%
Step 3: Analyze Cost Management
Company B has a lower cost of goods sold as a percentage of sales, indi-
cating better cost management compared to Company A.
Step 4: Evaluate Operating Efficiency
Company B has a higher operating income and operating margin, sug-
gesting better operating efficiency compared to Company A.
In conclusion, Company B outperforms Company A in terms of profitability,
cost management, and operating efficiency based on the given financial state-
ments.
Question 29
Question
Company XYZ has provided the following financial information for Year 2 and
Year 1:
Year 2 Year 1
Revenue
$
500,000
$
400,000
Cost of Goods Sold
$
250,000
$
200,000
Gross Profit
$
250,000
$
200,000
Operating Expenses
$
100,000
$
80,000
Net Income
$
120,000
$
90,000
Total Assets
$
600,000
$
500,000
Calculate the following financial ratios for Company XYZ for Year 2:
1. Gross Profit Margin
2. Operating Profit Margin
3. Return on Assets
37
Solution
Step 1: Calculate Gross Profit Margin
Gross Profit Margin = Revenue −Cost of Goods Sold
Revenue ×100%
Gross Profit Margin = $500,000 −$250,000
$500,000 ×100%
Gross Profit Margin = $250,000
$500,000×100%
Gross Profit Margin = 0.5×100%
Gross Profit Margin = 50%
Step 2: Calculate Operating Profit Margin
Operating Profit Margin = Revenue −Operating Expenses
Revenue ×100%
Operating Profit Margin = $500,000 −$100,000
$500,000 ×100%
Operating Profit Margin = $400,000
$500,000×100%
Operating Profit Margin = 0.8×100%
Operating Profit Margin = 80%
Step 3: Calculate Return on Assets
Return on Assets = Net Income
Total Assets×100%
Return on Assets = $120,000
$600,000×100%
Return on Assets = 0.2×100%
Return on Assets = 20%
Question 30
Question
The following data is extracted from the financial statements of two companies,
A and B:
38
Item Company A Company B
Revenue
$
500,000
$
650,000
Cost of Goods Sold
$
200,000
$
300,000
Operating Expenses
$
100,000
$
120,000
Interest Expense
$
20,000
$
15,000
Income Tax Expense
$
50,000
$
60,000
Compare the profitability of Companies A and B by calculating their gross
profit margin, operating profit margin, and net profit margin. Interpret your
results.
Solution
Step 1: Calculate the gross profit, operating profit, and net profit for Companies
A and B.
Company A: Gross Profit = Revenue - Cost of Goods Sold =
$
500,000
-
$
200,000 =
$
300,000
Operating Profit = Gross Profit - Operating Expenses =
$
300,000 -
$
100,000
=
$
200,000
Net Profit = Operating Profit - Interest Expense - Income Tax Expense
=
$
200,000 -
$
20,000 -
$
50,000 =
$
130,000
Company B: Gross Profit = Revenue - Cost of Goods Sold =
$
650,000
-
$
300,000 =
$
350,000
Operating Profit = Gross Profit - Operating Expenses =
$
350,000 -
$
120,000
=
$
230,000
Net Profit = Operating Profit - Interest Expense - Income Tax Expense
=
$
230,000 -
$
15,000 -
$
60,000 =
$
155,000
Step 2: Calculate the gross profit margin, operating profit margin, and net
profit margin for Companies A and B.
Company A: Gross Profit Margin = Gross Profit
Revenue ×100% = 300,000
500,000 ×
100% = 60%
Operating Profit Margin = Operating Profit
Revenue ×100% = 200,000
500,000 ×100% = 40%
Net Profit Margin = Net Profit
Revenue ×100% = 130,000
500,000 ×100% = 26%
Company B: Gross Profit Margin = Gross Profit
Revenue ×100% = 350,000
650,000 ×
100% ≈53.85%
Operating Profit Margin = Operating Profit
Revenue ×100% = 230,000
650,000 ×100% ≈
35.38%
Net Profit Margin = Net Profit
Revenue ×100% = 155,000
650,000 ×100% ≈23.85%
Step 3: Interpretation of results
Company A has higher profitability margins across all levels compared to
Company B. Company A has a higher gross profit margin (60
39
Question 31
Question
A company experienced a decrease in net income from $750,000 to $600,000 over
the past year. At the same time, the company’s operating expenses increased
from $400,000 to $450,000. Analyze the impact of this change on the company’s
profit margin and provide an explanation.
Solution
Step 1: Calculate the initial profit margin. To calculate the initial profit margin,
we use the formula:
Profit Margin = Net Income
Total Revenue ×100%
Given that the initial net income was $750,000, we need to find the total
revenue. Since profit margin is not affected by operating expenses, we can
assume that net income is the same as operating income. Therefore, the total
revenue can be calculated as:
Total Revenue = Operating Income+Operating Expenses = 750,000+400,000 = 1,150,000
Now, we can calculate the initial profit margin:
Initial Profit Margin = 750,000
1,150,000 ×100% ≈65.22%
Step 2: Calculate the final profit margin. Using the same formula as above,
we calculate the final profit margin with the new net income of $600,000:
Final Profit Margin = 600,000
1,200,000 ×100% = 50%
Step 3: Analyze the impact. By comparing the initial profit margin of
approximately 65.22% to the final profit margin of 50%, we can see that the
profit margin decreased by about 15.22%.
The decrease in profit margin is primarily due to the increase in operating
expenses from $400,000 to $450,000. This means that for every dollar the com-
pany earns, it is spending a larger portion on operating expenses, which results
in a lower profit margin. In other words, the company’s efficiency in converting
revenue into profit has decreased, indicating a less profitable operation.
Question 32
Question
Company XYZ has provided you with the following income statement data for
two consecutive years:
40
Item Year 1 Year 2
Sales $500,000 $600,000
Costof GoodsSold $300,000 $360,000
GrossP rofit $200,000 $240,000
OperatingExpenses $100,000 $120,000
NetIncome $100,000 $120,000
Compute and discuss the following financial ratios for both years: 1. Gross
profit margin 2. Operating profit margin 3. Net profit margin
Solution
Step 1: Calculate the financial ratios for Year 1.
Gross Profit Margin for Year 1 = Gross ProfitYear 1
SalesYear 1
×100%
Operating Profit Margin for Year 1 = Operating ProfitYear 1
SalesYear 1
×100%
Net Profit Margin for Year 1 = Net IncomeYear 1
SalesYear 1
×100%
Now, calculate these financial ratios:
Gross Profit Margin for Year 1 = $200,000
$500,000 ×100% = 40%
Operating Profit Margin for Year 1 = $100,000
$500,000 ×100% = 20%
Net Profit Margin for Year 1 = $100,000
$500,000 ×100% = 20%
Step 2: Calculate the financial ratios for Year 2.
Gross Profit Margin for Year 2 = Gross ProfitYear 2
SalesYear 2
×100%
Operating Profit Margin for Year 2 = Operating ProfitYear 2
SalesYear 2
×100%
Net Profit Margin for Year 2 = Net IncomeYear 2
SalesYear 2
×100%
Now, calculate these financial ratios:
Gross Profit Margin for Year 2 = $240,000
$600,000 ×100% = 40%
Operating Profit Margin for Year 2 = $120,000
$600,000 ×100% = 20%
Net Profit Margin for Year 2 = $120,000
$600,000 ×100% = 20%
Step 3: Discussion
The gross profit margin remained constant at 40
The operating profit margin also remained constant at 20
The net profit margin also remained constant at 20
In summary, all three financial ratios remained stable from Year 1 to Year
2 for Company XYZ.
41
Question 33
Question
Company ABC and Company XYZ are two competitors in the same industry.
Below are selected financial data for both companies for Year 2 and Year 1:
Company ABC
Year 2 Year 1
Sales
$
500,000
$
400,000
Cost of Goods Sold
$
300,000
$
240,000
Net Income
$
80,000
$
60,000
Company XYZ
Year 2 Year 1
Sales
$
600,000
$
500,000
Cost of Goods Sold
$
360,000
$
300,000
Net Income
$
120,000
$
80,000
Comparatively analyze the financial performance of both companies using
the information provided.
Solution
Step 1: Calculate the Gross Profit Margin for Company ABC and Company
XYZ for Year 2 and Year 1.
Company ABC Gross Profit Margin:
For Year 2:
Gross Profit Margin = 1−Cost of Goods Sold
Sales ×100%
Gross Profit Margin = 1−300,000
500,000×100%
Gross Profit Margin = (1 −0.6) ×100%
Gross Profit Margin = 0.4×100%
Gross Profit Margin = 40%
For Year 1:
Gross Profit Margin = 1−240,000
400,000×100%
Gross Profit Margin = (1 −0.6) ×100%
Gross Profit Margin = 0.4×100%
Gross Profit Margin = 40%
Company XYZ Gross Profit Margin:
42
For Year 2:
Gross Profit Margin = 1−360,000
600,000×100%
Gross Profit Margin = (1 −0.6) ×100%
Gross Profit Margin = 0.4×100%
Gross Profit Margin = 40%
For Year 1:
Gross Profit Margin = 1−300,000
500,000×100%
Gross Profit Margin = (1 −0.6) ×100%
Gross Profit Margin = 0.4×100%
Gross Profit Margin = 40%
Step 2: Interpretation
Both Company ABC and Company XYZ have the same Gross Profit Margin
of 40% in both Year 2 and Year 1. This indicates that both companies are
efficient in managing their production costs relative to their sales.
Step 3: Calculate the Net Profit Margin for Company ABC and Company
XYZ for Year 2 and Year 1.
Company ABC Net Profit Margin:
For Year 2:
Net Profit Margin = Net Income
Sales ×100%
Net Profit Margin = 80,000
500,000×100%
Net Profit Margin = 0.16 ×100%
Net Profit Margin = 16%
For Year 1:
Net Profit Margin = 60,000
400,000
43
Question 34
Question
Company XYZ is analyzing its financial statements for the past three years to
assess its financial performance and position. Using the comparative financial
statement analysis method, calculate the following ratios for Company XYZ
based on the given information:
Year 2019 2020 2021
Net Sales
$
500,000
$
600,000
$
700,000
Gross Profit
$
250,000
$
300,000
$
350,000
Net Income
$
100,000
$
120,000
$
140,000
Total Assets
$
800,000
$
900,000
$
1,000,000
Total Liabilities
$
400,000
$
450,000
$
500,000
Calculate the following ratios:
1. Gross Profit Margin
2. Net Profit Margin
3. Return on Assets
4. Return on Equity
Solution
Step 1: Calculate Gross Profit Margin
Gross Profit Margin = Gross Profit
Net Sales ×100%
Year 2019:
Gross Profit Margin2019 =250,000
500,000×100% = 50%
Year 2020:
Gross Profit Margin2020 =300,000
600,000×100% = 50%
Year 2021:
Gross Profit Margin2021 =350,000
700,000×100% = 50%
Step 2: Calculate Net Profit Margin
Net Profit Margin = Net Income
Net Sales ×100%
44
Year 2019:
Net Profit Margin2019 =100,000
500,000×100% = 20%
Year 2020:
Net Profit Margin2020 =120,000
600,000×100% = 20%
Year 2021:
Net Profit Margin2021 =140,000
700,000×100% = 20%
Step 3: Calculate Return on Assets
Return on Assets = Net Income
Total Assets×100%
Year 2019:
Return on Assets2019 =100,000
800,000×100% = 12.5%
Year 2020:
Return on Assets2020 =120,000
900,000×100% ≈13.33%
Year 2021:
Return on Assets2021 =140,000
1,000,000×100% = 14%
Step 4: Calculate Return on Equity
Return on Equity = Net Income
Total Equity×100%
To calculate Total Equity, we use the formula:
Total Equity = Total Assets −Total Liabilities
Year 2019:
Total Equity2019 =
45
Question 35
Question
The financial statements of two companies, Company A and Company B, are
provided below:
Company A
Year Net Income (in
$
)
Year 1 150,000
Year 2 175,000
Year 3 200,000
Company B
Year Net Income (in
$
)
Year 1 100,000
Year 2 125,000
Year 3 200,000
Given this information, analyze and compare the profitability trends of both
companies over the three-year period.
Solution
Step 1: Compute the percentage change in net income for each com-
pany
To calculate the percentage change in net income, we will use the formula:
Percentage Change = New Value - Old Value
Old Value ×100.
For Company A:
Percentage change from Year 1 to Year 2: 175,000−150,000
150,000 ×100 ≈16.67%
Percentage change from Year 2 to Year 3: 200,000−175,000
175,000 ×100 ≈14.29%
For Company B:
Percentage change from Year 1 to Year 2: 125,000−100,000
100,000 ×100 = 25%
Percentage change from Year 2 to Year 3: 200,000−125,000
125,000 ×100 = 60%
Step 2: Analyze the profitability trends
From the calculations, we see that Company A has a steady increase in net
income over the three-year period, with percentage changes of approximately
16.67
On the other hand, Company B experienced a more significant increase in
profitability, with percentage changes of 25
Therefore, Company B has a more aggressive growth in profitability com-
pared to Company A over the three-year period.
46
Question 4
Question
Company X and Company Y are two competitors in the same industry. The
following financial information is available for both companies:
Company X:
Net Income:
$
500,000
Total Assets:
$
3,000,000
Total Liabilities:
$
1,200,000
Company Y:
Net Income:
$
800,000
Total Assets:
$
5,000,000
Total Liabilities:
$
2,500,000
Compare the financial performance of Company X and Company Y based
on the Return on Assets (ROA) ratio. Which company seems to be utilizing its
assets more efficiently?
Solution
Step 1: Calculate the Return on Assets (ROA) ratio for Company X and Com-
pany Y.
The formula for ROA is:
ROA =Net Income
T otal Assets ×100%
For Company X:
ROAX=500,000
3,000,000 ×100% = 1
6×100% = 16.67%
For Company Y:
ROAY=800,000
5,000,000 ×100% = 4
25 ×100% = 16%
Step 2: Compare the ROA for both companies.
Company X has an ROA of 16.67
5
Question 5
Question
You are given the following financial information for Company X and Company
Y:
Company X
Net Income:
$
500,000
Total Assets:
$
2,000,000
Total Liabilities:
$
800,000
Equity:
$
1,200,000
Company Y
Net Income:
$
400,000
Total Assets:
$
1,500,000
Total Liabilities:
$
600,000
Equity:
$
900,000
Determine which company is more profitable and has a stronger financial
position based on this information.
Solution
To compare the profitability and financial position of Company X and Company
Y, we will analyze their financial ratios.
Step 1: Calculate Return on Assets (ROA)
ROA is a profitability ratio that shows how efficiently a company is using
its assets to generate profit.
ROA = Net Income
Total Assets
Company X:
ROAX=$500,000
$2,000,000 = 0.25 or 25%
Company Y:
ROAY=$400,000
$1,500,000 ≈0.2667 or 26.67%
Step 2: Calculate Return on Equity (ROE)
6
ROE is a profitability ratio that indicates how well a company is utilizing
its shareholders’ equity to generate profit.
ROE = Net Income
Equity
Company X:
ROEX=$500,000
$1,200,000 ≈0.4167 or 41.67%
Company Y:
ROEY=$400,000
$900,000 ≈0.4444 or 44.44%
Step 3: Analyze the Results
Based on the calculated ratios, Company Y is slightly more profitable than
Company X as it has a higher ROA and ROE. However, financial position also
depends on the level of risk and liquidity, which can be further analyzed using
additional financial ratios.
Question 6
Question
The following data was gathered from the comparative financial statements of
Company XYZ:
Ratio Year 1 Year 2
Current Ratio 2.5 3.0
Quick Ratio 1.5 1.8
Debt to Equity Ratio 0.6 0.8
Net Profit Margin 15% 12%
Return on Equity 20% 18%
Based on this information, analyze the financial performance of Company
XYZ between Year 1 and Year 2.
Solution
Step 1: Current Ratio Analysis
The current ratio is a liquidity ratio that measures a company’s ability to
meet its short-term obligations.
The current ratio can be calculated as:
Current Ratio = Current Assets
Current Liabilities
7
In Year 1:
Current Ratio (Year 1) = 2.5
1= 2.5
In Year 2:
Current Ratio (Year 2) = 3.0
1= 3.0
The increase in the current ratio from 2.5 in Year 1 to 3.0 in Year 2 indicates
an improvement in the company’s liquidity position.
Step 2: Quick Ratio Analysis
The quick ratio is a more stringent measure of liquidity as it excludes inven-
tory from current assets.
The quick ratio can be calculated as:
Quick Ratio = Current Assets −Inventory
Current Liabilities
In Year 1:
Quick Ratio (Year 1) = 2.5−1
1= 1.5
In Year 2:
Quick Ratio (Year 2) = 3.0−1
1= 1.8
The increase in the quick ratio from 1.5 in Year 1 to 1.8 in Year 2 also
indicates an improvement in the company’s liquidity position.
Step 3: Debt to Equity Ratio Analysis
The debt to equity ratio measures the company’s financial leverage and risk.
The debt to equity ratio can be calculated as:
Debt to Equity Ratio = Total Debt
Shareholders’ Equity
In Year 1:
Debt to Equity Ratio (Year 1) = 0.6
In Year 2:
Debt to Equity Ratio (Year 2) = 0.8
The increase in the debt to equity ratio from 0.6 in Year 1 to 0.8 in Year
2 indicates that the company took on more debt relative to equity, which may
increase financial risk.
Step 4: Net Profit Margin Analysis
The net profit margin measures the company’s profitability.
The net profit margin can be calculated as:
Net Profit Margin = Net Profit
Revenue ×100%
In Year 1:
Net Profit Margin (Year 1) = 15%
8
In Year 2:
Net Profit Margin (Year 2) = 12%
The decrease in the net profit margin from 15% in Year 1 to 12% in Year 2
indicates a decrease in profitability.
Step 5: Return on Equity Analysis
The return on equity measures the return earned on the shareholders’ equity.
The return on equity can be calculated as:
Return on Equity = Net Income
Average Shareholders’ Equity ×100%
In Year 1:
Return on Equity (Year 1) = 20%
In Year 2:
Return on Equity (Year 2) = 18%
The decrease in the return on equity from 20% in Year 1 to 18% in Year 2
indicates a decrease in the return
Question 7
Question
Company A and Company B are both in the same industry. Company A’s cur-
rent ratio decreased from 2.5 to 1.8, while Company B’s current ratio increased
from 1.6 to 1.9. Discuss the implications of these changes in the context of
comparative financial statement analysis.
Solution
To analyze the implications of the changes in current ratios for Company A and
Company B, we need to consider the liquidity position of each company.
Step 1: Understand the Current Ratio The current ratio is calculated
as:
Current Ratio = Current Assets
Current Liabilities
This ratio indicates a company’s ability to pay its short-term obligations
with its short-term assets.
Step 2: Analyze Company A’s Current Ratio Change Company A’s
current ratio decreased from 2.5 to 1.8. This implies that Company A’s current
liabilities have increased relative to its current assets. The decrease in current
ratio may indicate potential liquidity issues for Company A. It could mean that
Company A is struggling to meet its short-term obligations with its current
assets.
9
Step 3: Analyze Company B’s Current Ratio Change Company B’s
current ratio increased from 1.6 to 1.9. This increase suggests that Company
B’s current assets have increased relative to its current liabilities. The higher
current ratio indicates improved liquidity position for Company B. It implies
that Company B is in a better position to cover its short-term liabilities with
its current assets.
Step 4: Comparative Analysis Comparing the changes in current ratios
for Company A and Company B, we can infer that Company B has shown better
performance in managing its liquidity compared to Company A. Company B’s
increased current ratio indicates a stronger liquidity position, while Company
A’s decreased current ratio raises concerns about its ability to meet short-term
obligations. This analysis suggests that Company B may be in a more favorable
financial position compared to Company A in terms of liquidity.
Question 8
Question
Company X and Company Y are two competing companies in the same in-
dustry. You have been provided with their financial statements for the past
three years. Compare their financial performance using horizontal and vertical
analysis. Discuss any trends or significant differences that you observe.
Solution
To compare the financial performance of Company X and Company Y, we will
conduct both horizontal analysis (comparing line items across the years) and
vertical analysis (comparing line items within a single year).
Horizontal Analysis:
Step 1: Calculate the percentage change for key line items for each com-
pany over the past three years.
Step 2: Compare the percentage changes for Company X and Company Y
to identify any significant differences in their financial performance trends.
Vertical Analysis:
Step 1: Calculate the percentage of each line item relative to a base item
(usually total revenue or total assets) within each year for both companies.
Step 2: Compare the vertical analysis percentages between Company X
and Company Y to identify any significant differences in their financial
structure.
After conducting both horizontal and vertical analysis for Company X and
Company Y, we will be able to identify trends, strengths, weaknesses, and
differences in their financial performance and financial structures.
10
Question 9
Question
Company XYZ provides you with the following financial information for the
years 2019 and 2020:
2019 2020
Net Sales
$
500,000
$
600,000
Cost of Goods Sold
$
300,000
$
350,000
Operating Expenses
$
80,000
$
90,000
Interest Expense
$
10,000
$
12,000
Income Tax Expense
$
15,000
$
18,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 = Net Sales−Cost of Goods Sold
Net Sales ×100%
For 2019:
Gross Profit Margin2019 =$500,000 −$300,000
$500,000 ×100% = 40%
For 2020:
Gross Profit Margin2020 =$600,000 −$350,000
$600,000 ×100% = 41.67%
Step 2: Calculate Operating Profit Margin
Operating Profit Margin = Net Sales−Cost of Goods Sold−Operating Expenses
Net Sales ×
100%
For 2019:
Operating Profit Margin2019 =$500,000 −$300,000 −$80,000
$500,000 ×100% = 24%
For 2020:
Operating Profit Margin2020 =$600,000 −$350,000 −$90,000
$600,000 ×100% = 21.67%
Step 3: Calculate Net Profit Margin
11
Net Profit Margin = Net Income
Net Sales ×100%
To calculate net income, we need to subtract interest expense and income
tax expense from operating profit.
For 2019:
Net Income2019 = $500,000−$300,000−$80,000−$10,000−$15,000 = $95,000
Net Profit Margin2019 =$95,000
$500,000 ×100% = 19%
For 2020:
Net Income2020 = $600,000−$350,000−$90,000−$12,000−$18,000 = $140,000
Net Profit Margin2020 =$140,000
$600,000 ×100% = 23.33%
Therefore, the calculated ratios for Company XYZ for the years 2019 and
2020 are as follows:
1. Gross Profit Margin: 40
2. Operating Profit Margin: 24
3. Net Profit Margin: 19
Question 10
Question
Company X and Company Y are two competitors in the same industry. Evaluate
and compare Company X and Company Y’s financial performance using the
following financial ratios:
Profit Margin
Return on Assets (ROA)
Debt-to-Equity Ratio
Current Ratio
Use the information provided in the financial statements of both companies to
calculate these ratios and provide an analysis based on your calculations.
12
Solution
Step 1: Calculate Profit Margin
Profit Margin = (Net Income / Revenue) * 100%
Step 2: Calculate Return on Assets (ROA)
ROA = (Net Income / Average Total Assets) * 100%
Step 3: Calculate Debt-to-Equity Ratio
Debt-to-Equity Ratio = Total Debt / Total Equity
Step 4: Calculate Current Ratio
Current Ratio = Current Assets / Current Liabilities
Step 5: Analysis
Compare Company X and Company Y’s profit margins to see which com-
pany is more efficient in generating profit from its revenue.
Calculate and compare the return on assets to determine which company
is more effective in generating profit from its assets.
Analyze the debt-to-equity ratio to assess the financial risk of each com-
pany.
Lastly, compare the current ratios of both companies to evaluate their
liquidity positions.
Based on the calculations and analysis of these financial ratios, you can
provide a comprehensive comparative analysis of the financial performance of
Company X and Company Y in the industry.
Question 11
Question
Assume you are a financial analyst analyzing two companies, Company A and
Company B. You are reviewing their financial statements and notice the follow-
ing information for both companies:
Company A had a higher net income than Company B in the current year.
Company B had a higher return on assets (ROA) than Company A in the
current year.
Both companies had the same total assets.
Company A had a higher return on equity (ROE) than Company B in the
current year.
Given this information, which company do you think is performing better
financially, and why?
13
Solution
To determine which company is performing better financially based on the infor-
mation provided, we need to analyze the different financial ratios and consider
how they relate to each company’s financial performance.
Step 1: Define the Ratios
Net Income: This measures the profitability of a company.
Return on Assets (ROA): This ratio shows how efficiently a company is
using its assets to generate profit.
Total Assets: The total value of a company’s assets.
Return on Equity (ROE): This ratio shows how effectively a company is
using its shareholders’ equity to generate profit.
Step 2: Analysis
Company A having a higher net income than Company B indicates that
Company A is more profitable in absolute terms.
Company B having a higher ROA means that Company B is more efficient
at using its assets to generate profit compared to Company A.
Both companies having the same total assets means they are of equal size
in terms of assets.
Company A having a higher ROE than Company B suggests that Com-
pany A is more effective at generating profit from shareholders’ equity.
Step 3: Conclusion Based on the information provided, it can be con-
cluded that Company A is performing better financially compared to Company
B. This conclusion is drawn from the fact that Company A has a higher net
income and ROE, indicating better profitability and more effective use of share-
holders’ equity. Company B’s higher ROA is important but does not outweigh
the significance of higher net income and ROE in this case.
Question 12
Question
A company reported the following financial information for two consecutive
years:
Year 1:
Net Sales:
$
500,000
Cost of Goods Sold:
$
300,000
Operating Expenses:
$
100,000
14
Year 2:
Net Sales:
$
600,000
Cost of Goods Sold:
$
350,000
Operating Expenses:
$
120,000
Perform a comparative financial statement analysis for the two years by
calculating the following ratios: 1. Gross Profit Margin 2. Operating Profit
Margin
Solution
Step 1: Calculate Gross Profit Margin
Year 1:
–Gross Profit = Net Sales - Cost of Goods Sold
–Gross Profit =
$
500,000 -
$
300,000 =
$
200,000
–Gross Profit Margin = Gross Profit
Net Sales ×100% = 200,000
500,000 ×100% = 40%
Year 2:
–Gross Profit = Net Sales - Cost of Goods Sold
–Gross Profit =
$
600,000 -
$
350,000 =
$
250,000
–Gross Profit Margin = Gross Profit
Net Sales ×100% = 250,000
600,000 ×100% = 41.67%
Step 2: Calculate Operating Profit Margin
Year 1:
–Operating Profit = Gross Profit - Operating Expenses
–Operating Profit =
$
200,000 -
$
100,000 =
$
100,000
–Operating Profit Margin = Operating Profit
Net Sales ×100% = 100,000
500,000 ×100% =
20%
Year 2:
–Operating Profit = Gross Profit - Operating Expenses
–Operating Profit =
$
250,000 -
$
120,000 =
$
130,000
–Operating Profit Margin = Operating Profit
Net Sales ×100% = 130,000
600,000 ×100% ≈
21.67%
15
Question 13
Question
Company XYZ reported the following information for two consecutive years:
Year 2 Year 1
Net Sales
$
500,000
$
450,000
Cost of Goods Sold
$
300,000
$
260,000
Operating Expenses
$
100,000
$
80,000
Income Tax Expense
$
20,000
$
15,000
Calculate the following financial ratios for both years and state whether the
company’s financial performance improved or deteriorated from Year 1 to Year
2:
1. Gross Profit Margin
2. Operating Profit Margin
3. Net Profit Margin
4. Return on Assets
5. Return on Equity
Solution
Step 1: Calculate the financial ratios for Year 1:
Gross Profit Margin = Net Sales −Cost of Goods Sold
Net Sales ×100%
=$450,000 −$260,000
$450,000 ×100%
= 42.22%
Operating Profit Margin = Operating Income −Operating Expenses
Net Sales ×100%
=$190,000 −$80,000
$450,000 ×100%
= 24.44%
Net Profit Margin = Net Income −Income Tax Expense
Net Sales ×100%
=$150,000 −$15,000
$450,000 ×100%
= 31.11%
16
Return on Assets = Net Income
Average Total Assets ×100%
= $150,000
$1,000,000+$800,000
2!×100%
= 15.79%
Return on Equity = Net Income
Average Shareholders’ Equity×100%
= $150,000
$600,000+$500,000
2!×100%
= 28.57%
Step 2: Calculate the financial ratios for Year 2:
Gross Profit Margin = $500,000 −$300,000
$500,000 ×100%
= 40.00%
Operating Profit Margin = $200,000 −$100,000
$500,000 ×100%
= 20.00%
Net Profit Margin = $180,000 −$20,000
$500,000 ×100%
= 32.00%
Return on Assets = $180,000
$1,200,000+$900,000
2!×100%
= 11.54%
Return on Equity = $180,000
$800,000+$700,000
2!×100%
= 23.08%
Step 3: Analyzing the results:
17
Question 14
Question
You are given the following income statements for Company A and Company
B:
Income Statement Company A Company B
Revenue $500,000 $700,000
Cost of Goods Sold $200,000 $350,000
Operating Expenses $100,000 $150,000
Net Income $200,000 $200,000
Which company is more profitable based on the information provided? Jus-
tify your answer.
Solution
To determine which company is more profitable, we will compare their net
income.
Step 1: Calculate the Net Profit Margin for each company.
The Net Profit Margin formula is:
Net Profit Margin = Net Income
Revenue ×100
Company A:
Net Profit Margin = 200,000
500,000×100 = 40%
Company B:
Net Profit Margin = 200,000
700,000×100 ≈28.57%
Step 2: Compare the Net Profit Margins.
Company A has a net profit margin of 40%, while Company B has a net profit
margin of approximately 28.57%. Therefore, based on the net profit margin,
Company A is more profitable than Company B. Company A generates
more profit for every dollar of revenue compared to Company B.
Question 15
Question
Company XYZ and Company ABC are both in the manufacturing industry.
The following are selected financial data for the two companies:
Company XYZ
18
Net Income:
$
500,000
Total Assets:
$
4,000,000
Total Liabilities:
$
1,500,000
Shareholders’ Equity:
$
2,500,000
Company ABC
Net Income:
$
700,000
Total Assets:
$
6,000,000
Total Liabilities:
$
2,000,000
Shareholders’ Equity:
$
4,000,000
Perform a comparative financial statement analysis for Company XYZ and
Company ABC. Analyze their profitability, liquidity, and solvency based on the
given data.
Solution
Step 1: Calculate Return on Assets (ROA) for Company XYZ and
Company ABC
ROA is a measure of profitability and is calculated as follows:
ROA =Net Income
T otal Assets ×100%
For Company XYZ:
ROAXY Z =500,000
4,000,000 ×100% = 12.5%
For Company ABC:
ROAABC =700,000
6,000,000 ×100% = 11.67%
Step 2: Calculate Return on Equity (ROE) for Company XYZ and
Company ABC
ROE is a measure of profitability and is calculated as follows:
ROE =Net Income
Shareholders′Equity ×100%
For Company XYZ:
ROEXY Z =500,000
2,500,000 ×100% = 20%
19
For Company ABC:
ROEABC =700,000
4,000,000 ×100% = 17.5%
Step 3: Calculate Current Ratio for Company XYZ and Company
ABC
The current ratio is a measure of liquidity and is calculated as follows:
Current Ratio =Current Assets
Current Liabilities
Since the current assets and liabilities are not provided, we cannot calculate
the current ratio for both companies.
Step 4: Calculate Debt-to-Equity Ratio for Company XYZ and
Company ABC
The debt-to-equity ratio is a measure of solvency and is calculated as follows:
Debt −to −Equity Ratio =T otal Liabilities
Shareholders′Equity
For Company XYZ:
Debt −to −EquityXY Z =1,500,000
2,500,000 = 0.6
For Company ABC:
Debt −to −EquityABC =2,000,000
4,000,000 = 0.5
Based on the analysis, Company XYZ has a higher ROA, ROE, and debt-
to-equity ratio compared to Company ABC, indicating better profitability and
leverage but it might have more financial risk due to higher debt levels.
Question 16
Question
Company ABC and Company XYZ are two competitors in the same industry.
The following data is extracted from their financial statements:
Financial Ratios Company ABC Company XYZ
Current Ratio 2.5 1.8
Debt-to-Equity Ratio 0.6 0.5
Return on Equity 15% 18%
Based on this information, which company appears to be in a better financial
position? Justify your answer with reasons.
20
Solution
To determine which company appears to be in a better financial position, we
will analyze each financial ratio provided.
Step 1: Current Ratio Comparison
Company ABC has a current ratio of 2.5, while Company XYZ has a
current ratio of 1.8.
The current ratio indicates a company’s ability to pay its short-term obli-
gations.
A higher current ratio is generally preferred as it suggests a stronger ability
to cover short-term liabilities.
Therefore, based on the current ratio, Company ABC appears to be in a
better financial position than Company XYZ.
Step 2: Debt-to-Equity Ratio Comparison
Company ABC has a debt-to-equity ratio of 0.6, while Company XYZ has
a debt-to-equity ratio of 0.5.
The debt-to-equity ratio measures the proportion of debt a company uses
to finance its operations relative to shareholders’ equity.
A lower debt-to-equity ratio indicates lower financial risk and a stronger
capital structure.
Therefore, based on the debt-to-equity ratio, Company XYZ appears to
be in a better financial position than Company ABC.
Step 3: Return on Equity Comparison
Company ABC has a return on equity of 15
Return on equity measures the profitability of a company in relation to
shareholders’ equity.
A higher return on equity indicates better profitability for shareholders.
Therefore, based on the return on equity, Company XYZ appears to be in
a better financial position than Company ABC.
Conclusion:
Company ABC performs better in terms of liquidity with a higher current
ratio.
Company XYZ has a stronger capital structure with a lower debt-to-equity
ratio.
21
However, Company XYZ is more profitable for its shareholders with a
higher return on equity.
In conclusion, Company XYZ appears to be in a better overall financial
position due to its better return on equity, despite having a lower current
ratio than Company ABC.
Question 17
Question
Company A and Company B are competitors in the same industry. The follow-
ing are selected financial statement data for the two companies:
Company A:
Net Income:
$
500,000
Total Assets:
$
5,000,000
Shareholders’ Equity:
$
3,000,000
Company B:
Net Income:
$
600,000
Total Assets:
$
7,000,000
Shareholders’ Equity:
$
4,000,000
Compare the profitability and financial leverage of Company A and Com-
pany B using the given financial statement data.
Solution
Step 1: Calculate Return on Assets (ROA) for both companies. ROA is calcu-
lated as net income divided by total assets.
For Company A:
ROAA=500,000
5,000,000 = 0.10 or 10%
For Company B:
ROAB=600,000
7,000,000 =6
70 ≈0.0857 or 8.57%
Step 2: Interpretation of ROA results. Company A has a higher ROA (10
Step 3: Calculate Return on Equity (ROE) for both companies. ROE is
calculated as net income divided by shareholders’ equity.
22
For Company A:
ROEA=500,000
3,000,000 =1
6≈0.1667 or 16.67%
For Company B:
ROEB=600,000
4,000,000 = 0.15 or 15%
Step 4: Interpretation of ROE results. Company A has a higher ROE (16.67
Step 5: Calculate Debt-to-Equity ratio for both companies. Debt-to-Equity
ratio is calculated as total liabilities divided by shareholders’ equity.
For Company A:
D/EA=5,000,000 −3,000,000
3,000,000 =2,000,000
3,000,000 =2
3≈0.67
For Company B:
D/EB=7,000,000 −4,000,000
4,000,000 =3,000,000
4,000,000 = 0.75
Step 6: Interpretation of Debt-to-Equity ratio results. Company A has a
lower Debt-to-Equity ratio (0.67) compared to Company B (0.75). This indi-
cates that Company A relies less on debt funding than Company B.
Question 18
Question
Company A and Company B are two competing companies in the same indus-
try. You have been provided with the following financial information for both
companies for two consecutive years:
Company A
Year 1 Revenue:
$
500,000
Year 2 Revenue:
$
600,000
Year 1 Net Income:
$
50,000
Year 2 Net Income:
$
70,000
Company B
Year 1 Revenue:
$
700,000
Year 2 Revenue:
$
800,000
Year 1 Net Income:
$
60,000
Year 2 Net Income:
$
75,000
Based on this information, which company showed a better increase in both
revenue and net income between the two years?
23
Solution
Step 1: Calculate the increase in revenue for both companies.
Company A revenue increase = $600,000 −$500,000
= $100,000
Company B revenue increase = $800,000 −$700,000
= $100,000
Step 2: Compare the revenue increases for both companies. Since both
companies had the same increase in revenue (
$
100,000), they showed an equal
increase in revenue between the two years.
Step 3: Calculate the increase in net income for both companies.
Company A net income increase = $70,000 −$50,000
= $20,000
Company B net income increase = $75,000 −$60,000
= $15,000
Step 4: Compare the net income increases for both companies. Company
A showed a better increase in net income (
$
20,000) compared to Company
B (
$
15,000) between the two years. Thus, Company A demonstrated better
growth in net income over the period.
Question 19
Question
Company XYZ provided the following information from its financial statements
for the years ended December 31, 20X1 and December 31, 20X2:
Item 20X1 ($) 20X2 ($)
Total assets 500,000 600,000
Total liabilities 200,000 250,000
Net income 50,000 70,000
Calculate the following ratios for Company XYZ for the years ended Decem-
ber 31, 20X1 and December 31, 20X2: 1. Debt-to-Asset Ratio 2. Return on
Assets (ROA) 3. Return on Equity (ROE)
24
Solution
Step 1: Calculate the Debt-to-Asset Ratio.
Debt-to-Asset Ratio = Total liabilities
Total assets
20X1: = 200,000
500,000 = 0.40
20X2: = 250,000
600,000 ≈0.42
Step 2: Calculate the Return on Assets (ROA).
ROA = Net income
Total assets
20X1: = 50,000
500,000 = 0.10 = 10%
20X2: = 70,000
600,000 ≈0.12 = 12%
Step 3: Calculate the Return on Equity (ROE).
ROE = Net income
Total equity
Total equity = Total assets −Total liabilities
20X1: = 50,000
500,000 −200,000 =50,000
300,000 ≈0.17 = 17%
20X2: = 70,000
600,000 −250,000 =70,000
350,000 = 0.20 = 20%
Question 20
Question
The following information pertains to Company XYZ for the years 2020 and
2021:
Item 2020 2021
Net Sales
$
500,000
$
600,000
Cost of Goods Sold
$
350,000
$
420,000
Gross Profit
$
150,000
$
180,000
Operating Expenses
$
80,000
$
90,000
Net Income
$
50,000
$
60,000
Total Assets
$
600,000
$
700,000
Total Liabilities
$
200,000
$
250,000
Calculate the following for Company XYZ for the years 2020 and 2021:
25
a) Gross profit margin
b) Net profit margin
c) Return on total assets
d) Debt to equity ratio
Solution
a) To calculate the gross profit margin, we use the formula:
Gross Profit Margin = Gross Profit
Net Sales ×100%
Step 1: Calculate the gross profit margin for 2020 and 2021.
For 2020:
Gross Profit Margin (2020) = 150,000
500,000 ×100% = 30%
For 2021:
Gross Profit Margin (2021) = 180,000
600,000 ×100% = 30%
b) To calculate the net profit margin, we use the formula:
Net Profit Margin = Net Income
Net Sales ×100%
Step 2: Calculate the net profit margin for 2020 and 2021.
For 2020:
Net Profit Margin (2020) = 50,000
500,000 ×100% = 10%
For 2021:
Net Profit Margin (2021) = 60,000
600,000 ×100% = 10%
c) To calculate the return on total assets, we use the formula:
Return on Total Assets = Net Income
Total Assets ×100%
Step 3: Calculate the return on total assets for 2020 and 2021.
For 2020:
Return on Total Assets (2020) = 50,000
600,000 ×100% ≈8.33%
For 2021:
Return on Total Assets (2021) = 60,000
700,000 ×100% ≈8.57%
26
d) To calculate the debt to equity ratio, we use the formula:
Debt to Equity Ratio = Total Liabilities
Total Equity
Step 4: Calculate the debt to equity ratio for 2020 and 2021.
For 2020:
Debt to Equity Ratio (2020) = 200,000
600,000 = 0.33
For 2021:
Debt to Equity Ratio (2021) = 250,000
700,000 ≈0.36
Question 21
Question
The following is the income statement for Company XYZ for the years 20X1
and 20X2:
Item 20X1 20X2
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
Calculate the following ratios for Company XYZ for the years 20X1 and
20X2: 1. Gross Profit Margin 2. Operating Margin 3. Net Profit Margin
Solution
Step 1: Calculate the Gross Profit Margin
For year 20X1:
Gross Profit Margin20X1=Gross Profit20X1
Revenue20X1
×100%
Gross Profit Margin20X1=$200,000
$500,000 ×100% = 40%
For year 20X2:
Gross Profit Margin20X2=Gross Profit20X2
Revenue20X2
×100%
Gross Profit Margin20X2=$250,000
$600,000 ×100% ≈41.67%
27
Step 2: Calculate the Operating Margin
For year 20X1:
Operating Margin20X1=Operating Income20X1
Revenue20X1
×100%
Operating Margin20X1=($200,000 −$120,000)
$500,000 ×100% = 16%
For year 20X2:
Operating Margin20X2=Operating Income20X2
Revenue20X2
×100%
Operating Margin20X2=($250,000 −$140,000)
$600,000 ×100% = 18.33%
Step 3: Calculate the Net Profit Margin
For year 20X1:
Net Profit Margin20X1=Net Income20X1
Revenue20X1
×100%
Net Profit Margin20X1=$80,000
$500,000 ×100% = 16%
For year 20X2:
Net Profit Margin20X2=Net Income20X2
Revenue20X2
×100%
Net Profit Margin20X2=$110,000
$600,000 ×100% ≈18.33%
Question 22
Question
Assume you are analyzing the financial statements of two companies, Company
A and Company B. You notice that Company A has a higher profit margin
compared to Company B. What factors could explain this difference in profit
margins between the two companies?
28
Solution
To explain the difference in profit margins between Company A and Company
B, we need to consider various factors that could impact profitability. Here are
some possible reasons for the difference:
1. Revenue Levels: Company A may have higher revenue levels compared
to Company B, resulting in a higher profit margin even if their expenses
are similar.
2. Cost Structure: Company A may have a more efficient cost structure,
with lower costs of goods sold, operating expenses, or interest expenses,
compared to Company B.
3. Operating Efficiency: Company A may have higher operating efficiency
in terms of production processes, inventory management, or supply chain
management, leading to lower costs and higher profits.
4. Product Mix: Company A may have a more profitable product mix, with
higher-margin products contributing a larger share of revenue compared
to Company B.
5. Economies of Scale: Company A may benefit from economies of scale,
operating at a larger scale that allows them to spread fixed costs over a
larger output, resulting in higher profitability.
6. Debt Levels: Company A may have lower debt levels or more favorable
debt terms, leading to lower interest expenses and higher profitability
compared to Company B.
Considering these factors can help in understanding why Company A has a
higher profit margin compared to Company B. Additionally, a detailed financial
analysis of both companies’ income statements, balance sheets, and cash flow
statements would provide further insights into the reasons behind the difference
in profit margins.
Question 23
Question
The following data is extracted from the comparative financial statements of
Company XYZ for the years ending December 31, 20X2 and 20X1:
Item 20X2 20X1
Sales $500,000 $400,000
Costof GoodsSold $200,000 $150,000
GrossP rofit $300,000 $250,000
OperatingExpenses $120,000 $100,000
NetIncome $100,000 $80,000
29
Calculate the following ratios based on the given data for Company XYZ for
the years 20X2 and 20X1: 1. Gross Profit Margin 2. Operating Profit Margin
3. Net Profit Margin
Solution
Step 1: Calculate the Gross Profit Margin
Gross Profit Margin = Gross Profit
Sales ×100%
20X2: = 300,000
500,000×100% = 60%
20X1: = 250,000
400,000×100% = 62.5%
Step 2: Calculate the Operating Profit Margin
Operating Profit Margin = Operating Income
Sales ×100%
20X2: = 180,000
500,000×100% = 36%
20X1: = 150,000
400,000×100% = 37.5%
Step 3: Calculate the Net Profit Margin
Net Profit Margin = Net Income
Sales ×100%
20X2: = 100,000
500,000×100% = 20%
20X1: = 80,000
400,000×100% = 20%
Question 24
Question
Company XYZ and Company ABC are two competitors in the same industry.
You have been provided with their financial statements for the past three years.
Perform a comparative financial statement analysis for both companies and
identify which company seems to be in a better financial position. Justify your
answer with relevant financial ratios and trends.
30
Solution
To compare the financial performance of Company XYZ and Company ABC,
we will analyze their financial statements for the past three years and calculate
key financial ratios.
Step 1: Gather Financial Statements First, we need to gather the
income statements and balance sheets of Company XYZ and Company ABC
for the past three years.
Step 2: Calculate Financial Ratios Next, we will calculate key financial
ratios such as profitability ratios, liquidity ratios, and solvency ratios for both
companies. Some important ratios to consider include:
1. Profitability Ratios: - Return on Assets (ROA) - Return on Equity (ROE)
2. Liquidity Ratios: - Current Ratio - Quick Ratio
3. Solvency Ratios: - Debt-to-Equity Ratio
Step 3: Analyze Trends After calculating the financial ratios for both
companies, we will analyze the trends over the past three years. It is important
to look for any consistent patterns or changes in the ratios.
Step 4: Compare Companies Based on the financial ratios and trends
identified, we can compare Company XYZ and Company ABC to determine
which company seems to be in a better financial position. This comparison
should be supported with the calculated ratios and trends analysis.
By following these steps, we can perform a comprehensive comparative fi-
nancial statement analysis of Company XYZ and Company ABC to assess their
financial performance and determine which company is in a better financial
position.
Question 25
Question
The financial statements of Company X for the current and previous year are
given below:
Current Year
Net sales:
$
500,000
Cost of goods sold:
$
300,000
Operating expenses:
$
100,000
Net income:
$
40,000
Previous Year
Net sales:
$
450,000
Cost of goods sold:
$
270,000
Operating expenses:
$
95,000
31
Net income:
$
35,000
Calculate and analyze the following ratios for both years:
Gross profit margin
Operating profit margin
Net profit margin
Solution
Step 1: Calculate the ratios for the current year.
Gross profit margin:
Gross profit margin = 1−Cost of goods sold
Net sales ×100%
Gross profit margin = 1−300,000
500,000×100% = 40%
Operating profit margin:
Operating profit margin = 1−Operating expenses
Net sales ×100%
Operating profit margin = 1−100,000
500,000×100% = 80%
Net profit margin:
Net profit margin = 1−Net income
Net sales ×100%
Net profit margin = 1−40,000
500,000×100% = 92%
Step 2: Calculate the ratios for the previous year.
Gross profit margin:
Gross profit margin = 1−270,000
450,000×100% = 40%
Operating profit margin:
Operating profit margin = 1−95,000
450,000×100% = 78.89%
32
Net profit margin:
Net profit margin = 1−35,000
450,000×100% = 92.22%
Step 3: Analyze the ratios for both years.
The gross profit margin remained the same at 40% for both years.
The operating profit margin increased from 78.89% to 80%.
The net profit margin also increased from 92.22% to 92%.
These ratios suggest that Company X improved its operational efficiency
and profitability in the current year compared to the previous year.
Question 26
Question
Company A and Company B are both in the same industry. You are provided
with the following information from their financial statements:
Company A:
Revenue:
$
800,000
Cost of Goods Sold:
$
350,000
Operating Expenses:
$
200,000
Net Income:
$
150,000
Company B:
Revenue:
$
1,200,000
Cost of Goods Sold:
$
500,000
Operating Expenses:
$
300,000
Net Income:
$
250,000
Compare the profitability of Company A and Company B using relevant
financial ratios and explain which company is more profitable.
33
Solution
To compare the profitability of Company A and Company B, we will calculate
the following financial ratios: gross profit margin, operating profit margin, and
net profit margin.
Step 1: Calculate Gross Profit Margin
Gross Profit Margin = 1−Cost of Goods Sold
Revenue ×100%
Company A:
Gross Profit Margin A = 1−350,000
800,000×100% = 56.25%
Company B:
Gross Profit Margin B = 1−500,000
1,200,000×100% = 58.33%
Step 2: Calculate Operating Profit Margin
Operating Profit Margin = 1−Operating Expenses
Revenue ×100%
Company A:
Operating Profit Margin A = 1−200,000
800,000×100% = 75%
Company B:
Operating Profit Margin B = 1−300,000
1,200,000×100% = 75%
Step 3: Calculate Net Profit Margin
Net Profit Margin = 1−Net Income
Revenue ×100%
Company A:
Net Profit Margin A = 1−150,000
800,000×100% = 81.25%
Company B:
Net Profit Margin B = 1−250,000
1,200,000×100% = 79.17%
Conclusion: Company A has a slightly higher gross profit margin and net
profit margin compared to Company B. However, both companies have the same
operating profit margin. Overall, Company A is more profitable than Company
B based on the calculated financial ratios.
34
Question 27
Question
The following data is extracted from the financial statements of two companies,
Company A and Company B, for the year ended December 31, 2020:
Item Company A Company B
Sales
$
500,000
$
750,000
Cost of Goods Sold
$
200,000
$
300,000
Gross Profit
$
300,000
$
450,000
Operating Expenses
$
150,000
$
200,000
Net Income
$
150,000
$
250,000
Assuming all other factors are consistent, analyze and compare the financial
performance of Company A and Company B.
Solution
Step 1: Calculate the Gross Profit Margin The Gross Profit Margin is
calculated as:
Gross Profit Margin = Gross Profit
Sales ×100%
For Company A:
Gross Profit MarginA=300,000
500,000 ×100% = 60%
For Company B:
Gross Profit MarginB=450,000
750,000 ×100% = 60%
Step 2: Analyze the Gross Profit Margin Both companies have the
same Gross Profit Margin of 60%, indicating that both companies are able to
generate equivalent gross profit as a percentage of sales.
Step 3: Calculate the Operating Profit Margin The Operating Profit
Margin is calculated as:
Operating Profit Margin = Operating Income
Sales ×100%
For Company A:
Operating Profit MarginA=150,000
500,000 ×100% = 30%
For Company B:
Operating Profit MarginB=250,000
750,000 ×100% = 33.33%
35
Step 4: Analyze the Operating Profit Margin Company B has a
higher Operating Profit Margin of 33.33% compared to Company A’s 30%. This
indicates that Company B is more efficient in managing its operating expenses
relative to its sales.
Step 5: Compare the Net Income Company B has a higher net income
of
$
250,000 compared to Company A’s
$
150,000. This suggests that Company
B is more profitable after accounting for all expenses.
In conclusion, Company B outperforms Company A in terms of operating
efficiency and overall profitability.
Question 28
Question
The financial statements of two companies, Company A and Company B, are
provided below. Use this information to analyze and compare the financial
performance of the two companies.
Company A:
Item Amount (in
$
) % of Sales
Sales 500,000 100%
Cost of Goods Sold 300,000 60%
Gross Profit 200,000 40%
Operating Expenses 120,000 24%
Net Income 80,000 16%
Company B:
Item Amount (in
$
) % of Sales
Sales 800,000 100%
Cost of Goods Sold 440,000 55%
Gross Profit 360,000 45%
Operating Expenses 160,000 20%
Net Income 200,000 25%
Based on the information provided, analyze and compare the financial per-
formance of Company A and Company B.
Solution
Step 1: Calculate Operating Income
For Company A: Operating Income = Gross Profit - Operating Expenses
OperatingIncome = $200,000 −$120,000 = $80,000
For Company B: Operating Income = Gross Profit - Operating Expenses
OperatingIncome = $360,000 −$160,000 = $200,000
36
Step 2: Compare Profitability Ratios
Profit Margin for Company A:
P rofitMargin =NetIncome
Sales ×100% = $80,000
$500,000 ×100% = 16%
Profit Margin for Company B:
P rofitMargin =NetIncome
Sales ×100% = $200,000
$800,000 ×100% = 25%
Step 3: Analyze Cost Management
Company B has a lower cost of goods sold as a percentage of sales, indi-
cating better cost management compared to Company A.
Step 4: Evaluate Operating Efficiency
Company B has a higher operating income and operating margin, sug-
gesting better operating efficiency compared to Company A.
In conclusion, Company B outperforms Company A in terms of profitability,
cost management, and operating efficiency based on the given financial state-
ments.
Question 29
Question
Company XYZ has provided the following financial information for Year 2 and
Year 1:
Year 2 Year 1
Revenue
$
500,000
$
400,000
Cost of Goods Sold
$
250,000
$
200,000
Gross Profit
$
250,000
$
200,000
Operating Expenses
$
100,000
$
80,000
Net Income
$
120,000
$
90,000
Total Assets
$
600,000
$
500,000
Calculate the following financial ratios for Company XYZ for Year 2:
1. Gross Profit Margin
2. Operating Profit Margin
3. Return on Assets
37
Solution
Step 1: Calculate Gross Profit Margin
Gross Profit Margin = Revenue −Cost of Goods Sold
Revenue ×100%
Gross Profit Margin = $500,000 −$250,000
$500,000 ×100%
Gross Profit Margin = $250,000
$500,000×100%
Gross Profit Margin = 0.5×100%
Gross Profit Margin = 50%
Step 2: Calculate Operating Profit Margin
Operating Profit Margin = Revenue −Operating Expenses
Revenue ×100%
Operating Profit Margin = $500,000 −$100,000
$500,000 ×100%
Operating Profit Margin = $400,000
$500,000×100%
Operating Profit Margin = 0.8×100%
Operating Profit Margin = 80%
Step 3: Calculate Return on Assets
Return on Assets = Net Income
Total Assets×100%
Return on Assets = $120,000
$600,000×100%
Return on Assets = 0.2×100%
Return on Assets = 20%
Question 30
Question
The following data is extracted from the financial statements of two companies,
A and B:
38
Item Company A Company B
Revenue
$
500,000
$
650,000
Cost of Goods Sold
$
200,000
$
300,000
Operating Expenses
$
100,000
$
120,000
Interest Expense
$
20,000
$
15,000
Income Tax Expense
$
50,000
$
60,000
Compare the profitability of Companies A and B by calculating their gross
profit margin, operating profit margin, and net profit margin. Interpret your
results.
Solution
Step 1: Calculate the gross profit, operating profit, and net profit for Companies
A and B.
Company A: Gross Profit = Revenue - Cost of Goods Sold =
$
500,000
-
$
200,000 =
$
300,000
Operating Profit = Gross Profit - Operating Expenses =
$
300,000 -
$
100,000
=
$
200,000
Net Profit = Operating Profit - Interest Expense - Income Tax Expense
=
$
200,000 -
$
20,000 -
$
50,000 =
$
130,000
Company B: Gross Profit = Revenue - Cost of Goods Sold =
$
650,000
-
$
300,000 =
$
350,000
Operating Profit = Gross Profit - Operating Expenses =
$
350,000 -
$
120,000
=
$
230,000
Net Profit = Operating Profit - Interest Expense - Income Tax Expense
=
$
230,000 -
$
15,000 -
$
60,000 =
$
155,000
Step 2: Calculate the gross profit margin, operating profit margin, and net
profit margin for Companies A and B.
Company A: Gross Profit Margin = Gross Profit
Revenue ×100% = 300,000
500,000 ×
100% = 60%
Operating Profit Margin = Operating Profit
Revenue ×100% = 200,000
500,000 ×100% = 40%
Net Profit Margin = Net Profit
Revenue ×100% = 130,000
500,000 ×100% = 26%
Company B: Gross Profit Margin = Gross Profit
Revenue ×100% = 350,000
650,000 ×
100% ≈53.85%
Operating Profit Margin = Operating Profit
Revenue ×100% = 230,000
650,000 ×100% ≈
35.38%
Net Profit Margin = Net Profit
Revenue ×100% = 155,000
650,000 ×100% ≈23.85%
Step 3: Interpretation of results
Company A has higher profitability margins across all levels compared to
Company B. Company A has a higher gross profit margin (60
39
Question 31
Question
A company experienced a decrease in net income from $750,000 to $600,000 over
the past year. At the same time, the company’s operating expenses increased
from $400,000 to $450,000. Analyze the impact of this change on the company’s
profit margin and provide an explanation.
Solution
Step 1: Calculate the initial profit margin. To calculate the initial profit margin,
we use the formula:
Profit Margin = Net Income
Total Revenue ×100%
Given that the initial net income was $750,000, we need to find the total
revenue. Since profit margin is not affected by operating expenses, we can
assume that net income is the same as operating income. Therefore, the total
revenue can be calculated as:
Total Revenue = Operating Income+Operating Expenses = 750,000+400,000 = 1,150,000
Now, we can calculate the initial profit margin:
Initial Profit Margin = 750,000
1,150,000 ×100% ≈65.22%
Step 2: Calculate the final profit margin. Using the same formula as above,
we calculate the final profit margin with the new net income of $600,000:
Final Profit Margin = 600,000
1,200,000 ×100% = 50%
Step 3: Analyze the impact. By comparing the initial profit margin of
approximately 65.22% to the final profit margin of 50%, we can see that the
profit margin decreased by about 15.22%.
The decrease in profit margin is primarily due to the increase in operating
expenses from $400,000 to $450,000. This means that for every dollar the com-
pany earns, it is spending a larger portion on operating expenses, which results
in a lower profit margin. In other words, the company’s efficiency in converting
revenue into profit has decreased, indicating a less profitable operation.
Question 32
Question
Company XYZ has provided you with the following income statement data for
two consecutive years:
40
Item Year 1 Year 2
Sales $500,000 $600,000
Costof GoodsSold $300,000 $360,000
GrossP rofit $200,000 $240,000
OperatingExpenses $100,000 $120,000
NetIncome $100,000 $120,000
Compute and discuss the following financial ratios for both years: 1. Gross
profit margin 2. Operating profit margin 3. Net profit margin
Solution
Step 1: Calculate the financial ratios for Year 1.
Gross Profit Margin for Year 1 = Gross ProfitYear 1
SalesYear 1
×100%
Operating Profit Margin for Year 1 = Operating ProfitYear 1
SalesYear 1
×100%
Net Profit Margin for Year 1 = Net IncomeYear 1
SalesYear 1
×100%
Now, calculate these financial ratios:
Gross Profit Margin for Year 1 = $200,000
$500,000 ×100% = 40%
Operating Profit Margin for Year 1 = $100,000
$500,000 ×100% = 20%
Net Profit Margin for Year 1 = $100,000
$500,000 ×100% = 20%
Step 2: Calculate the financial ratios for Year 2.
Gross Profit Margin for Year 2 = Gross ProfitYear 2
SalesYear 2
×100%
Operating Profit Margin for Year 2 = Operating ProfitYear 2
SalesYear 2
×100%
Net Profit Margin for Year 2 = Net IncomeYear 2
SalesYear 2
×100%
Now, calculate these financial ratios:
Gross Profit Margin for Year 2 = $240,000
$600,000 ×100% = 40%
Operating Profit Margin for Year 2 = $120,000
$600,000 ×100% = 20%
Net Profit Margin for Year 2 = $120,000
$600,000 ×100% = 20%
Step 3: Discussion
The gross profit margin remained constant at 40
The operating profit margin also remained constant at 20
The net profit margin also remained constant at 20
In summary, all three financial ratios remained stable from Year 1 to Year
2 for Company XYZ.
41
Question 33
Question
Company ABC and Company XYZ are two competitors in the same industry.
Below are selected financial data for both companies for Year 2 and Year 1:
Company ABC
Year 2 Year 1
Sales
$
500,000
$
400,000
Cost of Goods Sold
$
300,000
$
240,000
Net Income
$
80,000
$
60,000
Company XYZ
Year 2 Year 1
Sales
$
600,000
$
500,000
Cost of Goods Sold
$
360,000
$
300,000
Net Income
$
120,000
$
80,000
Comparatively analyze the financial performance of both companies using
the information provided.
Solution
Step 1: Calculate the Gross Profit Margin for Company ABC and Company
XYZ for Year 2 and Year 1.
Company ABC Gross Profit Margin:
For Year 2:
Gross Profit Margin = 1−Cost of Goods Sold
Sales ×100%
Gross Profit Margin = 1−300,000
500,000×100%
Gross Profit Margin = (1 −0.6) ×100%
Gross Profit Margin = 0.4×100%
Gross Profit Margin = 40%
For Year 1:
Gross Profit Margin = 1−240,000
400,000×100%
Gross Profit Margin = (1 −0.6) ×100%
Gross Profit Margin = 0.4×100%
Gross Profit Margin = 40%
Company XYZ Gross Profit Margin:
42
For Year 2:
Gross Profit Margin = 1−360,000
600,000×100%
Gross Profit Margin = (1 −0.6) ×100%
Gross Profit Margin = 0.4×100%
Gross Profit Margin = 40%
For Year 1:
Gross Profit Margin = 1−300,000
500,000×100%
Gross Profit Margin = (1 −0.6) ×100%
Gross Profit Margin = 0.4×100%
Gross Profit Margin = 40%
Step 2: Interpretation
Both Company ABC and Company XYZ have the same Gross Profit Margin
of 40% in both Year 2 and Year 1. This indicates that both companies are
efficient in managing their production costs relative to their sales.
Step 3: Calculate the Net Profit Margin for Company ABC and Company
XYZ for Year 2 and Year 1.
Company ABC Net Profit Margin:
For Year 2:
Net Profit Margin = Net Income
Sales ×100%
Net Profit Margin = 80,000
500,000×100%
Net Profit Margin = 0.16 ×100%
Net Profit Margin = 16%
For Year 1:
Net Profit Margin = 60,000
400,000
43
Question 34
Question
Company XYZ is analyzing its financial statements for the past three years to
assess its financial performance and position. Using the comparative financial
statement analysis method, calculate the following ratios for Company XYZ
based on the given information:
Year 2019 2020 2021
Net Sales
$
500,000
$
600,000
$
700,000
Gross Profit
$
250,000
$
300,000
$
350,000
Net Income
$
100,000
$
120,000
$
140,000
Total Assets
$
800,000
$
900,000
$
1,000,000
Total Liabilities
$
400,000
$
450,000
$
500,000
Calculate the following ratios:
1. Gross Profit Margin
2. Net Profit Margin
3. Return on Assets
4. Return on Equity
Solution
Step 1: Calculate Gross Profit Margin
Gross Profit Margin = Gross Profit
Net Sales ×100%
Year 2019:
Gross Profit Margin2019 =250,000
500,000×100% = 50%
Year 2020:
Gross Profit Margin2020 =300,000
600,000×100% = 50%
Year 2021:
Gross Profit Margin2021 =350,000
700,000×100% = 50%
Step 2: Calculate Net Profit Margin
Net Profit Margin = Net Income
Net Sales ×100%
44
Year 2019:
Net Profit Margin2019 =100,000
500,000×100% = 20%
Year 2020:
Net Profit Margin2020 =120,000
600,000×100% = 20%
Year 2021:
Net Profit Margin2021 =140,000
700,000×100% = 20%
Step 3: Calculate Return on Assets
Return on Assets = Net Income
Total Assets×100%
Year 2019:
Return on Assets2019 =100,000
800,000×100% = 12.5%
Year 2020:
Return on Assets2020 =120,000
900,000×100% ≈13.33%
Year 2021:
Return on Assets2021 =140,000
1,000,000×100% = 14%
Step 4: Calculate Return on Equity
Return on Equity = Net Income
Total Equity×100%
To calculate Total Equity, we use the formula:
Total Equity = Total Assets −Total Liabilities
Year 2019:
Total Equity2019 =
45
Question 35
Question
The financial statements of two companies, Company A and Company B, are
provided below:
Company A
Year Net Income (in
$
)
Year 1 150,000
Year 2 175,000
Year 3 200,000
Company B
Year Net Income (in
$
)
Year 1 100,000
Year 2 125,000
Year 3 200,000
Given this information, analyze and compare the profitability trends of both
companies over the three-year period.
Solution
Step 1: Compute the percentage change in net income for each com-
pany
To calculate the percentage change in net income, we will use the formula:
Percentage Change = New Value - Old Value
Old Value ×100.
For Company A:
Percentage change from Year 1 to Year 2: 175,000−150,000
150,000 ×100 ≈16.67%
Percentage change from Year 2 to Year 3: 200,000−175,000
175,000 ×100 ≈14.29%
For Company B:
Percentage change from Year 1 to Year 2: 125,000−100,000
100,000 ×100 = 25%
Percentage change from Year 2 to Year 3: 200,000−125,000
125,000 ×100 = 60%
Step 2: Analyze the profitability trends
From the calculations, we see that Company A has a steady increase in net
income over the three-year period, with percentage changes of approximately
16.67
On the other hand, Company B experienced a more significant increase in
profitability, with percentage changes of 25
Therefore, Company B has a more aggressive growth in profitability com-
pared to Company A over the three-year period.
46
