i understand the first question there but get confused with 2-4??? help!

This ASSIE Needs Corrections Good to Go Please answer all questions on this sheet and remember to show all your work! 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 publicly 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. 1 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 Quarter Quarterly 1 $250,000 Sales 2 $325,000 3 $355,000 $250.000 2 $370,000 $325,000 4 3 $355.000 $395,000 5 4 $370,000 6 $420,000 5 $395.000 7 $440,000 7 6 $420,000 $460,000 7 8 8 $440.000 8 $460.000 2 1 3 4 5 6 9 INVESTING ASSIGNMENT Resources 2. You have instructed your bank to immediately transfer your dividends from the previous question, to a certain high-risk second mortgage company. There you invest the money at 10% interest compounded quarterly You suspect that your second mortgage company investment will have grown very well by the beginning of the ninth quarter. You want to use the compound interest formula to figure out how much you will have by that time. Using that formula, you can figure out the totals starting in the second quarter. A = P(1+ Because the value of t will be different for each quarter, you have to use that formula 7 times. What will the value of t be in each quarter after the first quarter? Include this column in your previous spreadsheet and then copy your new spreadsheet here: 10 W TOYU 22 boys do you do not COCK som 1) lovebnis 3. For the formula for compound interest, you must use (1 + 5) within the parentheses. What is the value of (1 + 5 for each of the quarters? What is the value of nt for each of the quarters? What formula do you use to find the value of nt in row 3 of your spreadsheet? Copy your updated spreadsheet here. 1922 OY Hoyaum Wolfo voopstad to gulova 2698 baru suprasa nad tulevad liw 4. When you wish to express a number as an exponent in your scientific or graphing calculuator, you key a caret (M) in front of the number you wish to be the exponent. Your spreadsheet formula for a power is =POWER(base,exponent). Use your spreadsheet and find the value of (1 + 5 for each quarter. What is the formula you used in line three