70.2K

Verified Solution

Link Copied!

Did I do this correctly? The $11$th tab in your Financial Statement Analysis Template must be labeled

Historical and Competitor Ratios

$$ The list of ratios to be included are as follows. They should be grouped

under the headings, as shown:

$$ Liquidity Ratios

o Current Ratio

o Quick Ratio

$$ Leverage Ratios

o Debt to Total Assets Ratio

o Debt Equity Ratio

o Long$-$Term Debt to Equity

o Times Interest Earned Ratio

$$ Activity Ratios

o Inventory Turnover

o Fixed Assets Turnover

o Total Assets Turnover

o Accounts Receivable Turnover

o Average Collection Period

$$ Profitability Ratios

o Gross Profit Margin

o Operating Profit Margin

o Net Profit Margin

o Return on Total Assets $($ROA$)$

o Return on Stockholders$$ Equity $($ROE$)$

o Earnings Per Share $($EPS$)$

o Price Earnings Ratio

$$ Calculate the ratios for your chosen company for the last three years, linking

the ratio calculations back to the historical financial statement tabs $($Tabs $2-$

$4)$ using formulas.

$$ Calculate the ratios for each of your company$$s competitors $($most recent

year only$),$ linking the ratio calculations to the competitor financial

statements shown in Tabs $5-10$ using formulas.

$$ Using the internet, locate the industry averages for the ratios listed above,

and include them in the final column of the ratio tab. Include a footnote on

the tab to identify the source of the industry averages. Ford Motor Company Competitor Ratio Analysis

Historical Ratios

For the years ended December $21,2022,2021,2020$ For the year ended December $31,2022$

$202220212020$ General Motors Tesla Industry Average

Liquidity Note $1$

Current ratio $1\mathrm{.}201\mathrm{.}201\mathrm{.}201\mathrm{.}531\mathrm{.}011\mathrm{.}03$

Quick Ratio $1\mathrm{.}061\mathrm{.}071\mathrm{.}090\mathrm{.}931\mathrm{.}050\mathrm{.}75$

Leverage Ratios

Debt to Total Assets Ratio $0\mathrm{.}830\mathrm{.}810\mathrm{.}880\mathrm{.}730\mathrm{.}440\mathrm{.}51$

Debt to Equity Ratio $4\mathrm{.}924\mathrm{.}307\mathrm{.}702\mathrm{.}830\mathrm{.}821\mathrm{.}38$

Long$-$Term Debt to Equaity $2\mathrm{.}124\mathrm{.}297\mathrm{.}672\mathrm{.}670\mathrm{.}810\mathrm{.}47$

Times Interest Earned Ratio $6\mathrm{.}62-1\mathrm{.}2610\mathrm{.}8810\mathrm{.}2813\mathrm{.}699\mathrm{.}32$

Activity Ratios

Inventory Turnover $10\mathrm{.}3010\mathrm{.}0010\mathrm{.}409\mathrm{.}584\mathrm{.}729\mathrm{.}77$

Fixed Assets Turnover $4\mathrm{.}604\mathrm{.}003\mathrm{.}803\mathrm{.}804\mathrm{.}722\mathrm{.}41$

Total Assets Turnover $0\mathrm{.}740\mathrm{.}680\mathrm{.}660\mathrm{.}590\mathrm{.}990\mathrm{.}76$

Accounts Receivable Turnover $11\mathrm{.}6712\mathrm{.}7613\mathrm{.}223\mathrm{.}3433\mathrm{.}4933\mathrm{.}96$

Average Collection Period $31\mathrm{.}2$ days $28\mathrm{.}6$ days $27\mathrm{.}7$ days $109\mathrm{.}35$ days $11$ days $55\mathrm{.}81$ days

Profitability Ratios

Gross Profit Margin $14\mathrm{.}97\%15\mathrm{.}89\%13\mathrm{.}02\%13\mathrm{.}39\%25\mathrm{.}60\%18\mathrm{.}28\%$

Operating Profit Margin $5\mathrm{.}22\%3\mathrm{.}32\%6\mathrm{.}58\%6\mathrm{.}58\%16\mathrm{.}76\%6\mathrm{.}73\%$

Net Profit Margin $-12\mathrm{.}50\%13\mathrm{.}16\%-12\mathrm{.}50\%59\mathrm{.}90\%15\mathrm{.}45\%4\mathrm{.}50\%$

Return on Total Assets $($ROA$)1\mathrm{.}61\%7\mathrm{.}04\%-0\mathrm{.}77\%3\mathrm{.}81\%14\mathrm{.}64\%3\mathrm{.}32\%$

Return on Stockholders' Equity $($ROE$)9\mathrm{.}67\%46\mathrm{.}56\%-4\mathrm{.}54\%13\mathrm{.}15\%26\mathrm{.}18\%33\mathrm{.}71\%$

Earnings Per Share $($EPS$)$ $$(0\mathrm{.}49)$ $$4\mathrm{.}45$ $$(0\mathrm{.}32)$ $$6\mathrm{.}17$ $$4\mathrm{.}03$ $$3\mathrm{.}60$

Price Earning Ratio $-0\mathrm{.}494\mathrm{.}45-0\mathrm{.}326\mathrm{.}174\mathrm{.}0312\mathrm{.}61$

Note $1$: Some of the financial ratios for the automotive industry for $2022$ are projected estimated averages. These values are only approximations and may not reflect the actual performance of the industry.

Answer & Explanation Solved by verified expert

See Answer