Meta Manufacturers is applying for a loan from Third Mercantile Bank for the purpose of updating its factories. As the bank's credit analyst. you are investigating the advisability of making the loan. As one step in the analysis, you have determined that Meta's debt to equity ratio is sufficiently low to support additional debt, but to continue your investigation you are examining the prospective borrower's asset management, initially focusing on the fixed asset turnover ratio. This ratio will allow you to measure the amount of sales that Meta generates for every dollar invested in fixed assets. You measure this metric as net sales divided by average depreciable assets, where fixed assets are net of accumulated depreciation and exclude land. It's useful to track this metric over time to detect patterns and to compare it with industry norms. A quick Google search indicates the average turnover for Meta's industry is 3.80 Fixed Asset Turnover Ratio Net Depreciable Assets Fixed Asset Turnover Kniel Net Depreciables Net 600 COMPOSITION OF ASSETS 2015 2016 2013 2018 2019 2020 $300,00 2021 $400,000 200 500.000 500 200 Fordset LO (SIDO. Fixed Asset Turnover Ratio Total Fixed Assets Averpt Fixed Assets Fixed Asset Tomover Ratio Notales 00 Sto0.00 $500.000 4.00 300,000) S100.000 Fine Art Turner Ratio 500.000 Consolam Bond 30 0.00 2014 2015 2016 2017 2018 2019 2020 2021 tableau You have asked your assistant to create a Tableau Dashboard depicting trends in the numerator - net sales the denominator - average net depreciable assets, and the fixed asset turnover ratio itself for the most recent eight years. You also requested data on the composition of Meta's fixed assets, and a secondary measure of the fixed asset turnover ratio in which land is included and accumulated depreciation is excluded in the calculation Drawing from the data available, assess the following Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 What were Meta's fixed asset (net depreciable assets) turnover ratios in 2014 and in 20212 53.67 in 2014 and 528 in 2021 528 in 2014 and 3 67 in 2021 3 50 in 2014 and 525 in 2021 Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 What does the Dashboard suggest about Meta's fixed asset (net depreciable assets) turnover ratio during the most recent eight years? The ratio is decreasing but is above industry norms. The ratio is increasing quite rapidly and recently is above the industry average The ratio is thing but still below industry norms Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 What is a reason for the trend in the fixed asset turnover ratio during the most recent eight years? The denominator - average net depreciable assets - is decreasing The numerator - net sales - is decreasing The numerator - net sales - is increasing Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Which possible conclusion is supported by the Dashboard concerning Meta's fixed asset turnover ratio when calculated without including accumulated depreciation and land? The growth in accumulated depreciation relative to that of depreciable assets seems to be the primary reason for the reversal of the trend in the turnover ratio when calculated with and without including accumulated depreciation and land. The size of the company's land holdings seems to be the primary reason for the reversal of the trend in the turnover ratio when calculated with and without including accumulated depreciation and land When excluding accumulated depreciation and land, the fired assof turnover metric is smaller but continues to reflect growth over the wight-year period Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 What does the Dashboard suggest about Meta's fixed asset (net depreciable assets) turnover ratio during the most recent eight years? The ratio is decreasing but is above industry norms. The ratio is increasing quite rapidly and recently is above the industry average The ratio is thing but still below industry norms Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 What is a reason for the trend in the fixed asset turnover ratio during the most recent eight years? The denominator - average net depreciable assets - is decreasing The numerator - net sales - is decreasing The numerator - net sales - is increasing Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Which possible conclusion is supported by the Dashboard concerning Meta's fixed asset turnover ratio when calculated without including accumulated depreciation and land? The growth in accumulated depreciation relative to that of depreciable assets seems to be the primary reason for the reversal of the trend in the turnover ratio when calculated with and without including accumulated depreciation and land. The size of the company's land holdings seems to be the primary reason for the reversal of the trend in the turnover ratio when calculated with and without including accumulated depreciation and land When excluding accumulated depreciation and land, the fired assof turnover metric is smaller but continues to reflect growth over the wight-year period