Analyze expected performance and financing needs

Assignment Help Finance Basics
Reference no: EM131117926

Pro forma balance sheet Peabody & Peabody has 2012 sales of $10 million. It wishes to analyze expected performance and financing needs for 2014-2 years ahead. Given the following information, respond to parts a and b.

(1) The percents of sales for items that vary directly with sales are as follows:

Accounts receivable, 12%

Inventory, 18%

Accounts payable, 14%

Net profit margin, 3%

(2) Marketable securities and other current liabilities are expected to remain unchanged.

(3) A minimum cash balance of $480,000 is desired.

(4) A new machine costing $650,000 will be acquired in 2013, and equipment costing $850,000 will be purchased in 2014. Total depreciation in 2013 is forecast as $290,000, and in 2014 $390,000 of depreciation will be taken.

(5) Accruals are expected to rise to $500,000 by the end of 2014.

(6) No sale or retirement of long-term debt is expected.

(7) No sale or repurchase of common stock is expected.

(8) The dividend payout of 50% of net profits is expected to continue.

(9) Sales are expected to be $11 million in 2013 and $12 million in 2014.

(10) The December 31, 2012, balance sheet follows.

Peabody & Peabody Balance Sheet December 31, 2012 ($000)



Assets


Liabilities and Stockholders' Equity



Cash

$ 400

Accounts payable

$1,400


Marketable securities

200

Accruals

400


Accounts receivable

1,200

Other current liabilities

80


Inventories

1,800

Total current liabilities

$1,880


Total current assets

$3,600

Long-term debt

2,000


Net fixed assets

4,000

Total liabilities

$3,880


Total assets

$7,600

Common equity

3,720




Total liabilities and





stockholders' equity

$7,600


a. Prepare a pro forma balance sheet dated December 31, 2014.

b. Discuss the financing changes suggested by the statement prepared in part a.

Reference no: EM131117926

Questions Cloud

A no-growth company expected to pay : Flatbush Shipyards is a no-growth company expected to pay a $12-per- share annual dividend into the distant future. Its cost of equity capital is 15 percent.
Organization and promotion expenses : Interest revenue on investments held to fund construction of a building. Do you agree with these charges? If not, how would you deal with each of the items above in the corporation's books and in its annual financial statements?
Transformations in human culture : The agricultural revolution allowed some transformations in human culture to take place during the ancient colonial times in Africa. identify at least three of these revolutions?
Create a world that simulates a driving test : Also, write a function named is Test Passed, which evaluates whether the user has passed the test (i.e., whether the car has been driven past the gate).
Analyze expected performance and financing needs : Pro forma balance sheet Peabody & Peabody has 2012 sales of $10 million. It wishes to analyze expected performance and financing needs for 2014-2 years ahead. Given the following information, respond to parts a and b.
Violence of the french revolutionary era : The violence of the French Revolutionary era, the ideologies of the Enlightenment passing through the fire, the powerful reaction against the traumatic decades just passed: all these factors roiling together produced the new ideology known as "Rom..
Two positions have normally been taken : It should be included at the same rate as is charged to normal operations. What are the circumstances or rationale that support or deny the application of these methods?
Find nyse marketrac and click on the djia ticker tape : 1. Go to Find NYSE MarkeTrac and click on the DJIA ticker tape, which shows trades for the stocks in the Dow Jones Industrial Averages. Stop the tape at GE. What are the latest price, dividend yield, and P/E ratio?
What is the length of the trail : A straight trail with a uniform inclination of 11° leads from a lodge at an elevation of 600 feet to a mountain lake at an elevation of 9000 feet. What is the length of the trail (to the nearest foot)?

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the projects irr

You have now been tasked with providing a recommendation for the project based on the results of a Net Present Value Analysis. Assuming that the required rate of return is 15% and the initial cost of the machine is $3,500,000.

  Find breakeven in dollars and units

Suppose you are selling crafts - candles you make at home and trade at art fairs. Your fixed costs are $5,000 per year. Every candle costs $2 to make and sells for $10.

  What is the bond refunding npv

The new bonds would be issued 1 month before the old bonds are called, with the proceeds being invested in short-term government securities returning 6 percent annually during the interim period.a. Perform a complete bond refunding analysis. What is ..

  What are the investment proportions of your clients overall

What are the investment proportions of your client's overall portfolio, including the position in T-bills?

  Any conclusion drawn for the t-test statistical process is

any conclusion drawn for the t-test statistical process is only as good as the research question asked and the null

  What is the addition to retained earnings

Gallagher's Supply has sales of $387,000 and costs of $294,500. The depreciation expense is $43,800. Interest paid equals $18,200 and dividends paid equal $6,500. The tax rate is 35 percent. What is the addition to retained earnings?

  The weighted average cost of capital 98 if these values

forecasted information for the year 2014 sales300000000 operating profitability 6 capital requirements 43 growth 5

  Journal entries to the general ledger

Post the general journal entries to the general ledger in the Excel spreadsheet.

  How would the yield curve facing an aaa rated company

At any given time, how would the yield curve facing an AAA-rated company compare with the yield curve for U. S. Treasury securities? At any given time, how would the yield curve facing a BB-rated company compare with the yield curve for U. S. Treasur..

  What balance sheet accounts must have changed

Over the past year, M. D. Ryngaert & Co. had an increase in its current ratio and a decline in its total assets turnover ratio. However, the company's sales, cash and equivalents, DSO, and fixed assets turnover ratio remained constant. What balance s..

  What is the retention ratio

Jones Hardware had common stock of $9,500 and retained earnings of $3,800 at the beginning of the year. At the end of the year, the common stock balance is $9,600 and the retained earnings account balance is $4,200.

  How the process of interest rate determination affected

Select at least two additional economic indicators such as inflation, unemployment rates, retail sales and the yield curve to make and explain your prediction.

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