AutoSave om 9 Tutorial 10 Week 11 2020 14 (1) - Excel A shajnin.m.sara@gmail.com S - X Comments File Home Insert Page Layout Formulas Data Review View Developer Help Search Share > Arial -11 BIU - B - A A - A- Z === E 2 Wrap Text Merge & Center - Paste LG E General $ -% Number Insert Delete Format Ideas Conditional Format as Cell Formatting - Table Styles Sort & Find & Filter - Select - Clipboard Font Alignment Styles Cells Editing Ideas B11 - X f 'On 31 Oct the equity section of Gretzky Ltd's statement of financial position consists of contributed equity of $70,000 s $25.000 & declared cash dividends of CALCULATE THE DIVIDEND PAYOUT AND THE RETURN ON ORDINARY SHAREHOLDERS' EQUITY. Dividend payout 35.7% Use CELL-REFERENCING formulas when possible. DO NOT Return on shareholders' equity 18.9% type numbers to the 'Gretzky' entry cells if yellow data is provided. Numerical entries are OK if yellow data not 10 Question 4 provided. On 31 Oct the equity section of Gretzky Ltd's statement of financial position consists of contributed equity of $980,000 & retained earnings of $140,000 Gretzky Ltd is considering two courses of action: (1) declaring a 5% share dividend on the 98,000 $10 Issued ordinary shares or (2) paying a cash dividend of $ 0.50 per share. If Gretzky issues shares as a dividend, the shares will have a nominal value of $10 each. REQUIRED: Use the tabular summary below to show the effects of the alternative actions on the company's equity, the number of issued shares, and share capital. Comment on any assumption made and which course of action you would advise Gretzky Ltd to take. Gretzky Ltd After Share Before Action Dividend After Cash Dividend Equity $ Contributed equity Retained earnings Total equilty 980,000 140.000 1.120.000 $ Issued shares Type your comment here 29 QtnsA QInsb QtnsC QtnsD QtnsE QtnsF Ready H -- ENG + -+5995 5:19 AM 11/05/2020 1 O Type here to search 2 l e John A 8 . 1