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

Discussion Board 3 ( Healthcare Reimbursement)

In your post, compare the characteristics and claims filing processes of private and public payers. What type of ethical issues could arise with personnel during the claims filing processes? Imagine yourself sitting around a conference table with your instructor and classmates. This discussion topic will be similar. It is a

Reading 3

instructions and readings are attached  For section #2 Comparative Insight (7 points) I also attached week 2 reading (Staffing Models)

MATH120

SEE ATTACHMENT  Conditional Probability: What affect does a condition have on the probability?  Let’s compare and find out. Example:   Let’s look at a standard deck of 52 playing cards. No replacement:  What is the probability of getting 2 kings assuming that the first one is not replaced?  (Note:  There are

MGMT496

SEE ATTCHMENT 250-300 WORDS ANSWERING THE FOLLOWING QUESTION This week explain who the potential audience for your e-portfolio will be.  How will you ensure that your e-portfolio is well received by the audience?  What acronyms do you use in your workplace that can cause confusion?  If you are including a

Government and Politics

Details attached.   The role of government in the economy is often debated by economists and businesspeople. 

HRM 6302 Unit V DBR

2 Employment Law HRM 6302 Unit V DB Reply 1 Posts to others should be a minimum of 150 words and use at least one supporting reference. You can use the text for this course as one of the reference sources. Reply to student post below Part I Under the Federal

Fin 6301 Unit VI PPP

2 Corporate Finance ECO 6301 Unit VI PowerPoint Presentation This assignment measures your mastery of ULOs 5.1, 5.2, and 5.3. The purpose of this PowerPoint Presentation is to analyze fundamental aspects of corporate finance management in multinational corporations. You will research a multinational corporation to focus on for the assignment,

gender

 In this summarize, Gallant writes mostly about gender and sex work. How might her ideas be expanded to consider gender in other areas of life?  

Real Estate Evaluation| Neighborhood Analysis

Identify and evaluate the neighborhood within which you live? Create a neighborhood profile using internet links and personal information that will provide some specific data. Draw some inference from this evaluation. Be sure to understand the term neighborhood and what makes this neighborhood different. Is it close to jobs? How

week 3 dicussion Organizational Behavior

 What are the factors that influence our perception? What is the link between perception and decision making? How do individual differences and organizational constraints influence decision making? 

FIN 6301 Unit V DB R1

2 Corporate Finance ECO 6301 Unit V DB Reply 1 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

FIN 6301 Unit V DB R2

2 Corporate Finance ECO 6301 Unit V DB Reply 2 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

discussion and assignment ASSIGNMENT Brand Extension Assignment For this assignment, you are asked to choose an  existing brand and create a  brand extension for that brand. This is not connected to your final paper topic, so you can use any brand, including your final paper topic for this deliverable. Your goal is

Cash Budget

See attached Please complete Excel template provided The goal of this assignment is to demonstrate the process of construction and utilization of a cash budget for a company. The assignment is closely related to Course Objectives #02. For this assignment we consider the monthly cash budget for six months (January

Final Project: Present a Business Plan

   Final Project: Present a Business Plan WHO: You are the entrepreneur, and your job is to present a business plan for your entrepreneurial venture (I was thinking of a truck parking stop).

Deliverable 7 – Strategic Implementation of Quality Initiatives

  Competencies Analyze the history of healthcare quality improvement and how it shapes current and future quality initiatives. Evaluate patient care clinical outcomes using quality improvement principles. Evaluate healthcare quality measures and their use in diverse populations and settings. Apply models of quality improvement to institutional challenges within the healthcare

Week 4 Discussion Response- Account for Managment Decision Making

Account for Management Decision Making Week 4 Learning Resources Costs There are many different types of costs that impact a manager’s decision making. Therefore, it is imperative that managers understand what each type is as well as the ones relevant to a specific decision. In these resources, you will examine