i have added the original work book question and the excel modified numbers in the templet, in excel can you show me how each answer was done in each cell by referencing, very much appreciated.

162. (Calculating the dividend payout ratio) The Welmar Corporation operates membership warehouses that offer a wide variety of branded and private-label products in no-frills, self-service warehouse facilities. In 2016, the company paid total cash dividends of $265,029,000 and had net income of $1,282,725,000. a. What was the firm's dividend payout ratio? b. If Welmar earns $1.5 billion in 2017 and maintains the same dividend payout ratio that it paid in 2016, what will the firm's dividends be? M O P16-2 Modified - for the 2016 total cash dividends assume $350,000,000 for the 2017 net income assume $1,500,000,000 Hint sehr bortom page 52 7 2016 total cash dividende net income 10 payout 13 2012 23 net income 14 payout ratio I total cash dividends 16