I am looking for the following values for PepsiCo to solve for the WACC. This is being done in excel and I need to set up the formula in the respective box.

File Home Insert Page Layout Cut Copy Paste Format Painter fx Undo Clipboard A13 X A B 1 WACC estimation 2 3 Summarize the information: 4 5 Equity 6 Debt 7 Preferred stock 8 9 tax rate 10 11 WACC 12 13 14 15 16 Formulas Data Calibri BI U N 11 Review View ' Help L... Font N D Market value Weigth Estimated Cost: r = E ab Wrap Text Alignment Merge & Center F G S General $ % 9 Number H File Home Insert Page Layout Cut Copy Paste Format Painter fx Undo Clipboard A13 X A B 1 WACC estimation 2 3 Summarize the information: 4 5 Equity 6 Debt 7 Preferred stock 8 9 tax rate 10 11 WACC 12 13 14 15 16 Formulas Data Calibri BI U N 11 Review View ' Help L... Font N D Market value Weigth Estimated Cost: r = E ab Wrap Text Alignment Merge & Center F G S General $ % 9 Number H