FIND bottom up beta and WACC

\begin{tabular}{|l|r|r|r|r|r|c|} \hline 5Y Beta & \multicolumn{2}{|r|}{1.1} & & & \\ \hline Cost of Debt & 5.50% & & & \\ \hline Risk-free Rate & 2.89% & $ & 135,601.00 & total debt & \\ \hline Market Risk Premium & 6.00% & $ & 56,919.88 & mkt cap & \\ \hline d/e & 2.3823 & & & 0 & preferred & \\ \hline Tax Rate & 21.00% & & & & \\ \hline Comparables & 5Y Beta & Total Debt & Market Cap & Tax Rate \\ \hline GM (NYSE:GM) & 1.20 & $ & 110,951.00 & $ & 55,273.60 & 21.00% \\ \hline BMW (XTRA:BMW) & 1.20 & $ & 106,667.40 & $ & 54,230.70 & 15.83% \\ \hline Volkswagen (XTRA:VOW3) & 1.42 & $ & 220,712.10 & $ & 97,423.40 & 15.83% \\ \hline Mercedes-Benz (XTRA:MBG) & 1.41 & $ & 124,140.45 & $ & 75,651.90 & 15.83% \\ \hline Honda (TSE:7267) & 0.96 & $ & 60,790.23 & $ & 45,059.40 & 30.62% \\ \hline Ford (NYSE:F) & 1.1 & $ & 135,601.00 & $ & 56,919.88 & 21.00% \\ \hline \end{tabular}