Publicly traded company that you would like to analyze

Assignment Help Financial Management

Reference no: EM131868373

For this Excel assignment you will be need to complete the following.

1. Choose a publicly traded company that you would like to analyze.

2. Download the most recent 10-K spreadsheet using the Security and Exchange Commission Website.

3. For this assignment you will be looking at the following financial statements:

Consolidated Statement of Operations (Sometimes called the Consolidated Income statement or Consolidated Statement of Income)

Consolidated Balance Sheets

Possibly Consolidated Statement of Cash Flow

4. Use formulas to create standardized financial statements - also called common size statements.

This is vertical/horizontal analysis

Reference no: EM131868373

Questions Cloud

Determine the accumulated value of fund : Determine the accumulated value of Fund Y at the end of year 10.

Evaluate the influence that corporate social responsibility : This assignment is designed to identify how decisions impact a business. Corporations have an obligation to be ethical at all times.

Explain human resource planning and evidence-based hr : Explain human resource planning and evidence-based HR. How do these concepts help HR in supporting an organization's strategy?

Design of an organization hierarchy of authority : What are the main considerations in deciding on the design of an organization's hierarchy of authority? How does culture shape organizational behavior?

Publicly traded company that you would like to analyze : Choose a publicly traded company that you would like to analyze.

Calculate predetermined overhead application rate of company : Job no. 2077 was completed in January 2002, and there was no work in process at year-end. All jobs produced during 2002 were sold with the exception of Job no.

Impact the performance review process : Define each of the performance issues listed below, and then discuss the issues of each as they impact the performance review process.

Balloon payment be in order to completely pay off the loan : Jesse buys a new house in Santa Barbara, California. How much must the balloon payment be in order to completely pay off the loan?

How would you suggest your friend start retirement planning : Why is investment planning important? How would you suggest your friend start retirement planning? What steps should he/she take to start?

User Account

All Pages