1. Prepare an Income statement from a list of accounts. Preparing an income statement - Excel ILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 - A A ste BIU- Alignment Number Conditional Format as Cell Cells Formatting - Table- Styles - pboard Font TM Styles The list below shows select accounts for Reading Readiness, Inc. as of Ja B F The list below shows select accounts for Reading Readiness, Inc. as of January 31, 20X1. (Accounts are in alphabetical order.) Accounts Payable 24 8,088 Accounts Receivable 6,960 Cash 13,445 Equipment 4,800 Income Tax Expense 1,350 Operating Expense 11,800 3,482 Other Expenses Other Revenues 6,050 4,800 Rent Expense 6,882 Salaries Expense Short-term Notes Payable 17,200 15,400 Test Prep Revenue 9,100 Tutoring Revenue Unearned Revenue 1,046 a Required: P 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references 1 to select account titles and amounts to be included on the income statement. 2 Note: List revenues ond expenses in order of lorgest to smallest dollor amounts. 4 2. After entering the formula in celIl C42. use the Excel IF function to label cell B42 as either "Net Income" or

1. Prepare an Income statement from a list of accounts. Preparing an income statement - Excel ILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 - A A ste BIU- Alignment Number Conditional Format as Cell Cells Formatting - Table- Styles - pboard Font TM Styles The list below shows select accounts for Reading Readiness, Inc. as of Ja B F The list below shows select accounts for Reading Readiness, Inc. as of January 31, 20X1. (Accounts are in alphabetical order.) Accounts Payable 24 8,088 Accounts Receivable 6,960 Cash 13,445 Equipment 4,800 Income Tax Expense 1,350 Operating Expense 11,800 3,482 Other Expenses Other Revenues 6,050 4,800 Rent Expense 6,882 Salaries Expense Short-term Notes Payable 17,200 15,400 Test Prep Revenue 9,100 Tutoring Revenue Unearned Revenue 1,046 a Required: P 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references 1 to select account titles and amounts to be included on the income statement. 2 Note: List revenues ond expenses in order of lorgest to smallest dollor amounts. 4 2. After entering the formula in celIl C42. use the Excel IF function to label cell B42 as either "Net Income" or

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

What are some advantages of using a software system versus recording transactions manually (by hand)?
What are the possible scenarios in the delivery creation process? Can a SAP user create a delivery without referencing any existing order? Write a few audit techniques applied to audit computerized AIS?
Give me a research methodology.
Discuss the major control implications of batch systems with real-time data input. What compensating procedures are available?
Research on the following: a. Auditing with the computer b. Auditing around the computer c. Auditing through the computer
Create a code in java to calculate the surface area and volume of a cylinder. You need to get the radius input from the user
Discuss a monetization model that would work for the app.
What are CAATs (Computer-aided audit tools)?
What is the most efficient way to access data when you have multiple tables?
Discuss the characteristics of a computerized information system that make it different from the manual system.
As users determine new computer application needs, request must be sent to both the system programmers and the database administrator. Why is so important that these two group perform separate functions and what are these functions?