The list below shows select accounts for Reading Readiness Company as of January 31, 20X1. (Accounts...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The list below shows select accounts for Reading Readiness Company as of January 31, 20X1. (Accounts are in alphabetical order.) Accounts Payable 8,088 Accounts Receivable 6,960 13,445 4,800 Cash Equipment Insurance Expense Operating Expense Other Expenses 1,350 11,800 3,482 6,050 Other Revenues Rent Expense Salaries Expense Short-term Notes Payable Test Prep Revenue Tutoring Revenue Unearned Revenue 4,800 6,882 17,200 15,400 9,100 1,046 ment i Saved B D E F 19 Required: 20 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references 21 to select account titles and amounts to be included on the income statement. 22 Note: List revenues and expenses in order of largest to smallest dollar amounts. 23 24 2. After entering the formula in cell C42, use the Excel IF function to label cell B42 as either "Net Income" or 25 "Net Loss" as appropriate based on the value calculated in cell C42. 26 27 READING READINESS Company 28 Income Statement For the Month Ended January 31, 20X1 29 30 Revenues: 31 32 33 Total Revenues Expenses: 34 35 36 37 38 39 40 41 Total Expenses The list below shows select accounts for Reading Readiness Company as of January 31, 20X1. (Accounts are in alphabetical order.) Accounts Payable 8,088 Accounts Receivable 6,960 13,445 4,800 Cash Equipment Insurance Expense Operating Expense Other Expenses 1,350 11,800 3,482 6,050 Other Revenues Rent Expense Salaries Expense Short-term Notes Payable Test Prep Revenue Tutoring Revenue Unearned Revenue 4,800 6,882 17,200 15,400 9,100 1,046 ment i Saved B D E F 19 Required: 20 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references 21 to select account titles and amounts to be included on the income statement. 22 Note: List revenues and expenses in order of largest to smallest dollar amounts. 23 24 2. After entering the formula in cell C42, use the Excel IF function to label cell B42 as either "Net Income" or 25 "Net Loss" as appropriate based on the value calculated in cell C42. 26 27 READING READINESS Company 28 Income Statement For the Month Ended January 31, 20X1 29 30 Revenues: 31 32 33 Total Revenues Expenses: 34 35 36 37 38 39 40 41 Total Expenses
Expert Answer:
Answer rating: 100% (QA)
Solution 1 READING READINESS INC Income Statement 2 For the Month Ended January 31 ... View the full answer
Related Book For
Experiencing MIS
ISBN: 978-0133153934
3rd Canadian Edition
Authors: David M. Kroenke, Andrew Gemino, Peter Tingling
Posted Date:
Students also viewed these accounting questions
-
Based on Problem 2-9A, prepare an income statement for Jay Pembroke for the month of April 20--. Problem 2-9A: Jay Pembroke started a business. During the first month (April 20--), the following...
-
Based on Problem 2-9B, prepare an income statement for David Segal for the month of October 20. Problem 2-9B: David Segal started a business. During the first month (October 20--), the following...
-
Prepare an income statement for a profitable small business. Include at least 10 operating expenses. Use an income tax rate of 25%.
-
List the key principles of the six Sigma philosophy. How does it differ from TQM?
-
What objectives of financial reporting does the cash flow statement serve? Explain
-
The writer is considering revising the phrase which tomatoes should become salsa or sauce and which should be served raw in a salad or sandwich in the preceding sentence to read: which tomatoes...
-
Ruby Pharmacy allocates indirect expenses to its three departments on the basis of sales. For the year ended 30 June 2024, the following allocations were made. Required (a) Determine the allocation...
-
In a merger under state law, Anchor Corporation acquires all the assets of Tower Corporation. Towers assets have a $5 million FMV and a $2.2 million adjusted basis. Assuming Tower liquidates, which...
-
Read the three factual scenarios and discuss whether the actions were done under color of state law. Please give reasons in support of your conclusion. Two New York City police officers removed...
-
A pipe-pump assembly is being considered by a farmer for use in irrigating a field during summer. There is an underground water well that is 75 m deep. The well is an open-hole type in which the free...
-
You have ascertained the following information to assist with your assessment: Cloud 9 is registered for VAT and charges 23% VAT on its sales. VAT returns are submitted on-line following the end of...
-
How do logistics managers effectively manage the supply chain? Why do companies need to pay close attention to managing logistics?
-
Why are customers increasingly vital in the creation of innovative new products and services? How has this come about?
-
Identify a new product that you have recently adopted into your daily lifestyle. Discuss each step of the consumer buyer decision process as it relates to the purchase decision with your adopted new...
-
Alicia is a self-employed hair stylist who owns her own salon. She has asked you to consult with her on how to generate more revenue. Using the price adjustment strategies, advise Alicia on her...
-
Explain how the mix of different retailer types is changing. What are the trends moving toward?
-
Describe what is a peacemaking court. Discuss three qualities or characteristics of a peacemaking court. Describe how peacemaking courts are different than adversarial courts used in Western...
-
Use the T account for Cash below to record the portion of each of the following transactions, if any that affect cash. How do these transactions affect the companys liquidity? Jan. 2 Provided...
-
1. What are the primary benefits realized by Edocs use of HELM software? 2. Could HELM also result in increased revenue? Explain your answer. 3. Can you think of other benefits that might arise from...
-
Choose one of the following basic business processes: inventory management, operations, manufacturing, HR management, or accounting/financial management. Use the Internet to identify three vendors...
-
Suppose Akbars company, noted earlier in the chapter introduction, is located in a hurricane zone and that it has been given 36 hours warning that a serious, category 4 hurricane is headed its way....
-
Dunkirk Consulting wishes to predict the amount of overhead expense that will be incurred by a consulting contract, to develop more accurate bids for future con- tracts. Dunkirk has the following...
-
Block Commodities has gathered the following information concerning rock salt deliveries to its clients, which it believes are highly seasonal: a. Suppose Block Commodities calculated a set of...
-
The service center at a large automobile dealership is trying to boost revenue by pro- viding no-appointment-necessary oil changes to any type of vehicle that stops by the service center. To quickly...
Study smarter with the SolutionInn App