1. Additional supplies were purchased on account in the amount of $16,050. 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. raising expense is $2,000. The remainder is for animal care.) original donor unconditionally pledged to support the project for an additional 24 months by promising to pay $3,600 in January 2022 (all of this is expected to be collectible). Activities. 9. Animal medical equipment was purchased during the year in the amount of $5,200. Funding came from a special capital campaign conducted in 2020 . 10. Depreciation for the year amounted to $6,000. (The portion of depreciation expense attributable 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). Instructions: Using formulas/functions wherever possible, complete the following... 1. Download a copy of the Excel file. 2. On the Journal Entries tab, complete the journal entries for the transactions above and post entries to the T-accounts. 3. On the Closing Entries tab, complete the closing journal entries and post to the T-accounts. 4. On the Statement of Activities tab, compile the Statement of Activities report. 5. And on the Other statements tab, complete the Statement of Cash Flows and the Statement of Financial Position