Using Excel, calculate the amount paid the first year and the monthly payment:Formula: $=$PMT$(\%$ interest,Years,Principle$)$ Example: $=$PMT $(\mathrm{.}07,5,20000)1$st year, then divide by $12$ for monthly Pmt$\mathrm{.}18)$ $$20,0007\%5$ years $1$st year $$\_\_\_\_\_\_\_\_\_\_\_\_$ Monthly Payment $$\_\_\_\_\_\_\_19)$ $$110,0005\%15$ years $1$st year $$\_\_\_\_\_\_\_\_\_\_\_\_$ Monthly Payment $$\_\_\_\_\_\_\_20)$ $$10,0006\%7$ years $1$st year $$\_\_\_\_\_\_\_\_\_\_\_\_$ Monthly Payment $$\_\_\_\_\_\_\_21)$ $$55,0004\%6$ years $1$st year $$\_\_\_\_\_\_\_\_\_\_\_\_$ Monthly Payment $$\_\_\_\_\_\_\_$Calculate the D$/$A and D$/$E for the following company. Then, tell at first glance if you would advise the Company as Financially Healthy. Asset $=$ $$26,000$ Liability $($Debt$)=$ $$2,000$ Owners Equity $=$ $$24,00022-24)$ D$/$A $\_\_\_\_\_\_\_\_$ D$/$E $\_\_\_\_\_\_\_$ Financially Healthy Yes or No$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$Asset $=$ $$555,000$ Liability $($Debt$)=$ $$250,000$ Owners Equity $=$ $$305,00025-27)$ D$/$A $\_\_\_\_\_\_\_\_$ D$/$E $\_\_\_\_\_\_\_$ Financially Healthy Yes or No$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$Asset $=$ $$98,000$ Liability $($Debt$)=$ $$41,000$ Owners Equity $=$ $$57,00028-30)$ D$/$A $\_\_\_\_\_\_\_\_$ D$/$E $\_\_\_\_\_\_\_$ Financially Healthy Yes or No