Warf Computers, Inc., was founded 15 years ago by Nick Warf, a computer programm
ID: 2808008 • Letter: W
Question
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 aproprietary, 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:
Balance Sheets for 2014 and 2015
Nick has also providedthe following information: During the year the company raised $228,000 in new long-term debt and retired $197,000 in long-term debt. The company also sold $15,000 in new stock and repurchased $66,000 in stock. The company purchased $1,482,000 in fixed assets and sold $429,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.Is the company able to distribute part of the cash flow to creditors?To this aim, calculate the cash flow to bondholders and stockholders.In addition to that, check whether the firm is experiencing a positive or negative change in cash (accounting cash flow).
2.Do you thinkthe accounting statement of cash flowsaccurately describes the cash flows ofthe company?
3.In light of your previous answers, comment on Nick’s expansion plans.
4.For part (4), consider the Balance Sheet of Warf Computers in 2015. Let us suppose that sales are expected to increase by 10%.
What will be the External Financing Neededto support this increase in sales? Construct the Pro-Forma Income Statement and the Pro-Forma Balance Sheet.Comment your result.
To answer part (4), assume that costs vary directly with sales, but depreciationand interest expense arenot affected by any change in the sales’ level. It takes time for the initial investment to depreciate, so, to simplify the analysis, we are going to assume that depreciation isunaffected by changes in sales.Similarly, as we will see when studying bonds, the payment to bondholders is fixed in any period.Further, assume that all assets (i.e., current and fixed) vary directly with sales. Regarding the current liabilities, only accounts payable respond to a change in sales. Accruedexpenses are periodic expenses that have been incurred but will be paid at some future date and for which there is no actual documentation(i.e., no invoice available, for instance). Given the limited growth rate of sales, we will be assuming that accruedexpenses do not change.Finally, use the same assumptions used in class regarding long-term debt and equity. More in detail, assume that long-term liabilities do not change with a change in sales as they strongly depend upon managerial decisions that taketime to be approved and thus be effective. The change in equity will be driven by the change in accumulated retained earnings.
WARF COMPUTERS Balance Sheet ($ in thousands) 2015 2014 2015 2014 Current assets Current liabilities Cash and equivalents Accounts receivable Inventories Other $ 452 $ 391 668 663 78 Accounts payable Accrued expenses $ 519 247 485 716 641 92 401 $ 766 $ 886 $ 330 159 Total current liabilities Total current assets $1.901 $1.800 Long-term liabilities Deferred taxes Long-term debt Fixed assets 1.179 1.148 Property, plant, and $4,148 %3.179 equipment Less accumulated Total long-term liabilities $1,509 $1.307 depreciation 1,340 1,092 Stockholders' equity $ 21 $2 Preferred stock Common stock Capital surplus Accumulated retained Net property, plant, and $2,808 $2,087 709 $3.601 $%2.796 126 794 2.478 126 779 1.603 equipment 793 Intangible assets and others Total fixed assets earnings Less treasury stock 192 126 $3.227 $%2.403 Total equity Total liabilities and shareholders equity $5,502 $4,596 Total assets $5,502 $4,596Explanation / Answer
Operating activities Net Income as per Income statement 1167 Add Back: Depreciation 248 Add Back: Deferred tax liability(330-159) 171 Adjusted net income 1586 Changes to working capital: Less: Increase in Accounts receivables(716-668) -48 Add:Decrease in Inventories(663-641) 22 Less: Increase in other assets(92-78) -14 Add: Increase in current liabilities(519-485) 34 Less:Decrease in Accrued expenses(401-247) -154 Net changes to working capital -160 Cash generated from operating activities 1426 Investing activities Purchase of fixed assets -1482 Sale of assets 429 Cash used in Investing activities -1053 Financing activities Sale proceeds of new stock 15 Stock Repurchase -66 Proceeds of new debt 228 Retirement of debt -197 Less: Dividends paid -292 Cash used in Financing activities -312 Net cash generated 61 Add: Beginning cash balance 391 Ending cash balance 452 1… Cash flow to creditors Interest paid-Ending Long-Term debt-Beginning LT debt ie. 137-1179+1148= 106 Cash Flow to Common Stockholders = Dividends Paid- (Ending Common Stock - Beginning Common Stock)- (Ending Capital Surplus - Beginning Capital Surplus)+ (Ending Treasury Stock - Beginning Treasure Stock) ie. 292-(126-126)-(794-779)+(192-126)= 343 Net cash generated during the Year = 61 This is a POSITIVE change in cash. 2.. YES CFS identifies all cash flowing in & out of the business. Moreover, the 3 segregations, operating ,investing & financing are very useful & informative. 3. The positive cash generated is mainly due to the non-cash items of expenditure ,ie.depreciation & deferrment of tax liabilities ,in the operating section of the cash flow statement, followed by sale of fixed assets & proceeds of new bebt. So, funding the expansion through better operations must be aimed , so as to impress the new investors & banks 4.. WARF COMPUTERS Proforma Income Statement ($ in '000s) Sales (7557*1.1) 8313 COGS (4456*1.1) 4902 S&G&A exp.(848*1.1) 933 Depn. 248 Operating Income 2230 Other Income(75*1.1) 83 EBIT 2313 Interest expense 137 Pretax Income 2176 Taxes(776/1943*2176) 869 Net Income 1307 Dividends(292/1167*1307) 327 Retained Earnings 980 External Financing Needed to support this increase in sales----- Increase in assets-Spontaneous increase in liabilities-Spontaneous additions to retained earnings 2015 Current assets +Gross fixed assets 1901+4148+793= 6842 Increase in assets=6842*10% 684.2 Increase in Current liabilities 519*10%= 51.9 Additions to Retained Earnings 980 SO, EFN=684.2-51.9-980= -347.7 As the above arrived at is -ve, no external financing is needed at this rate of increase in sales.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.