Tech Sector Financial Analysis (2019-2024)

Project Overview

This repository contains a comprehensive financial analysis of the top 5 tech companies (Apple, Microsoft, Nvidia, Google, and Meta) from 2019 to 2023. The project aims to evaluate their financial performance, growth trends, and resilience during the post-pandemic period.

Tools and Technologies Used

• Python
• Pandas
• Pyplot
• Streamlit
• Excel
• OpenBB Terminal

Data Sources

• Yahoo Finance
• SEC Filings
• Annual Reports

Project Structure

1. Data Collection and Preparation:

   • Gathered financial data from reliable sources
   • Used Excel for data cleaning and structuring
   • Utilized Python and Pandas for preliminary data analysis

2. Financial Ratio Analysis:

   • Calculated key financial ratios including liquidity, profitability, and operational efficiency ratios

3. Trend Analysis:

   • Performed time series analysis to identify growth patterns and cyclical trends

4. Comparative Analysis:

   • Benchmarked companies against each other and sector averages

5. Visualization:

   • Created insightful charts and graphs using Pyplot

6. Interactive Dashboard:

   • Developed an interactive Streamlit dashboard for exploring the analysis

Key Findings

Revenue Growth Analysis (2019-2023)

• Detailed analysis of revenue growth trends for each company
• Comparative insights across the tech sector

Profitability Analysis

• Evaluation of net profit margins and other profitability metrics
• Insights into each company's ability to generate profits

Liquidity and Insolvency Analysis

• Assessment of current ratios, quick ratios, and cash ratios
• Analysis of working capital management through cash conversion cycle

Return on Equity (ROE) Analysis

• Comprehensive review of ROE trends for each company
• Insights into efficient use of shareholder equity

Interactive Streamlit Dashboard

Explore our analysis through an interactive dashboard: Launch Streamlit Dashboard

How to Use This Repository

1. Clone the repository:

   git clone https://github.com/yourusername/tech-sector-financial-analysis.git
   

2. Install required dependencies:

   pip install -r requirements.txt
   

3. Navigate through the Jupyter notebooks for detailed analysis
4. Run the Streamlit app locally:

   streamlit run app.py
   

Contributing

We welcome contributions to this project. Please feel free to submit a Pull Request.

License

This project is licensed under the MIT License - see the LICENSE.md file for details.

Acknowledgments

• Data providers: Yahoo Finance, SEC
• OpenBB Terminal for additional data retrieval capabilities
• Streamlit for enabling interactive data visualization