4 Pages + Calculation on excel Make sure to follow the rubric carefully
I have a 4 page assignment for the following, it is due this coming Sunday and I was wondering if you would be able to take this one up? I have not received the feedback from last week’s assignment but I will send it once I have and I will just need this one by 7 pm mountain time on Sunday 5/2 at the latest. Please let me know if you need anything else, it is the same case study as last week as well. đÂ
Deliverables for Case Study: Â Historical Financial Analysis AssignmentÂ
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).Â
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 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.Â