Reference no: EM13924962

Financial Statements and Taxes

Part I of this case, presented in Chapter 3, discussed the situation of D'Leon Inc., a regional snack foods producer, after an expansion program. D'Leon had increased plant capacity and undertaken a major marketing campaign in an attempt to "go national." Thus far, sales have not been up to the forecasted level, costs have been higher than were projected, and a large loss occurred in 2012 rather than the expected profit. As a result, its managers, directors, and investors are concerned about the firm's survival.
Donna Jamison was brought in as assistant to Fred Campo, D'Leon's chairman, who had the task of getting the company back into a sound financial position. D'Leon's 2011 and 2012 balance sheets and income statements, together with projections for 2013, are given in Tables IC 4.1 and IC 4.2. In addition, Table IC 4.3 gives the company's 2011 and 2012 financial ratios, together with industry average data. The 2013 projected financial statement data represent Jamison's and Campo's best guess for 2013 results, assuming that some new financing is arranged to get the company "over the hump."

Jamison examined monthly data for 2012 (not given in the case), and she detected an improving pattern during the year. Monthly sales were rising, costs were falling, and large losses in the early months had turned to a small profit by December. Thus, the annual data look somewhat worse than final monthly data. Also, it appears to be taking longer for the advertising program to get the message out, for the new sales offices to generate sales, and for the new manufacturing facilities to operate efficiently. In other words, the lags between spending money and deriving benefits were longer than D'Leon's managers had anticipated. For these reasons, Jamison and Campo see hope for the company-provided it can survive in the short run.Jamison must prepare an analysis of where the company is now, what it must do to regain its financial health, and what actions should be taken. Your assignment is to help her answer the following questions. Provide clear explanations, not yes or no answers.

Table IC 4.1.  Balance Sheets
	2013E	2012	2011
Assets
Cash	$85632	$7282	$57600
Accounts receivable	8,78,000	6,32,160	3,51,200
Inventories	17,16,480	12,87,360	7,15,200
Total current assets	$2680112	$1926802	$1124000
Gross fixed assets	11,97,160	12,02,950	4,91,000
Less accumulated depreciation	3,80,120	2,63,160	1,46,200
Net fixed assets	$817040	$939790	$344800
Total assets	$3497152	$2866592	$1468800
Liabilities and Equity
Accounts payable	$436800	$524160	$145600
Notes payable	3,00,000	6,36,808	2,00,000
Accruals	4,08,000	4,89,600	1,36,000
Total current liabilities	$1144800	$1650568	$481600
Long-term debt	4,00,000	7,23,432	3,23,432
Common stock	17,21,176	4,60,000	4,60,000
Retained earnings	2,31,176	32,592	2,03,768
Total equity	$1952352	$492592	$663768
Total liabilities and equity	$3497152	$2866592	$1468800

Note:  “E” indicates estimated.  The 2013 data are forecasts.

 

Table IC 4.2.  Income Statements
	2013E	2012	2011
Sales	$7035600	$6034000	$3432000
Cost of goods sold	58,75,992	55,28,000	28,64,000
Other expenses	5,50,000	5,19,988	3,58,672
Total operating costs
excluding deprec. & amort.	$6425992	$6047988	$3222672
EBITDA	$609608	($13,988)	$209328
Deprec. & amort.	1,16,960	1,16,960	18,900
EBIT	$492648	($130,948)	$190428
Interest expense	70,008	1,36,012	43,828
EBT	$422640	($266,960)	$146600
Taxes (40%)	1,69,056	(106,784)a	58,640
Net income	$253584	($160,176)	$87960
EPS	$1.014	($1.602)	$0.88
DPS	$0.22	$0.11	$0.22
Book value per share	$7.809	$4.926	$6.638
Stock price	$12.17	$2.25	$8.5
Shares outstanding	2,50,000	1,00,000	1,00,000
Tax rate	40.00%	40.00%	40.00%
Lease payments	40,000	40,000	40,000
Sinking fund payments	0	0	0

Note: “E” indicates estimated.  The 2013 data are forecasts.

a The firm had sufficient taxable income in 2010 and 2011 to obtain its full tax refund in 2012.

 

Table IC 4.3.  Ratio Analysis
				Industry
	2013E	2012	2011	Average
Current		1.2´	2.3´	2.7´
Quick		0.4´	0.8´	1.0´
Inventory turnover		4.7´	4.8´	6.1´
Days sales outstanding (DSO)a		38.2	37.4	32
Fixed assets turnover		6.4´	10.0´	7.0´
Total assets turnover		2.1´	2.3´	2.6´
Debt-to-assets ratio		82.80%	54.80%	50.00%
TIE		-1.0´	4.3´	6.2´
Operating margin		-2.20%	5.60%	7.30%
Profit margin		-2.70%	2.60%	3.50%
Basic earning power		-4.60%	13.00%	19.10%
ROA		-5.60%	6.00%	9.10%
ROE		-32.50%	13.30%	18.20%
Price/earnings		-1.4´	9.7´	14.2´
Market/book		0.5´	1.3´	2.4´
Book value per share		$4.93	$6.64	n.a.

 

Note: “E” indicates estimated.  The 2013 data are forecasts.

a Calculation is based on a 365-day year.

 

A.  Why are ratios useful? What are the five major categories of ratios?

B.  Calculate D'Leon's 2013 current and quick ratios based on the projected balance sheet and income statement data.  What can you say about the company's liquidity positions in 2011, in 2012, and as projected for 2013?  We often think of ratios as being useful (1) to managers to help run the business, (2) to bankers for credit analysis, and (3) to stockholders for stock valuation.  Would these different types of analysts have an equal interest in these liquidity ratios?

C.  Calculate the 2013 inventory turnover, days sales outstanding (DSO), fixed assets turnover, and total assets turnover.  How does D'Leon's utilization of assets stack up against other firms in the industry?

D.  Calculate the 2013 debt-to-assets and times-interest-earned ratios.  How does D'Leon compare with the industry with respect to financial leverage?  What can you conclude from these ratios?

E.  Calculate the 2013 operating margin, profit margin, basic earning power (BEP), return on assets (ROA), and return on equity (ROE).  What can you say about these ratios?

F.  Calculate the 2013 price/earnings ratio and market/book ratio.  Do these ratios indicate that investors are expected to have a high or low opinion of the company?

G.  Use the DuPont equation to provide a summary and overview of D'Leon's financial condition as projected for 2013.  What are the firm's major strengths and weaknesses?

H.  Use the following simplified 2013 balance sheet to show, in general terms, how an improvement in the DSO would tend to affect the stock price.  For example, if the company could improve its collection procedures and thereby lower its DSO from 45.6 days to the 32-day industry average without affecting sales, how would that change "ripple through" the financial statements (shown in thousands below) and influence the stock price? Accounts receivable $   878 Debt $1,545 Other current assets 1,802 Net fixed assets      817 Equity  1,952  Total assets $3,497  Liabilities plus equity $3,497

I.  Does it appear that inventories could be adjusted?  If so, how should that adjustment affect D'Leon's profitability and stock price?

J.  In 2012, the company paid its suppliers much later than the due dates; also, it was not maintaining financial ratios at levels called for in its bank loan agreements.  Therefore, suppliers could cut the company off, and its bank could refuse to renew the loan when it comes due in 90 days.  On the basis of data provided, would you, as a credit manager, continue to sell to D'Leon on credit?  (You could demand cash on delivery-that is, sell on terms of COD-but that might cause D'Leon to stop buying from your company.)  Similarly, if you were the bank loan officer, would you recommend renewing the loan or demand its repayment?  Would your actions be influenced if in early 2013 D'Leon showed you its 2013 projections along with proof that it was going to raise more than $1.2 million of new equity?

K.  In hindsight, what should D'Leon have done in 2011?

L.  What are some potential problems and limitations of financial ratio analysis?

M.  What are some qualitative factors analysts should consider when evaluating a company's likely future financial performance?