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

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

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