+1-415-670-9189
info@expertsmind.com
Prepare a statement of cash flow using the indirect method
Course:- Accounting Basics
Reference No.:- EM131722908




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Accounting Basics

Problem - This is a comprehensive problem all contained on this spreadsheet tab. You are to prepare a cash flow statement, a vertical analysis, a horizontal analysis, and some ratio calculations. Scroll down the spreadsheet to complete each part.

Philadelphia Widget Corporation is in the process of preparing financial statements for the year ended 12/31/2015.

They have completed the balance sheet and income statement as shown.

Philadelphia Widget CorporationIncome StatementFor the year ended 12/31/2015




Revenue


1,235,000

Cost of Goods Sold


806,356

Gross Profit


428,644




Administrative Expenses:



  Salaries

212,450


  Rent

82,500


  Depreciation

24,800


  Total Administrative Expense


319,750

Operating Profit


108,894




Gain on Sale of Equipment


4,500

Interest Expense


(42,115)

Net Income


71,279

 

Philadelphia Widget Corporation Balance Sheet

As of 12/31/2015, 12/31/2014, and 12/31/2013


2015

2014

2013

Cash


119,411


89,564


105,644

Accounts Receivable


85,455


83,118


78,400

Inventory


41,600


48,560


62,600

Prepaid Expenses


14,500


18,100


24,000

Total Current Assets


260,966


239,342


270,644








Land


50,000


50,000


50,000

Buildings and Equipment

182,450


172,450


166,800


Accumulated Depreciation

78,900

103,550

62,600

109,850

54,580

112,220








Total Assets


414,516


399,192


432,864















Accounts Payable


62,525


51,480


45,200

Wages payable


4,500


4,500


1,500

Unearned Revenue


3,000


-


-

Current Portion of Long-Term Debt


50,000


50,000


50,000

Total Current Liabilities


120,025


105,980


96,700








Long-Term Debt


175,000


225,000


275,000








Common Stock, 3500 shares outstanding

35,000


35,000


35,000


Retained Earnings

84,491


33,212


26,164


Total Stockholders' Equity


119,491


68,212


61,164








Total Liabilities and Equity


414,516


399,192


432,864

A. Prepare a Statement of Cash Flow using the indirect method for the 2015, using the above statements and the following additional information:

1. Equipment costing $30,000 was purchased in 2015.

2. Equipment having an original cost of $20,000 and accumulated depreciation of $8,500 was sold for $16,000 during 2015.

3. A dividend of $20,000 was declared and paid in 2015.

B. Prepare a vertical analysis (1 year) of the income statement above and a horizontal analysis (2 years) of the balance sheet.

C. Calculate the following ratios based on 12/31/2015 numbers:

1. Earnings per share

2. Return on common stockholder's equity

3. Return on assets

4. Current ratio

5. Acid-test ratio

6. Accounts receivable turnover




Put your comment
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Accounting Basics) Materials
Write a 700- to 1,050-word paper analyzing the disclosures contained within the notes to the financial statements related to cash and cash equivalents, receivables, and inve
What is your conclusion about the fairness of the recorded balance in accounts payable for pinnacle manufacturing as it affects the income statement and balance sheet?
Derrick Lee just received a signing bonus of $1,000,000. His plan is to invest this payment in a fund that will earn 6%, compounded annually. (Hint: Use tables in text.)
The equity sections from Hovo Corporations 2013 and 2014 balance sheets follow.Stockholders Equity (December 31, 2013) Common stock,$ 20 par value, 30,000 shares authorized,
In addition, some of CJP's facilities could be rented to a third party for $15,000 per year. What are the relevant costs for the "make" alternative?
Record these events in a general journal. Open T-accounts and post the beginning balances and the preceding transactions to the appropriate accounts. Determine the balance of
Explain procedures for collecting accounting evidence, Explain the use of sampling in performing an examination Evaluate accounting evidence using analytical and inferential t
Which scheme does not inflate sales? A) Recognizing sales on disputed claims against customers. B) Recognizing sales without shipping the goods. C) Understanding allowances fo