This Portfolio Project Has Two Parts Calculations Due This Week And A Choose a publicly traded company and perform an expanded analysis on the financial statements. Use the most current 10K statements available on SEC or annual statements in Yahoo Finance. Complete the following for your chosen firm in an Excel spreadsheet: Horizontal and vertical analysis of the income statements for the past three years (all yearly balances set as a percentage of total revenues for that year). Horizontal and vertical analysis of the balance sheets for the past three years (all yearly balances set as a percentage of total assets for that year). Ratio analysis (eight ratios of your choosing) for the past three years PLUS a measurement for the creditworthiness of your firm as measured by Altman’s Z-score. Compare your firm’s ratios to industry-average ratios or current-year competitor ratios for meaningful analysis. Review this video: Demonstration of Vertical/Horizontal Analysis using Excel, which demonstrates the completion of vertical and horizontal analysis on Nike using Excel. Be prepared to discuss how changes in sales, assets, and ratios reflect management effectiveness, operational efficiency, or potential concerns that may require further research or explanation.
Paper For Above instruction The purpose of this project is to develop a comprehensive financial analysis of a publicly traded company through horizontal, vertical, and ratio analyses, culminating in an interpretive report that examines trends, financial health, and operational efficiency over three years. This exercise provides insight into financial statement interpretation, ratios, and overall corporate performance, with particular emphasis on the importance of benchmarking against industry and competitor data. The first step in this analysis is selecting a publicly traded company, ideally one with available and recent financial statements on the SEC or Yahoo Finance. These financial statements serve as the foundation for further analysis. Using Excel, I conducted horizontal and vertical analyses of the income statements and balance sheets for the past three years. Horizontal analysis involves calculating the percentage change in financial statement items year-over-year, highlighting trends such as increasing sales, cost controls, or anomalies. Vertical analysis contextualizes each item as a percentage of total revenue or assets, revealing structural changes or deviations from typical industry patterns. In analyzing the income statement, a key focus was the relationship between sales growth and net income margins. For example, a 20% increase in sales accompanied by a proportionate or greater increase in net income suggests effective cost management and operational efficiency. Conversely, if sales increase by