Paste Clipboard FILE A1 3 4 5 6 7 8 9 10 11 12 13 14...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Paste Clipboard FILE A1 3 4 5 6 7 8 9 10 11 12 13 14 15 567 16 1. Prepare an income statement from a list of accounts. 17 18 HOME Calibri INSERT BIU 11 D ▼ Font PAGE LAYOUT B с D 1 The list below shows select accounts for Reading Readiness, Inc. as of January 31, 20X1. (Accounts are in alphabetical order.) 2 Accounts Payable Accounts Receivable Cash A A Equipment Income Tax Expense Operating Expense Preparing an income statement - Excel FORMULAS REVIEW G Other Expenses Other Revenues Rent Expense Salaries Expense Short-term Notes Payable Test Prep Revenue Tutoring Revenue Unearned Revenue DATA % Alignment Number Conditional Format as Cell Formatting Table Styles Styles fx The list below shows select accounts for Reading Readiness, Inc. as of January 31, $ VIEW 8,088 6,960 13,445 4,800 1,350 11,800 3,482 6,050 4,800 6,882 17,200 15,400 9,100 1,046 Cells Editing E 4 F Sign In 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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Revenues: READING READINESS, INC. Income Statement For the Month Ended January 31, 20X1 Total Revenues Expenses: Total Expenses Sheet1 M Paste Clipboard FILE A1 3 4 5 6 7 8 9 10 11 12 13 14 15 567 16 1. Prepare an income statement from a list of accounts. 17 18 HOME Calibri INSERT BIU 11 D ▼ Font PAGE LAYOUT B с D 1 The list below shows select accounts for Reading Readiness, Inc. as of January 31, 20X1. (Accounts are in alphabetical order.) 2 Accounts Payable Accounts Receivable Cash A A Equipment Income Tax Expense Operating Expense Preparing an income statement - Excel FORMULAS REVIEW G Other Expenses Other Revenues Rent Expense Salaries Expense Short-term Notes Payable Test Prep Revenue Tutoring Revenue Unearned Revenue DATA % Alignment Number Conditional Format as Cell Formatting Table Styles Styles fx The list below shows select accounts for Reading Readiness, Inc. as of January 31, $ VIEW 8,088 6,960 13,445 4,800 1,350 11,800 3,482 6,050 4,800 6,882 17,200 15,400 9,100 1,046 Cells Editing E 4 F Sign In 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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Revenues: READING READINESS, INC. Income Statement For the Month Ended January 31, 20X1 Total Revenues Expenses: Total Expenses Sheet1 M
Expert Answer:
Related Book For
Operations management processes and supply chain
ISBN: 978-0136065760
9th edition
Authors: Lee J Krajewski, Larry P Ritzman, Manoj K Malhotra
Posted Date:
Students also viewed these accounting questions
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
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 Cash 13,445...
-
Craig Corporation has just paid dividends of $3.75 per share, which the company projects will grow at a constant rate of 5% percent forever. If Craig Corporation's shareholders require a 12 percent...
-
A wooden bookshelf has external dimensions as follows :Height = 110cm, Depth = 25cm, Breadth = 85cm (see figure). The thickness of the plank is 5 cm everywhere. The external faces are to be polished...
-
Arnold is the successful owner and operator of a small business. He plans to take a one-year vacation and is interviewing Minnie for the position of manager while he is away. On the basis of...
-
Some critics argue that Six Sigma is a collection of superficial changes that often result in doing a superb job of building the wrong product or offering the wrong service. Do you agree or disagree?...
-
Does Fairmont have any contactor personnel whose have terminated but are being paid through payroll after termination (e.g., ghost employees)?
-
Claire Company produces Tablets and Books. Total overhead costs traditionally have been allocated on the basis of direct labor hours. After implementing activity-based costing, managers determined...
-
One way financial managers evaluate a firm's current financial condition is by computing ratios based on current accounts listed on the firm's financial statements. Financial managers look at four...
-
Consider the simultaneous equation of demand and supply given by D = a0 + apt + aYt + u St= Bo + Bipt + BCt + u{, (Demand equation) (Supply equation) where yt is the income level while c is the...
-
A company due to pay a certain amount of a foreign currency in the future decides to hedge with futures contracts. Which of the following best describes the advantage of hedging? It leads to a better...
-
Refer to the given data. This firm's product price is Quantity of Labor Total Product Total Revenue 1 4 $16 2 8 32 3 11 44 4 13 52 5 14 56 Multiple Choice $2. $3. $4. $16.
-
Suppose that prices in Brazil are rising faster than US prices, and the US is a very important trading partner of Brazil. (Brazil's currency is called the real.) (a) Suppose the dollar/real rate is...
-
The initial cost of a pickup truck is $10559 and will have a salvage value of $3843 after five years. Maintenance is estimated to be a uniform gradient amount of $152 per year, with zero dollar for...
-
The maintenance cost for a generator have been recorded over its five year life. Calculate EUAC at 8 percent per year. Year 1 2 3 4 5 Cost $1100 1500 1300 1900 2200
-
AssetsCash $ - 1 9 $ 1 2 Accounts receivable 3 3 4 2 3 0 Inventory 1 5 1 1 9 4 Prepaid expenses 9 5 Total current assets 4 7 5 4 4 1 Property, plant, and equipment 5 1 1 4 3 1 Less accumulated...
-
Suppose that a police car is sitting 8 feet from a highway with a radar gun a car speeds by and 1 second later is 29 feet from from the point when it passed the police car. What is the angle formed...
-
Why is homeostasis defined as the "relative constancy of the internal environments? Does negative feedback or positive feedback tend to promote homeostasis?
-
The Marlin Company produces plastic bottles to customer order. The quality inspector randomly selects four bottles from the bottle machine and measures the outside diameter of the bottle neck, a...
-
A restaurant is considering adding fresh brook trout to its menu. Customers would have the choice of catching their own trout from a simulated mountain stream or simply asking the waiter to net the...
-
MKM International is seeking to purchase a new CNC machine in order to reduce costs. Two alternative machines are in consideration. Machine 1 costs $500,000, but yields a 15 percent savings over the...
-
Some stream data have been collected from a process plant, and these are listed in Table P19.2. Assuming the minimum temperature difference between streams, \(\Delta T_{\min }=10^{\circ} \mathrm{C}\)...
-
Figure P19.3 shows a network design using steam, cooling water and some heat recovery. (a) Does this design achieve the minimum energy target for \(\Delta T_{\min }=20^{\circ} \mathrm{C}\) ? (b) If...
-
Figure P19.4 shows two hot streams and two cold streams for heat integration (subject to \(\Delta T_{\min }=20^{\circ} \mathrm{C}\) ). (i) What are the energy targets? (ii) Show a network design...
Study smarter with the SolutionInn App