Question

Hill Propane Distributors wants to construct a pro forma balance sheet for 2013. Build the statement using the following data and assumptions:
1. Projected sales for 2013 are $35 million.
2. Hill’s gross profit margin is 35%.
3. Operating expenses average 10% of sales.
4. Depreciation expense last year was $5 million.
5. Hill faces a tax rate of 35%.
6. Hill distributes 20% of its net income to shareholders as a dividend.
7. Hill wants to maintain a minimum cash balance of $3 million.
8. Accounts receivable equal 8.5% of sales.
9. Inventory averages 10% of cost of goods sold.
10. Last year’s balance sheet lists net fixed assets of $30 million. All these assets are depreciated on a straight-line basis, and none of them will be fully depreciated for at least three years.
11. Hill plans to invest an additional $1 million in fixed assets that it will depreciate over a five-year life on a straight-line basis.
12. In 2012, Hill reported common stock and retained earnings of $20 million.
13. Accounts payable averages 9% of sales.
Will Hill Propane’s cash balance at the end of 2013exceed its minimum requirement of $3 million?