fill out the blanks above. All answers must start with = like if they were entered in excel. thanks

4 5 6 7 8 An investor purchases shares of the following corporation at the beginning of each year period. Dividends are paid at the end of each year. agon123456m 9 10 11 Majere Brothers, Incorporated 2018 2019 2020 2021 2022 2023 Dividend Paid at Year-End 15 Required: 17 $3.00 Beginning-of-Year Price $85.00 $95.00 $80.00 $105.00 $115.00 $120.00 Shares Bought (Beginning Shares Sold (Beginning of of Year) Year) 100 25 25 100 16 Using the information in the tables above, please calculate the cash flows and the dollar-weighted rate of return for the above transactions. 4 5 (Use cells A5 to D13 from the given information to complete this question.) 6 27 28/ Time Period 0 (Beginning of 2018) 1 (2018-2019) 2 (2019-2020) 3 (2020-2021) 4 (2021-2022) 5 (2022-2023) Dollar-Weighted Rate of Return Cash Flows ($85.00)