REQUIRED: You must highlight your answers in Parts 2 to 5 : Vou are not to alter the Glven information or format in any way. You must use Order of Operations in making determinations: DO NOT USE AVERAGE. 1. Rename the 4 sheets as: Balance Sheet Income Statement Ratio Analysis Loan Amort Table 2. On the Balance Sheet, perform Vertical Analysis for 2022 for: Merchandise inventory 3. On the Balance Sheet, determine both the Dollar Change and the Percentage Change for: Total Long Term Assets 4. On the Income Statement, perform Vertical Analysis for 2022 for: Total operating expenses 5. On the income Statement, perform the Dollar Change and the Percentage Change for: Net Sales 6. Perform 2022 Ratio Analysis for: Net Profit Margin Return on Assets Quick Ratio (Acid Test) Total Asset Turnover 7. Use Sheet\#4 and prepare a Loan Amortization Table per the Given information. Sheet\#4 has the Loan problem information. Label sheet\#4 "Loan Amort Table." NCT202L.A: Fall 2023: Final Exam: Vershon A: Comparative Balance Sheetsi 2021 and 207 Computer hardware \& software Construction-In-proesess Accumulated depreciation Property \& Equipment, net Other noncurrent assets Total long term assets Total assets Current liabilities Accounts payable Accrued liabilities Short-term debt Other current liabilities Total current iablities Long term liabilities Bonds payable Capital Lease Obligations Other lone term debt Total lons-term liabilities Total Liabilities Shareholders Equity Common stock. Additional Pald-in-Capital Retained Earnings Accumulated Other Comp Loss Total shareholders equity Total liabilities and shareholders equity No, of shares outstanding: 12-31-2022 No. of shares outstanding: 12-31-2021 Share price as of 12-31-2022 Share price as of 12-31-2021 \begin{tabular}{rr} $ & 2,850 \\ $ & 420 \\ $ & (12,950) \\ $ & 19,361 \\ $ & 1,325 \\ $ & 20,686 \\ $ & 31,321 \\ \hline \end{tabular} \begin{tabular}{rr} $ & 1,858 \\ $ & 2,512 \\ $ & 870 \\ $ & 351 \\ $ & 5,591 \end{tabular} $ 9.469 1,950 1.275 12.694 is, 285 \begin{tabular}{rr} $ & 30 \\ $ & 7,200 \\ $ & 6,553 \\ $ & (7.47) \\ $ & 13,036 \\ $ & 31.321 \\ \hline \end{tabular} $ $ \begin{tabular}{|rr} $5 & 1,690 \\ 5 & 2,030 \\ 5 & 790 \\ $ & 347 \\ $ & 4,857 \end{tabular} \begin{tabular}{l|l} & \\ 5 & 8,742 \\ 5 & 1,758 \\ $ & 2,133 \\ $ & 12,633 \\ 5 & 17,490 \end{tabular} $ 5 49 5 6,631 5 5,884 (638) 11,926 29.416 Comparative income ftatements 2021 and xon ACTzo2t-A: Fall zo23: Find Exam: Verilon A Ratio Analyals Profitability Retios 202 Gross Prolit Margin Gross profit/Net sales revenue Net Profit Margin Net income/Net sales revenuet Retum on Assets Net income/Average total assets Return on Equity Net income/Average shareholders equity Earnings per Share (EPS) Net income . PS dividend/Ave no. O/5 thares. Price Earnings ratio Price/EPS Liquidity Rotios Current Ratio Current assets/Current habities. Return on Equity Net income/Average shareholders equity Earnings per Share (EPS) Net income - PS dividend/Ave no. O/S shares Price Earnings ratio Price/EPS Liquidity Ratios Current Ratio Current assets/Current liabilities Quick ratio (Acid Test) Quick assets/Current liabilities Receivables Turnover Net sales revenue/Average AR Days Sales Outstanding 365/Receivables turnover Inventory Turnover COGS/Average inventory Days Sales in Inventory 365/ Inventory turnover Solvency Ratios Debt to Assets Total Debt/Total Assets Days Sales in Inventory 365/ Inventory turnover Solvency Ratios Debt to Assets Total Debt/Total Assets Debt to Equity Total Debt/Total Shareholders Equity Times Interest Earned Operating income/Interest expense Operating Efficiency Total Asset Turnover Net sales/Average total assets ACT202L-A: Fall 2023 - Final Exam: Prepare Installment Loan Table: Version A: GIVEN: On January 1,2023 , the National Company signed a $200,000,5.0% installment note, to be repaid over 20 years once monthly with the first payment on December 31, 2023, and then at the end of every following year thereafter until the loan is paid in full. REQUIRED: 1) List the Given information and determine the annual cash payment. 2) Prepare the Loan Amortization Table. Prepare the Loan Amortization Table on either this worksheet or use an additional worksheet in this Excel file and label the tab appropriately