Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please give in Excel and explanation. Please the information just only that, please do it Problem 1 The following is a statement of comparative financial
please give in Excel and explanation. Please
the information just only that, please do it
Problem 1 The following is a statement of comparative financial position of PT Armenia in 2021 and 2022 (in rupiah) PT. Armenia Comparative Statements of Financial Position December 31, 2021 and 2022 Account 2022 2021 Assets Land 1.000.000.000 1.200.000.000 Building 500.000.000 530.000.000 Accum. Depreciation of Building (168.750.000) (229.750.000) Vehicle 300.000.000 300.000.000 Accum. Depreciation of Vehicle (240.625.000) (203.125.000) Supplies 20.000.000 15.000.000 Inventory 270.000.000 195.000.000 Accounts Receivable (net) 250.000.000 175.000.000 Cash 440.125.000 258.500.000 Total Assets 2.370.750.000 2.240.625.000 Equity and Liabilities Share Capital - Ordinary (par Rp 600.000.000 500.000.000 5.000) Share Premium - Ordinary 550.000.000 375.000.000 Retained Earnings 620.750.000 420.000.000 Bank Loan 400.000.000 700.000.000 Accounts Payable 175.000.000 220.000.000 Dividend Payable 25.000.000 25.625.000 Total Equity and Liabilities 2.370.750.000 2.240.625.000 Additional information during the year 2022: 1. Net profit in 2022 is Rp 250,750,000 with sales of Rp 1,500,000,000, COGS of Rp 1,060,062,500, operating expense of Rp 216,500,000 (including depreciation expense) and interest expense of 40,000,000. The 2022 tax rate is 25%. 2. The land is sold on April 30, 2022 for Rp. 300,000,000. 3. The building purchased on March 30, 2015 with an acquisition cost of Rp 180,000,000 was sold for Rp 120,000,000 on June 5, 2022. The building has a useful life of 15 years. 4. During 2022, PT. Armenia issued 20,000 shares. Instruction: Make a Statement of Cash Flows PT. Armenia for the year ended December 31, 2022 using the indirect method! Problem 2 Using Problem 1. Instruction: Make a Statement of Cash Flows PT. Armenia for the year ended December 31, 2022 using the direct methodStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started