answer all parts a b c and d, must show work in excel with formulas

Yerba Industries is an all-equity firm whose stock has a beta of 0.80 and an expected return of 19.5%. Suppose it issues new risk-free debt with a 3.5% yield and repurchase 20% of its stock. Assume perfect capital markets. a. What is the beta of Yerba stock after this transaction? b. What is the expected return of Yerba stock after this transaction? Suppose that prior to this transaction, Yerba expected earnings per share this coming year of $4.50, with a forward P/E ratio (that is, the share price divided by the expected earnings for the coming year) of 12 . c. What is Yerba's expected earnings per share after this transaction? Does this change benefit the shareholder? Explain. d. What is Yerba's forward P/E ratio after this transaction? Is this chanqe in the P/E ratio reasonable? Explain. a. What is the beta of Yerba stock after this transaction? The beta of Yerba stock after this transaction is (Round to two decimal places.) b. What is the expected return of Yerba stock after this transaction? The expected retum of Yerba stock after this transaction is \%. (Round to two decimal places.) Suppose that prior to this transaction, Yerba expected earnings per share this coming year of $4.50, with a forward P/E ratio (that is, the share price divided by the expected earnings for the coming year) of 12 . c. What is Yerba's expected earnings per share after this transaction? Does this change benefit the shareholder? Explain. If prior to the transaction, Yerba expected earnings per share this coming year of $4.50, with a forward P/E ratio of 12 , Yerba's expected eamings per share after this transaction is $ (Round to the nearest cent.) Does this change benefit the shareholder? Explain. (Select the best choice below.) A. It does benefit shareholders because their cash flows have gone up and everything else is unchanged. B. You cannot tell. It depends on shareholders risk preferences, Cash flows are higher, but so is risk, some shareholders will be better off, enme will he wnree off Yerba industries is an all-equity firm whose stock has a beta of 0.80 and an expected return of 19.5%. Suppose it issues new risk-free debt with a 3.5% yield and repurchase 20% of its stock. Assume perfect capital markets. a. What is the beta of Yerba stock after this transaction? b. What is the expected return of Yerba stock after this transaction? Suppose that prior to this transaction, Yerba expected earnings per share this coming year of $4.50, with a forward P/E ratio (that is, the share price divided by the expected earnings for the coming year) of 12 . c. What is Yerba's expected earnings per share after this transaction? Does this change benefit the shareholder? Explain. d. What is Yerba's forward P/E ratio after this transaction? Is this chanqe in the P/E ratio reasonable? Exolain. some will be worse off. c. It does not benefit shareholders because if you take into account the shares they lost to the repurchase, their cash flows are actually the same. D. It does not benefit shareholders because the risk of holding equity has increased. d. What is Yerba's forward P/E ratio after this transaction? is this change in the P/E ratio reasonable? Explain. Yerba's forward P/E ratio after this transaction is (Round to two decimal places.) Is this change in the P/E ratio reasonable? Explain. (Select the best choice below.) A. It is reasonable. P/E has gone down because risk has gone up. B. It is reasonable. P/E has gone down because risk has gone down. C. It is not reasonable and reflects the value loss of the recapitalization. D. You cannot tell. It depends on shareholders' risk preferences. P/E has gone down, but risk has also changed, some shareholders will be better off, some will be worse off