Please help? I have already inputted the beginning balances into the ledger to the right.

Canine Concerns is a not-for-profit organization that protects abandoned dogs. The organization's trial balance at the beginning AutoSave Home Insert Paste NFP Case Excel v of the year follows: Cash Contributions Receivable Equipment and Furnishings Buildings (net) Accounts Payable Salaries Payable Net Assets Unrestricted Net Assets Restricted Total Draw Font Page Layout Formulas Q Tell me Conditional Formatting Format as Table v Cell Styles v D C) Comments Debit 100,000 152,000 Credit 220,000 42,000 980,000 Alignment O O Number Cells Editing c The following transactions occurred during the year: All the $152,000 contributions receivable were collected during the year. Unrestricted pledges of $4,250,000 were made during the year. Of these pledges, $4,200,000 was collected. All the remaining pledges wehe expected to be collected within the next two months. The Pet Foundation offered Canine Concerns $1,000,000 to study the effects of a new neutering technique. $600,000 is paid and $400,000 will be paid later. The funds must be used for research purposes. Of the grant money provided by the Pet Foundation, $100,000 was used to pay researcher salaries and $200,000 was used to purchase research equipment. A contribution was made by a prominent donor for $350,000. All funds are to be used for a networked computer system. The computer network was purchased for $350,000. Installation costs were $50,000. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 TRIAL BALANCE Cash Short-Term Investments Contributions Receivable Grant Receivable Equipment and Furnishings Buildings (net) Accounts Payable Salaries Payable Net Assets (beginning) Net Assets (beginning) Contribution Revenue - Contribution Revenue - Foundation Grant Revenue Program Service Expenses Administrative Expenses Asset Released from Restriction Satisfaction of Restriction Total Stmt of Fin Pos Ready Accessibility: Investigate Debit 100,000 152,000 Stmt of Activities Credit 152,000 220,000 42,000 980,000 Cash of $3,330,000 was paid for salaries. Twenty percent of the salaries were for administrative activities and the remaining were related to programs. At the end of the period, $72,000 of salaries remained payable. Program expenses of $750,000 were incurred during the period. At the end of the period, $170,000 of these expenses remained payable. Equipment and furnishings were depreciated for $240,000 and the building was depreciated for $550,000. 75% of these assets were used for programs and 25% of the assets were used administratively. (Make the entry using functional expenses.) Of the Pet Foundation money received, $250,000 was moved from cash to short-term investments. REQUIRED: Given the additional information provided, update the Trial Balance on the associated Excel Worksheet. e Share v Analyze Data 100%