I need help with this problem.

Excel-Based Problems 1015 Jefferson Animal Rescue is a private not forprofit clinic and shelter for abandoned domesticated animals, chielly dogs and cats. At the end of 2019 , the organization had the following account balances: The following took place during 2020 : 1. Additional supplies were purchased on aceount in the amonit of 516,050 2. Unconditional (and unrestricted) pledges of support were received totaling $95,000. In light of a declining ccononv. 4 percent is expected to be uncollectible. The remainder is expected to be collected in the carrent yeat 3. Supplies used for animal care amounted to $17,200. 4. Payments made on accounts payable amounted to $17,100 5. Cash collected from pledges totaled $90,500. 6. Salaries were paid in the amount of $47,500. Included in this amonat is the acerued wages payable at the end of 2019. (The ponion of wages expense attributable to administrative expense is $15,000 and fund-raising expense is $2,000. The remainder is for animal 7. Jefferson Animal Reseue entered an agreement with KDAC. Channel 8 News, to find taore lomes for slietter pets. This special care.) adoption program highlights a shelter animal in need of a hone on the cvening news the first Thurstay of each month. The progmm was initially funded by a restricted gift. During 2020. Jefferson Anialal Resese paid $1.800 ( $150 per month) for the production of the monthly videos. In December 2020, the original donor uncouditionally pledged to support the proiect for an miditional 24 months by promising to pay $3,600 in January 2021 (all of this is expected to be collectible). The following took place during 2020 : 1. Additional supplies were purchased on account in the amount of $16,050. 2. Unconditional (and unrestricted) pledges of support were received totaling $95,000. In light of a declining econony. 4 percent is expected to be uncollectible. The remainder is expected to be collected in the current year: 3. Supplies used for animal care amounted to $17,200. 4. Payments made on accounts payable amounted to $17,100. 5. Cash collected from pledges totaled $90,500. 6. Salaries were paid in the amount of $47,500. Included in this amount is the acerued wages payable at the cnd of 2019. (The portion of wages expense attributable to administrative expense is $15.000 and fund-raising expense is $2,000. The reulainder is for animal care.) 7. Jefferson Animal Rescue entered an agreement with KDAC. Channel 8 News, to find more homes for shelter pets, This special adoption program highlights a shelter animal in need of a home on the evening news the first Thursday of each month. The program was initially funded by a restricted gift. During 2020. Jefferson Animal Rescue paid $1.800 (\$150 per month) for the production of the monthly videos. In December 2020, the original donor unconditionally pledged to support the project for an additional 24 months by promising to pay $3,600 in January 2021 (all of this is expected to be collectible). 8. The shelter's building was partially financed by a bank note with an annual interest rate of 6 perceut. Interest totaling $1.250 was paid during 2020. Interest is displayed as Administrative Expense in the Statement of Activities: 9. Animal medical equipment was purchased during the year in the amount of $5.200. Funding came from a speciat capital campaien conducted in 2019. 10. Depreciation for the year amounted to $6,000. (The portion of depreciation expense atuributable to administrative is $2,000, and the remainder is related to animal care.) 11. Unpaid wages relating to the final week of the year totaled $715 (all animal care). Using the information above and the Excel template provided: a. Prepare journal entries and post entries to the T-accounts. b. Prepare closing entries. c. Prepare a Statement of Activities, Statement of Financial Position, and Statement of Cash Flows for the year ending December 31 . 2020. ADMIN EXPrNSE RECLASSDEATION MaLASsmickTION To NAA BKOM NA WrTH ReIsTe HaC Assticanos nos wruot dovor EtSTR Jelferson Animal Roscue a private not-for-probt Closing Entries December 31, 2020 Jefferson Animal Rescue Statement of Activities For the year ended 12-31-2020 Net Assets Net Assets Without Donor With Donor 6 Revenues Restrictions Restrictions Total Contributions Net assets released from restriction: Satisfaction of program restrictions Satisfaction of capital asset restrictions Total Revenues and Other Support Operating Expenses Animal Care KDAC TV program Administration Fundraising Total Operating Expenses Change in net assets from operations Change in Net Assets Net Assets- Beginning of Year Net Assets - End of Year Jeftersou Animal Rescue Jelferson Animal Rescue Statemeat of Cash Flows Statement of Financial Position for the year ended 12-31-2020 As of 12-31-2020 CASIR HOWS FROM OPERATING ACINITIES Assets Change in Net Assets Cash Depreciation expense Pledges recemable (net) Increase in piedges receivable (net) Supplies liventory Decrease in suppties total current assets Decrease in accounts payable lintense in wages payable Land buticing and equprace: Other Less accurnalated depreciation Net cass provided (used) by operating activities Total Assets CASH HLOWS FROM FINANCINGACTVITIES Liabilities Borrowings this period Accorats payable Net cash provided (used) by financing actsities Wages payable tota coment sabilities CAST FLOWS FROM INVESTHN ACTIIIITS Purchase of land buhlings and equptient Net cash provided (used) from inesting activides Net asseti Withont Donor Restrictions Increase im cash Net Assets with Doncer Restrictions Cash and cash equivilents begining of year ICDACIN program Crish and cash equivalents end of year Perchase of cayatbl assets Total Net Assets Total I iabarties and Net Assets