Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please create a Genaral Journal, Income Statement, and Balance Sheet based on the information given below. Q: Great Adventures General Ledger (Algo) i)

Can you please create a Genaral Journal, Income Statement, and Balance Sheet based on the information given below.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Q: Great Adventures General Ledger (Algo) i) Prepare the journal entries for transactions. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) 2 Record the first monthly payment on the long-term note payable, made on November 30,2022. Prepare an income statement for the period ended December 31,2022 . Choose the appropriate accounts to complete the company's income statement. The unadjusted, or post-closing balances will appear for each account, based on your selection. Notice the dropdown below that gives the options to select the unadjusted, or post-closing trial balance. The option you choose will be the values used to populate the income statement and balance sheet tabs. Each journal entry is posted automatically to the general ledger. The unadjusted, or post-closing balances will appear for each account, based on your selection. Tony's favorite memories of his childhood were the times he spent with his dad at camp. Tony was daydreaming of those days a bit as he and Suzie jogged along a nature trail and came across a wonderful piece of property for sale. He turned to Suzie and said, "T've always wanted to start a camp where families could get away and spend some quality time together. If we just had the money, I know this would be the perfect place." On November 1, 2022, Great Adventures purchased the land by issuing a $900,000,6%,10year installment note to the seller. Payments of $9,992 are required at the end of each month over the life of the 10-year loan. Each monthly payment of $9,992 includes both interest expense and principal payments (i.e., reduction of the loan amount). Late that night Tony exclaimed, "We now have land for our new camp; this has to be the best news everl" Suzie said, "There's something else I need to tell you. I'm expectingl" They decided right then, if it was a boy, they would name him Venture. 1. Record each of the transactions listed above in the 'General Journal' tab. Review the 'General Ledger' and the 'Trial Balance' tabs to see the effect of the transactions on the account balances. 2. Prepare an income statement for the period ended December 31, 2022, in the 'Income Statement' tab. 3. Prepare a classified balance sheet as of December 31,2022 in the 'Balance Sheet' tab. 4. Record the closing entries in the 'General Journal' tab. \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Depreciation Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 19,250 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Salaries Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 34,000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Interest Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 2,800 \\ \hline \end{tabular} Income Tax Expense \begin{tabular}{|r|r|r|r|r|} \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 16,500 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Repairs and Maintenance Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & 800 \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 16,000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Supplies Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 1,500 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Bad Debt Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 3.400 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Rent Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 4,400 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Insurance Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 7,700 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Warranty Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 8,000 \\ \hline \end{tabular} General Journal Trial Balance \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Interest Payable } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & Nov 01 & & & 1,750 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Income Tax Payable } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & Nov 01 & & & 16,500 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Deferred Revenue } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & Nov 01 & & & 9.000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Notes Payable (Current) } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 20,000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Notes Payable (Long-term) } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 24,000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Contingent Liability } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & Nov 01 & & & 16,000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Warranty Liability } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & Nov 01 & & & 8,000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Common Stock } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 20,000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Retained Earnings } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 35,450 \\ \hline \end{tabular} \begin{tabular}{|r||c|c|r|r|} \hline \multicolumn{5}{|c|}{ Service Revenue } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 46,500 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Sales Revenue } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 160,000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Sales Discounts } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 550 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline & & 16,500 \\ \hline - Dererrea Revenue & & 9,000 \\ \hline Notes Payable (Current) & & 20,000 \\ \hline Soles Payable (Long-term) & & 24,000 \\ \hline Contingent Liability & & 16,000 \\ \hline Warranty Liability & & 8,000 \\ \hline Common Stock & & 20,000 \\ \hline Retained Earnings & & 35,450 \\ \hline Q Service Revenue & & 46,500 \\ \hline Sales Revenue & & 160,000 \\ \hline QSales Discounts & 550 & \\ \hline Binterest Revenue & & 520 \\ \hline Cost of Goods Sold & 40,500 & \\ \hline Depreciation Expense & 19,250 & \\ \hline Asupplies Expense & 1,500 & \\ \hline QSaiaries Expense & 34,000 & \\ \hline EBadDebtExponse & 3,400 & \\ \hline EinterestExpense & 2,800 & \\ \hline QRent Expense & 4,400 & \\ \hline Eincorne Tax Expense & 16,500 & \\ \hlineEinsuranceExpense & 7,700 & \\ \hline Prepairs and Maintenance Expense & 800 & \\ \hline Warranty Expense & 8,000 & \\ \hline QLoss & 16,000 & \\ \hline Total & 414,570 & 414,570 \\ \hline \end{tabular} Prepare the journal entries for transactions. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) 1 Record the issuance of the long-term note payable for the purchase of land on November 1, 2022. 2 Record the first monthly payment on the long-term note payable, made on November 30, 2022. 3 Record the second monthly payment on the long-term note payable, made on December 31, 2022. 4. The 12 monthly payments in 2023 (following year) will reduce the note's balance by an additional $68,424. Record the reclassification of this amount from long-term notes payable to current notes payable. 5. Prepare the closing entry for revenue accounts. \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Interest Revenue } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 520 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Cost of Goods Sold } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 40,500 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Depreciation Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 19,250 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Supplies Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 1,500 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Salaries Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 34,000 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Bad Debt Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 3,400 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Interest Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 2,800 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Rent Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 4,400 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Income Tax Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 16,500 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Insurance Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 7,700 \\ \hline \end{tabular} Repairs and Maintenance Expense \begin{tabular}{|r|c|c|c|r|} \hline \multicolumn{5}{|c|}{ Repairs and Maintenance Expense } \\ \hline No. & Date & Debit & Credit & Balance \\ \hline & & & & 800 \\ \hline \end{tabular} \begin{tabular}{|r|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Warranty Expense } \\ \hline No. & Date & Debit & Credit & Batance \\ \hline & & & & 8,000 \\ \hline \end{tabular} Loss

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_2

Step: 3

blur-text-image_3

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

Financial Accounting

Authors: Charles T. Horngren, Jr. Harrison, Walter T.

2nd Edition

0133118207, 978-0133118209

More Books

Students also viewed these Accounting questions

Question

What leadership style would best characterize Adam Neumann?

Answered: 1 week ago