Function: SUM; Formula: Multiply; Cell Referencing
Some cells are merged.
Using Excel to Calculate Dividend Payments for Preferred and Common Shares		Student Work Area
	Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated.
PROBLEM
On April 30, the directors of Florida Window Resources declared dividends to common shareholders and directed that preferred dividends be paid as required to the shareholders of record on May 14, payable May 28. No dividends were paid in the previous fiscal year.
	Calculate the amount of dividends that would be paid if
	(a)	The preferred shares are cumulative.
		April 30, common dividends declared per share	$ 0.75				Cumulative
		Preferred dividend rate	$ 0.80				Preferred dividends
		Issued shares:
		Preferred shares	15,000				Common dividends
		Common shares	45,000
							Total dividends
						(b)	The preferred shares are noncumulative.
							Noncumulative
							Preferred dividends
							Common dividends
							Total dividends