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)
Here are the stepbystep workings for the Statement of Cash Flows using the indirect method 1 Calculate net income from the income statement Net Income ... 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
-
At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock,...
-
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
-
It is desired to produce an iron-carbon alloy that has a minimum hardness of 175 HB and a minimum ductility of 52%RA. Is such an alloy possible? If so, what will be its composition and microstructure...
-
Prior to the first month of operations ending October 31, Marshall Inc. estimated the following operating results: Sales (40,000 $90) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
Accounts receivable are typically collected within three months from the date of sale. Can they be considered cash equivalents? Explain.
-
Answer the following questions with regard to infrastructure: a. What is infrastructure? b. What are the two methods that might be used to record infrastructure expense from year to year? How is the...
-
Book Problem 9 Find a power series representation for the following function: f(x) = . . .. (enter only the first 3 non-zero terms). 4+ x2 The radius of convergence R =
-
(a) A horizontal steel I-beam of cross-sectional area 0.041m2 is rigidly connected to two vertical steel girders. If the beam was installed when the temperature was 30oC, what stress is developed in...
-
Let A={o,p,q,r,s}. a. How many subsets does A have? b. How many proper subsets does A have? c. How many subsets does A have that include the elements o and p? a. A has subsets. (Type a whole number.)...
-
1. Elaborate upon the challenges faced by the organization as they took a more adaptive and agile approach to organization structure and design. 2. What can organizations do to overcome these...
-
Better Times Company is a manufacturer of soap. It produces all of its products in one department. The information for the current month is as follows: Beginning work in process50,000 units Units...
-
In the interval [-7, 7] the function d,, is defined: Sn(x) = n for 0 for = x <1/(2n) x>1/(2n) (a) Find the Fourier series of dn(x) as a Fourier cosine and sine expansion. (b) Simplify your result (a)...
-
You believe that Yoyo dyne's stock will rise in value between now and the end of the year. The stock price is now $48, and you buy a $60 call option for 100 shares. The option premium is $1.50 per...
-
Please write a function named is evenodd split which takes an integer (and option- ally a bool) as input. If the parameter even on left is True by default, the function should return true if all even...
-
Use the following account balances from the adjusted trial balance of ABC Consulting: Debit Credit Balance Balance Cash Account Accounts Payable. B. Conway, Capital B. Conway, Drawing Fees Revenue...
-
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...
-
Transaction Analysis Amanda Weisman opened a home health care business under the name Home Care Inc. During its first month of operations, the business had the following transactions: a. Issued...
-
Transaction Analysis and Business Activities OBJECTIVE 3 The accountant for Huron Corporation has collected the following information: a. Huron purchased a tract of land from Jacobsen Real Estate for...
-
Transaction Analysis} During December, Cynthiana Refrigeration Service engaged in the following transactions: a. On December 3, Cynthiana sold a one-year service contract to Cub Foods for \(\$ 12 ;...
Study smarter with the SolutionInn App