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

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

Echo Corporation had the following balances immediately prior to writing off a $100 uncollectible account: Current assets $ 30,000 Accounts receivable 3,300 Allowance for credit losses 300 Current liabilities 10,000 Required: Calculate the following amounts or ratios and determine the relationship between the amount or ratio before the write-off (x) with the amount or ratio after the write-off (y): Current ratio x equals y Net accounts receivable balance x equals y Gross accounts receivable balance x greather than Y
! Required information [The following information applies to the questions displayed below.] On January 1, 2024, the general ledger of 3D Family Fireworks includes the following account balances: Accounts Cash Debit Credit $25,300 Accounts Receivable 14,300 Allowance for Uncollectible Accounts $1,600 Supplies 3,200 Notes Receivable (6%, due in 2 years) 27,000 Land 77,700 Accounts Payable 9,800 103,000 33,100 $147,500 $147,500 Common Stock Retained Earnings Totals During January 2024, the following transactions occur: January 2 Provide services to customers for cash, $42,100. Write off accounts receivable as uncollectible, $1,800. (Assume the company uses the allowance method) Pay cash for salaries, $32,100. January 6 Provide services to customers on account, $79,400. January 15 January 20 January 22 Receive cash on accounts receivable, $77,000. January 25 Pay cash on accounts payable, $6,200. January 30 Pay cash for utilities during January, $14,400. 3. Prepare an adjusted trial…
Required information Skip to question [The following information applies to the questions displayed below.] On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances: Accounts Debit Credit Cash $ 27,300 Accounts Receivable 15,300 Allowance for Uncollectible Accounts $ 4,200 Supplies 4,200 Notes Receivable (6%, due in 2 years) 21,000 Land 80,600 Accounts Payable 9,100 Common Stock 101,000 Retained Earnings 34,100 Totals $ 148,400 $ 148,400 During January 2021, the following transactions occur: January 2 Provide services to customers for cash, $52,100. January 6 Provide services to customers on account, $89,400. January 15 Write off accounts receivable as uncollectible, $3,900. January 20 Pay cash for salaries, $33,100. January 22 Receive cash on accounts receivable,…
Simons Industries reported net income of $69,000 for the current year. The balances and activity in its accounts receivable accounts follow. In addition, the company recorded $3,400 of bad debt expense and wrote off $2,500 of uncollectible accounts. E (Click the icon to view the balances and activity in accounts receivable accounts.) Prepare the operating section of the cash flow statement under the indirect method. (Use a minus sign or parentheses for any amounts to be subtracted. If an input field is not used in the statement, leave the field empty; do not select a label or enter a zero.) Simons Industries Partial Statement of Cash Flows (Indirect Method) Operating Activities: Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: Net Cash Provided (Used) by Operating Activities
What is the amount of write offs during Year 2 based on the following financial information? Balance Sheet Excerpts As At Year Year 2 Year 1 End(000s) Gross Accts Receivable Allowance for Doubtful Accounts Net Accts Receivable Provision for Bad Debt O $15 $20 $37 $52 $456 $20 $437 $25 $321 $32 $294 $40
The following selected transactions were taken from the records of Rustic Tables Company for the year ending December 31: June 8. Wrote off account of Kathy Quantel, $8,150. Aug. 14. Received $5,790 as partial payment on the $14,590 account of Rosalie Oakes. Wrote off the remaining balance as uncollectible. Oct. 16. Received the $8,150 from Kathy Quantel, whose account had been written off on June 8. Reinstated the account and recorded the cash receipt. Dec. 31. Wrote off the following accounts as uncollectible (record as one journal entry): Wade Dolan $2,360 Greg Gagne 1,470 Amber Kisko 5,620 Shannon Poole 3,260 Niki Spence 900 Dec. 31. If necessary, record the year-end adjusting entry for uncollectible accounts. If no entry is required, select "No entry" and leave the amount boxes blank. If an amount box does not require an entry, leave it blank. a. Journalize the transactions under the direct write-off method. June 8 Bad Debt Expense Accounts Receivable-Kathy Quantel Aug. 14 Cash…
Estimating Uncollectible Accounts and Reporting Accounts Receivable LaFond Company analyzes its accounts receivable at December 31, and arrives at the age categories below along with the percentages that are estimated as uncollectible. Accounts Estimated Receivable Loss % $ 90,000 20,000 11,000 6,000 Over 180 days past due 4,000 Total accounts receivable $ 131,000 Age Group 0-30 days past due 31-60 days past due 61-120 days past due 121-180 296 4 The balance of the allowance for uncollectible accounts is $520 on December 31, before any adjustments. Transaction Record bad debts expense 5 10 25 (a) What amount of bad debts expense will LaFond report in its income statement for the year? $0 Cash Asset (b) Use the financial statement effects template to record LaFond's bad debts expense for the year. Use negative signs with your answers, when appropriate. Noncash Assets Balance Sheet Liabilities Contributed Capital (c) What is the balance of accounts receivable on it December 31 balance…
The following data (in millions) were adapted from recent financial statements of CVS Health Corporation (CVS). Year 2 Year 1 Sales $256,776 $194,579 Operating income 12,467 10,170 Average accounts receivable 18,624 15,406 1. Compute the accounts receivable turnover for Years 1 and 2. Round to one decimal place. Accounts Receivable Turnover Year 2 fill in the blank 1 Year 1 fill in the blank 2 2. Compute the days' sales in receivables for Years 1 and 2. Assume there are 365 days in the year, and round to the nearest day. Number of Days' Salesin Receivables Year 2 fill in the blank 3 days Year 1 fill in the blank 4 days 3. Compute the return on sales for Years 1 and 2. Round to one decimal place. Return on Sales Year 2 fill in the blank 5 % Year 1 fill in the blank 6 % 4. Based on the results in parts 1, 2, and 3, all the following are true except: The change in accounts receivable turnover from Year 1 to…
At what amount will accounts receivable for Anderson Company be reported on the balance sheet if the gross receivable balance is $52,000 and the allowance for doubtful accounts is estimated at 4% of gross receivables? Select one: A. $28,200 B. $49,920 C. $52,960 D. $47,000
Consider the following financial data for Larry’s Computer Stores: Statement of Financial Position as of December 31, 2012 Cash & equivalents $ 94,500 Accounts payable $ 122,500 Receivables 202,500 Short-term bank note 162,500 Inventories 364,000 Accrued wages and taxes 110,500 Total current assets $ 661,000 Total short-term liab. $ 395,500 Long-term debt 418,000 Net fixed assets 468,500 Common equity 316,000 Total assets $ 1,129,500 Total liabilities & equity $ 1,129,500 Statement of Earnings for the Year Ended December 31, 2012 Sales revenue $ 450,000 Cost of merchandise sold 250,000 Gross profit $ 200,000 Operating expenses 97,500 Earnings before interest and taxes (EBIT) $ 102,500 Interest expense 46,500 Earnings before taxes (EBT) $ 56,000 Federal and state income taxes (45 percent) 25,200 Net earnings $ 30,800…
Estimating Uncollectible Accounts and Reporting Accounts ReceivableCollins Company analyzes its accounts receivable at December 31, and arrives at the aged categories below along with the percentages that are estimated as uncollectible. Age Group Accounts Receivable Estimated Loss % 0-30 days past due $110,000 1% 31-60 days past due 40,000 2 61-120 days past due 27,000 5 121-180 days past due 14,000 10 Over 180 days past due 9,000 25 Total accounts receivable $200,000 The balance of the allowance for uncollectible accounts is $1,100 on December 31, before any adjustments. (a) What amount of bad debts expense will Collins report in its income statement for the year?$Answer? (b) Use the financial statement effects template to record Collin's bad debts expense for the year. Use negative signs with your answers, when appropriate. Balance Sheet Transaction Cash Asset + Noncash Assets = Liabilities + Contributed Capital + Earned Capital…
Exercise 5-18 (Algo) Calculate receivables ratios (LO5-8) Below are amounts (in millions) from three companies' annual reports. WalCo TarMart CostGet Required: Beginning Accounts Receivable $1,775 5,966 589 Ending Accounts Receivable $2,722 6,494 625 Net Sales $318,427 63,878 64,963 1. Calculate the receivables turnover ratio and the average collection period for WalCo, TarMart and CostGet. 2. Which company appears most efficient in collecting cash from sales? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the receivables turnover ratio and the average collection period for WalCo, TarMart and CostGet. (Enter your answers in millions rounded to 1 decimal place.) WalCo TarMart CostGet WalCo TarMart CostGet Choose Numerator Receivables Turnover Ratio Choose Denominator Receivables turnover ratio times times times Average Collection Period Choose Numerator Choose Denominator Average collection period days days days