Situation

Suppose you are a financial manager in a nonprofit organization named Concern for Animal Shelter and Habitats $($CASH$).$ The organization places homeless animals in permanent homes. You need to record financial transactions on the transaction worksheet during the fiscal year and then need to prepare $($or generate$)$ an Activity Statement $($i$.$e$.,$ Income Statement$)$ based on the transaction worksheet at the end of the fiscal year. To generate an Activity Statement, you need to select transaction records that have effects on the Activity Statement. Then, you need to generate an Activity Statement using these selected records.

Transactions during this fiscal year $($January $1$ to December $31,2024)$ of operations were as follows:

Transaction $1.$ January $1$: CASH bought a car. The car cost was $$100$ and CASH paid for it when the car was received.

Transaction $2.$ January $22$: CASH received a $$300$ payment from a pledge made last year.

Transaction $3.$ March $15$: CASH paid out a $$50$ annual fee to the American Association of Animal Shelter and Habitats

Transaction $4.$ June $14$: CASH collected $$80$ in new donations. CASH can use this $$80$ for any purpose because donors did not impose any restrictions on the donations.

Transaction $5.$ July $2$: CASH received a letter from a donor. The letter said that the donor promises to make a gift of $$120,$ which can be used for any purpose. Based on CASH$$s data on historical patterns of donors$$ behavior, CASH expected that it could collect $100$ percent of this pledge.

Transaction $6.$ September $5$: CASH bought drugs, $60$ pills $($$$2$ per pill$),$ for dog and cat. They paid half now, and still owe the other half, to be paid at the end of the year

Transaction $7.$ October $7$: CASH used $35$ pills to provide medical services for dogs and cats.

Transaction $8.$ November $14.$ CASH borrowed $$75$ from IU Credit Union on a note payable.

Transaction $9.$ December $6$: CASH repaid $$25$ on the note payable, and also $$3$ in interest expenditures

Transaction $10.$ December $24$: CASH paid its employees $$95$ of wages in cash.

Transaction $11.$ December $25$: CASH expects that $$5$ of the pledge will not be corrected.

Transaction $12.$ December $31$: CASH recognizes depreciation on the car that it purchased on January $1$ this year. The car has a $10-$year useful life and a $$20$ salvage value. CASH uses straight$-$line depreciation.

Transaction $13.$ December $31$:While CASH received gift income, it also received earned income, which is fees for pet training services. CASH received $$60$ from customers in advance. While CASH has not provided any training services yet, it will provide the service to those customers next year

Question $1.$ Complete transaction worksheet. Provide your completed transaction worksheet. $($Note: Use Template $1)$

Note: When you fill out your transaction worksheet, write not only amounts but also $$appropriate and specific account names$$ related to each transaction on the Revenue $($& Support$)$ or Expenses column of the unrestricted fund section.$\backslash$table$[[$Date$,,$ASSETS,$=,$LABILITIES & NET ASSETS$],[,,$LLABIIIIES,$\{$

$\backslash$table$[[$NET ASSETS$],[$Unrestricted$]]\}],[,$Cash,$\backslash$table$[[$Pledges$],[$Receirable$],[($net$)]],$Inventory,$\backslash$table$[[$Property$],[$& Equipment$],[($net$)]],,\backslash$table$[[$Account$],[$Payable$]],\backslash$table$[[$Note$],[$Payable$]],\backslash$table$[[$Unearned$],[$Revenue$]],\backslash$table$[[$Deferred$],[$Rerenue$]]],[1-$Jan,Beginning,$110,350,19,350,=,27,270,0,0,402,$Retenues $($& Support$)$ or Expenses$],[1-$Jan,Transaction $=1,,,,,,,,,,,],[22-$Jan,Iransaction $=2,,,,,,,,,,,],[15-$Mar,Transaction $=3,,,,,,,,,,,],[14-$Jun,Iransaction $=4,,,,,,,,,,,],[2-$Jun,Iransaction $=15,,,,,,,,,,,],[5.$Sep,Iransaction $116,,,,,,,,,,,],[7-$Oet,Transaction $=?,,,,,,,,,,,],[14-$Nov,Transaction $==8,,,,,,,,,,,],[6-$Dec,Transaction $=9,,,,,,,,,,,],[24-$Dec,$\backslash$table$[[$Transaction$],[=10$