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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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