Reference no: EM13829164

Sergio Zubieta

Problems:

P1. Complete the table below using the attached financial statements.

	Industry Average	Allied Food
Current Ratio	4.2
Quick Ratio	2.2
Inventory Turnover Ratio	10.9
Average Collection Period	36 days
Fixed Asset Turnover	2.8
Total Asset Turnover	1.8
Debt Ratio	40%
Times Interest Earned	6
Profit Margin	5%
Return on Assets	9%
Operating Margin	10%
Basic Earning Power	18%
Return on Equity	15%

After comparing Allied Food to the industry for each ratio and category of ratios, share key insights and/or managerial recommendations (note: this part of the question is just as important as correctly solving for all of the above ratios using Allied's financials below).

P2. Solve for Firm U's Return on Equity for expected and bad conditions:

Firm U (unleveraged)
CA	50	Debt	0
FA	50	Equity	100
TA	100		100
	Expected	Bad
Sales	100	82.5
Toper Costs	70	80
EBIT	30	2.5
Interest	0	0
EBT	30	2.5
Taxes	12	1
Net Inc	18	1.5

Now, solve for firm L's Return on Equity for expected and bad conditions:

Firm L (Leveraged)
CA	50	Debt	50
FA	50	Equity	50
TA	100		100
	Expected	Bad
Sales	100	82.5
Oper Costs	70	80
EBIT	30	2.5
Interest	7.5	7.5
EBT	22.5	-5
Taxes	9	-2
Net Inc	13.5	-3

Use this information to elaborate upon an organization's use of debt.

P3. Compare the percentage change in net operating profit after taxes to the percentage change in net income using 2007 and 2008 data from Allied Food Product's financial statements.  What conclusions can you draw from this analysis?

P4. Using 2008 data, calculate Allied's earnings per share (EPS). Assume there are 45,000,000 shares outstanding and the data in the income statement and balance sheet accounts are measured in millions.

P5. Use the financial statements below to solve for Allied'sDuPont Equation.  Explain key drivers of performance for Allied.

P6. Solve for the present value of $10,500 to be received in 5 years if the opportunity cost rate is 8%.

P7. Solve for the future value of $12,000 to be invested for 10 years at 15%.

P8. Solve for the present value of the following series of cash flows: $400 to be received at the end of 1 year, $500 to be received at the end of 2 years, $600 to be received at the end of 3 years, and $700 to be received at the end of 4 years.  Assume the opportunity cost rate is 7%.

 

P9. Solve for the future value of the following series of cash flows: $300 to be invested today for 3 years and $200 to be invested one year from now for 2 years.

P10.  What is the present value of $1000 to be received at the end of every year in between now and forever if the opportunity cost rate is 5%?

P11. Ed inherited from his grandparents $100,000 today and $50,000 at the end of every year for 5 years.  What is the present value of Ed's inheritance?

Multiple Choice:

M1. DuPont Analysis:  You are considering investing in Lenny's Lube, Inc.  You have been able to locate the following information on the form: total assets = $20 million, accounts receivable =$6 million, ACP =20 days. Net income = $5 million, and debt-to-equity ratio=2.5 times.  What is the ROE for the firm?

a.        22.5%

b.        8.75%

c.        87.5%

d.        17.5%

M2. Given the following information, calculate the return on equity for Chaus, Inc.:

Return on Sales= 5%

Total asset turnover = 2

Debt ratio = .73

a.        22%

b.        32%

c.        47%

d.        37%

M3. For corporations, maximizing the value of owner's equity can also be stated

a.        Maximizing corporate social responsibility

b.        Maximizing revenues

c.        Maximizing the stock price

d.        Minimizing tax payments to the government

M4. Common stockholders' equity divided by number of shares of common stock outstanding is the formula for calculating

a.        Book value per share

b.        Earnings per share

c.        The market value of equity per share

d.        Dividends per share

M5. Which ratio measures how many days inventory is held before the final product is sold?

a.        Inventory turnover ratio

b.        Asset turnover ratio

c.        Times interest earned ratio

d.        Days' sales in inventory

M6. How much cash does Gray Computer Co. have if the firm has a current ratio of 2.5, a quick ratio of 1.2, and current liabilities of $12,000? Gray's credit sales are $98,000 and its average collection period is 40 days. (Assume 365 days per year.)

a.        2250

b.        3660

c.        4550

d.        8770

M7. Calculate the times interest earned ratio for LaTonya's Flop Shops, Inc. using the following information. Sales = $1 million, cost of goods sold = $600,000, depreciation expense = $100,000, addition to retained earnings = $97,500, dividends per share = $1, tax rate = 30%, and number of shares of common stock outstanding = 60,000. LaTonaya's Flop Shops has no preferred stock outstanding.

a.     3 times

b.     4 times

c.      5 times

d.     6 times

 

Allied Food Products: Balance Sheet
Assets	2013	2012		Liabilities and Equity	2013	2012
Cash	$10	$80		AP	$60	30
AR	$375	$315		NP	$110	60
Inv	$615	$415		Acc	$140	130
Total CA	$1,000	$810		Total CL	$310	220
FA	$1,000	$870		Long-term Bonds	$754	580
				Total Liabilities	$1,064	800
				PS	$40	40
				CS	$130	130
				RE	$766	710
				Total Common Equity	$896	$840
Total Assets	$2,000	$1,680		Total Liabilities and Equity	$2,000	$1,680

 

Allied Food Product: Income Statements
	2013	2012
Net Sales	$3,000.0	$2,850
Operating Costs	$2,616.2	$2,497
EBITDA	$383.8	$353
Depreciation	$100.0	$90
Amort	$0.0	$0
EBIT	$283.8	$263.0
Interest	$88.0	$60
Earnings Before Taxes	$195.8	$203.0
Taxes (40%)	$78.3	$81.2
Net Income Before Pre Div	$117.5	$121.8
Pre Div	$4.0	$4.0
Net Income	$113.5	$117.8
Common Div	$57.5	$53.0
Addition to RE	$56.0	$64.8