Reference no: EM131110862
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.
.png)
a. Prepare a pro forma balance sheet dated December 31, 2014.
b. Discuss the financing changes suggested by the statement prepared in parta.
|
Today collaborative-team-oriented workplaces
: Studies have suggested that extroverts contribute less to teams and are poor listeners, yet other studies suggest that they are more likely to earn six-figure incomes, even in today's collaborative, team-oriented workplaces. Discuss why you think ..
|
|
Define and differentiate among the three basic patterns
: Define and differentiate among the three basic patterns of cash flow:(1) A single amount, (2) An annuity, and (3) A mixed stream.
|
|
What is the difference between future value and present val
: What is the difference between future value and present value? Which approach is generally preferred by financial managers? Why?
|
|
Press release indicating that sales will not be as high
: The SEC is trying to get companies to notify the investment community more quickly when a “material change” will affect their forthcoming financial results. In what sense might a financial manager be seen as “more ethical” if he or she follows this d..
|
|
Discuss the financing changes suggested by the statement
: Prepare a pro forma balance sheet dated December 31, 2014. Discuss the financing changes suggested by the statement prepared in parta.
|
|
Prepare a pro forma balance sheet for december
: Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2013. The firm expects 2013 sales to total $3,000,000. The following information has been gathered.
|
|
Explain how the percent of sales method could result
: Use the percent-of-sales method, the income statement for December 31, 2012, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year. Explain how the percent-of-sales method ..
|
|
Compare and contrast the statements developed
: Use the percent-of-sales method to prepare a pro forma income statement for the year ended December 31, 2013. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2013. Compare and contrast the stat..
|
|
Discuss how knowledge of the timing and amounts involved
: Prepare a scenario analysis of Trotter's cash budget using -$20,000 as the beginning cash balance for October and a minimum required cash balance of $18,000. Use the analysis prepared in part a to predict Trotter's financing needs and investment oppo..
|