Prepare a pro forma income statement

Assignment Help Corporate Finance
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

Verified Expert

The assignment relates to working capital management. In part 1, pro-forma income statement is prepared and after calculation of metrics the working capital performance is analysed. In part 2 pro-forma balance sheet is prepared assuming company takes further borrowings. Part 3,4 and 5 provides role of financial analyst, control over the company by ownership and competitive companies in the fancy food industry.

Reference no: EM131671125

Questions Cloud

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?

Reviews

inf1671125

1/9/2018 3:32:34 AM

Much obliged to you for your astonishing service. I know where to request help on the off chance that I have homework questions.

len1671125

10/7/2017 2:56:49 AM

Read case, finalize spreadsheet with new balance sheet numbers and review income statement numbers and calculation of ratios for accuracy. Complete 2 pages answering all 5 of the questions on the word document attached. The financials to review will be done on the excel document, do not include those again in the word document. Please make sure all questions are answered. This is a master level analysis.

Write a Review

Corporate Finance Questions & Answers

  Average collection period to the industry average

How much additional financing can be obtained from receivables if Anderson institutes more stringent credit and collection policies and is able to reduce its average collection period to the industry average and calculate the firm's current, quick,..

  Quantitative vs tarditional fundamental analysis

Quantitative vs tarditional fundamental analysis Would you propose that the acquisition or merger target have a high or low equity value-to-earnings multiple

  Compute the initial investment cash outlay

Compute the initial investment cash outlay. This is the total cost of equipment purchase ($285,000), installation and shipping ($25,000), and change in net working capital

  Explain the type of cost system you plan to implement

Explain the type of cost system you plan to implement in your company, and identify any major challenge(s) in implementing your cost system. Suggest a way to overcome the identified challenge(s).

  Consider that sales for the entire year were 100000 and

consider that sales for the entire year were 100000 and cost of goods sold was 80 of sales. the inventory conversion

  Why does a corporation buyback stock

Why does a corporation buyback stock? How does buying back shares impact net earnings, earnings per share, shares outstanding and stock price?

  Annual cash flows from the acceptance of dynamo

On the basis of costs, would you recommend Radiant to purchase the specialised equipment and packaging facilities from  Donnalley Limited or Danforth Limited

  What types of costs do corporations incur

What are some potential disadvantages to the issue of using a private placement?

  Calculate return on equity using the dupont system

Calculate Return on Equity (ROE) using the DuPont system. Assess management performance by calculating Economic Value Added (EVA).

  Compute the net present value and payback period

Compute the Net Present Value, Payback Period and the Internal Rates of Return for each alternative and on the basis of your analysis in question 2, which of the alternatives would you recommend

  Explain the organization chart of finance function

Explain the organization chart of finance function in a typical organization. What is  the key function of each role/position? Explain the difference between the  treasury and controller function.

  Discuss expected profit and return on investments

Discuss expected profit and return on investments. Discuss your assessment of whether or not your business service is likely to be successful.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd