KPF was very successful in its first year with the corporate community. Katelyn, was busy during the holiday season and did not get a chance to account for some December 2022 transactions. atelyn knew that there were a total of 10 transactions that were not recorded ( 5 regular operational Iransactions and 5 adjustments transactions) that occurred at the end of December 2022. you can assist Katelyn in completing these transactions and preparing financial statements at the end of December 2022. Katelyn would like your help with the following: NOTE: Please provide as much audit trail of how calculations are derived (use formulas and link where you can in Excel) as you can so that as the assignment is corrected, the methodology can be followed. This will help prowidenartialcredit for matherrorsandexeludeanvearrvforward errors on a consistent theory applied 1. Prepare the 5 regular transactions &5 adjusting transactions, showing them on the "Transaction Analysis Template" 2. Prepare the following financial statements in proper form (see examples in your text for titling order, etc.) Place each financial statement on the applicable tab on this file. a. Income Statement b. Statement of Changes in Stockholders' Equity c. Balance Sheet REGULAR TRANSACTIONS NOT RECORDED YET: KPF had received a payment from collected $20,000 of her accounts receivable during December TRANSACTION 1 and forgot to record it. KPF sent gift baskets to her customer list for the holidays. This cost a total of $3,000 which Katelyn TRANSACTION 2 paid for in December 2022. KPFlanded a new corporate customer in December 2022 who wanted to pay $120,000 for a 12 month subscription to the dog walking service. The subscription starts on January 1, 2023. The TRANSACTION 3 customer asked if this purchase could be on account and payment would be made in January. KPF paid her staff an extra salary amount at year end as a bonus payment for a successful year's TRANSACTION 4 business. This amount was $4,000 and was paid to the employees in December 2022. KPF had a customer who paid $2,000 cash for the dogs walked during the last week of December TRANSACTION 5 2022. ADIUSTING TRANACTIONS NOT RECORDED YET: NOTE: Adjusting entries are generally recorded every month, and all prior month's entries have been properly recorded. Only the below AE's for December still need to be recorded. KPF noticed in the unearned revenue balance, that $25,000 of the balance was earned by dog TRANSACTION 1 walking for her customers in December 2022. Katelyn had not recorded this as yet. KPF pays their employees every Wednesday. The 2022 year ended on a Friday, but she did not pay the employees for the two days they worked in 2022 until the following week (which was in January 2023). This amount totaled $17,500. TRANSACTION 3 KPF did not record the insurance expense for the month of December 2022 of $8,000. TRANSACIION 4 KPF had an advertising campaign done in December 2022 by a marketing firm. Katelyn found the invoice on her desk for $11,000 and it was not due until January. TRANSACIION 5 KPF did not send an invoice to a customer for the month of December 2022 dog walking services of $9,000. 1 You can put all three financlal statements on this tab. a. Income 5tatement. b. Statement of Changes in Stockholders' Equily c. Balance sheet Kateinis Frt ritrins Catelmi fee nitheas Kateyny Pet Fithes Malanceshief Sarment of stockholdery' fauity De anter 31, zay? for the Year ended December 31, 2021