Using Excel to Prepare a Statement of Changes in Equity

PROBLEM

Allaire Corporation reported the following statement of changes in equity for the year ended December $31,2024.$

$\backslash$table$[[$Allaire Corporation$],[$Statement of Changes in Equity$],[$Year Ended December $31,2024]]$

$\backslash$table$[[,,,\backslash$table$[[$Accumulated$],[$Other$]]],[,\backslash$table$[[$Common$],[$Shares$]],\backslash$table$[[$Contributed$],[$Surplus$]],\backslash$table$[[$Retained$],[$Earnings$]],\backslash$table$[[$Comprehensive$],[$Income$]],$Total$],[$Bal$.$ January $1,$$$1,500,000,$$$500,000,$$$3,000,000,$$$100,000,$$$5,100,000$

Can you please also mention the formulas so I will know how you solved the question?