Build a Model: Ratio Analysis Start with the partial model in the file Ch03 P15 Build a Model.xls from the textbook?s Web site. Joshua & White (J&W) Technologies?s financial statements are also shown below. Answer the following questions. (Note: Industry average ratios are provided in Ch03 P15 Build a Model.xls.) Has J&W?s liquidity position improved or worsened? Explain. Has J&W?s ability to manage its assets improved or worsened? Explain. How has J&W?s profitability changed during the last year? Perform an extended DuPont analysis for J&W for 2012 and 2013. What do these results tell you? Perform a common size analysis. What has happened to the composition (that is, percentage in each category) of assets and liabilities? Perform a percentage change analysis. What does this tell you about the change in profitability and asset utilization?

Build a Model: Ratio Analysis Start with the partial model in the file Ch03 P15 Build a Model.xls from the textbook's Web site. Joshua & White (J&W) Technologies's financial statements are also shown below. Answer the following questions. (Note: Industry average ratios are provided in Ch03 P15 Build a Model.xls.) 1. 2. 3. 4. Has J&W's liquidity position improved or worsened? Explain. Has J&W's ability to manage its assets improved or worsened? Explain. How has J&W's profitability changed during the last year? Perform an extended DuPont analysis for J&W for 2012 and 2013. What do these results tell you? 5. Perform a common size analysis. What has happened to the composition (that is, percentage in each category) of assets and liabilities? 6. Perform a percentage change analysis. What does this tell you about the change in profitability and asset utilization