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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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