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 AvanfgardeOne, partially due to a debt ratio higher than the industry average. The average percentage of assets financed by liabilities rather than stockhoiders' equity for the manufocturing 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.

TOTALASSETS

ASSETS $=$ LIABILITIES $+$ STOCKHOLDERS' EOIITY

$$ View on Tableau Public

Drawing from the data available, assess the following:

Complete this question by entering your answers in the tabs below.

Required $1$

Determine the following amounts.

Assots in $2012$

Assets in $2021$

Wights managed centenc. Tablew graf