Bookmarks Profiles Tab Window Help -1 Final Project Mi X D21 Milestone Two Guid X SACC...

Transcribed Image Text:

Bookmarks Profiles Tab Window Help -1 Final Project Mi X D21 Milestone Two Guid X SACC 325 Milestone X forced/1372719-ACC-325-Q1941-OL-TRAD-UG.23EW1/Course%20Files/ACC%2032... ome Workbo... paraphraser icon 1 / 2 | - 97% + | @ ACC 325 Milestone Two Final Project Workbook Instructions 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. OCT 16 |- C I need help with my x + 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. c. 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. v. Fund-Raising: 10% Management and General: 20% 6 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. 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. BO tv N MacBook Air 9 I l A M < : X 2 History 0 D2L 5-1 Final Project Mi X Bookmarks Profiles Tab Window Help /content/enforced/1372719-ACC-325-Q1941-OL-TRAD-UG.23EW1/Course%20Files/ACC%2032... Final Project Workbo... SNHU Home 3 E C 80 F3 paraphraser icon 1 / 2 | - $ 4 D2L Milestone Two Guic x Use the information in the Trial Balance tab to prepare the following financial statements: OCT 16 1. Statement of Financial Position You will use the data provided in the Trial Balance tab to complete this statement. Q F4 R 97% 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. e. + i. Program 1: 40% ii. Program 2: 20% iii. Program 3: 10% iv. v. Fund-Raising: 10% a. Salaries and Fringe Benefit Expenses were allocated to Program Services and Supporting Expenses in the following percentages: 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. do L H % ACC 325 Milestone X CI need help with my X x | + 5 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. Management and General: 20% 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. 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. F5 T 6 atv MacBook Air c F6 Y & 7 2 F7 G U 1 all Z A * 8 DII F8 1 5 : - S 9 F9 M 0 O : B I Project Workbook V Activities F10 X E View P %* Number F W Automate a Statement of C E F11 G Bookmarks Profiles Tab Window Help -1 Final Project Mi X D21 Milestone Two Guid X SACC 325 Milestone X forced/1372719-ACC-325-Q1941-OL-TRAD-UG.23EW1/Course%20Files/ACC%2032... ome Workbo... paraphraser icon 1 / 2 | - 97% + | @ ACC 325 Milestone Two Final Project Workbook Instructions 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. OCT 16 |- C I need help with my x + 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. c. 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. v. Fund-Raising: 10% Management and General: 20% 6 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. 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. BO tv N MacBook Air 9 I l A M < : X 2 History 0 D2L 5-1 Final Project Mi X Bookmarks Profiles Tab Window Help /content/enforced/1372719-ACC-325-Q1941-OL-TRAD-UG.23EW1/Course%20Files/ACC%2032... Final Project Workbo... SNHU Home 3 E C 80 F3 paraphraser icon 1 / 2 | - $ 4 D2L Milestone Two Guic x Use the information in the Trial Balance tab to prepare the following financial statements: OCT 16 1. Statement of Financial Position You will use the data provided in the Trial Balance tab to complete this statement. Q F4 R 97% 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. e. + i. Program 1: 40% ii. Program 2: 20% iii. Program 3: 10% iv. v. Fund-Raising: 10% a. Salaries and Fringe Benefit Expenses were allocated to Program Services and Supporting Expenses in the following percentages: 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. do L H % ACC 325 Milestone X CI need help with my X x | + 5 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. Management and General: 20% 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. 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. F5 T 6 atv MacBook Air c F6 Y & 7 2 F7 G U 1 all Z A * 8 DII F8 1 5 : - S 9 F9 M 0 O : B I Project Workbook V Activities F10 X E View P %* Number F W Automate a Statement of C E F11 G

Answer rating: 100% (QA)

Statement of Financial Position Assets Cash on Hand 163314 Cash from Contributors unrestricted 34080... View the full answer