Answered step by step
Verified Expert Solution
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
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 hereStep 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