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 minimum level of capital according to basel ii

an internationally active bank has a 500 million portfolio of investments and bank credits. 100 million are claims on

  Identify and define up to three concepts associated with

identify and define up to three concepts associated with making capital investment decisions such as cash flows sunk

  Set up a balance sheet

From the accompanying particulars identifying with AB Co. set up a Balance Sheet as on 31.12.2009:

  What is the rate of return on an investment

What is the rate of return on an investment of $10,606 if the company will receive $2,000 each year for the next 10 years?

  What was its charge for depreciation and amortization

Talbot enterprises recently reported an EBITDA of $8 Million and net income of $2.4 million. It had $2.0 million of interest expense, and its corporate tax rate was 40%. What was its charge for depreciation and amortization?

  Earnings per share and return on equity

What is the expected earnings per share (EPS) and return on equity (ROE) at next year's expected level of EBIT if the firm remains 100% equity financed?

  Irr of a perpetuity project

We saw in class that the IRR of a perpetuity project is exactly equal to the inverse of the payback period. I also noted that for non-perpetuity projects the relationship IRR = 1/PB is only an approximation, and that this approximation improves as..

  How much of first annual payment will be principal reduction

You take out a $800,000 amortized loan for your new beach house. You will make equal annual payments at the end of each of the next 10 years. The interest rate is 8%. How much of the first annual payment will be principal reduction?

  Periodic review system

You work for a retailer that uses a monthly periodic system to maintain the inventory of water heaters it sells. Below is the sales data for the last 5 months.

  Reinegar corporations has just issued a 25 year par bond

problem 1bond abond bunitmaturity47yearscoupon56annualprice101.79102.85-you know for certain that the 3 year rate in 4

  Discuss the importance of quality in a firm

Discuss the importance of quality in a firm's financial statements and how you would go about evaluating the quality of a firm's financial statement.

  Do the strategic benefits of stimulus generalization

1. do the strategic benefits of stimulus generalization outweigh its possible disadvantages in strategic marketing?

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