Analyzing Financial Statements

Question 1

Analyzing financial statements is critical in order to understand

Answer 1

the performance of a business. To do so, we can use different types of ratios that uncover important relationships between financial statement items.

Question 2

Ratios are typically most useful when

Answer 2

making comparisons to other companies or to the past performance of the company itself. Therefore, it’s important to first get an overall understanding of the company and the industry in which it operates.

Question 3

One of the most commonly evaluated ratios is a firm’s ___ which shows ___

Answer 3

return on equity or ROE, which shows the return that a business generated during a period on the equity invested in the business by the owners of the business.

Return on Equity = Net Income / Owners Equity

Question 4

The DuPont Framework measures profitability using

Answer 4

Profit Margin, efficiency using Asset Turnover, and leverage using the Leverage Ratio (or Equity Multiplier

Question 5

Profitability reveals

Answer 5

how much profit is left from each dollar of sales after all expenses have been subtracted.

Question 6

Profit margin is calculated

Answer 6

by dividing net income by the total sales for the period.

Question 7

The gross profit margin ratio tells us

Answer 7

what percentage of our revenue is left to cover other expenses after the cost of goods sold is subtracted. Recall that gross profit is equal to sales minus cost of goods sold.

(Revenue - Cost of Sales) / Revenue = Gross Profit Margin

Question 8

Earnings before interest after taxes or EBIAT, is a measure of

Answer 8

how much income the business has generated while ignoring the effect of financing and capital structure, or the proportion of debt that the business has. As the name implies, interest expense, which is included on the income statement, is added back, and income tax expense is calculated and subtracted based on earnings before interest.

Question 9

asset turnover tells us how well a business is

Answer 9

using its assets to produce sales. A business that can create more revenue with fewer assets is more efficient. This ratio uses both the income statement and the balance sheet; we typically use the average of the beginning and ending balance sheet amounts to estimate the average level of assets during the period.

Asset Turnover is calculated by dividing the annual revenue by the average asset value for the year.

Question 10

Inventory turnover helps understand how efficiently a business is

Answer 10

managing its inventory levels. Excess inventory costs money to store and uses up the firm’s cash that could be used for other investments. A higher inventory turnover represents more efficient inventory management.

INVENTORY TURNOVER = COGS / AVG INVENTORY

Question 11

Days Inventory is expressed

Answer 11

as the average number of days the inventory is held before it is sold rather than how many times the inventory turned over during the period. At times it may be more intuitive to consider and discuss ratios and changes to these ratios when the terms are expressed in days.

DAYS INVENTORY = AVG INVENTORY / (COGS/365)

or

365 / INVENTORY TURNOVER

Question 12

The accounts receivable turnover or AR turnover indicates a business’ efficiency in

Answer 12

collecting receivables from customers.Uncollected receivables represent cash that is tied up and can’t be used for other purposes. A higher AR turnover represents more efficient cash collections. An AR turnover that is too low could indicate that the business’ customers are having trouble paying.

= CREDIT SALES / AVG ACCOUNTS RECEIVABLE

Question 13

The average collection period, sometimes referred to as Days Sales Outstanding (DSO) or Days Sales in Receivables,is the average number of days

Answer 13

it took for a business to collect payment from a customer. This helpful measure can be compared to the cash collection policy of the firm. If payment is expected from customers within 30 days, but the average collection period is 40 days, it may be a sign of concern.

We can calculate the average collection period by first finding the average credit sales per day. Dividing the average accounts receivable balance by credit sales per day will leave us with the number of days sales our accounts receivable balance represents, or the average collection period

= 365 / Accounts receivable turnover

Question 14

To measure Accounts payable turnover, or AP turnover, we look at how long it takes us

Answer 14

at how long it takes us to pay our vendors. Vendors include suppliers of inventory and also suppliers of services or other non-inventory items. One input for this ratio is credit purchases, which can be estimated by looking at COGS. We are also assuming that all goods are bought on credit and not paid for with cash. In both cases other adjustments may have to be made.

= CREDIT PURCHASES / AVG Accounts Payable

or

COGS / avg accounts payable

Question 15

days purchases outstanding =

Answer 15

AVG accounts payable / (Annual credit purchases/ 365)

Question 16

cash conversion cycle is a measure of

Answer 16

how long it takes a business from the time it has to pay for inventory from its suppliers until it collects cash from its customers.

= Days Inventory + Average Collection Period - Days Purchases Outstanding

Question 17

Financial Leverage, also known as the Equity Multiplier, measures the impact

Answer 17

the impact of all non-equity financing, or debt of all sorts, on the firm’s ROE. If all of the assets are financed by equity, the multiplier is 1. As liabilities, which are forms of debt, increase, the multiplier increases from 1 demonstrating the leverage impact of the debt.

Question 18

debt to equity ratio =

Answer 18

The Debt to Equity Ratio is calculated by dividing the total liabilities by the total equity.

Total liabilities / total equity =

Question 19

The current ratio helps us understand the business’ ability

Answer 19

to pay its short term obligations. It focuses on the business’ more liquid assets and liabilities, or those that are convertible to cash or coming due, within a year.

Current Assets / Current Liabilities =

Question 20

The quick ratio =

Answer 20

The quick ratio is an even more stringent test than the current ratio to see if a business can meet its current obligations because it depends only on the most readily available current assets. Some businesses may have trouble turning their inventory into cash, so this gives us an idea of their ability to meet current obligations even if their inventory can’t be sold immediately.

(Current Assets - Inventory) / Current Liabilities =

Question 21

The interest coverage ratio, also known as the times interest earned, is a good way to gauge how

Answer 21

capable a business is of making the interest payments on its debt. For this, we use a common income number called EBIT (Earnings Before Interest and Taxes). This number has to be calculated from the income statement by adding back interest expense and tax expense for the period to net income.

To calculate Earnings Before Interest and Taxes (EBIT), we start with Net Income and then add back Interest Expense and Income Tax Expense.

To calculate the Interest Coverage Ratio, we divide EBIT by Interest Expense.

Question 22

Credit Sales per Day can be calculated as

Answer 22

Sales / 365

Question 23

A company’s Inventory Turnover decreased during the year. Which of the following is a reasonable explanation to this trend?

Answer 23

Inventories were less marketable compared with last year.
Inventory Turnover = Cost of goods sold / Average inventory As the inventories became less marketable, the company would be less efficient in operating its inventories, and thus the Inventory Turnover would decrease.

Question 24

Company A has a shorter Average Collection Period than Company B. Which of the following statements is true regarding these two companies?

Answer 24

Company A is more efficient in collecting receivables from customers than Company B.
Average Collection Period = 365 / (Credit Sales / Average AR Balance) A lower Average Collection Period means the company is more efficient in collecting from their customers.

Question 25

What is the formula used to calculate Cash Conversion Cycle?

Answer 25

Cash Conversion Cycle = Days Inventory + Average Collection Period - Days Payable Outstanding

Question 26

Company C has zero inventory, which indicates it is likely a ___ industry.

Answer 26

service

Question 27

Company A has high inventory which indicates it is ____

Answer 27

retail.

Question 28

Days Purchases Outstanding is calculated by

Answer 28

dividing Average Accounts Payable by the average daily Cost of Sales, which is Cost of Sales divided by 365.

Average Accounts Payable / Average Daily Cost of Sales

Question 29

Gross Profit Margin is calculated by

Answer 29

the Gross Profit (Revenue less Cost of Sales) by the Revenue

(Revenue - Cost of Sales) / Revenue = Gross Profit Margin

Question 30

Interest Coverage Ratio =

Answer 30

EBIT / Interest Expense = (Net Income + Income Tax + Interest Expense)

Question 31

Days Inventory =

Answer 31

365 / Inventory Turnover

Question 32

Average Collection Period =

Answer 32

365 / Accounts Receivable Turnover

Question 33

Days Purchases Outstanding =

Answer 33

365 / Accounts Payable Turnover