7 Requirements: 8 1) Using the data below, create a multi-step GAAP Income Statement in appropriate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
7 Requirements: 8 1) Using the data below, create a multi-step GAAP Income Statement in appropriate professional Excel format (i.e., use cell referencing and formulas, no hard coding numbers). 92) All account titles and subtotals should be added using cell referencing. 10 11 Grading: 10 possible points 12 This spreadsheet contains macros which will provide real time feedback on EACH cell that you enter in the Solution. There are 51 cells which get graded, and your score 13 on this assignment will be calculated based upon the % of the 51 cells that are completed correctly. 14 15 Tips: 16 1) The P&L header should start in cell F23 and the first line of data should be in row 27. The Earnings Per Share header should be in cell F48 with the first line of data in row 49 17 2) All expenses should be included as negative numbers 18 3) If there is more than one line item in a category in the P&L where there is flexibility in the order, list the line items in alphabetical order 19 4) All amounts should be included in column G 205) Earnings Per Share should be taken to two decimal places 21 22 Data 23 24 25 26 Common Dividends Paid 27 Cost of Goods Sold 28 Dividend revenue 29 Gain on Sale of Discontinued Operations Nguyen Corp 12/31/25 Debit Credit $80,000 $850,000 $60,000 $200,000 Solution 21 22 Data 23 24 Nguyen Corp 12/31/25 25 Debit Credit 26 Common Dividends Paid $80,000 27 Cost of Goods Sold $850,000 28 Dividend revenue $60,000 29 Gain on Sale of Discontinued Operations $200,000 30 Gain on Sale of Equipment $70,000 31 Restructuring charge $10,000 32 Interest Expense $100,000 33 Loss on Discontinued Operations $75,000 34 Net Sales Revenue $1,870,000 35 Preferred Dividends Paid $100,000 $540,000 36 Selling & Admin Expense 37 38 Additional information: 39 Tax rate 20% 40 Common Shares Outstanding 12/31/25 41 Preferred Shares Outstanding 12/31/25 1,000,000 800,000 42 43 Possible account titles and subtotal headings for the P&L 44 (cell reference from here, some may be used more than once) 45 Cost of Goods Sold 46 Discontinued Operations 47 Dividend Revenue 48 Earnings per share 49 Gain on Sale of Discontinued Operation 50 Gain on Sale of Equipment 51 Gross Margin 52 Income from Continuing Operations 53 Income from Continuing Operations Before Taxes 54 Income from Operations 55 Income Statement 56 Interest Expense 57 Less Income Tax Expense 58 Loss on Discontinued Operations 59 Net Income 60 Net Sales Revenue 61 Net tax expense on disc operations 62 Other Expenses and Losses 63 Other Revenues and Gains 64 Restructuring Charge 65 Selling & Administrative Expenses 66 Total Discontinued Operations After Tax 67 Year Ended 12/31/25 Solution 7 Requirements: 8 1) Using the data below, create a multi-step GAAP Income Statement in appropriate professional Excel format (i.e., use cell referencing and formulas, no hard coding numbers). 92) All account titles and subtotals should be added using cell referencing. 10 11 Grading: 10 possible points 12 This spreadsheet contains macros which will provide real time feedback on EACH cell that you enter in the Solution. There are 51 cells which get graded, and your score 13 on this assignment will be calculated based upon the % of the 51 cells that are completed correctly. 14 15 Tips: 16 1) The P&L header should start in cell F23 and the first line of data should be in row 27. The Earnings Per Share header should be in cell F48 with the first line of data in row 49 17 2) All expenses should be included as negative numbers 18 3) If there is more than one line item in a category in the P&L where there is flexibility in the order, list the line items in alphabetical order 19 4) All amounts should be included in column G 205) Earnings Per Share should be taken to two decimal places 21 22 Data 23 24 25 26 Common Dividends Paid 27 Cost of Goods Sold 28 Dividend revenue 29 Gain on Sale of Discontinued Operations Nguyen Corp 12/31/25 Debit Credit $80,000 $850,000 $60,000 $200,000 Solution 21 22 Data 23 24 Nguyen Corp 12/31/25 25 Debit Credit 26 Common Dividends Paid $80,000 27 Cost of Goods Sold $850,000 28 Dividend revenue $60,000 29 Gain on Sale of Discontinued Operations $200,000 30 Gain on Sale of Equipment $70,000 31 Restructuring charge $10,000 32 Interest Expense $100,000 33 Loss on Discontinued Operations $75,000 34 Net Sales Revenue $1,870,000 35 Preferred Dividends Paid $100,000 $540,000 36 Selling & Admin Expense 37 38 Additional information: 39 Tax rate 20% 40 Common Shares Outstanding 12/31/25 41 Preferred Shares Outstanding 12/31/25 1,000,000 800,000 42 43 Possible account titles and subtotal headings for the P&L 44 (cell reference from here, some may be used more than once) 45 Cost of Goods Sold 46 Discontinued Operations 47 Dividend Revenue 48 Earnings per share 49 Gain on Sale of Discontinued Operation 50 Gain on Sale of Equipment 51 Gross Margin 52 Income from Continuing Operations 53 Income from Continuing Operations Before Taxes 54 Income from Operations 55 Income Statement 56 Interest Expense 57 Less Income Tax Expense 58 Loss on Discontinued Operations 59 Net Income 60 Net Sales Revenue 61 Net tax expense on disc operations 62 Other Expenses and Losses 63 Other Revenues and Gains 64 Restructuring Charge 65 Selling & Administrative Expenses 66 Total Discontinued Operations After Tax 67 Year Ended 12/31/25 Solution
Expert Answer:
Answer rating: 100% (QA)
To create the multistep GAAP Income Statement in Excel ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
"internet radios" for streaming audio, and personal video recorders and players. Describe design and evaluation processes that could be used by a start-up company to improve the usability of such...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Choose a company or product that you have been noticing or admiring. Develop a plan to advertise this product that involves the United States and at least one other country, and three forms of media....
-
United Apparel has the following balances in its stockholders' equity accounts on December 31, 2012: Treasury Stock, $750,000; Common Stock, $500,000; Preferred Stock, $2,600,000; Retained Earnings,...
-
For the beam shown in Figure P4-79, use a computer program to determine the deflection at the mid-span using four beam elements, making the shear area zero and then making the shear area equal 5/6...
-
What is the purpose of timelines in an investigation?
-
The comparative balance sheet of Flack Inc. for December 31, 2013 and 2012, is as follows: The income statement for the year ended December 31, 2013, is as follows: The following additional...
-
1. Write an integral using cylindrical coordinates that represents the volume between the surfaces z=x+ y and z = 6-x - y.
-
This problem continues the Draper Consulting, Inc., situation from Problem 2-62 of Chapter 2. Start from the trial balance and the posted T-accounts that Draper Consulting, Inc., prepared at December...
-
2.5 kg s-1 of a solution at 288 K containing 10 m % of dissolved solids is fed to a backward - feed double effect evaporator operating at a pressure of 20 kN m-2 in the second effect. If the product...
-
Positrons and beta particles have (1) the same charge and the same mass (2) the same charge and different masses (3) different charges and the same mass (4) different charges and different masses
-
In the circuit shown, the current in the R3 resistor is 13 = 5.2 A, and the current in the R resistor is l = 1.0 A, find the current 1. I E1- A. 6.2 A B. 5.2 A C. 2.2 A D. 8.2 A E. 4.2 A R=52 MM R=...
-
An ion will spontaneously move to an area where it is less concentrated. Ofrom an area of high enthalpy to an area of low enthalpy. wherever a protein pushes it. O toward ions with the same charge
-
sodium bicarbonate is a product of neutralization reaction between sodium hydroxide and carbonic acid. Should not we classify this compound as a salt? or a base?
-
QUESTION 5 (a) Define the term Magnification Factor (MF) and explain why it is important to determine the Magnification Factor (MF) of a system. [CO1/PO1/C2] (5 marks) (b) Figure Q5(a) shows a system...
-
1. Select a Private Higher Education Institution of your choice. Note: Ask permission to use the name of the institution. 2. Provide a detailed explanation with examples of the market/task...
-
The area of a rectangle is 30 cm 2 and its perimeter is 26 cm. Find the length and width of the rectangle.
-
Locate The Walt Disney Company's 2011 annual report on the Internet and answer the following questions. 1. What is the largest liability listed in Disney's 2011 balance sheet? 2. By what percentage...
-
The company purchased the following securities during Year 1: In Year 2, the company reclassified both of these securities. Security A was reclassified as available for sale; the fair value of...
-
On December 31, 2015, analysis of Sayer Sporting Goods' operations for 2015 revealed the following. (a) Total cash collections from customers, $105,260. (b) December 31, 2014, inventory balance,...
-
a. Suppose that General Hospital has a current ratio of 0.5. Which of the following actions would improve (increase) this ratio? Use cash to pay off current liabilities. Collect some of the current...
-
What is the role of internal control in an organization?
-
What are the elements and principles of the COSO framework?
Study smarter with the SolutionInn App