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.

%d bloggers like this: