Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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

Discussionpart 1 please respond the following question no

Discussion Part 1 please respond the following question no less then 350 words (original work, no plagiarism, 1 reference "free cash-flow valuations" please respond to the following: • Create an argument that use of the ...

Exercise 1for roche inc variable manufacturing overhead

Exercise 1 For Roche Inc., variable manufacturing overhead costs are expected to be $20,780 in the first quarter of 2017, with $4,150 increments in each of the remaining three quarters. Fixed overhead costs are estimated ...

Assignment question 1 -impulse pty ltd impulse is an

Assignment Question 1 - Impulse Pty Ltd (Impulse) is an entertainment system manufacturer that was established in 2005. Your audit firm King & Queen have been the auditor of Impulse since its formation. The audit report ...

Cost accounting systemsconsider the places of employment of

Cost Accounting Systems Consider the places of employment of the team members or businesses with which the team is familiar and the industries in which they operate. Create a 12-slide presentation, including detailed spe ...

Question 1the collection on an account within the 110 n30

Question 1 The collection on an account within the 1/10 n/30 discount period was recorded using a 10% discount rather than a 1% discount in both the controlling and subsidiary accounts. This error will cause the A. the n ...

Imagine you are the responsible accountant for one of our

Imagine you are the responsible accountant for one of our companies. Apart from local gaap or local accounting rules but with regard to HB II (Group financial statement) and with the help of the HB II accounting manual o ...

Learning outcomesupon successful completion of this subject

LEARNING OUTCOMES Upon successful completion of this subject, you should be able to : 1 Identify and apply relevant accounting and information systems skills to the development, operation, maintenance and control of acco ...

Problem 1bart exchanges some real estate basis of 80000 and

Problem 1 Bart exchanges some real estate (basis of $800,00 and fair market value of $1 million) for other real estate owned by Roland (basis of $1.2 million and fair market value of $900,00) and $100,000 in cash. The re ...

1 weighted average cost method with perpetual inventory

1. Weighted average cost method with perpetual inventory (Page 349 of Accounting 25e Warren-Reeve-Duchac) The beginning inventory for RTE Office Supplies and data on purchases and sales for a three-month period are shown ...

Reflectionbulldescribe and explain what you believe are the

Reflection • Describe and explain what you believe are the top three most important corporate taxation concepts you learned in this course. (Some of the topics, Enacting New Taxes, Calculating Tax Cost, Cash Method Versu ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro