Conditional Formatting v Format as Table Cell Styles Cells Number En * Alignment Font x a) \begin{tabular}{|c|c|c|c|} \hline & A & B & c \\ \hline 4 & \begin{tabular}{l} he bala \\ Each bi \\ IRED As \end{tabular} & \begin{tabular}{l} ance or onswer the question(s) posed in both columns o) \\ olankis worth 1 point for a total of 28 points. This is a \\ ssignment. \end{tabular} & \begin{tabular}{l} a) Ust / Compute the amount as per the Financial \\ Statement(s) for the Year Ended 1/30/2022 (referred to \\ Fiscal 2021 on the Bolance Shicet) \end{tabular} \\ \hline \begin{tabular}{l} 5 \\ 6 \end{tabular} & 1 & Current Assets & 29,055 million dollars \\ \hline87 & 2 & Current Liabilities & 28,693 million dollars \\ \hline \begin{tabular}{l} 9 \\ 10 \end{tabular} & 3 & \begin{tabular}{l} a) Working Capital - formula; amount \\ Current Ratio - formula; percentage amount \end{tabular} & \\ \hline 11 & 4 & \begin{tabular}{l} Quick Assets; enter description of numbers used - \\ hint: see your textbook or google this formula \end{tabular} & \\ \hline \begin{tabular}{l} 13 \\ 14 \\ \end{tabular} & 3 & Current notes payable & \\ \hline1615 & 5 & Long-term notes payable & D. \\ \hline \begin{tabular}{l} 17 \\ 18 \end{tabular} & 7 & Interest Expense & \\ \hline2019 & 3 & Property, Plant \& Equipment & \\ \hline 22 & 9 & \begin{tabular}{l} Using a horizontal analysi5s chnique, by how much did \\ Sales increase or (decrease) from the prior year? a) The \\ numeric difference; b) The percentage difference. \end{tabular} & a) \\ \hline 24 & 10 & \begin{tabular}{l} a) List the Gross profit; and b) Compute the Gross Profit \\ Percentage; enter both the number and the \\ percentage. \end{tabular} & a) \\ \hline 26 & 1 & Earnings (basic) per share & \\ \hline2827 & 2 & \# of Common Stock shares outstanding @1/30/2022 & \\ \hline 30 & 3 & Cash Dividends Paid & \\ \hline 31. & 4 & Cash at the end of the year & \\ \hline 33 & & & \\ \hline 34 & 5 & \begin{tabular}{l} Why does the Company have a fiscal year that is not at \\ the end of the month or at December 31 ? (Hint: Look \\ up information on fiscal years versus calendar years \\ used for annual reports-this is defined in your \\ textbook.) \end{tabular} & EXPLAIN: \\ \hline 35 & & & \\ \hline 36 & & & \\ \hline \end{tabular} THE HONE DEROT, INC THE WOUE DEPOT, NC. CONSOLIBATEO HAY AYCE SMEETS CONSOUDATID STATENENTS OF EAEMEIGS Daf wont berot, int menombecic menombecic THE HOME DEPOT, INC. \begin{tabular}{|c|c|c|c|} \hline & & \begin{tabular}{l} a) List / Compute the amount as per the Financial \\ Statement(s) for the Year Ended 1/30/2022 Veferred to ar \\ Fiscal 2021 an the Alalance Shece) \end{tabular} & \begin{tabular}{l} b) List all Financial Statements where the Amount was \\ lecated for the Year Ended 1/30/2022. Fheal 2021 on the \\ Alaloece Shiret \end{tabular} \\ \hline 1 & Current Assets & 29,055 miltion dellars & \\ \hline 2 & Current Labilities & 28,693 million dollans. & \\ \hline 3 & \begin{tabular}{l} a) Working Capital - formula, amount \\ Current Futio-formula, percentage amount \end{tabular} & & b) \\ \hline 4 & \begin{tabular}{l} Qulck Assets emter description of numbers used - \\ hint: vee your textbook or goople this formufit \end{tabular} & & \\ \hline 5 & Current notes parable & & \\ \hline 6 & toncterm notes parable & & \\ \hline 7 & Interest Eapense & & - \\ \hline 8 & Property, Plant \& Equipment & & \\ \hline 9 & \begin{tabular}{l} Uning a horisontal analvis technique, by how much did \\ Sales increase or (decrease) from the prier year? a) The \\ numeric difference; b) The percentage difference. \end{tabular} & a) & b) \\ \hline 10 & \begin{tabular}{l} a) List the Cross profit; and b) Compute the Gross Profit \\ Percentage; conter both the number and the \\ percentage. \end{tabular} & a) & b) \\ \hline 11 & Earnings (pasic) per thace & & \\ \hline 12 & & & \\ \hline 13 & Cach Dividendipald & & \\ \hline 14. & Cash at the end of the vear & & \\ \hline is & & EXPLANE & \\ \hline \end{tabular}