Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Am I doing this right? MUFC Company is a sporting goods retailer with a December 31 year end. In the Project Module on Canvas there

Am I doing this right? MUFC Company is a sporting goods retailer with a December 31 year end. In the Project Module on Canvas there are files for the project ledger, project journal, the trial balance at December 23 along with templates for other trial balances and financial statements. Below you will be given the transactions for the last week of 2022 and the information for any required adjusting entries for 2022. You are to do the following: Journalize and post the remaining 2022 transactions Prepare a trial balance at December 31, 2022 Journalize and post the required adjusting entries Prepare an adjusted trial balance at December 31, 2022 Prepare a multi-step income statement for 2022 Prepare a statement of retained earnings for 2022 Prepare a classified balance sheet for December 31, 2022 Journalize and post the necessary closing entries at December 31, 2022 Prepare a post-closing trial balance All these are to be completed in the Excel spreadsheets shown in the Project Module on Canvas. Your final solution should be the completed Excel spreadsheets and they are to be submitted either through Canvas or email. image text in transcribed

Remaining December transactions: Dec. 24 Paid employees for the previous two weeks work, $4,200 Dec 26 Paid $6,860 to CP Company for inventory purchased on December 15, the inventory had a list price of $7,000 and the terms were 2/15, n/30 Dec 28 Sold merchandise to NF Company for $8,000 cash. The merchandise cost $5,900. Dec 29 Purchased $600 of office supplies for cash Dec 29 Received payment from AV Company for sale of merchandise on December 16. The sales price was $2,500 and the terms were 2/10, n/30. Dec 30 Sold merchandise to AFC Company for $10,000 on account. The terms are 3/15, n/45. The merchandise cost $7,500. Dec 30 Wrote off WHU Companys account as uncollectible. The sale to WHU occurred on June 20, 2022. The amount of the sale was $3,000 and the terms were n/30. Dec 31 Purchased $9,000 of merchandise inventory from MCFC Company. The terms are 2/10, n/45.

image text in transcribed image text in transcribed

Information for year-end adjusting entries: On December 31, there are $800 of office supplies on hand MUFC borrowed the $120,000 on July 1, 2022. MUFC must make annual interest payments each September 30 and pay the full note on September 30, 2025. The interest rate on the note is 7%. Employees have earned $1,400 in wages for work done since the last payday (December 24) The prepaid rent was paid on April 1, 2022, and covers a one-year period starting on April 1, 2022. MUFC paid $2,100 for a one-year insurance policy on August 1, 2022. Coverage began on that date. The Building has a twenty-five year useful life and a $10,000 salvage value. The Equipment has an eight-year useful life and no salvage value. MUFC uses straight-line to depreciate its plant assets. December utilities are $480 and will be paid in January MUFC estimates its bad debts at 1% of its sales.

Check Figures: December 31 Trial Balance Debits and Credits = $1,010,560 December 31 Adjusted Trial Balance Debits and Credits = $1,042,267 Net Income = $2,068 Total Assets = $402,258 Post-Closing Trial Balance Debits and Credits = $524,985

===============================================

image text in transcribedimage text in transcribed

ASSETS^

image text in transcribed

LIABILITIES^

image text in transcribed

EQUITY^

image text in transcribed

REVENUE^

image text in transcribed

EXPENSES^

Dec. 24: To record payment to workers for previous two weeks work Debit Wages Expense for $4,200 Credit Cash for $4,200 Dec 26: To record purchase of inventory from KP Company with 2/15, n/30 terms Debit Inventory for $6,860 Credit Accounts Payable for $6,860 Dec 28: To record sale of merchandise to MF Company for $8,000 cash Debit Cash for $8,000 Credit Sales Revenue for $8,000 Debit Cost of Goods Sold for $5,900 Credit Inventory for $5,900 Dec 29: To record purchase of office supplies for cash Debit Office Supplies for $600 Credit Cash for $600 Dec 29: To record receipt of payment from AW Company for sale of merchandise with 2/10, n/30 terms Debit Cash for $2,450([$2,500($2,5000.02)]) Credit Accounts Receivable for $2,500 Dec 30: To record sale of merchandise to APC Company on account with 3/15,n/45 terms Debit Accounts Receivable for $9,700([$10,000 - ($10,0000.03)]) Credit Sales Revenue for $10,000 Debit Cost of Goods Sold for $7,500 Credit Inventory for $7,500 Dec 30: To record writing off WHY Company's account as uncollectible Debit Bad Debt Expense for $3,000 Credit Accounts Receivable for $3,000 Dec 31: To record purchase of merchandise inventory from MSPC Company with 2/10, n/45 term Debit Inventory for $8,820([$9,000($9,0000.02)]) Credit Accounts Payable for $8,820 Trial Balance - December 31 \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Accounts Payable } & & & \multicolumn{2}{|c|}{201} \\ \hline & & & & \multicolumn{2}{|c|}{ Balance } \\ \hline date & Post Ref & debit & credit & debit & credit \\ \hline & & & & & 26,610 \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Wages Payable } & & & & 202 \\ \hline & & & & \multicolumn{2}{|c|}{ Balance } \\ \hline date & Post Ref & debit & credit & debit & credit \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Interest Payable } & & & & 203 \\ \hline \multicolumn{2}{|l|}{} & & & & \multicolumn{2}{|c|}{ Balance } \\ \hline date & Post Ref & debit & credit & debit & credit \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Utilities Payable } & & & & 205 \\ \hline \multicolumn{2}{|l|}{} & & & & \multicolumn{2}{|c|}{ Balance } \\ \hline date & Post Ref & debit & credit & debit & credit \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Notes Payable } & & & & 210 \\ \hline \multicolumn{2}{|l|}{} & & & & \multicolumn{2}{|c|}{ Balance } \\ \hline date & Post Ref & debit & credit & debit & credit \\ \hline & & & & & 120,000 \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Common Stock } & & & & \multicolumn{2}{|c|}{301} \\ \hline & & & & \multicolumn{2}{|c|}{ Balance } \\ \hline date & Post Ref & debit & credit & debit & credit \\ \hline & & & & & 200,000 \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|r|} \hline \multicolumn{2}{|l|}{ Retained Earnings } & & & \multicolumn{2}{|r|}{302} \\ \hline & & & & \multicolumn{2}{|c|}{ Balance } \\ \hline date & Post Ref & debit & credit & debit & credit \\ \hline & & & & & 53,100 \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Dividends } & & & \multicolumn{2}{|r|}{305} \\ \hline \multicolumn{2}{|l|}{} & & & & \multicolumn{2}{|c|}{ Balance } \\ \hline date & Post Ref & debit & credit & debit & credit \\ \hline & & & & 5,500 & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{2}{|l|}{ Income Summary } & & & & \\ \hline \multicolumn{2}{|l|}{} & & & & \multicolumn{2}{|c|}{350} \\ \hline date & Post Ref & debit & credit & debit & credit \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{l} \multicolumn{2}{c|}{ A } & & \multicolumn{2}{c|}{ C } & \multicolumn{1}{c|}{D} & \multicolumn{2}{c|}{E} & \multicolumn{2}{c|}{401} \\ \hline \end{tabular} \begin{tabular}{l|llll|l|} \hline Sales & & & & \multicolumn{2}{|c|}{ Balance } \\ \hline & & & & debit & credit \\ \hline \end{tabular} 9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions