Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the data in exhibits C2.1 and C2.3, calculate and analyze the firms 2012 and 2013 ratios. Enter the ratios in the table below in

image text in transcribedimage text in transcribedimage text in transcribed

  1. Using the data in exhibits C2.1 and C2.3, calculate and analyze the firms 2012 and 2013 ratios. Enter the ratios in the table below in the 2012 and 2013 columns, respectively:image text in transcribed

2. Part of Owens evaluation will consist of comparing the firms ratios to the industry as shown in Exhibit C2.3 of the text. Discuss the limitations of such a comparative financial analysis. In view of these limitations, why are such industry comparisons so frequently made? (Note: Sales are forecast to be $8.25 million in 2014).

3.Owen thinks that the profitability of the firm has been hurt by Tessas reluctance to use much interest-bearing debt. Is this a reasonable position? Explain.

4.The case mentions that Tessa rarely takes trade discounts, which are typically 1/10, net 30. Does this seem like a wise financial move? Explain.

5.Is the estimate of $35 to $40 for Owens shares a fair evaluation? Explain.

EXHIBIT C2.2 KF Balance Sheets: 2012-2013 \begin{tabular}{|c|c|c|c|} \hline & & 2012 & 2013 \\ \hline \multicolumn{4}{|l|}{ Assets } \\ \hline Cash & $ & 300,000 & $244,000 \\ \hline Accounts receivable & $ & 915,000 & $1,106,600 \\ \hline Inventory & $ & 700,000 & $1,222,300 \\ \hline Other current & $ & 36,200 & $46,800 \\ \hline Current assets & & 1,951,200 & $2,619,700 \\ \hline Gross fixed assets & $ & 340,000 & $493,600 \\ \hline Accumulated depreciation & ($ & 135,000) & ($233,800) \\ \hline Net fixed assets & $ & 205,000 & $259,800 \\ \hline Total assets & & 2,361,200 & $2,879,500 \\ \hline \multicolumn{4}{|l|}{ Liabilities and Net Worth } \\ \hline Accounts payable & $ & 345,700 & $544,800 \\ \hline Notes payable & $ & 63,200 & $63,200 \\ \hline Accruals & $ & 164,300 & $156,100 \\ \hline Current liabilities & $ & 573,200 & $764,100 \\ \hline Long-term debt & $ & 316,000 & $252,800 \\ \hline Common stock ( 62,000 shares outstanding) & $ & 948,000 & $1,137,600 \\ \hline Retained earnings & $ & 524,000 & $725,000 \\ \hline Total liabilities and net worth & & 2,361,200 & $2,879,500 \\ \hline \end{tabular} EXHIBIT C2.1 KF Income Statements: 2012-2013 \begin{tabular}{|c|c|c|} \hline & 2012 & 2013 \\ \hline Sales & $6,572,800 & $7,811,500 \\ \hline Cost of goods sold & 4,896,700 & 5,866,200 \\ \hline Gross margin & $1,676,100 & $1,945,300 \\ \hline Administrative & 1,281,700 & 1,492,200 \\ \hline Depreciation & 72,000 & 86,000 \\ \hline Earnings before interest and taxes & $322,400 & $367,100 \\ \hline Interest & 37,900 & 31,600 \\ \hline Earnings before taxes & $284,500 & $335,500 \\ \hline Taxes (at 40% ) & 113,800 & 134,200 \\ \hline Net income & $170,700 & $201,300 \\ \hline \end{tabular} EXHIBIT C2.3 Financial Ratios for the Electronic Arts Industry \begin{tabular}{lc} \hline & Industry Averages* \\ \hline Current (times) & 2.6/1.7/1.3 \\ Quick (times) & 1.6/0.8/0.6 \\ Debt \% & 41/57/71 \\ Times interest earned (times) & 7.4/3.9/1.3 \\ Inventory turnover (times) & 8.1/6.0/3.5 \\ Total asset turnover (times) & 3.5/2.8/2.0 \\ Average collection period (days) & 41/50/68 \\ Return on equity \% & 27.3/19.5/7.8 \\ \hline * Third quartile, median, and first quartile results & \end{tabular} EXHIBIT C2.2 KF Balance Sheets: 2012-2013 \begin{tabular}{|c|c|c|c|} \hline & & 2012 & 2013 \\ \hline \multicolumn{4}{|l|}{ Assets } \\ \hline Cash & $ & 300,000 & $244,000 \\ \hline Accounts receivable & $ & 915,000 & $1,106,600 \\ \hline Inventory & $ & 700,000 & $1,222,300 \\ \hline Other current & $ & 36,200 & $46,800 \\ \hline Current assets & & 1,951,200 & $2,619,700 \\ \hline Gross fixed assets & $ & 340,000 & $493,600 \\ \hline Accumulated depreciation & ($ & 135,000) & ($233,800) \\ \hline Net fixed assets & $ & 205,000 & $259,800 \\ \hline Total assets & & 2,361,200 & $2,879,500 \\ \hline \multicolumn{4}{|l|}{ Liabilities and Net Worth } \\ \hline Accounts payable & $ & 345,700 & $544,800 \\ \hline Notes payable & $ & 63,200 & $63,200 \\ \hline Accruals & $ & 164,300 & $156,100 \\ \hline Current liabilities & $ & 573,200 & $764,100 \\ \hline Long-term debt & $ & 316,000 & $252,800 \\ \hline Common stock ( 62,000 shares outstanding) & $ & 948,000 & $1,137,600 \\ \hline Retained earnings & $ & 524,000 & $725,000 \\ \hline Total liabilities and net worth & & 2,361,200 & $2,879,500 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Ratio Type } & \multicolumn{1}{c|}{2012} & \\ \hline Current (times) & & \\ \hline Quick (times) & & \\ \hline Debt (\%) & & \\ \hline Times interest earned (times) & & \\ \hline Inventory turnover (times) & & \\ \hline Total asset turnover (times) & & \\ \hline Average collections period (days) & & \\ \hline Return on equity (\%) & & \\ \hline \end{tabular} EXHIBIT C2.3 Financial Ratios for the Electronic Arts Industry \begin{tabular}{lc} \hline & Industry Averages* \\ \hline Current (times) & 2.6/1.7/1.3 \\ Quick (times) & 1.6/0.8/0.6 \\ Debt \% & 41/57/71 \\ Times interest earned (times) & 7.4/3.9/1.3 \\ Inventory turnover (times) & 8.1/6.0/3.5 \\ Total asset turnover (times) & 3.5/2.8/2.0 \\ Average collection period (days) & 41/50/68 \\ Return on equity \% & 27.3/19.5/7.8 \\ \hline * Third quartile, median, and first quartile results & \end{tabular} EXHIBIT C2.1 KF Income Statements: 2012-2013 \begin{tabular}{|c|c|c|} \hline & 2012 & 2013 \\ \hline Sales & $6,572,800 & $7,811,500 \\ \hline Cost of goods sold & 4,896,700 & 5,866,200 \\ \hline Gross margin & $1,676,100 & $1,945,300 \\ \hline Administrative & 1,281,700 & 1,492,200 \\ \hline Depreciation & 72,000 & 86,000 \\ \hline Earnings before interest and taxes & $322,400 & $367,100 \\ \hline Interest & 37,900 & 31,600 \\ \hline Earnings before taxes & $284,500 & $335,500 \\ \hline Taxes (at 40% ) & 113,800 & 134,200 \\ \hline Net income & $170,700 & $201,300 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Housing Policy And Finance

Authors: John Black, David Stafford

1st Edition

0415004195, 978-0415004190

More Books

Students also viewed these Finance questions