Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Lakota Freight Co. UNADJUSTED TRIAL BALANCE March 31, 2047 ACCOUNT TITLE DEBIT CREDIT 1 Cash 12,000.00 30,000.00 3,600.00 2 Supplies 3 Prepaid Insurance 4 Equipment

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Lakota Freight Co. UNADJUSTED TRIAL BALANCE March 31, 2047 ACCOUNT TITLE DEBIT CREDIT 1 Cash 12,000.00 30,000.00 3,600.00 2 Supplies 3 Prepaid Insurance 4 Equipment 5 Accumulated Depreciation-Equipment 110,000.00 25,000.00 6 Trucks 60,000.00 15,000.00 4,000.00 96,000.00 7 Accumulated Depreciation-Trucks 8 Accounts Payable 9 Kaya Tarango, Capital 10 Kaya Tarango, Drawing 11 Service Revenue 12 Wages Expense 15,000.00 160,000.00 13 Rent Expense 45,000.00 10,600.00 9,000.00 4,800.00 14 Truck Expense 15 Miscellaneous Expense 16 Totals 300,000.00 300,000.00 The data needed to determine year-end adjustments are as follows: Supplies on hand at March 31 are $7,500. Insurance premiums expired during the year are $1,800. Depreciation of equipment during the year is $8,350. Depreciation of trucks during the year is $6,200. Wages accrued but not paid at March 31 are $600. Required: 1. A. Download the spreadsheet in the Ledger panel and save the Excel file to your computer. Use the spreadsheet to post the adjusting and closing entries from the journal to a ledger of four-column accounts. Be sure to save your work in Excel. Your input into the spreadsheet will not be included in your grade in CengageNOW on this problem. B. For each account listed in the unadjusted trial balance, enter the balance in the appropriate Balance column of a four-column account and enter X'in the Post. Ref. column. Enter Balance in the ITEM column. 2. (Optional) on your own paper or spreadsheet, enter the unadjusted trial balance on an end-of-period work sheet and complete the work sheet. Find a blank end-of-period work sheet in the Excel spreadsheet you previously downloaded. 3. A. Journalize the adjusting entries on Page 26 of the journal. Adjusting entries are recorded on March 31. Refer to the chart of accounts for the exact wording of the account titles. CNOW journals do not use lines for journal explanations. Every line on a journal page is used for debit or credit entries. CNOW journals will automatically indent a credit entry when a credit amount is entered. B. Post the adjusting transactions from the journal to a ledger of four-column accounts, inserting balances in the accounts affected. Add the appropriate posting reference to the journal. 4. Prepare an adjusted trial balance. 5. If you completed the end-of-period work sheet, use the adjusted trial balance figures to prepare an income statement, a statement of owner's equity, and a balance sheet. If you didn't complete the end-of-period work sheet, use the ledger (the Excel spreadsheet) to 5. If you completed the end-of-period work sheet, use the adjusted trial balance figures to prepare an income statement, a statement of owner's equity, and a balance sheet. If you didn't complete the end-of-period work sheet, use the ledger (the Excel spreadsheet) to prepare an income statement, a statement of owner's equity, and a balance sheet.* 6. A. Journalize the closing entries on page 27 of the journal. Refer to the chart of accounts for the exact wording of the account titles. CNOW journals do not use lines for journal explanations. Every line on a journal page is used for debit or credit entries. CNOW journals will automatically indent a credit entry when a credit amount is entered. (Note: Complete the adjusted trial balance, the income statement, the statement of owner's equity, and the balance sheet BEFORE completing part 6. A.) B. Post the closing entries to the ledger of four-column accounts, inserting balances in the accounts affected. Add the appropriate posting reference to the journal. 7. Prepare a post-closing trial balance. * Be sure to read the instructions for each financial statement carefully

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

Accounting And Financial System Reform In Eastern Europe And Asia

Authors: Robert W. McGee, Galina G. Preobragenskaya

2nd Edition

0387257098, 9780387257099

More Books

Students also viewed these Accounting questions