Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2019 2018 Cash and cash equivalents $21,000 $20.000 Short-term investments 3,759 3.240 Accounts Receivable 52,500 48.000 Inventories 84.000 56.000 Total current assets $161.259 $127.240 Net fixed assets 223.097 200.000 Total assets $384.356 $327 240 Liabilities and equity Accounts payable $33,600 $32.000 Accruals 12.600 12.000 Notes payable 19.929 6.480 Total current liabilities $66.129 $50,480 Long-term debt 67 662 58 320 Total liabilities $133.791 $108.800 Common stock 178,440 178.440 Retained Earings 72 125 40.000 Total common equity $250 565 $218 440 Total liabilities and equity $384.356 $327 240 EBT Joshua & White Technologies December 31 Income Statements (Thousands of Dollars) 2019 2018 Sales $420,000 $400.000 COGS except excluding depr. and amort 300,000 298,000 Depreciation and Amortization 19,660 18,000 Other operating expenses 27.600 22.000 EBIT $72.740 $62,000 Interest Expense 5.740 4.460 $67.000 $57.540 Taxes (25%) 16.750 14.385 Net Income $50.250 $34524 Common dividends $18.125 $17.262 Addition to retained earnings $32.125 $17.262 Other Data 2019 20181 Year-end Stock Price $90.00 $96.00 # of shares (Thousands) 4,052 4,000 Lease payment (Thousands of Dollars) $20,000 $20,000 Sinking fund payment (Thousands of Dollars) $5,000 $5,000 Ratio Analysis 2018 Industry Avg Liquidity Ratios Current Ratio Quick Ratio Asset Management Ratios Inventory Turnover (Total COGS/Inventories) Days Sales Outstanding Fixed Assets Turnover Total Assets Turnover Debt Management Ratios Debt Ratio (Total debt-to-assets) Liabilities-to-assets ratio Times-interest-eamed ratio EBITDA coverage ratio Profitability Ratios 2019 2.58 1.53 7.69 47.45 2.04 1.23 20.0% 32.1% 15.33 4.18 8.86% 19.48% 10.93% 16.10% Profitability Ratios Profit Margin Basic Earning Power Return on Assets Return on Equity Market Value Ratios Eamings per share Price-to-earnings ratio Cash flow per share Price-to-cash flow ratio Book Value per share Market-to-book ratio NA 10.65 NA 7.11 NA 1.72 a. Has Joshua & White's liquidity position improved or worsened? Explain. b. Has Joshua & White's ability to manage its assets improved or worsened? Explain. 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. ROE = PM XTA Tunover X Equity Multiplier 2019 20.05% 11.96% 1.09 1.53 2018 15.80% 8.63% 1.22 1.50 e. Perform a common size analysis. What has happened to the composition (that is, percentage in each category) of assets and liabilities? 2019 2018 Common Size Balance Sheets Assets Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net foxed assets Total assets 20191 2018 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 20191 2018 Common Size Income Statements Sales COGS except excluding depr. and amort. Depreciation and Amortization Other operating expenses EBIT Interest Expense EBT Taxes (25) FOIS 2019 2018 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 2019 2018 Common Size Income Statements Sales COGS except excluding depr. and amort. Depreciation and Amortization Other operating expenses EBIT Interest Expense EBT Taxes (25%) Net Income 1. Perform a percent change analysis. What does this tell you about the change in profitability and asset utilization? Percent Change Balance Sheets Base Assets 2019 2018 Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net fixed assets Total assets Base Liabilities and equity 2019 2018 Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity Base Percent Change Income Statements 2019 2018 Sales COGS except excluding depr. and amort. Depreciation and Amortization Other operating expenses EBIT Interest Expense EBT Taxes (25%) Noticom Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2019 2018 Cash and cash equivalents $21,000 $20.000 Short-term investments 3,759 3.240 Accounts Receivable 52,500 48.000 Inventories 84.000 56.000 Total current assets $161.259 $127.240 Net fixed assets 223.097 200.000 Total assets $384.356 $327 240 Liabilities and equity Accounts payable $33,600 $32.000 Accruals 12.600 12.000 Notes payable 19.929 6.480 Total current liabilities $66.129 $50,480 Long-term debt 67 662 58 320 Total liabilities $133.791 $108.800 Common stock 178,440 178.440 Retained Earings 72 125 40.000 Total common equity $250 565 $218 440 Total liabilities and equity $384.356 $327 240 EBT Joshua & White Technologies December 31 Income Statements (Thousands of Dollars) 2019 2018 Sales $420,000 $400.000 COGS except excluding depr. and amort 300,000 298,000 Depreciation and Amortization 19,660 18,000 Other operating expenses 27.600 22.000 EBIT $72.740 $62,000 Interest Expense 5.740 4.460 $67.000 $57.540 Taxes (25%) 16.750 14.385 Net Income $50.250 $34524 Common dividends $18.125 $17.262 Addition to retained earnings $32.125 $17.262 Other Data 2019 20181 Year-end Stock Price $90.00 $96.00 # of shares (Thousands) 4,052 4,000 Lease payment (Thousands of Dollars) $20,000 $20,000 Sinking fund payment (Thousands of Dollars) $5,000 $5,000 Ratio Analysis 2018 Industry Avg Liquidity Ratios Current Ratio Quick Ratio Asset Management Ratios Inventory Turnover (Total COGS/Inventories) Days Sales Outstanding Fixed Assets Turnover Total Assets Turnover Debt Management Ratios Debt Ratio (Total debt-to-assets) Liabilities-to-assets ratio Times-interest-eamed ratio EBITDA coverage ratio Profitability Ratios 2019 2.58 1.53 7.69 47.45 2.04 1.23 20.0% 32.1% 15.33 4.18 8.86% 19.48% 10.93% 16.10% Profitability Ratios Profit Margin Basic Earning Power Return on Assets Return on Equity Market Value Ratios Eamings per share Price-to-earnings ratio Cash flow per share Price-to-cash flow ratio Book Value per share Market-to-book ratio NA 10.65 NA 7.11 NA 1.72 a. Has Joshua & White's liquidity position improved or worsened? Explain. b. Has Joshua & White's ability to manage its assets improved or worsened? Explain. 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. ROE = PM XTA Tunover X Equity Multiplier 2019 20.05% 11.96% 1.09 1.53 2018 15.80% 8.63% 1.22 1.50 e. Perform a common size analysis. What has happened to the composition (that is, percentage in each category) of assets and liabilities? 2019 2018 Common Size Balance Sheets Assets Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net foxed assets Total assets 20191 2018 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 20191 2018 Common Size Income Statements Sales COGS except excluding depr. and amort. Depreciation and Amortization Other operating expenses EBIT Interest Expense EBT Taxes (25) FOIS 2019 2018 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 2019 2018 Common Size Income Statements Sales COGS except excluding depr. and amort. Depreciation and Amortization Other operating expenses EBIT Interest Expense EBT Taxes (25%) Net Income 1. Perform a percent change analysis. What does this tell you about the change in profitability and asset utilization? Percent Change Balance Sheets Base Assets 2019 2018 Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net fixed assets Total assets Base Liabilities and equity 2019 2018 Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity Base Percent Change Income Statements 2019 2018 Sales COGS except excluding depr. and amort. Depreciation and Amortization Other operating expenses EBIT Interest Expense EBT Taxes (25%) Noticom