key inshort data and figureout the spreadsheet for both questions if right it will not show correct very short I only need the spreadsheets back

Problem 3-5 Name: Section: Score: 20% *Since some answer boxes are correct when left blank, the beginning score is greater than 0%. Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. Reported amounts Corrections: Adjustment a. Adjustment b. Adjustment c. Adjustment d. Corrected amounts Net Income $ 127,500 Total Assets $ 480,000 Total Liabilities $ 150,000 Total Stockholders' Equity $ 330,000 Problem 4-2 Name: Section: Score: 0% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. 1. AQUA CO. Income Statement Revenues: Expenses: Total expenses Net income 2. AQUA CO. Retained Earnings Statement Retained earnings, July 1, 20Y7 Retained earnings, June 30, 20Y8 \fSelectedaccounts And related amounts for Aqua co for the fical year end june 30 20Y8 are presented in belwo 1 prepare a single step income statement in the format shown in exhibit 3 2 Prepare a retained earnings statement Problem 3-5 Name: Section: Score: 20% *Since some answer boxes are correct when left blank, the beginning score is greater than 0%. Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. Reported amounts Corrections: Adjustment a. Adjustment b. Adjustment c. Adjustment d. Corrected amounts Net Income $ 127,500 Total Assets $ 480,000 Total Liabilities $ 150,000 Total Stockholders' Equity $ 330,000 1/16/2017 Copyright | CENGAGE Learning | Survey of Accounting | Edition: 7 | martin8558@yahoo.com | Printed from www.chegg.com Copyright CENGAGE Learning Survey of Accounting Edition: 7 martin8558@yahoo.com Printed from www.chegg.com Copyright CENGAGE Learning Survey of Accounting Edition: 7 martin8558@yahoo.com Printed from www.chegg.com Copyright CENGAGE Learning Survey of Accounting Edition: 7 martin8558@yahoo.com Printed from www.chegg.com Copyright CENGAGE Learning Survey of Accounting Edition: 7 martin8558@yahoo.com Printed from www.chegg.com Creating Print Version http://1285974360.reader.chegg.com/reader/print.php?id=bd063983f27caff392d5b3a69deb1823&name=Survey%20of%20Accounting&range=369246612420092&... 1/2 1/16/2017 Copyright | CENGAGE Learning | Survey of Accounting | Edition: 7 | martin8558@yahoo.com | Printed from www.chegg.com Creating Print Version http://1285974360.reader.chegg.com/reader/print.php?id=bd063983f27caff392d5b3a69deb1823&name=Survey%20of%20Accounting&range=369246612420092&... 2/2 Problem 3-5 Name: Section: Score: 100% *Since some answer boxes are correct when left blank, the beginning score is greater than 0%. Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. Reported amounts Corrections: Adjustment a. Adjustment b. Adjustment c. Adjustment d. Corrected amounts Net Income $ 127,500 Total Assets $ 480,000 Total Liabilities $ 150,000 Total Stockholders' Equity $ 330,000 9,700 (8,000) (1,150) (975) $ 127,075 9,700 (8,000) 0 (975) $ 480,725 0 0 1,150 0 $ 151,150 9,700 (8,000) (1,150) (975) $ 329,575 Problem 3-5 Name: Section: Score: 100% *Since some answer boxes are correct when left blank, the beginning score is greater than 0%. Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. Reported amounts Corrections: Adjustment a. Adjustment b. Adjustment c. Adjustment d. Corrected amounts Net Income $ 127,500 Total Assets $ 480,000 Total Liabilities $ 150,000 Total Stockholders' Equity $ 330,000 9,700 (8,000) (1,150) (975) $ 127,075 9,700 (8,000) 0 (975) $ 480,725 0 0 1,150 0 $ 151,150 9,700 (8,000) (1,150) (975) $ 329,575