Question: please solve this 'articipant name: Here is your task For this task you will continue using the Microsoft Excel Participant Template from Task 1 (reuploaded




'articipant name: Here is your task For this task you will continue using the Microsoft Excel Participant Template from Task 1 (reuploaded below for your reterence) In the second tab labeled "Transaction Overview", you will need to complete the Capitalization Table section by filling out the sections highlighted in yellow. Please fill out the amounts using the Sources and Uses table (in the same 'Transaction Overview' tab) as a guide to how the debt of the company will change post-transaction. The leverage will calculate automatically once you enter in the debt amounts, \begin{tabular}{|c|c|} \hline Sources (5mm) & \\ \hline New Revolving Credit Facility & 126.0 \\ \hline Total Sources & $126.0 \\ \hline Uses ( 5mm ) & \\ \hline Repay Tranche A & 80.0 \\ \hline Repay Tranche B & 46.0 \\ \hline Total Uses & $126.0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & \multicolumn{2}{|c|}{ Before Transaction } & \multicolumn{2}{|c|}{ After Transaction } \\ \hline(5mm) & Amount & x EBITDA & Amount & x \\ \hline Tranche A & 80.0 & 0.8x & & \\ \hline Tranche B & 46.0 & 0.5x & & \\ \hline New Revolving Credit Facility & & & & \\ \hline Total Debt & 126.0 & 1.3x & 0.0 & \\ \hline Adjusted EBITOA & $99.8 & & $99.8 & \\ \hline \end{tabular} 'articipant name: Here is your task For this task you will continue using the Microsoft Excel Participant Template from Task 1 (reuploaded below for your reterence) In the second tab labeled "Transaction Overview", you will need to complete the Capitalization Table section by filling out the sections highlighted in yellow. Please fill out the amounts using the Sources and Uses table (in the same 'Transaction Overview' tab) as a guide to how the debt of the company will change post-transaction. The leverage will calculate automatically once you enter in the debt amounts, \begin{tabular}{|c|c|} \hline Sources (5mm) & \\ \hline New Revolving Credit Facility & 126.0 \\ \hline Total Sources & $126.0 \\ \hline Uses ( 5mm ) & \\ \hline Repay Tranche A & 80.0 \\ \hline Repay Tranche B & 46.0 \\ \hline Total Uses & $126.0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & \multicolumn{2}{|c|}{ Before Transaction } & \multicolumn{2}{|c|}{ After Transaction } \\ \hline(5mm) & Amount & x EBITDA & Amount & x \\ \hline Tranche A & 80.0 & 0.8x & & \\ \hline Tranche B & 46.0 & 0.5x & & \\ \hline New Revolving Credit Facility & & & & \\ \hline Total Debt & 126.0 & 1.3x & 0.0 & \\ \hline Adjusted EBITOA & $99.8 & & $99.8 & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
