ASSETS = LIABILITIES + STOCKHOLDERS' EQUITY $1,000,000 $900,000 $500,000 $400,000 $200,000 90 2012 2013 2014 20152016 2017 2018 2019 20202021 Liabilities Shareholders' Equity Tableau Dashboard Activity 10-1 Analyze Asset Financing through Debt versus Equity As a loan officer for Third Commercial Bank your job description includes evaluating and recommending approval of commercial and real estate loans. On your desk is a loan application from Avantgarde Manufacturing, a producer of household goods. Nine years ago, your bank declined a loan application from AvantgardeOne, partially due to a debt ratio higher than the industry average. The average percentage of assets financed by liabilities rather than stockholders' equity for the manufacturing industry is 50%. The rationale for declining the previous loan request was that too much debt posed a risk of default. To assist you in your analysis of the current loan application, you have created a Tableau Dashboard depicting trends in assets, liabilities, and equity for the most recent ten years. Drawing from the data avallable, assess the following: Complete this question by entering your answers in the tabs below. Determine the following amounts