Assignment: Financial Analysis
Activity Context
This assignment helps you develop the skills to master the following course competencies:
• Apply the theories, models, and practices of finance to the financial management of the firm.
• Integrate financial analyses into general business management planning and decision making.
• Communicate in a manner that is professional and consistent with expectations for members of the business professions.
Activity Instruction
For this assignment, you will complete the Financial Analysis component of your course project. To complete this assignment, use the Financial Analysis Toolkit Excel file you have been working in previously.
Complete a financial analysis of your chosen company over the two most recent years, using the company's 10-K or annual reports. Replace the financial ratios provided in the Excel file with the appropriate financial ratios from MSN Money.
Write a 4-6 page financial analysis of your company, addressing the following elements:
• Identify your company, its industry, and analyze the important segments (percentage of sales or subsidiaries) of your company compared to its industry and its overall business.
• Perform a complete financial analysis of your chosen company's financial statements-horizontal, vertical (percentage of sales and common-size), and changes in ratios-for the last two years.
o Compare all ratios to industry averages.
o Evaluate the company's ratios against the industry averages.
o Explain the significance of the company's ratios when compared to industry averages.
• Analyze the company's cash flows.
• Assess the overall financial health of your company based on this financial analysis.
A great way to integrate your completed calculations from your Excel sheet into your written analysis is to copy and paste pieces of the worksheet directly into your Word document. You are also encouraged to create graphs or charts from the data that may illustrate your analyses.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Financial-Analysis-Toolkit.rar