Financial-Analysis-of-New-York-Stock-Exchange-Data

Introduction

This is the first project in my Business Analytics Nanodegree program at Udacity. The purpose of this project is to analyse the Income statement of S&P 500 companies to understand their financial status. This project is divided into three parts

1. Exploratory Analysis of the Data using Visuals
2. Profit and Loss Statement Dashboard
3. Forecast Modelling

Data Source

The dataset was provided by Udacity and a copy of it can be found here

Skills and Concepts demonstrated

• Use of Excel functions such as Xlookup, Index and Match, Unique, Offset
• Excel Name Range
• Data validation
• Financial reporting
• Forecasting Modelling and
• Sensitivity Analysis

Analysis

Exploratory Analysis of the Data using Visuals

Profit and Loss Statement Dashboard

Forecast Modelling

Medium Article

I have explained my approaches to carrying out this project on my medium account. Click here to read the walkthrough.