Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pro forma balance sheet-Basic Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2020. The firm expects 2020 sales to total

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Pro forma balance sheet-Basic Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2020. The firm expects 2020 sales to total $3,000,000. The following information has been gathered. (1) A minimum cash balance of $49,800 is desired. (2) Marketable securities are expected to remain unchanged. (3) Accounts receivable represent 9.9% of sales. (4) Inventories represent 11.6% of sales. (5) A new machine costing $90,400 will be acquired during 2020. Total depreciation for the year will be $31,700. (6) Accounts payable represent 14.1% of sales. (7) Accruals, other current liabilities, long-term debt, and common stock are expected to remain unchanged. (8) The firm's net profit margin is 4.2%, and it expects to pay out $69,500 in cash dividends during 2020. (9) The December 31, 2019, balance sheet follows: a. Use the judgmental approach to prepare a pro forma balance sheet dated December 31, 2020, for Leonard Industries. b. How much, if any, additional financing will Leonard Industries require in 2020? Discuss. c. Could Leonard Industries adjust its planned 2020 dividend to avoid the situation described in part b? Explain how. - i Data Table Mar.) (Click on the icon here 2 in order to copy the contents of the data table below into a spreadsheet.) Leonard Industries Balance Sheet December 31, 2019 Assets Liabilities and Stockholders' Equity Cash $44,800 Accounts payable Marketable securities 14,900 Accruals Accounts receivable 254,700 Other current liabilities Inventories 340,300 Total current liabilities Total current assets $654,700 Long-term debt Net fixed assets 600,400 Common stock Retained earnings Total assets $1,255,100 Total liabilities and stockholders' equity $394,500 60,100 30,400 $485,000 349,900 200,000 220,200 $1,255, 100 Print Done a. Use the judgmental approach to prepare a pro forma balance sheet dated December 31, 2020, for Leonard Industries. Complete the assets part of the pro forma balance sheet for Leonard Industries for December 31, 2020 below: (Round to the nearest dollar.) Pro Forma Balance Sheet Leonard Industries December 31, 2020 Assets Current assets HA Cash Marketable securities Accounts receivable Inventories Total current assets Net fixed assets Total assets $ Complete the liabilities and stockholders' equity part of the pro forma balance sheet for Leonard Industries for December 31, 2020 below: (Round to the nearest dollar.) Pro Forma Balance Sheet Leonard Industries December 31, 2020 Liabilities and stockholders' equity Current liabilities $ Accounts payable Accruals Other current liabilities Total current liabilities $ Long-term debt Total liabilities $ Common stock $ Retained earnings Total stockholders' equity External funds required Total liabilities and stockholders' equity $ b. How much, if any, additional financing will Leonard Industries require in 2020? Discuss. (Select all the answers that apply.) A. Based on the forecast and desired level of certain accounts, the financial manager should arrange for credit of $54,900. B. Based on the forecast and desired level of certain accounts, the financial manager should arrange for credit of $59,900. C. Leonard Industries' retained earnings are enough to cover all of the company's desired level of certain accounts. D. If financing cannot be obtained, one or more of the constraints must be changed. c. Could Leonard Industries adjust its planned 20202016 dividend to avoid the situation described in part b? Explain how. (Select all the answers that apply.) A. If Leonard Industries reduced its 2020 dividend to $15,600 or less, the firm would not need any additional financing B. Leonard Industries' retained earnings are enough to cover all of the company's desired level of certain accounts including dividends. OC. By reducing the dividend, more cash is retained by the firm to cover the growth in other asset accounts. D. If Leonard Industries reduced its 2020 dividend to $20,600 or less, the firm would not need any additional financing

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions