Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Should I calculate each shareholder and round down each of the DIVIDEND REINVESTMENT PLAN then sum of the DRP, OR calculate total share of shareholder
Should I calculate each shareholder and round down each of the DIVIDEND REINVESTMENT PLAN then sum of the DRP, OR calculate total share of shareholder who agree DRP then calculate total DRP and round down the total DRP.
Because I got the different answer from these two ways.
thanks a lot
COVARIAN... - X Fx =ROUNDDOWN(D10*E10/(F10*G10),0) B C D F G First Name DRP Patsy Ricky Irving Y Y 435 548 217 690 226 365 1581 159 Rita William Lois Gladys Priscilla Wilson 944 Family name/Corporate 1 name 2 Oliver 3 Rivera 4 Lindsey 5 Wagner Pty Ltd 6 Nelson 7 Fowler 8 Hoffman Superannuation Fund 9 Graves 10 Bradley 11 Carpenter 12 Gibson 13 Reyes International Ltd 14 McCoy 15 Palmer 16 Bush 17 King Enterprises Pty Ltd 18 Watson 19 Watts 20 Hernandez 21 Simmons 22 Mack Investments Ltd 23 Parks 24 Peterson 351 1/7/20X1 Dividend Declared 22 July 20x1Market price discount DRP 150,000 $ 0.07 S 25.67 94% 189,000 $ 0.07 S 25.67 94% 75,000 $ 0.07 S 25.67 94% 238,000 $ 0.07 $ 25.67 949 78,000 $ 0.07 S 25.67 949 126,000 $ 0.07 $ 25.67 94% 545,000 $ 0.07 S 25.67 94% 55,000 $ 0.07 $ 25.67 949 100,000 $ 0.07 $ 25.67 949 OWN(D10-E10/(F10+G10).0) 121,000 $ 0.07 $ 25.67 249,000 $ 0.07 S 949 179,000 $ 0.07 $ 25.67 94% 126,000 $ 0.07 $ 25.67 949 75,000 $ 0.07 $ 25.67 94% 80,000 $ 0.07 $ 25.67 94% 1.430,000 $ 0.07 25.67 126,000 $ 25.67 94% 390,000 $ 25.67 94% 27,000 $ S 25.67 135,000 $ $ 25.67 980,000 $ S 25.67 225,000 143,000 722 519 Marta Wilma Lila 94% 0.07 Patty Kristina Angel Jenna 365 217 232 4148 365 1131 78 391 2842 94% 941 941 Johnny TanyaStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started