Build the statement using the data and assumptions

Assignment Help Financial Management
Reference no: EM131316949

Hill Propane Distributors wants to construct a pro forma balance sheet for 2010. Build the statement using the following data and assumptions:

1. Projected sales for 2010 are $35 million.

2. Hill's gross profit margin is 35 percent.

3. Operating expenses average 10 percent of sales.

4. Depreciation expense last year was $5 million.

5. Hill faces a tax rate of 35 percent.

6. Hill distributes 20 percent 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 percent of sales.

9. Inventory averages 10 percent 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 2009, Hill reported common stock and retained earnings of $20 million.

13. Accounts payable averages 9 percent of sales. Will Hill Propane's cash balance at the end of 2010 exceed its minimum requirement of $3 million?

Reference no: EM131316949

Questions Cloud

Construct a pro forma income statement for 2010 : You learn that 25 percent of the cost of goods sold and operating expense figures for 2009 are fixed costs that will not change in 2010. Reconstruct the pro forma income statement.
What does universal health care mean : What does "universal health care" mean? Which countries in the film have universal health care? How do the British pay for their National Health Service? What, according to the film, might Americans not like about the British system
What specific argument does machiavelli justify his position : Machiavelli has been described as the first political thinker to discuss politics as a public responsibility that cannot afford to operate according to the moral rules that govern private life. According to Machiavelli, what rules govern private m..
What events constitute completion of the widget : What event(s) constitute completion of the widget? What rights/obligations should the government have if the widget does not work?
Build the statement using the data and assumptions : Hill Propane Distributors wants to construct a pro forma balance sheet for 2010. Build the statement using the following data and assumptions.
Discuss about the sociology of developing countries : Some of the most serious abuses taking place in developing countries deal with child labor, human slavery, sweatshops, bad governance, and environmental degradation. Select one (1) developing country, and examine the extent to which two (2) of the..
What are the firms expected cash receipts for march : A firm has actual sales of $50,000 in January and $70,000 in February. - what are the firm's expected cash receipts for March, April, and May?
Compare and contrast these two arguents : Thomas Malthus and neo-Malthusians argue that population growth has negative consequences and needs to be controlled; Marx and Engels argue that capitalism, not population growht, is the problem. Answer the following:Compare and contrast these two ar..
Prepare a cash budget for may and june and july : Bachrach has a cash balance of $200,000 on May 1 and does not want its balance to dip below that level. Prepare a cash budget for May, June, and July.

Reviews

Write a Review

Financial Management Questions & Answers

  What would be the companys debt ratio

Sadik Industries must install $300 of new machinery in its Texas plant. It can either lease the equipment or obtain a bank loan for 100% of the required amount and buy the equipment. What would be the company's debt ratio, in percentages, if it purch..

  Explain what typically happens to interest rates

Briefly explain what typically happens to interest rates during a recession. Use a demand and supply graph for bonds to illustrate your answer.

  Dividends are expected to grow at constant rate

The Jackson–Timberlake Wardrobe Co. just paid a dividend of $2.10 per share on its stock. The dividends are expected to grow at a constant rate of 5 percent per year indefinitely. Investors require a return of 14 percent on the company's stock. What ..

  Dividend is expected to grow at rate-stock required return

A stock is currently priced at $37.40. Its dividend is expected to grow at a rate of 6.80% per year indefinitely. The stock's required return is 9.70%. The stock's predicted price 5 years from now, P5, should be $________.

  Discuss whether they make bonds more or less risky

Describe at least 5 bond provisions and discuss whether they make bonds more or less risky. Exercise: Consider two bonds, everything else the same except the provision. Would Bond A with the provision be more or less risky than Bond B without the pro..

  The project modified internal rate of return

Modified Internal Rate of Return (MIRR) Adolphus Logistics has a weighted average cost of capital of 10 percent. The company is considering a project with the following expected cash flows: Year Project Cash Flow 0 –$611 million 1 372 million 2 235 m..

  Calculate change in firms eps-change in capital structure

Consider a firm with an EBIT of $10,500,000. The firm finances its assets with $50,000,000 debt (costing 6.5 percent) and 10,000,000 shares of stock selling at $10.00 per share. Calculate the change in the firm’s EPS from this change in capital struc..

  Ensure an annual retirement income

Starting with your current situation, what must you do to ensure an annual retirement income of $75,000 starting at age 65? Make sure that you submit time value of money calculations that support the conclusions

  Estimate costcos cost of equity capital

Estimate Costcos cost of equity capital - How much will your dream car cost by the time you are ready to buy it?

  Determine the after-tax cash flows

Some new production machinery has a first cost of $100,000 and a useful life of 10 years. Its estimated O&M costs are $10,000 the first year, which will increase annually by $4,000. Determine the after-tax cash flows. The property’s economic service ..

  Issuing preferred and common stock to further expand

Stephen and Chris are also looking at issuing preferred and common stock to further expand TechU's businesses. They also want to examine their existing stock value to get a picture of how much they can sell additional stock for. What would TechU be w..

  What is the enterprise value-EBITDA multiple

The market value of the equity of Thompson, Inc., is $307,000. The balance sheet shows $22,000 in cash and $200,000 in debt, while the income statement has EBIT of $97,000, and a total of $136,000 depreciation and amortization. What is the enterprise..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd