Help answering part 12

Financial Corenants 1. Total Leverage Ratio. The Company will not, as of the last day of any fiscal quarter, permit the Total Leverage Ratio to be greater than 2.00 to 1.00. Definitions - Total Leverage Ratio: As of any date of determination, the ratio of (a) Funded Debt on such date to (b) EBITDA for the quarter ending on or immediately prior to such date. amortization and depreciation expense. -Funded Debt: As of the date of determination with respect to the Company, the sum of all liabilities of the Company due to borrowing money. The Excel file associated with this exercise includes quarterly financial information for Monroe Inc. from Quarter 1 of Year 10 to Quarter 2 of Year 12. Required 1. Download the following Excel file: Monroe Inc. 2. Determine the key financial categories needed to determine whether the company is in compliance with the three financial covenants for each quarter presented. 3. Calculate the key financial amounts within the Excel wrorksheet. Note: Enter the answer for the Total leverage ratio rounded to two digits after the decimal; for example, enter 1.42 for 1.424 or 1.43 for 1.425. Note: Enter the answier for Actual EBITDA and the 104 of total assets rounded to one digit after the decimal; for example, enter 10.4 for $10.44 or 10.5 for $10.45. lin a. Tatal leve . Actual EB c. \% Amaun1 5. List the formula for the IF statement for Q1 Year 10 for the first financial statement covenant. ppliance with the fiancial covenants. Note: Enter the answer for the Total leverage ratio rounded to two digits after the decimal; for example, enter 1.42 for 1.424 or 1.43 for 1.425. Note: Enter the answer for Actual EBITDA, and the 104t of total assets rounded to one digit after the decimal; for example, enter 10.4 for $10.44 or 10.5 for $10.45. 9. Indicate the quarter ends (if any) where the company is not in compliance with the financial covenants based on the schedule created in part 8. Note: Enter the answier for the Total leverage ratio rounded to two digits after the decimal; for example, enter 1.42 for 1.424 or 1.43 for 1.425. Note: Enter the answer for Actual EBITDA, and the 104 of total assets rounded to one digit after the decimal; for example, enter 10.4 for $10.44 or 10.5 for $10.45