Use the following information about XYZ Plumbing (FY=12/31), a public company with the most recent closing stock price of $6.00 (used for Diluted Shares calculations), to answer the following three problems:

Use the following information about XYZ Plumbing (FY=12/31), a public company with the most recent closing stock price of $6.00 (used for Diluted Shares calculations), to answer the following three problems:

Problem 3 Projections Admin Revenue (Increase of 20\% from 2021) CGS Gross Profit (Gross Margin increases by 0.5\% from 2021) \begin{tabular}{|l|l|r|} \hline 2023E & Key & \multicolumn{1}{|c|}{ Pts } \\ \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline \end{tabular} SG\&A (Improves by 1.5% from 2021) R&D (Increases by 10% in total dollars from 2021) Deprec \& Amort (no change from 2021) Total Op. Expense \begin{tabular}{|l|l|l|} \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline \end{tabular} Operating Profit \begin{tabular}{|l|l|l|} \hline & & 2 \\ \hline \end{tabular} Interest cost (given) Interest income (given) Pre-Tax Tax (21\% rate) Net Income \begin{tabular}{|l|l|l|} \hline & & 1 \\ \hline & & 1 \\ \hline & & 2 \\ \hline \end{tabular} EPS - Basic EPS - Diluted (See Information sheet for Equity Structure) \begin{tabular}{|l|l|l|} \hline$0 & & 1 \\ \hline & & 8 \\ \hline \end{tabular} Problem 2 or Brown boxes below Analysis Current Ratio Quick Ratio Gross Margin Operating Margin Accounts Receivable turnover Inventory turnover Total asset turnover Debt to Equity Return on Equity \begin{tabular}{|l|l|r|} \hline \multicolumn{2}{|c|}{ Admin } \\ \hline 2021 & Key & Pts \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 4 \\ \hline \end{tabular} Problem 3 Projections Admin Revenue (Increase of 20\% from 2021) CGS Gross Profit (Gross Margin increases by 0.5\% from 2021) \begin{tabular}{|l|l|r|} \hline 2023E & Key & \multicolumn{1}{|c|}{ Pts } \\ \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline \end{tabular} SG\&A (Improves by 1.5% from 2021) R&D (Increases by 10% in total dollars from 2021) Deprec \& Amort (no change from 2021) Total Op. Expense \begin{tabular}{|l|l|l|} \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline \end{tabular} Operating Profit \begin{tabular}{|l|l|l|} \hline & & 2 \\ \hline \end{tabular} Interest cost (given) Interest income (given) Pre-Tax Tax (21\% rate) Net Income \begin{tabular}{|l|l|l|} \hline & & 1 \\ \hline & & 1 \\ \hline & & 2 \\ \hline \end{tabular} EPS - Basic EPS - Diluted (See Information sheet for Equity Structure) \begin{tabular}{|l|l|l|} \hline$0 & & 1 \\ \hline & & 8 \\ \hline \end{tabular} Problem 2 or Brown boxes below Analysis Current Ratio Quick Ratio Gross Margin Operating Margin Accounts Receivable turnover Inventory turnover Total asset turnover Debt to Equity Return on Equity \begin{tabular}{|l|l|r|} \hline \multicolumn{2}{|c|}{ Admin } \\ \hline 2021 & Key & Pts \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 4 \\ \hline \end{tabular} PROBLEM SOLVING Problem 1 Blue or Brown Statement of Cash Flows Net Income Adjustments Depreciation and amortization Cash Provided by Operating Assets and Liabilities \begin{tabular}{|l|l|} \hline Accounts Receivable & \\ \hline Inventories & \\ \hline Pre-paid expenses & \\ \hline Accounts payable & \\ \hline Accrued liabilities & \\ \hline Net Cash provided (used) by operating activities & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline & 2 \\ \hline & 2 \\ \hline & 2 \\ \hline & 2 \\ \hline & 2 \\ \cline { 2 - 3 } & 2 \\ \hline \end{tabular} Cash Provided from Investing Activities Additions to property, plant and equipment Net Cash provided (used) by investing activities \begin{tabular}{|l|l|} \hline & 2 \\ \hline & 2 \\ \hline \end{tabular} Cash Provided from Financing Activities Additions to long term borrowing Addition to short term borrowing Net Cash provided (used) by financing activities \begin{tabular}{|l|l|} \hline & 2 \\ \hline & 2 \\ \hline & 2 \\ \hline \end{tabular} Net Cash Flow Problem 3 Projections Admin Revenue (Increase of 20\% from 2021) CGS Gross Profit (Gross Margin increases by 0.5\% from 2021) \begin{tabular}{|l|l|r|} \hline 2023E & Key & \multicolumn{1}{|c|}{ Pts } \\ \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline \end{tabular} SG\&A (Improves by 1.5% from 2021) R&D (Increases by 10% in total dollars from 2021) Deprec \& Amort (no change from 2021) Total Op. Expense \begin{tabular}{|l|l|l|} \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline \end{tabular} Operating Profit \begin{tabular}{|l|l|l|} \hline & & 2 \\ \hline \end{tabular} Interest cost (given) Interest income (given) Pre-Tax Tax (21\% rate) Net Income \begin{tabular}{|l|l|l|} \hline & & 1 \\ \hline & & 1 \\ \hline & & 2 \\ \hline \end{tabular} EPS - Basic EPS - Diluted (See Information sheet for Equity Structure) \begin{tabular}{|l|l|l|} \hline$0 & & 1 \\ \hline & & 8 \\ \hline \end{tabular} Problem 2 or Brown boxes below Analysis Current Ratio Quick Ratio Gross Margin Operating Margin Accounts Receivable turnover Inventory turnover Total asset turnover Debt to Equity Return on Equity \begin{tabular}{|l|l|r|} \hline \multicolumn{2}{|c|}{ Admin } \\ \hline 2021 & Key & Pts \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 4 \\ \hline \end{tabular} Problem 3 Projections Admin Revenue (Increase of 20\% from 2021) CGS Gross Profit (Gross Margin increases by 0.5\% from 2021) \begin{tabular}{|l|l|r|} \hline 2023E & Key & \multicolumn{1}{|c|}{ Pts } \\ \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline \end{tabular} SG\&A (Improves by 1.5% from 2021) R&D (Increases by 10% in total dollars from 2021) Deprec \& Amort (no change from 2021) Total Op. Expense \begin{tabular}{|l|l|l|} \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline & & 1 \\ \hline \end{tabular} Operating Profit \begin{tabular}{|l|l|l|} \hline & & 2 \\ \hline \end{tabular} Interest cost (given) Interest income (given) Pre-Tax Tax (21\% rate) Net Income \begin{tabular}{|l|l|l|} \hline & & 1 \\ \hline & & 1 \\ \hline & & 2 \\ \hline \end{tabular} EPS - Basic EPS - Diluted (See Information sheet for Equity Structure) \begin{tabular}{|l|l|l|} \hline$0 & & 1 \\ \hline & & 8 \\ \hline \end{tabular} Problem 2 or Brown boxes below Analysis Current Ratio Quick Ratio Gross Margin Operating Margin Accounts Receivable turnover Inventory turnover Total asset turnover Debt to Equity Return on Equity \begin{tabular}{|l|l|r|} \hline \multicolumn{2}{|c|}{ Admin } \\ \hline 2021 & Key & Pts \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 2 \\ \hline & & 4 \\ \hline \end{tabular} PROBLEM SOLVING Problem 1 Blue or Brown Statement of Cash Flows Net Income Adjustments Depreciation and amortization Cash Provided by Operating Assets and Liabilities \begin{tabular}{|l|l|} \hline Accounts Receivable & \\ \hline Inventories & \\ \hline Pre-paid expenses & \\ \hline Accounts payable & \\ \hline Accrued liabilities & \\ \hline Net Cash provided (used) by operating activities & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline & 2 \\ \hline & 2 \\ \hline & 2 \\ \hline & 2 \\ \hline & 2 \\ \cline { 2 - 3 } & 2 \\ \hline \end{tabular} Cash Provided from Investing Activities Additions to property, plant and equipment Net Cash provided (used) by investing activities \begin{tabular}{|l|l|} \hline & 2 \\ \hline & 2 \\ \hline \end{tabular} Cash Provided from Financing Activities Additions to long term borrowing Addition to short term borrowing Net Cash provided (used) by financing activities \begin{tabular}{|l|l|} \hline & 2 \\ \hline & 2 \\ \hline & 2 \\ \hline \end{tabular} Net Cash Flow