Ask Question, Ask an Expert


Ask Accounting Basics Expert

Q1) Pro Forma balance sheet--Peabody and Peabody has 2006 sales of $10million. It wants to analyze expected performance and financing needs for 2008-2 years ahead. Provided following information, respond to parts A and B.


(1) Percents of sales for items which differ directly with sales are as follows:

a. Accounts receivable, 12%
b. Inventory, 18%
c. Accounts payable, 14%
d. Net profit margin, 3%

(2) Marketable securities and other current liabilities are expected to remain unchanged.

(3) Minimum cash balance of $480,000 is desired.

(4) New machine costing $650,000 will be required in 2007, and equipment costing $850,000 will be bought in 2008. Total depreciation in 2007 is forecast as $290,000, and in 2008 $390,000 of deprecation will be taken.

(5) Accruals are expected to rise to $500,000 by end of 2008.

(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 2007 and $12 million in 2008.

(10) December 31, 2008 balance sheet is listed below

Peabody & Peabody
Balance Sheet
31-Dec-06 $ in (000)
Assets   Liabilities & Stockholders' Equity  
Cash $400 Accounts payable $1,400
Marketable securities     $200 Accruals 400
Accounts receivable      1200 Other Current Liabilities                     80
Inventories 1800 Total Current Liabilities                     $1,880
Total current Assets      $3,600 Long term Debt $2,000
Net fixed assets           4000 Common equity $3,720
Total assets $7,600 Total Liabilities & stockholders' equity  $7,600

A. Create pro forma balance sheet dated December 31, 2008

B. Describe the financing changes suggested by statement prepared in part A

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M920915

Have any Question? 

Related Questions in Accounting Basics

Accounting questionrecent news stories have clearly

Accounting Question: Recent news stories have clearly established that there are increasing instances of cyber-crime that are plaguing major corporations and financial institutions. These crimes have taken many forms, su ...

Q1 partners a b and c are contemplating using the following

Q1. Partners A, B and C are contemplating using the following profit distribution plan: Salary is to be given to A in the amount of P60,000, with the remainder in an equal rates to all partners. A is guaranteed a minimum ...

Obtain the 2012 10-k annual report for overland storage inc

Obtain the 2012 10-K Annual Report for Overland Storage, Inc. (OVRL). Refer to Note 1 on page F-7. Based on management's discussion in the note, what type of audit report did Overland's audit firm likely issue? In this s ...

Question 1 queenslander ltd operates a cafeacute and gift

Question 1: Queenslander Ltd operates a café and gift shop at Montville in the Sunshine Coast hinterland. You are the accountant for the company and the following items relate to the year ended 30 June 2016: (a) Queensla ...

In the citation schusters express inc 66 tc 588 1976 affd

In the citation Schuster's Express, Inc., 66 T.C. 588 (1976), aff'd 562 F.2d 39 (CA-2, 1977), nonacq., to what do the 66, 39, and nonacq. refer? • Is there an automatic right to appeal to the U.S. Supreme Court? If so, w ...

Topic ethics in auditing practiceyour assignment should

Topic: "Ethics in auditing practice" Your assignment should answer the following questions: 1. Provide a brief overview of the nature of the auditing/ethical issue/s involved with Ethics in auditing practice. 2. How does ...

Assignment detailsas at the 1stmay katy perry establishes a

Assignment Details: As at the 1stMay, Katy Perry establishes a new business Katie's Bridal Services as a sole trader. The business will hire out bridal gowns and other accessories as well as provide professional services ...

Your text notes that all of the business processes we have

Your text notes that all of the business processes we have studied feed data to the general ledger system. For each of the 5 business processes listed below: • Indicate which of the business events listed are activities ...

Accounting paper-research a current article regarding

Accounting Paper- Research a current article regarding accounting in government. and write a summary of the article in 350 to 700 words applying concepts you've learned in this course to assessing the content of the arti ...

Assignment questionbio-sustainable feeds bsf ltd an

ASSIGNMENT QUESTION Bio-sustainable Feeds (BSF) Ltd., an Australian bio-research firm listed on the Australian Stock Exchange (ASX), has engaged research on sustainable aqua-culture feeds for two decades. Its research on ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate