Can you assist me with D. E. and F.?
d. Perform an extended DuPont analysis for J&W for 2018 and 2019. What do these results tell you? e. Perform a common size analysis. What has happened to the composition (that is, percentage in each category) of assets and liabilities? f. Perform a percentage change analysis. What does this tell you about the change in profitability and asset utilization? Joshua & White Technology: December 31 Balance Sheets (Thousands of Dollars) 2018 2019 Assets Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets 2019 $ 21,000 3,759 52,500 84,000 $ 161,259 223,097 $384,356 $ $ 20,000 3,240 48,000 56,000 $127.240 200,000 $327,240 Liabilities & Equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total common equity Total liabilities & equity $ 33,600 12,600 19929 22 $ 66,129 67,662 $ 133,791 178.440 72,125 $250,565 $384,356 2018 $ 32,000 12,000 6,480 $ 50,480 58,320 $108,800 . 178,440 40,000 $218,440 $327,240 Joshua & White Technology: Income Statements for Year Ending on December 31 (Thousands of Dollars) Sales COGS excluding depr. & amort. Depreciation and amortization Other operating expenses EBIT 2019 $420,000 300,000 19,660 27,600 $ 72,740 5,740 $ 67,000 16,750 $ 50,250 2018 $400,000 298,000 18,000 22,000 $ 62,000 4,460 $ 57,540 14,385 $ 34,524 Interest expense EBT Taxes (25%) Net income Common dividends Additions to retained earnings $ 18,125 $ 32,125 $ 17,262 $ 17,262 Other Data Year-end stock price Number of shares (Thousands) Lease payment (Thousands of Dollars) Sinking fund payment (Thousands of Dollars) 2019 $ 90.00 4,052 2018 $ 96.00 4,000 $20,000 $ 5,000 $20,000 $ 5,000 d. Perform an extended DuPont analysis for J&W for 2018 and 2019. What do these results tell you? e. Perform a common size analysis. What has happened to the composition (that is, percentage in each category) of assets and liabilities? f. Perform a percentage change analysis. What does this tell you about the change in profitability and asset utilization? Joshua & White Technology: December 31 Balance Sheets (Thousands of Dollars) 2018 2019 Assets Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets 2019 $ 21,000 3,759 52,500 84,000 $ 161,259 223,097 $384,356 $ $ 20,000 3,240 48,000 56,000 $127.240 200,000 $327,240 Liabilities & Equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total common equity Total liabilities & equity $ 33,600 12,600 19929 22 $ 66,129 67,662 $ 133,791 178.440 72,125 $250,565 $384,356 2018 $ 32,000 12,000 6,480 $ 50,480 58,320 $108,800 . 178,440 40,000 $218,440 $327,240 Joshua & White Technology: Income Statements for Year Ending on December 31 (Thousands of Dollars) Sales COGS excluding depr. & amort. Depreciation and amortization Other operating expenses EBIT 2019 $420,000 300,000 19,660 27,600 $ 72,740 5,740 $ 67,000 16,750 $ 50,250 2018 $400,000 298,000 18,000 22,000 $ 62,000 4,460 $ 57,540 14,385 $ 34,524 Interest expense EBT Taxes (25%) Net income Common dividends Additions to retained earnings $ 18,125 $ 32,125 $ 17,262 $ 17,262 Other Data Year-end stock price Number of shares (Thousands) Lease payment (Thousands of Dollars) Sinking fund payment (Thousands of Dollars) 2019 $ 90.00 4,052 2018 $ 96.00 4,000 $20,000 $ 5,000 $20,000 $ 5,000
