Requirements: $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$).2)$ All account titles and subtotals should be added using cell referencing.$$ Grading: $10$ possible points 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 on this assignment will be calculated based upon the $\%$ of the $51$ cells that are completed correctly. Tips: $1)$ The P&L header should start in cell F$23$ and the first line of data should be in row $27.$ The Earnings Per Share header should be in cell F$48$ with the first line of data in row $492)$ All expenses should be reported as negative numbers $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 $4)$ All$$ labels should be included in column F and all amounts should be included in column G $5)$ Earnings Per Share should be taken to two decimal places. The first and last numbers in the P&L should be formatted as dollar amounts, all other rows should have comma formatting. Data $$ Solution $$ Nguyen Corp Nguyen Corp $12/31/2025$ Income Statement $$ Debit Credit Year Ended $12/31/25$ Common Dividends Paid $$80,000$ Cost of Goods Sold $900,000$ Net Sales Revenue $$$$1,870,000$ Dividend revenue $60,000$ Cost of Goods Sold $(900,000)$ Gain on Sale of Discontinued Operations $200,000$ Gross Margin $970,000$ Gain on Sale of Equipment $70,000$ Selling & Administrative Expenses $(540,000)$ Restructuring charge $10,000$ Income from Operations $$ Interest Expense $100,000$ Other Revenues and Gains $$ Loss on Discontinued Operations $75,000$ Dividend Revenue $60,000$ Net Sales Revenue $1,870,000$ Gain on Sale of Equipment $70,000$ Preferred Dividends Paid $100,000$ Other Expenses and Losses $$ Selling & Administrative Expenses $$540,000$ Interest Expense $100,000$ Restructuring Charge $10,000$ Additional information: $$ Income from Continuing Operations Before Taxes $-$ Tax rate $20\%$ Less Income Tax Expense $1,870,000$ Common Shares Outstanding $12/31/251,000,000$ Income from Continuing Operations$-$ Preferred Shares Outstanding $12/31/25800,000$ Discontinued Operations $$ Gain on Sale of Discontinued Operation$200,000$ Possible account titles and subtotal headings for the P&L$$ Loss on Discontinued Operations$75,000($cell reference from here, some may be used more than once$)$ Net tax expense on disc operations $-$ Cost of Goods Sold $$ Total Discontinued Operations After Tax $-$ Discontinued Operations $$ Net Income $-$ Dividend Revenue $$ Earnings per share $$ Earnings per share $$ Gain on Sale of Discontinued Operation$$ Income from Continuing Operations$$$$-$ Gain on Sale of Equipment $$ Gain on Sale of Discontinued Operation$$$$70,000$ Gross Margin $$ Loss on Discontinued Operations$$$$75,000$ Income from Continuing Operations$$ Net tax expense on disc operations $$ Income from Continuing Operations Before Taxes $$ Net Income $$ Income from Operations $$ Income Statement $$ Interest Expense $$ Less Income Tax Expense $$ Loss on Discontinued Operations$$ Net Income $$ Net Sales Revenue $$ Net tax expense on disc operations $$ Nguyen Corp $$ Other Expenses and Losses $$ Other Revenues and Gains $$ Restructuring Charge $$ Selling & Administrative Expenses $$ Total Discontinued Operations After Tax $$ Year Ended $12/31/25$

$$PLEASE LOOK AT THE PHOTO AS WELL