Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 method

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of Cost Accounting

Authors: Edward J. Vanderbeck

16th edition

9781133712701, 1133187862, 1133712703, 978-1133187868

More Books

Students also viewed these Accounting questions

Question

Identify three ways to manage an intergenerational workforce.

Answered: 1 week ago

Question

Prepare a Porters Five Forces analysis.

Answered: 1 week ago

Question

Analyze the impact of mergers and acquisitions on employees.

Answered: 1 week ago