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

D E P14-9M (changes from the text are in bold) Temple-Midland, Inc., is issuing a $1,000 par value bond that pays 5 percent annual Interest and matures in 15 years. Investors are willing to pay $925 for the bond, and Temple faces a tax rate of 28 percent. What is Temple's after-tax cost of debt on the bond where interest is pald semiannually? 6 -7 8 9 10 Cost of Debt 12 Coupon Rate Years 14 15 36 17 18 9 20 Par Value PMT NPER M Price (PV) YTM (Semi Annual) YTM (Annual) Tax Rate After Tax Cost of Debt 5 6 7 0 1 2 3