Using a spreadsheet to complete the statement of cash flows—indirect method Companies can use a spreadsheet to complete the statement of cash flows. Each item that follows is recorded in the transaction analysis columns of the spreadsheet.  Net income Increases in current assets (other than Cash) Decreases in current liabilities Cash payment for the acquisition of plant assets Cash receipt from the issuance of common stock Depreciation expense Identify each as being recorded by a Debit or Credit in the statement of cash flows section of the spreadsheet.

Question

Using a spreadsheet to complete the statement of cash flows—indirect method

Companies can use a spreadsheet to complete the statement of cash flows. Each item that follows is recorded in the transaction analysis columns of the spreadsheet. 

  • Net income
  • Increases in current assets (other than Cash)
  • Decreases in current liabilities
  • Cash payment for the acquisition of plant assets
  • Cash receipt from the issuance of common stock
  • Depreciation expense

Identify each as being recorded by a Debit or Credit in the statement of cash flows section of the spreadsheet.

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Accounting

Financial Accounting

Related Accounting Q&A

Find answers to questions asked by students like you.

Q: S operates in a business environment with a 6% state sales tax rate and a 4% county sales tax rate. ...

A: Prepare the journal entries to reflect the sales tax that will remit to the state and to the county.

Q: Mountain Water Corp. issued a common stock of $28,000 to pay off long-term notes payable of $28,000....

A: “Non-cash transaction” does not involve any cash dealings and this type transaction will not create ...

Q: What should the net change in the cash section of the statement of cash flows always reconcile with?

A: Statement of Cash Flows: It is a financial statement that shows the cash and cash equivalents of a c...

Q: Balanced scorecard and strategy. Scott Company manufactures a DVD player called the Maxus. The compa...

A: 1.

Q: Palmer Co. is evaluating the appropriate accounting for the following items. 1. Management has deci...

A:  

Q: Winston Corporation has 9,000 shares of 4%, $10 par cumulative preferred stock and 47,000 shares of ...

A: Dividends: This is the amount of cash distributed to stockholders by a company out its earnings, acc...

Q: Should gains and losses on a fair value hedge be recorded as they occur, or should they be recorded ...

A:  

Q: On 04-01-18, S borrowed $2,400,000 at 3%. S made semi-annual interest payments on 10-01-18 and 04-01...

A: Journal entry: Journal entry is a set of economic events which can be measured in monetary terms. Th...

Q: What is the difference between a CPA's unqualified opinion or “clean” opinion and a qualified one?

A: Click to see the answer

Q: A change in the liability for warranty costs requires a. presenting prior-period financial statement...

A:  

Q: A Type A lease agreement calls for quarterly lease payments of $5,376 over a 10-year lease term, wit...

A: Compute the outstanding balance:

Q: Journalizing issuance of stock—stated value Nelson Corporation issued 5,000 shares of $3 stated valu...

A: The stock in which shareholders are entitled to received dividend whose amount may vary from time to...

Q: Bronson Industries reported a deferred tax liability of $8 million for the year ended December 31, 2...

A: Taxable Income The amount of adjusted gross income which is liable to be taxed is known as taxable i...

Q: Olga Conrad, a financial writer, noted recently, “Thereare substantial arguments for including earni...

A: Projections: Based on the past and present records any estimation or forecast made are said to be pr...

Q: The Collins Corporation purchased office equipment at the beginning of 2014 and capitalized a cost o...

A: 1. 

Q: Describe techniques of comparative analysis

A: Comparative analysis of a financial statement helps the potential investors and stakeholders to anal...

Q: Classifying cash flow items Consider the following transactions: Purchased equipment for $130,000 c...

A: Click to see the answer

Q: On July 1, year 2, a company decided to adopt IFRS. The company’s first IFRS reporting period is as ...

A: IFRS:  International Financial Reporting Standard is abbreviated as IFRS. The IFRS is set up to brin...

Q: Determining the present value of bonds payable and journalizing using the effective-interest amortiz...

A: The presnt value of bond is $ 311580the compnay received $ 311580 as cash.

Q: Predetermined overhead rates and manufacturing overhead application (LO 4) Beltran Corporation produ...

A: A.Beltran's predetermined overhead rate for the yearPredetermined overhead rate = Estimated manufact...

Q: Journalizing issuance of stock—no-par Wolcott Corporation issued 5,000 shares of no-par common stock...

A: Common stock: These are the ordinary shares that a corporation issues to the investors in order to r...

Q: Dividing Partnership Income Tyler Hawes and Piper Albright formed a partnership, investing $195,000 ...

A: Division of net income under given assumptions:

Q: State how each of the following items is reflected in the financial statements. a.    Change from FI...

A: Hi, thankk you for the question. Since we only answer up to 3 sub-parts, we'll answer the first 3. P...

Q: Some financial instruments are called derivatives. Why?

A:  

Q: Journalizing cash and stock dividends Self-Defense Schools, Inc. is authorized to issue 200,000 shar...

A: 1. 

Q: What are the three relevant dates involving cash dividends? Describe each.

A: A dividend is a return received by shareholders of the company. The relevant dates involving cash di...

Q: Smitty’s Home Repair Company, a regional hardware chain that specializes in do-it-yourself materials...

A: Merger: A merger is the mix of two organizations into one by either shutting the old entities into o...

Q: Camm Corporation has two manufacturing departments--Forming and Assembly. The company used the follo...

A: Estimated fixed manufacturing overhead cost per MH = $4,600 / 2,000 = $2.30

Q: What are the major differences between postretirementhealthcare benefits and pension benefits?

A: Both pension funds and post retirement healthcare benefits accrue to an employee after his/her retir...

Q: Cost-plus, target pricing, working backward. The new CEO of Rusty Manufacturing has asked for a vari...

A: We are authorized to answer one question at a time, since you have not mentioned which question you ...

Q: Wardell Company purchased a mini computer on January 1, 2014, at a cost of $40,000. The computer has...

A: 1.Prepare adjusting entries: 

Q: Bernson Corporation is using a predetermined overhead rate that was based on estimated total fixed m...

A: The correct answer is $464,120.

Q: Value engineering, target pricing, and target costs. Westerly Cosmetics manufactures and sells a var...

A: Requirement 1:Determine the target cost of producing 400,000 units.

Q: Differentiate between the direct method and the indirect method by discussing each method.

A: Statement of cash flows: The statement of cash flows is a statement which includes all transactions ...

Q: You are the newest member of the staff of Brinks & Company, a medium-size investment management ...

A: Share issue cost: Cost such as legal fee, promotional charge, and accounting services incurred for t...

Q: Explain how the amount of cash payments to suppliers is computed under the direct method.

A: Statement of cash flows: The statement of cash flows is a statement which includes all transactions ...

Q: Module 2 Homework T-Accounts Would you please solve the following T-Account problems. Please show th...

A: 1. Compute ending balance of left side account as shown below:

Q: Suppose Yummy Treats Bakery issues common stock in exchange for a building. Yummy Treats Bakery shou...

A: The correct answer is Option (c)

Q: Presently, the profession requires that earnings per share be disclosed on the face of the income st...

A: Financial statement: A record of financial activities and financial position of the company or an in...

Q: The Antonescu Sporting Goods leased equipment from Chapman Industries on January 1, 2016. The agreem...

A: 1. Record journal entries for equipment taken on lease in the books of Antonescu sporting (Lessee) a...

Q: Journalizing issuance of no-par stock Eates Corp. issued 8,000 shares of no-par common stock for $13...

A: No-par common stock: The common stock that is issued at its fair market value is known as no-par com...

Q: M includes one coupon in each bag of dog food it sells. The coupons do not have an expiration date. ...

A: Click to see the answer

Q: Analyzing the effect of prior-period adjustments Taylor Corporation discovered in 2019 that it had i...

A: Prior period adjustment: It refers to the adjustment made in the current year to rectify the error m...

Q: Module 2 Homework T-Accounts Would you please provide the correct answers for these T-Account proble...

A: T-account: T-account is the form of the ledger account, where the journal entries are posted to this...