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?
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
