Question: You are a lender tasked with analyzing a companys loan request. To meet your loan criteria, the company must have:

-Coverage ratio and leverage ratio in excess of 1x and 5x, respectively

-The exceptions are Fintech, Technology, and Biotech firms, which qualify for a loan regardless of the coverage and leverage ratios

-If the loan amount requested (expressed as a multiple of EBITDA) is greater than 25% of the companys industry EV/EBITDA, the approved loan amount will be limited to 25% of the companys industry EV/EBITDA

-If the criteria for a loan are not met, output Dont lend!

-For any industry selected, calculate the amount of approved loan expressed as a multiple of EBITDA in cell C25

Open recovered workbooks? Your recent changes were saved. Do you want to continue Working Wh SUM fx=IF(OR(D6=C9,D6=C10, B C Credit analysis Loan amount sought as multiple of EBITDA 1 Input the coverage ratio Input the leverage ratio Select an industry Industry I Biotech ITechnology I Fintech 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 D6=C11),IF(D3