Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
I need to create a balance sheet, income statement, and Retained Earnings Statement. Can you point me in the righ direction of which account would to each sheet or how to put each one together?
After all of the transactions for the year ended December 31, Year 1, had been posted [including the transactions recorded in part (1) and all adjusting entries], the data that follows were taken from the records of Equinox Products Inc.
A.
Prepare a multiple-step income statement for the year ended December 31, Year 1, concluding with earnings per share. In computing earnings per share, assume that the average number of common shares outstanding was 100,000 and preferred dividends were $100,000. Enter all amounts as positive numbers EXCEPT in the Other income and expenses. In that section only, enter amounts that represent other expenses as negative numbers using a minus sign. (Round earnings per share to the nearest cent.)
B.
Prepare a retained earnings statement for the year ended…
In this case you will complete the full accounting cycle for one month for a new company. To facilitate the end-of-month accounting and reporting process you will use a worksheet. The worksheet is a tool used to adjust account balances and prepare financial statements, however, the worksheet does not replace the financial statements. Preparation of a worksheet is covered in Appendix 3C on pages 3-46 through 3-49.
The following is information concerning the company. Instructions are at the end of the case.
At the start of the new business the company set up the following chart of accounts:
101
Cash
405
Commissions Earned
106
Accounts Receivable
410
Consulting Revenue
124
Office Supplies
612
Depreciation Expense—Computer Equip.
128
Prepaid Insurance
622
Salaries Expense
167
Computer Equipment
637
Insurance Expense
168
Accumulated Depreciation—Computer Equip.
640
Rent Expense
209
Salaries Payable…
Please answer ASAPUsing the information provided in the picture, complete the calculation of accounting ratios andpercentages and comment briefly on the performance of the company for the twoyears.
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
- You are the accountant for Kamal Fabricating, Inc. and you oversee the preparation of financial statements for the year just ended 6/30/2020. You have the following information from the companys general ledger and other financial reports (all balances are end-of-year except for those noted otherwise: Prepare the companys Statement of Retained Earnings.arrow_forwardYou are the accountant for Trumpet and Trombone Manufacturing, Inc. and you oversee the preparation of financial statements for the year just ended 6/30/2020. You have the following information from the companys general ledger and other financial reports (all balances are end-of-year except for those noted otherwise): Prepare the companys Statement of Retained Earningsarrow_forwardFedEx Corporation had the following revenue and expense account balances (in millions) for a recent year ending May 31: a.Prepare an income statement. b.Compare your income statement with the income statement that is available at the FedEx Corporation Web site, (http://investors.fedex.com). Click on Annual Report and Download Annual Report. What similarities and differences do you see?arrow_forward
- The following revenue and expense account balances were taken from the ledger of Wholistic Health Services Co. after the accounts had been adjusted on February 29, 2016, the end of the fiscal year: Prepare an income statement.arrow_forwardPrepare journal entries to record the following transactions for the month of July: A. on first day of the month, paid rent for current month, $2,000 B. on tenth day of month, paid prior month balance due on accounts, $3,100 C. on twelfth day of month, collected cash for services provided, $5,500 D. on twenty-first day of month, paid salaries to employees, $3,600 E. on thirty-first day of month, paid for dividends to shareholders, $800arrow_forwardFor each of the following accounts, identify whether it would be closed at year-end (yes or no) and on which financial statement the account would be reported (Balance Sheet, Income Statement, or Retained Earnings Statement). A. Accounts Payable B. Accounts Receivable C. Cash D. Dividends E. Fees Earned Revenue F. Insurance Expense G. Prepaid Insurance H. Suppliesarrow_forward
- At December 31, Rolison Consulting’s financial records show the following selected account information. Service revenue..................... $90,000Rent expense......................... $25,000Salaries expense.................... $54,000Supplies expense..................... $3,000Depreciation expense............... $6,000Retained earnings.................. $52,000 (credit balance)Contributed Capital................. $10,000 (credit balance) After all closing entries are recorded and posted, what is the balance of the retained earnings account? At December 31, Rolison Consulting’s financial records show the following selected account information. Service revenue..................... $90,000Rent expense......................... $25,000Salaries expense.................... $54,000Supplies expense..................... $3,000Depreciation expense............... $6,000Retained earnings.................. $52,000 (credit balance)Contributed Capital................. $10,000 (credit…arrow_forwardHello, I am stuck with this problem. I have included the directions below and what I have done so far is included in the images. The Adjusted Trial Balance columns of a work sheet for Planta Company follow. Complete the work sheet by extending the account balances into the appropriate financial statement columns and by entering the amount of net income for the reporting period.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
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
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY