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 MEWrap Text Accounting Fill A cut

image text in transcribed

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

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

Auditing and Assurance Services

Authors: Timothy Louwers, Allen Blay, David Sinason, Jerry Strawser, Jay Thibodeau

7th edition

978-1259573286, 1259573281, 978-1260152166

More Books

Students also viewed these Accounting questions