Homework Help is Here – Start Your Trial Now!
Business
Accounting
Using the Data below create a balance sheet. This should be comparative and classified in proper format for the fiscal years 2015 and 2016.Just use the amounts for each year and ignore whether its credit and debit.

Using the Data below create a balance sheet. This should be comparative and classified in proper format for the fiscal years 2015 and 2016.Just use the amounts for each year and ignore whether its credit and debit.

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...
See similar textbooks
icon
Related questions
Question

Using the Data below create a balance sheet. This should be comparative and classified in proper format for the fiscal years 2015 and 2016.Just use the amounts for each year and ignore whether its credit and debit.

Don't worry about the "debit" (dr) or "credit" (cr) columns - just use the amount Brady and Co. List of Accounts from General Ledger in Alphabotical Order December 31, 2016 (thousands of dollars) 2015 2016 Cr 1,079,837 Dr Cr Dr Accounts Payable 999,210 2,943,125 3,245,967 Accounts Receivable 721,358 450,356 90.476 350,191 85,000 1,999,999 402,634 299,304 75 Accrued Liabilities - Other Accrued Pension Liabilities Accrued Restructuring Charges 508,643 650,216 126,000 281,364 Accrued Salaries, Wages and Commissions Accumulated Other Comprehensive Income (Loss) Accumulated Depreciation - Property, Plant & Equipment 621,236 1,829,634 802,316 299,304 Accumulated Post-Employment Benefit Obligation (long-term) Additional Paid-in Capital, Common Stock Additional Paid-in Capital, Preferred Stock Allowance for Doubtful Accounts 75 125,436 244,563 124,645 249,046 Bonds Payable 401,236 751,329 Cash and Cash Equivalents Common Stock 300,000 284,000 Cost of Goods Sold 3,000,235 2,763,584 720,125 849,869 Current Portion of Long-term Debt Deferred Tax Assets (current) 62,596 81,236 229,000 440,263 Deferred Tax Liabilities (long-term) Depreciation Expense Dividends - Common Dividends - Preferred General & Administrative Expenses Goodwill and Other Intangibles Income Taxes Payable Interest Expense Interest Income Investments in unconsolidated affiliated companies Inventories Long-term Debt 307,200 292,351 2,000 1,732,429 3,212,491 311,236 214,956 945 1,459,695 3,212,491 246,002 102,563 201,366 250,000 10,126 18,227 1,235,000 163,214 1,456,896 224,561 3,223,713 (Loss) Income from Discontinued Operations, net of tax Preferred Stock 3,702,700 7,453 900 28,100 900 141,029 2,943,216 245,105 199,500 199,506 170,296 3,936,726 201,636 496,597 255,013 Prepaid Expenses Property, Plant and Equipment Provision for income taxes Research and Development Expenses Restau Restructuring Charges Retained Earnings, beginning Sales 2,960,256 8,430,061 5,173,286 6,526.967 Selling Expenses Short-term Investments Treasury Stock, at cost Uneamed Revenues 19,365 20,000 4,472,969 58,890 26,800 4,263,984 456,325 22,443,269 423,689 23,382,838 22,443,269 23,382,838 Net Income (loss) Weighted average number of common shares: FY 2016: Basic 208,448,076 shares 210,348,076 shares Diluted FY 2015: Basic Diluted 218,464,140 shares 220,964,140 shares ** again The Dr = Debit and the Cr = Crodit. Do not worry about this since you are not responsible for debits and credits. It is incluc students are familiar with debits and credits
Transcribed Image Text:Don't worry about the "debit" (dr) or "credit" (cr) columns - just use the amount Brady and Co. List of Accounts from General Ledger in Alphabotical Order December 31, 2016 (thousands of dollars) 2015 2016 Cr 1,079,837 Dr Cr Dr Accounts Payable 999,210 2,943,125 3,245,967 Accounts Receivable 721,358 450,356 90.476 350,191 85,000 1,999,999 402,634 299,304 75 Accrued Liabilities - Other Accrued Pension Liabilities Accrued Restructuring Charges 508,643 650,216 126,000 281,364 Accrued Salaries, Wages and Commissions Accumulated Other Comprehensive Income (Loss) Accumulated Depreciation - Property, Plant & Equipment 621,236 1,829,634 802,316 299,304 Accumulated Post-Employment Benefit Obligation (long-term) Additional Paid-in Capital, Common Stock Additional Paid-in Capital, Preferred Stock Allowance for Doubtful Accounts 75 125,436 244,563 124,645 249,046 Bonds Payable 401,236 751,329 Cash and Cash Equivalents Common Stock 300,000 284,000 Cost of Goods Sold 3,000,235 2,763,584 720,125 849,869 Current Portion of Long-term Debt Deferred Tax Assets (current) 62,596 81,236 229,000 440,263 Deferred Tax Liabilities (long-term) Depreciation Expense Dividends - Common Dividends - Preferred General & Administrative Expenses Goodwill and Other Intangibles Income Taxes Payable Interest Expense Interest Income Investments in unconsolidated affiliated companies Inventories Long-term Debt 307,200 292,351 2,000 1,732,429 3,212,491 311,236 214,956 945 1,459,695 3,212,491 246,002 102,563 201,366 250,000 10,126 18,227 1,235,000 163,214 1,456,896 224,561 3,223,713 (Loss) Income from Discontinued Operations, net of tax Preferred Stock 3,702,700 7,453 900 28,100 900 141,029 2,943,216 245,105 199,500 199,506 170,296 3,936,726 201,636 496,597 255,013 Prepaid Expenses Property, Plant and Equipment Provision for income taxes Research and Development Expenses Restau Restructuring Charges Retained Earnings, beginning Sales 2,960,256 8,430,061 5,173,286 6,526.967 Selling Expenses Short-term Investments Treasury Stock, at cost Uneamed Revenues 19,365 20,000 4,472,969 58,890 26,800 4,263,984 456,325 22,443,269 423,689 23,382,838 22,443,269 23,382,838 Net Income (loss) Weighted average number of common shares: FY 2016: Basic 208,448,076 shares 210,348,076 shares Diluted FY 2015: Basic Diluted 218,464,140 shares 220,964,140 shares ** again The Dr = Debit and the Cr = Crodit. Do not worry about this since you are not responsible for debits and credits. It is incluc students are familiar with debits and credits
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Balance Sheet Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
SEE MORE TEXTBOOKS