Assets

Cash $ $20,475$ $ $19,500$

Short$-$term investments $4,3173,120$

Accounts receivable $55,50050,500$

Inventories $83,00058,500$

Total current assets $ $163,292$ $ $131,620$

Net fixed assets $224,971200,000$

Total assets $ $388,263$ $ $331,620$

Liabilities & Equity

Accounts payable $ $36,750$ $ $35,000$

Accruals $11,02510,500$

Notes payable $19,4555,960$

Total current liabilities $ $67,230$ $ $51,460$

Long$-$term debt $63,29854,940$

Total liabilities $ $130,528$ $ $106,400$

Common stock $197,500197,500$

Retained earnings $60,23527,720$

Total common equity $ $257,735$ $ $225,220$

Total liabilities & equity $ $388,263$ $ $331,620$

Joshua & White Technology: Income Statements for Year

Ending on December $31($Thousands of Dollars$)$

$20212020$

Sales $ $414,750$ $ $395,000$

COGS excluding depreciation and amortization $297,250296,250$

Depreciation and amortization $19,75018,000$

Other operating expenses $24,45019,750$

EBIT $ $73,300$ $ $61,000$

Interest expense $5,5204,280$

EBT $ $67,780$ $ $56,720$

Taxes $(25\%)16,94514,180$

Net income $ $50,835$ $ $42,540$

Common dividends $ $18,320$ $ $17,016$

Additions to retained earnings $ $32,515$ $ $25,524$

Other Data $20212020$

Year$-$end stock price $ $78\mathrm{.}00$ $ $85\mathrm{.}00$

Number of shares $($Thousands$)5,0565,000$

Lease payment $($Thousands of Dollars$)$ $ $19,000$ $ $19,000$

Sinking fund payment $($Thousands of Dollars$)$ $ $6,000$ $ $6,000$

The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers to two decimal places. If your answer is zero, enter $"0".$

Download spreadsheet Ch$07$ P$15$ Build a Model$-$e$27$dea.xlsx

Has J&W$\text{'}$s liquidity position improved or worsened? Explain.

$20212020$ Industry Average

Current ratio fill in the blank $2$

fill in the blank $3$

$2\mathrm{.}62$

Quick ratio fill in the blank $4$

fill in the blank $5$

$1\mathrm{.}54$

The firm's current ratio has

declined

$,$ and the quick ratio has

declined

$,$ indicating that J&W$\text{'}$s liquidity position has

worsened

$.$

Has J&W$\text{'}$s ability to manage its assets improved or worsened? Explain. Assume that there are $365$ days in a year.

$20212020$ Industry Average

Inventory turnover fill in the blank $9$

$1\mathrm{.}07$

fill in the blank $10$

$7\mathrm{.}60$

Days sales outstanding $($days$)$ fill in the blank $11$

$99\mathrm{.}93$

fill in the blank $12$

$50\mathrm{.}63$

Fixed assets turnover fill in the blank $13$

fill in the blank $14$

$2\mathrm{.}02$

Total assets turnover fill in the blank $15$

fill in the blank $16$

$1\mathrm{.}22$

The firm's inventory turnover has

declined

$,$ the DSO has

increased

$,$ the fixed assets turnover has

declined

$,$ and the total assets turnover has

declined

$,$ indicating that J&W$\text{'}$s ability to manage its assets has

worsened

$.$

How has J&W$\text{'}$s profitability changed during the last year?

$20212020$ Industry Average

Profit margin fill in the blank $22$

$\%$ fill in the blank $23$

$\%11\mathrm{.}22\%$

Basic earning power fill in the blank $24$

$\%$ fill in the blank $25$

$\%19\mathrm{.}19\%$

Return on assets fill in the blank $26$

$\%$ fill in the blank $27$

$\%13\mathrm{.}45\%$

Return on equity fill in the blank $28$

$\%$ fill in the blank $29$

$\%19\mathrm{.}33\%$

The firm's profit margin has

declined

$,$ the basic earning power has

increased

$,$ the return on assets has

declined

$,$ and the return on equity has

declined

$,$ indicating that J&W$\text{'}$s profitability has

improved

$.$

Perform an extended DuPont analysis for J&W for $2020$ and $2021.$

Profit margin TA turnover Equity multiplier ROE

$2021$ fill in the blank $35$

$\%\backslash$times fill in the blank $36$

$\backslash$times fill in the blank $37$

$=$ fill in the blank $38$

$\%$

$2020$ fill in the blank $39$

$\%\backslash$times fill in the blank $40$

$\backslash$times fill in the blank $41$

$=$ fill in the blank $42$

$\%$

What do these results tell you?

The ROE has

improved

because the profit margin has

declined

$,$ and the equity multiplier has

declined

$,$ despite the fact that the total asset turnover ratio has

declined

$.$

Perform a common size analysis.

Joshua & White Technology: December $31$ Common Size Balance Sheets

$20212020$

Assets

Cash fill in the blank $47$

$\%$ fill in the blank $48$

$\%$

Short$-$term investments fill in the blank $49$

$\%$ fill in the blank $50$

$\%$

Accounts receivable fill in the blank $51$

$113548\mathrm{.}63\%$

$\%$ fill in the blank $52$

$\%$

Inventories fill in the blank $53$

$27850\mathrm{.}09\%$

$\%$ fill in the blank $54$

$\%$

Total current assets fill in the blank $55$

$\%$ fill in the blank $56$

$\%$

Net fixed assets fill in the blank $57$

$\%$ fill in the blank $58$

$\%$

Total assets fill in the blank $59$

$\%$ fill in the blank $60$

$\%$

Liabilities & Equity

Accounts payable fill in the blank $61$

$1299010406\mathrm{.}00\%$

$\%$ fill in the blank $62$

$\%$

Accruals fill in the blank $63$

$\%$ fill in the blank $64$

$\%$

Notes payable fill in the blank $65$

$\%$ fill in the blank $66$

$\%$

Total current liabilities fill in the blank $67$

$\%$ fill in the blank $68$

$\%$

Long$-$term debt fill in the blank $69$

$\%$ f