Horngren's Accounting (12th Edition)
12th Edition
ISBN: 9780134486444
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 4, Problem E4.20E
Preparing financial statements from the completed worksheet.
Learning Objective 1, 2
2. Ending Capital $34,550
Use your answer from Exercise E4−19 to prepare Data Solution’s financial statements.
Requirements
- Complete the income statements for the month ended November 30, 2018.
- Complete the statement of owner’s equality for the month ended November 30, 2018. Assume there were no contributions made by the during the month.
- Complete the classified
balance sheet as of November 30, 2018. Use the report form.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
(Learning Objective 1: Identify the current liabilities associated with operating activities)Identify the current liability associated with each of the following operating activities:1. Perform work on a warranty claim2. Pay income taxes3. Purchase supplies4. Pay payroll taxes5. Borrow money for operations using a short-term note6. Process cash received in advance from customers7. Purchase inventory8. Pay employee salaries
1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…
(Learning Objectives 1, 2, 5: Analyze current liabilities; evaluate accounts payable turnover; evaluate contingent liabilities) Retrieve the 2016 Under Armour financial statementsat www.sec.gov by clicking on Filings and then searching for “Under Armour” under Company Filings. When you see the list of filings for the company, select the Form 10-K for 2016.Be sure to retrieve the 2016 financial statements, not another year. These financial statementsreport a number of liabilities.Requirements1. The current liability section of Under Armour’s Consolidated Balance Sheet as of December31, 2016, lists four different liabilities. List them and give a brief description of each one.2. For 2016, calculate accounts payable turnover, both as a ratio and in number of days.Describe what this ratio means. Also compute the following other ratios for 2016 (if you havealready computed them as part of your work in previous chapters, refer to them): (1) currentratio, (2) quick ratio, (3) days’ sales…
Chapter 4 Solutions
Horngren's Accounting (12th Edition)
Ch. 4 - Assets are listed on the balance sheet in the...Ch. 4 - Which of the following accounts would be included...Ch. 4 - Which situation indicates a net loss within the...Ch. 4 - Which of the following accounts is not closed?...Ch. 4 - What do closing entries accomplish? Learning...Ch. 4 - Which of the following is not a closing entry?...Ch. 4 - Which of the following accounts may appear on a...Ch. 4 - 8. Which of the following steps of the accounting...Ch. 4 - Clean Water Softener Systems has Cash of $600,...Ch. 4 - Which of the following statements concerning...
Ch. 4 - What document are financial statements prepared...Ch. 4 - What does the income statement report?Ch. 4 - Prob. 3RQCh. 4 - Prob. 4RQCh. 4 - Why are financial statements prepared in a...Ch. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Prob. 8RQCh. 4 - Prob. 9RQCh. 4 - How could a worksheet help in preparing financial...Ch. 4 - If a business had a net loss for the year, where...Ch. 4 - Prob. 12RQCh. 4 - What are temporary accounts? Are temporary...Ch. 4 - What are permanent accounts? Are permanent...Ch. 4 - How is the Income Summary account used? Is it a...Ch. 4 - Prob. 16RQCh. 4 - If a business had a net loss for the year, what...Ch. 4 - What types of accounts are listed on the...Ch. 4 - Prob. 19RQCh. 4 - What is the current ratio, and how is it...Ch. 4 - Prob. 21ARQCh. 4 - Preparing an income statement Learning Objective 1Ch. 4 - Preparing a statement of owner’s equity. Learning...Ch. 4 - Preparing a balance sheet (unclassified, account...Ch. 4 - Preparing a balance sheet (classified, report...Ch. 4 - Classifying balance sheet accounts Learning...Ch. 4 - Prob. S4.6SECh. 4 - Prob. S4.7SECh. 4 - Determine net loss using a worksheet Learning...Ch. 4 - Identifying temporary and permanent accounts...Ch. 4 - Prob. S4.10SECh. 4 - Posting closing entries directly to Taccounts...Ch. 4 - S412 Identifying accounts included on a...Ch. 4 - Identifying steps in the accounting cycle Learning...Ch. 4 - Calculating the current ratio Learning Objective 6...Ch. 4 - Journalizing reversing entries Learning Objective...Ch. 4 - E416 Preparing the financial statements The...Ch. 4 - Classifying balance sheet accounts Learning...Ch. 4 - Preparing a classified balance sheet and...Ch. 4 - Preparing a worksheet Learning Objective 2: Title...Ch. 4 - Preparing financial statements from the completed...Ch. 4 - Preparing closing entries from an adjusted trial...Ch. 4 - Preparing closing entries from T-accounts Learning...Ch. 4 - Determining the effects of closing entries on the...Ch. 4 - Preparing a worksheet and closing entries Learning...Ch. 4 - Preparing closing entries from an adjusted trial...Ch. 4 - Preparing a worksheet, closing entries, and a...Ch. 4 - Journalizing reversing entries. Learning Objective...Ch. 4 - Journalizing reversing entries Leaning Objectives...Ch. 4 - Preparing financial statements including a...Ch. 4 - Preparing financial statements including a...Ch. 4 - Preparing a worksheet, financial statements, and...Ch. 4 - Completing the accounting cycle from adjusting...Ch. 4 - Completing the accounting cycle from journal...Ch. 4 - Preparing adjusting entries and reversing entries...Ch. 4 - Preparing financial statements including a...Ch. 4 - Preparing financial statements including a...Ch. 4 - Preparing a worksheet financial statements, and...Ch. 4 - Completing the accounting cycle from adjusting...Ch. 4 - Completing the accounting cycle from journal...Ch. 4 - Preparing adjusting entries and reversing entries...Ch. 4 - Using Excel to prepare financial statements,...Ch. 4 - Completing the accounting cycle from adjusted...Ch. 4 - Completing the accounting cycle from adjusted...Ch. 4 - COMPREHENSIVE PROBLEMS Comprehensive Problem 1 for...Ch. 4 - COMPREHENSIVE PROBLEMS Comprehensive Problem 1 for...Ch. 4 - COMPREHENSIVE PROBLEMS Comprehensive Problem 1 for...Ch. 4 - COMPREHENSIVE PROBLEMS Comprehensive Problem 1 for...Ch. 4 - COMPREHENSIVE PROBLEMS Comprehensive Problem 1 for...Ch. 4 - COMPREHENSIVE PROBLEMS Comprehensive Problem 1 for...Ch. 4 - COMPREHENSIVE PROBLEMS Comprehensive Problem 1 for...Ch. 4 - COMPREHENSIVE PROBLEMS Comprehensive Problem 1 for...Ch. 4 - COMPREHENSIVE PROBLEMS Comprehensive Problem 1 for...Ch. 4 - Comprehensive Problem 2 for Chapters 1 —4 This...Ch. 4 - Comprehensive Problem 2 for Chapters 1 —4 This...Ch. 4 - Comprehensive Problem 2 for Chapters 1 4 This...Ch. 4 - Comprehensive Problem 2 for Chapters 1 4 This...Ch. 4 - Comprehensive Problem 2 for Chapters 1 4 This...Ch. 4 - Comprehensive Problem 2 for Chapters 1 4 This...Ch. 4 - Comprehensive Problem 2 for Chapters 1 4 This...Ch. 4 - Comprehensive Problem 2 for Chapters 1 4 This...Ch. 4 - Prob. 4.1TIATCCh. 4 - Prob. 4.1EICh. 4 - Prob. 4.1FSC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- CH1 HW (1).docx (Protected View) - Word Mailings Help the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. wout References W View Review Land Notes Payable Property Tax Expense Dividends P-F:1-43A. Preparing financial statements (Learning Objective 5) Presented here are the accounts of Hometown Décor Company for the year ended December 31, 2024. Rent Expense Salaries Expense Salaries Payable Service Revenue Office Supplies Retained Earnings, Dec. 31, 2023 Tell me what you want to do 1. Net Income $115,700 $ 13,000 Common Stock 33,000 Accounts Payable 2,800 Accounts Receivable 36,000 Advertising Expense 14,000 Building 67,000 Cash 1,300 Equipment 225,000 Insurance Expense 8,000 Interest Expense 56,000 Enable Editing Requirements 1. Prepare Hometown Décor Company's income statement for the year ended December 31, 2024. 2. Prepare the statement of retained earnings for the December 31, 2024. $ 28,000 14,000 800 17,000 170,400 2,800 17,000 1,700…arrow_forwardMindTap - Cengage Learning 2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false ork items week 6: Homework eBook Salary State income taxes Exercise 12-22 (Algorithmic) (LO. 2, 3, 5) Yanni, who is single, provides you with the following information for 2021: CengageNOWv2 | Online teachin X Print Item Mortgage interest expense on principal residence Charitable contributions Interest income a. Yanni's taxable income: b. Yanni's AMT base: Check My Work Click here to access the exemption table. If required, round your answers to the nearest dollar. Compute the following: c. Yanni's tentative minimum tax: $117,400 11,740 10,566 2,348 1,761 94,507 32,647 X + 8,488arrow_forwardLearning Outcome 7. Answer the following question in a short answer of 100-150 words; provide comprehensive information and examples in applicable, to support your answer. How Financial Statements are Interconnected? Explain.arrow_forward
- education.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewcon... It sec Question 2 - Ch 7 h/w - mkt sec - Connect Required B Complete this question by entering your answers in the tabs below. Required C Saved b. As of December 31, year 1, what income taxes has Wharton paid on the increase in value of these investments? c. Prepare a journal entry at January 4, year 2, to record the cash sale of these investments at $220,000. d. What effect will the sale recorded in part c have on Wharton's tax obligation for year 2? Required D Wharton, Inc., pays income taxes on capital gains (including gains on marketable securities) at a rate of 30 percent. At December 31, year 1, the company owns marketable securities that cost $180,000 but have a current market value of $220,000. Required B Prev ‒‒‒‒‒‒‒‒‒‒‒ As of December 31, year 1, what income taxes has Wharton paid on the increase in value of these investments? Income taxes paid on the increase in the…arrow_forwardDigital Learning * CengageNOwv2 | Online teachir * Cengage Learning + Assignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false A eBook Show Me How Percent of Sales Method At the end of the current year, Accounts Receivable has a balance of $555,000; Allowance for Doubtful Accounts has a credit balance of $5,000; and sales for the year total $2,500,000. Bad debt expense is estimated at 1/4 of 1% of sales. a. Determine the amount of the adjusting entry for uncollectible accounts. b. Determine the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts, and Bad Debt Expense. Accounts Receivable 24 Allowance for Doubtful Accounts Bad Debt Expense %24 c. Determine the net realizable value of accounts receivable. Feedback Check My Work a. Remember that since accounts receivable are created by credit sales, uncollectible accounts çan be estimated as a percent of credit sales. If the portion of credit sales to sales id relatively constant, the…arrow_forwardOpen the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas where indicated on the worksheet. Check to be sure that your balance sheet balances. Enter your name in cell A1. Save the completed file as MASTER2. Print the worksheet when done. Also print your formulas using fit-to-1 page scaling. Check figures: Borrowing (cell B78), $7,280; forecasted net income (cell D95), $40,200; total assets (cell D105), $507,600.arrow_forward
- Insert a pie chart with a 2-D visual effect for 2018 using all expense items in a new worksheet called, “Comparing Expenses”. Include all relevant labels, titles (not shown) and legends while changing the default colors. Thom-Pierre Consultants (TPC) Tax Rate COMPARITIVE INCOME STATEMENT 30% for years ended 31 December 2018 2019 Revenues and gains *Sales revenue *Interest revenue *Investment Income *Other revenue Total revenue and gains Expenses and losses **Cost of goods sold 460,000 **Selling and admin administrative 195,000 ***Computer (operating) **Depreciation 55,000 **Interest expense 25,200 Total expenses and losses Income before taxes Income tax expense (30%) Net Incomearrow_forwardLocate Gap Inc.’s 2020 Annual Report (for fiscal year 2/2/20-1/30/21) There are 10 sections of questions. You will find the information necessary to answer the questions in “Item 8. Financial Statements and Supplementary Data,” of the report. Read through the questions carefully and answer in the space provided. What are the following amounts at 1/30/21: Total Assets : Total Liabilities: Total Owner’s Equity : At 1/30/21: What is the percentage of debt used to finance Gap? What is the percentage of owner’s equity used to finance Gap? What is the significance of these two percentages?arrow_forward10:04 Assignment Details ATG-110-20A01: Financial Accounting (Session II Summer 2021) 7474 unread replies.7575 replies. Please read and respond to TIF 12-2 on page 623. Review the rubric to ensure you receive full points for this discussion. Discussion Rubric- 25 points(1)_(3).docx *After you have posted your answers, please reply to three other students' posts. This discussion board was set up so that you will not be able to see others replies until you post your own. Search entries or author Filter replies by unreadUnread Collapse replies TIF 12-2 Issuing Stock 1. ETHICS Lou Hoskins and Shirley Crothers are organizing Red Lodge Metals Unlimited Inc. to undertake a high-risk gold mining venture in Canada. Lou and Shirley tentatively plan to request authorization for 400,000,000 shares of common stock to be sold to the general public. Lou and Shirley have decided to establish par of $0.03 per share in order to appeal to a wide variety of potential investors. Lou and Shirley believe…arrow_forward
- Download the attached Excel file (First Q Profits Report W Goal Seek_Ver2.xlsx). Instructions: . There are 3 Worksheet Tabs in this Excel file; First Q, First Q Goal Seek, and Minivan Loan. • The First Q (First Quarter) tab shows the first quarter revenue and expenses of the Downtown Internet Cafe. For this tab, • Complete the Proportion column, cells G7 through G11 Each proportion value shows the % of the quarterly sale of that item over the entire sale. Calculate the Net Income row, cells B24 through F24. o Compute the Profit Margin row, Cells B25 through E25. o Add Net Income Sparkline for January through March in Cell H24. in For this tabarrow_forwardin CengageNOWv2| Online teachi x Cengage Learning 8-1 Problem Set: Module Eight X how.comn/akeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=D&inprogress3false eBook Show Me How Changes in Current Operating Assets and Liabilities-Indirect Method Covington Corporation's comparative balance sheet for current assets and liabilities was as follows: Dec. 31, 20Y2 Dec. 31, 20Y1 Accounts receivable $15,300 Inventory 66,500 67,200 Accounts payable 20,100 0098 Dividends payable 000' Adjust net income of $84,200 for changes in operating assets and liabilities to arrive at net cash flow from operating activities. ( Previou: Check My Work レ AD 12arrow_forwardsignments x y Indicate the impact on the incom X * Cengage Learning mpt.php?attempt3D462760&cmid%3D605614 Student Toolbox JSCC Bookstore English (United States) (en_us) - Indicate the impact on the income statement and balance sheet if the following adjusting entries were omitted. You should indicate which of the items shown would be overstated or understated. An attorney has earned 1/2 of a retainer fee that was received and recorded last month. No adjustment was recorded for the amount earned. von Revenues Choose... Expenses Choose.. Net Income Choose. Assets Choose.. Liabilities Choose... Owner's Equity Choose.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
IAS 29 Financial Reporting in Hyperinflationary Economies: Summary 2021; Author: Silvia of CPDbox;https://www.youtube.com/watch?v=55luVuTYLY8;License: Standard Youtube License