Question: 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. ThanksPlease solve for the answer in the highlighted yellow cells. Very importantto make sure each cell shows how the solution was gotten byreferencing the cell used in the calculation. Thanks \begin{tabular}{l|l|l|l|l|} \hline Common SizeIncome Statements & 2023 & 2022 \\ \hline Sales & & \\\hline COGS except excluding depr. and amort. \\ Depreciation and Amortization \\

\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 equity

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!