Use Excel to solve this problem. No typing and handwritten answer for cash flows (Question 1 and 2). You can type the answer for questions 3, 4, and 5. Please, show all the calculations, and formulas in the excel sheet. Make sure the answers are correct, well written, and easy to understand. Thanks in advance.

Nick has also provided the following information: During the year the company raised $274,000 in new long-term debt and retired $238,000 in long-term debt. The company also sold $19,000 in new stock and repurchased $79,000 in stock. The company purchased $1,778,000 in fixed assets and sold $514,000 in fixed assets.

Angus has asked you to prepare the financial statement of cash flows and the accounting statement of cash flows. He has also asked you to answer the following questions:

1). Prepare the 2019 financial statement of cash flows.

2). Prepare the 2019 accounting statement of cash flows.

3). How would you describe Warf Computers' cash flows?

4). Which cash flow statement more accurately describes the cash flows at the company?

5). In light of your previous answers, comment on Nick's expansion plans.

Mini Case Cash Flows at Warf Computers, Inc. Warf Computers, Inc., was founded 15 years ago by Nick Warf, a computer programmer. The small initial investment to start the company was made by Nick and his friends. Over the years, this same group has supplied the limited additional investment needed by the company in the form of both equity and short and long-term debt. Recently the company has developed a virtual keyboard (VK). The VK uses sophisticated artificial intelligence algorithms that allow the user to speak naturally and have the computer input the text, correct spelling and grammatical errors, and format the document according to preset user guidelines. The VK even suggests alternative phrasing and sentence structure, and it provides detailed stylistic diagnostics. Based on a proprietary, very advanced software/hardware hybrid technology, the system is a full generation beyond what is currently on the market. To introduce the VK the company will require significant outside investment Nick has made the decision to seek this outside financing in the form of new equity investments and bank loans. Naturally, new investors and the banks will require a detailed financial analysis. Your employer, Angus Jones & Partners, LLC, has asked you to examine the financial statements provided by Nick. Here are the balance sheets for the two most recent years and the most recent income statement: Page 41 2018 2019 $ 582 $ 623 481 296 $1,063 $ 919 110 WARF COMPUTERS BALANCE SHEETS ($ IN THOUSANDS) 2018 2019 Current assets Current liabilities Cash and equivalents $ 469 $ 542 Accounts payable Accounts receivable 802 859 Accrued expenses Inventories 795 769 Total current liabilities Other 94 Long-term liabilities Total current assets $2,160 $2,280 Deferred taxes Fixed assets Long-term debt Property, plant, and equipment $3,815 $4,978 Total long-term liabilities Less accumulated depreciation 1,310 1,608 Stockholders' equity Net property, plant, and equipment $2,505 $3,370 Preferred stock Intangible assets and others 851 953 Common stock Total fixed assets $3,356 $4,322 Capital surplus Accumulated retained earnings Less treasury stock $ 191 $ 257 1,379 1,415 $1,570 $1,672 S 25 $ 25 151 155 934 949 1,924 3,112 151 230 Total equity $2,883 $4,011 Total assets $5,516 $6,602 Total liabilities and shareholders' equity $5,516 $6,602 WARF COMPUTERS INCOME STATEMENT ($ IN THOUSANDS) Sales $9,068 Cost of goods sold 5,347 Selling, general, and administrative expense 848 Depreciation 298 Operating income $2,575 Other income 90 EBIT $2,665 Interest expense 164 Pretax income $2,501 Taxes 625 Current: $559 Deferred: $66 Net income $1,876 Dividends $ 688 Retained earnings $1,188 Mini Case Cash Flows at Warf Computers, Inc. Warf Computers, Inc., was founded 15 years ago by Nick Warf, a computer programmer. The small initial investment to start the company was made by Nick and his friends. Over the years, this same group has supplied the limited additional investment needed by the company in the form of both equity and short and long-term debt. Recently the company has developed a virtual keyboard (VK). The VK uses sophisticated artificial intelligence algorithms that allow the user to speak naturally and have the computer input the text, correct spelling and grammatical errors, and format the document according to preset user guidelines. The VK even suggests alternative phrasing and sentence structure, and it provides detailed stylistic diagnostics. Based on a proprietary, very advanced software/hardware hybrid technology, the system is a full generation beyond what is currently on the market. To introduce the VK the company will require significant outside investment Nick has made the decision to seek this outside financing in the form of new equity investments and bank loans. Naturally, new investors and the banks will require a detailed financial analysis. Your employer, Angus Jones & Partners, LLC, has asked you to examine the financial statements provided by Nick. Here are the balance sheets for the two most recent years and the most recent income statement: Page 41 2018 2019 $ 582 $ 623 481 296 $1,063 $ 919 110 WARF COMPUTERS BALANCE SHEETS ($ IN THOUSANDS) 2018 2019 Current assets Current liabilities Cash and equivalents $ 469 $ 542 Accounts payable Accounts receivable 802 859 Accrued expenses Inventories 795 769 Total current liabilities Other 94 Long-term liabilities Total current assets $2,160 $2,280 Deferred taxes Fixed assets Long-term debt Property, plant, and equipment $3,815 $4,978 Total long-term liabilities Less accumulated depreciation 1,310 1,608 Stockholders' equity Net property, plant, and equipment $2,505 $3,370 Preferred stock Intangible assets and others 851 953 Common stock Total fixed assets $3,356 $4,322 Capital surplus Accumulated retained earnings Less treasury stock $ 191 $ 257 1,379 1,415 $1,570 $1,672 S 25 $ 25 151 155 934 949 1,924 3,112 151 230 Total equity $2,883 $4,011 Total assets $5,516 $6,602 Total liabilities and shareholders' equity $5,516 $6,602 WARF COMPUTERS INCOME STATEMENT ($ IN THOUSANDS) Sales $9,068 Cost of goods sold 5,347 Selling, general, and administrative expense 848 Depreciation 298 Operating income $2,575 Other income 90 EBIT $2,665 Interest expense 164 Pretax income $2,501 Taxes 625 Current: $559 Deferred: $66 Net income $1,876 Dividends $ 688 Retained earnings $1,188