Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is all the information!!!! Use the information in the Trial Balance tab to prepare the following financial statements: 1. Statement of Financial Position You

This is all the information!!!!

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Cash Pledges Receivable-Without Donor Restrictions Estimated Uncollectible Pledges Inventory Investments Furniture and Equipment Accumulated Depreciation - Furniture and Equipment Accounts Payable Net Assets Without Donor Restrictions Net Assets With Donor Restrictions - Programs Net Assets With Donor Restrictions Permanent Endowment Contributions-Without Donor Restrictions Contributions-With Donor Restrictions-Programs Investment Income-Without Donor Restrictions Depreciation Expense Printing and Publishing Expense Rent and Utility Expense Salaries and Fringe Benefit Expense Supplies Expense Telephone and Postage Expense Utilities Expense Totals Debit Credit $156,500 41,000 $4,100 2,800 178,000 210,000 120,000 20,520 196,500 50,500 140,000 378,820 38,100 11,200 30,000 4,190 32,000 288,410 5,940 4,500 6,400 $959,740 $959,740 Statement of Financial Position December 31, 2018 Assets Cash Pledges Receivable Inventory Investments Furniture and Equipment $0.00 Total Assets Liabilities Accounts Payable $0.00 Total Liabilities Net Assets Without Donor Restrictions With Donor Restrictions - Programs With Donor Restrictions-Permanent Endowment Total Net Assets Total Liabilities and Net Assets $0.00 $0.00 Statement of Activities Year Ended December 31, 2018 Without Donor Restrictions Revenues, Gains, and Other Support: Contributions Investment Income With Donor Restrictions Total o $0 Total Revenues, Gains, and Other Support Expenses and losses: Program Services: Program Program Program 3 1 2 0 0 $0 $0 $0 Total Program Expenses Support Expenses: Management and General Fundraising $0 $0 $0 0 0 Total Support Expenses Total Expenses and Losses Change in Net Assets Net Assets, December 31, 2017 Net Assets, December 31, 2018 So $0 $0 $0 $0 Statement of Cash Flows Year Ended December 31, 2018 Cash Flows from Operating Activities: Cash Received from Contributors Cash Received as Investment Income Cash Paid to Employees Cash Paid for Operating Expenses Net Cash Used for Operating Activities Cash Flows from Investing Activities: Purchase of Furniture and Equipment Cash Flows from Financing Activities: Proceeds from Contributions Restricted for: Investment in Capital Assets Net Increase(Decrease) in Cash Cash, December 31, 2017 Cash, December 31, 2018 Reconciliation of Changes in Net Assets to Net Cash Used for Change in Net Assets Adjustments to Reconcile Changes in Net Assets to Net Cash Depreciation Increase in Net Pledges Receivable Increase in Inventory Decrease in Accounts Payable Net Cash Used for Operating Activities Cash Pledges Receivable-Without Donor Restrictions Estimated Uncollectible Pledges Inventory Investments Furniture and Equipment Accumulated Depreciation - Furniture and Equipment Accounts Payable Net Assets Without Donor Restrictions Net Assets With Donor Restrictions - Programs Net Assets With Donor Restrictions Permanent Endowment Contributions-Without Donor Restrictions Contributions-With Donor Restrictions-Programs Investment Income-Without Donor Restrictions Depreciation Expense Printing and Publishing Expense Rent and Utility Expense Salaries and Fringe Benefit Expense Supplies Expense Telephone and Postage Expense Utilities Expense Totals Debit Credit $156,500 41,000 $4,100 2,800 178,000 210,000 120,000 20,520 196,500 50,500 140,000 378,820 38,100 11,200 30,000 4,190 32,000 288,410 5,940 4,500 6,400 $959,740 $959,740 Statement of Financial Position December 31, 2018 Assets Cash Pledges Receivable Inventory Investments Furniture and Equipment $0.00 Total Assets Liabilities Accounts Payable $0.00 Total Liabilities Net Assets Without Donor Restrictions With Donor Restrictions - Programs With Donor Restrictions-Permanent Endowment Total Net Assets Total Liabilities and Net Assets $0.00 $0.00 Statement of Activities Year Ended December 31, 2018 Without Donor Restrictions Revenues, Gains, and Other Support: Contributions Investment Income With Donor Restrictions Total o $0 Total Revenues, Gains, and Other Support Expenses and losses: Program Services: Program Program Program 3 1 2 0 0 $0 $0 $0 Total Program Expenses Support Expenses: Management and General Fundraising $0 $0 $0 0 0 Total Support Expenses Total Expenses and Losses Change in Net Assets Net Assets, December 31, 2017 Net Assets, December 31, 2018 So $0 $0 $0 $0 Statement of Cash Flows Year Ended December 31, 2018 Cash Flows from Operating Activities: Cash Received from Contributors Cash Received as Investment Income Cash Paid to Employees Cash Paid for Operating Expenses Net Cash Used for Operating Activities Cash Flows from Investing Activities: Purchase of Furniture and Equipment Cash Flows from Financing Activities: Proceeds from Contributions Restricted for: Investment in Capital Assets Net Increase(Decrease) in Cash Cash, December 31, 2017 Cash, December 31, 2018 Reconciliation of Changes in Net Assets to Net Cash Used for Change in Net Assets Adjustments to Reconcile Changes in Net Assets to Net Cash Depreciation Increase in Net Pledges Receivable Increase in Inventory Decrease in Accounts Payable Net Cash Used for Operating Activities

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance Text And Cases

Authors: Vishwanath S. R.

3rd Edition

9353282896, 978-9353282899

More Books

Students also viewed these Accounting questions

Question

Formulate strategies and recommendations for action on HRM issues.

Answered: 1 week ago