1) Your friend, El Geeko, has developed an app that smartphone users all over the world are using. The app is sold online. In order to increase sales, it is necessary to advertise heavily. He asked you to become part of his venture. In order to raise money for advertising, you started a publicly traded company. That means that people will own shares in the company. The ten million shares are traded on the stock exchange. Even before you and El Geeko started the publicy traded company, sales were going very well. So, you decided that the new company would pay out 1% of sales out as a quarterly dividend. That means that the people who owned shares on the last day of each third month would get 1% of the total sales that quarter. The money would be deposited in their bank account. The company had 10 million shares outstanding. You owned 8% of them. This table shows what the company sales were for the first eight quarters that the company was listed on the stock exchange. Quarter Quarterly Sales $250,000 Quarter Quarterly Sales $325,000 $355,000 1 $250,000 $370,000 2 $325,000 $395,000 $355,000 $370.000 $420,000 $395.000 $440,000 $420,000 $460,000 7 $440,000 $460,000 00W 8 Make a spreadsheet to show a) How much was paid out in dividends each quarter. b) How much you earned in dividends each quarter. Explain the formulas you used, and include the resulting spreadsheet table into this document