Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1-Given below is a screen shot for a balance sheet while in process 1C-Balance Sheet-Template-8552 - Microsoft Excel Data Review View . Home Insert Page
1-Given below is a screen shot for a balance sheet while in process 1C-Balance Sheet-Template-8552 - Microsoft Excel Data Review View . Home Insert Page Layout Formulas X Cut Century Gothic - 10 - A A Copy BIU. Fomat Painter A Clipboard Font Wrap Test Accounting Puite Merge & Center Insert Delete Fomat $% 499 Conditional Format - % Chl Formatting Table Styles Number Sylei Autosum Fill Sort & Find a 2 Clear Filter Select Editing Allgaient Cells H20 fo A B C D E G 1 BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 8 9 10 11 12 13 14 Inventory $ 10.000.00 $ 1.000.00 Prepaid Expenses $ 11,000.00 $ 12.000.00 Short-Term Investments $ 20.000.00 $ 23,000.00 TOTAL CURRENT ASSETS $59.000.00 $ 65.800.00 FIXED (LONG TERM) ASSETS Long Term Investments $ 100,000.00 $ 120,000.00 Property / Equipment $ 50,000.00 $ 20.000.00 Lers Accumulated Depreciation insert negative $ 10.000.00 $ 5.000.00 Intangible Assets $ 10,000.00 $ 12,000.00 TOTAL FIXED ASSETS $ 170,000.00 $ 157,000.00 OTHER ASSETS Deferred Income Tax $ 12,000.00 $ 123.000.00 Other $ 20,000.00 $ 20.000.00 TOTAL OTHER ASSETS $ 32,000.00 $ 143.000.00 15 Income Taxes Poyable $ 11,000.00 $ 11,100.00 Accrued Salaries and Woges $ 11.200.00 $ 11,500.00 Unearned Revenue $ 19.000.00 $ 24.000.00 Current 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 $ 10.000.00 $ 121,000.00 Deferred Income Tax $ 10.000.00 $ 20.000.00 Other $ $ TOTAL LONG-TERM LIABILITIES$ 111,000.00 $ 141,000.00 OWNER'S EQUITY Owner's investment $ 13,000.00 $ 123.900.00 Retained Coming $ 22.000.00 + Other $ 31,000.00 $ TOTAL OWNER'S EQUITY $ 66,000.00 $ 123,900.00 16 17 18 19 20 21 22 23 TOTAL ASSETS $ 241,000.00 $ 365,800.00 TOTAL LIABILITIES AND OWNER'S EQUITY $ 293,200.00 $ 394,400.00 24 25 COMMON FINANCIAL RATIO MA)Balance Sheet Enter [YEAR] [YEAR] DO 100% S X EN . a 3:28 AM 5/12/2021 Required How will you you balance the two sides 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started