\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{mlboshoff} \pdfinfo{ /Title (financial-statement-analysis.pdf) /Creator (Cheatography) /Author (mlboshoff) /Subject (Financial Statement Analysis Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{24A36C} \definecolor{LightBackground}{HTML}{F1F9F5} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Financial Statement Analysis Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{mlboshoff} via \textcolor{DarkBackground}{\uline{cheatography.com/37296/cs/11710/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}mlboshoff \\ \uline{cheatography.com/mlboshoff} \\ \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Published 5th May, 2017.\\ Updated 5th May, 2017.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{3} \begin{tabularx}{5.377cm}{x{0.86963 cm} x{1.69349 cm} x{2.01388 cm} } \SetRowColor{DarkBackground} \mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Liquidity Ratios}} \tn % Row 0 \SetRowColor{LightBackground} {\bf{Current Ratio}} & Current \seqsplit{Assets:Current} Liabilities & Company's ability to meet its short term obligations \tn % Row Count 4 (+ 4) % Row 1 \SetRowColor{white} {\bf{Quick Ratio}} & Liquid \seqsplit{Assets:Current} Liabilities & Liquid assets not only excludes inventory \tn % Row Count 7 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}---} \SetRowColor{LightBackground} \mymulticolumn{3}{x{5.377cm}}{Is the level of operating capital management to aggressive? Could lead to a loss in business. Also take into account level of operating risk and costs associated with short-term finance.} \tn \hhline{>{\arrayrulecolor{DarkBackground}}---} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.73926 cm} x{1.09848 cm} x{1.73926 cm} } \SetRowColor{DarkBackground} \mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Debt Management Ratios}} \tn % Row 0 \SetRowColor{LightBackground} {\bf{Debt ratio}} & Total Debt / Total Assets & Indicates extent to which company uses external financing to finance assets \tn % Row Count 5 (+ 5) % Row 1 \SetRowColor{white} {\bf{Interest Cover or Times interest earned}} & EBIT / Interest & Ability to meet interest obligation. EBITDA also used. \tn % Row Count 9 (+ 4) % Row 2 \SetRowColor{LightBackground} {\bf{Debt/Equity ratio}} & Total \seqsplit{Debt/Total} Equity & Gearing ratio of the company \tn % Row Count 12 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}---} \SetRowColor{LightBackground} \mymulticolumn{3}{x{5.377cm}}{May need to restate balance sheet {\bf{interest earning debt}} - Preference shares (redeemable=debt), deferred tax (do you have obligation to pay?), minority interest (equity), non-interest bearing debt (treat as debt or deduct)} \tn \hhline{>{\arrayrulecolor{DarkBackground}}---} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.69349 cm} x{1.23579 cm} x{1.64772 cm} } \SetRowColor{DarkBackground} \mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Measures of Profitability}} \tn % Row 0 \SetRowColor{LightBackground} {\bf{Profit Margin}} & Profit / Turnover & Calculated at different levels. Non-trade income should not be included \tn % Row Count 6 (+ 6) % Row 1 \SetRowColor{white} {\bf{Organisational profitability / Return on total assets}} & EBIAT / Total Assets & Return on enterprise as a whole \tn % Row Count 11 (+ 5) % Row 2 \SetRowColor{LightBackground} {\bf{Return on Equity}} & Equity Earnings / Total Equity & Difference between ROA and ROE is financial leverage \tn % Row Count 15 (+ 4) % Row 3 \SetRowColor{white} {\bf{Financial leverage}} & ROA vs ROE & \tn % Row Count 17 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}---} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.41887 cm} x{1.60195 cm} x{1.55618 cm} } \SetRowColor{DarkBackground} \mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Asset Management / effectiveness}} \tn % Row 0 \SetRowColor{LightBackground} {\bf{Inventory turnover}} & Cost of sales / Average inventory (times) & Effectively manage and control inventory. Poor turnover may indicate obsolete stock. (if you don't have COS use SALES) \tn % Row Count 10 (+ 10) % Row 1 \SetRowColor{white} {\bf{Inventory turnover rate}} & Average inventory / COS x 365 (days) & Length of time that inventory is on average held before it is sold. \tn % Row Count 16 (+ 6) % Row 2 \SetRowColor{LightBackground} {\bf{Days' sales in closing inventory}} & Closing Inventory / COS x 365 (days) & Days sales left from current closing inventory \tn % Row Count 20 (+ 4) % Row 3 \SetRowColor{white} {\bf{Debtor's turnover}} & Credit Sales / Average Debtor (times) & Evaluate application of Co's credit policy. Too short (sales will be lost) \& too long (bad debts) \& opp cost \tn % Row Count 29 (+ 9) % Row 4 \SetRowColor{LightBackground} {\bf{Debtors Collection period}} & Average debtors / Credit sales x 365 (days) & Reciprocal relationship with debtors turnover \tn % Row Count 33 (+ 4) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{x{1.41887 cm} x{1.60195 cm} x{1.55618 cm} } \SetRowColor{DarkBackground} \mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Asset Management / effectiveness (cont)}} \tn % Row 5 \SetRowColor{LightBackground} {\bf{Days Sales in closing debtors}} & Closing debtors / Credit sales x 365 (days) & Sales represented by closing debtors \tn % Row Count 4 (+ 4) % Row 6 \SetRowColor{white} {\bf{Creditors payment period}} & Average creditors / Credit purchases x 365 (days) & Use COS if credit purchases not available. Too short (not utilising free credit) \& too long (Bad reputation) \tn % Row Count 13 (+ 9) % Row 7 \SetRowColor{LightBackground} {\bf{Asset Turnover}} & Net Sales / Assets & Management ability to utilise assets effectively to generate sales. Can use different categories of assets \tn % Row Count 22 (+ 9) \hhline{>{\arrayrulecolor{DarkBackground}}---} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.14425 cm} x{1.69349 cm} x{1.73926 cm} } \SetRowColor{DarkBackground} \mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Investor's ratios / Market value ratios}} \tn % Row 0 \SetRowColor{LightBackground} Earnings per share & Earnings / WANOS & \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} Dividend per share & Dividend / No of shares in issue & \tn % Row Count 5 (+ 3) % Row 2 \SetRowColor{LightBackground} Earnings Yield & EPS / Share price & \tn % Row Count 7 (+ 2) % Row 3 \SetRowColor{white} Dividend Yield & DPS / Share Price & \tn % Row Count 9 (+ 2) % Row 4 \SetRowColor{LightBackground} Dividend cover & EPS / DPS & \tn % Row Count 11 (+ 2) % Row 5 \SetRowColor{white} Price - Earnings Ratio & Share Price / EPS & High PE ratio can indicate investor's confidence and growth prospects. Repayment period in years of share investment. How much investors will pay per R1 of co's earnings. \tn % Row Count 23 (+ 12) % Row 6 \SetRowColor{LightBackground} PEG & PE / Expected sustainable growth & 2 companies taht are in different growth stages (eliminating growth impact) \tn % Row Count 28 (+ 5) % Row 7 \SetRowColor{white} Nest Asset Value per Share & NAV / WANOS & Compare share price to NAV ps = trading at a discount? \tn % Row Count 32 (+ 4) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{5.377cm}{x{1.14425 cm} x{1.69349 cm} x{1.73926 cm} } \SetRowColor{DarkBackground} \mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Investor's ratios / Market value ratios (cont)}} \tn % Row 8 \SetRowColor{LightBackground} \seqsplit{Shareholder} return & (Share price(end) - Share price(beg) + Dividend) / Share price(beg) & Compare to ALSI return \tn % Row Count 5 (+ 5) % Row 9 \SetRowColor{white} Dividend Payout ratio & DPS / EPS & Use to calculate sustainable growth \tn % Row Count 8 (+ 3) % Row 10 \SetRowColor{LightBackground} \seqsplit{Sustainable} growth & 1 - Dividend Payout Ratio & \tn % Row Count 10 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}---} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.51041 cm} x{1.41887 cm} x{1.64772 cm} } \SetRowColor{DarkBackground} \mymulticolumn{3}{x{5.377cm}}{\bf\textcolor{white}{Cash Flow Statement}} \tn % Row 0 \SetRowColor{LightBackground} Cash flow to total debt & CF from Operations / Total Debt & Indicator of financial distress \tn % Row Count 3 (+ 3) % Row 1 \SetRowColor{white} Cash ability to cover finance charges & CF from Operations / Interest Paid & Ability to pay interest from cash available \tn % Row Count 7 (+ 4) % Row 2 \SetRowColor{LightBackground} Cash generating ability of co & CF from Operations / Turnover & \tn % Row Count 10 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}---} \SetRowColor{LightBackground} \mymulticolumn{3}{x{5.377cm}}{Remember CASH IS KING! so any Cash Flow Ratio will be more reliable as to the true performance and going concern ability of the company} \tn \hhline{>{\arrayrulecolor{DarkBackground}}---} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}