For the next seven $(7)$ questions, you will need the supplemental Excel file found HERE.

The Excel file contains an LBO model. The following sections need to be built: the Revolver and Unitranche Term Loan $($TL$)$ sections of the Debt Schedule, the Effective Interest Rate calculations in the Interest Schedule, and the Sensitivity Analyses. There are also seven $(7)$ errors in the Balance Sheet and Cash Flow Statement $($CFS$)$ that are creating problems in the model.

NOTE: You are working only in the yellow shaded cells. The Excel file is already formatted for you. To avoid calculation errors, do not change the formatting in the file.

Step $1$: Build the Revolver and Unitranche TL sections of the Debt Schedule and the Effective Interest Rate calculations in the Interest Schedule. Then, link the Revolver and the Unitranche TL to the CFS and the Interest Income and Interest Expense to the Income Statement.

NOTE: After completing this step, the balance sheet will be out of balance because there are still errors in the model that need to be fixed.

Step $2$: Fix the errors in the Balance Sheet and CFS$.$ After completing this step, the Balance Sheet should balance $($line $126).$

HINT: There are five $(5)$ errors in the balance sheet, two $(2)$ in the Pro Forma adjustments and three $(3)$ in the balance sheet projection from periods $2023$PF $2028$P$.$ There are two $(2)$ errors in the Cash Flow from Operating Activities section of the CFS$.$NOTE $1$: When the balance sheet is out of balance, it is either because: i$)$ company and$/$or transaction$-$related data is incorrectly reflected in the balance sheet, ii$)$ there are errors in the formulas within the statements, or iii$)$ the balance sheet and cash flow statement are not properly connected.NOTE $2$: If you complete the error fix and the balance check in line $126$ still reads $0\mathrm{.}0$ or $(0\mathrm{.}0)$ in any given year, hit F$9$ to refresh the model until your balance sheet fully balances. This is a rounding error and not an indication that there are still errors in the model.

Step $3$: Complete the Sensitivity Analysis in rows $237-246.$

Step $4$: Answer the following questions.

Question $1$ of $7$: What is the Total Asset balance on the $2023$PF Balance Sheet?