978-0078025815 Exercise 10 Excel

subject Type Homework Help
subject Pages 8
subject Words 1078
subject Authors Paul Copley

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
AWG EDUCATIONAL FOUNDATION - a private not-for-profit
journal entries and General ledger
PLEDGES ACCRUED INTEREST
CASH RECEIVABLE RECEIVABLE SUPPLIES
Association of Women in Government bb 22,900 bb 27,232 bb 700 bb 400
Educational Foundation 2,200 1 5 1,362 700 3 1 1,900
December 31, 2015 29,600 1,200 110,000 5 3 850 1,850 1
3
7,800
Account Title Debits Credits 510,000
1 Administrative expenses 2,200 22,000 618,594 850 450
Cash 2,200
Supplies 1,900
Accounts payable 1,900 24,900
Accounts payable 1,200 SCHOLARSHIPS ACCOUNTS
Cash 1,200 INVESTMENT IN BONDS PAYABLE PAYABLE
bb 100,000 5,000 bb - bb
Administrative expense 1,850 41,600 1,900 1
Supplies 1,850 20,000 61 1,200
6 22,000
2 Cash 9,600
Unrestricted revenue - contributions 9,600 101,600 3,000 700
3 Cash 7,800
UNRESTRICTED
NET ASSETS TEMPORARILY PERMANENTLY
Interest receivable 700 NET ASSETS RESTRICTED - SCHOLARSHIPS RESTRICTED NET ASSETS
Temporarily restricted revenue - interest 7,100 16,400 bb 2,600 bb 127,232 bb
Interest receivable 850
Temporarily restricted revenue - interest 850
4 Investment in bonds 1,600
Temporarily restricted revenue - net gain on 16,400 2,600 127,232
endowment investments 1,600
TEMPORARILY RESTRICTED
PERMANENTLY
5 Pledges receivable 1,362
UNRESTRICTED REVENUE
TEMPORARILY RESTRICTED
REVENUE-NET GAIN ON RESTRICTED REVENUE
Permanently restricted revenue - contributions 1,362 CONTRIBUTIONS REVENUE-INTEREST
ENDOWMENT INVESTMENTS
CONTRIBUTIONS
Cash 10,000 9,600 27,100 31,600 41,362 5
Pledges receivable 10,000 850 3
6 Program expenses - scholarships 20,000
Scholarships payable 20,000
Scholarships payable 22,000 9,600 7,950 1,600 1,362
Cash 22,000
PROGRAM EXPENSE RECLASSIFICATION RECLASSIFICATION TO
Reclassification from temp restricted net assets 12,150 ADMIN EXPENSE SCHOLARSHIPS FROM TEMP RESTR. UNRESTRICTED NET ASSETS
Reclassification to unrestricted net assets 12,150
1 2,200 6 20,000 6 12,150 12,150 6
11,850
Beginning temporarily restricted net assets 2,600
Interest income 7,950
Capital gains on bonds 1,600
12,150
4,050 20,000 12,150 12,150
Check that these equal after posting each journal entry
Total Debit Balances 182,594
Total Credit Balances 182,594
page-pf2
page-pf3
financial statements
Unrestricted
Temporarily
Restricted
Permanently
Restricted
Total
Revenues
Contributions 9,600$ -$ 1,362$ 10,962$
Interest Income 7,950 7,950
Net gain on endowment investments 1,600 1,600
Net assets released from restriction: -
Satisfaction of program restrictions 12,150 (12,150) -
Total Revenues and Other Support 21,750 (2,600) 1,362 20,512
Expenses
Scholarships 20,000 20,000
Administration 4,050 4,050
-
Total Expenses 24,050 - - 24,050
Change in Net Assets (2,300) (2,600) 1,362 (3,538)
Net Assets- Beginning of Year 16,400 2,600 127,232 146,232
Net Assets - End of Year 14,100$ -$ 128,594$ 142,694$
Statement of Activities
For the year ended 12-31-2015
Association of Women in Government Educational Foundation
page-pf4
Association of Women in Government Educational Foundation
Assets
Change in Net Assets (3,538)$ Cash 24,900$
Unrealized gain on investments (1,600) Pledges receivable 18,594
Increase in interest receivable (150) Interest receivable 850
Decrease in pledges receivable (net) 8,638 Supplies Inventory 450
Increase in supplies (50) Investment in bonds 101,600
Decrease in scholarships payable (2,000) -
Increase in accounts payable 700 Total Assets 146,394$
Net cash provided by operating activities 2,000 Liabilities
Accounts payable 700
Scholarships payable 3,000
Borrowings this period Total Liabilities 3,700
Net cash provided by financing activities -
Net assets
CASH FLOWS FROM INVESTING ACTIVITIES Unrestricted 14,100
Purchase of fixed assets Temporarily restricted for:
Net cash provided from investing activities - scholarships -
Permanently restricted (endowment) 128,594
Increase(decrease) in cash 2,000 Total Net Assets 142,694
Cash and cash equivalents end of year 24,900$
Statement of Financial Position
As of 12-31-2015
Association of Women in Government Educational Foundation
Statement of Cash Flows
for the year ended 12-31-2015
CASH FLOWS FROM OPERATING ACTIVITIES
CASH FLOWS FROM FINANCING ACTIVITIES
page-pf5
Jefferson Animal Rescue - a private not-for-profit
journal entries and General ledger
page-pf6
page-pf7
financial statements
Unrestricted
Temporarily
Restricted
Total
Revenues
Contributions 92,150$ 3,000$ 95,150$
Net assets released from restriction:
Satisfaction of program restrictions 1,800 (1,800) -
Satisfaction of capital asset restrictions 5,550 (5,550) -
Total Revenues and Other Support 99,500 (4,350) 95,150
Operating Expenses
Animal Care 50,886 50,886
KDAC TV program 1,800 1,800
Administration 17,000 17,000
Fundraising 2,000 2,000
Total Operating Expenses 71,686 - 71,686
Change in net assets from operations 27,814 (4,350) 23,464
Other changes (expenses)
Interest Expense (1,500) - (1,500)
Total nonoperating revenue (expense) (1,500) - (1,500)
Change in Net Assets 26,314 (4,350) 21,964
Net Assets- Beginning of Year 13,200 9,700 22,900
Net Assets - End of Year 39,514$ 5,350$ 44,864$
Jefferson Animal Rescue
Statement of Activities
For the year ended 12-31-2015
page-pf8
Assets
Change in Net Assets 21,964$ Cash 45,925$
Depreciation expense 6,000 Pledges receivable (net) 4,150
Increase in pledges receivable (net) (650) Supplies Inventory 4,320
Decrease in supplies (320) total current assets 54,395
Decrease in accounts payable (705)
Increase in wages payable 186 Land building and equipment 46,550
Other - Less: accumulated depreciation (25,300)
Net cash provided by operating activities 26,475 Total Assets 75,645$
Liabilities
Borrowings this period Accounts payable 5,095
Net cash provided by l financing activities - Wages payable 686
total current liabilities 5,781
CASH FLOWS FROM INVESTING ACTIVITIES Bank note payable 25,000
Purchase of land buildings and equipment (5,550)
Net cash provided from investing activities (5,550) Total Liabilities 30,781
Increase in cash 20,925 Net assets
Cash and cash equivalents beginning of year 25,000 Unrestricted 39,514
Cash and cash equivalents end of year 45,925$ Temporarily restricted for:
KDAC TV program 3,700
Purchase of capital assets 1,650
Total Net Assets 44,864
Total Liabilities and Net Assets 75,645$
CASH FLOWS FROM OPERATING ACTIVITIES
CASH FLOWS FROM FINANCING ACTIVITIES
Jefferson Animal Rescue
Jefferson Animal Rescue
Statement of Cash Flows
Statement of Financial Position
for the year ended 12-31-2015
As of 12-31-2015

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.