Hill Propane Distributors wants to construct a pro forma balance sheet for 2013. Build the statement using
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?
Common StockCommon stock is an equity component that represents the worth of stock owned by the shareholders of the company. The common stock represents the par value of the shares outstanding at a balance sheet date. Public companies can trade their stocks on... Accounts Payable
Accounts payable (AP) are bills to be paid as part of the normal course of business.This is a standard accounting term, one of the most common liabilities, which normally appears in the balance sheet listing of liabilities. Businesses receive... Accounts Receivable
Accounts receivables are debts owed to your company, usually from sales on credit. Accounts receivable is business asset, the sum of the money owed to you by customers who haven’t paid.The standard procedure in business-to-business sales is that... Balance Sheet
Balance sheet is a statement of the financial position of a business that list all the assets, liabilities, and owner’s equity and shareholder’s equity at a particular point of time. A balance sheet is also called as a “statement of financial...
Step by Step Answer:
Income Statement 2013 Sales 35000000 Cost of goods sold 22750000 Gross profit 12250000 Operating exp...View the full answer
Introduction to Corporate Finance What Companies Do
ISBN: 978-1111222284
3rd edition
Authors: John Graham, Scott Smart
