A 1 Fashion Trends, Inc. B 2 Balance Sheet, Dec. 31 3 Assets 2019 2018 4...

Transcribed Image Text:

A 1 Fashion Trends, Inc. B 2 Balance Sheet, Dec. 31 3 Assets 2019 2018 4 Cash and Equivalents 862,000 678,000 5 6 Accounts Receivable Inventory 1,006,000 730,000 578,000 600,000 7 Total Current Assets 2,446,000 ? 8 Plant & Equipment 9,338,000 8,644,000 9 Accumulated Depreciation 4,590,000 4,112,000 10 Net Fixed Assets 11 Total Assets 4,748,000 4,532,000 7,194,000 The figure above shows the balance sheet statements for Fashion Trends, Inc. on Dec. 31, 2019 and Dec. 31, 2018. What is the formula on cell C7 that will allow you to calculate the total current assets for 2018? =SUM(C5:C6)-C4 none of the answers is correct. O=C4-C5-C6 =SUM(C4:C10) O=C4+C5+C6 A 1 Fashion Trends, Inc. B 2 Balance Sheet, Dec. 31 3 Assets 2019 2018 4 Cash and Equivalents 862,000 678,000 5 6 Accounts Receivable Inventory 1,006,000 730,000 578,000 600,000 7 Total Current Assets 2,446,000 ? 8 Plant & Equipment 9,338,000 8,644,000 9 Accumulated Depreciation 4,590,000 4,112,000 10 Net Fixed Assets 11 Total Assets 4,748,000 4,532,000 7,194,000 The figure above shows the balance sheet statements for Fashion Trends, Inc. on Dec. 31, 2019 and Dec. 31, 2018. What is the formula on cell C7 that will allow you to calculate the total current assets for 2018? =SUM(C5:C6)-C4 none of the answers is correct. O=C4-C5-C6 =SUM(C4:C10) O=C4+C5+C6