Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help doing financial statements for the company Intel Corp. The directions are below, but I am honestly completely lost. I need help with

I need help doing financial statements for the company Intel Corp. The directions are below, but I am honestly completely lost. I need help with how to format my balance sheet, which I have posted what it looks like thus far down below... I don't know how to format my excel sheet... I also am unsure what columns to put formulas to.... Please help.

image text in transcribed

image text in transcribed

Before you start analyzing company, you need to adjust the financial statements. I hope If not, please watch my video and try to fallow it. le database and download the key financial statements namely Balance Sheet, Income Statement, Cash Flow Statement and Statement of that you remember from Please,access Mergent online via thecle database and download the key Please, access Mergent online via the 2 Stockholder Equity for the company assigned to you for the last six years ie from December 2011 to December 2016. Please, download both the "as reported" and "standardize" financial statements and combine them in a single Excel file. Save "as reported" and "standardized" financial statements on separate excel sheets within the same excel file. [While you are there on Mergent, you may want to explore the other infomation that is provided for you to know more about the firm ie its business, the competitors, company synopsis, reports, long term debt...] Familiarize yourself with the company basics. You need to adjust the Income Statement to add Earnings Before Interest, Depreciation & Amortization (EBITDA) as a line item as Depreciation &Amortization is a Finance "non- cash" item and it is usually "buried in either Cost of Goods Sold (or Cost of Sales) or Selling, General, & Administrative Expenses (SG&A) or both. The result will be the Standardized Financials adjusted for EBITDA; break out net interest income into interest expense and . nterest income. Make sure that subtotal and total accounts do add up, and that the accounting relationships are . accurate and correct. Replace all sub-totals and totals with appropriate fornmulas. . Use formulas to calculate the following items on the income statement: Gross Profit, Total Operating Expenses, Income from Continuing Operations, Earnings Before Interest And Taxes, Income Before Tax, Net Income From Contimung Ops, Net Income, Separate out Depreciation Expense from Selling General and Administrative expenses and report it separately Use formulas to calculate the following items on the balance sheet, Total Current Assets, Total Non-Current Assets, Total Assets, Total Current Liabilities, Total Non-Current Assets, Total . Liabilities, Total Stockholder Equity, Total Liabilities & Stockholder Equity .Make sure the cash flow from operating, investing, and financing activities equal the change in cash Make all financial statements readable

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting IFRS Principles

Authors: Ilse Lubbe, Goolam Modack, Shelly Herbert

5th Edition

0190746920, 978-0190746926

More Books

Students also viewed these Accounting questions

Question

6.2 Explain the recruitment process.

Answered: 1 week ago