Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I couldn't post part b for some reason. Can you please search up the question there should be similar problems for part b's blanks? Thank
I couldn't post part b for some reason. Can you please search up the question there should be similar problems for part b's blanks? Thank you!
Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.3 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 tat vary directly with sales are as follows: Accounts receivable: 12.1% Inventory: 17.8%; Accounts payable, 13.5%; Net profit margin 3.4%. (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of $479,000 is desired. (4) A new machine costing $652,000 will be acquired in 2020, and equipment costing $854,000 will be purchased in 2021. Total depreciation in 2020 is forecast as $292,000, and in 2021 $391,000 of depreciation will be taken. (5) Accruals are expected to rise to $499,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 areexpected to be $11.5 million in 2020 and $11.5 millon in 2021 (10) The December 31, 2019, balance sheet is here BEB (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Leonard Industries Balance Sheet December 31, 2019 Assets Cash Marketable securities Accounts receivable Inventories Liabilities and Stockholders' Equity $403,000 Accounts payable $1,403,000 397,000 80,500 $1,880,500 2,001,500 3,720,000 198,000 Accruals 1,196,000 Other current liabilities 1,802,000 Total current liabilities Total current assets $3,599,000 Long-term debt Net fixed assets 4,003,000 Common stock Total liabilities and Total assets $7,602,000 stockholders' equity $7,602,000 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 December 31, 2021 Assets Current assets Cash Marketable securities Accounts receivable Inventories Total current assets Net fixed assets Total assets
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started