Skip to content
BranchesTags

Latest commit

 

History

13 Commits

Folders and files

NameName
Last commit message
Last commit date
Bloomberg data_Source.xlsx
Bloomberg data_Source.xlsx
 
 
P&Ltable.PNG
P&Ltable.PNG
 
 
README.md
README.md
 
 
solution.xlsx
solution.xlsx
 
 
waterfall_grapgh.JPG
waterfall_grapgh.JPG
 
 

Repository files navigation

oie_xVZTXqDKiKbf Case Description

Cleaned and structured raw Bloomberg financial data using advanced Excel functions (VLOOKUP, INDEX-MATCH). Built a P&L summary table with Pivot Tables and created a Waterfall chart to visualize 2023 profit & loss dynamics — delivering a clean, decision-ready report for management.

About

This data is a detailed Bloomberg extraction, outlining financial information over multiple fiscal years from 2016 to 2023. It provides an in-depth view of revenues, segmented by product, brand, and geographic area, along with a breakdown of operating expenses, gross profits, net income, and earnings per share (EPS).

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

Packages

Contributors