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 - 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 ...

Graph an event study relationshipthe event in consideration

Graph an event study relationship. The event in consideration here is: "Environmental performance, being green, clean-tech, corporate sustainability, and many other "green" issues are on the forefront of the current econ ...

Corporate finance assignment - required this assessment

Corporate Finance Assignment - Required: This assessment task is a written report and analysis of the financial performance of a selected company in order to provide financial advice to a wealthy investor. It will be bas ...

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 ...

Assignment - preparing and analyzing a cash budgetselect

Assignment - Preparing and analyzing a cash budget Select assumptions for the following values that fall between the minimum and maximum indicated. Assumption Minimum Maximum a. Sales in month 1 $150,000 $250,000 b. Incr ...

Questions -q1 global auto wants to choose the better of two

Questions - Q1. Global Auto wants to choose the better of two mutually exclusive projects for expanding the firm's production capacity. The relevant cash flows for the projects are shown in the following table. The firm' ...

Question - given1 under armour annual report - you will

Question - Given 1. Under Armour Annual Report - You will find the financial statements in this annual report. 2. Nike Annual Report - You will find the financial statements in the 10-K. Instructions for final project: 1 ...

Strategic and financial decision-making referral

Strategic and Financial Decision-making Referral Assignment- The following assignment is based on HYPOTHETICAL scenarios related to Tesco plc. Task 1 - Tesco plc is contemplating introducing a new computer system which i ...

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 ...

Question - business performanceassess how business

Question - Business Performance Assess how Business Performance is measured, financially and non-financially, in your organization* and analyze its business performance. Organization is InterContinental Hotels Group (IHG ...

  • 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