The following information applies to the questions displayed below.] 

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: Financial Analysis of the Sector 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.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?

Answer rating: 100% (QA)

Total Revenues and Total Expenses To find the total revenues and total expenses of the notforprofit ... View the full answer