Question: can i get some help please . please show the workings if you can please . Thank you Overview: The nonprofit that you established has

can i get some help please . please show the workings if you can please . Thank you Overview: The nonprofit that you established has just completed its second year
of operations. In the Final Project Workbook you will find six tabs
at the bottom. You will use the Trial Balance tab to prepare
the Financial Reports (Statement of Financial Position, Statement of Activities, and Statement

Overview: The nonprofit that you established has just completed its second year of operations. In the Final Project Workbook you will find six tabs at the bottom. You will use the Trial Balance tab to prepare the Financial Reports (Statement of Financial Position, Statement of Activities, and Statement of Cash Flows) for your nonprofit. The information in each step relates to the financial activity for your nonprofit during the second year of operations. Remember to save your work in your Excel workbook as you will need to populate the Budget and Financial Analysis tabs and make any revisions based on feedback from your instructor in your final project due in Module Seven. For Milestone Two, you will leave those two tabs blank. Use the information in the Trial Balance tab to prepare the following financial statements: 1. Statement of Financial Position You will use the data provided in the Trial Balance tab to complete this statement. 2. Statement of Activities In addition to the information provided from the Trial Balance tab, use the following information about your nonprofit to prepare the Statement of Activities. a. Salaries and Fringe Benefit Expenses were allocated to Program Services and Supporting Expenses in the following percentages: i. Program 1: 40% ii. Program 2: 20% iii. Program 3: 10% iv. Management and General: 20% v. Fund-Raising: 10% b. Rent and Utility, Supplies, Printing and Publishing, and Telephone and Postage Expenses were allocated in the same manner as Salaries and Fringe Benefit Expenses. c. Depreciation Expense was divided equally to each functional expense category. 3. Statement of Cash Flows In addition to the information provided from the Trial Balance tab and the information you have the prepared in the Statement of Financial Position and Statement of Activities, use the following information to prepare the Statement of Cash Flows. a. Your organization had $163,314 of cash on hand at the beginning of the year. b. During the year, your organization received cash from contributors: $340,800 that was unrestricted and $38,100 that was restricted for the purchase of equipment for the center. c. It had $11,200 of income earned and received on long-term investments. d. The organization spent cash of $288,410 on salaries and fringe benefits, $22,000 on the purchase of equipment, and $86,504 for operating expenses. e. Other pertinent information follows: net pledges receivable increased $6,000, inventory increased $1,000, accounts payable decreased $102,594, and there were no salaries payable at the beginning of the year.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!