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?
-
Perform research on the Internet to identify an ASP that offers Web-based business solutions, and write a brief memo describing the firm and its services.
-
Icahn Tackel just signed an $11.5 million, four year contract with an NFL team. He received a signing bonus of $2 million; $1.5 million at the end of year one; $3 million at the end of year two; $3.5...
-
The opportunity cost rate is the rate of interest one could earn on an alternative investment with a risk equal to the risk of the investment in question. This is the value of \(\mathrm{i}\) in the...
-
Multiple Choice Questions The following questions concern auditing complex IT systems. Choose the best response. a. Which of the following client IT systems generally can be audited without examining...
-
Pardo Company produces a single product and has capacity to produce 1 8 0 , 0 0 0 units per month. Costs to produce its current monthly sales of 1 4 4 , 0 0 0 units follow. The normal selling price...
-
Spotlight Ltd has issued share capital of 60,000----8% redeemable cumulative preference shares of ~ 20 each and 4,00,000 equity shares of ~ 10 each. The preference shares are redeemable at a premium...
-
Classify each of the following audit procedures according to the types of audit evidence: i. Review the accounts receivable with the credit manager to evaluate their collectability ii. Compare a...
-
write two pages review for the article The 4 dimensions of digital trust, charted across 42 countries by Bhaskar Chakravorti, Ajay Bhalla, and Ravi Shankar Chaturvedi to give a personal opinion about...
-
10. Which age group is commonly affected by common variablehypogammaglobulinemia? A) Children under 10 years B) People between 40 and 50 years C) Between 13 and 35 years D) Older adults above 60...
-
For the circuit shown, the switch closes at t=0. t=0 (with do 40 % A 0.2 F 120 100 10 V a) Modify the circuit above for t-0-. Solve for the only value that cannot change instantaneously when the...
-
Dime-a-Dozen Diamonds makes synthetic diamonds by treating carbon. Each diamond can be sold for $180. The materials cost for a synthetic diamond is $120. The fixed costs incurred each year for...
-
Consider you are a Software Engineer the task given by the manager to prepare a SRS (Use any Standard template) for any application. Mention their steps. Define their outline, product purpose, how to...
-
6 . Considering what you have learned about negotiations, what concepts / principles would you describe as being the most relevant in Fiji vs FIJI case: Negotiating over water? Explain your
-
Suppose the spot and six-month forward rates on the Norwegian krone are Kr 5.78 and Kr 5.86, respectively. The annual risk-free rate in the United States is 3.8 percent, and the annual risk-free rate...
-
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....
-
Recording payroll and payroll costs Le Banquet Francaise restaurant employs 1 man- ager, 2 chefs, 4 waiters, and 3 helpers. They are paid monthly as follows: All personnel are entitled to a half...
-
Overtime pay for a production department Harnagle Company employs ten produc- tion workers who are paid $7.50 per hour for first shift and a 50 percent overtime premium for any hours worked in excess...
-
Payroll costs and bonus Marsha's Ceramics has two highly-skilled employees who design and produce exquisite ceramic pieces. Each earns a salary of $1,495 per month. Each also gets 1 /2 month of paid...
N Oxidation Of Drugs Biochemistry Pharmacology Toxicology 1st Edition - ISBN: 9401053782 - Free Book
Study smarter with the SolutionInn App