+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
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
A borrower has two alternatives for a loan: (1) issue a $660,000, 90-day, 9% note or (2) issue a $660,000, 90-day note that the creditor discounts at 9%. Assume a 360-day year
Analyse how this seasonality can affect capacity decisions.- Describe a case where demand seasonality is evident and strongly disturbs the smooth operation of your selected or
Assume that the lessor retains title to the machine at the expiration of the lease, that there is no bargain renewal or purchase option, and that the fair value of the equip
How much goodwill will be reported in the consolidation financial statements on December 31, 2012, at the end of Allen's fiscal year? What is the excess amortization expense
Corporation issued 100,000 shares of $20 par value, cumulative, 8% preferred stock on January 1, 2009, for $2,100,000. In December 2011, AI declared its first dividend of $500
During this past year Pat's collected $42,000 in tailoring fees, and paid $14,000 in expenses. Depreciation expense totaled $2,000. Accounts receivable increased $1,500, sup
10.22 - Static and flexible budgets, variances, information quality The photocopying department in a community college has budgeted monthly costs at $40,000 per month plus $
When a multi product factory operates at full capacity, decisions must be made about what products to emphasize. In making such decisions, products should be ranked based on