Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2) (5 points) Count the number of paid Directors, Officers, and Highly Paid Individuals and total by organization, by year. 3) (10 points) For tax

image text in transcribed
image text in transcribed
2) (5 points) Count the number of paid Directors, Officers, and Highly Paid Individuals and total by organization, by year. 3) (10 points) For tax year 2015 list the five individuals with the highest total compensation. List from highest to lowest compensation. Include the Name, Role, Organization, Tax Year, and each type of compensation and total compensation for each person on the report. Do not include duplicates of people on the report. 4) (8 points) List the Name, Role, Organization, Tax Year, and Other Compensation for individuals that have ONLY Other compensation, sorted by Other Compensation, from high to low. 5) (5 points) Change the title of the column, "Volunteers" to "Reported_Volunteers". 6) (5 points) For the column "Reported Volunteers" change "null" values to zero. 7) (10 points) It might be interesting to look at what the percentage of Community Benefit Expense (CBE) is relative to Total Expenses for the hospitals. For 2014 data, create a new table, that includes information for hospitals that computes a ratio of (Community Benefit Expense Amt / Total Expenses) the report should include the tax year, name of the organization, the CBE Amount, Total Expenses, and the computed ratio. Report the top three and bottom three organizations, based on your new ratio. What are some similarities and differences in those organizations? 8) (12 points) A reporter might think, correctly or incorrectly, that highly compensated CEOs from hospitals are not concerned with their local communities. For 2016, create a report of the hospitals in the database, listing the hospital name, ein, ceo name (and

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan

12th edition

1259918947, 1260091908, 978-1259918940

More Books

Students also viewed these Accounting questions

Question

8. What values do you want others to associate you with?

Answered: 1 week ago