1/31
Looks like no tags are added yet.
Descriptive Analytics
Analysis performed that characterized, summarizes, and organizes features and properties of the data to facilitate understanding.
four primary financial statements provided in a 10-K submission
Balance sheet, Income statement, statement of cash flows, statement of stockholder’s equity and footnotes.
tools used to perform descriptive analytics
Summarization and statistical tools
Mean, median, and mode
Summary measures of the central tendency of the data.
Most useful when there are extreme, or skewed, observations
Median
minimums, maximums
Summary measures showing extreme values to help explain what happened.
counts
The number of occurrences of a certain data item or event
Example of counts
How many customers do we have?
Total, sums, subtotals
summary measures of the data. what is the net income?
Graph (line, bar, or column charts)
A diagram showing interrelationships between two or more variables
percentage change
The extent to which a data item gains or loses magnitude or value
PivotTable
A tool that allows reorganization and summarization of certain data using cross-tabulations without changing the underlying spreadsheet (or data)
histogram
Display of rectangles with area proportional to the underlying frequency of the data.
Example of histogram
What are the total aged receivables in each 30-day bucket.
Ratio analysis
Analyzing a company's financial statements to see how well it manages money, pays its debts, makes profits, and uses its resources.
Example of ratio analysis
the use of Dupont to understand return on equity.
Vertical analysis
Comparing financial numbers to a specific amount or figure to better understand a company's performance
Horizontal analysis
Comparing financial statements from different years to see what changed. Displays the dollar and percentage change in financial statements from one period to the next.
example of minimum and maximum
sorting sales data from smallest to largest.
calculating the change in dollar sales (horizontal)
most current- less current
percentage change calculation
(New - Old)/Old or (most current- less current)/less current
on a income statement, the relevant base would be
net sales revenue
on a balance sheet, the relevant base would be
total assets
calculation for vertical analysis
(cost of sales/ sales) = percent of sales
Dupont Ratio analysis
Summarizes and disaggregates company performance into three ratios: profit margin, asset turnover, and financial leverage.
Return on equity
Profit margin x asset turnover x financial leverage
profit margin formula
net income/sales
asset turnover formula
Sales/ Total assets
Financial leverage formula
total assets/equity
return on equity (ROE)
Measure of profitability generated for each dollar of stockholders’ investment.
return on assets (ROA)
Measure of profitability for each dollar of resources (assets) available for management to use.
Return on Assets (ROA) only uses to calculate
Profit margin (Net income/sales) x Asset turnover (Sales/ Total assets)