USING EXCEL,

Axle Supply Co. expects sales next year to be $310,000. Inventory and accounts receivable will increase by $65,000 to accommodate this sales level. The company has a steady profit margin of 15 percent, with a 10 percent dividend payout. How much external funding will the firm have to seek? Assume there is no increase in liabilities other than that which will occur with the external financing. External funds needed $