### Free Educational Resources

• > ACCT 221 WEEK 3 HOMEWORK
+

# ACCT 221 WEEK 3 HOMEWORK

##### Rating:
(0)
Author: Joyce Buda
##### Description:

http://theperfecthomework.com/acct-221-week-3-homework/

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.

A. Prepare a Statement of Cash Flow using the indirect method for 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:

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial