Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

Need asap

NEED NOW 

BUSI 690

Case Study: Historical Financial Analysis Assignment Instructions

Overview

Complete a case study of ABC Corporation. You will find the case in the case section of the text.

A formal, in-depth case study analysis requires you to utilize the entire strategic management process. Assume you are a consult asked by the ABC Corporation to analyze its external/internal environment and make strategic recommendations. You must include exhibits to support your analysis and recommendations.

Instructions

The completed case study must include these components, with portions to be submitted over several modules as the
Case Study: Matrices Assignment, the
Case Study: Historical Financial Analysis Assignment, and the
Case Study: Projections, NPV, Compilation Assignment.

· Cover page (must include the company name, your name, the date of submission, and a references page; the document must follow current APA guidelines)

· A total of 12 – 15 pages (for all three parts, combined) of narrative text, this does not include the financial statements, reference pages, or matrices

· Reference page (follow current APA guidelines)

· Historical Financial Statements, Proforma Financial Statements, NPV Calculations and a Cost Sheet for the strategy in an Excel document

· Matrices, which must be exhibits/attachments in the appendix and not part of the body of the analysis (The Strategy Club has excellent templates/examples for exhibits and matrices).

Your
Case Study: Historical Financial Analysis Assignment paper must include:

1. Historical Financial Statements (Income Statement, Balance Sheet and Statement of Cash Flows) from the 3 most current years for the firm. These should be downloaded from the SEC website. The financial statements must include horizontal (shown between the years) and vertical analysis (shown to the right of the last year of historical data).

2. Ratio analysis for the ratios shown on Table 1 in the Guide to Case Analysis (CA) of the textbook:

a. Profitability ratios

b. Liquidity ratios

c. Leverage ratios

d. Activity ratios

e. Price-to-earnings ratio

f. The changes between years are included in the calculations.

3. Competitor ratios to compare with the ratios that were calculated in item 2. These should be included on the same tab as the ratio analysis for the firm.

4. Financial analysis should include comparisons to the firm’s main competitor as well as to the industry. How does the financial position of the firm influence the strategic direction of the company? This section should not be used to define what each ratio is rather it should clearly provide analysis based on the calculations as to the strategic choices and implications of the firm’s financial position. A compare and contrast with the main competitor should be included in this section of narrative.

Place the results of Case Study: Historical Financial Analysis, in the Case Study: Historical Financial Analysis submission link in Module 6: Week 6.

Options to Download SEC Financial Data into Excel Spreadsheets:

There are two ways to pull financial data in Excel format from the SEC site, depending on how recent the information is.

OPTION 1: For filings that are a year or two old

· Go to
www.sec.gov.

· In the Filings & Forms box, click on
Search for Company Filings.

· Then click on
Company or fund name, ticker symbol, CIK (Central Index Key), file number, state, country, or SIC (Standard Industrial Classification).

· Enter either a company name or ticker symbol into the appropriate box. (Note: it may be easier to use a ticker symbol because this guarantees you have the right company.) Choose
Find Companies.

· On the next screen, select the appropriate filing or filter by filing type (10-K).

· Newer filings have two button options:
Documents and
Interactive Data. Select
Interactive Data if that is an option.

· Once in Interactive Data, select financial statements. A drop-down box will appear in the left-hand column. Select the statement that you want. Then, click
View Excel Document above the left-hand column.

·


OPTION 2: For older filings

· Follow the steps in Option 1 to get to the company filing screen. Since
Interactive Data will not be available, click on
Documents.

· There will be several options. Find the link containing the full filing. This is usually the first link but not always. For a 10-K filing look for a link titled
10-K.

· Open Excel. Click on the
Data tab in the ribbon and select
From Web, the second icon from the left.

· A web browser will open up. Copy the link from the company 10-K and insert it into the
New Web Query browser that opened up. Click
Go to be taken to the filing. (Note: The browser sometimes runs slow.)

· Find the financial tables you wish to import. Above the tables you should see a yellow box with a black arrow pointing to the right. Click on each box corresponding with each financial table that you wish to import. The box will turn green with a check mark.

· Once all desired tables are selected, click the
Import button at the bottom right of the web browser.

· You will be taken back into the Excel spreadsheet with an
Import Data box open. To import the data, select either a cell in the existing worksheet or
New Worksheet and click
OK.

· Data will be uploaded into Excel.
Note that this process does a poor job of formatting the tables. Brackets indicating negativity and currency symbols are often placed in adjacent cells, necessitating manual entry. For year-over-year analysis across multiple filings be careful to ensure that financial sheet items line up with one another.

Page 2 of 6

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image1.png

image2.png

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Order Now

Related Questions

Dummy post- Tax Admin

1. How is the current tax administration in the Turks and Caicos Islands structured, and what challenges or limitations have you observed in its ability to ensure compliance and effective revenue collection? Function-based Organizational Model -functional areas – 1. Taxpayer Services and Business Licenses- 2. Audit and Investigations 3. Compliance

Unit IV Ass

see attached Assignment Objective: For this assignment, you will research and compare international and U.S. accounting standards. This will enable you to see how the different reporting methods affect business and how product costs are affected by international business. In the assignment you will do the following: 1. Compare and

ACCt105

see attached Instructions Complete the Budget in a Service Company (Cash Budget) assignment.   Please use the template provided below. The document must have the complete budget and show the entire process along with an explanation. Add a brief explanation of the budget just like what you should do if you

Balik and Kiefer Inc

   Assume that you recently graduated and have just reported on working as an investment advisor at the brokerage firm of Balik and Kiefer Inc. One of the firm’s clients is Michelle DellaTorre, a professional tennis player who has just come to the United States from Chile. DellaTorre is a

Questions

Just need a brief answers to prepare for my proposal defense  Last Updated: Jul 1, 2025 11:01 AM URL:  Print Page Staff Login Report a problem Dissertation Center / Dissertation Defense / Example Defense Questions Dissertation Defense Dissertation Defense: Home Preparing for the Defense Example Defense Questions Consider These

Motivation a driving force for goals achievement

Please see attachment for assignment reference and instruction. BMAL 703 Motivation Theory Assignment Instructions Overview Since motivation is a major determinate of a person’s persistence toward achieving a goal, it is important to examine how managers can use motivation to attain organizational goals. There are various theories to help managers

Conscious Capitalism and Christian Worldview

     Describe how the concept of Conscious Capitalism aligns with Christian worldview principles; and demonstrates the importance of corporate social responsibility to the parent company’s board of directors. Instructor Tips: Include 1 short paragraph (3 to 5 sentences / bullets) for each of the 2 parts of the question:  

lFG-1

please review BUSI 606 Discussion Assignment Instructions The Discussions allow you the opportunity to apply what you have learned from the Module: Week’s readings. There are 2 parts to each Discussion: thread and replies. Both parts must be posted and written in a substantive manner, without spelling and grammatical errors

Business Finance – Operations Management week 8 assignment

4-5 page explore the leader within. You will be applying your own leadership skills to a real world scenario within the U.S. Marine Corps. Go to and click on the Command and Leadership module. What would you do as a leader based on one of the case studies from the

Week 8 discussion

 What is the difference between the forces for change and planned change?How can organizations overcome resistance to change? How can managers create a culture for change? 

Business Finance – Accounting homework

see attached Use this reference for first 2 questions. Williams, J., Bettner, M., & Smith, K. (2023). Financial & Managerial Accounting (eBook with Connect access). New York, NY: McGraw-Hill Education. Homework 1, 1 page with 2 references: Review the provisions of the Sarbanes-Oxley Act of 2002 to address the accounting

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

Discussion & Respond Week 8 (No more than 200-250 words) Research  Research marketing plans(attached) and controls for success. Review information on your final paper topic and the industry it is in.   Discuss · What were the challenges and triumphs you encountered while writing your marketing plan? · What would

Audit

Turks and Caicos Islands Community college Auditing (ACCT4702) Coursework #1 (Professionalism and Ethics – Unit 3) Weight: 10% Due Date: October 22, 2025 Question 1 The following are situations that may violate the Code of Professional Conduct. Assume, in each case, that the CPA is a partner. Discuss whether the

How Do Federal Health Agencies Help?

Choose a federal healthcare agency (e.g., CDC, FDA, NIH) and discuss briefly how it promotes or contributes to public health. Then, picture yourself as a manager at the agency. What managerial function that you have been introduced to would you use to promote one of its missions? Why? Support your

Business & Finance Module 7-1 Assignment

I have completed majority of the assignment what is needed to be completed is the part of the document that I will attach a screenshot of. That is all that needs to be completed. The rest of the document should not be altered in any way.

HRM 6302 VIII

HRM 6302, Employment Law 1 Course Learning Outcomes for Unit III Upon completion of this unit, students should be able to: 2. Summarize Title VII of the Civil Rights Act of 1964. 2.1 Identify the conduct that constitutes sexual harassment. 2.2 Analyze the protection against sexual harassment under Title VII.

Mid

Instructions attached  Also attached some readings you can use as reference  Your essay should be between 1000 to 1100 words and use citations and a bibliography using MLA. To receive a good grade on your essay, please make use of course materials, readings, video’s etc. Outside research is encouraged but