Build a Model: Ratio Analysis

Resource
Start with the partial model in the file Ch03 P15 Build a Model.xlsx from the textbook’s Web site. Joshua & White (J&W) Technology’s financial statements are also shown here. Answer the following questions. (Note: Industry average ratios are provided in Ch03 P15 Build a Model.xlsx.)
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?