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
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 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.
FULL INSTRUCTIONS AND GRADING RUBRIC ATTACHED
Criteria Ratings Points
Content and Development
40 to >35 pts
Advanced
Information clearly relates to the main topic. It includes several supporting details and/or examples. All topics are thoroughly addressed and/or all questions are answered. Minimum word count is reached.
35 to >27 pts
Proficient
Information clearly relates to the main topic. No details and/or examples are given. All or most topics are generally but not comprehensively addressed and all or most questions are answered. Minimum word count is reached.
27 to >0 pts
Developing
Assignment is missing key elements; lacks contextual presentation and the central thesis of the project is unclear. Information has little or no relation to the main topic. Topics and/or questions were not addressed satisfactorily. Minimum word count is not reached.
0 pts
Not Present
40 pts
Writing Grading Rubric | BUSI645_B02_202330
Criteria Ratings Points
Depth and Organization
30 to >26 pts
Advanced
The introduction provides sufficient background on the topic and previews major points. Ideas flow in a logical sequence. The structure of the paper is clear and easy to follow. The paper’s organization emphasizes the central theme or purpose. Paragraph transitions are present, logical, and direct the flow of thought throughout the paper. The conclusion logically derives from the paper’s ideas. The conclusion reviews the major points toward the appropriate audience.
26 to >20 pts
Proficient
The introduction provides sufficient background on the topic and previews most major points. Ideas flow in a fairly logical sequence. The structure of the paper is somewhat hard to follow. The paper’s organization does not emphasize the central theme or purpose. Paragraph transitions are mostly present, logical, and direct the flow of thought throughout the paper. Comprehensive conclusion missing.
20 to >0 pts
Developing
The introduction provides sufficient background on the topic and previews one or two major points. Some breaks in logic are present. The structure of the paper is somewhat clear and easy to follow. The paper’s organization emphasizes the central theme or purpose. Paragraph transitions are missing on some sections. The conclusion somewhat derives from the paper’s ideas. The conclusion may not review the major points toward the appropriate audience.
0 pts
Not Present
30 pts
Writing Grading Rubric | BUSI645_B02_202330
Criteria Ratings Points
Grammar/ Punctuation/ Spelling and Formatting
30 to >26 pts
Advanced
Rules of grammar, usage, and punctuation are followed. Spelling is correct. The paper follows APA format guidelines. The paper is written in 12pt font, Times New Roman, double-spaced and 1” margins. The work is original, giving credit to all borrowed ideas.
26 to >20 pts
Proficient
Rules of grammar, usage, and punctuation are generally followed but some mistakes are evident. Spelling is correct. The paper follows APA format guidelines but with some mistakes. The paper is written in 12pt font, Times New Roman, double-spaced and 1” margins. The work is original, giving credit to all borrowed ideas.
20 to >0 pts
Developing
Rules of grammar, usage, and punctuation are generally followed but many mistakes are evident. Spelling is incorrect in places. The paper fails to follow APA format guidelines to include: Written in 12pt font, Times New Roman, double- spaced and 1” margins. The work is original, giving credit to all borrowed ideas.
0 pts
Not Present
30 pts
Total Points: 100
Writing Grading Rubric | BUSI645_B02_202330
,
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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
