Formatting Table Clipboard Font Alignmen Number Styles B1 T D F G H 1 2 3 Question 15 4.Ox 4 Directions: Credit analysis Loan amount sought as multiple of EBITDA Input the coverage ratio Input the leverage ratio Select an industry 20 5 6.OX 6 Industrials 7 8 9 10 11 You are a lender tasked with analyzing a company's loan request. To meet your loan criteria, the company must have: Average EBITDA Multiple 11.4% 11.0x 12.0x 12 13.1x 714x 13 14 115 16 Industry Biotech Technology Fintech Telecom Asset Management Commercial Banking Industrials Consumer Products Food Retail Drug Retail Broadlines Aerospace Medical Devices 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 11.2x 14.7x . 9.1% 9.0x 17 18 19 9.0x 8.6% 7.9x 13.6x 20 21 Pharma 8.4x 22 23 24 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 25 The formula should work even if new rows or columns are added to the worksheet 26 27 28 For any industry selected, calculate the amount of approved Inan 015 Ready O Type here to search or trainer 22 Merge Center - $ - % Conditional Format as Normal Formatting - Table Bad Chipboard Fond Alignment Number Styles B1 f D G H 8 9 10 11 12 13 14 15 Average EBITDA Multiple 11.4x 11.0x 12.0x 113.1x 7.4x 11.2x Industry Biotech Technology Fintech Telecom Asset Management Commercial Banking Industrials Consumer Products Food Retail Drug Retail Broadlines Aerospace Medical Devices Pharma 14.7% 9.1% . 16 17 18 9.OX 9.DX A 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 quality 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 19 8.6x 7.9x 13.6x 8.4x For any industry selected, calculate the amount of approved loan expressed as a multiple of EBITDA in cell C25 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 When you're done with this question click the done button below Done! Go to next question 0.15 Ready Type here to search acer . Formatting Table Clipboard Font Alignmen Number Styles B1 T D F G H 1 2 3 Question 15 4.Ox 4 Directions: Credit analysis Loan amount sought as multiple of EBITDA Input the coverage ratio Input the leverage ratio Select an industry 20 5 6.OX 6 Industrials 7 8 9 10 11 You are a lender tasked with analyzing a company's loan request. To meet your loan criteria, the company must have: Average EBITDA Multiple 11.4% 11.0x 12.0x 12 13.1x 714x 13 14 115 16 Industry Biotech Technology Fintech Telecom Asset Management Commercial Banking Industrials Consumer Products Food Retail Drug Retail Broadlines Aerospace Medical Devices 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 11.2x 14.7x . 9.1% 9.0x 17 18 19 9.0x 8.6% 7.9x 13.6x 20 21 Pharma 8.4x 22 23 24 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 25 The formula should work even if new rows or columns are added to the worksheet 26 27 28 For any industry selected, calculate the amount of approved Inan 015 Ready O Type here to search or trainer 22 Merge Center - $ - % Conditional Format as Normal Formatting - Table Bad Chipboard Fond Alignment Number Styles B1 f D G H 8 9 10 11 12 13 14 15 Average EBITDA Multiple 11.4x 11.0x 12.0x 113.1x 7.4x 11.2x Industry Biotech Technology Fintech Telecom Asset Management Commercial Banking Industrials Consumer Products Food Retail Drug Retail Broadlines Aerospace Medical Devices Pharma 14.7% 9.1% . 16 17 18 9.OX 9.DX A 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 quality 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 19 8.6x 7.9x 13.6x 8.4x For any industry selected, calculate the amount of approved loan expressed as a multiple of EBITDA in cell C25 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 When you're done with this question click the done button below Done! Go to next question 0.15 Ready Type here to search acer