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

  Compute the cash flows to investors from operating activity

Assume that the firm has a tax rate of 35 percent. Compute the cash flows to investors from operating activity. (Round answer to 2 decimal places, e.g. 15.25.)

  An average collection period

Mr. Husker's Tuxedos Corp. ended the year 2015 with an average collection period of 34 days. The firm's credit sales for 2015 were $56.3 million.

  The manager of sensible essentials conducted an excellent

the manager of sensible essentials conducted an excellent seminar explaining debt and equity financing and how firms

  Discuss the advantages and disadvantages of maintaining

discuss the advantages and disadvantages of maintaining multiple manufacturing sites as a hedge against exchange rate

  Payback period using payback method for capital budgeting

If the discounted rate is 10% and we have cash flows of -20 today, 15 in year 1, and 10 in year 2, then the payback period using the payback method for capital budgeting is?

  What is the yield on 2-year treasury securities

The real risk-free rate is 3.25%. Inflation is expected to be 1.75% this year and 5% during the next 2 years. Assume that the maturity risk premium is zero.

  Optimal cpa business structure

Which business structure would you select if you were to set up your own CPA practice: a partnership, proprietorship, or corporation? Why? Explain what factors affect your decision.

  What conditions are necessary for an item to qualify as a

what conditions are necessary for an item to qualify as a prior period

  What is a fair price for this stock

If you want to inest in a stock that pays $3.50 annual cash dividens for the next six yrs. At the end of the six years, you will sell the stock for $22.50. If you want to earn 12.5% on this investment, what is a fair price for this stock if you bu..

  What does the word stipulation mean

What does the word stipulation mean

  What is the monthly payment for this loan

After researching banks to find the best interest rate, you find that banks for small businesses offer the best interest rate of 9% interest that compounds monthly for 7 years.

  An investment project requires a net investment of 100000

an investment project requires a net investment of 100000 and is expected to generate annual net cash inflows of 25000

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