Question: You are a lender tasked with analyzing a company's 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 company's industry EV/EBITDA, the approved loan amount will be limited to 25% of the company's industry EV/EBITDA

-If the criteria for a loan are not met, output "Don't lend!"

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

pelling Thesaurus Workbook Check Smart Translate New Delete Previous Next Statistics Accessibility Lookup Comment Comment Comment Comments Sheet Workbook | Read-Only Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? UM X V fac =IF(OR( D6=(9,D6=C10,D6=C11), IF(D3