I need assistance answering the mini case questions 1-3. In addition, I need to include the financial statement of cash flows and the accounting statement of cash flows.

tax rate, and the tax bill for any level of taxab b. For a taxable income of $265,000, what is the marginal tax rate? c. For a taxable income of $265,000, what is the total tax bill? d. For a taxable income of $265,000, what is the average tax rate? 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 cur- rently 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: Financial Statements WARF COMPUTERS Balance Sheets ($ in thousands) 2019 2018 2019 $ 582 481 $ 623 296 $ 542 859 769 110 $2,280 $ 1,063 $ 919 2018 Current assets Cash and equivalents $ 469 Accounts receivable 802 Inventories 795 Other 94 Total current assets $ 2,160 Fixed assets Property, plant, and equipment $ 3,815 Less accumulated depreciation 1,310 Net property, plant, and equipment $2,505 Intangible assets and others 851 Total fixed assets $3,356 $ 191 1,379 $ 257 1,415 $4.978 Current liabilities Accounts payable Accrued expenses Total current liabilities Long-term liabilities Deferred taxes Long-term debt Total long-term liabilities Stockholders' equity Preferred stock Common stock Capital surplus Accumulated retained earnings Less treasury stock Total equity $ 1,570 $ 1,672 1,608 $ $ $3,370 25 151 934 1,924 25 155 949 3,112 953 $4,322 151 $2,883 230 $ 4,011 Total liabilities and shareholders' equity $ 5,516 $6,602 $5,516 Total assets $6,602 WARF COMPUTERS Income Statement ($ in thousands) Sales Cost of goods sold Selling, general, and administrative expense Depreciation Operating income Other income EBIT Interest expense Pretax income Taxes Current: $559 Deferred: $66 Net income Dividends Retained earnings $9,068 5,347 848 298 $2,575 90 $2,665 164 $ 2,501 625 $ 1,876 $ 688 $ 1,188 muided the following information: During the year the company raised $274,000 $ 2,501 625 Pretax income Taxes Current: $559 Deferred: $66 Net income Dividends Retained earnings $ 1,876 $ 688 $ 1,188 Nick also has 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 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 rately describes the cash flows at the company? 3. In light of your previous answers, comment on Nick's expansion plans. a. Create a tax shown above. Your spreadsheet should then tax rate, and the tax bill for any level of taxable income input by a user. b. For a taxable income of $265.000, what is the marginal tax rate? c. For a taxable income of $265,000, what is the total tax bill? d. For a taxable income of $265.000, what is the average tax rate? 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 cur- rently 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: CHAPTER 2 Financial Statements and Cash Flow 41 WARF COMPUTERS Balance Sheets ($ in thousands) 2019 2018 2019 $ 582 481 $ 623 296 $ 542 859 769 110 $2,280 $ 1,063 $ 919 $ 2018 Current assets Cash and equivalents $ 469 Accounts receivable 802 Inventories 795 Other 94 Total current assets $2,160 Fixed assets Property, plant, and equipment $ 3.815 Less accumulated depreciation 1,310 Net property, plant, and equipment $2,505 Intangible assets and others 851 Total fixed assets $3,356 191 1,379 $ 257 1,415 $4,978 $ 1,570 $ 1,672 1,608 Current liabilities Accounts payable Accrued expenses Total current liabilities Long-term liabilities Deferred taxes Long-term debt Total long-term liabilities Stockholders' equity Preferred stock Common stock Capital surplus Accumulated retained earnings Less treasury stock Total equity Total liabilities and shareholders' equity $ 25 $ $3,370 151 25 155 949 3,112 953 $4,322 934 1,924 151 $2,883 230 $ 4,011 Total assets $ 5,516 $6,602 $5,516 $6.602 WARF COMPUTERS Income Statement ($ in thousands) Sales Cost of goods sold Selling, general, and administrative expense Depreciation Operating income Other income EBIT Interest expense Pretax income Taxes Current: $559 Deferred: $66 Net income Dividends Retained earnings $9,068 5,347 848 298 $2,575 90 $2,665 164 $ 2,501 625 $ 1,876 $ 688 $ 1,188 Wick also has provided the following information: During the year the company raised $274,00 new long-term debt and retired $238,000 in long-term debt. The company also sold $19,00 new stock and repurchased $79,000 in stock. The company purchased $1,778,000 in fixe ssets and sold $514,000 in fixed assets. Deferred: $66 Net income Dividends Retained earnings $ 1,876 $ 688 $ 1,188 Nick also has 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 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