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