Chapter 11 - d Enter formulas in Column H to calculate...

This preview shows page 1. Sign up to view the full content.

Chapter 11 - Exercise 08 Find the dividend amount paid to preferred and common stockholders. \$900,000 15,000 5% \$5.00 \$75,000 \$825,000 250,000 \$3.30 \$800,000 17,500 3% \$3.00 \$52,500 \$747,500 300,000 \$2.49 \$600,000 12,500 5% \$5.00 \$62,500 \$537,500 130,000 \$4.13 \$1,500,000 30,000 10% \$10.00 \$300,000 \$1,200,000 300,000 \$4.00 \$350,000 6,500 8% \$8.00 \$52,000 \$298,000 250,000 \$1.19 \$500,000 5,900 9% \$9.00 \$53,100 \$446,900 200,000 \$2.23 Directions: a. Enter formulas in Column D to calculate the Preferred Stock Dividend Amount Per Share. b. Enter formulas in Column E to calculate the Preferred Stock Total Dividend To Be Paid. c. Enter formulas in Column F to calculate Common Stock Total Dividend To Be Paid.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: d. Enter formulas in Column H to calculate Common Stock Dividend Amount Per Share. e. Format Columns D and H for Currency, 2 Decimal places, and \$. Format Columns E and F for Currency, 0 Decimal places, and \$. Dividend Amount To Be Paid to All Shareholders Number of Preferred Stock Shares Preferred Stock Dividend Rate \$100 Par Value Preferred Stock Dividend Amount Per Share Preferred Stock Total Dividend To Be Paid Common Stock Total Dividend To Be Paid Number of Common Stock Shares Common Stock Dividend Amount Per Share f. Save the file as ch11ex08a.xls....
View Full Document

This note was uploaded on 04/13/2010 for the course BUSINESS 15643 taught by Professor Schilz during the Spring '10 term at École Normale Supérieure.

Ask a homework question - tutors are online