Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answers the all questions thanku 1-Given below is a screen shot for a balance sheet while in process K-Balance Sheet Template 50 - Microsoft

image text in transcribed

image text in transcribed

image text in transcribed

Please answers the all questions thanku

1-Given below is a screen shot for a balance sheet while in process K-Balance Sheet Template 50 - Microsoft Excel DNA Resin Ve Home Iniet Page Layout Formulas XO Century Gothic - 10 Copy T Fomet Painter Clipboard tiap Tet Merge Center Accounting ... Contoh Format Formatting a Table Styles THPT Sort G Agent Eng H20 BALANCE SHEET TEMPLATE Try Smartsheet for FREE Inventory $ 10.000.00 $ 11.000.00 Prepaid penses $ 1.000.00 12.000.00 Short-Term Investments $ 20,000.00 23.000.00 TOTAL CURRENT ASSETS $ 9.000.00 $ 6.500.00 HXED (LONG TERM) ASSETS Long Term investments $ 100.000.00 $ 20.000.00 Property / Equipment $50,000.00 $ 20.000.00 Les accumulated Depreciation for regalves 10.000.00 5 5.000.00 intangible Assets $ 10.000.00 $12.000.00 TOTAL MIXED ASSETS $ 170.000.00 $ 157.000.00 OTHER ASSETS Deferred income Tax $ 2.000.00 $ 20.000.00 Other $ 20,000.00 $ 20.000.00 TOTAL OTHER ASSETS $ 32.000.00 $ 143,000.00 income for Poyable $ 1.000.00 11.100.00 Accrued Salories and Wogel $ 1.200.00 $ 11.500.00 Uneamed Revere 3 19.000,00 5 24,000.00 Curent Portion of Long Term Debt $58.000.00 56.000.00 TOTAL CURRENT LIABILITIES $116.200.00 $ 131,300.00 LONG TERM LIABILITIES Long Term Debt $ 101.000.00 $ 121.000.00 Deferred income fox $ 10.000.00 $ 20,000.00 Other $ TOTAL LONG-TERM LIABILITIES $111.000.00 $ 141.000.00 OWNERS EQUITY Owner's Investment $ 13.000.00 $123.900.00 Retained Coming 5 22.000.00 Other $31.000.00 $ TOTAL OWNER'S EQUITY $66.000.00 $ 122.900.00 TOTAL ASSETS $ 20,000.00 $ 45,800.00 TOTAL LIABILITIES AND OWNERS EQUITY $295,200.00 $3,400.00 COMMON FINANCIAL RATIO Balance Sheet [YEAR] [YEAR! 10 * SN x 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? 2-Giving the following excel screenshot A B C D E F G H 1 Investment alternates (stocks ) 100 200 300 Net profit 400 200 150 300 320 170 10000 15000 22000 11000 23000 40000 100000 70000 7000 Capital invested ROI RETURN ON INVESTMENT -USE EXCELL TO CALCULATE ROI Paste your excel screenshot below here 1-Given below is a screen shot for a balance sheet while in process K-Balance Sheet Template 50 - Microsoft Excel DNA Resin Ve Home Iniet Page Layout Formulas XO Century Gothic - 10 Copy T Fomet Painter Clipboard tiap Tet Merge Center Accounting ... Contoh Format Formatting a Table Styles THPT Sort G Agent Eng H20 BALANCE SHEET TEMPLATE Try Smartsheet for FREE Inventory $ 10.000.00 $ 11.000.00 Prepaid penses $ 1.000.00 12.000.00 Short-Term Investments $ 20,000.00 23.000.00 TOTAL CURRENT ASSETS $ 9.000.00 $ 6.500.00 HXED (LONG TERM) ASSETS Long Term investments $ 100.000.00 $ 20.000.00 Property / Equipment $50,000.00 $ 20.000.00 Les accumulated Depreciation for regalves 10.000.00 5 5.000.00 intangible Assets $ 10.000.00 $12.000.00 TOTAL MIXED ASSETS $ 170.000.00 $ 157.000.00 OTHER ASSETS Deferred income Tax $ 2.000.00 $ 20.000.00 Other $ 20,000.00 $ 20.000.00 TOTAL OTHER ASSETS $ 32.000.00 $ 143,000.00 income for Poyable $ 1.000.00 11.100.00 Accrued Salories and Wogel $ 1.200.00 $ 11.500.00 Uneamed Revere 3 19.000,00 5 24,000.00 Curent Portion of Long Term Debt $58.000.00 56.000.00 TOTAL CURRENT LIABILITIES $116.200.00 $ 131,300.00 LONG TERM LIABILITIES Long Term Debt $ 101.000.00 $ 121.000.00 Deferred income fox $ 10.000.00 $ 20,000.00 Other $ TOTAL LONG-TERM LIABILITIES $111.000.00 $ 141.000.00 OWNERS EQUITY Owner's Investment $ 13.000.00 $123.900.00 Retained Coming 5 22.000.00 Other $31.000.00 $ TOTAL OWNER'S EQUITY $66.000.00 $ 122.900.00 TOTAL ASSETS $ 20,000.00 $ 45,800.00 TOTAL LIABILITIES AND OWNERS EQUITY $295,200.00 $3,400.00 COMMON FINANCIAL RATIO Balance Sheet [YEAR] [YEAR! 10 * SN x 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? 2-Giving the following excel screenshot A B C D E F G H 1 Investment alternates (stocks ) 100 200 300 Net profit 400 200 150 300 320 170 10000 15000 22000 11000 23000 40000 100000 70000 7000 Capital invested ROI RETURN ON INVESTMENT -USE EXCELL TO CALCULATE ROI 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

Core Concepts Of Accounting

Authors: Leslie K. Breitner, Robert N. Anthony

10th Edition

0136029442, 9780136029441

More Books

Students also viewed these Accounting questions