Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1-Given below is a screen shot for a balance sheet while in process IC-Balence-Sheet-Template-1552 - Microsoft Excel Home Insert Page Layout Formu Data Review View

image text in transcribedimage text in transcribed

1-Given below is a screen shot for a balance sheet while in process IC-Balence-Sheet-Template-1552 - Microsoft Excel Home Insert Page Layout Formu Data Review View I Autosun Century Gothic 10 Wrap Test Accounting Merge & Center $ - %%% B 4 cun ) togy Paste Fomet Printer Clipboard H20 Insert Delete Fomat Conditional Format CHI Formatting Table Styles Style Clear Sort & Find & Fiter Select Editing Font Alignment Number Cels BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 8 10.000.00 $ 11.000.00 9 11,000.00 $ 12.000.00 23.000.00 10 20.000.00 11 59.000.00 65.800.00 12 13 100.000.00 $ 120,000.00 14 nventory $ Prepaid Expenses $ Short-Term investments $ TOTAL CURRENT ASSETS $ FIXED (LONG TERM) ASSETS Long-Term investments $ Property / Equipment $ Les Accumulated Depreciation rat negative nangiole Asets TOTAL FIXED ASSETS $ OTHER ASSETS Deferred Income Tax $ $ 50.000.00 $ 20.000.00 15 10.000.00 $ 5.000.00 Income Taxes Poyale $ 11,000.00 11.100.00 Accrued Solaries and Wages $ 11,200.00 $ 11.500.00 Uneamed Revenue $ 19.000.00 24.000.00 Cument Portion of Long-Term Debt $ 58,000.00 66,000.00 TOTAL CURRENT LIABILITIES 116,200.00 131,500.00 LONG TERM LIABILITIES Long-Term Debt $ 101,000.00 121.000.00 Deferred Income Tax $ 10,000.00 20.000.00 Other $ $ TOTAL LONG-TERM LIABILITIES 11,000.00 $ 141.000.00 OWNER'S EQUITY Owner's Investment $ 13,000.00 $ 22.900.00 Retained Earrings $ 22,000.00 $ Other 5 31,000.00 $ TOTAL OWNER'S EQUITY S 66,000.00 123.900.00 16 $ 10.000.00 $ 12.000.00 17 170,000.00 $ 157.000.00 18 19 12.000.00 20.000.00 $ 123,000.00 20.000.00 20 Other 21 TOTAL OTHER ASSETS $ 32,000.00 $ 143,000.00 22 23 TOTAL ASSETS $261,000.00 $ 345,800.00 24 TOTAL LIABILITIES AND OWNER'S EQUITY $ 293,200.00 $ 396,400.00 25 COMMON FINANCIAL RATIO # Balance Sheet [YEAR] [YEAR] 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? Page 4 16 +

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

Excel For Accountants Tips, Tricks & Techniques

Authors: Conrad Carlberg

1st Edition

1932925015, 9781932925012

More Books

Students also viewed these Accounting questions

Question

10. What is meant by a feed rate?

Answered: 1 week ago