Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Corporate Finance Expert

Dell is now a private company. So I have changed the firm to Hewlett-Packard Company (HPQ).

As an intern in the capital budgeting division of Hewlett-Packard Company (HPQ), your first assignment is to determine the free cash flows and a battery of capital budgeting criteria of a proposed new type of tablet computer system similar in size to an iPad, but with the operating power of a high-end desktop system.

Investments (CAPEX): Development of the new system will initially require an initial investment (CAPEX) equal to 10% of net Property, Plant, and Equipment (PPE) at the end of fiscal year 2014 (October 31 in this case). The project will then require an additional investment at year 1 equal to 10% of previous year's net PP&E. Then in year 2 net PP&E increases by 5%, and increases by 1% in the third, fourth, and fifth years.

Revenues (sales): First-year revenues for the new product are expected to be 3% of total revenue for HPQ's fiscal year ended October 31, 2014. The new product's revenues are expected to grow at 15% for the second year then 10% for the third and 5% annually for the final two years of the expected life of the project.

NWC and depreciation: Your boss has indicated that the operating costs and net working capital requirements are similar to the rest of the company and that depreciation is straight-line for capital budgeting purposes.

The product is expected to have a life of five years. Your job is to determine the rest of the cash flows associated with this project. Welcome to the "real world." Since your boss hasn't been much help, here are some tips to guide your analysis:

1. Download HPQ's financial statements from Mergent Online.

2. You are now ready to estimate the Free Cash Flow for the new product. Compute the Free Cash Flow for each year using the following equation:

FCF = EBIT * (1 - Tax Rate) + Depreciation - CapEx - Change in NWC

where EBIT = Revenues - Costs - Depreciation & Amortization (in the case of this new project, there is no amortization.)

Set up the timeline and computation of free cash flow in separate, contiguous columns for each year of the project life. Be sure to make outflows negative and inflows positive.

a) Assume that the project's profitability will be about 1% higher relative to HPQ's existing projects in 2014 (fiscal year ended October 31, 2014). Estimate gross profits (revenues -costs) each year by using the adjusted (1% higher) 2014 (EBITDA/Sales) margin, so that your gross profits for each year are the 2014 EBITDA/sales -ratio multiplied by your sales in the subsequent years.

b) Determine the annual depreciation by assuming HPQ depreciates these assets by the straight-line method over a 10-year life. Depreciation is calculated based on the net PP&E for each year.

c) Assume that you sell the net PP&E at year 6 for its book value.

d) Determine HPQ's tax rate by using the income tax rate in 2014.

e) Calculate the net working capital required each year by assuming that the level of NWC will be a constant percentage of the project's sales. Use HPQ's 2014 NWC/Sales to estimate the required percentage. (Use only accounts receivable, accounts payable, and inventory to measure working capital. Other components of current assets and liabilities are harder to interpret and not necessarily reflective of the project's required NWC-for example, HPQ's cash holdings.) Assume that NWC is required for years 1 to 5. At year 6 you should close your NWC account.

f) To determine the free cash flow, calculate the additional capital investment and the change in net working capital each year. Assume that (1) Equipment is sold at book value at year 6 when the operations cease, and (2) the NWC account is recovered when operations cease. Note: don't be surprised of your NWC and the change in NWC are negative.

3. Determine the NPV, IRR, and Payback period of the project at a cost of capital of 10% using the Excel spreadsheets. Include free cash flows 0 through 6 in the NPV calculation.

4. Perform a sensitivity analysis by varying the project forecasts as follows:         

a. suppose first year sales will equal 2%-4% of HPQ's revenues.

b. Suppose cost of capital is 8%-15%

c. Suppose revenue growth is constant after the first year at a rate of 0%-10%.

Corporate Finance, Finance

  • Category:- Corporate Finance
  • Reference No.:- M91223849

Have any Question?


Related Questions in Corporate Finance

Assignment - npv and real option valuationproposed project

Assignment - NPV and real option valuation Proposed project: Alchemy Mines is considering an investment in the rights to a silver mine. Initial investment - The owner of the mine will sell the rights to Alchemy Mines at ...

Descriptionstudents are required to study undertake

Description: Students are required to study, undertake research, analyse and conduct academic work within the areas of corporate finance. The assignment should examine the main issues, including underlying theories, impl ...

Mini case assignment -problems - use internet to identify a

Mini Case Assignment - Problems - Use internet to identify a house or condo that you may be interested in investing as a rental property for 10+ years. (Suggested price range between $250k - $1 million) 1. Estimate the a ...

Case - campar industries incthis case is about variance

Case - Campar Industries, Inc. This case is about variance analysis. The purpose of this case is to allow you to break down several different types of variance that might occur in a business. For each of the types of var ...

Descriptionstudents are required to study undertake

Description: Students are required to study, undertake research, analyse and conduct academic work within the areas of corporate finance. The assignment should examine the main issues, including underlying theories, impl ...

Ethics and financial services assignment -learning outcome

Ethics and Financial Services Assignment - Learning Outcome - Apply ethical principles and decisionmaking models in arriving at a responsible and ethical judgement in routine and complex finance decisions Communicate the ...

Assignment -the main objective of this assignment is to

Assignment - The main objective of this assignment is to emphasis the importance of consideration time value of money in financial management decisions. It will cover time value of money, investment valuation and firms' ...

Assignment -this assignment is designed to test students on

Assignment - This assignment is designed to test students on Topic (Investment Appraisal) and on Topic (Dividend Policy). For Question 1, students are expected to appraise the attractiveness and risk of a capital asset p ...

Interest swap valueabc bank has agreed to receive 3-month

Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of 11 months. The LIBOR spot rates for 2-month, 5-month, 8-mont ...

Assignment - credit card liabilities and fraudwhen a credit

Assignment - Credit Card Liabilities and Fraud When a credit card is lost or stolen, it can be used until its owner reports it as missing. This loss of one's credit card can result in fraud and therefore, being aware of ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As