$(1)$ The percents of sales for items that vary directly with sales are as follows: Accounts receivable; $12\mathrm{.}2\%,$ Inventory; $17\mathrm{.}7\%$; Accounts payable, $13\mathrm{.}9\%$; Net profit margin, $3\mathrm{.}4\%.$

$(2)$ Marketable securities and other current liabilities will remain unchanged

$(3)$ Peabody desires a minimum cash balance of $$481,000.$

$(5)$ Accruals will rise to $$495,000$ by the end of $2024.$

$(6)$ There will be no sale or retirement of long$-$term debt.

$(7)$ No sale or repurchase of common stock is expected.

$(8)$ The dividend payout of $50\%$ of net profits will continue.

$(9)$ The sales forecast predicts $$11\mathrm{.}6$ million in $2023$ and $$11\mathrm{.}2$ million in $2024.$

$(10)$ The December $31,2022,$ balance sheet is here $.$

Data table

a$.$ Prepare a pro forma balance sheet dated December $31,2024.$

b$.$ Discuss the financing changes suggested by the statement prepared in part $($a$).$

a$.$ Prepare a pro forma balance sheet dated December $31,2024.$

Complete the assets part of the pro forma balance sheet for Peabody & Peabody for December $31,2$

$\backslash$table$[[($Click on the icon here $$ in order to copy the contents of the data table below into a spreadsheet.$)],[$Assets$,,$Liabilities and Stockholders' Equity,$],[$Cash$,$$$397,000,$Accounts payable,$$1,400,000$