Only questions 3,4,5 and can you please make the tables able to be copy and pasted into word for editing PR 4-4A Ledger accounts, adjusting entries, financial statements,and closing entries; optional spreadsheetThe unadjusted trial balance of Lakota Freight Co. at March 31, 20Y4, the end of the year, follows:Obj. 2, 3Lakota Freight Co.Unadjusted Trial BalanceMarch 31, 20Y4AccountDebitBalancesCreditBalancesNo.Cash.1112,000Supplies1330,000Prepaid Insurance..Equipment..Accumulated Depreciation-Equipment. .Trucks.....143,600110,000161725,0001860,000Accumulated Depreciation-TrucksAccounts Payable..Common Stock..Retained EarningsDividends.1915,000214,0003126,00070,000323315,000Service Revenue41160,000Wages Expense..Rent Expense.Truck ExpenseMiscellaneous Expense..5145,0005310,600549,000594,800300,000300,000The data needed to determine year-end adjustments are as follows:(a) Supplies on hand at March 31 are $7,500.(b) Insurance premiums expired during year are $1,800.(c) Depreciation of equipment during year is $8,350.(d) Depreciation of trucks during year is $6,200.(e) Wages accrued but not paid at March 31 are $600.Instructions1. For each account listed in the trial balance, enter the balance in the appropriate Balance col-umn of a four-column account and place a check mark () in the Posting Reference column.2. (Optional) Enterand complete the spreadsheet. Add the accounts listed in part (3) as needed,3. Journalize and post the adjusting entries, inserting balances in the accounts affected. Record theadjusting entries on Page 26 of the journal. The following additional accounts from Lakota FreightCo's chart of accounts should be used: Wages Payable, 22; Supplies Expense, 52; DepreciationExpense-Equipment, 55; Depreciation Expense–Trucks, 56; Insurance Expense, 57.4. Prepare an adjusted trial balance.5. Prepare an income statement, a statement of stockholders' equity, and a balance sheet. Duringthe year ended March 31, 20Y4, additional common stock of $6,000 was issued6. Journalize and post the closing entries. Record the closing entries on Page 27 of the journalIndicate closed accounts by inserting a line in both Balance columns opposite the closing entrythe unadjusted trial balanceend-of-period spreadsheetonan7. Prepare a post-closing trial balance.

The question is based on the concept of final accounts.

PR 4-4A Ledger accounts, adjusting entries, financial statements, and closing entries; optional spreadsheet The unadjusted trial balance of Lakota Freight Co. at March 31, 20Y4, the end of the Obj. 2, 3 year, follows: Lakota Freight Co. Unadjusted Trial Balance March 31, 20Y4 Account No. Debit Balances Credit Balances Cash..... 11 12,000 30,000 Supplies Prepaid Insurance. Equipment.. Accumulated Depreciation-Equipment.. 13 ..... 14 3,600 16 ...... 110,000 17 25,000 Trucks

PR 4-4A Ledger accounts, adjusting entries, financial statements, and closing entries; optional spreadsheet The unadjusted trial balance of Lakota Freight Co. at March 31, 20Y4, the end of the Obj. 2, 3 year, follows: Lakota Freight Co. Unadjusted Trial Balance March 31, 20Y4 Account No. Debit Balances Credit Balances Cash..... 11 12,000 30,000 Supplies Prepaid Insurance. Equipment.. Accumulated Depreciation-Equipment.. 13 ..... 14 3,600 16 ...... 110,000 17 25,000 Trucks

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Kindly describe and demonstrate how to close a database record.
Approved CAE_BSA BSMA BSAIS BSIA_ACC 124_Sombilon.Aguilar (1).pdf - Foxit Reader File Home Comment Fil & Sign View Form Protect Share Connect Help Tell me what you want to do... Find O SnapShot B Clipboard O Fit Page TI T 110.51% A Link File Attachment D Fit Width D Fit Visible Rotate Left Bookmark Le Image Annotation Hand Select Actual Reflow Typewriter Highlight Rotate Right | Audio & Video Size Tools View Comment Links Insert PDF 4 Word Convert Start Approved CAE_BSA BS... PDF 2 Word DAIF checks of customers returned by bank Error in recording a check in the book. The correct amount as paid by the bank is P100,000 instead of P200,000 as recorded in the book The correct cash balance under current assets on December 31, 2019 is 500,000 100,000 Problem 11 The accounts of DMCI Holdings, Inc. revealed the following facts on August 31,2019. Balance of bank statement 1,200,000 Outstanding checks, August 31: Number 555 10,000 55,000 40,000 25,000 65,000 70,000 275,000 761 UM 762 763 764 765…
Attached are two pictures. The first picture has the instructions (3 pages) and the second picture is a screenshot of an excel spreadsheet that need the "formulas".
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
Create a SQL table using your name with the following features: the columns of your table must include, at least the data types (in this order) and one more of your choice NOTE: You need to specify a 2 column (i.e 2 attribute 1. varchar (n), // where n covers the string length you want to enter 2. Int, 3. decimal, (precision = 8, scale = 3 4. date. 5. ??? your choice here ??? Table constraints: 1. It has a two column primary key 2. a check constraint on 2 columns, on the decimal and the date field 3. Use '2024-02-18' date as the default on the date field 5. write down your relational schema 5. Create the table, insert at least 4 rows, and do a Select * to show them example don't just copy these, change the constraint names
Please answer questions correctly
AutoSave Normal 因 Document1 - Word Search badiya aldujaili ff BА EN File Home Insert Draw Design Layout References Mailings Review View Help A Share O Comments X Cut Calibri (Body) v 11 - A^ A Aav A E E O Find - AaBbCcDc AaBbCcDc AABBCC AABBCCC AaB AABBCCC AaBbCcDa 自Copy Paste S Replace В IUvab х, х* А 1 Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em.. A Select v Dictate Editor Format Painter Clipboard Font Paragraph Styles Editing Voice Editor 2 3 4 Winter Company reported the following for the most recent month: Physical Units 700 Beginning work in process (60% complete) Units transferred in (started) during month Ending work in process 4,800 950 Materials are added at the end of the process and conversion costs are added evenly throughout the process. If equivalent whole units of production for conversion using the weighted average were 4,816, what percent complete was ending work in process at the end of the month? (Round to the nearest whole percent.) а. 20% b. 16%…
Hi can you show how to input in excel using the pmt formula thank you so much
AutoSave Off H Document2 - Word P Search (Alt+Q) Sign in File Design References Mailings Review View Help Grammarly Picture Format P Comments A Share Home Insert Draw Layout P Find - - A A Aa v A = - E - E G Times New Roman v 12 Normal No Spacing Heading 1 Replace = = 1E v Editor Open Grammarly Paste BIU I U v - 2. A - ab x, x' A . A Select v Undo Clipboard a Font Paragraph Styles Editing Editor Grammarly a. At the beginning of the year, Addison Company's assets are $200,000 and its equity is $150,000. During the year, assets increase $80,000 and liabilities increase $46,000. What is the equity at year-end? Assets Liabilities Equity Beginning $ 200,000 = 150,000 Change 80,000 = 46,000 + Ending Page 1 of 1 O words Text Predictions: On * Accessibility: Good to go O Focus 110% 9:58 PM P Type here to search 49°F 3/20/2022 近
Safari File Edit View History Bookmarks Window Help uLink - Student... W 1. 2. uLink - Student... 3. 4. learn-eu-central-1-prod-fleet01-xythos.content.blackboardcdn.com uLink - Student... 21 445 Entity A enters into the following transactions. You are required to show the impact of the transactions below on the accounting equation. e Content 9 Bb https://learn-eu-... Entity A purchased 1 000 bags of cement from K Ltd on credit. K Ltd normally sells a bag for R45. Entity A received a 10% discount for the 1 000 bags. Entity A returned 150 bags of cement, as they were defective. On the same day, the outstanding balance was settled through an online payment. This transaction did not affect the discount offered to Entity A. Select the correct values from the dropdown menus in the table provided in the Blackboard activity. MAR 7 In an attempt to assist the business, the owner of Entity A deposited R100 000 into the entity's bank account. A quarter of the amount is payable to the owner and…
A/an __________ approach actually schedules in detail eachresource using the setup and runtime required for each order.
Please help on parts 4 and 5. Please also show work on how to do.