please show the procedure in excel

THE REPUBLIC

Below is the adjusted trial balance of La Repblica, S.A., as of March 31, 2023, with this information you must prepare

1. Income statement (15 pts.) 2. Statement of changes in equity (4 pts.) 3. Financial situation statement (20pts.) 4. Closing entries (12 pts.)

'The Republic Adjusted trial balance in thousands of colones (\$) Banks Clients Prepaid rent office supplies land Building Accumulated building depreciation office equipment accumulated depreciation of office equipment suppliers Wages to pay taxes to pay Long-term bank loan long-term mortgage payable capital stock accumulated profits dividends service income Administrative salary expense Expense for telephone services Electricity expense Office supplies expense Building depreciation expense Office equipment depreciation expense Sales salary expense Sales commission expense advertising expense Interest expense Tax expense Equal sums 1,143,890.00 237,500.00 36,400.00 27,430.00 1,100,000.00 1,300,000.00 230,000.00 140,000.00 32,500.00 228,500.00 57,450.00 44,750.00 350,00.00 1,000,000.00 1,350,000.00 350,000.00 250,000.00 1,290,300.00 175,000.00 52,360.00 34,700.00 8,300.00 23,500.00 4,300.00 110,000.00 90,000.00 42,500.00 70,000.00 87,620.00 4,933,500.00