Financial Modelling with Microsoft Excel

Following an analysis on a subset of historical financial data from S&P 500 companies via the New York Stock Exchange.

For the financial analysis I delved into predictive statements for APA, building a two year forecast model based on three scenarios: strong, base, and weak. The model leveraged all Excel concepts such as INDEX, MATCH, VLOOKUP, DATA VALIDATION, Absolute and relative referencing, in addition to the OFFSET function.