2 HomeworkSavedHelpSave & ECalibri11A APasteB IE - O -A-Alignment Number Conditional Format as CellStylesCellsEditingFormattingStylesTableClipboardFontA2fr(Accounts are in alphabetical order.)E1 The list below shows select accounts for Reading Readiness Company as of January 31, 20X1.2 (Accountsare in alphabetical order.)Accounts Payable8,0884.6,96013,4454,8005Accounts Receivablees6CashEquipmentInsurance ExpenseOperating ExpenseOther ExpensesOther Revenues1,350811,8003,482106,050114,8006,88217,20015,40012Rent Expense13Salaries ExpenseShort-term Notes PayableTest Prep Revenue14159,10016Tutoring Revenue1,04617Unearned Revenue1819 Required:20 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references21 to select account titles and amounts to be included on the income statement.22 Note: List revenues and expenses in order of largest to smallest dollar amounts.2324 2. After entering the formula in cell C42, use the Excel IF function to label cell B42 as either "Net Income" orSheet18 of 8Next< Prev.

1 The list below shows select accounts for Reading Readiness Company as of January 31, 20X1. 2 (Accounts are in alphabetical order.) 3 4 Accounts Payable 8,088 5 Accounts Receivable 6,960 6 Cash 13,445 Equipment Insurance Expense Operating Expense Other Expenses 4,800 1,350 11,800 3,482 6,050 4,800 Other Revenues Rent Expense Salaries Expense Short-term Notes Payable 6,882 17,200 15,400 Test Prep Revenue 9,100 Tutoring Revenue Unearned Revenue 1,046 Required: 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references to select account titles and amounts to be included on the income statement. Note: List revenues and expenses in order of largest to smallest dollar amounts. IUNat Income" %24

1 The list below shows select accounts for Reading Readiness Company as of January 31, 20X1. 2 (Accounts are in alphabetical order.) 3 4 Accounts Payable 8,088 5 Accounts Receivable 6,960 6 Cash 13,445 Equipment Insurance Expense Operating Expense Other Expenses 4,800 1,350 11,800 3,482 6,050 4,800 Other Revenues Rent Expense Salaries Expense Short-term Notes Payable 6,882 17,200 15,400 Test Prep Revenue 9,100 Tutoring Revenue Unearned Revenue 1,046 Required: 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references to select account titles and amounts to be included on the income statement. Note: List revenues and expenses in order of largest to smallest dollar amounts. IUNat Income" %24

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter2: Basic Accounting Systems: Cash Basis

Section: Chapter Questions

Problem 2.5P: Missing amounts from Financial statements The financial statements at the end of Network Realty,...

See similar textbooks

Similar questions

Marked out of 20.00P Flag questionusing the income summary account for the month ofSiren MarketingAdjusted Trial BalanceMay 31, 2022Account TitleCashDebitCredit$8, 600Accounts Receivable$2, 500Prepaid Insurance$2,700 Accounts PayableUnearned RevenueKirk, Capital$1, 200$1, 800$5, 880Kirk, Withdrawals$1,600Service Revenue$8, 620Advertising Expenselnsurance ExpenseRent Expense Total$790$450$860$17,500 $17,500No comma or dollar sign should be included in the imput icklPrepare the closing entries in the proper order. For transactions that have more than 1 debit or more than 1 deditDebitAccount Title and Explanation Date May 31
If Accounts Payable has debit postings of P170,000 credit postings of P140,000 and a normal ending balance of P60,000 which of the following was its beginning balance? Group of answer choices P30,000 Cr. P30,000 Dr. P90,000 Dr. P90,000 Cr.
I posted this a few days ago. In the attached image is the updated trial balance. All I need is help with creating the balance sheet from the provided data. ACC 122 Fall 2020Comprehensive ProjectBestValue Corporation's Trial Balance at December 31, 20XX is presented below.All 20XX transactions have been recorded except for the items described on the next page.Debit CreditCash $ 109,890Accounts Receivable 28,789Inventory 25,540Debt Investments 0Land 55,674Buildings 215,850Equipment 75,120Allowance for Doubtful Accounts $ 1,027Accumulated Depreciation-Buildings 63,306Accumulated Depreciation-Equipment 16,048Accounts Payable 35,278Interest Payable 0Unearned Rent Revenue 48,900Dividends Payable 0Income Tax Payable 0Bonds Payable 0Discount on Bonds Payable 0Common Stock ($2 par) 29,200Paid in Capital in Excess of Par-Common Stock 44,580Preferred Stock ($60 par) 0Paid in Capital in Excess of Par-Preferred Stock 0Retained Earnings 107,904Treasury Stock 0Cash Dividends 0Sales Revenue…
3. The following was the trial balance extract from ABC Trading as at 31 March 2019.Particulars DEBIT (RM) CREDIT (RM)Purchases and Sales 22,800 41,000Inventory on 1 April 2018 5,100Capital 8,170Bank overdraft 4,300Cash 140Discount allowed and received 1,440Returns inwards and outwards 790Carriage outwards 2,180Office expenses 450Fixtures and fittings 1,210Delivery van 2,000Accounts receivables and account payables 11,900 6,720Rent and insurance 1,790Drawings 2,850Wages and salaries 8,980TOTAL 61,690 61,690Additional information as at 31 March 2019:a. Inventory on 31 March 2019 was RM4,250b. Wages and salaries accrued as at 31 march 2019 was RM210; outstanding office expenses was RM30c. Rent and insurance prepaid was RM150Required:i. Prepare the Statement of Profit or Loss and Other Comprehensive Income for the year ended 31 March 2019ii. Prepare Statement of Financial Position as at 31 March 2019
Pg 37 T- Accounts Please find the missing amount on the follwoing T-Account. and explain CLEARLY and indepth (showing formula or method) on how you found the amount. Accounts Payable DRs 6/4 Transaction A 1500 6/8 Transaction C 2000 CRs Beginning Balance 3000 6/6 Transaction B UNKOWN 6/29 Transaction D 3,400 Ending Balance 6,700
On June 30 question attached in ss below thnak you for the help appareicated it 4i2opt24 y2oy4p
https://www.chegg.com/homework-help/questions-and-answers/q1-let-us-assume-mr-amir-starts-business-called-amir-enterprises-1st-january-2021-invests--q69973974?fbclid=IwAR2P3PvLU-TV9l2c3UJ1L3iqmf2MoRP-lQpp1m2RE9bHkCPdTkYNenUXFPY
5. Record the following transactions for the month of November 2020 in the generaljournal and post to the appropriate ledger account and balance all the accounts theprepare the trial balance as November 2020. Nov 1 Started business with RM6,000 in the bank2 Bought goods on credit from Ab Bhd RM 390 and XY Trading RM7105 Cash sales RM2407 Paid rent by cheque RM309 Paid sundry expenses by cheque RM20011 Sold goods on credit to Mina RM80 and Chee RM1,15016 Paid wages by cash RM4518 Returned goods to AB Bhd RM20 and XY Trading RM3519 Goods returned by Mina RM10 and Chee RM5021 Bought motor van on credit from Tan Ching Motor RM8,00024 Paid AB Bhd RM250 and XY Trading RM400 by cheque27 Received a loan of RM500 cash from Aman29 Received a cheque from Mina RM70 and Chee RM60030 The owner deposited a further RM1,000 into a business bank account
16) When creating a new QuickBooks data file for an existing company, QuickBooks automatically offsets accounts receivable balances with an entry to the:A) Uncategorized Expenses accountB) Uncategorized Income accountC) Opening Balance Equity accountD) Capital Stock account Group of answer choices A B C D
Use the following T-account for Careful Corporation to answer questions 11 and 12: Accounts Receivable Beg. Bal. $ 187 18 150 6 64 15 19 End. Bal. $ ? The ending balance of Accounts Receivable for Careful is: Group of answer choices A. $401 debit B. $343 debit C. $343 credit D. $ 58 credit
Missing amounts from Financial statements The financial statements at the end of Network Realty, Inc.’s first month of operations are shown below. 11y analyzing the interrelationships among the financial statements, fill in the proper amounts for (a) through (s).
Beginning Balance (BB) ? $ 8,820 $ 73,500 Ending Balance (EB) 36,260 ? 77,000 Transferred In (TI) 196,500 44,500 ? Transferred Out (TO) 194,700 48,400 183,800 For Case (A) above, what is the Beginning Balance (BB)? Multiple Choice $35,940. $38,300. $39,960. $34,460.