Tableau Dashboard Activity 10-1 Analyze Asset Financing through Debt versus Equity As a loan office for Thed Commeresal Barik your job dercriphon includes evaluating and recommending approvat of commercial and reol estate losers. On yout desk is a loan epplication from Avertgarde Manifoctining. a producer of household goods Nine years ago your back dedined a loan applicetion fromi AvantgaideOne, partaly due to a debt ratio hagher than the industy awerage Ihe inerage Percentage of assets financed by labinies tether than stocktobders equity for the menufacturng indastry is Solk The rationale for dechining the previous lomen request was that too nuch detb posed a rak of defaul. To assist you hy your aneysis of the curtent loan ib oblea Drawing from the data available. assess the following Complete this question by entering your answers in the tabs below. Determine the following amponts. Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. What does the Dashboard suggest about the size of Avantgarde's manufacturing operations during the most recent ten ye The size of Avantgarde's mandfacturing operations as measured by total assets shows steady growet, financed primarly with debt. The size of Avantgade's manufacturing operations as measured by total assets shows steady growth, financed primaily with. Drawing from the data available, assess the following: Complete this question by entering your answers in the tabs below. Which possible conclusion is supported by the Dashboard concerning Avantgarde's ability to repay a loan if granted? The bank should decline the loan because the debt ratio is higher than the industry average of 50 if for nine of the ten years observed The bank thould consider granting the loan because the debt ratio has decined sleadey since the previous loan applicabon and is aliby below the industy average of $0 in in the most recent year. The bark probably should decine the loan because the debt tatio has declined steadly since the previous loan application and, in fact, is Wsghtly below the industry average of 50\% in the most recent year