Question

Data Review View Developer Page Layout Formulas 10 VA Hep 1 X Cut Power Pot Tell me what you want to de Arial Copy Paste W ISH Format Painter Clipboard . Font Alignment M27 Simple Balance Sheet Exercise Make the calculations asked for in the green cells Accounts payable Accounts receivable Accumulated depreciation Cash Common stock Inventories Long term debt Other current assets Other current liabilities Other long-term assets Other long-term liabilities Plant and equipment Retained earnings Short-term debt Short-term investments 5,271 3.725 1,485 1,651 2,614 1,926 2.550 057 1.315 Total Current Assets Net Plant and equipment Total Long-term assets Total Assets Total Current Liabilities Total Long-term liabrities Total Liabilities Total Equity Net Working Capital 13.623 2,274 1,073 11,172 Assets Labs. + Equity? L 1,171

Answer 1

Answer:

DE G H Simple Balance Sheet Exercise Make calculations asked for in green cells Accounts payable Accounts receivable Accumulated deprecation Cash Common stock Inventories Long-term debt Other current assets Other current liabilities Other long-term assets Other long-term liabilities Plant and equipment Retained earnings Short-term debt Short-term Investments 5,271 3,725 1,485 1,651 2,614 1,926 2,550 657 1,315 2,274 1,073 11,172 7,994 Total current assets Net Plant and equipment Total long-term assets Total assets Total current liabilities Total long-term liabilities Total liabilities Total equity Net working capital 9,130 9,687 11,961 21,091 6,860 3,623 10,483 10,608 2,270 Assets = Liabs. + Equity 21,091 274 1,171

Above excel with 'show formulas' is as below:

A B DE Simple Balance Sheet Exercise Make calculations asked for in green cells Accounts payable Accounts receivable Accumulated deprecation Cash Common stock Inventories Long-term debt Other current assets Other current liabilities Other long-term assets Other long-term liabilities Plant and equipment Retained earnings Short-term debt Short-term Investments 5271 3725 1485 1651 2614 1926 2550 657 1315 2274 1073 11172 7994 274 1171 Total current assets 9130 Net Plant and equipment =D16-D7 Total long-term assets -G6+D14 Total assets =G5+G7 Total current liabilities =D5+D13+D18 Total long-term liabilities =D11+D15 Total liabilities =G9+G10 Total equity =D9+D17 Net working capital =G5-G9 Assets = Liabs. + Equity G11+G12