Statement of cash flows - prepare the spreadsheet

Assignment Help Financial Accounting
Reference no: EM13533096

Preparing the statement of cash flows-indirect method

The 2012 comparative balance sheet and income statement of Appleton Group, Inc., follow. Appleton had no noncash investing and financing transactions during 2012.

APPLETON GROUP, INC. Comparative Balance Sheet December 31, 2012 and 2011


2012

2011

Increase (Decrease)

Current assets:




Cash and cash equivalents

$ 9,300

$ 15,300

$ (6,000)

Accounts receivable

42,000

43,200

(1,200)

Inventories

97,100

93,700

3,400

Plant assets:




Land

41,100

16,000

25,100

Equipment, net

101,200

94,300

6,900

Total assets

290,700

$ 262,500

$ 28,200

Current liabilities:




Accounts payable

$ 25,600

$ 26,600

$ (1,000)

Accrued liabilities

24,000

22,800

1,200

Long-term liabilities:




Notes payable

46,000

62,000

(16,000)

Stockholders' equity:




Common stock

140,300

131,400

8,900

Retained earnings

54,800

19,700

35,100

Total liabilities and stockholders' equity

$ 290,700

$ 262,500

$ 28,200

APPLETON GROUP, INC. Income Statement Year Ended December 31, 2012

Revenues:



Sales revenue


$ 439,000

Interest revenue


11,800

Total revenues


$ 450,800

Expenses:



Cost of goods sold

$ 205,500


Salary expense

76,500


Depreciation expense

15,500


Other operating expense

49,500


Interest expense

24,300


Income tax expense

16,300


Total expenses


387,600

Net income


$ 63,200

Requirement

1. Prepare the spreadsheet for the 2012 statement of cash flows. Format cash flows from operating activities by the indirect method.

Reference no: EM13533096

Questions Cloud

Explain 2-methyl-2-butanol and sulfuric acid h2so4 : Show the reaction mechanism when 2-methyl-2-butanol, sulfuric acid(H2SO4), and water are in a mixture
Prepare operating activities section of business statement : Prepare the operating activities section of the business statement of cash flows for the year ended June 30, 2012, using the direct method.
Describe why hydrogen electrode is used as the cathode : A copper, Cu(s), electrode is immersed in a solution that is 1.00 M in ammonia, NH3, and 1.00 M in tetraamminecopper(II), [Cu(NH_3)_4]^{2+}. If a standard hydrogen electrode is used as the cathode, the cell potential, E_cell, is found to be 0.076 ..
Format cash flows from operating activities : Prepare the spreadsheet for the 2012 statement of cash flows. Format cash flows from operating activities by the indirect method.
Statement of cash flows - prepare the spreadsheet : Prepare the spreadsheet for the 2012 statement of cash flows. Format cash flows from operating activities by the indirect method.
Define photons with a wavelength how much energy is absorbed : A plant must absorb 48 moles of photons with a wavelength of 430 nm for every mole of sugar that it produces. If a plant absorbs 36.5 moles of photons with a wavelength of 430. nm, how much energy in kJ has it absorbed
Prepare the spreadsheet for the 2012 statement of cash flows : Prepare the spreadsheet for the 2012 statement of cash flows. Format cash flows from operating activities by the indirect method.
Evaluate the resulting charge on each capacitor : Capacitors C1 = 5.65 µF and C2 = 2.75 µF are charged as a parallel combination across a 250 V battery. Calculate the resulting charge on each capacitor
How much is the total return of the portfolio reduced : how much is the total return of the portfolio reduced by trading costs - Suppose that every time a fund manager trades stock, transaction costs

Reviews

Write a Review

Financial Accounting Questions & Answers

  Advise dr. white to prepare for reduced budgets

Compare and contrast accounting principles in lean production to those of typical production. Explain how you would advise Dr. White to prepare for reduced budgets.

  Effect of capital structure on companies value per share

Effect of capital structure on companies value per share - market-value balance sheets, assuming the capital structure before recapitalization. Please complete the worksheet for the recapitalization alternative.

  Determine the amount of merchandise inventory lost

Complete the Balance Sheet using the information on the Post Closing Trial Balance and determine the amount of Merchandise Inventory lost and prepare the entry to write off the lose.

  By how many days would the cash conversion cycle be

by how many days would the cash conversion cycle be changed?cash conversion cyclecyree inc. has annual sales of

  Government-wide financial statements

What information do the government-wide financial statements present and What information do the fund financial statements present?

  Prepare a statement of cash flows for bluebonnet bakers

Prepare a statement of cash flows for 2011 for Bluebonnet Bakers. Use the direct method for reporting operating activities.

  Draft the appropriate audit opinion provided the scenarios

Draft the appropriate audit opinion provided the subsequent scenarios.

  Prepare consolidated financial statements for peony

Assume that Jong used the equity method of accounting for its investment in Nye instead of the cost method.  Calculate the balance of its Investment in Nye account and prepare the consolidated financial statements for Peony at December 31, 20X6 usi..

  Journal entries necessary to bring the companys

Prepare the journal entries necessary to bring the companys book balance of cash into conformity with the reconciled cash balance as of July 31, 2008.

  How much cash did haden receive from its customers

Haden Inc. had cash sales of $300,000 and credit sales of $1,050,000. The accounts receivable balance increased $15,000 during the year. How much cash did Haden receive from its customers during the year?

  How to prepare the entries

Prepare the entries, if any, on each of the three dividend dates. (Credit account titles are automatically indented when amount is entered. Do not indent manually.)

  Describe process of preparing a trial balance

Describe the process of preparing a trial balance. What is the purpose of preparing a trial balance? If a trial balance does not balance.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd