Pro Forma Financial Statements

Any required new external funding is taken on at the beginning of the next year (2014) in the problem. Assume that there are 120,000 shares of common stock outstanding. Next year, the firm will pay dividends as specified in your particular variant. This new dividend per share must be paid on all shares outstanding next year. In this case we are not using a constant payout ratio, but rather are describing the dividend policy on a dividend per share basis. This means the payout ratio may change in the forecasted year.  

Rework problem 12-9 with the assumption that the firm’s sales will grow at a rate of 16% during the next year. Any new external funding required would be raised 60% from the sale of new common stock and 40% from taking on additional short-term debt (Line of Credit). The sale of any new shares would net the company $30 per share. All existing shares (existing and newly issued) will receive a dividend per share of $1.20. All existing debt will carry an interest rate of 6.5% in the forecast. Any new debt (if needed) would have an interest rate of 5.5%. In the event that the firm has excess funding under this plan, the excess funding should be used to repurchase shares of stock at $30. Due to an updated inventory management system, Inventory is expected to increase at a rate only half that of the increase in sales.  

THE ANSWER TO PROBLEM 12-9 IS ATTACHED BUT THE EXCEL SPREADSHEET WILL NEED TO BE MODIFIED TO THE ASSUMPTIONS GIVEN ABOVE.