Answered step by step
Verified Expert Solution
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.
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 readableStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started