EXCEL FORMAT

Please calculate this in excel only and show all excel cell functions to get the answer.

thanks

what is the price you would pay for a share today that reported earnings per share of $6.72 in the latest financial year, assuming that the payout ratio of 63% and growth in earnings of 7.00% per annum will remain constant for the foreseeable future? Your required return on shares in this company is 15.00% per annum