https://drive.google.com/file/d/1PN0uSeJbB4ARvI-gDPGQp3YC0W02p7DL/view?usp=drive_link

Given the information above. Answer the following 1. Make a trend analysis of Debt Ratio, Quick Ratio, Average collection period, inventory turnover and fixed asset inventory turnover. Provide an explanation for the analysis. 2. Calculate the DuPont Analysis. 3. Make a Modified Dupont Analysis (graph/figure) for 2022.

Here's an example of Modified Dupont Analysis

VI. DUPONT ANALYSIS Apple Inc. Modified DuPont Analysis (Latest Year - 2021) Return on Investment 26.97% Multiplied Total Assets to Stockholder's Equity 5.5643 times Equals Return on Stockholder's Equity 150.07% Sales $365,817 Earnings after tax $94,680 Equals Miss Net Profit Margin 25.88% Equals Divided Total Expenses Other non- Cost of Operating Interest Income operating Sales $212,981 Expenses Charges Taxes $43,887 $2,645 $14,527 income $2,903 Sales Equals Mutipled $365,817 Sales $365,817 Current Assets Total Asset Turnover 1.042 times Divided Cash and Cash Vendor Other Equals Marketable Accounts equivalents Securities Receivable $34,940 $26,278 $27,699 Inventories non-trade $6,580 receivables $25.228 current assets $14,111 Total Assets $351,002 Equals Non-current Assets Marketable Securities $127,877 Property, Plant and Other non- current Equipment $39,440 assets $48,849