The unadjusted trial balance of Lakota Freight Co. at March 31, 2017, the end of the year, follows: Lakota Freight Co. UNADJUSTED TRIAL BALANCE March 31, 2017 DEBIT CREDIT ACCOUNT TITLE 1 Cash 12,000.00 30,000.00 2 Supplies 3 Prepaid Insurance 3,600.00 110,000.00 4 Equipment s Accumulated Depreciation Equipment 25,000.00 & Trucks 60,000.00 7 Accumulated Depreciation-Trucks 15,000.00 Accounts Payable 4,000.00 9 Kaya Tarango, Capital 96,000.00 10 Kaya Tarango, Drawing 15,000.00 21 Service Revenue 160,000.00 19 Wages Expense 45,000.00 13 Rent Expense 10,600.00 14 Truck Expense 9,000.00 15 Miscellaneous Expense 4,800.00 16 Totals 500,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 tnal 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. Joumalize 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 joumal 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 prepare an income statement a statement of owner's equity and a balance sheet. CHART OF ACCOUNTS Lakota Freight Co. General Ledger ASSETS REVENUE 11 Cash 41 Service Revenue 13 Supplies 14 Prepaid Insurance EXPENSES 16 Equipment 51 Wages Expense 52 Supplies Expense 17 Accumulated Depreciation-Equipment 18 Trucks 53 Rent Expense 54 Truck Expense 19 Accumulated Depreciation-Trucks 55 Depreciation Expense-Equipment LIABILITIES 50 Depreciation Expense-Trucks 21 Accounts Payable 57 Insurance Expense 22 Wages Payable 59 Miscellaneous Expense EQUITY 31 Kaya Tarango. Capital 32 Kaya Tarango. Drawing 33 Income Summary Labels Current assets Current liabilities Expenses For the Year Ended March 31, 2017 March 31, 2017 Property, plant, and equipment Revenues Amount Descriptions Decrease in owner's equity Increase in owner's equity Kaya Tarango, capital, April 1, 2048 Kaya Tarango, capital, March 31, 2047 Net income Net loss Total assets Total current assets Total expenses Total liabilities Total liabilities and owner's equity Total property, plant and equipment Withdrawals 3. A Joumalize the adjusting entries on Page 26 of the joumal. Adjusting entries are recorded on March 31. Refer to the Chart of Accounts for account titles 3. B. Add the appropriate posting reference to the joumal 6. A. Joumalize the closing entries on page 27 of the journal. Refer to the Chart of Accounts for account titles. (Note: Complete the adjusted trial balance, the income statement, the statement of owner's equity, and the balance sheet BEFORE completing part 6. A.) 6. B. Add the appropriate posting reference to the journal. Refer to the chart of accounts for the exact wording of the account titles. CNOW joumals do not use lines for joumal explanations. Every line on a joumal page is used for debit or credit entries. CNOW joumals will automatically indent a credit entry when a credit amount is entered. Note: Scroll down for page 27 of the journal. PAGE 26 JOURNAL ACCOUNTING EQUATION DATE DESCRIPTION POST. REF. DEBIT CREDIT ASSETS LIABILITIES Adjusting Entries EQUITY 2 PAGE 27 JOURNAL ACCOUNTING EQUATION DATE DESCRIPTION POST. REF. DEBIT CREDIT ASSETS LIABILITIES EQUITY 1 Closing Entries 2 13 5 11 Adjusted Trial Balance 4. Prepare an adjusted trial balance. Lakota Freight Co. ADJUSTED TRIAL BALANCE March 31, 2017 DEBIT CREDIT ACCOUNT TITLE 1 Cash 2 Supplies 3 Prepaid Insurance 4 Equipment 5 Accumulated Depreciation-Equipment 6 Trucks 1 Accumulated Depreciation-Trucks 8 Accounts Payable 9 Wages Payable 30 Kaya Tarango. Capital Kaye Tarango, Drawing 12 Service Revenue 33 Wages Expense Supplies Expense 15 Rent Expense ** Truck Expense 37 Depreciation Expense-Equipment 4 Depreciation Expense Trucks 9 Insurance Expense 10 Miscellaneous Expense 21 Totals 5. If you completed the end-of-period work sheet, use the adjusted trial balance figures to prepare an income statement for the year ended March 31, 2017. If you didn't complete the end-of-period work sheet, use the ledger (the Excel spreadsh prepare an income statement for the year ended March 31, 2017. Be sure to complete the statement heading. Refer to the Chart of Accounts and the list of Labels and Amount Descriptions for the exact wording of the answer choices for text en amounts as positive numbers unless the amount is a calculation that results in a negative amount. For example: Net loss should be negative. Expenses should be positive. You will not need to enter colons() on the income statement Lakota Freight Co. Income Statement (Label) 2 (Label) 3 4 5 7 B 119 GI Statement of Owner's Equity 5. If you completed the end-of-period work sheet, use the adjusted trial balance figures to prepare a statement of owner's equity for the year ended March 31, 2017. If you didn't complete the end-of-period work sheet, use the ledger (the Excel spreadsheet) to prepare a statement of owner's equity for the year ended March 31, 2017. Be sure to complete the statement heading. Refer to the list of Labels and Amount Descriptions for the exact wording of the answer choices for text entnie those boxes in which you must enter subtracted negative numbers use a minus sign. Lakota Freight Co. Statement of Owner's Equity (Label) 1 2 3 5. If you completed the end-of-period work sheet, use the adjusted trial balance figures to prepare a balance sheet as of March 31, 2017. If you didn't complete the end of-period work sheet, use the ledger (the Excel spreadsheet) to prepare a balance sheet as of March 31, 2017. Be sure to complete the statement heading. Refer to the Chart of Accounts and the list of Labels and Amount Descriptions for the exact wording of the answer choices for text entries. You will not need to enter colons () or the word "Less" on the balance sheet, they will automatically insert where necessary. Enter all values as positive amounts Lakota Freight Co. Balance Sheet (Label) Assets 2 (Label) 3 3 5 6 7 Label) 19 10 12 Labilities 15 30 7. Prepare a post-closing trial balance. Lakota Freight Co. POST-CLOSING TRIAL BALANCE March 31, 2017 DEBIT CREDIT ACCOUNT TITLE 1 Cash 2 Supplies 3 Prepaid Insurance 4 Equipment 5 Accumulated Depreciation-Equipment 6 Trucks 2 Accumulated Depreciation-Trucks Accounts Payable 9 Wages Payable to Kaya Tarango, Capital 4 Totals