Please do this work in excel and show the work of the calculation please. First, we will calculate the value created $($NPV$)$ from the LBO. To obtain the value of the firm, you will follow the Congoleum Lecture $5$ Congoleum Guide.pdf darr. All the procedures and steps are given. The slides point you to the tables and cells for all the related cash flow calculations. You can break down works among your group members. There are $4$ parts in the total value. Each member can work on one part independently since you don't need numbers from one part for the other. The last two parts: PV $($loan $80-84)$ and PV $($TV$84)$ may take a bit longer than the first two. In terms of writing the report, you should answer the following: Why is this Congoleum a good target for LBO? What are the main benefits $($sources of gains$)$ from the LBO? What is value of the firm $($following the steps in the slides$)?$ How much each of the participants gets from the LBO? The case slides also contain suggestions to help you think about the case. For example, you don't have to answer the questions on slide $2,$ but they provide ways by which you can think about potential gains or incentives for the LBO. Overall, I would like you to apply the knowledge learned from the class in this real$-$life case. Show that you know how to value the firm and think about the payoffs for each investor. Exhibit $9$ Financial Data on Market Segment Competitors $\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|$l$|$l$|\}\backslash$hline $\backslash$multirow$\{3\}\{*\}\{\}$ & $\backslash$multirow$\{3\}\{*\}\{5-$Year Expected Growth$\}$ & $\backslash$multirow$[$b$]\{3\}\{*\}\{$P$/$E$\}$ & $\backslash$multirow$[$b$]\{3\}\{*\}\{\backslash (\backslash$beta$^\{\backslash$text $\{$a $\}\}\backslash )\}$ & $\backslash$multirow$[$b$]\{3\}\{*\}\{$LT Debt $\backslash \%$ Cap.$\}$ & $\backslash$multirow$[$b$]\{3\}\{*\}\{1979$ ROE$\}$ & $\backslash$multirow$\{3\}\{*\}\{1982-1984$ Expected Div. Yield$\}\backslash \backslash \backslash$hline & & & & & & $\backslash \backslash \backslash$hline & & & & & & $\backslash \backslash \backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Home Furnishings$\}\backslash \backslash \backslash$hline Armstrong Cork & $17\mathrm{.}5\backslash \%$ & $5\mathrm{.}8$ & $1\mathrm{.}00$ & $18\mathrm{.}2\backslash \%$ & $11\mathrm{.}6\backslash \%$ & $3\mathrm{.}2\backslash \%\backslash \backslash \backslash$hline GAF Corp & $14$ & $6$ & $1\mathrm{.}15$ & $35$ & $10\mathrm{.}4$ & $2\mathrm{.}6\backslash \backslash \backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Shipbuilding$\}\backslash \backslash \backslash$hline Todd Shipyards & $21$ & $5\mathrm{.}3$ & $1\mathrm{.}00$ & $69$ & $22$ & $2\mathrm{.}0\backslash \backslash \backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Automotive and industrial distribution$\}\backslash \backslash \backslash$hline Genuine Parts & $16$ & $10\mathrm{.}4$ & $.95$ & $5$ & $19\mathrm{.}2$ & $2\mathrm{.}5\backslash \backslash \backslash$hline General Automotive Parts & $16$ & $9\mathrm{.}6$ & $.75$ & $7$ & $19$ & $2\mathrm{.}4\backslash \backslash \backslash$hline Barnes Group & $12\mathrm{.}5$ & $5\mathrm{.}1$ & $.85$ & $18$ & $20\mathrm{.}6$ & $2\mathrm{.}7\backslash \backslash \backslash$hline Congoleum & $22\mathrm{.}5$ & $7\mathrm{.}9$ & $1\mathrm{.}25$ & $7$ & $23$ & $3\backslash \backslash \backslash$hline $\backslash$end$\{$tabular$\}\backslash (\{\}^\{\backslash$mathrm$\{$a$\}\}\backslash )$ The risk$-$free rate was assumed to be $\backslash (9\mathrm{.}5\backslash \%\backslash )$ and the market premium $\backslash (8\mathrm{.}6\backslash \%\backslash ).$ Slide $5$ Cash Flow Analysis for $1980-1984$ The base$-$case NPV values the cash flows of a fictitious all$-$equity firm. $-$ These free cash flows are not adjusted for non$-$equity financing cash flows such as debt principal payback, interest payments, and preferred dividends. $-$ Another word, financing costs are irrelevant for unlevered free cash flows. $-$ The free cash flows can be inferred from Exhibit $13$:EBIT $-$ Taxes $($@$48\backslash \%)$Unlevered net income $+$ Depreciation$/$Amortization $-$ Capitalexpenditures $-$ Investment inNWC