can someone please help me fill in the adjusting entries, closing entries, and ending balance. There is a picture of the income statement as well.

this is the table broken up because it won't allow me to post the whole picture. This is what needs to be filled out.

I need the closing entries column for debit and credit filled. The second picture posted.

https://drive.google.com/file/d/17I3nhr_uWdrVvH_Xb6oLfdJueXytn3oD/view?usp=drivesdk

Sales Cost of Goods Sold Gross Profit SG&A Expenses 5 Operating Profit 6 Interest Expense 7 Taxable Income 8 Income Tax 19 Net Income Q1 Q2 Q3 $420,000 $480,000 $720,000 -377,195 -376.535 -449,745 $42,805 $103,465 $270,255 $108,200 $110.800 $121.200 $65,395 $7,335 $149,055 $0 $ (720) $ (10,020) $65,395 $8,055 $139,035 SO SO $41,711 $14,904 $25,529 $63,535 20 G 5 E Adjusting Entries Debit Credit Closing Entries Debit Credit Ending Bal Debit Credit 7 Worksheet 8 Cash Beginning Bal Debit Credit 5,909 2,000 210,000 121.927 2,400,000 200.000 480,000 121.927 60,000 5.000 53,545 108,831 9 Savings Account 10 Accounts Receivable 11 Inventory 12 Fixed Assets-Mfg 13 Fixed Assets-SG&A 14 Accum Depreciation-Mfg 15 Accum Depreciation-SG&A 16 Accounts Payable 17 Loans Payable 18 Interest Payable 19 Income Tax Payable (Benefit) 20 Capital Stock 21 Additional Paid in Capital 22 Retained Earnings 23 Sales 24 COGS 25 SG&A Expenses 26 Interest Expense 27 Income Tax Expense 28 6,387 300,000 2,500,000 14.904 29 Totals $ 2,939,836 $ 2,939,836 $ 2.580,000 $ 2,580,000 $ 3,535,595 $ 3.535,595 Sheet1 Ready Accessibility: Good to go Q1 Q2 Q3 Q4 Annual $420.000 $480,000 $720,000 $960,000 $2,580,000 -377.195 -376.535 -449.745 -566.385 $ (1,769,860) $42,805 $103,465 $270,255 $393,615 $810,140 $108,200 $110.800 $121,200 $131.600 ($471,800) $65.395 $7,335 $149,055 $262,015 $338,340 $0 $ (720) $ (10,020) $ (18,030) $ (28,770) $65,395 $8,055 $139,035 $243,985 $309,570 $0 $0 $41.711 $73.195 $114.906 $14,904 $25,529 $63.535 $102,445 $194,664 7 Budgeted Income Statement by Quarter For the Year Ended Dec 31, 2021 8 9 $ 10 Q1 11 Sales $420,000 12 Cogs -377.195 13 Gross Profit $42,805 14 SG&A Expenses $108,200 15 Operating Profit $65.395 16 Interest Expense $0 17 Taxable Income $65.395 18. Income Tax Q2 03 Q4 $480,000 $720,000 $960,000 -376,535 -449,745-566,385 $ $103.465 $270.255 $393,615 $110.800 $121.200 $131.600 $7,335 $149.055 $262.015 $ (720) $ (10,020) $ (18,030) $ $8.055 $139.035 $243.985 $0. $41.711 $73.195 $25,529 $63,535 $102,445 19 Net Income $14.904 Q2 Q3 Cash Budget 2021 Beg Cash Collections Disbursements: 01 $5.909 $420,000 $0 $0 19563 DM $450.000 25568 $25.568 $97.759 $187.855 $19.563 ($64.000) $204.600 DL $600,000 35573 $35.578 $136,000 $196.725 $31,200 $90,000 $0 $10.020 $18.200 $90.000 $0 $20.800 $90.000 $330.498 $0 $720 Total OH Costs VSGA FSGA Capital Purchases Interest Expense Tax Expense Change to Cash Balance Trfd (To)/From Savings Loans borrowed (repaid) 1 Ending Cash ($6.387) $2.000 $24.000 $310.000 ($67.000) $49.159 $55.968 $89.449 Q1 $5.909 $420.000 Q2 $0 $450.000 25568 Q3 $0 $600,000 19563 35573 $25.568 $35.573 $136.000 $19.663 K$64.000) $204.600 $18.200 $90.000 $0 $97.759 $187.855 $20.800 $90.000 Q4 $56,205 $840,000 48913 $48,913 $187.000 $249.025 $41,600 $90,000 $0 $18.030 $41,711 $196,725 $31.200 $90.000 $0 $330.498 $720 $0 $10.020 ($6.387 ance Fings repaid) $2.000 $24.000 $310.000 ($67.000) 248000 $49.159 $55.968 $89.449 $5,170 24 16 17 Use the template below to prepare the Cash Budget. 18 19 Cash Budget 2021 20 Beg Cash 21 Collections 22 Disbursements 23 DM DL 25 Total OH Costs 26 VSGA FSGA 28 Capital Purchases 29 Interest Expense 30 Tax Expense 31 Change to Cash Balance 32 Trfd (To)/From Savings 33 Loans borrowed (repaid) 34 35 Ending Cash 36 Q1 $5,909 $420,000 19563 $19.563 ($64,000) $204.600 $18,200 $90,000 $0 $0 ($6,387) Q2 Q3 Q4 $0 $0 $56,205 $450,000 $600,000 $840,000 25568 35573 48913 $25.568 $35 573 $48.913 $97.759 $136.000 $187.000 $187,855 $196,725 $249,025 $20.800 $31,200 $41,600 $90,000 $90,000 $90.000 $330.498 $0 $0 $720 $10.020 $18.030 $41.711 27 $2,000 $24,000 $310,000 ($67,000) 248000 $49,159 $55.968 $89,449 $5,170 37 38 39 10 Sheet1 Beginning Bal Adjusting Entries Debit Credit Closing Ents Debit Yorksheet Debit Credit Cash 5.909 Savings Account 2.000 Accounts Receivable 210,000 121.927 2.400.000 200,000 60,000 Inventory Fixed Assets-Mfg Fixed Assets-SG&A Accum Depreciation-Mfg Accum Depreciation-SG&A Accounts Payable Loans Payable B Interest Payable Income Tax Payable (Benefit) 0 Capital Stock 1 Additional Paid in Capital 5,000 53.545 6,387 300,000 2,500,000 6.387 300,000 2.500.000 14.904 18 Interest Payable 19 Income Tax Payable (Benefit) 20 Capital Stock 21 Additional Paid in Capital 22 Retained Earnings 23 Sales 24 COGS 25 SG&A Expenses 26 Interest Expense 27 Income Tax Expense 28 2.939.836 2.580,00 2.939.836 $ $ 2.580.000 $ 29 Totals 2 Sheet1 F guling Bal. Adjusting Entries Debit Credit Closing Entries Debit Credit Credit Ending Bal Debit Credit 09 00 20 480,000 121,927 27 00 00 60,000 5.000 53,545 108,831 6,387 300,000 2,500,000 14,904 Quiz 2 Test Feb 12, 2022 4:54 PM GRADED 40.00 Master Budget Project: Budgeted Income Statement by Quarter COGS calculation units Sold DM Rate (2.3 * $1.45) Total DM (DM rate * Units Sold) *DL Rate ($17*.75) Total DL (DL Rate * Units sold) Units required for production Total OH cost OH Rate (OH cost/units required for production) Total OH for COGS (OH rate * units sold) Q1 Q2 Q3 Q4 Total 7000 8000 12000 16000 3.335 3.335 3.335 3.335 23345 26680 40020 53360 12.75 12.75 12.75 12.75 89250 102000 153000 204000 7200 8800 12800 14200 $272,160 $272,640 $273,840 $274,260 $37.80 $30.98 $21.39 $19.31 264,600.00 247,854.55 256,725.00 309,025.35 * Total COGS (sum of highlights) 377,195.00 376,534.55 449,745.00 566,385.35 1,769,859.90 Correct Budgeted Income Statement: SUBMITTED Assignment View Rubric w Q4 Cash Budget COGS calculation Q1 Units Sold DM rate (2.3*$1.45) Total DM 2/3 DM 1/3 DM Calculated DM DL rate ($17*.75) Total DL 2/3DL 1/3 DL Calculated DL Units required for production Total OH Cost OH Rate (OH costs/units required for production) Total OH for COGS Q2 7000 3.34 23,345 15,563 7,782 $19,653 12.75 89,250 59,500 29,750 $64,000 7200 (272,160.0) 37.80 264,600 Q3 8000 3.34 26,680 17,787 8,893 25,568 12.75 102,000 68,000 34,000 97,750 8800 (272,640.0) 30.98 247,855 12000 3.34 40,020 26,680 13,340 35,573 12.75 153,000 102,000 51,000 136,000 12800 (273,840.0) 21.39 256,725 16000 3.34 53,360 35,573 17,787 48,913 12.75 204,000 136,000 68,000 187,000 14200 (274,260.0) 19.31 309,025 Fixed Asset Depreciation (2400000/10)=240,000 ($60,000) ($60,000) ($60,000) ($60,000) OH Costs minus Depreciation (204,600.00) (187,854.55) (196,725.00) (249,025.35) Q3 Cash Budget COGS calculation Q1 Units Sold DM rate (2.3*$1.45) Total DM 2/3 DM 1/3 DM Calculated DM DL rate ($17*.75) Total DL 2/3DL 1/3 DL Calculated DL Units required for production Total OH Cost OH Rate (OH costs/units required for production) Total OH for COGS Q2 7000 3.34 23,345 15,563 7,782 $19,653 12.75 89,250 59,500 29,750 $64,000 7200 (272,160.0) 37.80 264,600 8000 3.34 26,680 17,787 8,893 25,568 12.75 102,000 68,000 34,000 97,750 8800 (272,640.0) 30.98 247,855 Q4 12000 3.34 40,020 26,680 13,340 35,573 12.75 153,000 102,000 51,000 136,000 12800 (273,840.0) 21.39 256,725 16000 3.34 53,360 35,573 17,787 48,913 12.75 204,000 136,000 68,000 187,000 14200 (274,260.0) 19.31 309,025 Fixed Asset Depreciation (2400000/10)=240,000 ($60,000) ($60,000) ($60,000) ($60,000) OH Costs minus Depreciation (204,600.00) (187,854.55) (196,725.00) (249,025.35) 18 04 01 $5,909 $420,000 Q2 $49,159 $450,000 Q3 $55,968 $89,449 $600,000 $840,000 11 19 Cash Budget 2021 20 Beg Cash 21 Collections 22 Disbursements: 23 DM 24 DL 25 Total OH Costs 26 VSGA 27 FSGA 28 Capital Purchases 29 Interest Expense 30 Tax Expense 31 Change to Cash Balance 32 Trfd (To) From Savings 33 Loans borrowed (repaid) 34 35 Ending Cash ($19,653) ($64,000) $204,600 $18,200 $90,000 $0 $0 $6,387 $23.159 $2,000 $24,000 $25,568 $97,750 $187,855 $20,800 $90,000 $330,498 $720 $35,573 $48,913 $136,000 $187,000 $196,725 $249,025 $31,200 $41,600 $90,000 $90,000 $0 $0 $10,020 $18,030 $41,711 $156,449 $253,170 $254,032 $310,000 ($67,000) $248,000 $49,159 $55,968 $89,449 $5,170 A B E F Budgeted Income Statement by Quarter For the Year Ended Dec 31, 2021 1 Sales 2 Cost of Goods Sold 3 Gross Profit 44 SG&A Expenses 15 Operating Profit 16 Interest Expense 17 Taxable Income 18 Income Tax 19 Net Income Q1 Q2 Q3 04 Annual $420,000 $480,000 $720,000 $960.000 $2,580,000 (-377.195 1-376.535 -449.745 1-566.385|$ (1,769,860) $42,805 $103,465 $270.255 $393,615 $810.140 $108,200 $110.800 $121,200 $131.600 ($471,800) $65,395 $7,335 $149,055 $262.015 $338,340 $0 $ (720) $ (10,020) S (18,030) $ (28,770) $65,395 $8,055 $139,035 $243,985 $309,570 $0 $0 $41,711 $73.195 $114,906 $14.904 $25,529 $63,535 $102,445 $194,664 20 1 Sales Cost of Goods Sold Gross Profit SG&A Expenses 5 Operating Profit 6 Interest Expense 7 Taxable Income 8 Income Tax 19 Net Income Q1 Q2 Q3 $420,000 $480,000 $720,000 -377,195 -376.535 -449,745 $42,805 $103,465 $270,255 $108,200 $110.800 $121.200 $65,395 $7,335 $149,055 $0 $ (720) $ (10,020) $65,395 $8,055 $139,035 SO SO $41,711 $14,904 $25,529 $63,535 20 G 5 E Adjusting Entries Debit Credit Closing Entries Debit Credit Ending Bal Debit Credit 7 Worksheet 8 Cash Beginning Bal Debit Credit 5,909 2,000 210,000 121.927 2,400,000 200.000 480,000 121.927 60,000 5.000 53,545 108,831 9 Savings Account 10 Accounts Receivable 11 Inventory 12 Fixed Assets-Mfg 13 Fixed Assets-SG&A 14 Accum Depreciation-Mfg 15 Accum Depreciation-SG&A 16 Accounts Payable 17 Loans Payable 18 Interest Payable 19 Income Tax Payable (Benefit) 20 Capital Stock 21 Additional Paid in Capital 22 Retained Earnings 23 Sales 24 COGS 25 SG&A Expenses 26 Interest Expense 27 Income Tax Expense 28 6,387 300,000 2,500,000 14.904 29 Totals $ 2,939,836 $ 2,939,836 $ 2.580,000 $ 2,580,000 $ 3,535,595 $ 3.535,595 Sheet1 Ready Accessibility: Good to go Q1 Q2 Q3 Q4 Annual $420.000 $480,000 $720,000 $960,000 $2,580,000 -377.195 -376.535 -449.745 -566.385 $ (1,769,860) $42,805 $103,465 $270,255 $393,615 $810,140 $108,200 $110.800 $121,200 $131.600 ($471,800) $65.395 $7,335 $149,055 $262,015 $338,340 $0 $ (720) $ (10,020) $ (18,030) $ (28,770) $65,395 $8,055 $139,035 $243,985 $309,570 $0 $0 $41.711 $73.195 $114.906 $14,904 $25,529 $63.535 $102,445 $194,664 7 Budgeted Income Statement by Quarter For the Year Ended Dec 31, 2021 8 9 $ 10 Q1 11 Sales $420,000 12 Cogs -377.195 13 Gross Profit $42,805 14 SG&A Expenses $108,200 15 Operating Profit $65.395 16 Interest Expense $0 17 Taxable Income $65.395 18. Income Tax Q2 03 Q4 $480,000 $720,000 $960,000 -376,535 -449,745-566,385 $ $103.465 $270.255 $393,615 $110.800 $121.200 $131.600 $7,335 $149.055 $262.015 $ (720) $ (10,020) $ (18,030) $ $8.055 $139.035 $243.985 $0. $41.711 $73.195 $25,529 $63,535 $102,445 19 Net Income $14.904 Q2 Q3 Cash Budget 2021 Beg Cash Collections Disbursements: 01 $5.909 $420,000 $0 $0 19563 DM $450.000 25568 $25.568 $97.759 $187.855 $19.563 ($64.000) $204.600 DL $600,000 35573 $35.578 $136,000 $196.725 $31,200 $90,000 $0 $10.020 $18.200 $90.000 $0 $20.800 $90.000 $330.498 $0 $720 Total OH Costs VSGA FSGA Capital Purchases Interest Expense Tax Expense Change to Cash Balance Trfd (To)/From Savings Loans borrowed (repaid) 1 Ending Cash ($6.387) $2.000 $24.000 $310.000 ($67.000) $49.159 $55.968 $89.449 Q1 $5.909 $420.000 Q2 $0 $450.000 25568 Q3 $0 $600,000 19563 35573 $25.568 $35.573 $136.000 $19.663 K$64.000) $204.600 $18.200 $90.000 $0 $97.759 $187.855 $20.800 $90.000 Q4 $56,205 $840,000 48913 $48,913 $187.000 $249.025 $41,600 $90,000 $0 $18.030 $41,711 $196,725 $31.200 $90.000 $0 $330.498 $720 $0 $10.020 ($6.387 ance Fings repaid) $2.000 $24.000 $310.000 ($67.000) 248000 $49.159 $55.968 $89.449 $5,170 24 16 17 Use the template below to prepare the Cash Budget. 18 19 Cash Budget 2021 20 Beg Cash 21 Collections 22 Disbursements 23 DM DL 25 Total OH Costs 26 VSGA FSGA 28 Capital Purchases 29 Interest Expense 30 Tax Expense 31 Change to Cash Balance 32 Trfd (To)/From Savings 33 Loans borrowed (repaid) 34 35 Ending Cash 36 Q1 $5,909 $420,000 19563 $19.563 ($64,000) $204.600 $18,200 $90,000 $0 $0 ($6,387) Q2 Q3 Q4 $0 $0 $56,205 $450,000 $600,000 $840,000 25568 35573 48913 $25.568 $35 573 $48.913 $97.759 $136.000 $187.000 $187,855 $196,725 $249,025 $20.800 $31,200 $41,600 $90,000 $90,000 $90.000 $330.498 $0 $0 $720 $10.020 $18.030 $41.711 27 $2,000 $24,000 $310,000 ($67,000) 248000 $49,159 $55.968 $89,449 $5,170 37 38 39 10 Sheet1 Beginning Bal Adjusting Entries Debit Credit Closing Ents Debit Yorksheet Debit Credit Cash 5.909 Savings Account 2.000 Accounts Receivable 210,000 121.927 2.400.000 200,000 60,000 Inventory Fixed Assets-Mfg Fixed Assets-SG&A Accum Depreciation-Mfg Accum Depreciation-SG&A Accounts Payable Loans Payable B Interest Payable Income Tax Payable (Benefit) 0 Capital Stock 1 Additional Paid in Capital 5,000 53.545 6,387 300,000 2,500,000 6.387 300,000 2.500.000 14.904 18 Interest Payable 19 Income Tax Payable (Benefit) 20 Capital Stock 21 Additional Paid in Capital 22 Retained Earnings 23 Sales 24 COGS 25 SG&A Expenses 26 Interest Expense 27 Income Tax Expense 28 2.939.836 2.580,00 2.939.836 $ $ 2.580.000 $ 29 Totals 2 Sheet1 F guling Bal. Adjusting Entries Debit Credit Closing Entries Debit Credit Credit Ending Bal Debit Credit 09 00 20 480,000 121,927 27 00 00 60,000 5.000 53,545 108,831 6,387 300,000 2,500,000 14,904 Quiz 2 Test Feb 12, 2022 4:54 PM GRADED 40.00 Master Budget Project: Budgeted Income Statement by Quarter COGS calculation units Sold DM Rate (2.3 * $1.45) Total DM (DM rate * Units Sold) *DL Rate ($17*.75) Total DL (DL Rate * Units sold) Units required for production Total OH cost OH Rate (OH cost/units required for production) Total OH for COGS (OH rate * units sold) Q1 Q2 Q3 Q4 Total 7000 8000 12000 16000 3.335 3.335 3.335 3.335 23345 26680 40020 53360 12.75 12.75 12.75 12.75 89250 102000 153000 204000 7200 8800 12800 14200 $272,160 $272,640 $273,840 $274,260 $37.80 $30.98 $21.39 $19.31 264,600.00 247,854.55 256,725.00 309,025.35 * Total COGS (sum of highlights) 377,195.00 376,534.55 449,745.00 566,385.35 1,769,859.90 Correct Budgeted Income Statement: SUBMITTED Assignment View Rubric w Q4 Cash Budget COGS calculation Q1 Units Sold DM rate (2.3*$1.45) Total DM 2/3 DM 1/3 DM Calculated DM DL rate ($17*.75) Total DL 2/3DL 1/3 DL Calculated DL Units required for production Total OH Cost OH Rate (OH costs/units required for production) Total OH for COGS Q2 7000 3.34 23,345 15,563 7,782 $19,653 12.75 89,250 59,500 29,750 $64,000 7200 (272,160.0) 37.80 264,600 Q3 8000 3.34 26,680 17,787 8,893 25,568 12.75 102,000 68,000 34,000 97,750 8800 (272,640.0) 30.98 247,855 12000 3.34 40,020 26,680 13,340 35,573 12.75 153,000 102,000 51,000 136,000 12800 (273,840.0) 21.39 256,725 16000 3.34 53,360 35,573 17,787 48,913 12.75 204,000 136,000 68,000 187,000 14200 (274,260.0) 19.31 309,025 Fixed Asset Depreciation (2400000/10)=240,000 ($60,000) ($60,000) ($60,000) ($60,000) OH Costs minus Depreciation (204,600.00) (187,854.55) (196,725.00) (249,025.35) Q3 Cash Budget COGS calculation Q1 Units Sold DM rate (2.3*$1.45) Total DM 2/3 DM 1/3 DM Calculated DM DL rate ($17*.75) Total DL 2/3DL 1/3 DL Calculated DL Units required for production Total OH Cost OH Rate (OH costs/units required for production) Total OH for COGS Q2 7000 3.34 23,345 15,563 7,782 $19,653 12.75 89,250 59,500 29,750 $64,000 7200 (272,160.0) 37.80 264,600 8000 3.34 26,680 17,787 8,893 25,568 12.75 102,000 68,000 34,000 97,750 8800 (272,640.0) 30.98 247,855 Q4 12000 3.34 40,020 26,680 13,340 35,573 12.75 153,000 102,000 51,000 136,000 12800 (273,840.0) 21.39 256,725 16000 3.34 53,360 35,573 17,787 48,913 12.75 204,000 136,000 68,000 187,000 14200 (274,260.0) 19.31 309,025 Fixed Asset Depreciation (2400000/10)=240,000 ($60,000) ($60,000) ($60,000) ($60,000) OH Costs minus Depreciation (204,600.00) (187,854.55) (196,725.00) (249,025.35) 18 04 01 $5,909 $420,000 Q2 $49,159 $450,000 Q3 $55,968 $89,449 $600,000 $840,000 11 19 Cash Budget 2021 20 Beg Cash 21 Collections 22 Disbursements: 23 DM 24 DL 25 Total OH Costs 26 VSGA 27 FSGA 28 Capital Purchases 29 Interest Expense 30 Tax Expense 31 Change to Cash Balance 32 Trfd (To) From Savings 33 Loans borrowed (repaid) 34 35 Ending Cash ($19,653) ($64,000) $204,600 $18,200 $90,000 $0 $0 $6,387 $23.159 $2,000 $24,000 $25,568 $97,750 $187,855 $20,800 $90,000 $330,498 $720 $35,573 $48,913 $136,000 $187,000 $196,725 $249,025 $31,200 $41,600 $90,000 $90,000 $0 $0 $10,020 $18,030 $41,711 $156,449 $253,170 $254,032 $310,000 ($67,000) $248,000 $49,159 $55,968 $89,449 $5,170 A B E F Budgeted Income Statement by Quarter For the Year Ended Dec 31, 2021 1 Sales 2 Cost of Goods Sold 3 Gross Profit 44 SG&A Expenses 15 Operating Profit 16 Interest Expense 17 Taxable Income 18 Income Tax 19 Net Income Q1 Q2 Q3 04 Annual $420,000 $480,000 $720,000 $960.000 $2,580,000 (-377.195 1-376.535 -449.745 1-566.385|$ (1,769,860) $42,805 $103,465 $270.255 $393,615 $810.140 $108,200 $110.800 $121,200 $131.600 ($471,800) $65,395 $7,335 $149,055 $262.015 $338,340 $0 $ (720) $ (10,020) S (18,030) $ (28,770) $65,395 $8,055 $139,035 $243,985 $309,570 $0 $0 $41,711 $73.195 $114,906 $14.904 $25,529 $63,535 $102,445 $194,664 20 1