Problem $15-5$ Spreadsheet Problem: AFN with Excess Capacity $($LG$15-4)$

Suppose that Psy Ops Industries currently has the balance sheet shown below, and that sales for the year just ended were $$5\mathrm{.}4$

million. The firm also has a profit margin of $20$ percent, a retention ratio of $25$ percent, and expects sales of $$8\mathrm{.}4$ million next year.

If fixed assets have enough capacity to cover the increase in sales and all other assets and current liabilities are expected to increase

with sales, what amount of additional funds will Psy Ops need from external sources to fund the expected growth?

Note: Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign.