can you show me how each cell is done in excel. thank you

A 14-6M Sparta For bareto 520 Guidend part 1 and the growth rateto Fortune the coupon rate the face to 28 Format chance the date to and the pictures would do to $90 per share go DI Serem.47 G D C Man Compound Tas Cart of our Aero Debt mych Porter for Mart Pato Durare Cast of Stock semi- ill Merge & Center $ . % ? Conditional Format Formatting a Table Q 5 HE K P14-6M - Slip part a - For part b change market price to $20, dividend paid last year to $1.95 and the growth rate to 4% -For parte change the coupon rate to 7% and the tax rate to 28% - For part d change the dividend percentage to 7% and the price the shares would sell for to $90 per share Cost of Common Equity 11 13 market price Dividendlar growth rate 01 10 Cost of Common Equity See formula 14-Jo on poge 457 18 19 Gosto Dets IS 21 Par Coupon Maturity Compounding Market Price 24 33 Tax Rate 2 Cost of Debt New Cost of 23 Hint: see the wild to maturity calculation from chapter 9 et see pope 453 for calculation after-tax cost of debt 11 D. Costed Steck ARR333ES Market price Didend te Cost of Perred to See for 14-20 455 Ready PIUM