Please show work so I can understand.

Problem $23-07$

RRM$,$ Inc. has the following balance sheet:

RRM$,$ Incorporated Balance Sheet as of $12/31/$X$0$

Assets Liabilities and Equity

Cash $ $2,900$ Accruals $ $4,800$

Marketable securities $2,300$ Accounts payable $16,050$

Accounts receivable $16,730$ Notes payable $5,000$

Inventory $19,940$

Long$-$term debt $23,000$

Common stock $18,000$

Plant and equipment $40,000$ Retained earnings $15,020$

$ $81,870$ $ $81,870$

Sales are currently $$100,000,$ but management expects sales to rise to $$130,000.$ The net profit margin is expected to be $11$ percent, and the firm distributes $60$ percent of its earnings as dividends.

Management is concerned about the firm's need for external funding to cover the expansion in assets required by the expansion in sales. To achieve sales of $$130,000,$ management will have to expand plant by $$15,000$ and expects to increase its holdings of cash by $$1,500.$ However, the holding of marketable securities may be reduced to zero.

According to the percent of sales and the additional information, will the firm need external financing, and, if so$,$ how much? Round your answer to the nearest dollar. Enter the answer as a positive value.

The firm will need or will have external $($choose one$)$ funds of $

Construct a pro forma balance sheet indicating the forecasted new entries for sales of $$130,000.$ If the firm has excess funds, they should be invested in marketable securities$.$ If the firm needs funds, these should be covered by issuing new long$-$term debt. If your answer is zero, enter $"0".$ Round your answers to the nearest dollar.

RRM$,$ Incorporated Pro Forma Balance Sheet as of $12/31/$X$1$

Assets

Cash $

Marketable securites

Accounts reciveable

Inventory

Plant and Equipment

Total $

Liabilites and Equity

Accruals $

Accounts payable

Accounts receivable

Notes Payable

Long$-$term debt

Common stock

Retained earnings

Total $