Please show work in excel:
Susie purchased a stock one year ago at a price of $24 a share. In the past year, she has received four quarterly dividends of $0.50 each. Today she sold the stock for $27 a share. What is her after-tax $ return if she is in the capital gains and ordinary income tax brackets of 25% and 30% respectively and if she her transaction costs were $0.25 per transaction?