Question
From the list of accounts provided on the Raw Data Prepare, using Excel: 1. A Trial Balance for both years (each one on a separate
From the list of accounts provided on the Raw Data Prepare, using Excel:
1. A Trial Balance for both years (each one on a separate tab) Refer to financial accounting text for order of accounts on a trial balance.
2. An Income Statement (including simple EPS calculation) for both years on the same worksheet tab,
3. Statement of Retained Earnings for both years on the same worksheet tab and
4. Balance Sheet for the end of each year on the same worksheet tab,
5. A Statement of Cash Flows for 2017 only and
6. Statement of Stockholders' Equity for 2017 only.
7. Be sure to include a heading on each financial statement in good form. Format the statements correctly. Refer to a financial accounting text or online resources for help. You should have a total of 8 worksheet tabs.
8. Use global (3D) formulas - in other words, refer to cells on other worksheets in your formulas. YOU MUST USE 3-D formulas throughout each worksheet. The ONLY worksheet that should have the hard-coded or typed financial information or words is the first one where the raw data is imported. Every other sheet MUST have ONLY text or formulas/functions. (Few Exceptions like names of subtotals and totals and the Cash Flow Statement)
In addition to the information above, you also need to know the following:
1) The long-term investments were purchased at cost.
2) The land that was sold had originally cost $325,000 and was sold for $490,000 Cash,
3) Treasury Stock, 5000 shares, were purchased in 2017 for $40,000
4) 20,000 shares of common stock were issued in 2017 at a price of $15 per share
Analytics Extra Data Sheet Accounts receivable (net) Accumulated Depreciation Additional Paid in Capital-Common Administrative expenses Bond payable, 10% due 2025 Cash Common stock, $2 par Cost of goods sold Current liabilities Depreciation Expense Dividends on common stock Dividends on preferred stock Gain on Sale of Land Income tax expense Inventories Long-term investments Temporary Investments Mortgage note payable, 9%, due 2030 Other expense (interest) Other income Preferred $2.00 stock, $50 par Prepaid expenses Property, plant, and equipment Retained earnings, 1/1 Sales Sales returns and allowances Selling expenses Treasury Stock 31-Dec-17 31-Dec-16 196,500 200,000 400,000 475,000 500,000 120,000 100,000 1,550,000 1,420,500 268,000 100,000 40,000 12,500 0 118,750 132,500 250,000 67,500 0 50,000 47,500 500,000 30,000 2,775,0002,100,000 781,500 3,415,0003,062,500 22,500 723,750 0 275,000 300,000 600,000 371,000 500,000 162,000 200,000 267,000 100,000 40,000 12,500 125,000 168,000 417,000 299,500 387,000 600,000 98,000 48,000 500,000 27,500 928,500 35,000 726,000 40,000 Analytics Extra Data Sheet Accounts receivable (net) Accumulated Depreciation Additional Paid in Capital-Common Administrative expenses Bond payable, 10% due 2025 Cash Common stock, $2 par Cost of goods sold Current liabilities Depreciation Expense Dividends on common stock Dividends on preferred stock Gain on Sale of Land Income tax expense Inventories Long-term investments Temporary Investments Mortgage note payable, 9%, due 2030 Other expense (interest) Other income Preferred $2.00 stock, $50 par Prepaid expenses Property, plant, and equipment Retained earnings, 1/1 Sales Sales returns and allowances Selling expenses Treasury Stock 31-Dec-17 31-Dec-16 196,500 200,000 400,000 475,000 500,000 120,000 100,000 1,550,000 1,420,500 268,000 100,000 40,000 12,500 0 118,750 132,500 250,000 67,500 0 50,000 47,500 500,000 30,000 2,775,0002,100,000 781,500 3,415,0003,062,500 22,500 723,750 0 275,000 300,000 600,000 371,000 500,000 162,000 200,000 267,000 100,000 40,000 12,500 125,000 168,000 417,000 299,500 387,000 600,000 98,000 48,000 500,000 27,500 928,500 35,000 726,000 40,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started