Question: Complete using MS Excel & Word (You can create in Google Docs and Google Sheets, then save it as an MS Word doc for Google

Complete using MS Excel & Word (You can create in Google Docs and Google Sheets, then save it as an MS Word doc for Google Docs and an Excel sheet from Google Sheets to submit). In this part, you will begin analyzing your companys financial statements. You will begin by preparing horizontal (comparative statements) and vertical (common-size statements) analyses. In the third part, you will be preparing ratio analysis.

There are three parts to this part. The first two parts are to be completed using Microsoft Excel. Be sure to use Excel formulas in the cells where you are making computations. Typing computational results in the cells is not acceptable and will result in zero points. Also, company name must be typed in the left-hand corner or added as a header on ALL pages. If any component is missing it will result in automatic point deductions. The third part is to be completed using Microsoft Word. Bullet statements, outlines, and so forth are not acceptable and will result in zero points. Be sure that you use good grammar, sentence structure, etc. Also make sure that your writing is businesslike and professional. Your answers should be clear, concise, and complete.

I. Using Excel, prepare comparative financial statements (Balance Sheet and Income Statement) for the two most recent years. Round amounts to the nearest one-tenth of a percent.

II. Using Excel, prepare common-size statements (Balance Sheet and Income Statement) for the two most recent years.

III. Comment on your findings from parts I and II.

I choose 2020 Intel company. If work finished please send my email. Thanks :)

Email: patrickjun321 @ google mail. com

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!