Question: ( CAN YOU PLEASE HELP ME SET THIS UP IN EXCEL AS WELL AS SOLVE ) Comparative balance sheets for 2 0 2 4 and

(CAN YOU PLEASE HELP ME SET THIS UP IN EXCEL AS WELL AS SOLVE) Comparative balance sheets for 2024 and 2023 and a statement of income for 2024 are given below for Metagrobolize Industries.
Additional information from the accounting records of Metagrobolize also is provided.
METAGROBOLIZE INDUSTRIES
Comparative Balance Sheets
December 31,2024 and 2023
($ in thousands)
METAGROBOLIZE INDUSTRIES
Income Statement
For the Year Ended December 31,2024
($ in thousands)
Additional information from the accounting records:
a. On December 31,2024. acquired the use of land with a finance lease. Annual payments of $20,000 on the liability are paid at
the end of each year beginning in 2024.
b. During 2024, equipment with a cost of $300,000(90% depreciated) was sold.
c. The statement of shareholders' equity reveals reductions of $225,000 and $450,000 for stock dividends and cash dividends,
respectively.
Required:
Prepare the statement of cash flows of Metagrobolize for the year ended December 31,2024. Present cash flows from operating
activities by the direct method.
Note: Enter your answers in thousands (i.e.,10,000 should be entered as 10). Amounts to be deducted should be indicated with a
minus sign.
Required:
Prepare the statement of cash flows of Metagrobolize for the year ended December 31,2024. Present cash flows from operating
activities by the direct method.
Note: Enter your answers in thousands (i.e.,10,000 should be entered as 10). Amounts to be deducted should be indicated with a
minus sign.
( CAN YOU PLEASE HELP ME SET THIS UP IN EXCEL AS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!