ACC 322 Final Project Two Case Study

ACC 322 Final Project Two Case Study

Author: willi padro


For Final Project Two, you will use the Final Project Two Student Workbook Excel spreadsheet provided for you
If you would like a refresher course on using various features of Excel, sign in to Atomic Learning and type “Excel” in the search box. This will provide you with options to select the specific level of training that you need (i.e., intro, intermediate, or advanced) and the specific version of Excel that you have (i.e., 2011, 2013, etc.). The trainings are broken down into small, meaningful chunks. Therefore, you should be able to find specific topics at each level that will meet your needs
SPARK Organization
SPARK was incorporated as a nonprofit voluntary health and welfare organization on January 1, 2015. During the fiscal year ended December 31, 2015, the following transactions occurred:
1. A business donated rent-free office space to the organization that would normally rent for $16,000 a year.
2. A fund drive raised $120,000 in cash. A state government grant of $50,000 was received for program operating costs.
3. An administrator was hired to administer the program services and support services of the organization. The administrator was paid $92,000 for the year, which included fringe benefits. Part-time clerical help was paid $26,000 for the year. At year-end, $18,000 of the salaries and wages remained unpaid.
4. Pledges of $100,000 were received for construction of a new building. The pledges are payable over the following five fiscal years. The discounted value of the $80,000 in pledges expected to be received in years 2016–2019 is $73,400.
5. Office equipment was purchased for $5,000. The useful life of the equipment is estimated to be five years. Office furniture with a fair value of $7,600 was donated by a local office supply company. The furniture has an estimated useful life of 10 years. Furniture and equipment are considered unrestricted net assets by SOLVE.
6. Telephone expense for the year was $5,600, printing and postage expense was $10,000 for the year, and supplies expense was $2,100 for the year. At year-end, an immaterial amount of supplies remained on hand and the balance in accounts payable was $3,800.
7. Volunteers contributed $15,000 of time to help with answering the phones, mailing materials, and various other clerical activities.
8. It is estimated that all of the pledges made for the 2015 year will be collected. Depreciation expense is recorded for the full year on the assets recorded in item 5.
9. Expenses were allocated in the following percentages: public health education, 35%; community service, 25%; management and general, 20%; and fundraising, 20%.
10.Net assets were released to reflect satisfaction of state grant requirements that the grant resources be used for program purposes.
11.All nominal accounts were closed to the appropriate net asset accounts.
A. Make all necessary journal entries to record these transactions. Expense transactions should be initially recorded by object classification; in entry 10, expenses will be allocated to functions.
B. Prepare a statement of activities for the year ended December 31, 2014.
C. Prepare a statement of financial position for the year ended December 31, 2014.
D. Prepare a statement of cash flows for the year ended December 31, 2014.
E. Prepare a statement of functional expenses for the year ended December 31, 2014.
This case study is adapted from Problem 13-8 in Reck, J., Lowensohn, S., & Wilson, E. (2013). Accounting for governmental and nonprofit entities (16th ed.). New York, NY: McGraw-Hill/Irwin

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.