
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
Concept explainers
Textbook Question
Chapter 4, Problem P4.41CT
Using Excel to prepare financial statements, closing
Download an Excel template for this problem online in MyAccountingLab or athttp:www.pearsonhighered.com/Horngren. Cedar River Company started operations on July 1, 2018. On July 31, a trial balance was prepared,
Requirements
- Use Excel to complete the Income Statement and
Balance Sheet columns of the worksheet. Carry numbers from the adjusted trial balance columns of the worksheet to the income statement and balance sheet columns using Excel formulas. - Use formulas to total the columns.
- Use a formula to determine the amount of the net income or net loss.
- Format the cells requiring dollar signs.
- Boldface the totals.
- Prepare the income statement, the statement of owner's equity, and a classified balance sheet.
- Use the Increase Indent button on the Home tab to indent items.
- Use formulas to sum items.
- Format the cells requiring dollar signs.
- Format the cells requiring double underlines.
- Journalize the closing entries. The account titles are available when you click on the down-arrow. Indent the account to be credited.
- Post the closing entries to the T-accounts. Use cell references from the closing entries.
- Complete the post-closing trial balance using formulas referencing the T-accounts. The account tiles are available when you click the down-arrow.
- Format the cells requiring dollar signs.
- Boldface the totals. Format the cells requiring double underlines.
Expert Solution & Answer

Trending nowThis is a popular solution!

Students have asked these similar questions
For each of the transactions above, indicate the amount of the adjusting entry on the elements of the balance sheet and income statement.Note: Enter negative amounts with a minus sign.
Need help with this question solution general accounting
Don't use ai given answer accounting questions
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
- I want to correct answer general accounting questionarrow_forwardKindly help me with accounting questionsarrow_forwardDuo Corporation is evaluating a project with the following cash flows: Year 0 1 2 3 Cash Flow -$ 30,000 12,200 14,900 16,800 4 5 13,900 -10,400 The company uses an interest rate of 8 percent on all of its projects. a. Calculate the MIRR of the project using the discounting approach. Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. b. Calculate the MIRR of the project using the reinvestment approach. Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. c. Calculate the MIRR of the project using the combination approach. Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. a. Discounting approach MIRR b. Reinvestment approach MIRR c. Combination approach MIRR % % %arrow_forward
- Provide correct answer general accounting questionarrow_forwardNeed help with this question solution general accountingarrow_forwardConsider a four-year project with the following information: Initial fixed asset investment = $555,000; straight-line depreciation to zero over the four-year life; zero salvage value; price = $37; variable costs = $25; fixed costs = $230,000; quantity sold = 79,000 units; tax rate = 24 percent. How sensitive is OCF to changes in quantity sold?arrow_forward
- Light emitting diodes (LED) light bulbs have become required in recent years, but do they make financial sense? Suppose a typical 60-watt incandescent light bulb costs $.39 and lasts 1,000 hours. A 15-watt LED, which provides the same light, costs $3.10 and lasts for 12,000 hours. A kilowatt-hour of electricity costs $.115. A kilowatt-hour is 1,000 watts for 1 hour. If you require a return of 11 percent and use a light fixture 500 hours per year, what is the equivalent annual cost of each light bulb? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.arrow_forwardRecently, Abercrombie & Fitch has been implementing a turnaround strategy since its sales had been falling for the past few years (11% decrease in 2014, 8% in 2015, and just 3% in 2016.) One part of Abercrombie's new strategy has been to abandon its logo-adorned merchandise, replacing it with a subtler look. Abercrombie wrote down $20.6 million of inventory, including logo-adorned merchandise, during the year ending January 30, 2016. Some of this inventory dated back to late 2013. The write-down was net of the amount it would be able to recover selling the inventory at a discount. The write-down is significant; Abercrombie's reported net income after this write-down was $35.6 million. Interestingly, Abercrombie excluded the inventory write-down from its non-GAAP income measures presented to investors; GAAP earnings were also included in the same report. Question: From an investor standpoint, do you think that the effect of the inventory write-down should be considered when…arrow_forwardFinancial accountingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY