Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Old MathJax webview Given below is a screen shot for a balance sheet while in process How will you balance the two sides of the

Old MathJax webview

Given below is a screen shot for a balance sheet while in process How will you balance the two sides of the above balance sheet(particularly cells no C23, G24 that are the total asset and total liabilities ? paste your excel screenshot answer below here ..Paste your excel screenshot below here?

image text in transcribed

this is full question.

process . 1C-Balance Sheet-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Autosun Century Gothic - 10 AN Wrap Text Accounting % cut Copy Paste Format Painter Clipboard BIU Merge & Center $%, Insert Delete Format 2. Conditional Format Cell Formatting as Table Styles G Styles Clear Sort & Find & Filter Select Editing Font Alignment Number Cells H20 fro A D E G H BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 8 $ 10,000.00 $ 11,000.00 $ 11,000.00 $ 11.100.00 Inventory Prepaid Expenses Short-Term Investments Income Taxes Payable Accrued Salaries and Woges 9 $ 11,000.00 $ 12,000.00 $ 11,200.00 $ 11.500.00 10 $ 20,000.00 $ 23.000.00 Unearned Revenue $ 19.000.00 $ 24,000.00 11 TOTAL CURRENT ASSETS $ 59,000.00 $ 65,800.00 Current Portion of Long-Term Debt 58,000.00 $ 66.000.00 12 TOTAL CURRENT LIABILITIES $ 116,200.00 $ 131,500.00 13 100,000.00 $ 120,000.00 LONG TERM LIABILITIES 14 50,000.00 20,000.00 Long-Term Debt $ 101.000.00 $ 121.000.00 FIXED (LONG TERM) ASSETS Long Term Investments $ Property / Equipment $ Less Accumulated Depreciation insert negative $ Intangible Assets $ TOTAL FIXED ASSETS $ 15 10.000.00 $ 5.000.00 Deferred Income Tax $ 10.000.00 $ 20.000.00 16 10,000.00 $ 12,000.00 Other $ $ 17 170,000.00 $ 157,000.00 TOTAL LONG-TERM LIABILITIES $ 111,000.00 $ 141,000.00 18 OTHER ASSETS OWNER'S EQUITY 19 Deferred Income Tax $ 12.000.00 $ 123.000.00 Owner's investment $ 13,000.00 $ 123.900.00 20 Other $ 20,000.00 $ 20,000.00 Retained Earrings $ 22.000.00$ 21 TOTAL OTHER ASSETS $ 32,000.00 $ 143,000.00 Other 31,000.00 $ 22 TOTAL OWNER'S EQUITY $ 66,000.00 $ 123.900.00 23 TOTAL ASSETS $ 261,000.00 $ 365,800.00 24 TOTAL LIABILITIES AND OWNER'S EQUITY $ 293,200.00 $ 396,400.00 [YEAR] [YEAR] 25 COMMON FINANCIAL RATIO # Balance Sheet came Enter BO 100% + 3:28 AM EN. OP 1 5/12/2021 Required How will you balance the two sides of the above balance sheet(particularly cells no C23, G24 that are the total asset and total liabilities ? paste your excel screenshot answer below here ... Paste your excel screenshot below here? process . 1C-Balance Sheet-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Autosun Century Gothic - 10 AN Wrap Text Accounting % cut Copy Paste Format Painter Clipboard BIU Merge & Center $%, Insert Delete Format 2. Conditional Format Cell Formatting as Table Styles G Styles Clear Sort & Find & Filter Select Editing Font Alignment Number Cells H20 fro A D E G H BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 8 $ 10,000.00 $ 11,000.00 $ 11,000.00 $ 11.100.00 Inventory Prepaid Expenses Short-Term Investments Income Taxes Payable Accrued Salaries and Woges 9 $ 11,000.00 $ 12,000.00 $ 11,200.00 $ 11.500.00 10 $ 20,000.00 $ 23.000.00 Unearned Revenue $ 19.000.00 $ 24,000.00 11 TOTAL CURRENT ASSETS $ 59,000.00 $ 65,800.00 Current Portion of Long-Term Debt 58,000.00 $ 66.000.00 12 TOTAL CURRENT LIABILITIES $ 116,200.00 $ 131,500.00 13 100,000.00 $ 120,000.00 LONG TERM LIABILITIES 14 50,000.00 20,000.00 Long-Term Debt $ 101.000.00 $ 121.000.00 FIXED (LONG TERM) ASSETS Long Term Investments $ Property / Equipment $ Less Accumulated Depreciation insert negative $ Intangible Assets $ TOTAL FIXED ASSETS $ 15 10.000.00 $ 5.000.00 Deferred Income Tax $ 10.000.00 $ 20.000.00 16 10,000.00 $ 12,000.00 Other $ $ 17 170,000.00 $ 157,000.00 TOTAL LONG-TERM LIABILITIES $ 111,000.00 $ 141,000.00 18 OTHER ASSETS OWNER'S EQUITY 19 Deferred Income Tax $ 12.000.00 $ 123.000.00 Owner's investment $ 13,000.00 $ 123.900.00 20 Other $ 20,000.00 $ 20,000.00 Retained Earrings $ 22.000.00$ 21 TOTAL OTHER ASSETS $ 32,000.00 $ 143,000.00 Other 31,000.00 $ 22 TOTAL OWNER'S EQUITY $ 66,000.00 $ 123.900.00 23 TOTAL ASSETS $ 261,000.00 $ 365,800.00 24 TOTAL LIABILITIES AND OWNER'S EQUITY $ 293,200.00 $ 396,400.00 [YEAR] [YEAR] 25 COMMON FINANCIAL RATIO # Balance Sheet came Enter BO 100% + 3:28 AM EN. OP 1 5/12/2021 Required How will you balance the two sides of the above balance sheet(particularly cells no C23, G24 that are the total asset and total liabilities ? paste your excel screenshot answer below here ... Paste your excel screenshot below here

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Managerial Accounting Concepts

Authors: Thomas Edmonds, Christopher Edmonds, Bor Yi Tsay, Philip Old

7th edition

978-0077632427, 77632427, 78025656, 978-0078025655

More Books

Students also viewed these Accounting questions