AutoSave

on $C$

$$in

$v$

$2023$ Week Two Project Problem On$.$

Saved $vv$

Search

J$22$

vdots$vv{f}_x$

A

B

C

D

E

F

G

Project One Problem

a$.$ Calculate all of the provided profitability, turnover$-$control, and leverage$/$liquidity ratios for the four years indicated. Your reponses should be carried out to one decimal place. Credit for your work will be based upon the use of Excel formulas and correct answers.

b$.$ Identify and describe two trends you discern for each of the three categories of ratios.

$\backslash$table$[[,$r Corpo,ion,,$],[$BALANCE$,$SHEET,millions$),,],[,2020,2021,2022,2023],[$ASSETS$,,,,],[$Cash & Short$-$Term Investments,$6,179,5,245,4,663,8,787],[$Net Receivables,$3,677,3,498,4,272,2,749],[$Inventories$,5,055,5,261,5,622,7,367],[$Prepaid Assets,$1,150,1,130,1,968,1,653],[$Total Current Assets,$16,061,15,134,16,525,20,556],[$Gross Plant, Property & Equipmen,$7,958,8,891,9,469,12,758],[$Accumulated Depreciation,$3,969,4,437,4,725,4,795],[$Net Plant, Property & Equipment,$3,989,4,454,4,744,7,963],[$Intangibles$,422,439,437,497],[$Other Assets,$2,787,2,509,2,011,2,326],[$TOTAL ASSETS,$23,259,22,536,23,717,31,342],[$LIABILITIES$,,,,],[$Long Term Debt Due in One Year,$331,342,,],[$Accounts Payable,$2,048,\backslash$table$[[342],[2,279]],\backslash$table$[[15],[2\mathrm{.}612]],\backslash$table$[[696],[2248]]],[,,,,2,248]]$

Sheet$1$

teady

If Accessibility: Good to go

$48F$

Mostly clear

Search

$\backslash$table$[[22vv2$:$xvv{f}_x$