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

Journal Article 1

See attachments  BUSI 613 Journal Article Review Assignment Instructions Overview MBA programs around the country are starting to require their students to become more effective writers. This is in response to industry’s urging for grad schools to improve the writing skills of graduate students. Writing at the MBA level should

Prof Double R

 Electronic Health Record  Answer the following questions: What is an EHR? What types of information are found in an EHR? Who manages an EHR? How is it used? Does an EHR follow the patient to other health facilities? Explain.

Microeconomics 6

Assignment in attachment  1. The following graph shows a firm operating in a monopolistically competitive market. How many haircuts will the firm perform in the short term, and at what price? At this point, what will its total revenue, total cost, and total profit be? Given your answers, what would

Microeconomics 7

Assignment in attachment  1. What are the four most important ways a firm becomes a monopoly? Will a monopoly that maximizes profit also be maximizing revenue? Will it be maximizing output? Explain. 2. Assume the graph below represents the market for a monopolist. What quantity will the monopolist produce, and

Microeconomics 2

Assignment in attachment  1. The graph below represents the market for flank steak in a specific town. Calculate the value of consumer surplus: A. When the market price is allowed to prevail, and B. When the town passes a law setting a price ceiling for flank steak of $13 per

MBA 699 4-2 Milestone 2

   1. Current employee demographics: Summarize the current employee demographics for the organization from the course scenario. a. Use Tableau to visualize the demographic data such as age, sex, marital status, education, and experience, and include the corresponding screenshots in your summary. Choose the graphs or charts that are best

HRM 6301 III

1 Three Keys to Success Joshua A. Learner Columbia Southern University LSS 1300: Learning Strategies for Success Dr. John Doe July 10, 2020 SAMPLE FORMAL ESSAY The title page includes the title of the assignment in bold font, the student’s name, the name of the university, the course name, the

ECO 6301 III

2 Economics for Managers ECO 6301 Unit III Essay Unit III Essay This 3-to-5-page essay measures your mastery of ULOs 1.1, 1.2, 2.1, 6.1, 6.2 and 7.1. Elasticity Assignment objective: Unit I introduced the benefits of markets to improving outcomes for producers and consumers. Unit II examined the role of

RCH 5301

2 Research Design and Methods RCH 5301 Unit II DB Describe a quantitative research project you would be interested in starting now or in the near future. Explain the problem and why this would be important for you to study. Why is a quantitative methodology an appropriate research strategy for

Business Finance – Accounting excel assignment

need this excel assignment done by tomorrow at 11:59. need formulas to be put in excel not just the answers Sheet1 Porsche and Mercedes-Benz, both based in Germany, are two of the largest automobile manufacturers in the world. The following information was provided in each company’s 2019 annual report. Porsche

Business Finance – Economics Global economics assignments

see attached READ ENTIRELY!  Assignments Week 2-6 NO AI!!! Week 2: DUE JULY 19 The role of government in the economy is often debated by economists and businesspeople. The debate ranges from having little to no government intervention to having a strong government presence in both business and social settings.

HRM 6301

2 Human Resources Management Methods HRM 6301 Equal employment opportunity and subsequent discrimination are major factors in today’s workplace. For a quick review, you can access the U.S. Equal Employment Opportunity Commission’s  Employees & Job Applicants webpage to review discrimination by type.  Considering the many types of employment discrimination, share which

dbs global economics

See attached DB1 Week 1 DUE JULY 09 Define capitalism and socialism and provide examples of countries that govern using each structure. Discuss why capitalism and socialism are currently spotlighted in U.S. politics giving the pros and cons of each organizational structure. Be specific and give supporting facts, not just

ECO 6301 II

2 Economics for Managers ECO 6301 Unit II This unit’s readings include information on pricing. You are introduced to the shutdown price, using elasticity to determine the effects of price changes, and cost-based pricing. Discuss the importance of considering elasticity in pricing decisions and the danger of relying solely on

Marketing Plan

iMBA Operations Strategy Module Summer 2024 Group Project One submission per group Only include your group name on the submission (points are deducted if individual group member names are included) . Please submit a Microsoft Word document. Limit of 20 pages, excluding title sheet, references, and appendices. 1. Overview of

WK1PR599

SEE ATTACHED 1 6 Peer Response: Cite 2 Scholary authors for each. •    Find at least TWO students whose conclusions bring new levels of understanding to your view on McDonald’s internal performance or conclusions. •    Discuss any major differences where you might disagree. 1Acj. A purpose/mission statement is

23

check f  This file is too large to display.View in new window