Katelyn's Catering (Katelyn) provides food services for corporate events. In the month of December 2019, she...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Katelyn's Catering ("Katelyn") provides food services for corporate events. In the month of December 2019, she was very busy with catering events and didn't have time to keep up with her accounting records until she got a break at the end of the year. Katelyn asked her business friend, a Bentley student, to help her update her accounting records for the year ended December 2019. Katelyn has an unadjusted trial balance (see "Unadjusted Trial Balance" tab) with information. The Bentley student found that she still needed to record 5 regular transactional journal entries and 5 adjusting journal entries in order to close the books for the year (See the "Regular and AJE Info" tab). In order to close out the year-end, Katelyn needs help from the Bentley student as follows: 1. Prepare the 5 regular journal entries and the 5 AJE's (using proper debits and credits), showing them on the "Journal Entries" tab in this file. 2. Update the balances in the Unadjusted Trial Balance to reflect the journal entries recorded in #1 above. NOTE: This section will not be graded, but you want to pick a method of arriving at an Adjusted Trial Balance that is easiest for you. You can choose one of a few different ways: 1. Use the Financial Statement Effects Template (FSET) - See "FSET" tab in this file 2. Use T accounts to post your entries and arrive at ending balances - See "T Accounts" tab in this file. 3. Post the entries with an adjustments column to the right of the Unadjusted Trial Balance and add/subtract the debits and credits appropriately to arrive at two columns for an "Adjusted Trial Balance." Use the "Unadjusted Trial Balance" tab to build from there. 3. Prepare the following financial statements in proper form (see examples in your text). Place each financial statement on the applicable tab on this file. a. Income Statement b. Statement of Changes in Stockholders' Equity c. Balance Sheet SUBMISSION: * Please submit your solution to Problem Set #1 in an excel file through BlackBoard. There will be an assignment tab under Week 1 for submission of this Problem Set. Katelyn's Catering Unadjusted Trial Balance For the year ended 12/31/19 Cash Accounts Receivable Food Supplies Inventory Prepaid Rent Equipment Accumulated Depreciation Accounts Payable Interest Payable Unearned Revenue Notes Payable Common Stock Retained Earnings 1/1/19 Catering Revenue Salary Expense Food Supplies Expense Advertising Expense Rent Expense Insurance Expense Utilities Expense Interest Expense Depreciation Expense Total $ $ Unadjusted Trial Balance Debit Credit 71,000 44,000 25,000 13,000 60,000 75,000 60,000 0 11,000 5,500 6,000 1,000 500 $ 6,000 12,000 0 32,000 10,000 20,000 42,000 250,000 372,000 $ 372,000 0 Katelyn's Catering REGULAR JOURNAL ENTRIES: Transaction 1 Transaction 2 Transaction 3 Transaction 4 Transaction 5. Transaction 1 Transaction 2 Transaction 3 Transaction 4 Katelyn catered a holiday party for her neighbor in December, who paid her $1,000 in cash. ADJUSTING JOURNAL ENTRIES: NOTE: Adjusting entries are generally recorded every month, and all prior entries have been properly recorded. Only the below AJE's for December still need to be recorded. Transaction 5 Katelyn paid $3,500 of an accounts payable vendor balance in December. Katelyn returned some food supplies inventory to a vendor who reimbursed her $500 cash. Katelyn paid her employees their December monthly salaries of $22,000. Katelyn borrowed $20,000 from her bank in order to front the food supplies cost of a few large corporate events in 2020. Katelyn catered a New Year's Eve party and since the party went into 2020, she left an invoice with the host that night for $6,500 to pay her for the services by January 15, 2020. Katelyn realized she had done a few home events that she had taken deposits on but never recorded the revenue on $10,000 of events she provided in December. In prior months when Katelyn received the cash deposits, she had properly recorded them to unearned revenue. Katelyn and her Bentley student did a count of her food supplies inventory and found that the value of the Food Supplies Inventory was $10,000 at December 31, 2019. The Equipment has a useful life of 10 years and was purchased in 2018. No depreciation was recorded yet for 2019. The Note Payable of $10,000 was signed on December 1, 2019. One month's interest must be accrued. The interest rate is 6% per year (APR). Note is due on December 1, 2022. Katelyn's Catering FSET Template Beginning Balance Transaction 1 Transaction 2 Transaction 3 Transaction 4 Transaction 5 AJE 1 AJE 2 AJE 3 AJE 4 AJE 5 Ending Balance Cash Accounts Receivable Food Supplies Inventory Prepaid Rent Equipment NOTE: You can use this sheet as one of your methods to get to the Adjusted Trial Balance Accumulated Depreciation Accounts Payable Accounts Payable Interest Payable Unearned Revenue Notes Payable Common Stock Retained Earnings Catering Revenue Salary Expense Food Supplies Expense Rent Expense Insurance Expense Interest Expense Depreciation Expense Katelyn's Catering ("Katelyn") provides food services for corporate events. In the month of December 2019, she was very busy with catering events and didn't have time to keep up with her accounting records until she got a break at the end of the year. Katelyn asked her business friend, a Bentley student, to help her update her accounting records for the year ended December 2019. Katelyn has an unadjusted trial balance (see "Unadjusted Trial Balance" tab) with information. The Bentley student found that she still needed to record 5 regular transactional journal entries and 5 adjusting journal entries in order to close the books for the year (See the "Regular and AJE Info" tab). In order to close out the year-end, Katelyn needs help from the Bentley student as follows: 1. Prepare the 5 regular journal entries and the 5 AJE's (using proper debits and credits), showing them on the "Journal Entries" tab in this file. 2. Update the balances in the Unadjusted Trial Balance to reflect the journal entries recorded in #1 above. NOTE: This section will not be graded, but you want to pick a method of arriving at an Adjusted Trial Balance that is easiest for you. You can choose one of a few different ways: 1. Use the Financial Statement Effects Template (FSET) - See "FSET" tab in this file 2. Use T accounts to post your entries and arrive at ending balances - See "T Accounts" tab in this file. 3. Post the entries with an adjustments column to the right of the Unadjusted Trial Balance and add/subtract the debits and credits appropriately to arrive at two columns for an "Adjusted Trial Balance." Use the "Unadjusted Trial Balance" tab to build from there. 3. Prepare the following financial statements in proper form (see examples in your text). Place each financial statement on the applicable tab on this file. a. Income Statement b. Statement of Changes in Stockholders' Equity c. Balance Sheet SUBMISSION: * Please submit your solution to Problem Set #1 in an excel file through BlackBoard. There will be an assignment tab under Week 1 for submission of this Problem Set. Katelyn's Catering Unadjusted Trial Balance For the year ended 12/31/19 Cash Accounts Receivable Food Supplies Inventory Prepaid Rent Equipment Accumulated Depreciation Accounts Payable Interest Payable Unearned Revenue Notes Payable Common Stock Retained Earnings 1/1/19 Catering Revenue Salary Expense Food Supplies Expense Advertising Expense Rent Expense Insurance Expense Utilities Expense Interest Expense Depreciation Expense Total $ $ Unadjusted Trial Balance Debit Credit 71,000 44,000 25,000 13,000 60,000 75,000 60,000 0 11,000 5,500 6,000 1,000 500 $ 6,000 12,000 0 32,000 10,000 20,000 42,000 250,000 372,000 $ 372,000 0 Katelyn's Catering REGULAR JOURNAL ENTRIES: Transaction 1 Transaction 2 Transaction 3 Transaction 4 Transaction 5. Transaction 1 Transaction 2 Transaction 3 Transaction 4 Katelyn catered a holiday party for her neighbor in December, who paid her $1,000 in cash. ADJUSTING JOURNAL ENTRIES: NOTE: Adjusting entries are generally recorded every month, and all prior entries have been properly recorded. Only the below AJE's for December still need to be recorded. Transaction 5 Katelyn paid $3,500 of an accounts payable vendor balance in December. Katelyn returned some food supplies inventory to a vendor who reimbursed her $500 cash. Katelyn paid her employees their December monthly salaries of $22,000. Katelyn borrowed $20,000 from her bank in order to front the food supplies cost of a few large corporate events in 2020. Katelyn catered a New Year's Eve party and since the party went into 2020, she left an invoice with the host that night for $6,500 to pay her for the services by January 15, 2020. Katelyn realized she had done a few home events that she had taken deposits on but never recorded the revenue on $10,000 of events she provided in December. In prior months when Katelyn received the cash deposits, she had properly recorded them to unearned revenue. Katelyn and her Bentley student did a count of her food supplies inventory and found that the value of the Food Supplies Inventory was $10,000 at December 31, 2019. The Equipment has a useful life of 10 years and was purchased in 2018. No depreciation was recorded yet for 2019. The Note Payable of $10,000 was signed on December 1, 2019. One month's interest must be accrued. The interest rate is 6% per year (APR). Note is due on December 1, 2022. Katelyn's Catering FSET Template Beginning Balance Transaction 1 Transaction 2 Transaction 3 Transaction 4 Transaction 5 AJE 1 AJE 2 AJE 3 AJE 4 AJE 5 Ending Balance Cash Accounts Receivable Food Supplies Inventory Prepaid Rent Equipment NOTE: You can use this sheet as one of your methods to get to the Adjusted Trial Balance Accumulated Depreciation Accounts Payable Accounts Payable Interest Payable Unearned Revenue Notes Payable Common Stock Retained Earnings Catering Revenue Salary Expense Food Supplies Expense Rent Expense Insurance Expense Interest Expense Depreciation Expense
Expert Answer:
Answer rating: 100% (QA)
Begibal Tr3 Tr4 1x5 AdJE1 Ady E2 Ady IE 4 AdyTES Postal Table lash 71000 1000 3500 500 ... View the full answer
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date:
Students also viewed these finance questions
-
The expected sales for Uptown Clothing in the month of May are shown in the table below. Chelsea Rogers, the owner, gives credit to a select group of customers (20 percent of sales), but all others...
-
The expected sales for Uptown Clothing in the month of May are shown in the table below. Chelsea Rogers, the owner, gives credit to a select group of customers (20 percent of sales), but all others...
-
In the month of March, C. D. Goose, Inc. entered into the following transactions: Mar. 2 Bought a new building for $135,000. 3 Paid February utility bill of $860. 11 Issued common stock to investors...
-
Water flowing in a positive x-direction passes through a 90 elbow in a 6-inch-diameter pipeline and heads in a positive y-direction with a flow rate of 3.05 ft3/sec. Compute the magnitude and...
-
What is the formula for the Sharpe ratio for a portfolio of stocks and bonds with equal expected returns, i.e., E(RS) = E(RB), and a zero return correlation?
-
Consider the following transactions associated with accounts receivable and the allowance for uncollectible accounts. Required: For each transaction, indicate whether it would increase (I), decrease...
-
(a) Identify the four factors which cause fixed assets to depreciate. (6) Which one of these factors is the most important for each of the following assets? (i) a gold mine, (ii) a motor lorry, (ii1)...
-
Ethics and pricing. Instyle Interior Designs has been requested to prepare a bid to decorate four model homes for a new development. Winning the bid would be a big boost for sales representative Jim...
-
NO PAPER WORK ONLY TYPED ANSWERS NO PLAGARISM DONT USE CHAT GPT. Our company (Aztecs Inc) operates in two states California and Texas. Our state tax base is $750,000 and 80,000 respectively. In...
-
An increasing number of Americans are moving to a warmer climate when they retire. To take advantage of this trend, Sunny Skies Unlimited is undertaking a major real estate development project. The...
-
On July 1, Premiere Paints' Mixing Department had 80,000 units in Beginning Work-in-Process that were 80% complete. Between July 1 and July 31, the department transferred 150,000 units to the...
-
Henry Hitchcock is 40 years old today and he wishes to accumulate $540,000 by his 65 th birthday so he can retire to his summer place on Lake Hopatcong. He wishes to accumulate this amount by making...
-
Examine the principles of non-Newtonian fluid dynamics, discussing the unique rheological properties of non-Newtonian fluids, the challenges in modeling their behavior, and the practical applications...
-
Solve this by entering both the significand and the exponential term into your calculator. (3.2 x 106)2= |
-
What would be good thorough answers to the below questions? The role of the financial manager is crucial inevery type of organization. Locate a job posting for a financial manager position from any...
-
Discuss the environmental and sustainability aspects of fluid dynamics, exploring the impact of fluid flow on ecosystems, the role of fluid dynamics in pollutant dispersion and environmental...
-
Summary of key findings from skateholders 1. Engage in gathering feedback from the following skateholders about your professional practice as an educator in the Quality Area 4.2. Summarise the key...
-
Prove that if Σ an is absolutely convergent, then a. an
-
Endowment Effects and Housing Markets: In end-of-chapter exercises 6.9 and 7.6, we derived the curious prediction that homeowners are made better off by housing price fluctuations regardless of...
-
In Chapter 22, we briefly discussed the signaling role of educationi.e. the fact that part of the reason many people get more education is not to learn more but rather to signal high productivity to...
-
Governments often interfere in markets by placing restrictions on the price that firms can charge. One common example of this is so-called anti-price gauging laws that restrict profits for firms when...
-
Calculate \(2+3^{2} \times 4\).
-
Calculate \(21-4 \times 13\).
-
The daily low temperatures in Barrie, Ontario, for the week of February 14,2021 , were \(-20^{\circ},-12^{\circ},-15^{\circ},-23^{\circ},-17^{\circ},-13^{\circ}\), and \(-19^{\circ}\) degrees...
Study smarter with the SolutionInn App