help fill out the bottom chart please Net Change in CashPlus Beginning Cash BalanceEnding Cash Balance21,088-SUM(B39,841,845)87,466-lournaltES108,554-SUM(847, 848)***When preparing your Balance Sheet, do not forget your beginning balances!Karry no Key, Inc.Balance SheetMay 312$108,554 =849CashAccounts Receivable5,152 =SUM(JournallE13,Je3,450 =SUMJournal!E9,Jou2,875 -SUM(JournallE10,Jc120,031 =SUM(856:B59)135,700 SUMUournal!E7,Jou255,731 =SUM(B60,B61)13,800 =SUMJournal!G9,Jou1,554 =Journal!G21111,000 =JournallG51,110 -SUMJournal!G6,Jou127,464 =SUM(B63:B66)InventoryPrepaid InsuranceTotal Current AssetsEquipment, Net of Accumulated DepreciationTotal Assets2$Accounts PayableWages PayableE Notes Payable5 Interest Payable7 Total Current Liabilities2$B Stock9 Retained Earnings0 Total Liabilities and Shareholders' Equity116,000 =Journal!1512,267 =B27255,731 =SUM(B67:B69)23 Link to the line item amount in the financial statement above:74Amount75 Amount charged customers from selling inventory76 Cash collected from customersn/an/an/an/an/an/a77 Earned but not yet collected from customers78 Cash paid for insurance79 Insurance paid for in advance but not yet used80 Insurance used818283848586878889Instructionslournal 1 12 Project (continued)2 b NOT INSERT/DELETE ANY CELLS, ROWS OR COLUMNS IN THIS WORKBOOK; DOING SO WILL RESULT IN A SCORE OF 0.3Karry no Key, Inc.Income StatementFor the Month Ended May 3151,520 =Journall13(36,800) =Journal!11414,720 =SUM(B6,B7)(1,554) =Journal!121(1,150) =Journal!120(575) =Journal!11911,441 =SUM(B8:B11)(555) -Journal!12210,886 =SUM(B12,B13)6 ales Revenue7 ost of Goods Sold8 ross Profit9 ages Expense10 epreciation Expense11 surance Expense12 perating Income13 terest Expense14 et Income151617Karry no Key, Inc.18Statement of Shareholders' Equity19For the Month Ended May 31116,000 =Journal!1520 eginning Stock21 ock Issued-=022 hding Stock116,000 =SUM(B20:B21)232,511 =Journal!1610,886 =B1424 eginning Retained Earnings25 et Income26 jvidends- 27 hding Retained Earnings(1,130) =Journal!11812,267 =SUM(B24;B26)2829 ptal Shareholders' Equity2$128,267 =SUM(B22,B27)303132Karry no Key, Inc.33Statement of Cash Flows34For the Month Ended May 3135 ash from Operating Activities:36 ash Collected from Customers37 ash Paid for Inventory38 ash Paid for Insurance39 ptal Cash from Operating Activities2$46,368 =Journal!E15(20,700) =Journal!E17(3,450) =Journal!E1122,218 =SUM(836:B38)4041 ash from Investing Activities-=04243 ash from Finandng Activities44 ash Paid for Dividends45 et Cash from Financing Activities(1,130) =Journal!E18(1,130) =SUM(B44)4621,088 =SUM(B39,B41,B45)47 et Change in Cash48 us Beginning Cash Balance87,466 =JournallESInstructionsA JournalA StatementsReady

Answered: Image /qna-images/answer/1985b1d2-5ab6-4752-b1ae-d0cba630f69f.jpg

Balance Sheet May 31 108,554 =849 5,152 =SUM(Journa 3,450 -SUM(Journal 2,875 SUM(lournal 120,031 -SUM(B56:B59 135,700 SUMlournal 255,731 -SUM(860,B61 13,800 =SUM(Journal 1,554 =Journal!G21 111,000 =JournallG5 1,110 =SUMUournal! 127,464 =SUM(B63:866 Cash Accounts Receivable Inventory Prepaid Insurance Total Current Assets Equipment, Net of Accumulated Depreciation Total Assets Accounts Payable Wages Payable E Notes Payable 5 Interest Payable - Total Current Liabilities B Stock 9 Retained Earnings 0 Total Liabilities and Shareholders' Equity 116,000 =Journal!15 12,267 =B27 255,731 =SUM(B67:B69) $4 1 2 3 Link to the line item amount in the financial statement above: 74 75 Amount charged customers from selling inventory 76 Cash collected from customers 77 Earned but not yet collected from customers 78 Cash paid for insurance 79 Insurance paid for in advance but not yet used 80 Insurance used Amount n/a n/a n/a n/a n/a n/a 81 82 83 84

Balance Sheet May 31 108,554 =849 5,152 =SUM(Journa 3,450 -SUM(Journal 2,875 SUM(lournal 120,031 -SUM(B56:B59 135,700 SUMlournal 255,731 -SUM(860,B61 13,800 =SUM(Journal 1,554 =Journal!G21 111,000 =JournallG5 1,110 =SUMUournal! 127,464 =SUM(B63:866 Cash Accounts Receivable Inventory Prepaid Insurance Total Current Assets Equipment, Net of Accumulated Depreciation Total Assets Accounts Payable Wages Payable E Notes Payable 5 Interest Payable - Total Current Liabilities B Stock 9 Retained Earnings 0 Total Liabilities and Shareholders' Equity 116,000 =Journal!15 12,267 =B27 255,731 =SUM(B67:B69) $4 1 2 3 Link to the line item amount in the financial statement above: 74 75 Amount charged customers from selling inventory 76 Cash collected from customers 77 Earned but not yet collected from customers 78 Cash paid for insurance 79 Insurance paid for in advance but not yet used 80 Insurance used Amount n/a n/a n/a n/a n/a n/a 81 82 83 84

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter4: Operating Activities: Sales And Cash Receipts

Section: Chapter Questions

Problem 1.5C

See similar textbooks

Similar questions

Ma1. Question 11. Which of the following is not a catetory found in the Content Pane of Dynamics GP? Options: A.Cards B.Inquiry C.Print D.Reports Question 12. The typical size of a business that is most likely to use MS Dynamics GP is options: A.Fewer than 50 employees B.250-500 employees C.2500 - 5000 employees D.More than 5000 employees Question 13. Which of the following features allows you to view information about a customer and then begin entering an invoice for that customer? options: A.Lists B.Reports C.Inquiry D.SmartLists Question 14. Which of the following statements is not true regarding the Navigation Pane? options: A.You can choose not to show specific series/functions on the Navigation Pane B.You can change the order in which series/function areas appear on the Navigation Pane C.If you hide a series/function so it doesn’t appear on the Navigation Pane, it is removed from your Dynamics GP system D.It can be hidden in order to make the Content area larger…
correct answers: i) let 60 months, then is 16,775 ii) 15,293.38 iii) for 13th = 15,131.79 and for 14th = 167.64 NO tables, ONLY formulas, please
Ex5.19From the following accounts (not in order), prepare a post-closing trial balance for Winter Co. onOctober 31, 201X. Note: These balances are before closing.Accounts Receivable $19,950P. Winter, Capital $45,300Legal Supplies 9,700P. Winter, Withdrawals 3,000Office Equipment 54,400Legal Fees Earned 28,000Repair Expense 2,700Accounts Payable 48,000Salaries Expense 1,550Cash 30,000Adjustment Dataa. Insurance expired, $100.b. Dance supplies on hand, $1,100.c. Depreciation on dance equipment, $2,000.d. Salaries earned by employees but not to be paid until October, $1,000.Your task is to do the following:1. Prepare a worksheet.2. Journalize adjusting and closing entries.
Ex5.21From the following transactions as well as additional data, please complete the entire accountingcycle for Parker’s Plowing201XJan. 1 Parker invested $10,000 cash and $12,000 worth of snow equipment into the plowingcompany.1 Paid rent for six months in advance for garage space, $6,000.4 Purchased office equipment on account from Lumen Corp., $12,600.6 Purchased snow supplies for $800 cash.8 Collected $14,000 from plowing local shopping centers.P a g e 7 | 812 Parker Muroney withdrew $4,000 from the business for his own personal use.20 Plowed Alton Co. parking lots, payment not to be received until May, $1,500.26 Paid salaries to employees, $1,900.28 Paid Lumen Corp. one-half amount owed for office equipment.29 Advertising bill received from Washington Co. but will not be paid until May, $700.30 Paid telephone bill, $130.Adjustment Dataa. Snow supplies on hand, $700.b. Rent expired, $1,000.d. Depreciation on snow equipment, $200: ($12,000/5 yr = $2,400/12 mo. = $200).e. Accrued…
THE VALUE IS $245,000 NOT $220,000 PLS DO NOT COPY OTHERS ANSWER SOLVE ASAP
GL0305 (Algo) - Based on Problem 3-5A LO P1, P3, P4, P5, P6 On April 1, Rick Mitchell created a new travel agency, Mitchell Travel. The following transactions occurred during the company’s first month. April 2 Mitchell invested $38,000 cash and computer equipment worth $18,600 in the company in exchange for its common stock. April 3 The company rented furnished office space by paying $2,200 cash for the first month’s (April) rent. April 4 The company purchased $2,200 of office supplies for cash. April 10 The company paid $1,800 cash for a 12-month insurance policy. Coverage begins on April 11. April 14 The company paid $1,540 cash for two weeks’ salaries earned by employees. April 24 The company collected $16,000 cash for commissions revenue. April 28 The company paid $1,540 cash for two weeks’ salaries earned by employees. April 29 The company paid $650 cash for minor repairs to computer equipment. April 30 The company paid $650 cash for this month’s telephone…
PARRISH Pg 140Please calculate the following amounts from an adjusted Trial Balance and tell me the Net Income or Net Loss. ***Please do not put the answers in an Excel spreadsheet with the total's showing incorrect formulas instead of the totals. I don't know if it is a copy and paste issue, however everytime an answer like that is given I have to reask the question because the Excel Sheet did not paste correctly. If this happens again I will have to report this answer to Bartleby as not being properly answered and request an additional questions. ***DEBITSCASH $14,500ACCOUNTS RECEIVABLE 7,000LAND 67,000BUILDING 72,000OFFICE EQUIPMENT 24,000DIVIDENDS…
Please give me the correct answer and solution pls. 10. The current assets of Domino's Gift shop by month for the last year are P500, P400, P300, P400, P500, P550, P600, P650, P700, P800, P950, P1,100. The amount of permanent current assets is a. 500 b. 400 c. 300 d. 1,100
Score: 0 of 10 pts 2of9(o complete) | Hw Score: 0%, 0 of S2-10 (similar to Question Hel After operating for several months, architect Kyle Farnsworth completed the following transactions during the latter part of August Aug 15 22 28 29 31 Borrowed $65,000 from the bank, signing a note payable. Performed service for clients on account totaling $17,400 Received $8,000 cash on account from clients. Received and paid a utility bill of $1,300 Paid monthly salaries of $5,000 to employees. Journalize the transactions of Kyle Farnsworth, Architect. Include an explanation with each journal entry On August 15, Kyle Farnsworth borrowed $65,000 from the bank, signing a note payable. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.) Journal Entry Date Accounts and Explanations
Serial Problem Business Solutions LO P1, A1 Selected ledger account balances for Business Solutions follow. For Three MonthsEnded December 31, 2019 For Three MonthsEnded March 31, 2020 Office equipment $ 8,100 $ 8,100 Accumulated depreciation—Office equipment 405 810 Computer equipment 20,000 20,000 Accumulated depreciation—Computer equipment 1,250 2,500 Total revenue 31,334 44,900 Total assets 83,360 121,668 Required:1. Assume that Business Solutions does not acquire additional office equipment or computer equipment in 2020. Compute amounts for the year ended December 31, 2020, for Depreciation expense—Office equipment and for Depreciation expense—Computer equipment (assume use of the straight-line method).2. Given the assumptions in part 1, what is the book value of both the office equipment and the computer equipment as of December 31, 2020?3. Compute the three-month total asset turnover for Business…
. EX.02.224 Journalize the following selected transactions for Long Company's first month of operations in a two-column journal, identifying each entry by letter. Omit explanations. If an amount box does not require an entry, leave it blank. a. Received $18,000 from Katie Long, owner, as an investment in the business. fill in the blank 0fc8d7040026053_2 fill in the blank 0fc8d7040026053_3 fill in the blank 0fc8d7040026053_5 fill in the blank 0fc8d7040026053_6 b. Purchased equipment for $27,000, paying $10,000 in cash and giving a note payable for the remainder. fill in the blank 5b0a5ef84f9efee_2 fill in the blank 5b0a5ef84f9efee_3 fill in the blank 5b0a5ef84f9efee_5 fill in the blank 5b0a5ef84f9efee_6 fill in the blank 5b0a5ef84f9efee_8 fill in the blank 5b0a5ef84f9efee_9 c. Paid $2,300 for rent for April. fill in the blank a37a6ffe2ff3024_2 fill in the blank a37a6ffe2ff3024_3 fill in the blank…
14. 15. 16. 17. 18. 19. 20. Question Workspace Check My Work The balance sheet and income statement shown below are for Koski Inc. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. Balance Sheet (Millions of $) 2021 Assets Cash and securities $ 3,000 Accounts receivable 15,000 Inventories 18,000 Total current assets $ 36,000 Net plant and equipment 24,000 Total assets $ 60,000 Liabilities and Equity Accounts payable $ 15,004 Accruals 9,196 Notes payable 7,000 Total current liabilities $ 31,200 Long-term bonds 12,000 Total liabilities $ 43,200 Common stock 4,536 Retained earnings 12,264 Total common equity $ 16,800 Total liabilities and equity $ 60,000 Income Statement (Millions of $) 2021 Net sales $…