Add and$/$or subtract lines on the horizontal analysis to match the financial statements of the company you have chosen. Three years of data needed for analysis.

Copy the financial statement data into another tab on your spreadsheet with one tab for each financial statement.$$

Ratio Analysis

Short Term Debt

Cash Ratio

Quick Ratio

Current Ratio

Liquidity

A$/$R Turnover

Days to collect A$//$R

Inventory Turnover

Days to sell Inventory

Long$-$Term Debt

Debt to Equity

Times Interest Earned

Profitability

Earning per Share

Gross Profit Percentage

Profit Margin

Return on Assets

Return on Common Equity $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Company Name$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Horizontal Analysis of Income Statement$\}\backslash \backslash$

$\backslash$hline & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$BecentYearus Year $-1\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Year$-1$usYear$-2\}\backslash \backslash$

$\backslash$hline & $\backslash$$ Change & $\backslash \%$ Change & Change & $\backslash \%.$Change $\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Net Sales$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Cost of Goods Sold$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Gross Profit$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$OperatingExpenses$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Income from Operations$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Dther Revenue and Gains$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Dither Expenses and Losses$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Income before Income Taxes$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Income tases$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Net lncome$\}\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Earnings per share$\}\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Company Name$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Horizontal Analysis of Balance Sheet$\}\backslash \backslash$

$\backslash$hline & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$BecentYearus Year$-1\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Year$-1$usYear$-2\}\backslash \backslash$

$\backslash$hline & $\backslash$$ Change & $\backslash \%$ Change & Change & $\backslash \%$ Change $\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Assets$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Current Assets$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Cash and Equivalents$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Net Receivables$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Inventory$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Dither current assets$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Total Current Assets$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Property$,$ plant, $\backslash$& Equip$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Total Assets$\}\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Liabilities$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Current Liabilities$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Payables$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Short termburrent long term debt$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Dther current liabilities$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Total current liabilities$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Long$-$term debt$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Total Liabilities$\}\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Stockholder$\text{'}$s Equity$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Common Stock$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Additional PICap$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Retained Earnings$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Total Stockholder's Equity$\}\backslash \backslash$

$\backslash$hline Total Liab $\backslash$& Stockholder's Equity & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$