Did you find the information provided above useful?

I‌‍‍‍‌‍‍‌‌‌‍‌‍‍‍‍‌‍‌‌ntroduction: Prepare an Excel spreadsheet, using this template, in which you analyze key elements of the company’s financial results from their last two full fiscal years along with headcount changes. In this, you will evaluate and explain the key changes in the company’s most recent annual Income Statements and Balance Sheets over the past two years and document company employee headcount changes. Please note that most of these figures will be in the billions or, possibly, millions. All numbers should be expressed as complete numbers; for our companies, this is likely in billions and the statements will report in millions; read more about rounding. Content Expected: 1) Income Statement: A. Present the following figures, in spreadsheet format, for the most recent two years: revenue, expenses, and net profit. Use Excel calculations to calculate the percent change year over year for each figure. B. In a few sentences, evaluate and explain the key changes in the company’s most recent annual Income Statement over the past two years, focusing on changes in the Profit section. 2) Balan‌‍‍‍‌‍‍‌‌‌‍‌‍‍‍‍‌‍‌‌ce Sheet: A. Present the following figures, in spreadsheet format, for the most recent two years: total assets, total liabilities, and stockholder’s equity. Use Excel calculations to calculate the percent change year over year for each figure. B. In a few sentences, evaluate and explain the key changes in the company’s most recent annual Balance Sheet over the past two years, focusing on change in the Equity section. 3) Headcount: A. Present the following figures, in spreadsheet format, for the most recent two years: total headcount and US headcount. Use Excel calculations to calculate the percent change year over year for each figure. B. In a few sentences, evaluate and explain why these figures are changing based on company research and your understanding of the overall state of the firm. Were there internal or external forces driving this change? 4) Feedback: How was your experience in preparing and researching the company you choose for this assignment? Did you find the information provided above useful? What resources did you find most helpful? What areas did you strug‌‍‍‍‌‍‍‌‌‌‍‌‍‍‍‍‌‍‌‌gle with?

Last Completed Projects