Question: IC-Balance Sheel-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Autosum Century Gothic 10 - AN MEWrap Text Accounting Fill A cut

 IC-Balance Sheel-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data

IC-Balance Sheel-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Autosum Century Gothic 10 - AN MEWrap Text Accounting Fill A cut Copy Paste Format Painter Clipboard BIU Merge Center $ Insert Delete Format Clear . . Conditional Format Cell Formatting as Table Styles Number Sor Filt Editing Font Alignment Styles Cells H20 fx 0 A B C. D E F G H BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 8 10,000.00 $ 11,000.00 $ 11,000.00 $ 11,100.00 9 11.000.00 $ 12.000.00 $ 11.200.00 $ 11.500.00 Inventory $ Prepaid Expenses $ Short-Term Investments $ TOTAL CURRENT ASSETS $ Income Taxes Payable Accrued Salaries and Wages Unearned Revenue Current Portion of Long-Term Debt 10 20,000.00 $ 23.000.00 $ 24,000.00 19.000.00 $ 58,000.00 $ 11 59,000.00 $ 65,800.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 FIXED (LONG TERM) ASSETS Long-Term Investments $ Property / Equipment $ Less Accumulated Depreciation insert negative $ Intangible Assets $ 50,000.00 $ 20.000.00 $ 101.000.00 $ 121.000.00 Long-Term Debt Deferred Income Tax 15 10.000.00 $ 5,000.00 $ 10,000.00 $ 20.000.00 16 10,000.00 $ 12.000.00 Other $ $ 17 TOTAL FIXED ASSETS $ 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 Earnings $ 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 H Balance Sheet charge Enter OU 100% EN .. 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 Sheel-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Autosum Century Gothic 10 - AN MEWrap Text Accounting Fill A cut Copy Paste Format Painter Clipboard BIU Merge Center $ Insert Delete Format Clear . . Conditional Format Cell Formatting as Table Styles Number Sor Filt Editing Font Alignment Styles Cells H20 fx 0 A B C. D E F G H BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 8 10,000.00 $ 11,000.00 $ 11,000.00 $ 11,100.00 9 11.000.00 $ 12.000.00 $ 11.200.00 $ 11.500.00 Inventory $ Prepaid Expenses $ Short-Term Investments $ TOTAL CURRENT ASSETS $ Income Taxes Payable Accrued Salaries and Wages Unearned Revenue Current Portion of Long-Term Debt 10 20,000.00 $ 23.000.00 $ 24,000.00 19.000.00 $ 58,000.00 $ 11 59,000.00 $ 65,800.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 FIXED (LONG TERM) ASSETS Long-Term Investments $ Property / Equipment $ Less Accumulated Depreciation insert negative $ Intangible Assets $ 50,000.00 $ 20.000.00 $ 101.000.00 $ 121.000.00 Long-Term Debt Deferred Income Tax 15 10.000.00 $ 5,000.00 $ 10,000.00 $ 20.000.00 16 10,000.00 $ 12.000.00 Other $ $ 17 TOTAL FIXED ASSETS $ 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 Earnings $ 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 H Balance Sheet charge Enter OU 100% EN .. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!