Create a common-sized balance sheet

Assignment Help Accounting Basics
Reference no: EM131595927

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

Reference no: EM131595927

Questions Cloud

What is cobblestone tour after tax cost of debt : What is Cobblestone Tour's after tax cost of debt if the applicable tax rate is 34 percent?
Optimal and intends to maintain it in the future : The management of Blue Thumb Tools believes the firm’s current capital structure is optimal and intends to maintain it in the future.
Discuss the legal significance of each of the communications : Letter posted on November 1, and received by Vestley Co on November 5, from Eddo Products Co: "Please quote us price per tonne of canned mango fruit Grade B".
Explain the evolution of american conservatism : Explain the Evolution of American conservatism and Progressive and conservative views of ‘common good vs individual rights'.
Create a common-sized balance sheet : FINC5333EMBA 2017-18 Homework Assignment. In addition, create a common-sized balance sheet and a common-sized income statementthat includes all items
What is enterprise architecture : How does IT supports business processes and links them together?
Define subsequent events as relate to financial statements : Define subsequent events as they relate to the financial statements. Discuss the need of the auditors to address these events - should they address them
Evaluate japanese policing and investigative agencies : Evaluate Japanese policing and investigative agencies. Were there any areas of the Japanese processes that you thought were better in Japan than United States?
Research events in the history of labor-management relations : Research at least two or three major events in the history of labor-management relations. Based on your research, synthesize the information and formulate.

Reviews

Write a Review

Accounting Basics Questions & Answers

  What does it mean to audit around the computer

How might the senior audit manager or partner on a particular engagement determine how much cost is acceptable to incur in order to test a particular area? Can you think of any lower cost alternatives?

  A day later jim edwards the owner of easy printing a local

the outsourcing opportunitya day later jim edwards the owner of easy printing a local one-room printing operation in

  Nemani corporation is projecting a cash balance of 41785 in

nemani corporation is projecting a cash balance of 41785 in its december 31 2013 balance sheet. nemani schedule of

  Classification of activities

complete the following 5 exercises below in either Excel or a word document (but must be single document).

  Capital balances at the start of the liquidation follow

a partnership is currently holding 400000 in assets and 234000 in liabilities. the partnership is to be liquidatedand

  Prepare a financial statements on a cash basis of accounting

Discuss this statement and provide appropriate Examples to support your argument - Financial statements prepared on a cash basis of accounting may distort the portrayal of financial position and operating results of a business

  How much did he pay if payment was made during the discount

Jackson purchased $500 of goods and received credit terms of 2/10, n/30. How much did he pay if payment was made during the discount period?

  Request to a hotel desk for room reservation

Assuming that a guest sends a request to a hotel desk for room reservation, draw a context diagram. Also consider the restaurant and hotel management in the diagram.

  Premium expense-inventory of premiums

Bonita places a coupon in each box of its product. Customers may send in five coupons and $3-A total of 400,000 boxes of product were sold in 2010. It was estimated that 6% of the coupons would be redeemed.

  Analyze key circumstance that caused impairment of goodwill

As a stakeholder of a company, suggest which financial measurement is most important to current stockholders' net income, or earnings, and comprehensive income. Provide support for your rationale.

  Problem related to consolidation entry

The land originally cost Stark $85,000. Stark reported net income of $200,000, $180,000 and $220,000 for 2009, 2010, and 2011 respectively. Parker sold the land it purchased from Stark in 2009 for $92,000 in 2011. Which of the following will be in..

  Funds to invest at discount rate

A company has unlimited funds to invest at its discount rate. The company should invest in all projects having:

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd