GIVEN BELOW IS A SCREEN SHOT OF BALANCE SHEET WHILE IN PROCESS IC.Balance Shelter Insert Page Formu ONE ni View Century Gothic - 10 - A == Wrap Test Accounting 27 A X Cut Copy Format Print Cleboard BIU A ER ER Merge & Center Ist Deldte format $ -% Conditional Format Cell Formatting Table Styles th 20 Sort & Find Fiter See Font . . H20 40 B D E G H BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 8 $ 10.000.00 $ 11.000.00 $ 11,000.00 $ nventory Prepaid Expenses Short-Term Investments 11.100.00 11.500.00 9 $ 11.000.00 $ 12.000.00 $ 11.200.00 $ 10 $ $ 20.000.00 $ 23.000.00 Income Taxos Payable Accrued Salones and Wages Uneamed Revenue Current Portion of Long-Term Debt TOTAL CURRENT LIABILITIES $ 19.000.00 $ 24,000.00 11 TOTAL CURRENT ASSETS $ 59.000.00 $ 65,800.00 5 50.000.00 $ 66.000.00 12 $ 116.200.00 $ 131.500.00 13 100,000.00 $ 120.000.00 LONG TERM LIABILITIES 14 FIXED (LONG TERM) ASSETS Long-Term nvestments $ Property / Equipment $ Less Accumulated Depreciation insert negative $ Intangible Assets $ 50.000.00 $ 20.000.00 $ 101.000.00 $ 15 10.000.00 $ 121.000.00 20.000.00 5.000.00 $ 10.000.00 $ 16 10,000.00 $ 12.000.00 $ 17 TOTAL PIXED ASSETS $ 170.000.00 $ 157.000.00 Long-Term Debt Deferred Income Tax Other TOTAL LONG-TERM LIABILITIES OWNEY EQUITY Ownes investment Retained Earings $ 111.000.00 $ 141,000.00 18 OTHER ASSETS 19 $ $ 12.000.00 $ 123.000.00 Deferred Income Tax Other $ 13.000.00 $ 123.900.00 20 $ 20.000.00 $ 20.000.00 $ 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 $ 345,800.00 24 TOTAL LIABILITIES AND OWNER'S EQUITY $ 293,200.00 $ 396,400.00 [YEAR] 25 COMMON FINANCIAL RATIO KM Balance Sheet Enter [YEAR] IOON S X; 3:28 AM 5/12/2011 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? GIVEN BELOW IS A SCREEN SHOT OF BALANCE SHEET WHILE IN PROCESS IC.Balance Shelter Insert Page Formu ONE ni View Century Gothic - 10 - A == Wrap Test Accounting 27 A X Cut Copy Format Print Cleboard BIU A ER ER Merge & Center Ist Deldte format $ -% Conditional Format Cell Formatting Table Styles th 20 Sort & Find Fiter See Font . . H20 40 B D E G H BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 8 $ 10.000.00 $ 11.000.00 $ 11,000.00 $ nventory Prepaid Expenses Short-Term Investments 11.100.00 11.500.00 9 $ 11.000.00 $ 12.000.00 $ 11.200.00 $ 10 $ $ 20.000.00 $ 23.000.00 Income Taxos Payable Accrued Salones and Wages Uneamed Revenue Current Portion of Long-Term Debt TOTAL CURRENT LIABILITIES $ 19.000.00 $ 24,000.00 11 TOTAL CURRENT ASSETS $ 59.000.00 $ 65,800.00 5 50.000.00 $ 66.000.00 12 $ 116.200.00 $ 131.500.00 13 100,000.00 $ 120.000.00 LONG TERM LIABILITIES 14 FIXED (LONG TERM) ASSETS Long-Term nvestments $ Property / Equipment $ Less Accumulated Depreciation insert negative $ Intangible Assets $ 50.000.00 $ 20.000.00 $ 101.000.00 $ 15 10.000.00 $ 121.000.00 20.000.00 5.000.00 $ 10.000.00 $ 16 10,000.00 $ 12.000.00 $ 17 TOTAL PIXED ASSETS $ 170.000.00 $ 157.000.00 Long-Term Debt Deferred Income Tax Other TOTAL LONG-TERM LIABILITIES OWNEY EQUITY Ownes investment Retained Earings $ 111.000.00 $ 141,000.00 18 OTHER ASSETS 19 $ $ 12.000.00 $ 123.000.00 Deferred Income Tax Other $ 13.000.00 $ 123.900.00 20 $ 20.000.00 $ 20.000.00 $ 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 $ 345,800.00 24 TOTAL LIABILITIES AND OWNER'S EQUITY $ 293,200.00 $ 396,400.00 [YEAR] 25 COMMON FINANCIAL RATIO KM Balance Sheet Enter [YEAR] IOON S X; 3:28 AM 5/12/2011 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
