Problem 15-5 Overview of the Planning Process Hill Propane Distributors wants to construct a pro forma balance sheet for 2013. Build the statement using the following data and assumptions. Round your answers to the nearest dollar. Projected sales for 2013 are $35 million. Hill's gross profit margin is 35%. Operating expenses average 11% of sales. Depreciation expense last year was $5 million. Hill faces a tax rate of 30%. Hill distributes 25% of its net income to shareholders as a dividend. Hill wants to maintain a minimum cash balance of $3 million. Accounts receivable equal 9.5% of sales. Inventory averages 10% of the cost of goods sold. Last year's balance sheet lists net fixed assets of $30 million. All of these assets are depreciated on a straight-line basis, and none of them will be fully depreciated for at least three years. Hill plans to invest an additional $1 million in fixed assets that it will depreciate over a 5-year life on a straight-line basis. In 2012, Hill reported common stock and retained earnings of $20 million. Accounts payable average 10% of sales.