70.2K

Verified Solution

Link Copied!

Please enter on your spreadsheet, the following information for your company, and the competitor selected, for the most recent $2$ years.

A$.$ Using the Financials option on the menu, and then the Income Statement and Balance Sheet options which then appear below the top menu:

a$.$ Total Current Assets

b$.$ Total Fixed Assets

c$.$ Intangibles

d$.$ Total Current Liabilities

e$.$ Long Term Debt

f$.$ Total Shareholder$$s Equity

g$.$ Revenues

h$.$ Cost of Goods Sold

i$.$ Gross Profit $($also referred to as Gross Margin$)$

j$.$ Operating Expenses

k$.$ Net Income $($also referred to as Net Profit$)$

B$.$ As mentioned above $($or by calculating from the financial statements for your companies$),$ enter the following financial ratios, for your company and its competitor for the past $2$ years.

a$.$ Current Ratio

b$.$ Leverage Ratio $($financial leverage$)$

c$.$ Gross Profit $($Gross Margin on the site$)$

d$.$ Return on Equity

e$.$ Return on Assets

f$.$ Return on Sales $($Operating Margin$)$

g$.$ Asset Turnover

h$.$ Inventory Turnover

C$.$ Analyze the profitability of your two companies:

a$.$ Which company showed the greatest improvement $($or least decrease$)$ in profitability as measured by ROA?

b$.$ Which company showed the greatest improvement $($or least decrease$)$ in profitability as measured by ROE?

c$.$ Are your answers for $($a$)$ and $($b$)$ different?

d$.$ If yes, why?

D$.$ Analyze the productivity of your two companies:

a$.$ Which company showed the greatest improvement $($or least decrease$)$ in productivity as measured by Asset Turnover?

b$.$ Based on the available information what would you say was the biggest cause of this increase $($or lesser amount of decrease$)$ in productivity?

E$.$ Estimate Cost Structure of the $2$ companies. Use the ratio of current assets to total assets as an estimate of the cost structure.

i$.$ Which company has a higher fixed cost structure?

j$.$ In this exercise, do you think that the current ratio is a reasonable representation of the relative cost structure of your two companies? Hint: This would depend on the nature of the non$-$current assets of your companies.

k$.$ Is the year$-$to$-$year change over the past $2$ years, in the same direction for the $2$ companies?

l$.$ Given the relative cost structures of the two companies, and the change in sales for the $2$ companies, what would you have expected for the change in Gross Profit? An increase? Decrease? Why?Part A: Comparing Two Companies

$\backslash$table$[[$Topics$,$Victoria Secret & CO $($VSCO$),$Dick Sporting Goods $($DKS$)],[$Year: $2022,$Year: $2023,$Year: $2022,$Year: $2023],[$Total Current Assests,$1\mathrm{.}69B,1\mathrm{.}74B,5\mathrm{.}11B,4\mathrm{.}96B$

Answer & Explanation Solved by verified expert

See Answer