Answered step by step
Verified Expert Solution
Link Copied!

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. Thanksimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

\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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions