Excel Assignment $1$: with Excel

$$

In addition to this tab, contains the three worksheet tabs listed below. Simply click on the tab you wish to view.

$$

$1.$Working Trial Balance$$ contains the KCN Working Trial Balance for the year ended December $31,20$X$5($unadjusted$)$ and $20$X$4($adjusted$).$

$2.$Financial Statements$$ contains comparative KCN Financial Statements which are the results of the adjusted working trial balance amounts for $20$X$5$ and $20$X$4.$

$3.$My Solutions$\_$Ratios$$ contains the financial statement ratios you are asked to calculate for $20$X$5.$

Required:$$

a$.$ Recalculate the $12/31/$X$5$ ratios using Excel on the My Solutions$\_$Ratios schedule. $($Please include what cells the information comes from$)$

$$ The current ratio is presented solved to illustrate calculation of a ratio when the underlying data is on a schedule other than the one you are calculating it on$.$ To receive full credit, be sure to use formulas to calculate the ratio.

$$

b$.$ Does anything stand out in the ratio analysis? For example, are there financial statement accounts that should be investigated because the related ratios are not what one would expect as compared to the prior$-$year ratios or compared the industry average?$$ Are there potential reasons for the unexpected account balances and related ratios.