Background: Tasked with analyzing SSI monthly sales for the past 6 years to track average growth per month. The analysis forecasted potential monthly sales and gave us an understanding of a negative Net Income month.
Action: Crafted an Excel spreadsheet with formulas computing the P & L statements to get a 6 year total and average.
Results: Company was able to use the analysis to test the impact COVID-19 had on monthly sales. Allowed company to forecast monthly sales to prepare for quarterly reports.