Using Data Analysis toolbox in Excel (linear regression), and based on the information provided for 3 comparable firms A, B, C; Estimate the bottom-up (levered) beta for company D (do not worry about statistical significance).Assume that Company D has a D/E ratio of 0.3 and that the tax rate is 30%.

Q20: What is your estimate of bottom-up beta for company D?

Show your work and results, in the excel file submission, step by step in an organized manner