Question
Open a new sheet in the workbook by clicking on the + on the bottom left of the screen. This is going to be your
Open a new sheet in the workbook by clicking on the + on the bottom left of the screen. This is going to be your Income Statement page. Using the numbers from the Adjusted Trial Balance column on the working trial balance, create a multi-step income statement that includes every account you identified as I in step 1 above.You should create the income statement such that it updates automatically if you add any debits or credits to the accounts existing on your working trial balance.
Open a new sheet in the workbook by clicking on the + on the bottom left screen. This is going to be your Balance Sheet page. Using the numbers from the Adjusted Trial Balance column on the working trial balance, create a classified balance sheet that includes every account you identified as B in step 1 above. (If you need a refresher on the balance sheet use chapter 3 of your textbook- again do NOT use an online template or the acctng 3401 Paris Bike balance sheet but create your own).
IMPORTANT NOTE: When you get to the Retained Earnings(or Accumulated Deficit) line on the balance sheet you will need to pick up the balance from the Adjusted Trial Balance column like you did for the other accounts PLUS you will need to pick up the Net Income (Loss) from your income statement PLUS you will need to subtract any (Dividends) from the Adjusted Trial Balance page. FYI the extra steps are necessary because you have not done closing entries for the period in this assignment.
You also need to adjust the Accumulated Comprehensive loss line on the balance sheet by picking up any debits or credits on the working trial balance that you have marked "C" as items that flow through the Statement of Comprehensive Income. FYI - these extra steps are necessary because you have done closing entries for the period in this assignment.
Consolidated Condensed Balance Sheets - USD ($) $ in Millions | Mar. 30, 2019 | ||
F/S | DR | CR | |
Cash and cash equivalents | B | $ 80.6 | |
Accounts receivable | B | 401.2 | |
Allowance for Bad Debt | B | 25.7 | |
Short term investments | B | 70.0 | |
Finished products | B | 359.2 | |
Raw materials and work-in-process | B | 14.8 | |
Prepaid expenses and other current assets | B | 45.4 | |
Property, plant and equipment, at cost | B | 385.6 | |
Accumulated depreciation | B | 252.60 | |
Lease right-of-use assets, net | B | 157.2 | |
Goodwill | B | 425.9 | |
Indefinite-lived intangibles | B | 604.5 | |
Amortizable intangibles, net | B | 70.7 | |
Equity method investments | B | 14.5 | |
Accounts payable | B | 112.6 | |
Accrued salaries and wages | B | 16.9 | |
Other accrued liabilities | B | 98 | |
Current maturities of long-term debt | B | 10 | |
Other short-term notes | B | 326 | |
Operating Lease, Liability, Current | B | 28.6 | |
Long-term debt, less current maturities | B | 435.3 | |
Operating Lease, Liability, Noncurrent | B | 147.3 | |
Accrued pension liabilities | B | 92.1 | |
Deferred income taxes | B | 108.6 | |
Environmental liabilities and other liabilities | B | 58.6 | |
Common Stock - par value $1, authorized 320,000,000 shares; shares issued (including shares in treasury): March 30, 2019: 107,881,756 shares; December 29, 2018: 107,609,206 shares | B | 107.9 | |
Additional paid-in capital | S | 208 | |
Retained earnings | B | 1,175.3 | |
Accumulated other comprehensive loss | C | 88.3 | |
Cost of shares in treasury: March 30, 2019: 19,152,384 shares | S | 520 | |
Revenue | I | 523.40 | |
Cost of goods sold | I | 303.2 | |
Selling, general and administrative expenses | I | 150 | |
Depreciation expense | I | 7 | |
Stock Compensation expense | I | 7 | |
Environmental and other related costs | I | 3.8 | |
Interest expense | I | 6.9 | |
Other income, net | I | 1.2 | |
Income tax expense | I | 6.1 | |
Dividends | S | 8.8 | |
Unrealized gins on AFS securities | C | 2.6 | |
TOTALS | 3730.7 | 3730.7 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started