A group of managers going to offer to purchase the company they manage with the help of a financial sponsor. The company currently has a cash balance of $$40$ million and requires a minimum cash balance of $$7$ million. The sponsor intends to finance this transaction by issuing various debt securities$,$ including $$800$ million in senior secured debt, $$400$ million in subordinated debt. The company is arranging for a $$100$ million revolving line of credit. The sponsor plans to use $$20$ million from the revolver in order to finance the transaction. The sponsor also intends to finance the transaction by investing its own equity, and having management invest $$250$ million in equity from rollover equity. The financial sponsor will put in enough equity to fund the remainder. In addition to redeeming the existing stock, management and its financial sponsor will also redeem all outstanding debt $($par value of $$270$ million$)$ and preferred stock $($par value of $$50$ million$)$ at its par value. Transaction costs are $2\%($based on equity$).$ Fill in all blank cells highlighted yellow.