nnovation Electronics, Inc. has provided you with the year-end Income Statement and Balance Sheet. The Controller has asked you to prepare the Statement of Cash Flows for the same year ended December 31. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. - Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal sign first, then click on the other tab and then click on the cell you want to reference. The syntax of a multi-tab cell reference looks different than a normal cell reference, since it includes the tab name surrounded by apostrophes and also an exclamation point before the cell location. In the Excel Simulation below, if "=Income StatementiB15" is entered in a blank cell on the Sheet1 tab, the formula outputs the result from cell 815 in the Income Statement tab, which is 16,000 in this example. - Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), " (asterisk sign to multiply), and / (forward slash to divide). In the Excel Simulation below, if "=B16+B17" is entered in a blank cell on the Balance Sheet tab, the formula adds the values from those cells and outputs the result, which is 411,500 in this example. If using the other math symbols, the result is an appropriate answer for - SUM function: Allows you to refer to multiple cells and adds all the values. You can add irgdividual cell references or ranges to its function. utilize this function. In the Excel Simulation below, if "=SUM(B16,B17,B18)" is entered in a blank cell on the Balance Sheet tab, the formula outputs the result of adding those three separate cells, or 294,000 in this example. Similarly, if " SUM(B16:B18)" is entered in a blank cell, the formula outputs the same result of adding those cells, except they are expressed as a range in the formula, which outputs 294,000 in this example. \begin{tabular}{|c|l|l|l|} \hline 7 & \multicolumn{2}{|c|}{ Statement of Cash Flows } \\ \hline 8 & \multicolumn{2}{|c|}{ For the Year Ended December 31, 20X2 } \\ \hline 10 & Cash Flows from Operating Activities: & & \\ \hline 11 & Aet income & & \\ 12 & provided by operating activities: & & \\ 13 & Depreciation expense & & \\ 14 & Gain (on sale of land) & & \\ \hline 15 & Changes in current assets and current liabilities: & & \\ 16 & Accounts receivable & & \\ 17 & Inventory & & \\ 18 & Prepaid insurance & & \\ 19 & Accounts payable & & \\ \hline 20 & Interest payable & & \\ \hline 21 & Income tax payable & & \\ \hline 22 & Net cash provided by (used in) operating activities & & \\ \hline 23 & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline 24 & Cash Flows from Investing Activities: & & \\ \hline 25 & Purchase investments & & \\ 26 & Sale of land & & \\ \hline 27 & Net cash provided by (used in) investing activities & & \\ 28 & & & \\ 29 & Cash Flows from Financing Activities: & & \\ \hline 30 & Issue common stock & & \\ 31 & Issue long term note & & \\ 32 & Net cash provided by (used in) financing activities & & \\ 33 & Net increase (decrease) in cash & & \\ 34 & Cash at beginning of the period & & \\ \hline 35 & Cash at end of the period & & \\ 36 & & & \\ \hline \end{tabular}