Assignment
Using each and every line item of data provided for Intel(an Excel spreadsheetwith the data is found on Blackboard), re-create the company's balancesheet and income statementin a reasonably correct manner. Some items (e.g., gross accounts receivable, allowance for doubtful accounts, and net accounts receivable) are not typically found listed on the financial statements but you should include them on this assignment nonetheless. In addition, create a common-sized balance sheet and a common-sized income statementthat includes all items found on the balance sheet and income statement, respectively.Round the percentages to one decimal place (e.g., 11.6%). Submit your work via the assignment submission feature in Blackboard.
|
Total assets
|
$113,327
|
|
Total liabilities and equity
|
$113,327
|
|
Fixed assets, gross
|
90,105
|
|
Total shareowners' equity
|
66,226
|
|
Net sales
|
$59,387
|
|
Less: Accumulated depreciation
|
53,934
|
|
Total liabilities
|
47,101
|
|
Retained earnings
|
40,747
|
|
Gross profits
|
36,191
|
|
Fixed assets, net
|
36,171
|
|
Total current assets
|
35,508
|
|
Common stock and paid-in capital
|
25,373
|
|
Less: Cost of goods sold
|
23,196
|
|
Long-term debt
|
20,649
|
|
Total current liabilities
|
20,302
|
|
Less: Selling, general and administrative expenses
|
17,051
|
|
Goodwill
|
14,099
|
|
Earnings before taxes
|
12,936
|
|
Operating profit (Earnings before interest and taxes)
|
12,874
|
|
Short-term investments
|
11,539
|
|
Other long-term investments
|
10,896
|
|
Net income
|
$10,316
|
|
Other intangible assets, net
|
9,494
|
|
Other noncurrent assets
|
7,159
|
|
Less: Depreciation and amortization expenses
|
6,266
|
|
Cash and cash equivalents
|
$5,560
|
|
Inventories
|
5,553
|
|
Other current liabilities
|
5,280
|
|
Other current assets
|
5,210
|
|
Accounts receivable, gross
|
4,727
|
|
Accounts receivable, net
|
4,690
|
|
Current maturities of long-term debt
|
4,634
|
|
Accrued liabilities
|
4,275
|
|
Other long-term liabilities
|
3,735
|
|
Prepaid expenses
|
2,956
|
|
Less: Income tax expense
|
2,620
|
|
Accounts payable
|
2,475
|
|
Short-term debt
|
1,920
|
|
Deferred taxes
|
1,730
|
|
Deferred revenues
|
1,718
|
|
Postretirement benefit obligations
|
685
|
|
Interest and other non-operating income
|
506
|
|
Less: Interest expense
|
444
|
|
Accumulated other comprehensive gain (loss)
|
106
|
|
Less: Allowance for doubtful accounts
|
37
|
|
Less: Treasury stock
|
0
|
|
Commitments and contingent liabilities
|
|
Attachment:- Assignment Files.rar