Question
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
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). The company is PUBLIX SUPERMARKET Ratio analysis for the ratios shown on Table 1 in the Guide to Case Analysis (CA) of the textbook: Profitability ratios Liquidity ratios Leverage ratios Activity ratios Price-to-earnings ratio The changes between years are included in the calculations. 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. Financial analysis should include comparisons to the firms 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 firms 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. PLSSS HELP ME IM SO STUCK ON THIS ASSIGNMENT
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started