Purpose: The purpose of this project is to analyze a large set of financial data for the not-for-profit sector. The data comprises the Form 990s filed with the IRS. The link to the raw data file is: https://www.irs.gov/statistics/soi-tax-stats-annual-extract-of-tax-exempt-organization-financial-data

Obtain the most recent dataset year via the link above. This exercise is based on the Form 990 Extract file. You will also need to obtain the Extraction Documentation which provides a basic description of the variables in the dataset. Please note that it may take a few minutes to download the dataset.

Click here for a brief tutorial on Pivot Tables in Excel.

Click here for a brief tutorial on Pivot Table Filters and Charts in Excel.

Part 2 of the project assesses the overall financial condition of the not-for-profit sector. Obtain the 2019 dataset via the following link https://www.irs.gov/statistics/soi-tax-stats-annual-extract-of-tax-exempt-organization-financial-data. The data comprises the 2019 Form 990s filed with the IRS. Required: 1. What are the total revenues and total expenses of the not-for-profit sector? (Enter your answers in dollars.) 2. In Chapter 13, Illustration 137 lists key performance indicators that can be calculated from not-for-profit financial information. Calculate the following performance indicators for the not-for-profit sector as a whole: (Round "months" to the nearest whole number. Round "(Revenues - Expenses)/Expenses" to 1 decimal place and other answers to the nearest whole percentage.)

3. Based on the performance indicators you calculated, overall, how would you assess the financial condition of the not-for-profit sector? 4a. Calculate the performance indicators from item (2) for 501(c)(3) organizations and non 501(c)(3) organizations. (Round "months" to the nearest whole number. Round "(Revenues - Expenses)/Expenses" to 1 decimal place and other answers to the nearest whole percentage.) 4b. How does the financial condition of 501(c)(3) organizations compare with non 501(c)(3) organizations? 5a. Calculate the performance indicators from item (2.) for smaller organizations (under 1 million in total revenue) and larger organizations (1 million or more in total revenue). (Negative amounts should be indicated by a minus sign. Round "months" to the nearest whole number and other answers to the nearest whole percentage.) 5b. How does the financial condition of smaller organizations (under 1 million in total revenue) compare with larger organizations?