Ratio Trend Analysis
Find the next three years of the neeeded ratios.
Due by Sunday, 11:59pm Level-Up Excel Skill 2: Trend Analysis (ratios) Continuing with Milestone 4 , complete 3 years for each of the ratios chosen in Milestone 4. \begin{tabular}{|c|c|c|c|c|} \hline except marked " or % & 23-Jan & 22-Jan & 21-Jan & 20-Jan \\ \hline Assets & & & & \\ \hline \multicolumn{5}{|l|}{ Current Assets } \\ \hline Cash & - & - & * & . \\ \hline Cash And Cash Equivalents & 1,154,867,000 & 1,259,871,000 & 1,150,517,000 & 1,093,505,000 \\ \hline Short-Term investments & - & - & - & - \\ \hline Total Cash & 1,154,867,000 & 1,259,871,000 & 1,150,517,000 & 1,093,505,000 \\ \hline Receivables. & 132,906,000 & 77,001,000 & 75,708,000 & 40,219,000 \\ \hline Deferred Income Taxes & - & - & - & - \\ \hline Prepaid Expenses & 327,644,000 & 259,873,000 & 221,290,000 & 155,701,000 \\ \hline Inventory & 1,447,367,000 & 966,481,000 & 647,230,000 & 518,513,000 \\ \hline Other Current Assets & 79,962,000 & 32,550,000 & 12,270,000 & 1. \\ \hline Total Current Assets & 3,159,453,000 & 2,614,853,000 & 2,124,379,000 & 1,807,938,000 \\ \hline \multicolumn{5}{|l|}{ Non-Current Assets } \\ \hline Gross Property, Plant \& Equipment & 3,226,331,000 & 2,560,387,000 & 2,171,109,000 & 1,883,033,000 \\ \hline Accumulated Depreciation & .987,298,000 & 829,134,000 & 690,587,000 & 521,676,000 \\ \hline Net Property, Plant \& Equipment & 2,239,033,000 & 1,731,253,000 & 1,480,522,000 & 1,361,357,000 \\ \hline Goodwill & 24,144,000 & 386,880,000 & 386,877,000 & 1 \\ \hline Intangible Assets & 21,961,000 & 71,299,000 & 80,080,000 & 1. \\ \hline Other Long Term Assets & - & - & - & - \\ \hline Total Non Current Assets & 2,447,585,000 & 2,327,625,000 & 2,060,836,000 & 1,473,416,000 \\ \hline Total Assets & 5,607,038,000 & 4,942,478,000 & 4,185,215,000 & 3,281,354,000 \\ \hline \multicolumn{5}{|l|}{ Labilities and stockholders' equity } \\ \hline \multicolumn{5}{|l|}{ Liabilities } \\ \hline \multicolumn{5}{|l|}{ Current Liabilities: } \\ \hline Short-Term Debt & ? & - & - & - \\ \hline Accounts Payable & 172,732,000 & 289,728,000 & 172,246,000 & 79,997,000 \\ \hline Deferred Revenues & 251,478,000 & 208,195,000 & 155,848,000 & 133,118,000 \\ \hline Accrued Uabilities & 64,030,000 & 67,827,000 & 42,364,000 & 8,855,000 \\ \hline Total Current Liabilities & 1,492,198,000 & 1,405,334,000 & 883,178,000 & 620,418,000 \\ \hline \multicolumn{5}{|l|}{ Non-Current Liabdities } \\ \hline Long Term Debt & - & * & ; & - \\ \hline Deferred Tax Lability & - & & - & \\ \hline Minonity Interest & . & (.) & - & \\ \hline \end{tabular} Income Statement Balance Shee! Cash Flow Statement Fatio Analyais DuPont FOESROA \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|l|}{ Cash Flow Statement } \\ \hline & 2023 & 2022 & 2021 & 2020 \\ \hline Cash Flow Statement & US\$ million & US\$ million & US\$ million & USS million \\ \hline Cash from Operating Activities & $966.46 & $1,389.11 & $803.34 & $669.32 \\ \hline Deferred Taxes & 3.042 & -5.18 & 34.908 & 24.129 \\ \hline Net Income/Starting Line & 854.8 & 975.322 & 588.913 & 645.596 \\ \hline Amortization & - & - & & - \\ \hline Depreciation/Depletion & 291.791 & 224.206 & 185.478 & 161.933 \\ \hline Non-Cash Items & 413.822 & 65.629 & 41.586 & 31.729 \\ \hline Changes in Working Capital & -596.992 & 129.131 & -47.549 & -194.071 \\ \hline Cash from Investing Activities & ($569.94) & ($427.89) & ($695.53) & ($278.41) \\ \hline Capital Expenditures & -638.657 & -394.502 & -229.226 & -283.048 \\ \hline Other Investing Cash Flow Items, Total & 68.72 & -33.389 & -466.306 & 4.64 \\ \hline Cash from Financing Activities & ($467.49) & ($844.99) & ($80.79) & ($177.17) \\ \hline Total Cash Dividends Paid & - & - & - & - \\ \hline Issuance (Retirement) of Debt, Net & - & - & - & - \\ \hline Issuance (Retirement) of Stock, Net & -444.001 & -812.602 & -63.663 & -173.399 \\ \hline Financing Cash Flow Items & -23.486 & -32.385 & -17.125 & -3.774 \\ \hline \multicolumn{5}{|l|}{ Other Considerations } \\ \hline Foreign Exchange Effects & -34.043 & -6.876 & 29.996 & -1.55 \\ \hline Net Change in Cash & ($105.00) & $109.35 & $57.01 & $212.19 \\ \hline Net Cash-Beginning Balance & 1,259.87 & 1,150.52 & 1,093.51 & 881.32 \\ \hline Net Cash - Ending Balance & 1,154.87 & 1,259.87 & 1,150.52 & 1,093.51 \\ \hline \end{tabular} Income Statement Balance Sheet Cash Flow Statement Ratio Analysis DUPONE ROESROA
