Philadelphia Widget Corporation is in the process of preparing financial statements for the year ended...
50.1K
Verified Solution
Link Copied!
Question
Accounting
Philadelphia Widget Corporation is in the process of preparing financial statements for the year ended December 31, 2015. They have completed the balance sheet and income statement as shown.
Philadelphia Widget Corporation
Income Statement
For the year ended December 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
Comparative Balance Sheets
December 31, 2015; 2014; and 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 & 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, 3,500 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 & Equity
$414,516
$399,192
$432,864
Instructions
Prepare a horizontal analysis the two most recent years of Philadelphia Widget Corporations balance sheets.
Philadelphia Widget Corporation
Horizontal Analysis of Balance Sheet
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 & Equipment, net
103,550
##.#%
109,850
##.#%
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
35,000
##.#%
35,000
##.#%
35,000
Retained Earnings
84,491
##.#%
33,212
##.#%
26,164
Total Liabilities & Equity
$414,516
##.#%
$399,192
##.#%
$432,864
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!