In: Accounting
Using the data for Brady and Co. below please provide:
Balance Sheet - comparative, classified in proper format for fiscal years 2015 and 2016
Income Statement - multiple-step for fiscal years 2015 and 2016. Include earnings per share data.
Statement of Retained Earnings for 2016.
2015 | 2016 | ||||
Dr | Cr | Dr | Cr | ||
Accounts Payable | 999,210 | 1,079,837 | |||
Accounts Receivable | 2,943,125 | 3,245,967 | |||
Accrued Liabilities - Other | 508,643 | 721,358 | |||
Accrued Pension Liabilities | 650,216 | 450,356 | |||
Accrued Restructuring Charges | 126,000 | 90,476 | |||
Accrued Salaries, Wages and Commissions | 281,364 | 350,191 | |||
Accumulated Other Comprehensive Income (Loss) | 621,236 | 85,000 | |||
Accumulated Depreciation - Property, Plant & Equipment | 1,829,634 | 1,999,999 | |||
Accumulated Post-Employment Benefit Obligation (long-term) | 802,316 | 402,634 | |||
Additional Paid-in Capital, Common Stock | 299,304 | 299,304 | |||
Additional Paid-in Capital, Preferred Stock | 75 | 75 | |||
Allowance for Doubtful Accounts | 125,436 | 124,645 | |||
Bonds Payable | 244,563 | 249,046 | |||
Cash and Cash Equivalents | 401,236 | 751,329 | |||
Common Stock ($1.00 par value) authorized 900 million shares issued 300 million shares in 2016, 284 million in 2015 | 300,000 | 284,000 | |||
Cost of Goods Sold | 3,000,235 | 2,763,584 | |||
Current Portion of Long-term Debt | 720,125 | 849,869 | |||
Deferred Tax Assets (current) | 62,596 | 81,236 | |||
Deferred Tax Liabilities (long-term) | 229,000 | 440,263 | |||
Depreciation Expense | 307,200 | 311,236 | |||
Dividends - Common | 292,351 | 214,956 | |||
Dividends - Preferred | 2,000 | 945 | |||
General & Administrative Expenses | 1,732,429 | 1,459,695 | |||
Goodwill and Other Intangibles | 3,212,491 | 3,212,491 | |||
Income Taxes Payable | 246,002 | 102,563 | |||
Interest Expense | 201,366 | 250,000 | |||
Interest Income | 10,126 | 18,227 | |||
Investments in unconsolidated affiliated companies | 1,235,000 | 1,456,896 | |||
Inventories | 163,214 | 224,561 | |||
Long-term Debt | 3,223,713 | 3,702,700 | |||
(Loss) Income from Discontinued Operations, net of tax | 28,100 | 7,453 | |||
Preferred Stock ($10 par value) authorized 10 million shares issued 90,000 shares in 2016, 90,000 in 2015 | 900 | 900 | |||
Prepaid Expenses | 141,029 | 170,296 | |||
Property, Plant and Equipment | 2,943,216 | 3,936,726 | |||
Provision for income taxes | 245,105 | 201,636 | |||
Research and Development Expenses | 199,500 | 496,597 | |||
Restructuring Charges | 199,506 | 255,013 | |||
Retained Earnings, beginning | 2,960,256 | 5,173,286 | |||
Sales | 8,430,061 | 6,526,967 | |||
Selling Expenses | 19,365 | 58,890 | |||
Short-term Investments | 20,000 | 26,800 | |||
Treasury Stock, at cost - 117,156,719 shares in 2016 and 108,822,953 shares in 2015 | 4,472,969 | 4,263,984 | |||
Unearned Revenues | 456,325 | 423,689 | |||
22,443,269 | 22,443,269 | 23,382,838 | 23,382,838 |
Comparative Balance Sheet of Brady and Co. for year 2015 and 2016 |
|||||
2015 |
2016 |
2015 |
2016 |
||
Shareholders funds |
Fixed Assets |
||||
Common Stock ($1.00 par value) |
300000.00 |
284000.00 |
Intangible Assets |
||
Additional Paid-in Capital Common Stock |
75.00 |
75.00 |
Goodwill and Other Intangibles |
3212491.00 |
3212491.00 |
Additional Paid-in Capital Preferred Stock |
299304.00 |
299304.00 |
|||
Preferred Stock ($10 par value) authorized 10 million shares issued 90000 shares in 2016 90000 in 2015 |
900.00 |
900.00 |
Tangible assets |
||
Retained Earings |
5173286.00 |
5713381.00 |
Property Plant and Equipment |
2943216.00 |
3936726.00 |
Accumulated Depreciation - Property Plant & Equipment |
-1829634.00 |
-1999999.00 |
|||
Long Term Liabilites |
|||||
Bonds Payable |
244563.00 |
249046.00 |
Long term Investments |
||
Long-term Debt |
3223713.00 |
3702700.00 |
Investments in unconsolidated affiliated companies |
1235000.00 |
1456896.00 |
Deferred Tax Liabilities (long-term) |
229000.00 |
440263.00 |
Treasury Stock at cost - 117156719 shares in 2016 and 108822953 shares in 2015 |
4472969.00 |
4263984.00 |
Accumulated Other Comprehensive Income (Loss) |
-621236.00 |
85000.00 |
|||
Accumulated Post-Employment Benefit Obligation (long-term) |
802316.00 |
402634.00 |
Current Assets |
||
Short-term Investments |
20000.00 |
26800.00 |
|||
Short Term Liabilities |
Deferred Tax Assets (current) |
62596.00 |
81236.00 |
||
Accounts Payable |
999210.00 |
1079837.00 |
Inventories |
163214.00 |
224561.00 |
Accrued Liabilities - Other |
508643.00 |
721358.00 |
Prepaid Expenses |
141029.00 |
170296.00 |
Accrued Pension Liabilities |
650216.00 |
450356.00 |
Accounts Receivable |
2943125.00 |
3245967.00 |
Accrued Restructuring Charges |
126000.00 |
90476.00 |
Allowance for Doubtful Accounts |
-125436.00 |
-124645.00 |
Current Portion of Long-term Debt |
720125.00 |
849869.00 |
Cash and Cash Equivalents |
401236.00 |
751329.00 |
Unearned Revenues |
456325.00 |
423689.00 |
|||
Accrued Salaries Wages and Commissions |
281364.00 |
350191.00 |
|||
Income Taxes Payable |
246002.00 |
102563.00 |
|||
13639806.00 |
15245642.00 |
13639806.00 |
15245642.00 |
||
Comparative Income Statement for year 2015 and 2016 |
||||
2015 |
2016 |
|||
Revenue From operations: |
||||
Sales |
8430061.00 |
6526967.00 |
||
Interest Income |
10126.00 |
18227.00 |
||
8440187.00 |
6545194.00 |
|||
Cost of Goods Sold |
3000235.00 |
2763584.00 |
||
Depreciation Expense |
307200.00 |
311236.00 |
||
General & Administrative Expenses |
1732429.00 |
1459695.00 |
||
Interest Expense |
201366.00 |
250000.00 |
||
Selling Expenses |
19365.00 |
58890.00 |
||
Research and Development Expenses |
199500.00 |
496597.00 |
||
Restructuring Charges |
199506.00 |
255013.00 |
||
5659601.00 |
5595015.00 |
|||
Net profit before Tax and Other Comprehensive Income |
2780586.00 |
950179.00 |
||
(Loss) Income from Discontinued Operations, net of tax |
28100.00 |
-7453.00 |
||
28100.00 |
-7453.00 |
|||
Net Profit Before Tax |
2752486.00 |
957632.00 |
||
Provision for income taxes |
245105.00 |
201636.00 |
||
Net Profit After Tax |
2507381.00 |
755996.00 |
||
No. of Shares |
284000.00 |
300000.00 |
||
Earning Per Share |
8.83 |
2.52 |
||
Statement of Retained Earnings |
||||
Particulars |
2015 |
2016 |
||
Retained Earnings, beginning |
2960256 |
5173286 |
||
Net profit After Tax |
2507381.00 |
755996.00 |
||
5467637.00 |
5929282.00 |
|||
Dividends - Common |
292351 |
214956 |
||
Dividends - Preferred |
2000 |
945 |
||
294351 |
215901 |
|||
Retained Earnings at the end of Year |
5173286.00 |
5713381.00 |