Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please include excel formulas; Need help balancing this balance sheet. No question, just fill in the blanks with excel equations as shown on the other

Please include excel formulas; Need help balancing this balance sheet. image text in transcribedimage text in transcribed

No question, just fill in the blanks with excel equations as shown on the other image. I just need help in figuring out why the balance sheet is not balancing. What am I doing wrong?

2016A 5560 11539 17,099.0 4690 5553 2017A 3,433.0 10,569.0 14,002.0 5,607.0 6,983.0 5210 2956 35,508.0 90105 53934 36,171.0 960 299 15322 23593 347 907 1180 77,819. 0 113,327.0 2,908.0 29,500.0 100,395.0 59.286.0 41,109.0 860.0 12,404.0 37,134.0 714.0 840.0 688.0 9 3,749.0 123,249.0 BALANCE SHEET ASSETS 2015A 32 Cash & Equivalents 15308 33 Short Term Investments 10005 34 Cash & Equivs & ST Investments 25,313.0 35 Receivables (ST) 4787 36 Inventories 5167 37 Current Tax Assets 2036 38 Assets Held for Sale (ST) 39 Other Current Assets 3053 40 Total Current Assets 40,356.0 41 Gross Property Plant & Equip 83396 42 Accumulated Depreciation 51538 43 Net Property Plant & Equip 31,858.0 44 Receivables (LT) 45 Long Term Investments 12374 46 Intangible Assets 15265 47 Prepayments (LT) 623 48 Deferred LT Assets 600 49 Other Assets 1029 50 Total Fixed Assets 62,709.0 51 Total Assets 103,065.0 LIABILITIES & EQUITY 53 Liabilities 54 Accounts Payable 2063 55 Accrued Expenses 8782 56 Accounts Payable & Accrued Exps 10845 57 Current Debt 2634 58 Other Current Liabilities 2188 59 Total Current Liabilities 15,667.0 60 LT Debt & Leases 20036 61 Deferred LT Liabilities 2539 62 Minority Interests 0 63 Other Liabilities 2841 64 Total Liabilities 41,083.0 Equity 66 Temporary Equity 67 Common Share Capital 23411 68 Retained Earnings 37614 69 Accum Other Comprehensive Income 70 For Curr Trans (BS) -515 71 Other Equity 515 72 Total Equity 37,614.0 73 Total Liabilities & Equity 78,697.0 FALSE 52 2475 9555 12030 4634 3638 20,302.0 20649 1730 0 3538 46,219.0 2,928.0 11,061.0 13989 1,776.0 1,656.0 17,421.0 25,037.0 3,046.0 0.0 7,860.0 53,364.0 897 866.0 26,074.0 42,083.0 862.0 60 882 25373 40747 106 -519 519 40,747.0 86,966.0 FALSE -9.0 9.0 42,083.0 95,447.0 FALSE 74 ASSETS BALANCE SHEET 2015 15308 10005 =B32+B33 4787 5167 2036 =B31+1 5560 11539 =C32+C33 4690 5553 =C31+1 3433 10569 =D32+D33 5607 6983 32 Cash & Equivalents 33 Short Term Investments 34 Cash & Equivs & ST Investments 35 Receivables (ST) 36 Inventories 37 Current Tax Assets 38 Assets Held for Sale (ST) 39 Other Current Assets 40 Total Current Assets 41 Gross Property Plant & Equip 42 Accumulated Depreciation 43 Net Property Plant & Equip 44 Receivables (LT) 45 Long Term Investments 46 Intangible Assets 47 Prepayments (LT) 48 Deferred LT Assets 49 Other Assets 50 Total Fixed Assets 51 Total Assets 3053 =SUM(B34:B39) 83396 51538 =B41-B42 960 12374 15265 623 600 1029 =SUM(B43: B49) =B40+B50 LIABILITIES & EQUITY Liabilities 2063 8782 =B54+B55 2634 2188 =SUM(B56:B58) 20036 2539 - 5210 2956 =SUM(C34:C39) 90105 53934 =C41-C42 299 15322 23593 347 907 1180 =SUMC43:049) =C40+C50 2908 =SUM(D34:D39) 100395 59286 =D41-D42 860 12404 37134 714 840 688 =SUM(D43:D49) =D40+D50 52 54 Accounts Payable 55 Accrued Expenses 56 Accounts Payable & Accrued Exps 57 Current Debt 58 Other Current Liabilities 59 Total Current Liabilities 60 LT Debt & Leases 61 Deferred LT Liabilities 62 Minority Interests 63 Other Liabilities 64 Total Liabilities 2475 9555 =C54+C55 4634 3638 =SUM(C56:C58) 20649 1730 2928 11061 =D54+D55 1776 1656 =SUM(D56:D58) 25037 3046 2841 =B59+SUM(B60:363) 3538 7860 =C59+SUM(C60:C63) =D59+SUM(D60:D63) 65 Equity 66 Temporary Equity 67 Common Share Capital 68 Retained Earnings 69 Accum Other Comprehensive Income 70 For Curr Trans (BS) 71 Other Equity 72 Total Equity 73 Total Liabilities & Equity 897 882 866 23411 25373 26074 37614 40747 42083 60 106 862 -515 -519 515 519 =B68-SUM(B70:B71) =C68-SUM(C70:C71) =D68-SUMD 70:D71) =B72+B64 =C72+C64 =D72+D64 =1F (B51=B73,TRUE,FAL! =IF(C51EC73,TRUE,FAL! =IF(D51=D73,TRUE,FALSE) -9

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

Financial Accounting For Decision Makers

Authors: Peter Atrill

8th Edition

1292099046, 978-1292099040

More Books

Students also viewed these Accounting questions

Question

b. Will there be one assigned leader?

Answered: 1 week ago

Question

1. Try oral, open-book, or group tests.

Answered: 1 week ago

Question

What are the functions of top management?

Answered: 1 week ago

Question

Bring out the limitations of planning.

Answered: 1 week ago

Question

Why should a business be socially responsible?

Answered: 1 week ago

Question

Discuss the general principles of management given by Henri Fayol

Answered: 1 week ago

Question

b. Did you suppress any of your anger? Explain.

Answered: 1 week ago