Show me how to construct a pro forma balance sheet

The Landis Corporation had 2008 sales of $100 million. The balance sheet items that
Vary directly with sales and the profit margin are as follows:
Percent
Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5%
Accounts receivable. . . . . . . . . . . . . . . . . . . . . . 15
Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Net fixed assets . . . . . . . . . . . . . . . . . . . . . . . . . 40
Accounts payable . . . . . . . . . . . . . . . . . . . . . . . 15
Accruals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Profit margin after taxes . . . . . . . . . . . . . . . . . . 6%
The dividend payout rate is 50 percent of earnings, and the balance in retained earnings
At the end of 2008 was $33 million. Common stock and the companys long-term
Bonds are constant at $10 million and $5 million, respectively. Notes payable are currently
$12 million.
A. How much additional external capital will be required for next year if sales
Increase 15 percent? (Assume that the company is already operating at full
Capacity.)
B. What will happen to external fund requirements if Landis Corporation reduces
The payout ratio, grows at a slower rate, or suffers a decline in its profit margin?
Discuss each of these separately.
C. Prepare a pro forma balance sheet for 2009 assuming that any external funds
Being acquired will be in the form of notes payable. Disregard the information in
Part b in answering this question (that is, use the original information and part a
In constructing your pro forma balance sheet).