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.
0 likes · 16 views · Mar 19, 2024
Constructed a three way forecast model for a S&P 500 company based on three scenarios.
