PART II: Open-ended Problems Instructions: Determine a solution for each problem. Unless specifically instructed to do otherwise, enter your final numerical answer on the THPS-2 Answer Submission Form on iCollege as follows: enter dollar answers rounded, if necessary, to the nearest whole dollar but do not include a dollar sign or any commas (for example, enter $23,306.84 as 23307); enter percent answer rounded to 1 decimal place, without a percent sign and without any commas (for example, enter 0.274324 = 27.4324% as 27.4); if your answer is a negative amount, put a hyphen before your number with no space between the hyphen and the number (for example, enter negative 72.3984 as -72.4). USE THE INFORMATION BELOW TO ANSWER QUESTIONS 21-23 Fertzil's Fertilizer Store, Incorporated Balance Sheets (all amounts in dollars) For the Years Ending December 31, 2021 and 2022 Cash Accounts receivable Inventory Current assets Net fixed assets Total assets Notes payable Accounts payable Wage & Tax accruals Current portion of L.T. Debt Current liabilities L.T. Debt Common stock ($2 par) Paid-in-capital Retained earnings Total Liabilities and Equity Income Statement data for selected years: Net income Depreciation 2021 200 1,500 3,800 5,500 9,000 14,500 300 1,100 500 100 2,000 4,600 2,000 1,200 4,700 14,500 2021 $ 3,900 $ 1,200 21. Calculate the Net Cash Flows from Operating Activities for 2022. 22. Calculate the Net Cash Flows from Investing Activities for 2022. 23. Calculate the Net Cash Flows from Financing Activities for 2022. 2022 100 1,200 4,600 5,900 11,800 17,700 500 1,300 300 300 2,400 5,200 1,600 1,000 7,500 17,700 2022 $ 4,200 $ 1,300

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 1M: The general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to...
icon
Related questions
Question
PART II: Open-ended Problems
Instructions: Determine a solution for each problem. Unless specifically instructed to do otherwise, enter
your final numerical answer on the THPS-2 Answer Submission Form on iCollege as follows: enter dollar
answers rounded, if necessary, to the nearest whole dollar but do not include a dollar sign or any commas
(for example, enter $23,306.84 as 23307); enter percent answer rounded to 1 decimal place, without a
percent sign and without any commas (for example, enter 0.274324 = 27.4324% as 27.4); if your answer is
a negative amount, put a hyphen before your number with no space between the hyphen and the number
(for example, enter negative 72.3984 as -72.4).
USE THE INFORMATION BELOW TO ANSWER QUESTIONS 21-23
Fertzil's Fertilizer Store, Incorporated
Balance Sheets (all amounts in dollars)
For the Years Ending December 31, 2021 and 2022
Cash
Accounts receivable
Inventory
Current assets
Net fixed assets
Total assets
Notes payable
Accounts payable
Wage & Tax accruals
Current portion of L.T. Debt
Current liabilities
L.T. Debt
Common stock ($2 par)
Paid-in-capital
Retained earnings
Total Liabilities and Equity
Income Statement data for selected years:
Net income
Depreciation
2021
200
1,500
3,800
5,500
9,000
14,500
300
1,100
500
100
2,000
4,600
2,000
1,200
4,700
14,500
2021
$ 3,900
$ 1,200
21. Calculate the Net Cash Flows from Operating Activities for 2022.
22. Calculate the Net Cash Flows from Investing Activities for 2022.
23. Calculate the Net Cash Flows from Financing Activities for 2022.
2022
100
1,200
4,600
5,900
11,800
17,700
500
1,300
300
300
2,400
5,200
1,600
1,000
7,500
17,700
2022
$ 4,200
$ 1,300
Transcribed Image Text:PART II: Open-ended Problems Instructions: Determine a solution for each problem. Unless specifically instructed to do otherwise, enter your final numerical answer on the THPS-2 Answer Submission Form on iCollege as follows: enter dollar answers rounded, if necessary, to the nearest whole dollar but do not include a dollar sign or any commas (for example, enter $23,306.84 as 23307); enter percent answer rounded to 1 decimal place, without a percent sign and without any commas (for example, enter 0.274324 = 27.4324% as 27.4); if your answer is a negative amount, put a hyphen before your number with no space between the hyphen and the number (for example, enter negative 72.3984 as -72.4). USE THE INFORMATION BELOW TO ANSWER QUESTIONS 21-23 Fertzil's Fertilizer Store, Incorporated Balance Sheets (all amounts in dollars) For the Years Ending December 31, 2021 and 2022 Cash Accounts receivable Inventory Current assets Net fixed assets Total assets Notes payable Accounts payable Wage & Tax accruals Current portion of L.T. Debt Current liabilities L.T. Debt Common stock ($2 par) Paid-in-capital Retained earnings Total Liabilities and Equity Income Statement data for selected years: Net income Depreciation 2021 200 1,500 3,800 5,500 9,000 14,500 300 1,100 500 100 2,000 4,600 2,000 1,200 4,700 14,500 2021 $ 3,900 $ 1,200 21. Calculate the Net Cash Flows from Operating Activities for 2022. 22. Calculate the Net Cash Flows from Investing Activities for 2022. 23. Calculate the Net Cash Flows from Financing Activities for 2022. 2022 100 1,200 4,600 5,900 11,800 17,700 500 1,300 300 300 2,400 5,200 1,600 1,000 7,500 17,700 2022 $ 4,200 $ 1,300
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Risk Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning