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

  How best to acquire capital

Evaluate the criteria or mechanisms used by the organisation for deciding how best to acquire capital and analyse the capital structure of the company.

  What is the argument for use of brightline tests

Identify where bright-lines currently exist in the statement of financial position, areas in which we might expect revisions in the future. What is the argument for use of brightline tests?

  Relation to company profitability and financial stability

What do these ratios show in relation to the company's profitability and financial stability?

  Determine the proper balance in the allowance

Prepare a table with the headings below (and a row for each type of raw material) and determine the proper balance in the Allowance to Reduce Inventory to Market account at December 31, 2009.

  How much interest will you earn during the 7 years

how much interest will you earn during the 7 years Round the answer to the nearest cent If you put $7,000 at the end of each year into a savings account that pays interest at the rate of 3 percent a year, how much would you have after 7 years

  Administrative and selling expenses

Administrative and Selling expenses

  Ledger i am doing a accounting comprehensive problem i want

i am doing a accounting comprehensive problem i want to know how to organize a ledger income statement

  Explain the relationship between code of conduct

Explain the relationship between code of conduct and corporate governance and research and report on current issues and trends in corporate governance reporting.

  Determine the monthly break-even

Determine the monthly break-even in either unit or total dollar sales. Show your work!

  Is there more than one class of common stock

Did the common buy back a significant amount of its shares in the current year? You can see this in the Statement of Stockholders' Equity as a reduction in shares.

  Find the lozier''s income from continuing operations

What was Lozier's gross profit, What was Lozier's income from operations, What was Lozier's income before income tax and What was Lozier's income from continuing operations

  What is the amount of capital in excess of par

What was the amount of retained earnings at the beginning of the year?

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