Cranfield Enterprises has just completed its annual planning and budgeting process and needs to raise $20 million to finance its capital expenditures for the coming year. The firm earned $18 million last year and will pay out half this amount in dividends. If the firms CFO wants to finance new investments using no more than 40 percent debt financing, how much common stock will the firm have to issue to raise the needed $20 million?

Can this be done without excel?