Information
Raven814u
w5-donald_taylor.xlsxCover Sheet
| ACC380 - Accounting for Not-for-Profit Organization (Ashford University) Copley 12th edition | ||
| **Your Name: | <----- Enter your name here. Fail to do so will cause you to loss at least 20% of the available points. | |
| ** You MUST include your name in the cell where it said **Your Name:" | You must use the following template when submitting your assignment. You need to fill in the missing appropriate data. | |
| If you failed to include your name or use the Excel spreadsheet there will be a minimum of 20% point deduction on the total points available this assignment. | If you do not submit your homework assignment using this Excel template you will loss at least 20% of the available points. | |
| Template for student on W5-Homework. You can fill in answer. I may have given some answer to get you started. | ||
| NOTE: This is NOT all the homework assignment, so you need to insert your answer to those which are assigned but without a template. | ||
| Do keep your answer to a manageable word count when answering question. You are NOT asked to write an essay as your answer. | ||
| Save your file as: | ||
| W5-Your first name-Your last name such as | ||
| W5-Rick-Kwan | ||
| W means week | ||
| Stduents are responsible to verify that they have completed all the assigned homework according to the syllabus. | ||
| Some of the homework may not have a tab or template included. | ||
| For this final paper you are to submit (1) the written paper in Word format to answer the requirements as stated in the syllabus and, | ||
| (2) include the completed Excel spreadsheet, using this template. | ||
| Fail to do so will cause you to loss at least 20% of the available points. |
P11-8A
| 11-8 (A) | ||||
| Lee College | ||||
| Statement of Activities | ||||
| For the year ended December 31, 2015 | ||||
| REVENUES | Unrestricted | Temporarily Restricted | Permanently Restricted | Total |
| Net Tuition and Fees | $ 10,625,000 | $ 10,625,000 | ||
| Contributions | $ 100,000 | $ 1,500,000 | $ 2,540,000 | $ 4,140,000 |
| Unrestricted Income on Endowments | $ 40,000 | $ 40,000 | ||
| Sales and Services of Auxiliary Enterprises | $ 5,500,000 | $ 5,500,000 | ||
| Grant Revenue | $ 970,000 | $ 970,000 | ||
| Gains on Long-term In vestments | $ 750,000 | $ 750,000 | ||
| Net Assets Released from Restriction | ||||
| Satisfaction of plant acquisition restriction | $ 1,080,000 | $ (1,080,000) | $ - | |
| Satisfaction of program restrictions | $ 720,000 | $ (720,000) | $ - | |
| Total Revenues | $ 18,065,000 | $ 670,000 | $ 3,290,000 | $ 22,025,000 |
| EXPENSES | ||||
| Instruction expenses | $ 7,000,000 | $ 7,000,000 | ||
| Research expenses | $ 4,500,000 | $ 4,500,000 | ||
| Public Service expense | $ 1,200,000 | $ 1,200,000 | ||
| Auxiliary enterprises | $ 3,725,000 | $ 3,725,000 | ||
| Student Services | $ 150,000 | $ 150,000 | ||
| Institutional support | $ 1,600,000 | $ 1,600,000 | ||
| Total Expenses | $ 18,175,000 | $ 18,175,000 | ||
| Increase (Decrease) in Net Assets | $ (110,000) | $ 670,000 | $ 3,290,000 | $ 3,850,000 |
| Net Assets January 1 | $ 1,000,000 | $ 300,000 | $ 1,760,000 | $ 3,060,000 |
| Net Assets December 31 | $ 890,000 | $ 970,000 | $ 5,050,000 | $ 6,910,000 |
P11-8B
| 11-8 (B). | |
| LEE COLLEGE | |
| STATEMENT OF UNRESTRICTED REVENUES, EXPENSES AND | |
| OTHER CHANGES IN UNRESTRICTED NET ASSETS | |
| YEAR ENDED JUNE 30, 2015 | |
| Unrestricted Revenues: | |
| Net Tuition and Fees | $10,625,000 |
| Contributions | 100,000 |
| Unrestricted Income on Endowments | 40,000 |
| Sales and Services of Auxiliary Enterprises | 5,500,000 |
| Total Revenues | 16,265,000 |
| Net Assets Released From Restrictions: | |
| Satisfaction of Program Restrictions | 720,000 |
| Satisfaction of Plant Acquisition Restrictions | 1,080,000 |
| Total Net Assets Released From Restrictions | 1,800,000 |
| Total Unrestricted Revenues and Other Support | 18,065,000 |
| Expenses and Losses: | |
| Educational and General: | |
| Instruction | 7,000,000 |
| Research | 4,500,000 |
| Public Service | 1,200,000 |
| Student Services | 150,000 |
| Institutional Support | 1,600,000 |
| Total Educational and General Expenses | 14,450,000 |
| Auxiliary Enterprises | 3,725,000 |
| Total Expenses | 18,175,000 |
| Increase (Decrease) in Unrestricted Net Assets | ($110,000) |
P11-8C
| 11-8 (C). | |
| LEE COLLEGE | |
| STATEMENT OF CHANGES IN NET ASSETS | |
| YEAR ENDED JUNE 30, 2015 | |
| Total Unrestricted Revenues | $16,265,000 |
| Net Assets released from restriction | 1,800,000 |
| Total Unrestricted Expenses and Losses | (18,175,000) |
| Increase (Decrease) in Unrestricted Net Assets | (110,000) |
| Temporarily Restricted Net Assets: | |
| Contributions | 1,500,000 |
| Grant Income | 970,000 |
| Net Assets Released From Restrictions | (1,800,000) |
| Increase in Temporarily Restricted Net Assets | 670,000 |
| Permanently Restricted Net Assets: | |
| Contributions | 2,540,000 |
| Gains on Long Term Investments | 750,000 |
| - | |
| Increase in Temporarily Restricted Net Assets | 3,290,000 |
| Increase in Net Assets | 3,850,000 |
| Net Assets, July 1, 2014 | 3,060,000 |
| Net Assets, July 30, 2015 | $6,910,000 |
