Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can i get some help please . is the statement of activities done correctly ? why are the programs still at 0 ? can i

can i get some help please . is the statement of activities done correctly ? why are the programs still at 0 ?
can i please have the statement of activities and statement of cashflow completed .
thank you .
i attached the instructions image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
2. Statement of Activities In addition to the information provided from the Trial Balance tob, 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. \begin{tabular}{|c|c|c|c|} \hline & A & \multirow[t]{2}{*}{ B } & \multirow[t]{2}{*}{ C } \\ \hline & \multirow[t]{2}{*}{\begin{tabular}{l} Trial Balance \\ as of 12/31/18 \end{tabular}} & & \\ \hline & & Debit & Credit \\ \hline & Cash & $156,500 & \\ \hline & Pledges Receivable-Without Donor Restrictions & 41,000 & \\ \hline & Estimated Uncollectible Pledges & & $4,100 \\ \hline & Inventory & 2,800 & \\ \hline & Investments & 178,000 & \\ \hline & Furniture and Equipment & 210,000 & \\ \hline & Accumulated Depreciation - Furniture and Equipment & & 120,000 \\ \hline & Accounts Payable & & 20,520 \\ \hline & Net Assets Without Donor Restrictions & & 196,500 \\ \hline & Net Assets With Donor Restrictions-Programs & & 50,500 \\ \hline & Net Assets With Donor Restrictions - Permanent Endowment & & 140,000 \\ \hline & Contributions - Without Donor Restrictions & & 378,820 \\ \hline & Contributions - With Donor Restrictions-Programs & & 38,100 \\ \hline & Investment Income-Without Donor Restrictions & & 11,200 \\ \hline & Depreciation Expense & 30,000 & \\ \hline & \begin{tabular}{l} Depreciation Expense \\ Printing and Publishing Expense \end{tabular} & 4,190 & \\ \hline & \begin{tabular}{l} Printing and Publishing Experise \\ Rent Expense \end{tabular} & 32,000 & \\ \hline & \begin{tabular}{l} Rent Expense \\ Salaries and Fringe Benefit Expense \end{tabular} & 288,410 & \\ \hline 3 & \begin{tabular}{l} Salaries and Fringe Benentiexperise \\ Supplies Expense \end{tabular} & 5,940 & \\ \hline 24 & \begin{tabular}{l} Supplies Expense \\ Telephone and Postage Expense \end{tabular} & 4,500 & \\ \hline 25 & \begin{tabular}{l} Telephone and Postage Experities Expense \\ Utilitis. \end{tabular} & 6,400 & \\ \hline & & $959,740 & $959,740 \\ \hline \end{tabular} Totals Figures and data adapted from Reck, Accounting for Governmental \& Nonprofit Entities, 18e \begin{tabular}{|c|c|c|} \hline A & B & C \\ \hline \multicolumn{3}{|c|}{ } \\ \hline \multicolumn{3}{|c|}{ Statement of Financial Position } \\ \hline \multicolumn{2}{|c|}{ December 31,2018} & \\ \hline \multicolumn{3}{|l|}{ Assets } \\ \hline Cash & $156,500.00 & \\ \hline Pledges Receivable & 36,900.00 & $41,000$4,100 \\ \hline Inventory & 2,800.00 & \\ \hline Investments & 178,000.00 & \\ \hline Furniture and Equipment & 90,000.00 & $210,000$120,000 \\ \hline Total Assets & $464,200.00 & \\ \hline \multicolumn{3}{|l|}{ Liabilities } \\ \hline Accounts Payable & $20,520.00 & \\ \hline Total Liabilities & $20,520.00 & \\ \hline \multicolumn{3}{|l|}{ Net Assets } \\ \hline Without Donor Restrictions & $196,500.00 & \\ \hline With Donor Restrictions-Programs & 50,500.00 & \\ \hline With Donor Restrictions-Permanent Endowment & 140,000.00 & \\ \hline & & \\ \hline Total Net Assets & $407,520.00$387,000.00 & \\ \hline Total Liabilities and Net Assets & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{\begin{tabular}{l} SYour Nonprofit's Name> \\ Statement of Activities \end{tabular}} \\ \hline & \begin{tabular}{l} Without Donor \\ Restrictions \end{tabular} & \begin{tabular}{l} With Donor \\ Restrictions \end{tabular} & Total \\ \hline Revenues, Gains, and Other Support: & & 11 & \\ \hline Contributions & $378,820 & $38,100 & $416,920 \\ \hline Investment Income & 11,200 & & 11,200 \\ \hline & & & \\ \hline Total Revenues, Gains, and Other Support & $390,020 & $38,100 & $428,120 \\ \hline \multicolumn{4}{|l|}{ Expenses and Losses: } \\ \hline \multicolumn{4}{|l|}{ Program Services: } \\ \hline Program 1 & & 7 & 0 \\ \hline Program 2 & IiI & & 0 \\ \hline Program 3 & III & & 0 \\ \hline & 11 & + & \\ \hline Total Program Expenses & $0 & $0 & so \\ \hline \multicolumn{4}{|l|}{ Support Expenses: } \\ \hline Management and General & & & 0 \\ \hline Fundraising & & & 0 \\ \hline & & & \\ \hline Total Support Expenses & \begin{tabular}{r} $0 \\ \end{tabular} & & so \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline investment income & 11,200 & & 11,200 \\ \hline & & & \\ \hline Total Revenues, Gains, and Other Support & $390,020 & $38,100 & $428,120 \\ \hline \multicolumn{4}{|l|}{ Expenses and Losses: } \\ \hline \multicolumn{4}{|l|}{ Program Services: } \\ \hline Program 1 & & & 0 \\ \hline Program 2 & & & 0 \\ \hline Program 3 & & & 0 \\ \hline & & & \\ \hline Total Program Expenses & $0 & $0 & $0 \\ \hline \multicolumn{4}{|l|}{ Support Expenses: } \\ \hline Management and General & & & 0 \\ \hline Fundraising & & & 0 \\ \hline & & & \\ \hline Total Support Expenses & \$o & $0 & 50 \\ \hline Total Expenses and Losses & 0 & 0 & 0 \\ \hline Change in Net Assets & $390,020 & $38,100 & $428,120 \\ \hline Net Assets, December 31, 2017 & & & 0 \\ \hline Net Assets, December 31, 2018 & $390,020 & $38,100 & $428,120 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Purchase of Furniture and Equipment & \\ \hline Cash Flows from Financing Activities: & \\ \hline Proceeds from Contributions Restricted for: & \\ \hline Investment in Capital Assets & \\ \hline Net Increase(Decrease) in Cash & \\ \hline Cash, December 31, 2017 & $0 \\ \hline Cash, December 31, 2018 & \\ \hline & \\ \hline Reconciliation of Changes in Net Assets to Net Cash Used for Operating \\ \hline Change in Net Assets & $428,120 \\ \hline Adjustments to Reconcile Changes in Net Assets to Net Cash Provided by \\ \hline Depreciation & \\ \hline Increase in Net Pledges Receivable & \\ \hline Increase in Inventory & $428,120 \\ \hline Decrease in Accounts Payable & \\ \hline \end{tabular}

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

Step: 3

blur-text-image

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

Introduction To Cost Accounting

Authors: Don R. Hansen, Maryanne Mowen, Liming Guan, Mowen/Hansen

1st International Edition

0538749636, 978-0538749633

More Books

Students also viewed these Accounting questions

Question

=+19.2. (a) Show that L"((0, 1], , A) is not separable.

Answered: 1 week ago