Non-Profit - Financial Analysis

Course	Course Name	Professor	Semester / Year
CPSC 531	Advanced Database Management	Tseng-Ching Shen	Spring 2024

Developers:

Name	Email
Erwin Medina	erwinmedina@csu.fullerton.edu
Indrajeet Patwardhan	Indrajeet2002@csu.fullerton.edu

About:

This project focuses on analyzing accessible data from nonprofit organizations and assessing their financial stability. We are focusing on retrieving, cleaning, and visualizing the data while also having a focus on big data.

Getting Started:

• Clone the repository.
  • git clone https://github.com/erwinmedina/NP_FinancialPredictor.git
• Navigate to the project directory on your local machine.
  • cd <project_directory>
• Install all dependencies using Pip (ensure you have Pip installed).
  • pip install -r requirements.txt
• Ask creators for .env file info
• Run the project.
  • python manage.py runserver
• Questions / Concerns?
  • Feel free to email either of us.

Languages / Frameworks:

• Python
  • Pandas (Graphs)
  • Random Forest Regression (ML)
• MongoDB
• Django
• HTML/CSS/Javascript

Images:

Page	Output
Home Page
Organization Detail Page
Predicted Expenses (Example)
Predicted Revenue (Example)
Revenue & Expense Comparison by States

Important Documents:

• Powerpoint - Midterm Presentation
• Powerpoint - Final Presentation
• Word - Final Report
• GuideStar (What we wanted to create)
• API for NonProfit Info - ProPublica

Future Tasks:

• Allow users to type in the name of the company instead of an EIN value.
• Provide a deeper analysis and more insights/comparisons of the graphs.
• Improve the UI.
• Comparison within States charts are a bottleneck. Requires optimization. Maybe cache the information so as not to retrieve the same static info.
• Utilize a GDP Per Capita API to provide a live comparison for the States charts.