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

Grana enterprise incgrana enterprise inc gei is a

Grana Enterprise Inc. Grana Enterprise Inc. (GEI) is a manufacturing company with operations in Italy and Serbia. GEI in Italy: In addition to other assets, GEI owns and operates a commercial building in Italy that is ca ...

Examine the following book-value balance sheet for

Examine the following book-value balance sheet for University Products, Inc. What is the capital structure of the firm on the basis of market values? The preferred stock currently sells for $15 per share and the common s ...

Westerville company reported the following results from

Westerville Company reported the following results from last year % 2013 operations: Sales $ 1,000,000 Variable expenses 300,000 -------------------------------------- Contribution margin 700,000 Fixed expenses 500,000 - ...

Assignmentair france-klm af a franco-dutch company prepares

Assignment Air France-KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Reporting Standards. AF's financial statements and disclosure notes for the year ended Decemb ...

Additional information1 the company during the year paid

Additional Information 1. The Company during the year paid AED 200,000 for security deposit and bank charges of AED 40. 2. The Warehouse reported inventory stock count of AED 286,500. 3. XYZ Company's confirmation ,( Cus ...

Accountingimagine that you are a consultant working on a

Accounting Imagine that you are a consultant working on a special project to help a company determine techniques that it can use in order to calculate the fair value of investments. From the e-activity, prepare a report ...

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 ...

Accountingbullimagine you are a consultant hired to convert

Accounting • Imagine you are a consultant hired to convert a manual accounting system to an automated system. • Suggest the key advantages and disadvantages of automating a manual accounting system. • Identify the most i ...

Problem 1 mat Problem 1 Mat. Date Rate(%) 1/15/2017 0.5 4/15/2017 0.6 7/15/2017 0.75

Problem 1 Mat. Date Rate(%) 1/15/2017 0.5 4/15/2017 0.6 7/15/2017 0.75 10/15/2017 1.0 1/15/2018 1.25 4/15/2018 1.5 7/15/2018 1.75 10/15/2018 2.0 1/15/2019 2.1 4/15/2019 2.2 7/15/2019 2.3 10/15/2019 2.4 Table 1: Continuou ...

Review the short list of account balances from data below

Review the short list of account balances from data below. From the account balances, generate an income statement, a statement of owner's equity and a balance sheet for a hypothetical small business. The adjusted trial ...

  • 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