Question: a. Calculate White & Pinkman's additional funds needed, or excess financing. If additional funds are needed, add them to long-term debt to bring the balance

a. Calculate White & Pinkman's additional funds needed, or excess financing. If additional funds are needed, add them to long-term debt to bring the balance sheet into balance. If excess financing is available increase common stock dividends paid (and, therefore, decrease 2022 retained earnings) until the balance sheet is in balance
b. Calculate current ratio for the end of 2021 and 2022.
c. Calculate total asset turnover and inventory turnover ratios for 2022.
d. Calculate total debt to total assets ratio for 2021 and 2022. Assume there has been no additional long-term issued in 2022.
e. Calculate net profit margin, return on assets, and return on equity ratios for 2021 and 2022
f. Comment on liquidity, asset productivity, debt management, and probability based on the results of ratio analysis in b through e
g. What recommendations would you provide to management based on your forecast and analysis.
7. Develop a pro forma income statement and balance sheet for the White & Pinkman Corporation. The company's 2021 financial statements are shown below. Base your forecast on the financial statements and the following assumptions: Sales growth is predicted to be 20 percent in 2022. Cost of goods sold, selling and administrative expense, all current assets, accounts payable, and accrued expenses will remain the same percentage of sales as in 2021. Depreciation expense, interest expense, gross plant and equipment, notes payable, long-term debt, and equity accounts other than retained earnings in 2022 will be the same as in 2021. The company's tax rate in 2022 will be 40 percent. The same dollar amount of dividends will be paid to common stockholders in 2022 as in 2021. Bad debt allowance in 2022 will be the same percentage of accounts receivable as it was in 2021. White & Pinkman Corporation Balance Sheet Dec. 31, 2021 Assets: Current Assets: Cash Marketable Securities Accounts Receivable (Net) Inventory Prepaid Expenses Total Current Assets Fixed Assets: Plant and Equipment (Gross) Less Accumulated Depreciation Plant and Equipment (Net) Total Assets $ 9,000,000 8,000,000 1,000,000 20,000,000 1,000,000 $39,000,000 11,000,000 20,000,000 (9,000,0000) 11,000,000 $50,000,000 Liabilities and Equity: Current Liabilities: Accounts Payable Notes Payable Accrued Expenses Total Current Liabilities Bonds Payable (5%, due 2035) Total Liabilities Common Stock (1 mil shares, $1 par) Capital in Excess of Par Retained Earnings Total Equity Total Liabilities and Equity $12,000,000 5,000,000 3,000,000 $20,000,000 20,000,000 $40,000,000 1,000,000 4,000,000 5,000,000 10,000,000 $50,000,000 White & Pinkman Corporation Income Statement for 2021 Sales Cost of Goods Sold Gross Profit Selling and Administrative Expenses Depreciation Expense Earnings before Interest and Taxes (EBIT) Interest Expense Earnings before Taxes (EBT) Taxes (40%) Net Income (NI) $ 10,000,000 4,000,000 6,000,000 800.000 2,000,000 3.200.000 1,350,000 1,850,000 740,000 1,110,000 Earnings per Share (EPS) (1 million shares) $ 1.11 Common Stock Dividends Paid 400,000 Addition to Retained Earnings 710,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
