WORKSHEET FORMULAS NEEDED FALL 2018 This project wil be submitted in 3 parts. Th

Question

WORKSHEET FORMULAS NEEDED

FALL 2018 This project wil be submitted in 3 parts. The submission dates and required parts to be completed for each submission are: Submission 1 - due Saturday September 15 before 5pm - You must submit your completed July Journal entries, the Worksheet complete through the Trial Balance, and the worksheet formulas tab complete through the Trial Balance. Your file must be named correctly - "Your name (first and last) Project 1 part 1. Failure to name your file correctly will result in a 1 point deduction Submission 2 - due Saturday September 22 before 5pm - You must submit your completed Adjusting Journal Entries, the worksheet with the Trial Balance and adjustments and Adjusted Trial Balance Columns, and the Worksheet formulas tabs completed. Your file must be named correctly- "Your name (first and last) Project 1 part 2. Failure to name your file correctly will result in a 1 point deduction Submission 3 - due Saturday September 29 before 5pm - You must submit your completed Closing entries, the financial statements completed, and the financial statements formulas tab completed. Your file must be named correctly - "Your name (first and last) Project 1 part 3. Failure to name your file correctly will result in a 1 point deduction

Explanation / Answer

Journal Entries WORKSHEET Date Particulars Debit$ Credit$ opening July Adjustments Final Balance 01-Jul cash A/c 25000 Particulars Debit Credit Debit Credit Debit credit Debit credit To bank(long term notes Payable) 25000 Cash 120500 22065 142565 Accounts receivable 4100 5980 10080 02-Jul office furniture A/c 9865 Supplies 8975 10660 14850 4785 To cash 9865 Prepaid Rent 13800 1150 12650 Land 30000 30000 04-Jul Office rent A/c 13800 Computer Equipment 49500 49500 To cash 13800 Accumulated Dep,computer 140 140 Office furniture 9865 9865 08-Jul Cash A/c 11400 Accumulated Dep,office furniture 120 120 To Unearned revenue 11400 Accounts Payable 8975 1685 10660 salaries Payable 1540 1540 10-Jul Utilities A/c 1275 Interest Payable 125 125 To Cash 1275 Unearned Revenue 11400 950 10450 Long term notes payable 25000 25000 14-Jul Supplies (Purchase) A/c 8975 Common Stock 200000 200000 To cash 8975 Retained Earnings 12410 Dividends 1000 1000 15-Jul cash A/c 12750 Total 260445 260445 To Revenue 12750 15-Jul Accounts Receivable A/c 15780 To Income 15780 26-Jul cash A/c 11680 To Accounts Receivable A/c 11680 28-Jul Office supplies A/c 10660 To Accounts Payable A/c 10660 29-Jul Salaries 3850 To Cash 3850 31-Jul Dividends 1000 To Cash A/c 1000 Adjustment Enties at the end of july 31-Jul Accounts Receivable A/c 5980 To Income 5980 31-Jul Interest (Expense) 125 To Notes Payable 125 31-Jul Depreciation A/c 260 To Accumulated Depreciation 260 (140+120) 31-Jul Rent A/c 1150 To Prepaid Rent A/c 1150 31-Jul Salaries A/c 1540 To salaries Payable A/c 1540 31-Jul Unearned Revenue A/c Dr 950 To Revenue(Service for S-board) 950 31-Jul Supplies Expense A/c 14850 To Supplies A/c 14850

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.