How does the financial position of the firm influence

Reference no: EM133646654

Homework: Business and Finance- Case Study- Historical Financial Analysis

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 Homework, the Case Study: Historical Financial Analysis Homework, and the Case Study: Projections, NPV, Compilation Homework.

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

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

C. Reference page (follow current APA guidelines)

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

E. 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

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

A. 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).

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

1. Profitability ratios

2. Liquidity ratios

3. Leverage ratios

4. Activity ratios

5. Price-to-earnings ratio

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

C. 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.

D. 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.

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

For filings that are a year or two old

Go to sec gov website.

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

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

3. 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.

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

5. Newer filings have two button options: Documents and Interactive Data. Select on the next screen, select the appropriate filing or filter by filing type (10-K).

6. 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.

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

1. 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.)

2. 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.

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

4. 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.

5. 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.

Reference no: EM133646654

Questions Cloud

Identify major milestones for your new venture : In this last development week of your business plan, you will identify major milestones for your new venture as well as projections of financial performance.

Adopting digital innovation : What challenges and opportunities have arisen in nursing practice while adopting a digital innovation(Telehealth)?

Develop executive summary to place at beginning of your plan : You will combine all components of your business plan together into one document, and develop an executive summary to place at the beginning of your plan.

How has understanding of four core disciplines proposed : How has your understanding of the four core disciplines proposed by Senge enhanced your perspective on organizational adaptability?

How does the financial position of the firm influence : Financial analysis should include comparisons to the firm's main. How does the financial position of the firm influence the strategic direction of the company?

Draw on theory and empirical evidence in your answer : Identify different aspects of structure in contemporary firms, employee engagement in some contemporary firms and organisational culture in contemporary firms

Create a fictitious case study of someone : PSYC110 Introduction to Psychology, Chamberlain University - elaborate on the assignment to fully address the instruction components

Patient health record : Read the following excerpt from a patient's health record: "Review of Systems: Positive for nausea, but no emesis, otherwise negative.

Explain its relevance when conducting an fba : Explain the following point: It is contingencies that define values, not values that drive the contingencies. Explain its relevance when conducting an FBA.

User Account

All Pages