please use excel or go step by step.

FIN 345 Problem Set #1 1. Given the information below answer the following questions: $ Dividend per share Date 1/1 3/31 6/30 9/30 12/31 0.2 0.2 0.2 0.2 Market Price when Dividend Received 25 22 23 28 29 a. Calculate the time-weighted rate of return. b. How does your answer compare to the standard unadjusted holding period rate of return? C. Calculate the after-tax, time-weighted return given a dividend tax rate of 15% and a capital gains tax rate of 20%. d. How does your answer compare to the standard after-tax unadjusted holding period rate of return using the same tax rates