USE EXCEL AND SHOW FORMULAS PLEASE

You are going to purchase a preferred share. The preferred share just paid a dividend of $1.08 per share. Dividends are paid monthly. Your have a required rate of return of 8.1% compounded annually. How much should you pay for the preferred share? Your answer should be accurate to two decimal places