Concord Inc. had net income for 2020 of $5,920,000. The company had 2,200,000 of common shares outstanding throughout the year. During 2020, Concord paid dividends on the common shares of $0.12 per share. Average common shareholder equity was $39,600,000, and the market value of the shares on December 31, 2020 was $27 per share. Concord Inc. also had 100,000 shares outstanding of cumulative, $7, no-par value preferred shares. The shares were outstanding for the full year, and dividends had been kept current for the past several years. Calculate the following ratios for Concord Inc.: (Round answers to 2 decimal places, e.g. 25.15 or 25.15%. Round earnings per share to 3 decimal places for intermediate calculations, e.g. 1.253.) Rate of return on common shareholders’ equity%, Payout ratio %Price earnings ratio, timesBook value per share$ per share Please share how to do in Excel
Concord Inc. had net income for 2020 of $5,920,000. The company had 2,200,000 of common shares outstanding throughout the year. During 2020, Concord paid dividends on the common shares of $0.12 per share. Average common shareholder equity was $39,600,000, and the market value of the shares on December 31, 2020 was $27 per share.
Concord Inc. also had 100,000 shares outstanding of cumulative, $7, no-par value
Calculate the following ratios for Concord Inc.: (Round answers to 2 decimal places, e.g. 25.15 or 25.15%. Round earnings per share to 3 decimal places for intermediate calculations, e.g. 1.253.)
%Price earnings ratio, timesBook value per share$ per share
Please share how to do in Excel
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
