Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help with Industry AVG and Trend Analysis calculations SAXENDA INC BALANCE SHEET PERIOD ENDING DEC 25TH 2022 (Thousands of Dollars Except Share Data) ASSETS
Please help with Industry AVG and Trend Analysis calculations
SAXENDA INC BALANCE SHEET PERIOD ENDING DEC 25TH 2022 (Thousands of Dollars Except Share Data) ASSETS Current assets \begin{tabular}{|l|r|r|r|r|} \hline Common stock of $0 par value. Authorized and 2020300,000 & shares, is:0 0 ed 149,920 share0 in 2020 \\ \hline Additional paid-in capital & 745,656 & 574,962 & 512,379 \\ \hline Retained earnings & 150,438 & 191,831 & 186,719 \\ \hline Accumulated other comprehensive (loss) earnings & 419,432 & 451,756 & 314,039 \\ \hline \end{tabular} Total shareholders' equity \begin{tabular}{lll} 1,014,651 & 1,218,550 & 1,013,138 \\ \hline \end{tabular} Total liabilities and shareholders' equity \begin{tabular}{|l|l|l|} \hline$3,065,399 & $2,867,171 & 2,673,181 \end{tabular} \begin{tabular}{|l|r|r|r|r|} \hline & Year 2022 & Year 2021 & Year 2020 & Industry Avg \\ \hline Net Profit Margin & 0.119248184 & S0.00 & 0.3557928 \\ \hline Return on Assets & 0.111655612 & 0.0017829 & 0.037935 \\ \hline Return on Equity & 0.337326825 & 0.0041951 & 0.100092 \\ \hline Average Days Payable & 118.5581209 & 87.40881453 & 101.2760267 \\ \hline Debt to Assets & 0.668998718 & 0.574999189 & 0.620999102 \\ \hline Debt to Equity & 3.021136332 & 2.352936687 & 2.638516174 \\ \hline Accounts receviable DSO & 91.25 & 73 & 73 \\ \hline Inventory Turnover & 4.275919314 & 5.28932163 & 4.76530222 \\ \hline Working Capital & & & \\ \hline Quick Ratio & 3.084755996 & 3.105810287 & 2.907354333 \\ \hline Current Ratio & 2.203393823 & 2.204780741 & 2.108628619 \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline Ratios & 9.60% & & \\ \hline Net Profit Margin & 10.45% & & \\ \hline Return on Assets & 19.20% & & \\ \hline Return on Equity & 84.9 Days & & \\ \hline AVG Days Payble & 4.8X & & \\ \hline Inventory Turnover & 79.6 Days & & \\ \hline Accounts Receivables DSO & 1.83X & & \\ \hline Current Ratio & 1.23X & 1.898309171 & 1.897613201 \\ \hline Quick Test Ratio & 98.50% & & \\ \hline Debt to Assets & & & \\ \hline Debt to Equity & & & \\ \hline \end{tabular} SAXENDA INC BALANCE SHEET PERIOD ENDING DEC 25TH 2022 (Thousands of Dollars Except Share Data) ASSETS Current assets \begin{tabular}{|l|r|r|r|r|} \hline Common stock of $0 par value. Authorized and 2020300,000 & shares, is:0 0 ed 149,920 share0 in 2020 \\ \hline Additional paid-in capital & 745,656 & 574,962 & 512,379 \\ \hline Retained earnings & 150,438 & 191,831 & 186,719 \\ \hline Accumulated other comprehensive (loss) earnings & 419,432 & 451,756 & 314,039 \\ \hline \end{tabular} Total shareholders' equity \begin{tabular}{lll} 1,014,651 & 1,218,550 & 1,013,138 \\ \hline \end{tabular} Total liabilities and shareholders' equity \begin{tabular}{|l|l|l|} \hline$3,065,399 & $2,867,171 & 2,673,181 \end{tabular} \begin{tabular}{|l|r|r|r|r|} \hline & Year 2022 & Year 2021 & Year 2020 & Industry Avg \\ \hline Net Profit Margin & 0.119248184 & S0.00 & 0.3557928 \\ \hline Return on Assets & 0.111655612 & 0.0017829 & 0.037935 \\ \hline Return on Equity & 0.337326825 & 0.0041951 & 0.100092 \\ \hline Average Days Payable & 118.5581209 & 87.40881453 & 101.2760267 \\ \hline Debt to Assets & 0.668998718 & 0.574999189 & 0.620999102 \\ \hline Debt to Equity & 3.021136332 & 2.352936687 & 2.638516174 \\ \hline Accounts receviable DSO & 91.25 & 73 & 73 \\ \hline Inventory Turnover & 4.275919314 & 5.28932163 & 4.76530222 \\ \hline Working Capital & & & \\ \hline Quick Ratio & 3.084755996 & 3.105810287 & 2.907354333 \\ \hline Current Ratio & 2.203393823 & 2.204780741 & 2.108628619 \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline Ratios & 9.60% & & \\ \hline Net Profit Margin & 10.45% & & \\ \hline Return on Assets & 19.20% & & \\ \hline Return on Equity & 84.9 Days & & \\ \hline AVG Days Payble & 4.8X & & \\ \hline Inventory Turnover & 79.6 Days & & \\ \hline Accounts Receivables DSO & 1.83X & & \\ \hline Current Ratio & 1.23X & 1.898309171 & 1.897613201 \\ \hline Quick Test Ratio & 98.50% & & \\ \hline Debt to Assets & & & \\ \hline Debt to Equity & & & \\ \hline \end{tabular} Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started