Excel Question

Question is Directions: - 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 "Dont lend!" - The formula should work even if new rows or columns are added to the worksheet - For any industry selected, calculate the amount of approved loan expressed as a multiple of EBITDA in cell C25 - When you're done with this question, click the done button below For any industry selected, calculate the amount of approved loan expressed as a multiple of EBITDA in cell C25 Question is Directions: - 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 "Dont lend!" - The formula should work even if new rows or columns are added to the worksheet - For any industry selected, calculate the amount of approved loan expressed as a multiple of EBITDA in cell C25 - When you're done with this question, click the done button below For any industry selected, calculate the amount of approved loan expressed as a multiple of EBITDA in cell C25