Please do the following exercise and problem- Open the web ebook- Government and Not-for-Profit...

Question

Please do the following exercise and problem- Open the web ebook- Government and Not-for-Profit Accounting: Concepts and Practices, Enhanced eText-https://strayer.vitalsource.com/reader/books/ XXXXXXXXXX/epubcfi/6/4[%3Bvnd.vst.idref%3DAnavigation]!/4-login - - username XXXXXXXXXX and password - Jeannemarie75@. As for the part of WK 9 -Your readings this week focused on various aspects of accounting in not-for-profit organizations. This week, you will take your first step to completing an Excel template for the fictitious not-for-profit Capitol Good Works Organization.

To complete this week's homework, you must download the Trial Balance Word document and the Excel template. Follow the instructions to complete the organization's Balance Sheet, as found in the Week 9 Homework tab of the Excel spreadsheet.

acc410-w8-hmwrk-submiss-sheet-wy0uvmlg.docx cfwk9homeworktrialbalance-zebviizx.pdf acct-410-wk-9cgwoexceltemplate-u0ho3wrs.xlsx

Nitish Lath · Accepted Answer

Chart of Accounts
		Capitol Good Works Organization
		Chart of Accounts and Other Useful Reference Information
		General Ledger Code	Account Description			General Ledger Code	Account Description
		11000	Cash			41001	Contributions					11000
		12000	Investments			41002	In kind contributions					12000
		13000	Pledges receivable			42000	Net Assets released from restriction					13000
		14000	Grants receivable			43001	State grant revenues					14000
		15000	Other receivables			43002	Federal grant revenues					15000
		16000	Prepaid expenses			44001	Membership dues					16000
		17001	Land			44002	Program service fees					17001
		17002	Buildings and improvements			45000	Investment earnings					17002
		17003	Leasehold improvements			51001	Salaries					17003
		17004	Equipment			51002	Payroll taxes					17004
		17500	Accumulated depreciation			51003	Employee benefits					17500
		18000	Investments endowment			52001	Professional Services					18000
		21000	Line of credit			52002	Supplies					21000
		22000	Accounts payable			52003	Telephone					22000
		24000	Lease incentive liability			52004	Postage and shipping					24000
		25000	Notes payable			52005	Rent					25000
		31000	Net Assets			52006	Printing and artwork					31000
						52007	Local transportation					41001
						52008	Conferences, Meeting and Conventions					41002
						52009	Scholarships, assistance to individuals					42000
						52011	Depreciation expense					43001
						52012	Interest expense					43002
						52013	Other expense					44001
						60000	Gain or Loss					44002
												45000
		Program Codes										51001
		100	Physical and Social Development									51002
		200	Supplementary Education			Restriction Codes						51003
		300	Community Development and Organization			1	Without donor restrictions					52001
		400	Scholarships			2	With donor restrictions					52002
		500	Management and General									52003
		600	Fundraising									52004
												52005
												52006
												52007
												52008
												52009
												52011
												52012
												52013
												60000
WK10 - Record Transactions 1-25
		Transactions for the Fiscal Year Ended 12/31/2021
										Cash Transaction Flg	PPE Transaction Flag		Cash PPE
		Transaction 1
		GL Code	Program	Restriction	GL + Prog	GL + Restr	Debit	Credit
		11000			11000000	110000	1,500,000.00			1	0	0	1
		13000			13000000	130000		1,500,000.00		0	0	0	0
		42000		2	42000000	420002	1,500,000.00			0	0	0	0
		42000		1	42000000	420001		1,500,000.00		0	0	0	0
													0
													0
		Transaction 2											0
													0
		GL Code	Program	Restriction			Debit	Credit		0	0	0	0
		11000			11000000	110000	474,966.25			1	0	0	1
		14000			14000000	140000		474,966.25		0	0	0	0
													0
													0
		Transaction 3											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		11000			11000000	110000	4,815,977.50			1	0	0	1
		13000			13000000	130000	694,786.25			0	0	0	0
		41001		1	41001000	410011		4,165,977.50		0	0	0	0
		41001		2	41001000	410012		1,344,786.25		0	0	0	0
		41002		1	41002000	410021		122,641.25		0	0	0	0
		52001	500	1	52001500	520011	122,641.25			0	0	0	0
													0
													0
		Transaction 4											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		14000			14000000	140000	4,048,455.00			0	0	0	0
		43001		1	43001000	430011		195,000.00		0	0	0	0
		43002		1	43002000	430021		3,853,455.00		0	0	0	0
													0
													0
		Transaction 5											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		11000			11000000	110000	460,053.75			1	0	0	1
		44001		1	44001000	440011		82,057.50		0	0	0	0
		44002		1	44002000	440021		377,996.25		0	0	0	0
													0
		Transaction 6											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		12000			12000000	120000	866,673.75			0	0	0	0
		18000		2	18000000	180002		866,673.75		0	0	0	0
													0
													0
		Transaction 7											0
													0
		Part A: Release the assets from restriction 											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		42000		2	42000000	420002	6,487,987.50			0	0	0	0
		42000		1	42000000	420001		6,487,987.50		0	0	0	0
													0
		Part B: Record expenditures 											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		51001	100		51001100	510010	1,887,455.94			0	0	0	0
		51001	200		51001200	510010	1,348,182.80			0	0	0	0
		51001	300		51001300	510010	808,909.69			0	0	0	0
		51001	400		51001400	510010	539,273.13			0	0	0	0	1
		51001	500		51001500	510010	647,127.75			0	0	0	0
		51001	600		51001600	510010	161,781.94			0	0	0	0
		51002	100		51002100	510020	191,720.18			0	0	0	0
		51002	200		51002200	510020	137,071.56			0	0	0	0
		51002	300		51002300	510020	82,242.94			0	0	0	0
		51002	400		51002400	510020	54,828.63			0	0	0	0
		51002	500		51002500	510020	65,974.35			0	0	0	0
		51002	600		51002600	510020	16,448.59			0	0	0	0
		51003	100		51003100	510030	191,439.50			0	0	0	0
		51003	200		51003200	510030	136,742.50			0	0	0	0
		51003	300		51003300	510030	82,045.50			0	0	0	0
		51003	400		51003400	510030	54,697.00			0	0	0	0
		51003	500		51003500	510030	65,636.40			0	0	0	0
		51003	600		51003600	510030	16,409.10			0	0	0	0
		11000			11000000	110000		6,487,987.50		1	0	0	1
													0
													0
		Transaction 8											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		18000	100		18000100	180000	83,475.88			0	0	0	0
		18000	200		18000200	180000	59,625.62			0	0	0	0
		18000	300		18000300	180000	35,775.37			0	0	0	0
		18000	400		18000400	180000	23,850.30			0	0	0	0
		18000	500		18000500	180000	28,620.30			0	0	0	0
		18000	600		18000600	180000	7,155.03			0	0	0	0
		11000			11000000	110000		238,502.50					0
													0
													0
		Transaction 9											0
													0
		GL Code	Program	Restriction			Debit	Credit		0	0	1	1
		11000			11000000	110000	250,000.00			1	0	1	2
		17004			17004000	170040		250,000.00		0	1	1	1
													0
													0
		Transaction 10											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		11000			11000000	110000	62,000.00			1	0	1	2
		17004			17004000	170040	175,000.00			0	1	1	1
		17004			17004000	170040		175,000.00		0	1	1	1
		60000	500	1	60000500	600001		62,000.00		0	0	1	1
													0
													0
		Transaction 11											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		52001	200		52001200	520010	544,888.12			0	0	0	0
		52001	500		52001500	520010	159,833.85			0	0	0	0
		52001	600		52001600	520010	21,795.53			0	0	0	0
		11000			11000000	110000		233,866.64		1	0	0	1
		22000			22000000	220000		492,650.86
					0	0							0
													0
		Transaction 12											0
													0
		GL Code	Program	Restriction			Debit	Credit					0
		52002	100		52002100	520020	235,700.50			0	0	0	0
		52002	200		52002200	520020	168,357.50			0	0	0	0
		52002	300		52002300	520020	101,014.50			0	0	0	0
		52002	400		52002400	520020	67,343.00			0	0	0	0
		52002	500		52002500	520020	80,811.60			0	0	0	0
		52002	600		52002600	520020	20,202.90			0	0	0	0
		11000			11000000	110000		355,817.05		1	0	0	1
		22000			22000000	220000		317,612.

Please do the following exercise and problem- Open the web ebook- Government and Not-for-Profit Accounting: Concepts and Practices, Enhanced eText-https://strayer.vitalsource.com/reader/books/...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment