Posted: August 31st, 2022

Prepare an Excel spreadsheet summarizing the following data for each of the 3 or

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Prepare an Excel spreadsheet summarizing the following data for each of the 3 organizations (MAP International, Samaritan’s Purse and Lutheran Services in America.):
Restricted net assets (permanent and temporary);
Total net assets;
Ratio of restricted net assets to total net assets;
Company’s contribution revenue recognition policy, if disclosed;
Two most significant expenses contained in the note disclosures; and
The amount of unconditional promises receivable due in 1 to 5 years from the balance sheet date.
Next, in MS Word, please provide your thoughts, ideas, questions, or commentary on the information you have reviewed for each entity. You could search for news stories regarding the organizations chosen that might help with your analysis or provide other defining information like fraud investigations, tax issues, or other positive or negative details of the organization that might provide some frame of reference for the data in the reports.
Paper Requirements:
Submit your responses to the questions in a 3-4-page written document in MS Word and the MS Excel worksheets as indicated. Label each question clearly.
For written answers, please make sure your responses are well written.
Assignment should follow APA style, according to the CSU Global Writing Center .
Preliminary information already found and references:
Based on the annual report, the total revenue of the three non-for-profit organization may include $894,308,893 for Samaritan’s Purse, $108million for Lutheran Services in America and $588,377,393 for MAP International. The program service expenses for the three is $718,037,500 MAP International, Samaritan’s Purse is $3,008,866 million while Lutheran Services in America has $ 2,691,326. However, the total expenses for the three non-for – profit organization are MAP International for $ 9 million, Samaritan’s Purse is$669,969,794and the Lutheran Services in America has $4,320,137 (Lutheran Services, 2021), Nonprofit Explorer, 2021), and MAP International, 2022).
Calculate The Ratio Of The Program Service Expenses To The Total Expenses
Name of Organization
website where the financial information was found
Total Revenue
Program Service Expenses
Total Expenses Service Ratio
MAP International
https://www.map.org/
$588,377,393
$718,037,500
$ 9 million
79.78%
Samaritan’s Purse
https://projects.propublica.org/nonprofits/organizations/581437002
$894,308,893
$306,826,323
$669,969,794
45.8%
Lutheran Services in America
https://www.lutheranservices.org.au/wp-content/uploads/2021/04/LS1586_Annual-Report-2020-25_SP_F_ER.pdf
$108million
$ 2,691,326
$4,320,137
62.3%
The program service ratio involves:
For MAP International
718,037,500/9000000 = 79.78%
For Samaritan’s Purse
$122,769,842/ 669,969,794= 45.8%
For Lutheran Services in America
2,691,326/ 4,320,137= 62.3%
The non-for-profit organizations encountering a higher program expense ratio are those with higher program service expenses near the total expenditure. The program expenditure for some organizations is higher, which indicates that the expenses incurred on the activities are higher. An organization like Samaritan’s Purse has a lower expense ratio due to the lesser costs in operating its services. However, non-profit organizations have a low ratio of the total expenses to total revenue. The non-for-profit organizations have low expenses compared to their revenue.
References
Lutheran Services (2021). Annual Report 2020. Retrieved On 25TH August 2022 From
https://www.lutheranservices.org.au/wp-content/uploads/2021/04/LS1586_Annual-Report-2020-25_SP_F_ER.pdf (Links to an external site.)
Nonprofit Explorer (2021). SAMARITANS PURSE. Retrieved On 25TH August 2022 From
https://projects.propublica.org/nonprofits/organizations/581437002 (Links to an external site.)
MAP International (2022).
About Us. Retrieved On 25TH August 2022 From
https://www.map.org/

For This or a Similar Paper Click To Order Now