A B C E 1 Formula: Add, Multiply, Divide, Subtract; Cell Referencing 2 3 BE15.19 - Using Excel to Calculate Shareholders' Equity Ratios 4 PROBLEM 5 Khalid Inc. has the following selected financial data: 6 7 2020 2019 8 Net income $ 720,000 $ 680,000 9 Total assets 5,136,000 4,525,000 10 Preferred shares, cumulative 600,000 600,000 11 Common shares 350,000 350,000 12 Retained earnings 2,786,000 2,190,000 13 Accumulated other comprehensive income 145,000 130,000 14 Total shareholders' equity 3,881,000 3,270,000 15 Cash dividends paid in the year 124,000 170,000 16 Market price of common shares 97.46 64.33 17 Weighted average number of common shares 80,000 80,000 18 Dividend rate on preferred shares 4% 19 20 There were no preferred dividends in arrears. 21 22