d. Analyze the firm's financial condition in 2015 as it relates to (1) liquidity, (2) activity,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
d. Analyze the firm's financial condition in 2015 as it relates to (1) liquidity, (2) activity, (3) debt, (4) profitability, and (5) market, using the financial statements provided in Tables 2 and 3 and the ratio data included in Table 5. Be sure to evaluate the firm on both a cross- sectional and a time-series basis. e. What recommendation would you make to Stanley regarding hiring a new software de- veloper? Relate your recommendation here to your responses in part a. f. Track Software paid $5,000 in dividends in 2015. Suppose that an investor approached Stanley about buying 100% of his firm. If this investor believed that by owning the compa- ny he could extract $5,000 per year in cash from the company in perpetuity, what do you think the investor would be willing to pay for the firm if the required return on this invest- ment is 10%? g. Suppose that you believed that the FCF gen- erated by Track Software in 2015 could con- tinue forever. You are willing to buy the com- pany in order to receive this perpetual stream of free cash flow. What are you willing to pay if you require a 10% return on your investment? - Swipe to turn pages Integrative Case 2 Track Software, Inc. Seven years ago, after 15 years in public account- ing, Stanley Booker, CPA, resigned his position as manager of cost systems for Davis, Cohen, and O'Brien Public Accountants and started Track Soft- ware, Inc. In the 2 years preceding his departure from Davis, Cohen, and O'Brien, Stanley had spent nights and weekends developing a sophisticated cost-accounting software program that became Track's initial product offering. As the firm grew, Stanley planned to develop and expand the soft- ware product offerings, all of which would be related to streamlining the accounting processes of medi- um- to large-sized manufacturers. Although Track experienced losses during its first 2 years of operation-2009 and 2010-its profit has increased steadily from 2011 to the present (2015). The firm's profit history, including dividend pay- ments and contributions to retained earnings, is summarized in Table 1. Stanley started the firm with a $100,000 investment: his savings of $50,000 as equity and a $50,000 long-term loan from the bank. He had hoped to maintain his initial 100 percent ownership in the cor- poration, but after experiencing a $50,000 loss dur- ing the first year of operation (2009), he sold 60 per- cent of the stock to a group of investors to obtain needed funds. Since then, no other stock transac- tions have taken place. Although he owns only 40 percent of the firm, Stanley actively manages all as- pects of its activities; the other stockholders are not pects of its activities; the other stockholders are not active in management of the firm. The firm's stock was valued at $4.50 per share in 2014 and at $5.28 per share in 2015. Table 1 Track Software, Inc., Profit, Dividends, and Retained Earnings, 2009-2015 Year Net prof- Divi- its after taxes (1) paid (2) Contribution to re- dends tained earnings [(1) |- (2)1 (3) 2009 ($50,000) $ 0 ($50,000) 2010 (20,000) (20,000) 2011 15,000 15,000 2012 35,000 35,000 2013 40,000 1,000 39,000 2014 43,000 3,000 40,000 2015 48,000 5,000 43,000 Stanley has just prepared the firm's 2015 income statement, balance sheet, and statement of retained earnings, shown in Tables 2, 3, and 4, along with the 2014 balance sheet. In addition, he has compiled the 2014 ratio values and industry average ratio val- ues for 2015, which are applicable to both 2014 and 2015 and are summarized in Table 5. He is quite pleased to have achieved record earnings of $48,000 in 2015, but he is concerned about the firm's cash flows. Specifically, he is finding it more and more difficult to pay the firm's bills in a timely and more difficult to pay the firm's bills in a timely manner and generate cash flows to investors, both creditors and owners. To gain insight into these cash flow problems, Stanley is planning to deter- mine the firm's 2015 operating cash flow (OCF) and free cash flow (FCF). Stanley is further frustrated by the firm's inability to afford to hire a software developer to complete de- velopment of a cost estimation package that is be- lieved to have "blockbuster" sales potential. Stanley began development of this package 2 years ago, but the firm's growing complexity has forced him to devote more of his time to administrative duties, thereby halting the development of this product. Stanley's reluctance to fill this position stems from his concern that the added $80,000 per year in salary and benefits for the position would certainly lower the firm's earnings per share (EPS) over the next couple of years. Although the project's success is in no way guaranteed, Stanley believes that if the money were spent to hire the software developer, the firm's sales and earnings would significantly rise once the 2- to 3-year development, production, and marketing process was completed. With all these concerns in mind, Stanley set out to review the various data to develop strategies that would help ensure a bright future for Track Soft- ware. Stanley believed that as part of this process, a thorough ratio analysis of the firm's 2015 results would provide important additional insights. Table 2 Track Software, Inc., Income Statement ($000) for the Year Ended December 31, 2015 Sales revenue $ 1,550 Less: Cost of goods sold $ 1,030 Gross profits $520 Less: Operating expenses Selling expense $ 150 General and administrative expenses 270 Depreciation expense 11 Total operating expense 431 Operating profits (EBIT) $ 89 Less: Interest expense 29 Net profits before taxes $ 60 Less: Taxes (20%) 12 Net profits after taxes $ 48 Table 3 Track Software, Inc., Balance Sheet (S000) Decem- ber 31 Assets 2015 2014 Cash $ 12 $ 31 Marketable securities 66 82 Accounts receivable 152 104 Inventories 191 145 Total current assets $421 $362 Gross fixed assets $195 $180 Less: Accumulated depreciation 63 52 Net fixed assets $132 $128 Total assets $553 $490 Liabilities and stockholders' equity Accounts payable $136 $126 Notes payable 200 190 Accruals 27 25 Total current liabilities $363 $341 Long-term debt $ 38 $ 40 Total liabilities $401 $381 Common stock (50,000 shares out- $ 20 $ 20 Liabilities and stockholders' equity Accounts payable $136 $126 Notes payable 200 190 Accruals 27 25 Total current liabilities $363 $341 Long-term debt $ 38 $ 40 Total liabilities $401 $381 Common stock (50,000 shares out- $ 20 $ 20 standing at $0.40 par value) Paid-in capital in excess of par 30 30 Retained earnings 102 59 Total stockholders' equity $152 $109 Total liabilities and stockholders' eq- $553 $490 uity Table 4 Track Software, Inc., Statement of Re- tained Earnings ($000) for the Year Ended De- cember 31, 2015 Retained earnings balance (January 1, $ 59 2015) Plus: Net profits after taxes (for 2015) 48 Less: Cash dividends on common stock (paid during 2015) Retained earnings balance (December 31, $102 2015) LO Table 5 Actual Industry aver- 2014 Ratio age 2015 Current ratio 1.06 1.82 Quick ratio 0.63 1.10 Inventory turnover 10.40 12.45 Average collection pe- 29.6 riod 20.2 days days Total asset turnover 2.66 3.92 Debt ratio 0.78 0.55 Times interest earned 3.0 ratio 5.6 Gross profit margin 32.1% 42.3% Operating profit mar- 5.5% gin 12.4% Net profit margin 3.0% 4.0% Return on total assets 8.0% 15.6% (ROA) Return on common equity (ROE) 36.4% 34.7% Price/earnings (P/E) ratio 5.2 7.1 Market/book (M/B) ra- 2.1 2.2 tio d. Analyze the firm's financial condition in 2015 as it relates to (1) liquidity, (2) activity, (3) debt, (4) profitability, and (5) market, using the financial statements provided in Tables 2 and 3 and the ratio data included in Table 5. Be sure to evaluate the firm on both a cross- sectional and a time-series basis. e. What recommendation would you make to Stanley regarding hiring a new software de- veloper? Relate your recommendation here to your responses in part a. f. Track Software paid $5,000 in dividends in 2015. Suppose that an investor approached Stanley about buying 100% of his firm. If this investor believed that by owning the compa- ny he could extract $5,000 per year in cash from the company in perpetuity, what do you think the investor would be willing to pay for the firm if the required return on this invest- ment is 10%? g. Suppose that you believed that the FCF gen- erated by Track Software in 2015 could con- tinue forever. You are willing to buy the com- pany in order to receive this perpetual stream of free cash flow. What are you willing to pay if you require a 10% return on your investment? - Swipe to turn pages Integrative Case 2 Track Software, Inc. Seven years ago, after 15 years in public account- ing, Stanley Booker, CPA, resigned his position as manager of cost systems for Davis, Cohen, and O'Brien Public Accountants and started Track Soft- ware, Inc. In the 2 years preceding his departure from Davis, Cohen, and O'Brien, Stanley had spent nights and weekends developing a sophisticated cost-accounting software program that became Track's initial product offering. As the firm grew, Stanley planned to develop and expand the soft- ware product offerings, all of which would be related to streamlining the accounting processes of medi- um- to large-sized manufacturers. Although Track experienced losses during its first 2 years of operation-2009 and 2010-its profit has increased steadily from 2011 to the present (2015). The firm's profit history, including dividend pay- ments and contributions to retained earnings, is summarized in Table 1. Stanley started the firm with a $100,000 investment: his savings of $50,000 as equity and a $50,000 long-term loan from the bank. He had hoped to maintain his initial 100 percent ownership in the cor- poration, but after experiencing a $50,000 loss dur- ing the first year of operation (2009), he sold 60 per- cent of the stock to a group of investors to obtain needed funds. Since then, no other stock transac- tions have taken place. Although he owns only 40 percent of the firm, Stanley actively manages all as- pects of its activities; the other stockholders are not pects of its activities; the other stockholders are not active in management of the firm. The firm's stock was valued at $4.50 per share in 2014 and at $5.28 per share in 2015. Table 1 Track Software, Inc., Profit, Dividends, and Retained Earnings, 2009-2015 Year Net prof- Divi- its after taxes (1) paid (2) Contribution to re- dends tained earnings [(1) |- (2)1 (3) 2009 ($50,000) $ 0 ($50,000) 2010 (20,000) (20,000) 2011 15,000 15,000 2012 35,000 35,000 2013 40,000 1,000 39,000 2014 43,000 3,000 40,000 2015 48,000 5,000 43,000 Stanley has just prepared the firm's 2015 income statement, balance sheet, and statement of retained earnings, shown in Tables 2, 3, and 4, along with the 2014 balance sheet. In addition, he has compiled the 2014 ratio values and industry average ratio val- ues for 2015, which are applicable to both 2014 and 2015 and are summarized in Table 5. He is quite pleased to have achieved record earnings of $48,000 in 2015, but he is concerned about the firm's cash flows. Specifically, he is finding it more and more difficult to pay the firm's bills in a timely and more difficult to pay the firm's bills in a timely manner and generate cash flows to investors, both creditors and owners. To gain insight into these cash flow problems, Stanley is planning to deter- mine the firm's 2015 operating cash flow (OCF) and free cash flow (FCF). Stanley is further frustrated by the firm's inability to afford to hire a software developer to complete de- velopment of a cost estimation package that is be- lieved to have "blockbuster" sales potential. Stanley began development of this package 2 years ago, but the firm's growing complexity has forced him to devote more of his time to administrative duties, thereby halting the development of this product. Stanley's reluctance to fill this position stems from his concern that the added $80,000 per year in salary and benefits for the position would certainly lower the firm's earnings per share (EPS) over the next couple of years. Although the project's success is in no way guaranteed, Stanley believes that if the money were spent to hire the software developer, the firm's sales and earnings would significantly rise once the 2- to 3-year development, production, and marketing process was completed. With all these concerns in mind, Stanley set out to review the various data to develop strategies that would help ensure a bright future for Track Soft- ware. Stanley believed that as part of this process, a thorough ratio analysis of the firm's 2015 results would provide important additional insights. Table 2 Track Software, Inc., Income Statement ($000) for the Year Ended December 31, 2015 Sales revenue $ 1,550 Less: Cost of goods sold $ 1,030 Gross profits $520 Less: Operating expenses Selling expense $ 150 General and administrative expenses 270 Depreciation expense 11 Total operating expense 431 Operating profits (EBIT) $ 89 Less: Interest expense 29 Net profits before taxes $ 60 Less: Taxes (20%) 12 Net profits after taxes $ 48 Table 3 Track Software, Inc., Balance Sheet (S000) Decem- ber 31 Assets 2015 2014 Cash $ 12 $ 31 Marketable securities 66 82 Accounts receivable 152 104 Inventories 191 145 Total current assets $421 $362 Gross fixed assets $195 $180 Less: Accumulated depreciation 63 52 Net fixed assets $132 $128 Total assets $553 $490 Liabilities and stockholders' equity Accounts payable $136 $126 Notes payable 200 190 Accruals 27 25 Total current liabilities $363 $341 Long-term debt $ 38 $ 40 Total liabilities $401 $381 Common stock (50,000 shares out- $ 20 $ 20 Liabilities and stockholders' equity Accounts payable $136 $126 Notes payable 200 190 Accruals 27 25 Total current liabilities $363 $341 Long-term debt $ 38 $ 40 Total liabilities $401 $381 Common stock (50,000 shares out- $ 20 $ 20 standing at $0.40 par value) Paid-in capital in excess of par 30 30 Retained earnings 102 59 Total stockholders' equity $152 $109 Total liabilities and stockholders' eq- $553 $490 uity Table 4 Track Software, Inc., Statement of Re- tained Earnings ($000) for the Year Ended De- cember 31, 2015 Retained earnings balance (January 1, $ 59 2015) Plus: Net profits after taxes (for 2015) 48 Less: Cash dividends on common stock (paid during 2015) Retained earnings balance (December 31, $102 2015) LO Table 5 Actual Industry aver- 2014 Ratio age 2015 Current ratio 1.06 1.82 Quick ratio 0.63 1.10 Inventory turnover 10.40 12.45 Average collection pe- 29.6 riod 20.2 days days Total asset turnover 2.66 3.92 Debt ratio 0.78 0.55 Times interest earned 3.0 ratio 5.6 Gross profit margin 32.1% 42.3% Operating profit mar- 5.5% gin 12.4% Net profit margin 3.0% 4.0% Return on total assets 8.0% 15.6% (ROA) Return on common equity (ROE) 36.4% 34.7% Price/earnings (P/E) ratio 5.2 7.1 Market/book (M/B) ra- 2.1 2.2 tio
Expert Answer:
Answer rating: 100% (QA)
Data Equity 50000 Bank loan 50000 Initial investment 100000 Percentage of ownership 06 Val... View the full answer
Related Book For
Microeconomics Principles, Problems and Policies
ISBN: 978-1259450242
20th edition
Authors: Campbell R. McConnell, Stanley L. Brue, Sean Masaki Flynn
Posted Date:
Students also viewed these accounting questions
-
Analyze the American dream as it relates to the two main characters, Jay Gatsby and Charles Foster Kane in terms of three issues that you have chosen. When you do comparison and contrast, you need to...
-
As it relates to the vicious circle of poverty, what is meant by the saying Some DVCs stay poor because they are poor? Change the box labels as necessary in Figure 25W.3 to explain rapid economic...
-
The salesperson as it relates to consumer buying behavior.
-
2 3 -4 6,-12,-18 If A = (a) 0 3a 2b 24 (b) -6,4,9 and KA= then the value of k, a,b are respectively (c) -6,-4,-9. (d) -6,12,18
-
Consider the trash bag problem. Suppose that an independent laboratory has tested trash bags and has found that no 30-gallon bags that are currently on the market have a mean breaking strength of 50...
-
The CEO of a regional airline recently learned that its only competitor is suffering from a significant cash-flow constraint. The CEO realizes that its competitors days are numbered, but has asked...
-
Outline the general strategy used in metagenomics.
-
Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his divisions return on investment (ROI), which has been above 20% each of the last three...
-
It is argued that decisions made in relatively risk-free environments are not optimal or not efficient. If this assertion is true, can we declare that the decision-making environment constrained by...
-
An oil company purchased an option on land in Alaska. Preliminary geologic studies assigned the following prior probabilities. P(high-quality oil) = 0.50 P(medium-quality oil) = 0.20 P(no oil) = 0.30...
-
Amelia has wages of $45,000 and net income from a small unincorporated business of $70,000 for 2021. (Click on the icon to view the self-employment tax rate table.) Requirements a. What is the amount...
-
How will the change in Accounts Payable be shown on the statement of cash flows? Question content area bottom Part 1 A. as an addition to operating cash flows B. as a deduction from Net Income in the...
-
5.9 You discover a record marked RRSIG in your DNS zone. What conclusions can you draw from this entry Question 8 options: DNSSEC has been enabled Conditional forwarding has been applied Peer Name...
-
6. Propose ONE appropriate indicator and standard of quality that could be used within a Limits of Acceptable Change management framework to monitor and control the problem/impact
-
Write a program to generate random passwords; the user should be able to select the length. Create a new project called04.06Password Generator in the Mod04Assignments folder. Create a class called...
-
how you would present return on equity (ROE) and earnings per share (EPS) to a group of investors or senior management.
-
A thermally-insulated subsea pipeline is used to transport oil at 140 C and with a flowrate of 1130 m/hr. The pipe is made of AISI 1010 carbon steel, has OD = 25 cm, ID = 20 cm, and it is insulated...
-
The following data are supplied for the common stocks of Nikola Corporation, Tesla, Inc. and General Motors: Nikola Corp (NKLA) Tesla Inc. (TSLA) Close Price ($) Close Price ($) 67.53 30.00 40.81...
-
True or false. The U shape of the long-run ATC curve is the result of diminishing returns.
-
Ted has always had difficulty saving money. So on June 1 st , Ted enrolls in a Christmas savings program at his local bank and deposits $750. That money is totally locked away until December 1 st so...
-
Suppose that the last dollar that Victoria receives as income brings her a marginal utility of 10 utils while the last dollar that Fredrick receives as income brings him a marginal utility of 15...
-
The number of claims received by an insurance company during a week follows a Poisson ( ) distribution. The weekly number of claims observed over a ten week period are: \(5,8,4,6,11,6,6,5,6,4\). (a)...
-
The number of defects per 10 meters of cloth produced by a weaving machine has the Poisson distribution with mean . You examine 100 meters of cloth produced by the machine and observe 71 defects. (a)...
-
The number of particles emitted by a radioactive source during a ten second interval has the Poisson( ) distribution. The radioactive source is observed over ve non-overlapping intervals of ten...
Study smarter with the SolutionInn App