Horngren's Accounting Plus Mylab Accounting With Pearson Etext -- Access Card Package (12th Edition)
12th Edition
ISBN: 9780134674681
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 Objectives 4, 5: Account for accounts receivable and uncollectibleaccounts) Perform the following accounting for the receivables of Andrews and Johnson, a lawfirm, at December 31, 2018.Requirements1. Set up T-accounts and start with the beginning balances for these T-accounts:■ Accounts Receivable, $100,000■ Allowance for Uncollectible Accounts, $14,000Post the following 2018 transactions to the T-accounts:a. Service revenue of $697,000, all on accountb. Collections on account, $714,000c. Write-offs of uncollectible accounts, $8,000d. Uncollectible-account expense (allowance method), $11,0002. What are the ending balances of Accounts Receivable and Allowance for UncollectibleAccounts?3. Show how Andrews and Johnson will report accounts receivable on its balance sheet atDecember 31, 2018.
Most Essential Learning Competencies
1. Identify the elements of the SFP and describe each of them.
2. Prepare an SFP using the report form and the account form with proper classification of
items as current and noncurrent.
STATEMENT OF FINANCIAL
Part 1: At the back of this paper, prepare a Statement of Financial Position pf CDS Enterprise
Business for the calendar year 2020 using the following accounts in Report Form:
Cash - 5,000
Loans Payable - 77,500
Accounts Receivable - 2,600
Supplies - 2,300
Equipment - 17,000
Owner's equity – 40,000
Accounts Payable - 22,400
Building - 113,000
Part 2: Answer the following questions and write the solutions in a clean paper. Attached your
solution with this paper.
1. If assets are Php17,000 and owner's equity is Php10,000, liabilities are
2. At the end of the first month of operations for Juana's Delivery Service, the business had the
following accounts: Accounts Receivable, Php1,200; Prepaid Insurance, Php500; Equipment,
Php36,200 and Cash,…
Prepare a worksheet of this. thank you
Chapter 4 Solutions
Horngren's Accounting Plus Mylab Accounting With Pearson Etext -- Access Card Package (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
- Prepare a worsksheet for this. in excel form pls, thank youarrow_forwardKindly prepare the Worksheet for this. thank yoouu!!arrow_forward(Learning Objective 5: Evaluate collectibility using the allowance for uncollectibleaccounts) At the end of the current year (before adjusting entries), Autumn Corporation hada balance of $76,000 in Accounts Receivable and a credit balance of $11,000 in Allowance forUncollectible Accounts. Service revenue (all on credit) for the year totaled $490,000.RequirementsConsider each of the following two independent situations.1. Using the percent-of-sales method, calculate the amount of Uncollectible-Account Expenseif Autumn Corporation estimates its uncollectible-account expense using a rate of 2% ofcredit sales. What is the ending balance of the Allowance for Uncollectible-Accounts underthis scenario?2. Now assume that Autumn Corporation uses the aging-of-receivables method. AutumnCorporation estimates that its Allowance for Uncollectible Accounts should have a creditbalance of $21,000. Calculate the amount of its Uncollectible-Account Expense. What isthe ending balance of the Allowance for…arrow_forward
- Please prepare Income Statement, Equity and Financial Position. Thank you!arrow_forwardSuppose that on January 6, 2018, Excel Motors paid $240,000,000 for its 45% investment in Dynamic Motors. Excel has significant influence over Dynamic after the purchase. Assume Dynamic earned net income of $10,000,000 and paid cash dividends of $15,000,000 to all outstanding stockholders during 2018. (Assume all outstanding stock is voting stock.) Read the requirements. Requirement 1. What method should Excel Motors use to account for the investment in Dynamic Motors? Give your reasoning. Excel Motors should use the method to account for its investment in Dynamic Motors because the investment Requirement 2. Journalize all required 2018 transactions related to Excel Motors's Dynamic investment. Include an explanation for each entry. (Record debits first, then credits. Select the explanation on the last line of the journal entry table. If no entry is required, enter "No entry required" on the first line of the Accounts and Explanation column and leave the remaining cells blank. Check…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_forward
- (Learning Objective 5: Evaluate collectibility using the allowance for uncollectibleaccounts) During its first year of operations, Spring Garden, Inc., had sales of $439,000, all onaccount. Industry experience suggests that Spring Garden’s uncollectibles will amount to 4% ofcredit sales. At December 31, 2018, accounts receivable total $59,000. The company uses theallowance method to account for uncollectibles.1. Make Spring Garden’s journal entry for uncollectible-account expense using thepercent-of-sales method.2. Show how Spring Garden should report accounts receivable on its balance sheet atDecember 31, 2018.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_forwardPrepare the financial statements for Smart Touch Learning for the month of December. Remember that the business started operations this month so all beginning balances were zero. For the Statement of Retained Earnings and the Balance Sheet, enter any decreases with a minus sign or parentheses. Check your spelling carefully and do not abbreviate. Enter account names exactly as provided in the adjusted trial balance. SMART TOUCH LEARNING Adjusted Trial Balance December 31, 2016 Balance Account Title Debit Credit Cash 35,270 Accounts Receivable 1,700 Office Supplies 290 Prepaid Insurance 1,350 Furniture 13,400 Accumulated Depreciation - Furniture 200 Salaries Payable 4,600 Unearned Revenue 3,400 Common Stock 36,800 Dividends 4,200 Service Revenue 20,800 Salaries Expense 6,600 Depreciation Expense - Furniture 200 Insurance Expense 450 Utilities Expense 230 Rent Expense 2,000 Supplies Expense 110 Total…arrow_forward
- Need answers please helparrow_forwardNeed help with this question please. Thank youarrow_forwardA Pre-Closing Trial Balance for Shady Lane Senior Living Center is listed below. From the list of accounts provided, prepare an activity statement. In this instance, there are no assets released from restrictions. Download the excel file provided. Prepare the activity statement, save it on your computer, and upload your response in the drop box below. Cash $121,000 Pledges Receivable 50,240 Interest Income Receivable 500 Inventory 1,000 Investments – long term 492,600 Land 42,000 Building 162,800 Vintage Car Collection 60,000 Allowance for Uncollectible Pledges 1,000 Accumulated Depreciation 22,600 Accounts Payable 600 Notes Payable 1,000 Deferred Revenue 400 Long Term Loans Payable 100,000 Mortgage Payable 14,000 Net Assets: UR Undesignated 100,000 Net Assets: UR Designated 60,000 Net Assets: TR 100,000 Net Assets: PR 200,000 Program Expenses 42,300 SS: Mgt & Genl Exp 9,600 SS: Fundraising Exp 3,600 Reclassifications OUT-TR 44,200 Loss on Disposal of equipment 600 Revenue:…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
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