Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help please the first sheet is the instruction and And the second sheet is where you plug in the formulas 1 H D E F
help please
the first sheet is the instruction
1 H D E F G 1 Statements of Financial Position and Cash Flows and the Annual Report 2 Statement of Cash Flows, Indirect Method 3 Edwards Company provided you with the following information for the current year. Accounts Payable relate to Selling. General and 4 Administrative Expenses. 5 6 Edwards Company 7 Statement of Net Income 8 For the Year Ended December 31, 2023 9 Sales $ 347,000 10 Depreciation Expense (35,000) 11 Selling. General, and Administrative Expenses (117,000) 12 Gain on Sale of Equipment 7,400 13 Other Expenses (8,200) 14 Income before Taxes 194,200 15 Tax Expense (58,260) 16 Net Income $ 135,940 17 INSTRUCTIONS ENTERANSWERS 17 18 December 31, 19 Select Balance Sheet Accounts 2022 2023 20 Cash $ 40,000 $ 37,400 21 Investments (noncurrent) 25,000 35,800 22 Prepaid Rent 248,200 280,200 23 Accounts Payable 116,400 136,000 24 Income Taxes Payable 4,300 5,900 25 Long-Term Debt 189,600 176,300 26 Common Stock 248,900 305,600 27 28 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be 29 marked wrong. Compute net cash flow from operating activities under the indirect reporting format. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Use cell references from prior calculations, if applicable.) 3 4 Amount 5 6 7 Operating Activities 8 Adjustments to Reconcile Net Income to Net Cash 9 Provided by Operating Activities 10 11 12 Changes in Operating Working Capital Accounts 13 14 15 16 Net Cash Provided by Operating Activities 17 4A B D G H Statements of Financial Position and Cash Flows and the Annual Report Statement of Cash Flows, Indirect Method Edwards Company provided you with the following information for the current year. Accounts Payable relate to Selling, General and 4 Administrative Expenses. 5 6 Edwards Company 7 Statement of Net Income 8 For the Year Ended December 31, 2023 9 Sales $ 347,000 10 Depreciation Expense (35,000) 11 Selling. General, and Administrative Expenses (117,000) 12 Gain on Sale of Equipment 7,400 Other Expenses (8,200) 14 Income before Taxes 194,200 15 Tax Expense (58,260) 16 Net Income $ 135,940 17 18 December 31 19 Select Balance Sheet Accounts 2022 2023 20 Cash S 40,000 $ 37,400 21 Investments (noncurrent) 25,000 35,800 Prepaid Rent 248,200 280,200 23 Accounts Payable 116,400 136,000 Income Taxes Payable 4,000 5,900 Long-Term Debt 189,600 176,300 26 Common Stock 248.900 305,600 27 26 Use the blue shaded areas on the LNTERANSWERS tab for inputs. ww ws cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions tab you will be marked 29 wrong 20 11 Bewirement Compute net cash flow from operating activities under the indirect reporting format Check your spelling carefully and do not abbreviate Enter cash intoars as positive values and cash outflows as negative values Uue cell references from prior calculations, if applicable INSTRUCTIONS ENTERANSWERS Ready D 1 Compute net cash flow from operating activities under the indirect reporting format. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Use cell references from prior calculations, if applicable.) 2 3 4 5 6 7 Operating Activities Amount 8 Adjustments to Reconcile Net Income to Net Cash 9 Provided by Operating Activities 10 11 12 Changes in Operating Working Capital Accounts 13 14 15 16 Net Cash Provided by Operating Activities 17 18 19 and
And the second sheet is where you plug in the formulas
Step 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