Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

IC-Balance Sheel-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Autosum Century Gothic . 10 . AN BrWrap Text Accounting Fill BIU

image text in transcribed

IC-Balance Sheel-Template-8552 - Microsoft Excel Home Insert Page Layout Formulas Data Review View Autosum Century Gothic . 10 . AN BrWrap Text Accounting Fill BIU $ Merge & Center A cut Copy Paste Format Painter Clipboard I H20 Insert Delete Format Clear . Conditional Format Cell Formatting as Table Styles Number Sor Filt Editing Font Alignment Styles Cells fx 0 B 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 Income Taxes Payable Accrued Solares and Wages 9 11,000.00 $ 12.000.00 $ 11.200.00 $ 11,500.00 10 20.000.00 $ 23.000.00 Unearned Revenue $ 24,000.00 19.000.00 $ 58,000.00 $ 11 59,000.00 $ 65,800.00 Current Portion of Long-Term Debt $ 66,000.00 12 Inventory $ Prepaid Expenses $ Short-Term Investments $ TOTAL CURRENT ASSETS $ FIXED (LONG TERM) ASSETS Long-Term Investments $ Property / Equipment $ Less Accumulated Depreciation insert negative $ Intangible Assets $ 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 $ 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 $ 13,000.00 $ 123.900.00 + 20 Other $ 20.000.00 $ Owner's Investment Retained Earnings Other 20.000.00 $ 22,000.00 $ 21 TOTAL OTHER ASSETS 32,000.00 $ 143,000.00 $ 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 Oscar 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 BrWrap Text Accounting Fill BIU $ Merge & Center A cut Copy Paste Format Painter Clipboard I H20 Insert Delete Format Clear . Conditional Format Cell Formatting as Table Styles Number Sor Filt Editing Font Alignment Styles Cells fx 0 B 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 Income Taxes Payable Accrued Solares and Wages 9 11,000.00 $ 12.000.00 $ 11.200.00 $ 11,500.00 10 20.000.00 $ 23.000.00 Unearned Revenue $ 24,000.00 19.000.00 $ 58,000.00 $ 11 59,000.00 $ 65,800.00 Current Portion of Long-Term Debt $ 66,000.00 12 Inventory $ Prepaid Expenses $ Short-Term Investments $ TOTAL CURRENT ASSETS $ FIXED (LONG TERM) ASSETS Long-Term Investments $ Property / Equipment $ Less Accumulated Depreciation insert negative $ Intangible Assets $ 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 $ 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 $ 13,000.00 $ 123.900.00 + 20 Other $ 20.000.00 $ Owner's Investment Retained Earnings Other 20.000.00 $ 22,000.00 $ 21 TOTAL OTHER ASSETS 32,000.00 $ 143,000.00 $ 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 Oscar 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

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

The Development Of The American Public Accounting Profession

Authors: T.A. Lee

1st Edition

0415403944, 9780415403948

More Books

Students also viewed these Accounting questions

Question

=+b) Drivers scores on the written part of a driving test.

Answered: 1 week ago