Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help with A and B Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.4 million. It wishes to analyze expected

Can someone help with A and B

image text in transcribed
Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.4 million. It wishes to analyze expected performance and financing needs for 2021-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 2%, Inventory; 17 7%, Accounts payable, 13.5%, Net profit margin, 2.7%. (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 $655,000 will be acquired in 2020, and equipment costing $854,000 will be purchased in 2021 Total depreciation in 2020 is forecast as $287,000, and in 2021 $391,000 of depreciation will be taken. (5) Accruals are expected to rise to $504,000 by the end of 2021. (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.2 million in 2020 and $11.3 million in 2021 (10) The December 31, 2019, balance sheet is here a. Prepare a pro forma balance sheet dated December 31, 2021. b. Discuss the financing changes suggested by the statement prepared in part (a). a. Prepare a pro forma balance sheet dated December 31, 2021 Complete the assets part of the pro forma balance sheet for Peabody & Peabody for December 31, 2021 below: (Round to the nearest dollar) Pro Forma Balance Sheet Peabody & Peabody . X Data table December 31, 2021 Assets Current assets (Click on the icon located on the top-right comer of the data table below in order to copy its contents into a spreadsheet.) Cash Leonard Industries Balance Sheet December 31, 2019 Marketable securities Assets Liabilities and Stockholders Equity Cash $396,000 Accounts payable $1,396,000 Accounts receivable Marketable securities 203,000 Accruals 395,000 Inventories Accounts receivable 1,196,000 Other current liabilities 79.900 Inventories 1,795,000 Total current liabilities $1,870,900 Total current assets Total current assets $3,590,000 Long-term debt 2,001.100 Net fixed assets Net fixed assets 4.003.000 Common stock 3,721.000 Total liabilities and Total assets Total assets $7.593.000 stockholders equity $7.593.000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting An IFRS Standards Approach

Authors: Pearl Tan, Chu Yeong Lim, Ee Wen Kuah

4th Edition

9789814821278, 9814821276

More Books

Students also viewed these Accounting questions

Question

Annoyance about a statement that has been made by somebody

Answered: 1 week ago