A	B	C	D	E
1		INSTRUCTIONS: enter your own data in the gold-shaded cells and drop-down lists below, and then click Recalculate on the toolbar above.
2		Company name
3		Year (Dec. 31 is the accounting year-end)	2022 2023 2024 2025 2026 2027
16
17
18		Jan. 1 Feb. 1	No transaction. 5,000 shares were issued. 10,000 shares were issued. 50,000 shares were issued. 100,000 shares were issued. 300,000 shares were issued. 6,000 shares were acquired and retired. 11,000 shares were acquired and retired. 60,000 shares were acquired and retired. 110,000 shares were acquired and retired. 500,000 shares were acquired and retired.
19		Mar. 1 Apr. 1	No transaction. issued a 2-for-1 stock split. issued a 3-for-1 stock split. issued a 5-for-1 stock split. issued a 10% stock dividend. issued a 20% stock dividend. issued a 50% stock dividend. issued a 100% stock dividend. completed a 1-for-2 reverse stock split. completed a 1-for-5 reverse stock split. completed a 1-for-10 reverse stock split.
20		May 1 Jun. 1	No transaction. 5,000 shares were issued. 10,000 shares were issued. 50,000 shares were issued. 100,000 shares were issued. 300,000 shares were issued. 6,000 shares were acquired and retired. 11,000 shares were acquired and retired. 60,000 shares were acquired and retired. 110,000 shares were acquired and retired. 500,000 shares were acquired and retired.
21		Jul. 1 Aug. 1	No transaction. issued a 2-for-1 stock split. issued a 3-for-1 stock split. issued a 5-for-1 stock split. issued a 10% stock dividend. issued a 20% stock dividend. issued a 50% stock dividend. issued a 100% stock dividend. completed a 1-for-2 reverse stock split. completed a 1-for-5 reverse stock split. completed a 1-for-10 reverse stock split.
22		Sep. 1 Oct. 1	No transaction. 5,000 shares were issued. 10,000 shares were issued. 50,000 shares were issued. 100,000 shares were issued. 300,000 shares were issued. 6,000 shares were acquired and retired. 11,000 shares were acquired and retired. 60,000 shares were acquired and retired. 110,000 shares were acquired and retired. 500,000 shares were acquired and retired.
23		Nov. 1 Dec. 1	No transaction. issued a 2-for-1 stock split. issued a 3-for-1 stock split. issued a 5-for-1 stock split. issued a 10% stock dividend. issued a 20% stock dividend. issued a 50% stock dividend. issued a 100% stock dividend. completed a 1-for-2 reverse stock split. completed a 1-for-5 reverse stock split. completed a 1-for-10 reverse stock split.
24
25		Number of ordinary shares outstanding at the beginning of the year:
26
27		REQUIRED
28		Determine Palermo Inc.'s weighted average ordinary shares for 2023's Basic EPS. Show all supporting calculations.
29
30
31		© Brian Conheady.	Prepared for educational use.
32
33
34
35
36
37
38
39
40
41
42
43
44