Create balance sheet or income statement horizontal analysis

Assignment Help Microeconomics

Reference no: EM132671127

Assignment: Assume the role of a senior financial analyst who has been assigned to complete a thorough and detailed review for a company of your choice from the list below. Access the company quarterly financial statements (10-Q) for the past two quarters on EDGAR, which is available on the web page, EDGAR Company Filings.

Select one of the following companies.

Name

Ulta

In your thorough and detailed review, analyze the company's quarterly financial statements (10-Q) for the past two most current quarters and perform the following:

1. Prepare a balance sheet and income statement horizontal analysis for the last two quarters.

2. Prepare a balance sheet and income statement vertical analysis for the last two quarters.

3. Prepare a liquidity analysis by computing and using the appropriate ratios to assess liquidity.

• Compute a minimum of three ratios and show your supporting calculations.

4. Prepare a solvency analysis by computing and using the appropriate ratios to assess solvency.

• Compute a minimum of three ratios and show your supporting calculations.

5. Prepare a profitability analysis by computing and using the appropriate ratios to assess profitability.

• Compute a minimum of three ratios and show your supporting calculations.

6. Analyze the methods and tips provided in the textbook, Warren Buffet Accounting, to address the following questions:

• What is your company's primary revenue, secondary revenue, and gains?

• What is your company's primary expenses, secondary expenses, financial activity generated expenses, and losses?

• What is the revenue trend? Does the 10-K or 10-Q discuss primary revenues, as well as other revenue types?

• What do the accounting policies say in the annual report (footnotes) regarding the cost of revenue? What are the drivers to the cost of revenue and the trends?

• Are there any trends in sales and marketing expenses or research and development? Are these amounts reasonable for the type of business?

• Compare general and administrative expenses to similar companies. Are they reasonable?

• What is the ratio of net interest income (expense) to income from operations? Is this a safe ratio for the company? Why or why not?

• What is the income taxes trend? Is the effective tax rate reasonable over time?

Formulate your analysis on the above requirements to discuss the financial health, performance, strengths, and weaknesses of the company, as well as any identified positive or negative trends.

In addition to your written financial statement analysis, you will also need to communicate a high-level summary of your analysis to your selected company's executive team using Screencast-O-Matic. If needed, review the Screencast-O-Matic Quick-Start Guide. The summary should be documented with three to five PowerPoint slides, including speaker notes. In addition, include the company's

• financial health,

• performance strengths and weaknesses, and

• identified positive or negative trends.

Reference no: EM132671127

Questions Cloud

Entering the network marketplace constantly : Network protocols. Many network protocols have been used, and new protocols are entering the network marketplace constantly.

What economic problems were the mercantilists interested : What economic problems were the mercantilists interested in solving and for whose benefit? How do those compare with the problems addressed by the Scholastics?

Discuss configuration considerations for installation : Discuss configuration considerations for installation of these components and protocols.

What will be the percent be sales change : Wholesale price $40.00 per unit, If ABC's price is reduced by 10% and if ABC's variable costs reduce by 10%, what will be the %BE sales change?

Create balance sheet or income statement horizontal analysis : Prepare a balance sheet and income statement horizontal analysis for the last two quarters. Prepare a balance sheet and income statement vertical analysis for.

How would managers of the company use the standard costs : How would the company go about setting standards for product? What types of standards would be included? How would managers of the company use the standard cost

The key processes for health-care organizations : What might be the key processes for health-care organizations? What special causes might be more important than the others?

How do demonstrate the total materials variance : How do demonstrate the total materials variance and round to the nearest whole dollar. Enter a favorable variance as a negative number.

Explain general theory of justice in economic distribution : "Many contemporary philosophers disagree...they believe that we should...seek some general theory of justice in economic distribution, on the basis of which.

User Account

All Pages