Ratio and category of ratios

Assignment Help Financial Accounting

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

Reference no: EM13829164

Questions Cloud

Human resources practices for start-up companies : You are a specialized advising team from the highly successful Human Resource Consultancy Company known as "On-Target Consulting".

Employee bullying by management led to strike : The news item must be current; i.e., must have been published sometime during these dates: September 1, 2013 and November 29, 2013. You must reference this item accurately - following this format:

Effects of political democratic theories on democracy : Review the article "American Nightmare: Neoliberalism, Neoconservatism, and De-Democratization" in this week's Learning Resources. Think about the effects of political democratic theories on contemporary democracy

Team building intervention : Provide a description of a recent team-building intervention that you have participated in (If you did not participate in a recent team-building intervention, please find a friend, colleague or business associate to describe the exercise so that y..

Ratio and category of ratios : 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 Allie..

Analysis of a health and safety accident in work place : Write a case study analysis of a health and safety accident in work place in New Zealand. The write-up should cover the structure/guideline below within 1000 words.

Communicate your successes externally for marketing : It is equally important to communicate your successes externally for marketing and internally to continue to build on your successes. The messaging to these two groups, however, is very different

Additional information for the current year are available : A company that lost part of its accounting system in a fire is having trouble determining its net income for the current year. The following correct adjusted balances and additional information for the current year are available:

Report on conceptualization of new organization : Create a fantasy company. You decide the product that is to be produced (it may be information, services, or a tangible product), but your company must have at least 15 regular employees*. Include the following things in your assignment:

User Account

All Pages