Prepare a complete cash flow statement of a company, Cost Accounting

Listed below are some balances of XYZ, Inc as of and for the year ended December 31, 2012 and 2013

Year ending

12/31/13

 

Revenue

2,000,000

 

Cost of goods sold

600,000

 

Rent expense

120,000

 

Insurance expense

60,000

 

Interest expense

50,000

 

Income tax expense

55,000

 

Payroll and benefit expense

200,000

 

Depreciation cost

50,000

 

Amortization cost

10,000

 

Gain on sale of investments

20,000

 

Loss on building fire

50,000

 

Interest income

25,000

 

General and administrative cost

180,000

 

Dividend income

25,000

 

 

 

 

As of

12/31/12

12/31/13

Accounts receivable

300,000

325,000

Interest receivable

10,000

8,000

Inventory

375,000

350,000

Accrued payroll and benefits

65,000

78,000

Accrued rent

10,000

10,000

Prepaid insurance

100,000

80,000

Accrued general and administrative

15,000

10,000

Accrued income tax

10,000

55,000

Cash

50,000

1,567,000

The following is additional information with regards XYZ during the year ending December 31, 2013:

Paid a dividend of $100,000

Made lease payments of $30,000

Purchased Ford Motor Stock for $25,000

Borrowed $600,000 under its line of credit

Purchased land for $50,000

Loaned $25,000 to the CEO

Sold patent for $30,000

Proceeds from sale of GE stock $100,000

Made Bond payments of $10,000

Repurchased Company stock for $15,000

Received insurance proceeds of $12,000 related to building fire

Issued $200,000 of XYZ common stock

Requirements:  Using the information above for XYZ Inc

(1)    Prepare a complete cash flow statement for the year ending December 31, 2013 using the indirect method

(2)    Prepare the operating section of the cash flow statement for the year ending December 31, 2013 using the direct method

(1)   The cash flow statements should be prepared in proper form and format including all relevant headings, sections, captions, titles, totals and subtotals. 

(2)   Solutions must be prepare using either excel or word.

Posted Date: 3/6/2013 4:07:49 AM | Location : United States







Related Discussions:- Prepare a complete cash flow statement of a company, Assignment Help, Ask Question on Prepare a complete cash flow statement of a company, Get Answer, Expert's Help, Prepare a complete cash flow statement of a company Discussions

Write discussion on Prepare a complete cash flow statement of a company
Your posts are moderated
Related Questions
Lapsol limited manufacture electrical appliances for the export market. The management of the company are considering investing in one of two possible capital expenditure projects.

Variable Overhead Variance This is the dissimilarity between the variable overheads absorbed and the actual variable overheads warned. Therefore it can be described as the und

If a company trades in a building towards a new building and does not recognize a gain or loss (because of code section 1031), will this transaction affect the cash flows statement

Under the average cost method the average cost of goods held in stock is recalculated after each receipt. An issue after the receipts is made at the recalculated average prices. A

Example of Profit Volume Graph The summary results of a company are given as: Product                        A B          C

Currently the stock of Backstreet Toys (BT) is selling for $20 per share and the risk free rate is5%. a) Draw a payoff diagram for each of the following 3 portfolios: i. Buy

Weston Corporation manufactures a product that is available in both a deluxe and a regular model. The company has made the regular model for years; the deluxe model was introduced

Sleep Corporation was organized on January 1, 2011. During its first year, the corporation issued 40,000 shares of $5 par value preferred stock and 400,000 shares of $1 par value c

Prepare Cash Budget of a Company The given information concerned to the proposed budget for a company for the months ending on 31 December 1996. Additional Information

Question Roseville, Ltd., sells one of its products for $500 each. Sales volume averages 1,000 units per year. Recently, its main competitor priced their competing product at 1