Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I need you to do balance sheet for me, and can you make sure my work is correct thank you cvcvscvss cxcxz AutoSave OF
Hello, I need you to do balance sheet for me, and can you make sure my work is correct thank you
cvcvscvsscxcxz
AutoSave OF APvc ... Shipping Inc Accounting Cycle Spreadsheet View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibri (Body) C v 11 v A X G " V 2 Insert 2 Wrap Text Number ' v DX Delete Paste BIU :- Y ~ Ar = = = Merge & Center $ %) 4 SA Conditional Format Cell Formatting es Table Styles A Format w Sort & Filter Find & Select Analyze Data B13 fx ='Adjusted Trial Balance 1830 A C D E F G H J L L M N OP Q A S T U V W 210,000 3.000 125,000 88,000 40,080 1 Shipping Inc. 2 Income rent 3 For the Month Ended January 31, 2021 4 Sales revenue 5 Service Revenue 6 Cost of goods sold 7 Grossprolit 8 9 Operating expenses 10 Salary and Wagexpense 44,100 11 Depreciation expense 1,100 12 Intrest pense 400 13 Maintanca expense 2,000 14 Insurance Expense 320 15 Tot operating expense 47,920 16 17 Net Income 18 19 20 21 22 23 24 25 26 27 22 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 T Accounts Ending Trial Balance Adjusting Entries Adjusted Trial Balance Income Statment Closing Entries Closing Trial Balance Retained Earnings Balance Sheet + Ready el + 100% AutoSave OF APvc ... Shipping Inc Accounting Cycle Spreadsheet Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman C v 12 ~ APA V 2 Insert X [G 2 Wrap Text Custom EY DX Delete Paste BIU ~ A v A Merge & Center v $ % ) SA 20 Conditional Format Cell Formatting es Table Styles Format Sort & Filter Find & Select Analyze Data C22 x fx ='Ending Trial Balance' C20 A c D E F G H I J L M NO P Q S Credit Debit 195,260 206,1100 55,500 3,520 26,000 16,000 16,000 1 Adjusted Trial Balance Summary 2 As of January 31, 2021 3 4 S Description Cash 7 Accounts Receivable 3 Inventory 9 Prepaid Insur 10 Tumituru & Fixtures 11 Computer Equipment 12 Van 13 Accum. Der.. T&T 14 Accum Dep. - Come Fan 15 Acum. Dep. - Van 16 Accounts Payahle 17 Salaris Payable 12 Incrust Payable 19 Deferred Reme 20 Notes l'ayable 21 Commen Sinck 22 Kind Earnings 23 Service Revue 24 Sales Revenge 25 COGS 26 Depreciation Expone 27 Interest Expense 22 Salary and Wage Expose 29 Insurance Tixpense 30 Maintenance Expanse 31 Total 32 33 34 35 1,700 6,350 250 105,400 5900 400 2,000 60,000 165,000 192,200 3,000 210,000 125,000 1.100 401 44,100 320 2,000 692,200.00 692,200.00 37 38 39 40 41 T Accounts Ending Trial Balance Adjusting Entries Adjusted Trial Balance Income Statment Closing Entries Closing Trial Balance Retained Earnings Balance Sheet + Ready + 100% AutoSave OF APvc ... Shipping Inc Accounting Cyclo Spreadsheet View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Times New Roman v 12 ~ A V X C. [G 2 Wrap Text 2 Insert General ZY DX Delete Paste B IUB Y ar Ar = = = Merge & Center v 4 SA 20 Conditional Format Cell Formatting es Table Styles Format Sort & Filter Find & Select Analyze Data A2 fx As of January 1, 2021 A B C D E F G I J L M NO P Q R S S Debit 107,200.00 114_700.00 89.500.00 26,000.00 16,000.00 0.001 Credit 0.00 0.00 0.00 0.00 0.00 1,200.00 6,000.00 78.400,00 0.00 0.00 DI 1 Trial Balance Summary 2 As of January 1, 2021 3 4 S Description 6 Cash 7 Accounts Receivable 2 Inventory 9 Furniture & Fixtures 10 Cunmuler Equipment 11 Accum. Dep. - F&F 12 Acum. Dep. - Comp. Eup 13 Accounts Payuhle 14 Salaris Payable 15 Noles Payable 16 Defemed Revan 17 Common Stock 12 Retained Earnings 19 Total 20 21 22 23 24 25 26 27 28 29 30 0.00 0.00 0.00 000 60,000.00 5,000.00 60,000.00 136.200.00 35.9.600.00 353,600.00 32 33 34 35 37 38 39 40 41 Beginning Trial Balance Journal Entries T Accounts Ending Trial Balance Adjusting Entries Adjusted Trial Balance Income Statment Closing Entries Closing Trial Balance Retain + Ready + 100% AutoSave OF A A P2G ... Shipping Inc Accounting Cyclo Spreadsheet View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Times New Roman v 12 ~ A X C. [G V 2 Wrap Text 2 Insert General ZY DX Delete Paste B IUB Y AvA Av = = = Merge & Center v 4 SA 20 Conditional Format Cell Formatting es Table Styles Format Sort & Filter Find & Select Analyze Data A2 fx As of January 1, 2021 A B C D E F G I J L M NO P Q R S S Debit 107,200.00 114_700.00 89.500.00 26,000.00 16,000.00 0.001 Credit 0.00 0.00 0.00 0.00 0.00 1,200.00 6,000.00 78.400,00 0.00 0.00 DI 1 Trial Balance Summary 2 As of January 1, 2021 3 4 S Description 6 Cash 7 Accounts Receivable 2 Inventory 9 Furniture & Fixtures 10 Cunmuler Equipment 11 Accum. Dep. - F&F 12 Acum. Dep. - Comp. Eup 13 Accounts Payuhle 14 Salaris Payable 15 Noles Payable 16 Defemed Revan 17 Common Stock 12 Retained Earnings 19 Total 20 21 22 23 24 25 26 27 28 29 30 0.00 0.00 0.00 000 60,000.00 5,000.00 60,000.00 136.200.00 35.9.600.00 353,600.00 32 33 34 35 37 38 39 40 41 Beginning Trial Balance Journal Entries T Accounts Ending Trial Balance Adjusting Entries Adjusted Trial Balance Income Startment Closing Entries Closing Trial Balance Retain + Ready + 100% AutoSave OF APvc ... Shipping Inc Accounting Cyclo Spreadsheet View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibri (Body) v 11 v A A X C. G V 29 Wrap Text 2 Insert General ZY v DX Delete Paste Y ar Ar = = = Merge & Center $ % 6.CA 20 Conditional Format Cell Formatting es Table Styles Format w Sort & Filter Find & Select Analyze Data A15 fx A C D F G H K K L M N 0 P Q R 5 T DJ V V W X 1 Statement of Retained Earnings 2 Shipping Inc. 3 For the month and January 21, 2021 4 5B of Retained earning 135200 5 6 Net pret 40,080 7 8 Dividends 4000 9 10 11 Fe Retained caring 172,280 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 04 Accounts Ending Trial Balance Ready Adjusting Entries Adjusted Trial Balance Income Statment Closing Entries Closing Trial Balance + Retained Earnings Balance Sheet 3 ,, + 100% AutoSave OF APvc ... Shipping Inc Accounting Cycle Spreadsheet Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) C X IR v 12 ~ A V 2 Insert 2 Wrap Text Custom ZY v DX Delete Paste BIU :- A Y A Merge & Center v $ % ) SA 20 Conditional Format Cell Formatting es Table Styles Format Sort & Filter Find & Select Analyze Data c D E F G H I J L M NO P Q R S S Credit Debit 195,260 205,000 55,500 3,520 26,000 16,000 16,000 C22 fx 172280 A 1 Post-Closing Trial Balance Summary 2 As of January 31, 2021 3 4 S Description 6 Cra 7 Accounts Receivable 3 Inventory 9 Prepaid Insur 10 Tumituru & Fixtures 11 Computer Equipment 12 Van 13 Accum. Der.. T&T 14 Accum Dep. - Come Fan 15 Acum. Dep. - Van 1E Accounts Paynhle 17 Salaris Payable 12 Interest Payable 19 Deferred Reveme 20 Noles Payable 21 Carmen Stock 22 Hair Farnings 23 Total 24 25 26 27 28 29 30 1,700 6,350 250 105,400 5900 400 2.000 60.000 165.000 172,280 519.280.00 519.280.00 19.20.00 32 33 34 35 37 38 39 40 41 T Accounts Ending Trial Balance Adjusting Entries Adjusted Trial Balance Income Statment Closing Entries Closing Trial Balance Retained Earnings Balance Sheet + Ready + 100% AutoSave OF APvc ... Shipping Inc Accounting Cyclo Spreadsheet Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Callbel (Body) C v 11 v AP V 2 Insert X G 2 Wrap Text General ZY v DX Delete WS Paste Av = = = Y A Merge & Center v $ % SA Conditional Format Cell Formatting es Table Styles Farmat v Sort & Filter Find & Select Analyze Data C10 fx C E F G H K L M N 0 P Q R S S T u WA -31 Dr B 1 Closing Entries 2 Date 3 4 Sales revenue 5 Service revenue 6 Retired sanine 7 210000 3000 213000 9 Metairesine 172920 Salary and Wage Danse Depreciation ciparse Intres expense Maintance exone Insurance Expense COGS 44,100 1.100 400 2,000 320 125.000 4000 Retaired earning Dividents 4000 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 32 33 34 35 36 37 38 39 40 42 43 04 T Accounts Ending Trial Balance Adjusting Entries Adjusted Trial Balance Income Statment Closing Entries Closing Trial Balance Retained Earnings Balance Sheet + Ready el 100%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started