Formatting as Table Styles

I

Student's Full Name:

Ratios for year$-$end $2019$

Ratio Categories

Profitability

Net income in each sales dollar

Profitability

Gross Margin in each sales dollar

Profitability

Overall profitability of assets

Profitability

Profitability of owner investment

Profitability

Net income per common share

Analyzing Stock$/$Market Prospects

Market value relative to earnings

Uquidity

Ability to pay current liabilities

Solvency

Debt versus equity financing

Turnover efficiency

Efficiency of inventory management

Turnover efficiency

Efficiency of AR collections

Turnover efficlency

Efficiency of assets in producing sales

$\backslash$table$[[$B$,$c$,$E$,$F$,$G$,H,$J$,$K$],[$Gianna Thompson,$\backslash$table$[[$Use only Chapter $13$ in the textbook. No$],[$outside resources should be used.$]],,\backslash$table$[[$Calculate ratios and highlight with color which ratio$],[$is best. Which company has the best Profit Margin, etc?$]],],[,$In this column, write the elements,,Show the numerator and denominator in columns F & I,$],[,$that are measured in the ratio. I have,,Apple,$-,$Google,,$],[$is$,$completed four as examples:,,,,,,$],[$Profit Margin,Net Income,$=,$$$1,655,500,19\mathrm{.}53\%,,$#DIV$/$OI$,],[$Net Sales,$$8,478,000,,],[,,,,,,,],[$Gross Margin Ratio,Net Sales $-$ Cost of Goods Sold,$=,,$#DIV$/0!,,$#DIV$/$O$!,],[$Net Sales,,,$],[,,,,,,,],[$Return on Total Assets,$-,=,,$#DIV$/0!,,$#DIV$/0!,],[,,,],[,,,,,,,],[$Return on Equily,$=,,$#DIV$/0!,,$#DIV$/$OI$,],[,,,,],[,,,,,,,],[$Basic Earnings Per Share,Net Income $-$ Preferred Dividends,$=,,$#DIVI$0!,,$#DIV$/$O$!,],[$of Common Stock $($EPS$),$Weighted$-$Average Common Shares Outstanding,,,$],[,,,,,,,],[$P$/$E ratio,Market Price Per Common Share,$=,,$#DIV$/0!,,$#DIV$/0!,],[($Price$-$Earnings$),$Earnings Per Share $($EPS$),,,],[,,,,,,,],[$Current Ratio,,$=,,$#DIV$/0!,,$# DIV$/$O$,],[,,,$Huiviol,$],[,,,,,,,],[$Debt$-$to$-$Equity Ratio,,$=,,$#DIV$/$O$!,,$#DIV$/0!,],[,,,,,,,],[,,,,,,,],[$Inventory Turnover,,$=,,$#DIV$/0!,,$#DIV$/0!,],[,,,,,,,],[,,,,,,1,],[$AR Turnover,,$=,,$#DIVIOI,,HDIVIO,$],[($Accounts Receivable$),,,,$Heivint,,HUVIOI,$],[,,,,,,,],[$Total Asset Turnover,,$=,,$HDIVIO,c$,$ODIVUl,$],[,,,,,,$Holvio!,$]]$