Joshua \& White Technoloaies: December 31 Balance Sheets (Thousands of Dollars) Joshua \& White Technoloav: Income Statements for Year Endina on December 31 (Thousands of Dollars) a Neterminina whether. IRW'e linuidity ne Current ratio Ouick ratio = imnroved ar woreaned or b. Determining whether J\&W's abilitv to manace its assets has imnroved or worsened e. Perform a common size analysis. Joshua \& White Technology: Common Size Income Statements for Year Ending on December 31 What has happened to the composition (that is, percentage in each category) of assets and liabilities? Inventories now make up a proportion of current assets and accounts payable make up a proportion of current liabilities. f. Perform a percentage change analysis. Joshua \& White Technology: December 31 Percent Change Balance Sheet What has happened to the composition (that is, percentage in each category) of assets and liabilities? Inventories now make up c proportion of current assets and accounts payable make up a proportion of current liabilities. f. Perform a percentage change analysis. Joshua \& White Technology: December 31 Percent Change Balance Sheet Joshua \& White Technology: Percent Change Income Statement for Year Ending on December 31 Darrent What does this tell you about the change in profitability and asset utilization? The profitability has However, the extreme growth in should be of great concern to J\&W's managers. Start with the partial model in the file Ch07 P15 Build a Model.xIsx. Joshua \& White (J\&W) Technology's financial statements are also shown here. Joshua \& White Technology: December 31 Balance Sheets (Thousands of Dollars) Joshua \& White Technology: Income Statements for Year Ending on December 31 (Thousands of Dollars) 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 ". b. Determinina whether J\&W's abilitv to manace its assets has imnroved or worsened nave in a voar 365 a. Has J\&W's liquidity position improved or worsened? Explain. The firm's current ratio has and the quick ratio has indicating that J\&W's liquidity position has b. Has J\&W's ability to manage its assets improved or worsened? Explain. Assume that there are 365 days in a year. The firm's inventory turnover has the fixed assets turnover has turnover has its assets has c. How has J\&W's profitability changed during the last year? The firm's profit margin has has the return on assets has on equity has indicating that J\&W's profitability has d. Perform an extended DuPont analysis for J\&W for 2020 and 2021. What do these results tell you? The ROE has because the profit margin has and the equity multiplier has despite the fact that the total asset turnover ratio has e. Perform a common size analysis