Using Excel to Prepare a Statement of Changes in Equity PROBLEM G H 5 Allaire Corporation...

Transcribed Image Text:

Using Excel to Prepare a Statement of Changes in Equity PROBLEM G H 5 Allaire Corporation reported the following statement of changes in equity for the year ended 5 December 31, 2024. KL M Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area and work area as indicated. 7 Allaire Corporation Statement of Changes in Equity Year Ended December 31, 2024 Determine the missing amounts for items [1] to [8]. 1 2 Accumulated (1) 3 4 5 Bal. January 1 Common Shares $15,00,000 Contributed Retained Surplus Earnings $5,00,000 $30,00,000 Other Comprehensive [2] Income Total $1,00,000 $51,00,000 6 Issued common shares [1] [3] [2] 7 Declared and issued 1,10,000 [3] [4] 8 stock dividend [4] 9 Declared cash dividends -1,35,000 -1,35,000 0 1 Comprehensive income Net income [5] 7,50,000 [5] 2 Other comprehensive [6] 3 income [6] 25,000 [7] 4 Bal. December 31 $20,50,000 [7] $35,05,000 $1,25,000 [8) [8] 6 Using Excel to Prepare a Statement of Changes in Equity PROBLEM G H 5 Allaire Corporation reported the following statement of changes in equity for the year ended 5 December 31, 2024. KL M Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area and work area as indicated. 7 Allaire Corporation Statement of Changes in Equity Year Ended December 31, 2024 Determine the missing amounts for items [1] to [8]. 1 2 Accumulated (1) 3 4 5 Bal. January 1 Common Shares $15,00,000 Contributed Retained Surplus Earnings $5,00,000 $30,00,000 Other Comprehensive [2] Income Total $1,00,000 $51,00,000 6 Issued common shares [1] [3] [2] 7 Declared and issued 1,10,000 [3] [4] 8 stock dividend [4] 9 Declared cash dividends -1,35,000 -1,35,000 0 1 Comprehensive income Net income [5] 7,50,000 [5] 2 Other comprehensive [6] 3 income [6] 25,000 [7] 4 Bal. December 31 $20,50,000 [7] $35,05,000 $1,25,000 [8) [8] 6