Reference no: EM131671125
To respond to the following questions, you will need to review the Quaker Cracker case study on pp. 242-244 of your textbook, Working Capital Management: Applications and Case Studies; the questions were adapted from the same section of the textbook. Respond in complete sentences as appropriate.
1. Part A: Using the data in exhibits C5.1 and C5.2, discuss how Quaker Cracker's results compare to its industry.
You will need to prepare a pro forma income statement (using the table in excel) before proceeding.
Income Statement
|
(in millions)
|
Sales
|
|
Cost of goods sold
|
|
Gross profit
|
|
Depreciation expense
|
|
Advertising and selling expenses
|
|
Profits before taxes
|
|
Income Taxes
|
|
Net income
|
|
Current (times)
|
|
Quick (times)
|
|
Debt (%)
|
|
Average collection period (days)
|
|
Total asset turnover (times)
|
|
Return on Equity (%)
|
|
After entering the calculations in the table above, discuss specific metrics that can be used to analyze working capital performance. Type your two- to three-sentence response below.
2. Part A: Show changes to the 2012 pro forma balance sheet assuming the company borrows the necessary funds for the capital improvements at an interest rate of 7 percent. Ignore depreciation on the new equipment. Enter your calculations in the table provided below.
Assets
|
Calculations
|
Liabilities and Owners' Equity
|
Calculations
|
Cash and Marketable Securities
|
|
Notes payable
|
|
Accounts Receivable
|
|
Accounts payable
|
|
Inventory
|
|
Accrued expenses
|
|
Current Assets
|
|
Current liabilities
|
|
Gross Fixed Assets
|
|
Long-term debt
|
|
Accumulated Depreciation
|
|
Common Stock ($10 par)
|
|
Net fixed assets
|
|
Retained earnings
|
|
Total assets
|
|
Total liabilities and owners' equity
|
|
Part B: Does this cause any significant change in the financials? Type your two- to three-sentence response below.
3. Play the role of a financial analyst and explain your recommended course of action. Type your three- to five-sentence response below.
4. The Cynsky family controls the company through its ownership of one half of the outstanding stock, with outsiders owning the balance. Should this influence McCabe's presentation of her recommendations? What arguments can you make in support of and against McCabe's position? Type your four- to five-sentence response below.
5. Why was the information provided in the second paragraph about competitive companies in the fancy food industry? Type your two- to four-sentence response.
Attachment:- Quaker Case - Financials.xlsx
Compare and contrast the issue of minority and majority
: Create a short bio, a page to a page and a half, on the author of your course project novel. What are the main themes in their work
|
Compute probability for the internal revenue service
: According to the Internal Revenue Service, income tax returns one year averaged $1,332 in refunds for taxpayers. One explanation of this figure is that taxpayer
|
Compute the break-even point in sales dollars
: Compute the break-even point in sales dollars if fixed costs are $200,000 and the total contribution margin is 20% of revenue.
|
Find the proportion of the cost
: Toolworkers are subject to work-related injuries. One disorder, caused by strains to the hands and wrists, is called carpal tunnel syndrome.
|
Prepare a pro forma income statement
: Discuss how Quaker Crackers results compare to its industry - prepare a pro forma income statement (using the table in excel) before proceeding
|
Determine the value of variable from the given information
: Suppose you are working with a data set that is normally distributed, with a mean of 200 and a standard deviation of 47.
|
Primary language-primary language
: Indicate a connection between this event/group of people and the impact of gender and culture, family therapy theories, etc.
|
What are pros of developing north point versus selling land
: What are the pros and cons of developing North Point versus selling the land? What implications can be drawn from this analysis?
|
Perspective on children with exceptionalities
: How do you think God has used this course to expand or strengthen your own biblical perspective on children with exceptionalities and their families?
|