Prepare the spreadsheet for the 2012 statement of cash flows

Assignment Help Financial Accounting
Reference no: EM13533094

Preparing the statement of cash flows-indirect method

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

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


2012

2011

Increase (Decrease)

Current assets:




Cash and cash equivalents

$ 11,800

$ 15,200

$ (3,400)

Accounts receivable

42,200

43,900

(1,700)

Inventories

96,800

93,500

3,300

Plant assets:




Land

39,800

14,000

25,800

Equipment, net

101,100

93,800

7,300

Total assets

$ 291,700

$ 260,400

$ 31,300

Current liabilities:




Accounts payable

$ 25,100

$ 26,300

$ (1,200)

Accrued liabilities

24,200

22,500

1,700

Long-term liabilities:




Notes payable

51,000

64,000

(13,000)

Stockholders' equity:




Common stock

136,600

128,300

8,300

Retained earnings

54,800

19,300

35,500

Total liabilities and stockholders' equity

$ 291,700

$ 260,400

$ 31,300

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

Revenues:



Sales revenue


$ 441,000

Interest revenue


11,300

Total revenues


$ 452,300

Expenses:



Cost of goods sold

$ 205,300


Salary expense

76,500


Depreciation expense

15,100


Other operating expense

49,600


Interest expense

24,700


Income tax expense

16,700


Total expenses


387,900

Net income


$ 64,400

Requirement

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

Reference no: EM13533094

Questions Cloud

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
Find the mean speed in meters per second : The current indoor world record time in the 200-m race is 19.92 s, held by Frank Fredericks of Namibia (1996), Find the mean speed in meters per second corresponding to the record time for the 200-m event
Determine what might the fatal voltage be : A human being can be electrocuted if a current as small as 50 mA passes near the heart.  what might the fatal voltage be

Reviews

Write a Review

Financial Accounting Questions & Answers

  The subsequent are selected 2012 transactions of darby

the subsequent are selected 2012 transactions of darby corporation.1st sept purchased inventory from orion company on

  The ceo of smartphone apps llc is preparing a loan

the ceo of smartphone apps llc is preparing a loan application. using the data below only prepare an income statement.

  Evaluate the amount of net loss

Evaluate the amount of net loss that Jones can report on its income statement for the year

  Prepare a horizontal common-size analysis

Prepare a horizontal common-size analysis with change in dollars, using March 31, 2012 and prepare a vertical analysis for the years ended March, 2012 and 2013

  Prepare a process priority map

Identify five functions/processes involved in achieving the mission of The State Board for Educator Certification and prepare a Process Priority Map

  Determine the debt ratio based on the information

Determine the debt ratio based on the information below. Be sure to label your answer clearly and show all work.

  Prepare the journal entries needed to record investments

Prepare the journal entries needed to record the investments of Levy and Parcells.

  Question company reported total income of 420000 for 2014

question company reported total income of 420000 for 2014. changes occurred in numerous balance sheet accounts as

  How should ken have recorded each of the four events

Work in Process Inventory 25,000 Cash 25,000(This is for materials put into process and manufacturing Overhead 12,000 Cash 12,000(This is for bonuses paid to salespeople.

  Compute standard direct labor rate per hour

Quantity-actual production time 1.5 hours, rest periods and clean up 0.33 hours, and setup and downtime 0.18 hours. Compute Standard direct labor rate per hour.

  What is the maturity value of the bonds

What is the maturity value of the bonds, what is the carrying amount of the bonds on December 31, 2012 and what is the annual cash interest payment on the bonds?

  What will be the implications for barmunda

What will be the implications for Barmunda Pty Ltd if it is considered to be a reporting entity and advise the Management Committee of Barmunda Pty Ltd as to whether the company would be considered a reporting entity in accordance

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