Part 3 Tools of Financial Analysis and Planning 10 Cash Accounts receivable Inventory Plant and equipment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 3 Tools of Financial Analysis and Planning 10 Cash Accounts receivable Inventory Plant and equipment Total assets Cash Receivables Inventories 4. Kedzie Kord Company had the following balance sheets and income statements over the last three years (in thousands): Current assets Net fixed assets Total assets. Payables Accruals Bank loan Current liabilities Long-term debt Shareholder's equity Total liabilities and shareholder's equity Sales Cost of goods sold Selling, general, and administrative expenses Interest Profit before taxes Taxes Profit after taxes Sales (in millions) Total assets (in millions) Net income (in millions) A 20X1 $ 561 1,963 2,031 $ 4,555 2,581 $ 7,136 $10 $ 1,862 301 250 $ 2,413 500 4,223 8 0.7 $ 7,136 $11,863 8,537 2,276 73 $ 977 390 $ 587 Notes and payables Long-term debt Common stock Retained earnings Total liabilities and shareholders' equity B $20 10 2 Problems 1. The data for various companies in the same industry are as follows: 20X2 $387 2,870 2,613 $ 5,870 C $8 4,430 $10,300 $ 2,944 516 6 0.8 900 $ 4,360 1,000 4.940 $10,300 $14,952 11,124 Using common-size and index analysis, evaluate trends in the company's financial condi- tion and performance. 2,471 188 $ 1,169 452 $717 COMPANY D $5 $100,000 $100,000 $100,000 $ 2.5 0.5 E $12 4 1.5 20X3 $ 202 4,051 3,287 $ 7,540 4,364 $11,904 $ 3,613 587 1,050 $5,250 950 5,704 $11.904 $16,349 12,016 2,793 200 $ 1,340 576 $ 764 F $17 8 1 Determine the total asset turnover, net profit margin, and earning power for each of the companies. 2. Cordillera Carson Company has the following balance sheet and income statement for 20X2 (in thousands): BALANCE SHEET Cash Accounts receivable Inventories Current assets Net fixed assets Total assets Accounts payable Accruals Short-term loans Current liabilities Long-term debt Net worth Total liabilities and net worth Current ratio Curatio Acid-test ratio Debt-to-total-assets Inventory turnover Average collection period Total asset turnover Net profit margin Return on investment (ROI) Return on equity (ROE) Current assets Net fixed assets Total assets $ 400 1,300 2,100 $3,800 3,320 $7,120 Notes: (i) current period's depreciation is $480; (ii) ending inventory for 20X1 was $1,800. On the basis of this information, compute (a) the current ratio, (b) the acid-test ratio, (c) the average collection period, (d) the inventory turnover ratio, (e) the debt-to-net-worth ratio, (f) the long-term debt-to-total-capitalization ratio, (g) the gross profit margin, (h) the net profit margin, and (i) the return on equity. 3. Selected financial ratios for RMN, Incorporated, are as follows: $ 320 260 1,100 $1,680 2,000 3,440 $7,120 BALANCE SHEET AS OF DECEMBER 31, 20X6 (IN THOUSANDS) Cash and marketable securities $500 Accounts receivable ? Inventories ? ? Profit before taxes 20X1 4.2 2.1 2396 Taxes (44% rate) 8.7x 33 days 3.2x 3.8% 12.1% 15.7% Profit after taxes INCOME STATEMENT Net sales (all credit) Cost of goods sold Gross profit Selling, general, and administration expenses Interest expense Profit before taxes Taxes Profit after taxes 6 Financial Statement Analysis Selling and administrative expenses Interest expense 20X2 2.6 1.0 33% INCOME STATEMENT FOR 20X6 (IN THOUSANDS) Credit sales Cost of goods sold Gross profit 5.4x 36 days. 2.6x 2.5% 6.5% 9.7% a. Why did return on investment decline? b. Was the increase in debt a result of greater current liabilities or of greater long-term debt? Explain. 4. The following information is available on the Vanier Corporation: Accounts payable Bank loan Accruals Current liabilities Long-term debt 20X3 1.8 0.6 47% 49 days 1.9x 1.4% 3.5x Common stock and retained earnings Total liabilities and equity $8,000 2.8% 5.4% 400 $12,680 8,930 $ 3,750 2,230 460 $ 1,060 390 $ 670 $ 400 ? 200 ? 2,650 3.750 159 The current period's deferred tax expense (a noncash charge) is added back to net income the argument is that profits were understated because taxes were, in effect, overstated. - The deferred taxes reported on the firm's balance sheet are added to equity - here the argument is that because this amount is not a definite, legal obligation requiring pay- ment in the foreseeable future, it overstates the debt position of the firm. In short, it is more like equity than debt. Such adjustment will, of course, affect the calculation of the firm's debt and profitability ratios. Still another school of thought rejects both of the previous adjustments. Called the "net- of-tax" approach, this viewpoint calls for most deferred taxes to be treated as adjustments to the amounts at which the related assets are carried on the firm's books. An analyst subscrib- ing to this approach would make the following financial statement adjustment: The deferred taxes on the firm's balance sheet are subtracted from net fixed assets - the reason is that when there is an excess of tax depreciation over book depreciation, an asset's value is decreased, rather than a liability created. Accelerated depreciation, in effect, uses up an additional part of an asset's tax-reducing capacity relative to straight- line depreciation. The immediate loss of the future tax-reducing (i.e., tax-shield) benefit should be deducted from the related asset account. This adjustment will affect the calculation of various leverage, activity, and profitability ratios. 1. What is the purpose of a balance sheet? An income statement? 2. Why is the analysis of trends in financial ratios important? 3. Auxier Manufacturing Company has a current ratio of 4 to 1 but is unable to pay its bills. Why? 4. Can a firm generate a 25 percent return on assets and still be technically insolvent (unable to pay its bills)? Explain. 5. The traditional definitions of collection period and inventory turnover are criticized because in both cases balance sheet figures that are a result of approximately the last month of sales are related to annual sales (in the former case) or annual cost of goods sold (in the latter case). Why do these definitions present problems? Suggest a solution. 6. Explain why a long-term creditor should be interested in liquidity ratios. 7. Which financial ratios would you be most likely to consult if you were the following? Why? a. A banker considering the financing of seasonal inventory b. A wealthy equity investor c. The manager of a pension fund considering the purchase of a firm's bonds d. The president of a consumer products firm 8. In trying to judge whether a company has too much debt, what financial ratios would you use and for what purpose? 9. Why might it be possible for a company to make large operating profits, yet still be unable to meet debt payments when due? What financial ratios might be employed to detect such a condition? 10. Does increasing a firm's inventory turnover ratio increase its profitability? Why should this ratio be computed using cost of goods sold (rather than sales, as is done by some compilers of financial statistics)? Part 3 Tools of Financial Analysis and Planning 10 Cash Accounts receivable Inventory Plant and equipment Total assets Cash Receivables Inventories 4. Kedzie Kord Company had the following balance sheets and income statements over the last three years (in thousands): Current assets Net fixed assets Total assets. Payables Accruals Bank loan Current liabilities Long-term debt Shareholder's equity Total liabilities and shareholder's equity Sales Cost of goods sold Selling, general, and administrative expenses Interest Profit before taxes Taxes Profit after taxes Sales (in millions) Total assets (in millions) Net income (in millions) A 20X1 $ 561 1,963 2,031 $ 4,555 2,581 $ 7,136 $10 $ 1,862 301 250 $ 2,413 500 4,223 8 0.7 $ 7,136 $11,863 8,537 2,276 73 $ 977 390 $ 587 Notes and payables Long-term debt Common stock Retained earnings Total liabilities and shareholders' equity B $20 10 2 Problems 1. The data for various companies in the same industry are as follows: 20X2 $387 2,870 2,613 $ 5,870 C $8 4,430 $10,300 $ 2,944 516 6 0.8 900 $ 4,360 1,000 4.940 $10,300 $14,952 11,124 Using common-size and index analysis, evaluate trends in the company's financial condi- tion and performance. 2,471 188 $ 1,169 452 $717 COMPANY D $5 $100,000 $100,000 $100,000 $ 2.5 0.5 E $12 4 1.5 20X3 $ 202 4,051 3,287 $ 7,540 4,364 $11,904 $ 3,613 587 1,050 $5,250 950 5,704 $11.904 $16,349 12,016 2,793 200 $ 1,340 576 $ 764 F $17 8 1 Determine the total asset turnover, net profit margin, and earning power for each of the companies. 2. Cordillera Carson Company has the following balance sheet and income statement for 20X2 (in thousands): BALANCE SHEET Cash Accounts receivable Inventories Current assets Net fixed assets Total assets Accounts payable Accruals Short-term loans Current liabilities Long-term debt Net worth Total liabilities and net worth Current ratio Curatio Acid-test ratio Debt-to-total-assets Inventory turnover Average collection period Total asset turnover Net profit margin Return on investment (ROI) Return on equity (ROE) Current assets Net fixed assets Total assets $ 400 1,300 2,100 $3,800 3,320 $7,120 Notes: (i) current period's depreciation is $480; (ii) ending inventory for 20X1 was $1,800. On the basis of this information, compute (a) the current ratio, (b) the acid-test ratio, (c) the average collection period, (d) the inventory turnover ratio, (e) the debt-to-net-worth ratio, (f) the long-term debt-to-total-capitalization ratio, (g) the gross profit margin, (h) the net profit margin, and (i) the return on equity. 3. Selected financial ratios for RMN, Incorporated, are as follows: $ 320 260 1,100 $1,680 2,000 3,440 $7,120 BALANCE SHEET AS OF DECEMBER 31, 20X6 (IN THOUSANDS) Cash and marketable securities $500 Accounts receivable ? Inventories ? ? Profit before taxes 20X1 4.2 2.1 2396 Taxes (44% rate) 8.7x 33 days 3.2x 3.8% 12.1% 15.7% Profit after taxes INCOME STATEMENT Net sales (all credit) Cost of goods sold Gross profit Selling, general, and administration expenses Interest expense Profit before taxes Taxes Profit after taxes 6 Financial Statement Analysis Selling and administrative expenses Interest expense 20X2 2.6 1.0 33% INCOME STATEMENT FOR 20X6 (IN THOUSANDS) Credit sales Cost of goods sold Gross profit 5.4x 36 days. 2.6x 2.5% 6.5% 9.7% a. Why did return on investment decline? b. Was the increase in debt a result of greater current liabilities or of greater long-term debt? Explain. 4. The following information is available on the Vanier Corporation: Accounts payable Bank loan Accruals Current liabilities Long-term debt 20X3 1.8 0.6 47% 49 days 1.9x 1.4% 3.5x Common stock and retained earnings Total liabilities and equity $8,000 2.8% 5.4% 400 $12,680 8,930 $ 3,750 2,230 460 $ 1,060 390 $ 670 $ 400 ? 200 ? 2,650 3.750 159 The current period's deferred tax expense (a noncash charge) is added back to net income the argument is that profits were understated because taxes were, in effect, overstated. - The deferred taxes reported on the firm's balance sheet are added to equity - here the argument is that because this amount is not a definite, legal obligation requiring pay- ment in the foreseeable future, it overstates the debt position of the firm. In short, it is more like equity than debt. Such adjustment will, of course, affect the calculation of the firm's debt and profitability ratios. Still another school of thought rejects both of the previous adjustments. Called the "net- of-tax" approach, this viewpoint calls for most deferred taxes to be treated as adjustments to the amounts at which the related assets are carried on the firm's books. An analyst subscrib- ing to this approach would make the following financial statement adjustment: The deferred taxes on the firm's balance sheet are subtracted from net fixed assets - the reason is that when there is an excess of tax depreciation over book depreciation, an asset's value is decreased, rather than a liability created. Accelerated depreciation, in effect, uses up an additional part of an asset's tax-reducing capacity relative to straight- line depreciation. The immediate loss of the future tax-reducing (i.e., tax-shield) benefit should be deducted from the related asset account. This adjustment will affect the calculation of various leverage, activity, and profitability ratios. 1. What is the purpose of a balance sheet? An income statement? 2. Why is the analysis of trends in financial ratios important? 3. Auxier Manufacturing Company has a current ratio of 4 to 1 but is unable to pay its bills. Why? 4. Can a firm generate a 25 percent return on assets and still be technically insolvent (unable to pay its bills)? Explain. 5. The traditional definitions of collection period and inventory turnover are criticized because in both cases balance sheet figures that are a result of approximately the last month of sales are related to annual sales (in the former case) or annual cost of goods sold (in the latter case). Why do these definitions present problems? Suggest a solution. 6. Explain why a long-term creditor should be interested in liquidity ratios. 7. Which financial ratios would you be most likely to consult if you were the following? Why? a. A banker considering the financing of seasonal inventory b. A wealthy equity investor c. The manager of a pension fund considering the purchase of a firm's bonds d. The president of a consumer products firm 8. In trying to judge whether a company has too much debt, what financial ratios would you use and for what purpose? 9. Why might it be possible for a company to make large operating profits, yet still be unable to meet debt payments when due? What financial ratios might be employed to detect such a condition? 10. Does increasing a firm's inventory turnover ratio increase its profitability? Why should this ratio be computed using cost of goods sold (rather than sales, as is done by some compilers of financial statistics)?
Expert Answer:
Related Book For
Intermediate Accounting
ISBN: 978-1119048541
11th Canadian edition Volume 2
Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield, Nicola M. Young, Irene M. Wiecek, Bruce J. McConomy
Posted Date:
Students also viewed these finance questions
-
South Africa has experienced an increased amount of loadshedding in the past year, which has resulted in high levels of frustration especially for business owners. Coffee Brew King is owned by...
-
In July 2011, the finale to the Harry Potter movie series, Harry Potter and the Deathly Hallows Part 2, from Time Warner Inc.s Warner Bros. Pictures, earned an estimated $ 307 million in 59 countries...
-
Division S of ABC Company makes a part that it sells to other companies. Data on that part appear below: Selling price on the intermediate market $30 per unit Variable costs per unit $22 per unit...
-
Ms. Patricia Sullivan plans to create a fund from her lottery winnings to meet three objectives. First, she wants to create a fund so that her mother can withdraw $20,000 per month for the remainder...
-
Determine the force in members AB, CD, ED, and CF of the space truss and state if the members are in tension orcompression. 2 m 2 m 2 m/ 3 m. B. |-2k) kN |-2k) kN
-
A hemispherical bowl of radius \(R\) is placed in a uniform magnetic field that has magnitude \(B_{0}\) and is in the positive \(z\) direction. The open top of the bowl is in the \(x y\) plane....
-
What financing alternatives would be available to a U.S. firm that was interested in investing in a proposed manufacturing plant in a small country that recently left the communist bloc and did not...
-
a) Explain the difference between quantum Mechanics and Classical Mechanics b) Explain the Bohr's form of quantization of Energy [4 mks] [3 mks] c) Calculate the penetration distance for a very small...
-
A vertical aerial photograph reveals a tall building. The foot of one corner of the building has (x, y) coordinates (30.5, 62.0) (both measured in mm from the lower left-hand corner of the negative),...
-
Record the replenishment of the $50.00 petty cash fund. The following documentation was gathered from the petty cash box: Petty Cash Slip Amount Purpose PC451 $ 3.85 Miscellaneous expenses PC452...
-
Dr. Sachiko McBride's squirrel, named Half-tail, runs north at 12 km/h for 2.5 min, then south at 14 km/h for 5.5 min, and then north at 11 km/h for 3.1 min. Set going to the north as the positive...
-
When uranium-238 absorbs a neutron (; no charge, but 1 mass unit), the result is uranium-239: 235U + U. The U-239 then undergoes two suc- cessive beta decays, like that of carbon-14 in Equation 7.2....
-
A person stands 6.00 m from a speaker, and 8.00 m from an identical speaker. What is the frequency of the second (n = 2) interference minimum (destructive)? (Hint: v Af= 343 m/s) (Unit = Hz)
-
. Why is it important to ensure that your financial management software is suitable for your business?
-
Convert the context-free grammar G in Chomsky Normal Form, where G = (V,T, S,T) with V = {S, A, B, C, D), T = {a,b,c} and P: S AABD|aBB A a| B BB|bc|X CCD|a D Db DD
-
Which one is the strongest acid A.Sulphuric acid with concentration 0.2 M. B.Nitric acid with concentration 0.2 M. Options are: a. Sulphuric acid because of the high number of H+ b. Nitric acid as it...
-
The baseball player A hits the ball from a height of 3.36 ft with an initial velocity of 34.8 ft/s. 0.14 seconds after the ball is hit, player B who is standing 15 ft away from home plate begins to...
-
At December 31, 2017, Bouvier Corp. has assets of $10 million, liabilities of $6 million, common shares of $2 million (representing 2 million common shares of $1.00 par), and retained earnings of $2...
-
Bryce Corporation is preparing the comparative financial statements for the annual report to its shareholders for the fiscal years ended May 31, 2017 and May 31, 2018. The income from operations was...
-
Refer to P16-1, but assume that Hing Wa wrote (sold) the call option for a premium of $480 (instead of buying it). Assume that the market price of the shares and the fair value of the option are...
-
Let us consider a call option with maturity \(T=1\) year and strike price \(\$ 11\). The current price of the stock share is \(\$ 10\), and the riskfree interest rate is \(10 \%\). The two possible...
-
Let us consider the PDE with terminal condition In order to apply the representation theorem, we observe that \(r=0\), \((x t)=\), and , so that the underlying stochastic process boils down to a...
-
Let us consider the same setting as Example 13.4: \(S_{0}=K=50\), \(r=01, \quad=04\), and time-to-maturity is \(T=5/12\) (here we take \(t=0)\). The calculation is as follows: This exact result may...
Study smarter with the SolutionInn App