showing how to calculate formulas in Excel. please dont simply give answers, i need to know how to do the calculations in Excel. thank you

using ttniket valoc 3nd took mble (sepstately) find the adjusted wACC, ting 30% tax rate. TAX 30% Ralance Sheet Valer Market Valae Cost of Capital Debe Prcfrtal Stock Coaca Stock 5,000,000.00 4,000,000.00 2,000,000.00 6.850000 00 2200,000.00 10% 13% 1 Refer to the Solved Exariple 7 on Page 334 od your test. ANSWER Baok Value Weights Market Value Weights Adjusted WACC Dak Prefeted Snock Market Valae Book Valc Prefened Sock Coimon Stock 16 Cono Stock