1. Prepare a Statement of Cash Flows for Sage Corporation for 2022 in proper form using...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Prepare a Statement of Cash Flows for Sage Corporation for 2022 in proper form using the indirect method 2. Provide supporting calculations for items in the statement to include Balance Sheet changes, depreciation expense, dividends and gains/losses on the sale of assets, Show your work. 3. Compute the following items (as if you were using the direct method) and show calculations: a. Cash received from customers (Sales were $1,300,000 for the year) b. Cash paid for merchandise (Cost of Goods Sold was $950,000 for the year) 4. Use Excel to prepare the statement to include formulas and calculations The Sage Corporation prepared, for 2022 and 2021, the following balance sheet data: December 31, 2022 December 31, 2021 102,800 33,000 18,000 205,175 189,500 7,400 Accounts Cash Available for sale securities Accounts Receivable. Merchandise Inventory Prepaid Insurance Land, Buildings, and Equipm Accumulated Depreciation Total Accounts Payable Salaries Payable Notes Payable - Long Term Bonds Payable Common Stock Retained earnings![Deficit) Total Additional information: (a) Sold available-for-sale securities (not cash equivalents) costing $95,000 (b) Equipment costing $30,000 with a book value of $5,450 was sold for $7,200. (c) Issued 8% bonds payable at par, $400,000. (d) Purchased new equipment for cash, $298,395. (e) Dividends were declared and paid in cash for (f) Net income for 2022 was $64,000, 1,378,875 (560,250) 1,341,500 153,375 20,000 37,500 400,000 700,000 30,625 1,341,500 Items used for Direct Method Calculations a. Cash received from customers (Sales were $1,300,000 for the yearl b. Cash paid for merchandise (Cost of Goods Sold was $950,000 113,000 339,000 7,500 8,000 1,110,480 (500,230) 1,110,750 220,000 18,250 162,000 700,000 10,500 1,110,750 1. Prepare a Statement of Cash Flows for Sage Corporation for 2022 in proper form using the indirect method 2. Provide supporting calculations for items in the statement to include Balance Sheet changes, depreciation expense, dividends and gains/losses on the sale of assets, Show your work. 3. Compute the following items (as if you were using the direct method) and show calculations: a. Cash received from customers (Sales were $1,300,000 for the year) b. Cash paid for merchandise (Cost of Goods Sold was $950,000 for the year) 4. Use Excel to prepare the statement to include formulas and calculations The Sage Corporation prepared, for 2022 and 2021, the following balance sheet data: December 31, 2022 December 31, 2021 102,800 33,000 18,000 205,175 189,500 7,400 Accounts Cash Available for sale securities Accounts Receivable. Merchandise Inventory Prepaid Insurance Land, Buildings, and Equipm Accumulated Depreciation Total Accounts Payable Salaries Payable Notes Payable - Long Term Bonds Payable Common Stock Retained earnings![Deficit) Total Additional information: (a) Sold available-for-sale securities (not cash equivalents) costing $95,000 (b) Equipment costing $30,000 with a book value of $5,450 was sold for $7,200. (c) Issued 8% bonds payable at par, $400,000. (d) Purchased new equipment for cash, $298,395. (e) Dividends were declared and paid in cash for (f) Net income for 2022 was $64,000, 1,378,875 (560,250) 1,341,500 153,375 20,000 37,500 400,000 700,000 30,625 1,341,500 Items used for Direct Method Calculations a. Cash received from customers (Sales were $1,300,000 for the yearl b. Cash paid for merchandise (Cost of Goods Sold was $950,000 113,000 339,000 7,500 8,000 1,110,480 (500,230) 1,110,750 220,000 18,250 162,000 700,000 10,500 1,110,750
Expert Answer:
Answer rating: 100% (QA)
1 Statement of Cash Flows for Sage Corporation for 2022 Indirect Method Cash Flows from Operating Activities Net income 64000 Adjustments for noncash ... View the full answer
Related Book For
Financial Accounting: A Business Process Approach
ISBN: 978-0136115274
3rd edition
Authors: Jane L. Reimers
Posted Date:
Students also viewed these finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
You are the controller for 21st Century Technologies. Your staff has prepared an income statement for the current year and has developed the following additional information by analyzing changes in...
-
Show that if powers of x greater than x 5 are neglected. In sin x X =-=-x-x 180
-
The Wood Division of Fir Products, Inc. manufactures wood moldings and sells them externally for $100. Its variable cost is $40 per unit, and its fixed cost per unit is $14. Fir's president wants the...
-
Is the circuit in Figure 3.66 combinational logic or sequential logic? Explain in a simple fashion what the relationship is between the inputs and outputs. What would you call this circuit? CLK
-
The enzyme lipase catalyzes the hydrolysis of esters of fatty acids. The hydrolysis of p-nitrophenyloctanoate was followed by measuring the appearance of p-nitrophenol in the reaction mixture: The...
-
Hasbro is a leading firm in the toy, game, and amusement industry. Its promoted brands group includes products from Playskool, Tonka, Milton Bradley, Parker Brothers, Tiger, and Wizards of the Coast....
-
in the COVID pandemic of 2020, the world's largest pharmaceutical companies were quick to develop vaccines. Would a market composed of many small companies have been able to respond as fast?
-
Creating and manipulating a MySQL schema for soccer Domain Description The attached file contains information on the soccer (European football) players for the 2017/2018 Premier League. The Premier...
-
Owner purchased land in a subdivision subject to restrictive covenants designed to ensure that all homes built in the subdivision were complementary. Owner complied with the requirement to submit...
-
Chief Thomas Rainwater signs and returns a letter from John Dutton, referring to the Dutton Yellowstone Ranch and its price. When Chief Rainwater attempts to complete the deal, John Dutton refuses,...
-
The Chapman Company had net income for the taxation year ending December 31st, 2022, of $263,000. This amount included $14,250 in taxable capital gains, as well as $14,200 in taxable dividends...
-
Andrew is a newspaper reporting that covers business and economic topics. He recently filed a FOIA request with the Department of Justice (DOJ), asking for case information and decisions concerning...
-
2. You own a farm business that produces corn and soy, and you need to replace your combine harvester. You are choosing between two options: A John Deere combine that costs $600,000, and a New...
-
A private bank shows a daily average salary of employees is Rs. 50,032and a standard deviation Rs. 5032 in a random sample of 3,032 private banks in Pakistan. Verify that banks claims that average...
-
A simple random sample of 220 university students were asked what pasta they usually order and with which sauce. The preferences of these respondents are summarised below: Sauce Bolognese Pasta...
-
Multiple Choice Questions 1. Which of the following is an intangible asset? a. Franchise b. Oil reserves c. Land d. Repairs 2. Depreciation is the systematic allocation of the cost of an asset a....
-
If Fitness and Fashion Corporation paid $10 per share for 590 shares of its own stock, how would the transaction be shown in the accounting equation? How would the transaction be reflected in the...
-
Each of the following items was found on the financial statements for Hartsfield Company for the year ended December 31, 2011: Net income from continuing operations .............$ 136,500 Gain on the...
-
As a security analyst covering the French market, youve identified the following factors and factor sensitivities for Elf Acquitaine (Elf): Elfs functional currency is the euro. Factors and factor...
-
Using the data shown in Figure 2.11 which anatomical site of the corn on the foot was the least frequently reported patients in the corn plaster group? The least frequently reported anatomical site...
-
The regional directors of a major investment bank are discussing investment strategies for their respective countries. a. As director of North American investments, describe to your foreign...
Study smarter with the SolutionInn App