Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Old MathJax webview 1-Given below is a screen shot for a balance sheet while in process Its AYA 9. Cance-ext2552 - Excel Home Print Pot

Old MathJax webview

image text in transcribed

image text in transcribed

1-Given below is a screen shot for a balance sheet while in process Its AYA 9. Cance-ext2552 - Excel Home Print Pot lapod formula de foie En View A CU Century Gothic 30 IX == lot Accounting Pasite Jumta IV. Mery Center - Carel Font 83 Fonning This Coboard Sy 120 TA B C D E Inlet Deo 2 Sat Find Fiter Select ating Ce G BALANCE SHEET TEMPLATE Try Smartsheet for FREE 1 8 9 10 11 12 13 14 Inventory $ 10.000.00 11.000.00 Prepaid Expenses $ 1.000.00 5 12.000.00 Short-Term investments $ 20.00.00 $ 23.000.00 TOTAL CURRENT ASSETSS 59.000.00 $ 65.800.00 RXEO PIXED (LONG TERM) ASSETS Longform investments $ 100.000.00 $ 120.000.00 Property / Equipment $ 50.000.00 220.000.00 Les Accumulated Depreciation negative 10.000.00 5.000.00 Intangible Alles 5 10.000.00 12000 TOTAL PRED ASSETS $ 170,000.00 $ 157.000.00 OTHER ASIETS Deferred income for $ 12.000.00 $ 122.000.00 Other $ 20.000.00 $ 20.000.00 TOTAL OTHER ASSETS $ 32.000.00 $ 19.000.00 .. 15 Income To Payable $ 11,000.00 5 11.100.00 Accrued Scieries and Wages $ 1.200.00 11.500.00 Uneamed Revenue $19.000.00 24.000.00 Curent Portion of Long Term Debt $ 98.000.00 5000.00 TOTAL CURRENT LIABILMES 11.200.00 $ 131 530.00 LONG TERM LIABILITIES Long Term Debt $ 101.000 DO 3/7 Defend ncome Tax $ 10.000 Other $ TOTAL LONG-TERM LIABILITIES 111.000.00 $ 1.000.00 OWNER'S EQUITY Owner's investment 5 13.000.00 $ 123,900.00 Retained Earnings $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 $ 211,000.00 $ 45,800.00 TOTAL LASILITIES AND OWNER'S EQUITY 199,200.00 $ 54,400.00 [YEAR] COMMON FINANCIAL RATIO * Balance Sheet [YEAR] ] En S SE 1 AM 52 Required How will you balance the two sides 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? 1-Given below is a screen shot fc a balance sheet while in process Lady 1C-Balance Shest-Teplie-155 cm bied hun Insert Pelayu Form Data Review Vi Century Gothic - 10 === I Autasun Fan AA A F# LU Copy Paste Format Painter God Test Anunting Mert Center - Conditional Format 01 Formatting a Table Styles Shes nint Delte Tomat 20 Sort Find Filter Sale ating Cl H20 . LO c D E F BALANCE SHEET TEMPLATE Try Smartsheel for FREE inventory 5 10.000.00 11.000.00 Income Taxes Poyable $ 11,100.00 11.500.00 $ 11.000.00 $ 12.000.00 Accrued Salaries and Wogel $ Prepaid Expenses Short-Term nvestments 11.000.00 11.200.00 5 19.000.00 58.000.00$ 5 20.000.00 23.000.00 Uneamed Revenue $ 24,000.00 TOTAL CURRENT ASSETS $ 59000.00 $ 65.800.00 $6.000.00 116.200.00 131.500.00 120.000.00 100.000.00 50.000.00 Current Portion of Long Term Debt 5 TOTAL CURRENT LIABILITIES $ LONG TERM LIABILITIES Long Term Debt $ Detened income Tax 5 Other 20.000.00 101.000.00 FIXED (LONG TERM) ASSETS Longform nvestments $ Property / Equipment 5 Less Accumulated Depreciation insert regativt $ Intangible Assets TOTAL FIXED ASSETS $ 121.000.00 10.000.00 5 5.000.00 10.000.00 20.000.00 10.000.00 12.000.00 1 170.000.00 157.000.00 TOTAL LONG-TERM LIABILITIES 5 111.000.00 141 000.00 OTHER ASSETS OWNERS EQUITY $ $ 13.000.00 Deferred Income Tax Other 12.000.00 20.000.00 123.000.00 20.000.00 Owners investment Retained Earning 123.900.00 + $ $ 22.000.00 TOTAL OTHER ASSETS $ 32.000.00 $ 1.000.00 Other $ 31.000.00 66.000.000 TOTAL OWNER'S EQUITY $ 122.900.00 TOTAL ASSETS $ 21,000.00 $ 345,800.00 TOTAL LIABILITIES AND OWNER'S EQUITY $ 293,200.00 $ 316,400.00 COMMON FINANCIAL RATIO Balance Sheet [YEAR] [YEAR] En N EN. 224 Required How will you balance the the tw sides of the above balanc sheet(particularly cells no C2 G24 that are the total asset an total liabilities ? paste your exco

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Accounting Principles

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

9th Edition

978-0470317549, 9780470387085, 047031754X, 470387084, 978-0470533475

Students also viewed these Accounting questions