Question


Information to prepare adjusting journal entries The following information relates to Gatsby, Inc. as of December 31 of the c
Credit 40,000 8,000 160,500 Gatsby, Inc. Unadjusted Trial Balance 12/31/XX Debit Cash 121,550 Accounts Receivable 236,000 Pre
All work must be completed using this Excel spreadsheet. Al journal extries, financial statements, etc. must be prepared in d
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer for the Part-1 in the given Question in the following two images:

- 7 X X Cut Copy - 2 Clear Sort & Find & 0 . New Microsoft Excel Worksheet - Microsoft Excel (Product Activation Failed File

0 New Microsoft Excel Worksheet - Microsoft Excel (Product Activation Failed . Home - 7 X File Insert Page Layout Formulas Da

PART-2:
Recording the adjusting entries of Gatsby Inc., as on Dec 31,XX :
Adjustment Account Debit($) Credit($)
A. Wages Account ($3,000*(2/5))          1,200
Wages Payable Account        1,200
(Being Wage expense till Dec-31 got accrued)
B. Depreciation on equipment Account        16,000
Accumulated Depreciation on equipment Account      16,000
(Being Depreciation for the current year recorded)
C. Unearned Revenue Account        30,000
Revenue Account((45,000/3)*2)      30,000
(Being revenue recognised as the job completed for 2 alarm systems)
D. Insurance expense Account((12,000/12)*3)          3,000
Prepaid Insurance Account        3,000
(Being Insurance expense of the October, November, December recorded)
E. Accounts Receivable Account        29,000
Revenue Account      29,000
(Being Unrecorded Revenue recorded on completion of job)
F. Interest Expense Account ((150,000*5%)*6/12)          3,750
Interest Payable Account        3,750
(Being Interest expense on Long term Note Payable caluclated and recorded for the current year)
G. Supplies expense Account          4,300
Supplies Account        4,300
(Being Supplies Expense recorded)
H. Depreciation on Builidings Account        10,000
Accumulated Depreciation on Builidings Account      10,000
(Being Depreciation for the current year recorded)
Add a comment
Know the answer?
Add Answer to:
Information to prepare adjusting journal entries The following information relates to Gatsby, Inc. as of Decembe...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • part 3 and 4 a,b,c part 6, 7 need done asap! All work must be completed...

    part 3 and 4 a,b,c part 6, 7 need done asap! All work must be completed using this Excel spreadsheet. Al journal extries, financial statements, etc. must be prepared in cean, proper form. Reference your textbook and past courses for examples or templates to model Use the current year for dating purposes. This project is valued at 120 points. The grading rubric is available on the last sheet labeled "Grading Rubric." Information on using Excel can be found in the...

  • need part 3, 4, 6, 7 help All work must be completed using this Excel spreadsheet....

    need part 3, 4, 6, 7 help All work must be completed using this Excel spreadsheet. All journal extries, financial statements, etc. must be prepared in clean, proper form. Reference your textbook and past courses for examples or templates to mod Use the current year for dating purposes. This project is valued at 120 points. The grading rubric is available on the last sheet labeled "Grading Rubric." Information on using Excel can be found in the Excel Notes section below....

  • I need help with Part 6 (closing journal entries) and Part 7 (post closing trial balance)...

    I need help with Part 6 (closing journal entries) and Part 7 (post closing trial balance) 3:02 PM Thu Feb 27 4796% AC 321 Intl - FA19 - Comprehensive Project Insert Draw Formulas Data Review View 8 Q o Calibri (Body) 12 B U Home B ^ A = 1 EE tx ã į 19 2 3 4 All work must be completed using this Excel spreadsheet. All journal extries, financial statements, etc. must be prepared in clean, proper form....

  • The question I need help/answer with is the 3rd photo. The first two photos just aid...

    The question I need help/answer with is the 3rd photo. The first two photos just aid the 3rd Comprehensive Properties All work must be completed using this Excel spreadsheet Al journal entries francial statements, et must be prepared in dean, proper form. Reference your textbook and past courses for examples or templates to model Uue the current year for din purpose This project is W ed 120 points. The grading rubricis valable on the last sheet labeled "Grading brie Wformation...

  • QUESTION 1 Required: #1. Prepare journal entries to record the December transactions in the General Journal...

    QUESTION 1 Required: #1. Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation, Accounts Payable, Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent Expense, and Insurance Expense. 1-Dec Began business by depositing $10000 in a bank account in the name of the company in...

  • (1) Prepare adjusting journal entries for the company using the information given on the "Adjusting Journal...

    (1) Prepare adjusting journal entries for the company using the information given on the "Adjusting Journal Entries" tab. (You may also need to refer to the "Trial Balance" tab.) Use formulas for your calculations, where possible. (2) Link the adjusting journal entries into the "Trial Balance" tab (see appropriate column), and use Excel formulas to calculate the 12/31/2018 Adjusted balances. (3) Using formulas that link back to the "Trial Balance" tab, prepare a Classified Balance Sheet and Multi-Step Income Statement...

  • I am in desperate need of help with this project. Apparently my answers are all wrong....

    I am in desperate need of help with this project. Apparently my answers are all wrong. 3:02 PM Thu Feb 27 4796% AC 321 Intl - FA19 - Comprehensive Project Insert Draw Formulas Data Review View 8 Q o Calibri (Body) 12 B U Home B ^ A = 1 EE tx ã į 19 2 3 4 All work must be completed using this Excel spreadsheet. All journal extries, financial statements, etc. must be prepared in clean, proper form....

  • "Prepare Adjusting Journal Entries (given the information below), then an Adjusted Trial Balance given said information....

    "Prepare Adjusting Journal Entries (given the information below), then an Adjusted Trial Balance given said information. Prepare an Income statement, Retained Earnings, Statement, and a Classified Balance Sheet (in this order). Finally, answer the following questions: 1) 'What is the dollar amount for Net Income or Net loss?' 2) 'What is the dollar amount for Ending Retained Earning?' 3) 'What is the amount for total Current Assets?' 4) 'What is the dollar amount for Total Current Liabilities?' 5) 'What is...

  • C4-2 From Recording Transactions including Adjusting Journal Entries to Preparing Financial Statements and Closing Journal Entries...

    C4-2 From Recording Transactions including Adjusting Journal Entries to Preparing Financial Statements and Closing Journal Entries (Chapters 2.2 and 4 LO 2-39.339.410.429.439.449.459.469 Brothers Harry and Herman Hauserday began operations of the machine shop Tool, Inc.) on January 1, 2016. The annual reporting period ends December 31. The trial balance on January 1, 2018, follows the amounts are rounded to thousands of dollars to simply Account Titles Debt Credit 53 Accounts Receivable Supplies Land Equipe Accumulated Depreciation Software 15 Accumulated Amortization...

  • Complete the worksheet using the excel file. Add your adjusting journal entries and complete the adjusted...

    Complete the worksheet using the excel file. Add your adjusting journal entries and complete the adjusted trial balance. Do not do the financial statements, closing entries, or post-close trial balance. The information for the adjusting journal entries are at the bottom of the tab- "adjusting entries" Adjusting Journal Entries Info. Insurance that expired during December was $275.00 A physical count of the supplies indicated that $715.00 were on hand. Depreciation on office equipment for the period was $330.00 Salaries worked...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT