please complete this case study asap!! provide excel formulas.

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 longterm 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 4I WARF COMPUTERS BALANCE SHEETS (in thousands) 20212022 20212022 Current assets Cash and equivalents Accounts receivable Inventories Other Total current assets Fixed assets Property, plant, and equipment $4,197$5,476 Less accumulated depreciation 1.4411,777 Stockholders' equity Net property, plant, and equipment $2,756$3.699 Preferred stock Intangible assets and others Total fixed assets Current liabilities Accounts payable Accrued expenses Total current liabilities Long-term liabilities $2.377$2.508 Deferred taxes Long-term debt Total long-term liabilities Common stock $3,962$4,746 Capital surplus Accumulated retained earnings Less treasury stock Total equity $645$685 529329 $1,174$1,014 $210$282 1,5171,557 $1,727$1,839 Total assets $6,069$7,254 Total liabilities and shareholders' equity $6,069$7,254 INCOME STATEMENT (in thousands) Sales $9,975 Cost of goods sold 5,882 Selling, general, and administrative expense 933 Depreciation 336 Operating income $2,824 Other income 98 EBIT $2,922 Interest expense 180 Pretax income $2,742 Taxes 687 Current: $615 Deferred: $72 Net income $2,055 Dividends: $757 Retained earnings: $1,298 Nick also has provided the following information: During the year the company raised $301,000 in new long-term debt and retired $261,000 in long-term debt. The company also sold $22,000 in new stock and repurchased $87,000 in stock. The company purchased $1,955,000 in fixed assets and sold $565.000 in fixed assets. Angus has asked you to prepare the financial statement of cash flows and the accounting statement of cash flows. He also has asked you to answer the following questions: 1. How would you describe Warf Computers's cash flows? 2. Which cash flow statement more accurately describes the cash flows at the company? 3. In light of your previous answers, comment on Nick's expansion plans