FABM2 Financial Ratios
FABM2 Financial Ratios
FABM2 Financial Ratios
The cost of goods sold is 29.55% of sales. The company has a gross profit
rate of 70.45%. Operating expenses are 15.91% of sales.
The company earns income of P 0.33 for every peso of sales.
Gross profit generated for every peso of sale is P 0.70
Liquidity Ratios
These ratios are very important to the short term creditors of a company. It will
determine if the borrowing company is in a position to pay the borrowed principal and
interest when they fall due.
GSM COMPANY
Comparative Balance Sheet
For the Year 2018 and 2019
ASSETS 2018 2019
Cash 450,000.00 500,000.00
Accounts Receivable 300,000.00 330,000.00
Trading Securities 170,000.00 80,000.00
Inventories 420,000.00 470,000.00
Prepaid Expenses 70,000.00 130,000.00
Total Current Assets 1,410,000.00 1,510,000.00
10
GSM COMPANY
Comparative Income Statement
For the Year 2018 and 2019
2018 2019
Net Sales 5,000,000.00 5,800,000.00
Less: Cost of Goods Sold 1,000,000.00 1,300,000.00
Gross Profit 4,000,000.00 4,500,000.00
Less: Operating Expenses 800,000.00 300,000.00
Earnings Before Interest and Taxes 3,200,000.00 4,200,000.00
Less: Interest Expense 300,000.00 1,800,000.00
Net Income before Tax 2,900,000.00 2,400,000.00
Less: Income Tax Expense 550,000.00 400,000.00
Net Income after Tax 2,350,000.00 2,000,000.00
1. Working Capital
Liquidity capital is the difference between current assets and current
liabilities. This is one of the simplest liquidity ratios. A positive working
capital is preferred because it would mean that there are enough
current assets to pay all of the current liabilities at the moment.
Formula: Working Capital = Current Assets – Current Liabilities
Using the GSM Company data, we would be able to compute the company’s
working capital for 2018 and 2019.
2018 2019
Current Assets 1,410,000.00 1,510,000.00
Less: Current Liabilities 450,000.00 500,000.00
Working Capital 960,000.00 1,010,000.00
Analysis: For both periods, the company has a positive working capital. This is
something good. However, comparing the two periods, we can conclude that
GSM Company is in a better liquidity position in the year 2019 than in 2018.
2. Current Ratio
Current ratio is the quotient of current assets divided by the current
liabilities of the company. As much as possible, a whole number
current ratio is preferred.
Formula: Current Ratio = Current Assets / Current Liabilities
Using the GSM Company data, we would be able to compute the company’s
current ratio for 2018 and 2019.
2018 2019
Current Assets 1,410,000.00 1,510,000.00
Divided by: Current Liabilities 450,000.00 500,000.00
Current Ratio 3.13 3.02
Analysis: GSM Company has P 3.13 worth of current assets for every P 1.00
of current liabilities for the year 2018. This is something positive. However,
11
comparing the two periods, the company has a slightly better current ratio in
2018 than in 2019.
Analysis: GSM Company has P 2.04 worth of quick assets for every P 1.00 of
current liabilities for the year 2018. This is something positive. It means that it
really has the capability to pay its maturing obligations through its quick
assets. Comparing both years, however, would reveal that the company was
better off in 2018 than in 2019.
12
5. Average Collection Period
The average collection period states the usual number of days it would
take before the company would be able to collect a certain group of
receivables. The Accounts Receivable Turnover itself is a component
for the computation of the average collection period. It serves as the
denominator in the formula. For the numerator, the company makes
use of either 360 or 365 days depending on the policy of the company.
Formula: Average Collection Period = 365 days / A/R Turnover Ratio
Using the GSM Company data, we would be able to compute the company’s
average collection period for 2018 and 2019.
2018 2019
No. of days 365 365
Divided by: Accounts 16.66 17.57
Receivable Turnover Ratio
Average Collection Period 21.91 days 20.77 days
Analysis: The shorter average collection period in 2019 shows that the
collection department increased its efforts to collect company receivables as
they fall due. It can be seen in our computation that the company has a better
Accounts Receivables Turnover Ratio and Average Collection Period in 2019
than in 2018. A shorter average collection period means that the company
has more immediate cash that can be used in its operation.
13
7. Average Days in Inventory
This ratio states the number of days that it would take before an
inventory would be entirely sold by the company. This follows the same
concept in computing the average collection period. The goal is to have
shorter average days in inventory. A shorter amount would mean that
the cash of the company is not being tied to its inventory for a very long
period of time.
Formula: Average Days in Inventory = No. of days / Inventory Turnover Ratio
Using the GSM Company data, we would be able to compute the company’s
average days in inventory for 2018 and 2019.
2018 2019
No. of days 365 365
Divided by: Inventory 2.38 2.76
Turnover Ratio
Average Days in Inventory 153.36 days 132.25 days
Analysis: This means that the company will take 153 days to sell its
entire inventory for the year 2018 while it would only take 132 days for the
year 2019. The average days in inventory of this company improved in 2019.
This is because the inventory turnover in 2019 also improved.
14
Solvency Ratios
Solvency ratios measure the capability of an entity to pay long term
obligations as they fall due. Creditors of the company’s long term payable and bond
payable will be interested in knowing its solvency ratios.
Analysis: Comparing the data for the two years involved, it can be seen
that there is a minimal change in the debt ratio of the company. This means
that in 2018, out of the total assets of the company, 69% was being financed
by creditors. A high debt to asset ratio implies a high level of debt.
Analysis: Comparing the debt to equity ratio of the company for two
periods concerned showed that the company was more solvent in 2019 than
in 2018. A high ratio suggests a high level of debt that may result in high
interest expense.
15
3. Times Interest Earned Ratio
The Time Interest Earned Ratio shows the proportion between the
EBIT of the company and its interest expense. It is an indicator of how
many times the company’s EBIT can cover the finance cost of
borrowing. Companies want a high Times Interest Earned Ratio. A
small or decimal number ratio indicates that it is not advisable for a
company to borrow money – especially if the company would not be
able to generate enough income to cover it.
Formula: Times Interest Earned Ratio = EBIT / Interest Expense
Using the GSM Company data, we would be able to compute the company’s
times interest earned ratio for 2018 and 2019.
2018 2019
Earnings Before Income Tax 3,200,000.00 4,200,000.00
Divided by: Interest Expense 300,000.00 1,800,000.00
Times Interest Earned Ratio 10.66 2.33
Analysis: Comparing the times interest earned ratio of the company for
two periods, it can be seen that the company is very solvent in the year 2018
compared to that in 2019. It is 10 times more solvent to pay the interest with
its income before tax.
Profitability Ratios
Profitability ratios measure the ability of the company to generate income from
the use of its assets and invested capital as well as control its cost. The following are
the commonly used profitability ratios:
1. Gross Profit Ratio
This is the proportion of the gross profit of the company with its net
sales. Gross profit is the difference between the net sales of the
company and its cost of goods sold. A company should aim for a
bigger gross profit ratio. A large gross profit ratio shows that a
company can generate more sales from the smaller cost of goods sold
that it has.
Formula: Gross Profit Ratio = Gross Profit / Net Sales
Using the GSM Company data, we would be able to compute the company’s
gross profit ratio for 2018 and 2019.
2018 2019
Gross Profit 4,000,000.00 4,500,000.00
Divided by: Net Sales 5,000,000.00 5,800,000.00
Gross Profit Ratio 80% 77.59%
16
Analysis: This means that for every P 1.00 the company sells, P .80
goes to the gross profit in the year 2018. The company’s gross profit ratio
slightly decreased in 2019. This should be avoided or at least be minimized.
The gross profit ratio can be improved by continuously finding inventories with
lower cost, without sacrificing quality.
2. Profit Margin Ratio
The profit mentioned here is the Net Income After Tax (NIAT). This
ratio measures the proportion between the NIAT and the Net Sales of
the company. This is a more precise measurement of the company’s
profitability because it has already considered the operating expenses
and other expenses of the entity. Companies want a high profit margin
ratio.
Formula: Gross Margin Ratio = Net Income after Tax / Net Sales
Using the GSM Company data, we would be able to compute the company’s
gross margin ratio for 2018 and 2019.
2018 2019
Net Income after Tax 2,350,000.00 2,000,000.00
Divided by: Net Sales 5,000,000.00 5,800,000.00
Gross Margin Ratio 47% 34.48%
Analysis: This means that company earned P .47 for every P 1.00 of
sales in the year 2018. The company’s gross margin ratio shows a decline for
the year 2019. This can be attributed to the lower NIAT coupled by an
increase in Net Sales.
17
Analysis: Comparing the data for the two years involved shows that
there is a huge improvement in the operating expenses to sales ratio. This
can be attributed to lower operating expenses and increase in net sales.
4. Return on Assets
Before profits can be realized, certain investments should be made. In
this case, assets will be used for the different projects of the company.
The goal is to generate profit based on the available assets during the
year. Thus, the company aims for a higher return on assets.
Formula: Return on Assets = NIAT / Total Assets
Using the GSM Company data, we would be able to compute the company’s
return on assets for 2018 and 2019.
2018 2019
Net Income After Tax 2,350,000.00 2,000,000.00
Divided by: Total Assets 2,300,000.00 2,700,000.00
Return on Assets 1.02 0.74
Analysis: Comparing the data for the two years involved shows that in
the year 2018 the return on assets is very high compared to the year 2019.
This can be attributed to a much higher income compared to the assets of the
company.
5. Return on Equity
This is a slight variation of the earlier formula. In this case, it is the
average owner’s/stockholder’s equity that will be used as a
denominator. This is a more specific computation of a company’s
profitability because the denominator being used is the one coming
from stockholders/owners alone.
Formula: Return on Equity = NIAT / Owner’s Equity
Using the GSM Company data, we would be able to compute the company’s
return on equity for 2018 and 2019.
2018 2019
Net Income After Tax 2,350,000.00 2,000,000.00
Divided by: Owner’s Equity 700,000.00 850,000.00
Return on Equity 3.36 2.35
18
6. Asset Turnover Ratio
This ratio measures the correlation between the assets owned by the
company and the net sales generated by such properties.
Formula: Assets Turnover Ratio = Net Sales / Total Assets
Using the GSM Company data, we would be able to compute the company’s
assets turnover ratio for 2018 and 2019.
2018 2019
Net Sales 5,000,000.00 5,800,000.00
Divided by: Total Assets 2,300,000.00 2,700,000.00
Assets Turnover Ratio 2.17 2.15
What’s More
19