5 Required: Prepare the statement financial position and statement of activities for this NFP in good form following the examples in Modules of the coursepack based on the adjusted trial balance provided below. Open a new tab (worksheet) for each of the statements and name them XSFA and XSA Where is your last name, for example. MLOS SFP IMPORTANT: Link (copy the data in this asstenment worksheet to the two financial statements with the function. As mentice where Assignment is the name of the worksheet from which you want to copy cell Use the power of Excel to copy from the trial balance into the financial statements when possible 6 7 Important: Use View-Page Break Preview to check each of your worksheets to be sure they would print on an 8 1/2 x 11" paper(s); that is, move the margin lines to be sure you don't have text falling off the right hand side of the paper. Return it to Normal View. 8 9 10 11 12 Keep the Rivers Clean Organization Adjusted (pre-closing) Trial Balance as of December 31 2020 Debit S s 18 14 Cash and cash equivalents 15 Contributions receivable, net of uncollectible accounts 16 Grants receivable 17 Inventory - Supplies 18 Prepaid expenses 19. Long-term investments, at fair value 20. Capital assets, net of accumulated depreciation 21 Accounts payable 22 Capital lease obligations payable 23 Notes payable 24 Net Assets Without donor restrictions 25 Net Assets With donor restrictions 26 Contributions without restrictions 27 Contributions with restrictions 28 in-kind contributions without restrictions 29 In-kind donations - with restrictions 30 Government grants without restrictions 31 interest and dividend income 32 Realized and unrealized loss on investments 33 Net assets released from restrictions 34 Program service expenses 35 Supporting service expenses 36 Totals Credit 158,050 32,411 40,000 25,985 10,000 61 442 75,430 S 26,930 6,500 20,000 37.492 94,813 173 956 57,875 54,365 36,005 32.249 1,080 355 32,750 32.750 107.035 30 557 574,015 S 574,015 S Trial balance directions Cash Flow Directions Required: Prepare the statement of cash flows INDIRECT METHOD for this NFP in good form following the examples in Module 3 of the coursepack based on the information provided below. ALSO, prepare the operating Activities under the DIRECT METHOD. Open a new tab (worksheet) for the statement and name it"XSCF" where X is your last name; for example, "LOSIC IMPORTANT: Link (copy) the data in this assignment worksheet to the financial statement with the function: Assignment'!C4 where Assignment is the name of the worksheet from which you want to copy cell C4. Use the power of Excel to copy from the trial balance into the financial statements when possible. Important: Use View-Page Break Preview to check each of your worksheets to be sure they would print on an 8 1/2 x 11" paper(s); that is, move the margin lines to be sure you don't have text falling off the right hand side of the paper. Return it to Normal View. As of June 30, 2020, the organization had $165,814 of cash on hand at the beginning of the year. During the year, the center received cash from contributors: $310,400 that was unrestricted and $38,200 that was restricted for the purpose of equipment for the center, it had $9,300 of income earned and received on long-term investments. The center spent cash of $288,510 on salaries and fringe benefits, $23,000 on the purchase of equipment for the center, and $86,604 for operating expenses. Other pertinent information follows: net pledges receivable increased $5,700, inventory increased $1,100, accounts payable decreased $103,094, and there were no salaries payable at the beginning of the year. 1 2 Cash paid for operating expenses 3. Cash paid to employees Cash received as Investment income 5 Cash received from contributiors 6 Change in Net Assets (From Statement of Activities) 7 Decrease in A/P 8 Depreciation 9 Increase in inventory 0 Increase in net pledges receivable 1 Investment in Capital Assets (From Restricted contribution) 2 Purchase of Furniture and Equipment 3 Unrealized gain on investments 4 5 1. Prepare a statement of Cash Flows Indirect Method) 6 2. Prepare the Operating Activities section under the Direct Method 27 86,604 288,510 9,300 310,400 26,080 103,094 30.500 1.100 5,700 38,200 23,000 2.100 5 Required: Prepare the statement financial position and statement of activities for this NFP in good form following the examples in Modules of the coursepack based on the adjusted trial balance provided below. Open a new tab (worksheet) for each of the statements and name them XSFA and XSA Where is your last name, for example. MLOS SFP IMPORTANT: Link (copy the data in this asstenment worksheet to the two financial statements with the function. As mentice where Assignment is the name of the worksheet from which you want to copy cell Use the power of Excel to copy from the trial balance into the financial statements when possible 6 7 Important: Use View-Page Break Preview to check each of your worksheets to be sure they would print on an 8 1/2 x 11" paper(s); that is, move the margin lines to be sure you don't have text falling off the right hand side of the paper. Return it to Normal View. 8 9 10 11 12 Keep the Rivers Clean Organization Adjusted (pre-closing) Trial Balance as of December 31 2020 Debit S s 18 14 Cash and cash equivalents 15 Contributions receivable, net of uncollectible accounts 16 Grants receivable 17 Inventory - Supplies 18 Prepaid expenses 19. Long-term investments, at fair value 20. Capital assets, net of accumulated depreciation 21 Accounts payable 22 Capital lease obligations payable 23 Notes payable 24 Net Assets Without donor restrictions 25 Net Assets With donor restrictions 26 Contributions without restrictions 27 Contributions with restrictions 28 in-kind contributions without restrictions 29 In-kind donations - with restrictions 30 Government grants without restrictions 31 interest and dividend income 32 Realized and unrealized loss on investments 33 Net assets released from restrictions 34 Program service expenses 35 Supporting service expenses 36 Totals Credit 158,050 32,411 40,000 25,985 10,000 61 442 75,430 S 26,930 6,500 20,000 37.492 94,813 173 956 57,875 54,365 36,005 32.249 1,080 355 32,750 32.750 107.035 30 557 574,015 S 574,015 S Trial balance directions Cash Flow Directions Required: Prepare the statement of cash flows INDIRECT METHOD for this NFP in good form following the examples in Module 3 of the coursepack based on the information provided below. ALSO, prepare the operating Activities under the DIRECT METHOD. Open a new tab (worksheet) for the statement and name it"XSCF" where X is your last name; for example, "LOSIC IMPORTANT: Link (copy) the data in this assignment worksheet to the financial statement with the function: Assignment'!C4 where Assignment is the name of the worksheet from which you want to copy cell C4. Use the power of Excel to copy from the trial balance into the financial statements when possible. Important: Use View-Page Break Preview to check each of your worksheets to be sure they would print on an 8 1/2 x 11" paper(s); that is, move the margin lines to be sure you don't have text falling off the right hand side of the paper. Return it to Normal View. As of June 30, 2020, the organization had $165,814 of cash on hand at the beginning of the year. During the year, the center received cash from contributors: $310,400 that was unrestricted and $38,200 that was restricted for the purpose of equipment for the center, it had $9,300 of income earned and received on long-term investments. The center spent cash of $288,510 on salaries and fringe benefits, $23,000 on the purchase of equipment for the center, and $86,604 for operating expenses. Other pertinent information follows: net pledges receivable increased $5,700, inventory increased $1,100, accounts payable decreased $103,094, and there were no salaries payable at the beginning of the year. 1 2 Cash paid for operating expenses 3. Cash paid to employees Cash received as Investment income 5 Cash received from contributiors 6 Change in Net Assets (From Statement of Activities) 7 Decrease in A/P 8 Depreciation 9 Increase in inventory 0 Increase in net pledges receivable 1 Investment in Capital Assets (From Restricted contribution) 2 Purchase of Furniture and Equipment 3 Unrealized gain on investments 4 5 1. Prepare a statement of Cash Flows Indirect Method) 6 2. Prepare the Operating Activities section under the Direct Method 27 86,604 288,510 9,300 310,400 26,080 103,094 30.500 1.100 5,700 38,200 23,000 2.100