Fill out the excel spreadsheet (green/blue shaded cells) with the correct data based on the balance sheet from BBWI provided (ignore the one is already in)

\begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{l} BALANCE SHEET DATA \\ Assets: \\ \end{tabular}}} \\ \hline & & & & & & \\ \hline \multicolumn{7}{|c|}{\begin{tabular}{|c|c|c|c|c|c|} 1,934,000.0 & 1,515,000.0 & 1,413,000.0 & 1,499,000.0 & 3,903,000.0 & 1,979,000.0 \\ \end{tabular}} \\ \hline \multicolumn{7}{|l|}{ Short-term investments } \\ \hline Accounts and notes receivable - net & 294,000.0 & 310,000.0 & 367,000.0 & 306,000.0 & 269,000.0 & 240,000.0 \\ \hline Inventories & 1,096,000.0 & 1,240,000.0 & 1,248,000.0 & 1,287,000.0 & 1,273,000.0 & 709,000.0 \\ \hline Prepaid expenses and other current assets & 3,465,000.0 & 3,293,000.0 & 3,260,000.0 & 3,245,000.0 & 5,579,000.0 & 3,009,000.0 \\ \hline Other current assets (1) & 141,000 & 228,000 & 232,000 & 153,000 & 134,000 & 81,000 \\ \hline \multicolumn{7}{|l|}{ Other current assets (2) } \\ \hline \multicolumn{7}{|l|}{ Other current assets (3) } \\ \hline Current Assets & 6,930,000 & 6,586,000 & 6,520,000 & 6,490,000 & 11,158,000 & 6,018,000 \\ \hline \multicolumn{7}{|l|}{ Long-term investments } \\ \hline \multicolumn{7}{|l|}{ Equity and cost investments } \\ \hline \multicolumn{7}{|l|}{ Property, plant, and equipment - at cost } \\ \hline \multicolumn{7}{|l|}{ } \\ \hline Deferred income taxes - noncurrent & 19,000.0 & 14,000.0 & 62,000.0 & 84,000.0 & 69,000.0 & 45,000.0 \\ \hline Other assets & 186,000.0 & 190,000.0 & 191,000.0 & 218,000.0 & 231,000.0 & 149,000.0 \\ \hline \multicolumn{7}{|l|}{ Other intangible assets } \\ \hline Goodwill & 1,348,000 & 1,348,000 & 1,348,000 & 628,000 & 628,000 & 628,000 \\ \hline Total Assets & 8,483,000 & 8,138,000 & 8,121,000 & 7,420,000 & 12,086,000 & 6,840,000 \\ \hline \multicolumn{7}{|l|}{ Liabilities and Equities: } \\ \hline Accounts payable & 683,000 & 717,000 & 711,000 & 647,000 & 683,000 & 435,000 \\ \hline \multicolumn{7}{|l|}{ Accrued liabilities } \\ \hline \multicolumn{7}{|l|}{ Notes payable and short-term debt } \\ \hline \multicolumn{7}{|l|}{ Current maturities of long-term debt } \\ \hline \multicolumn{7}{|l|}{ Deferred tax liabilities - current } \\ \hline \multicolumn{7}{|l|}{ Other current liabilities (1) } \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{|l|} Other current liabilities (2) \\ Other current liabilities (3) \end{tabular}}} \\ \hline & & & & & & \\ \hline \multicolumn{7}{|l|}{ Current Liabilities } \\ \hline \multicolumn{7}{|l|}{ Long-term debt } \\ \hline \multicolumn{7}{|l|}{ Long-term accrued liabilities } \\ \hline \multicolumn{7}{|l|}{ Deferred tax liabilities- noncurrent } \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{l} Other noncurrent liabilities (1) \\ Other noncurrent liabilities (2) \end{tabular}}} \\ \hline & & & & & \multicolumn{2}{|c|}{ Other noncurrent liabilities (2) } \\ \hline Total Liabilities & 683,000 & 717,000 & 711,000 & 647,000 & 683,000 & 435,000 \\ \hline Preferred stock & & & & & & \\ \hline Common stock + Additional paid in capital & 1,027,000 & 1,034,000 & 989,000 & 912,000 & 819,000 & 807,000 \\ \hline Retained earnings > & 205,000 & 1,434,000 & 1,482,000 & 2,182,000 & 1,421,000 & 1,803,000 \\ \hline Accum. other comprehensive income & 12,000 & 24,000 & 59,000 & 52,000 & 83,000 & 80,000 \\ \hline and other equity adjustments & 1,753,000 & 162,000 & 358,000.0 & 358,000 & 358,000 & 822,000 \\ \hline Total Common Shareholders' Equity & 2,997,000 & 214,000 & 76,000 & 860,000 & 161,000 & 94,000 \\ \hline Noncontrolling interests & 2,000 & 2,000 & 4,000 & 4,000 & 1,000 & 1,000 \\ \hline Total Equity & 2,999,000 & 212,000 & 72,000 & 856,000 & 160,000 & 93,000 \\ \hline Total Liabilities and Equities & 3,682,000 & 505,000 & 639,000 & 209,000 & 523,000 & 342,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{l} BALANCE SHEET DATA \\ Assets: \\ \end{tabular}}} \\ \hline & & & & & & \\ \hline \multicolumn{7}{|c|}{\begin{tabular}{|c|c|c|c|c|c|} 1,934,000.0 & 1,515,000.0 & 1,413,000.0 & 1,499,000.0 & 3,903,000.0 & 1,979,000.0 \\ \end{tabular}} \\ \hline \multicolumn{7}{|l|}{ Short-term investments } \\ \hline Accounts and notes receivable - net & 294,000.0 & 310,000.0 & 367,000.0 & 306,000.0 & 269,000.0 & 240,000.0 \\ \hline Inventories & 1,096,000.0 & 1,240,000.0 & 1,248,000.0 & 1,287,000.0 & 1,273,000.0 & 709,000.0 \\ \hline Prepaid expenses and other current assets & 3,465,000.0 & 3,293,000.0 & 3,260,000.0 & 3,245,000.0 & 5,579,000.0 & 3,009,000.0 \\ \hline Other current assets (1) & 141,000 & 228,000 & 232,000 & 153,000 & 134,000 & 81,000 \\ \hline \multicolumn{7}{|l|}{ Other current assets (2) } \\ \hline \multicolumn{7}{|l|}{ Other current assets (3) } \\ \hline Current Assets & 6,930,000 & 6,586,000 & 6,520,000 & 6,490,000 & 11,158,000 & 6,018,000 \\ \hline \multicolumn{7}{|l|}{ Long-term investments } \\ \hline \multicolumn{7}{|l|}{ Equity and cost investments } \\ \hline \multicolumn{7}{|l|}{ Property, plant, and equipment - at cost } \\ \hline \multicolumn{7}{|l|}{ } \\ \hline Deferred income taxes - noncurrent & 19,000.0 & 14,000.0 & 62,000.0 & 84,000.0 & 69,000.0 & 45,000.0 \\ \hline Other assets & 186,000.0 & 190,000.0 & 191,000.0 & 218,000.0 & 231,000.0 & 149,000.0 \\ \hline \multicolumn{7}{|l|}{ Other intangible assets } \\ \hline Goodwill & 1,348,000 & 1,348,000 & 1,348,000 & 628,000 & 628,000 & 628,000 \\ \hline Total Assets & 8,483,000 & 8,138,000 & 8,121,000 & 7,420,000 & 12,086,000 & 6,840,000 \\ \hline \multicolumn{7}{|l|}{ Liabilities and Equities: } \\ \hline Accounts payable & 683,000 & 717,000 & 711,000 & 647,000 & 683,000 & 435,000 \\ \hline \multicolumn{7}{|l|}{ Accrued liabilities } \\ \hline \multicolumn{7}{|l|}{ Notes payable and short-term debt } \\ \hline \multicolumn{7}{|l|}{ Current maturities of long-term debt } \\ \hline \multicolumn{7}{|l|}{ Deferred tax liabilities - current } \\ \hline \multicolumn{7}{|l|}{ Other current liabilities (1) } \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{|l|} Other current liabilities (2) \\ Other current liabilities (3) \end{tabular}}} \\ \hline & & & & & & \\ \hline \multicolumn{7}{|l|}{ Current Liabilities } \\ \hline \multicolumn{7}{|l|}{ Long-term debt } \\ \hline \multicolumn{7}{|l|}{ Long-term accrued liabilities } \\ \hline \multicolumn{7}{|l|}{ Deferred tax liabilities- noncurrent } \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{l} Other noncurrent liabilities (1) \\ Other noncurrent liabilities (2) \end{tabular}}} \\ \hline & & & & & \multicolumn{2}{|c|}{ Other noncurrent liabilities (2) } \\ \hline Total Liabilities & 683,000 & 717,000 & 711,000 & 647,000 & 683,000 & 435,000 \\ \hline Preferred stock & & & & & & \\ \hline Common stock + Additional paid in capital & 1,027,000 & 1,034,000 & 989,000 & 912,000 & 819,000 & 807,000 \\ \hline Retained earnings > & 205,000 & 1,434,000 & 1,482,000 & 2,182,000 & 1,421,000 & 1,803,000 \\ \hline Accum. other comprehensive income & 12,000 & 24,000 & 59,000 & 52,000 & 83,000 & 80,000 \\ \hline and other equity adjustments & 1,753,000 & 162,000 & 358,000.0 & 358,000 & 358,000 & 822,000 \\ \hline Total Common Shareholders' Equity & 2,997,000 & 214,000 & 76,000 & 860,000 & 161,000 & 94,000 \\ \hline Noncontrolling interests & 2,000 & 2,000 & 4,000 & 4,000 & 1,000 & 1,000 \\ \hline Total Equity & 2,999,000 & 212,000 & 72,000 & 856,000 & 160,000 & 93,000 \\ \hline Total Liabilities and Equities & 3,682,000 & 505,000 & 639,000 & 209,000 & 523,000 & 342,000 \\ \hline \end{tabular}