Financial Modelling with Microsoft Excel by Adepeju OladapoFinancial Modelling with Microsoft Excel by Adepeju Oladapo

Financial Modelling with Microsoft Excel

Adepeju Oladapo

Data Modelling Analyst

Financial Analyst

Data Analyst

Microsoft Excel

Analytics

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.