PLEASE SHOW HOW YOU GOT Average A$/$R FIGURES Part B: Appendix $6$C$-4$ Replacement Instructions Use the following instructions to complete $6$C$-4$ of Audit Case $1$ in Excel. These special instructions replace in total those for $6$C$-4$ found on page $294.$ Create a three$-$tab $($or sheet$)$ Excel spreadsheet from scratch, sequentially naming each tab as follows: $($a$)$ Account Balances, $($b$)$ Financial Ratios, $($c$)$ Account Evaluation. Then, for the $-$ a$.$ Account Balances tab: List all the account balances from the $20$X$5$ and $20$X$4$ trial balance relevant and needed in calculating the ratios in the next, Financial Ratios tab. b$.$ Financial Ratios tab: Recompute the financial ratios for $20$X$5.$ Perform the calculations on this second tab by linking to the accounts from the previous Account Balances tab. Include the given $12/31/$X$4$ and industry ratios; then add, by cell referencing, the calculations for $12/31/$X$5.$ The results for $12/31/$X$5$ should be formatted to look similar to what has already been calculated for $12/31/$X$4.$ For example, the current ratio and times interest earned are expressed as numerical results carried out to one decimal place, while return on total assets and return on net worth are expressed as percentages carried out to one decimal place. See the partially completed working paper below for related guidance. c$.$ Account Evaluation tab: Set up four columns $-$ Suspect Ratios, Related Accounts, Potential Reasons, and Proposed Auditor Action. Then, using this column structure, identify five $20$X$5$ financial ratios just computed, and related financial statement accounts, that should be investigated because of inconsistencies with prior$-$year ratios, industry averages, or other relevant knowledge. For each account identified, list next to it potential reasons $-$ internal and$/$or external to KCN itself $-$ for the apparent anomalie$($s$)$ as well as prudent audit team responses. Be as specific as you can for the latter.