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. REQUIRED: You must highlight your answers in Parts 2 to 5 : You are not to alter the Given 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." ACT202L-A: Fall 2023: Final Exam: Version A: Comparative Balance 5heets: 2021 and 2022 ACT202L-A: Fall 2023: Final Exam: Version A: Comparative lincome Statements: 2021 and 2022 Ratio Analysis Profitability Ratios 2022 Gross Profit Margin Net Profit Margin Return on Assets Return on Equity Earnings per Share (EPS) Price Earnings ratio Liquidity Ratios Current Ratio Quick ratio (Acid Test) Receivables Turnover Days Sales Outstanding Inventory Turnover Days Sales in Inventory Gross profit/Net sales revenue Net income/Net sales revenue Net income/Average total assets Net income/Average shareholders equity Net income - PS dividend/Ave no. O/S shares Price/EPS Current assets/Current liabilities Quick assets/Current liabilities Net sales revenue/Average AR 365/Receivables turnover COGS/Average inventory 365/ Inventory turnover 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 Debt to Equity Times Interest Earned Operating Efficiency Total Asset Turnover Total Debt/Total Assets Total Debt/Total Shareholders Equity Operating income/Interest expense Net sales/Average total assets