Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedRequired 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?

IC-Balance Sheet-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Century Gothic - 10 PT Wrap Text Accounting o % Cut Copy Paste Format Painter Clipboard BIU-- A- $ % 28.09 Insert Delete Format E Merge & Center Alignment Conditional Format Cell Formatting as Table Styles Styles AutoSum Fill- Sort & Find & 2 Clear Filter - Select Editing Number Cells Font fr 0 H20 a A B D G H BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 1 8 8 11,000.00 11,100.00 9 12,000.00 11.500.00 10 23.000.00 11,000.00 $ 11,200.00 $ 19.000.00 $ 58,000.00 $ 116,200.00 $ 24.000.00 11 65,800.00 66,000.00 131,500.00 12 13 14 Inventory $ 10,000.00 $ Prepaid Expenses $ 11.000.00 $ Short-Term Investments 20.000.00 $ TOTAL CURRENT ASSETS $ 59,000.00 $ $ FIXED (LONG TERM) ASSETS ) Long-Term Investments $ 100,000.00 $ Property / Equipment $ 50.000.00 $ (Less Accumulated Depreciation) insert negative $ 10.000.00 $ $ Intangible Assets $ 10,000.00 $ $ TOTAL FIXED ASSETS $ 170,000.00 $ OTHER ASSETS Deferred Income Tax $ 12.000.00 $ Other $ 20.000.00 $ TOTAL OTHER ASSETS $ 32,000.00 $ 120,000.00 20.000.00 5.000.00 15 Income Taxes Payable $ Accrued Salaries and Wages $ Unearned Revenue $ Current Portion of Long-Term Debt $ TOTAL CURRENT LIABILITIES $ LONG TERM LIABILITIES Long-Term Debt $ Deferred Income Tax $ Other $ TOTAL LONG-TERM LIABILITIES $ OWNER'S EQUITY Owner's Investment $ Retained Earnings $ Other $ TOTAL OWNER'S EQUITY $ 101,000.00 $ 21.000.00 10.000.00 $ 20.000.00 $ $ 111,000.00 $ 141,000.00 16 12,000.00 17 157,000.00 18 19 123,000.00 123.900.00 20 20.000.00 143,000.00 13,000.00 $ 22.000.00 $ 31,000.00 $ + 21 22 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 H Balance Sheet Diechimera Enter E 100% + WS S X8 EN . 3:28 AM 5/12/2021 IC-Balance Sheet-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Century Gothic - 10 PT Wrap Text Accounting o % Cut Copy Paste Format Painter Clipboard BIU-- A- $ % 28.09 Insert Delete Format E Merge & Center Alignment Conditional Format Cell Formatting as Table Styles Styles AutoSum Fill- Sort & Find & 2 Clear Filter - Select Editing Number Cells Font fr 0 H20 a A B D G H BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 1 8 8 11,000.00 11,100.00 9 12,000.00 11.500.00 10 23.000.00 11,000.00 $ 11,200.00 $ 19.000.00 $ 58,000.00 $ 116,200.00 $ 24.000.00 11 65,800.00 66,000.00 131,500.00 12 13 14 Inventory $ 10,000.00 $ Prepaid Expenses $ 11.000.00 $ Short-Term Investments 20.000.00 $ TOTAL CURRENT ASSETS $ 59,000.00 $ $ FIXED (LONG TERM) ASSETS ) Long-Term Investments $ 100,000.00 $ Property / Equipment $ 50.000.00 $ (Less Accumulated Depreciation) insert negative $ 10.000.00 $ $ Intangible Assets $ 10,000.00 $ $ TOTAL FIXED ASSETS $ 170,000.00 $ OTHER ASSETS Deferred Income Tax $ 12.000.00 $ Other $ 20.000.00 $ TOTAL OTHER ASSETS $ 32,000.00 $ 120,000.00 20.000.00 5.000.00 15 Income Taxes Payable $ Accrued Salaries and Wages $ Unearned Revenue $ Current Portion of Long-Term Debt $ TOTAL CURRENT LIABILITIES $ LONG TERM LIABILITIES Long-Term Debt $ Deferred Income Tax $ Other $ TOTAL LONG-TERM LIABILITIES $ OWNER'S EQUITY Owner's Investment $ Retained Earnings $ Other $ TOTAL OWNER'S EQUITY $ 101,000.00 $ 21.000.00 10.000.00 $ 20.000.00 $ $ 111,000.00 $ 141,000.00 16 12,000.00 17 157,000.00 18 19 123,000.00 123.900.00 20 20.000.00 143,000.00 13,000.00 $ 22.000.00 $ 31,000.00 $ + 21 22 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 H Balance Sheet Diechimera Enter E 100% + WS S X8 EN . 3:28 AM 5/12/2021

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Financial Accounting

Authors: Thomas H. Beechy

5th Edition

0131236997, 9780131236998

Students also viewed these Accounting questions