SHOW FULL WORK IN AN EXCEL FILE.

Use the same technique I used in class this week (Lecture 7: Calculating the WACC for Paypal) to calculate the cost of capital for Keurig Dr Pepper Inc. (KDP). Remember to use 5.5% for the market risk premium and the 13-week T-bill rate from Yahoo Finance for the risk-free rate. Also remember to click on each of the bond issues on FINRA (FINRA fixed income data) to find the yield and price of each bond. Finally, remember to use SEC EDGAR to obtain book value information for these bonds from the most recent 10Q (Note that due to data limitation on FINRA, you will not be able to match all the bonds on the 10Q with the FINRA bond data. You should only use the bond issues you can match).