Reference no: EM13868550
Pro forma balance sheet Peabody & Peabody has 2015 sales of $10 million. It wishes to analyze expected performance and financing needs for 2017, which is 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.
Peabody & Peabody has 2015 sales of $10 million. It wishes to analyze expected performance and financing needs for 2017, which is 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 2016, and equipment costing $850,000 will be purchased in 2017. Total depreciation in 2016 is forecast as $290,000, and in 2017 $390,000 of depreciation will be taken.
(5) Accruals are expected to rise to $500,000 by the end of 2017.
(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 2016 and $12 million in 2017.
(10) The December 31, 2015, balance sheet follows.
Assets Liabilities and stockholder’s 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 stockholder’s equity $7,600
Peabody & Peabody Balance Sheet December 31, 2015 ($000)
a. Prepare a pro forma balance sheet dated December 31, 2017.
b. Discuss the financing changes suggested by the statement prepared in part a.
|
Suppose the demand for eggs
: Suppose the demand for eggs is: Q=8,000-3,000P and the supply of eggs is: Q= -500+2,000P, where quantity is measured in millions (of eggs). Find the market-clearing price and quantity for eggs. (Enter price responses rounded to two decimal places.) T..
|
|
The equation for the original demand curve
: The equation for the original demand curve is Q=50-6.25P. Find the new demand equation when demand increases by 20% (Round to one decimal place). Q=___ - ___P. Find the new equilibrium price and quantity after demand increases 20%. P= ___ Q=___ (Roun..
|
|
Finding operating and free cash flows
: Finding operating and free cash flows Consider the following balance sheets and selected data from the income statement of Keith Corporation. Calculate the firm’s operating cash flow (OCF) for the year ended December 31, 2015, using Equation 4.3. Cal..
|
|
Evaluate the effectiveness and usability of tqm
: Examine and evaluate the effectiveness and usability of Total Quality Management (TQM) in ambulatory care settings
|
|
Prepare a pro forma balance sheet
: Pro forma balance sheet Peabody & Peabody has 2015 sales of $10 million. It wishes to analyze expected performance and financing needs for 2017, which is 2 years ahead. The percents of sales for items that vary directly with sales are as follows: Mar..
|
|
What is the three-year forward price
: The spot price of an investment asset is $30 and the risk-free rate for all maturities is 10% with continuous compounding. The asset provides an income of $2 at the end of the first year and at the end of the second year. What is the three-year forwa..
|
|
What were the firms operating cash flow
: The December 31, 2013 balance sheet of Schism inc. showed long-term debt of $1,395,000 $139,000 in the common stock account and $2,640,000 in the additional paid-in surplus account. The firm’s net capital spending for 2014 was $950,000 and the firm r..
|
|
What is net income and ROA
: Diamond Eyes, Inc., has sales of $21 million, total assets of $18.3 million, and total debt of $9.5 million. Assume the profit margin is 9 percent. What is net income? (Enter your answer in dollars not in millions, i.e. 1,234,567.) Net income $ What ..
|
|
Futures price per unit above which there will be margin call
: The six month and one-year rates are 3% and 4% per annum with semi-annual compounding. Is 3.90% or 3.95% or 3.99% closest to the one-year par yield expressed with semi-annual compounding? A company enters into a short futures contract to sell 50,000 ..
|