Juvenile Delinquent Assistance (JDA) is a nonprofit that provides counseling and recreation programs for youth offenders JDA's programs are financed through a contract with the county in which it is located and through contributions from local citizens The following transactions occurred during 2021 (fiscal year ending 12 31 2021) (27 points) JDA received pledges of gifts in the amount of $30,000, to be used as the JDA trustees consider appropriate Based on previous experience, JDA's Executive Director believed that all of the pledges would be collected JDA collected $23,000 cash on the pledges received in the previous transaction JDA received a gift of 5 computers valued at a total of $7,500 at the time of the gift (hint donated computers are considered support revenue equipment) JDA paid $4,000 cash for athletic equipment (hint athletic equipment is also considered an asset for the organization, equipment) JDA's employees earned $19,000 in wages JDA paid the employees $12,000 in wages (hint you can complete this as a single transaction or two transactions) JDA billed the county $14,500 for costs incurred under its contract after providing the contracted service JDA borrows $30,000 from the bank JDA paid $500 in interest during the year on the bank loan Assume that JDA began the year with the following balances (shown in alphabetical order) in their accounts Accounts Receivable (A R) $1,200 Cash $4,600 Equipment (Computers, athletic equip , etc ) Net Assets (NA) $8,500 Notes Payable (N P) $ Pledges Receivable (P R) $3,200 Wages Payable (W P) $500 Prepare a Statement of Financial Position Balance Sheet and Activity Statement for JDA based on the above information and accrual accounting concepts Include a transaction worksheet, like the template provided for Homework 5, to record transactions but it does not count as the financial statements You may include the statements here or in an attached spreadsheet Be sure to include the appropriate header information for each financial statement Ill also need help on making a detailed excel sheet to answer this Thank you in advance

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 29, 2024

Juvenile Delinquent Assistance (JDA) is a nonprofit that provides counseling and recreation programs for youth offenders. JDA's programs are financed through a contract with the

Juvenile Delinquent Assistance (JDA) is a nonprofit that provides counseling and recreation programs for youth offenders. JDA's programs are financed through a contract with the county in which it is located and through contributions from local citizens. The following transactions occurred during 2021 (fiscal year ending 12/31/2021): (27 points)

JDA received pledges of gifts in the amount of $30,000, to be used as the JDA trustees consider appropriate. Based on previous experience, JDA's Executive Director believed that all of the pledges would be collected.

JDA collected $23,000 cash on the pledges received in the previous transaction.

JDA received a gift of 5 computers valued at a total of $7,500 at the time of the gift (hint: donated computers are considered support revenue & equipment).

JDA paid $4,000 cash for athletic equipment (hint: athletic equipment is also considered an asset for the organization, equipment).

JDA's employees earned $19,000 in wages. JDA paid the employees $12,000 in wages. (hint: you can complete this as a single transaction or two transactions)

JDA billed the county $14,500 for costs incurred under its contract after providing the contracted service.

JDA borrows $30,000 from the bank.

JDA paid $500 in interest during the year on the bank loan.

Assume that JDA began the year with the following balances (shown in alphabetical order) in their accounts:

Accounts Receivable (A/R)	$1,200
Cash	$4,600
Equipment (Computers, athletic equip., etc.)	-
Net Assets (NA)	$8,500
Notes Payable (N/P)	$-
Pledges Receivable (P/R)	$3,200
Wages Payable (W/P)	$500

Prepare a Statement of Financial Position/Balance Sheet and Activity Statement for JDA based on the above information and accrual accounting concepts. Include a transaction worksheet, like the template provided for Homework #5, to record transactions but it does not count as the financial statements. You may include the statements here or in an attached spreadsheet. Be sure to include the appropriate header information for each financial statement!

Ill also need help on making a detailed excel sheet to answer this? Thank you in advance