Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please solve for the answer in the highlighted yellow cells. Very important to make sure each cell shows how the solution was gotten by referencing
Please solve for the answer in the highlighted yellow cells. Very important to make sure each cell shows how the solution was gotten by referencing the cell used in the calculation. Thanks
\begin{tabular}{l|l|l|l|l|} \hline Common Size Income Statements & 2023 & 2022 \\ \hline Sales & & \\ \hline COGS except excluding depr. and amort. \\ Depreciation and Amortization \\ Other operating expenses & \\ \hline EBIT \\ nterest Expense & \\ \hline EBT & & \\ \hline Taxes (25\%) & & \\ \hline Net Income & & & \\ \hline \end{tabular} Perform a percent change analysis. What does this tell you about the change in profitability and asset utilization? Percent Change Balance Sheets Assets \begin{tabular}{r|r|} & Base \\ \hline 2023 & 2022 \\ \hline \end{tabular} Cash and cash equivalents Short-term investments Accounts Receivable nventories Total current assets Net fixed assets Total assets Liabilities and equity 2023 Base Accounts payable Accruals Notes payable Total current liabilities -ong-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity he current ratio and quick ratio were a little below the industry average initially. However, the quick ratio fell by lot while the current ratio fell by just a little. This indicates a build-up in inventory relative to other current assets \begin{tabular}{|l|l|l|l|l|} \hline Percent Change Income Statements & 2023 & 2022 \\ \hline Sales & & \\ \hline COGS except excluding depr. and amort. \\ \hline Depreciation and Amortization & & \\ \hline Other operating expenses & & \\ \hline EBIT & & \\ \hline Interest Expense & & \\ \hline EBT & & \\ \hline Taxes (25\%) & & \\ \hline Net Income & & & \\ \hline & & & \\ \hline \end{tabular} c. How has Joshua \& White's profitability changed during the last year? d. Perform an extended Du Pont analysis for Joshua \& White for each year. 20232022 ROE=PMxTATurnoverxEquityMultiplier e. Perform a common size analysis. What has happened to the composition (that is, percentage in each category) of assets and liabilities? Common Size Balance Sheets Assets Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net fixed assets Total assets Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equityStep 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