ACC 325 Southern New Hampshire University Trial Balance Financial Report Worksheet I have attached the workbook and assignment instructions that I need to | Course Hero

ACC 325 Southern New Hampshire University Trial Balance Financial Report Worksheet I have attached the workbook and assignment instructions that I need to complete. I could use help with completing the Statement of Financial Position, Statement of Activities, and Statement of Cash Flows tabs. Statement of Activities
Year Ended December 31, 2018
Without Donor
Restrictions
With Donor
Restrictions
Total
Revenues, Gains, and Other Support:
Contributions
Investment Income
$0
0
Total Revenues, Gains, and Other Support
Expenses and Losses:
Program Services:
Program 1
Program 2
Program 3
$0
$0
Total Program Expenses
Support Expenses:
Management and General
Fundraising
$0
Total Support Expenses
Total Expenses and Losses
Change in Net Assets
Net Assets, December 31, 2017
Net Assets, December 31, 2018
$0
0
$0
$0
0
$0
$0
$0
$0
0
0
0
$0
$0
0
0
$0
0
$0
0
$0
Budget
January 1, 2019 – December 31, 2019
YTD Actual
2018
Budget
2019
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
Change in Net Assets
$0
$0
Numerator
Current Assets
Liquidity
÷
Denominator
Current Liabilities
÷
Numerator
Total Revenues
Going Concern
÷
=
Denominator
Total Expenses
÷
Numerator
Debt
Debt
=
=
Capital Structure
÷
Denominator
Total Assets
÷
÷
=
=
=
Net Assets
=
Numerator
Program Expenses
Numerator
Program Expenses
Program Effectiveness
÷
Denominator
Total Expenses
÷
Efficiency
÷
Denominator
# of Clients Served
÷
Numerator
Total Contributions – Fundraising Costs
Numerator
Fundraising Expenses
Fundraising Ratio
÷
Denominator
Total Contributions
÷
Fundraising Efficiency
÷
Denominator
Public Support
÷
Investment Performance
Numerator
÷
Denominator
Interest and Dividend Income +/- Gains and
Average Fair Value of
Losses
Investments
÷
=
=
=
=
=
=
=
=
=
=
Ratio
#DIV/0!
Ratio
#DIV/0!
Ratio
#DIV/0!
#DIV/0!
Ratio
#DIV/0!
Ratio
#DIV/0!
Ratio
#DIV/0!
Ratio
#DIV/0!
Ratio
#DIV/0!
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.
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.
Figures and data adapted from Reck, Accounting for Governmental & Nonprofit Entities, 18e.

Purchase answer to see full
attachment