Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please Help me balance out the following transactions and use the transaction analysis template below, as well as the financial statement templates. REGULAR TRANSACTIONS NOT
Please Help me balance out the following transactions and use the transaction analysis template below, as well as the financial statement templates.
REGULAR TRANSACTIONS NOT RECORDED YET: TRANSACTION 1 TRANSACTION 2 TRANSACTION 3 TRANSACTION 4 TRANSACTION 5 WOF sent customer promotional mailers worth $900 to potential customers in the area to attract new customers in hopes of starting off 2023 with a bang. WOF paid for and sent the mailers in December 2022. WOF landed a new corporate customer, Amazon, in December 2022 who wanted to pay $60,000 for a 12 month subscription to the dog walking service. The subscription starts on January 1, 2023. Amazon was very excited for the opportunity and they paid for the subscription in December 2022. WOF paid for insurance in advance for a new policy covering her dog walking business for the year of 2023 (January 1 - December 31). She paid cash of $12,000 for the policy. WOF bought bags, leashes, and treats amounting to $1,300 with her local pet supply warehouse in December 2022. During December, WOF had received a payment from collected $5,000 from a customer (who had previously paid on accounts) and did not record it. ADJUSTING TRANACTIONS NOT RECORDED YEL: NOTE: Adjusting entries are generally recorded every month, and_all prior month's entries have been properly recorded. Only the below AJE's for December still need to be recorded. TRANSACTION 1 TRANSACTION 2 TRANSACTION 4 TRANSACTION 5 TRANSACTION 1 WOF pays their employees every Tuesday. The 2022 year ended on a Friday, but they did not pay the employees for the three days they worked in 2022 until the following week (which was in January 2023). This amount totaled $24,500. WOF pre-paid the December 2022 rent, but did not record the rent expense for the office for the month of December 2022 of $5,000. WOF had cleaning services done in December 2022. Ryan found the invoice on his desk for $750 and it was not due until January. WOF did not send an invoice to a customer for the month of December 2022 dog walking services of $7,500. WOF noticed in the unearned revenue balance, that $14,000 of the balance was earned by dog walking for her customers in December 2022. Ryan had not recorded this yet. \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{2}{|l|}{ Walkers On Foot } & \multicolumn{2}{|l|}{ Walkers On Foot } & & \\ \hline \multicolumn{2}{|l|}{ Balance Sheet } & \multicolumn{2}{|l|}{ Income Statement } & & \\ \hline \multicolumn{2}{|l|}{ December 31, 2022} & \multicolumn{2}{|l|}{ For the Year ended December 31, 2022} & & \\ \hline Assets & & Revenue & & & \\ \hline Cash & $159,300.00 & Dog Walking Sales Revenue & $526,500.00 & & \\ \hline Accounts Receivable & 97500.00 & Total Revenue & 526500.00 & & \\ \hline Prepaid Insurance & 12000.00 & Expenses & & & \\ \hline Prepaid Rent & 28800.00 & Salary Expense & 279500.00 & & \\ \hline Fixed Assets & 95000.00 & Supplies Expense & 31000.00 & & \\ \hline \multirow[t]{2}{*}{ Total Assets } & $392,600.00 & Cleaning Expense & 20250.00 & & \\ \hline & & Customer Promotion Expense & 28900.00 & & \\ \hline Liabilities and Stckhldrs Equity & & Insurance Expense & 12000.00 & & \\ \hline Liabilities & & Rent Expense & 49000.00 & & \\ \hline Accounts Payable & $120,750.00 & Total Expenses & 420650.00 & & \\ \hline Salaries Payable & 0.00 & Net Income & $105,850.00 & & \\ \hline Unearned Revenue & 91000.00 & & & & \\ \hline Total Liabilities & 211,750 & & & & \\ \hline \multicolumn{6}{|l|}{ Stckhldrs Equity } \\ \hline Common Stock & 75000.00 & & & & \\ \hline Retained Earnings & 105850.00 & & & & \\ \hline Total Stckhldrs Equity & 180850.00 & & & & \\ \hline \multirow[t]{11}{*}{ Total Liabilities and Stckhldrs Equity } & $392,600.00 & & & & \\ \hline & & Walkers On Foot & & & \\ \hline & & Statement of Stockholders' Equity & & & \\ \hline & & For the Year ended December 31, 2022 & & & \\ \hline & & & Common Stock & Retained Earnings & Total \\ \hline & & Balance December 31, 2021 & 75,000 & 106,800 & $181,800 \\ \hline & & Common Stock Issued & & & 0.00 \\ \hline & & Net Income & & 105850.00 & 105850.00 \\ \hline & & Common Stock Repurchased & & 0.00 & 0.00 \\ \hline & & Dividends & & 0.00 & 0.00 \\ \hline & & Balance December 31, 2022 & 75,000 & 212,650 & $287,650 \\ \hline \end{tabular} REGULAR TRANSACTIONS NOT RECORDED YET: TRANSACTION 1 TRANSACTION 2 TRANSACTION 3 TRANSACTION 4 TRANSACTION 5 WOF sent customer promotional mailers worth $900 to potential customers in the area to attract new customers in hopes of starting off 2023 with a bang. WOF paid for and sent the mailers in December 2022. WOF landed a new corporate customer, Amazon, in December 2022 who wanted to pay $60,000 for a 12 month subscription to the dog walking service. The subscription starts on January 1, 2023. Amazon was very excited for the opportunity and they paid for the subscription in December 2022. WOF paid for insurance in advance for a new policy covering her dog walking business for the year of 2023 (January 1 - December 31). She paid cash of $12,000 for the policy. WOF bought bags, leashes, and treats amounting to $1,300 with her local pet supply warehouse in December 2022. During December, WOF had received a payment from collected $5,000 from a customer (who had previously paid on accounts) and did not record it. ADJUSTING TRANACTIONS NOT RECORDED YEL: NOTE: Adjusting entries are generally recorded every month, and_all prior month's entries have been properly recorded. Only the below AJE's for December still need to be recorded. TRANSACTION 1 TRANSACTION 2 TRANSACTION 4 TRANSACTION 5 TRANSACTION 1 WOF pays their employees every Tuesday. The 2022 year ended on a Friday, but they did not pay the employees for the three days they worked in 2022 until the following week (which was in January 2023). This amount totaled $24,500. WOF pre-paid the December 2022 rent, but did not record the rent expense for the office for the month of December 2022 of $5,000. WOF had cleaning services done in December 2022. Ryan found the invoice on his desk for $750 and it was not due until January. WOF did not send an invoice to a customer for the month of December 2022 dog walking services of $7,500. WOF noticed in the unearned revenue balance, that $14,000 of the balance was earned by dog walking for her customers in December 2022. Ryan had not recorded this yet. \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{2}{|l|}{ Walkers On Foot } & \multicolumn{2}{|l|}{ Walkers On Foot } & & \\ \hline \multicolumn{2}{|l|}{ Balance Sheet } & \multicolumn{2}{|l|}{ Income Statement } & & \\ \hline \multicolumn{2}{|l|}{ December 31, 2022} & \multicolumn{2}{|l|}{ For the Year ended December 31, 2022} & & \\ \hline Assets & & Revenue & & & \\ \hline Cash & $159,300.00 & Dog Walking Sales Revenue & $526,500.00 & & \\ \hline Accounts Receivable & 97500.00 & Total Revenue & 526500.00 & & \\ \hline Prepaid Insurance & 12000.00 & Expenses & & & \\ \hline Prepaid Rent & 28800.00 & Salary Expense & 279500.00 & & \\ \hline Fixed Assets & 95000.00 & Supplies Expense & 31000.00 & & \\ \hline \multirow[t]{2}{*}{ Total Assets } & $392,600.00 & Cleaning Expense & 20250.00 & & \\ \hline & & Customer Promotion Expense & 28900.00 & & \\ \hline Liabilities and Stckhldrs Equity & & Insurance Expense & 12000.00 & & \\ \hline Liabilities & & Rent Expense & 49000.00 & & \\ \hline Accounts Payable & $120,750.00 & Total Expenses & 420650.00 & & \\ \hline Salaries Payable & 0.00 & Net Income & $105,850.00 & & \\ \hline Unearned Revenue & 91000.00 & & & & \\ \hline Total Liabilities & 211,750 & & & & \\ \hline \multicolumn{6}{|l|}{ Stckhldrs Equity } \\ \hline Common Stock & 75000.00 & & & & \\ \hline Retained Earnings & 105850.00 & & & & \\ \hline Total Stckhldrs Equity & 180850.00 & & & & \\ \hline \multirow[t]{11}{*}{ Total Liabilities and Stckhldrs Equity } & $392,600.00 & & & & \\ \hline & & Walkers On Foot & & & \\ \hline & & Statement of Stockholders' Equity & & & \\ \hline & & For the Year ended December 31, 2022 & & & \\ \hline & & & Common Stock & Retained Earnings & Total \\ \hline & & Balance December 31, 2021 & 75,000 & 106,800 & $181,800 \\ \hline & & Common Stock Issued & & & 0.00 \\ \hline & & Net Income & & 105850.00 & 105850.00 \\ \hline & & Common Stock Repurchased & & 0.00 & 0.00 \\ \hline & & Dividends & & 0.00 & 0.00 \\ \hline & & Balance December 31, 2022 & 75,000 & 212,650 & $287,650 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started