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 is the discount being offered

You place an order for 540 units of inventory at a unit price of $170. The supplier offers terms of 2/15, net 60. How long do you have to pay before the account is overdue? If you take the full period, how much should you remit? How quickly must you ..

  Expanding rapidly-currently needs to retain all of earnings

Microtech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it does not pay dividends. However, investors expect Microtech to begin paying dividends, beginning with a dividend of $1.50 coming 3 years from toda..

  Growth in the value of the shares and the dividend

What is the annual rate of return on an investment in a common stock that cost $40.50 if the current dividend is $1.50 and the growth in the value of the shares and the dividend is 8 percent?

  The risk that mortgages will prepay quicker than investors

The risk that mortgages will prepay quicker than investors would like is called (???) risk and is associated with (???) market interest rates. The risk that mortgages will prepay slow than investors would like is called (???) risk and is associated w..

  Regarding corporate citizenship-ethics-shareholder wealth

A survey of Fortune 500 companies' executives said the following goal were most important to their firms: What is a firm's responsibility to society regarding corporate citizenship, ethics and shareholder wealth?

  Arithmetic and geometric returns for the stock

A stock has had returns of 10 percent, 28 percent, 15 percent, −16 percent, 28 percent, and −6 percent over the last six years. What are the arithmetic and geometric returns for the stock?

  Bright star dance company will be producing a modern dance

bright star dance company will be producing a modern dance show over a three-month period of time in october-december.

  Rate trading at a premium or discount relative to spot rate

Assume that interest rate parity holds and that 90-day risk-free securities yield 3% in the United States and 3.6% in Germany. In the spot market, 1 euro equals $1.38 dollar. Is the 90-day forward rate trading at a premium or discount relative to the..

  What is the after-tax salvage value of the asset

An asset is used in a four-year project falls in the five-year MACRS class for tax purposes. The asset has an acquisition cost of $8,600,000 and will be sold for $1,890,000 at the end of the project. If the tax rate is 35 percent, what is the after-t..

  Potential estate tax liability-estate planning case study

The goal of this Estate Planning Case Study is to make adjustments to an existing estate plan to eliminate the potential estate tax liability. Today is January 2014 John has been your financial planning client for over ten-years. He is 61 and married..

  What is the approximate real rate of interest

Treasury bills are currently paying 9 percent and the inflation rate is 3.6 percent. What is the approximate real rate of interest? What is the exact real rate?

  The incremental revenue

Carry- all plans to sell 1300 carriers next year and has budgeted sales of 46000 and profits of 22000. variable cost are projected to be $20 per unit. micheal company offers to pay $22900 to buy 500 units from carry-all. total fixed cost are 7000 per..

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