Reference no: EM133752677
Case: In your memo, codify your findings and interpretations from the horizontal and vertical analyses and the level of alignment in the company's fiscal management and strategic direction. Include the provided Excel spreadsheet you used to complete your analysis as an attachment to the memo. In this memo, you will:
Review the year-over-year variances contained in the audited Stanford balance sheets and income statements for fiscal years 2015-2018 in the Week 5 Assignment Spreadsheet [XLSX] Download Week 5 Assignment Spreadsheet [XLSX]. You'll be expected to pay particular attention to the negative variances (color-coded in red) that you believe to be potentially the most impactful to Stanford and provide a rationale for that belief.
Hypothesize as to the reasons for the negative variances. Be sure the hypothesis is supported by evidence from the scenario, the balance sheets, and income statements.
Explain the proportional changes in the common size results over the four fiscal year time frame and identify notable changes in the ratios. Also include a hypothesis, supported by a rationale, to suggest why these anomalies may exist.
Identify notable patterns and variances that warrant further investigation and justify both with evidence from the three-year period. Specify the potential consequences of the variances to justify the need to examine these variances further.
Assess whether the vision, mission, and goals of the organization are aligned with its current financial position and provide an explanation of why it does or does not align. Provides specifics from the variance analysis to support the assessment.