Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can i get some help please . thank you 2. Statement of Activities In addition to the information provided from the Trial Balance tab, use

can i get some help please . thank you
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 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 tob and the information you have the prepared in the Statement of Financial Position and Stotement of Activities, use the following information to prepare the Stotement 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 recelvable 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|} \hline A & B & C \\ \hline & & \\ \hline \begin{tabular}{c} 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 & th & 378,820 \\ \hline Contributions - With Donor Restrictions-Programs & & 38,100 \\ \hline Investment Income-Without Donor Restrictions & & 11,200 \\ \hline Depreciation Expense & 30,000 & \\ \hline Printing and Publishing Expense & 4,190 & \\ \hline Rent Expense & 32,000 & \\ \hline Salaries and Fringe Benefit Expense & 288,410 & \\ \hline Supplies Expense & 5,940 & \\ \hline Telephone and Postage Expense & 4,500 & \\ \hline Utilities Expense & 6,400 & \\ \hline 5 Totals & $959,740 & $959,740 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ } \\ \hline \multicolumn{2}{|c|}{ Statement of Financial Position } \\ \hline \multicolumn{2}{|c|}{ December 31, 2018} \\ \hline \multicolumn{2}{|l|}{ Assets } \\ \hline \multicolumn{2}{|l|}{ Cash } \\ \hline \multicolumn{2}{|l|}{ Pledges Receivable } \\ \hline \multicolumn{2}{|l|}{ Inventory } \\ \hline \multicolumn{2}{|l|}{ Investments } \\ \hline Furniture and Equipment & \\ \hline & \\ \hline Total Assets & $0.00 \\ \hline \multicolumn{2}{|l|}{ Liabilities } \\ \hline \multicolumn{2}{|l|}{ Accounts Payable } \\ \hline & \\ \hline Total Liabilities & $0.00 \\ \hline Net Assets & x \\ \hline \multicolumn{2}{|l|}{ Without Donor Restrictions } \\ \hline \multicolumn{2}{|c|}{ With Donor Restrictions-Programs } \\ \hline \multicolumn{2}{|c|}{ With Donor Restrictions-Permanent Endowment } \\ \hline & \\ \hline Total Net Assets & $0.00 \\ \hline Total Liabilities and Net Assets & $0.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline A & B & C & D \\ \hline \multicolumn{4}{|c|}{ } \\ \hline \multicolumn{4}{|c|}{ Statement of Activities } \\ \hline \multicolumn{4}{|c|}{ Year Ended December 31, 2018} \\ \hline & \begin{tabular}{c} Without Donor \\ Restrictions \end{tabular} & \begin{tabular}{l} With Donor \\ Restrictions \end{tabular} & Total \\ \hline \multicolumn{4}{|l|}{ Revenues, Gains, and Other Support: } \\ \hline Contributions & & & $0 \\ \hline \multirow{2}{*}{\multicolumn{4}{|c|}{ Investment Income }} \\ \hline & & + & \\ \hline Total Revenues, Gains, and Other Support & $0 & \$0 & $0 \\ \hline \multicolumn{4}{|l|}{ Expenses and Losses: } \\ \hline \multicolumn{4}{|l|}{ Program Services: } \\ \hline Program 1 & & & 0 \\ \hline Program 2 & & & 0 \\ \hline \multirow[t]{2}{*}{ Program 3} & & & 0 \\ \hline & & & \\ \hline Total Program Expenses & \$o & $0 & $0 \\ \hline \multicolumn{4}{|l|}{ Support Expenses: } \\ \hline Management and General & & & 0 \\ \hline \multirow{2}{*}{ Fundraising } & 2 & & 0 \\ \hline & & & \\ \hline Total Support Expenses & \$0 & $0 & \$o \\ \hline Total Expenses and Losses & 0 & 0 & 0 \\ \hline Change in Net Assets & $0 & \$0 & \$o \\ \hline Net Assets, December 31, 2017 & & & 0 \\ \hline Net Assets, December 31, 2018 & $0 & $0 & $0 \\ \hline : & & & \\ \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 Management Accounting

Authors: Charles T. Horngren, Gary L. Sundem, William O. Stratton, Dave Burgstahler, Jeff O. Schatzberg

16th Global Edition

0273790013, 978-0273790013

More Books

Students also viewed these Accounting questions

Question

What is Accounting?

Answered: 1 week ago

Question

Define organisation chart

Answered: 1 week ago

Question

What are the advantages of planning ?

Answered: 1 week ago

Question

Recognize the features of practical performance appraisal forms

Answered: 1 week ago