Calculate the npv of the homenet project

Assignment Help Financial Management
Reference no: EM13865696

You are evaluating the HomeNet project under the following assumptions: Sales of 50,000 units in year 1 increasing by 53,000 units per year over the life of the project, a year 1 sales price of $260/unit, decreasing by 11% annually and a year 1 cost of $120/unit decreasing by 21% annually. In addition, new tax laws allow you to depreciate the equipment, costing $7.5 million over three years using straight-line depreciation. Research and development expenditures total $15 million in year 0 and selling, general, and administrative expenses are $2.8 million per year (assuming there is no cannibalization).

Also assume HomeNet will have no incremental cash or inventory requirements (products will be shipped directly from the contract manufacturer to customers). However, receivables related to HomeNet are expected to account for 15% of annual sales, and payables are expected to be 15% of the annual cost of goods sold. Under these assumptions the unlevered net income, net working capital requirements and free cash flow are shown in the Table 1707 . Using the FCF projections given:

a. Calculate the NPV of the HomeNet project assuming a cost of capital of 10%, 12% and 14%.

The NPV of the FCF's of the HomeNet project assuming a cost of capital of 10% is $__.

The NPV of the FCF's of the HomeNet project assuming a cost of capital of 12% is __.

The ICPV of the FCF's of the HomeNet project assuming a cost of capital of 14% is $__.

b. What is the IRR of the project in this case?

The IRR is ____%.


Year               0

1

2

3

4

5

HomeNet








Units Sales (000s)


53

50

103

156

209


Sales Price (S unit)


11%

260

231.40

205.95

183.30


Cost of Goods Sold (S/unit)


21%

120

94.80

74.89

59.16


Operating Expenses ($000s)








Hardware & Software Develop.


(15,000)






Marketing & Technical Support



(2,800)

(2,800)

(2,800)

(2,800)

-

Capital Expenditures








Lab Equipment


(7,500)






Depreciation



33%

33%

33%



Marginal Corporate Tax Rate


40%

40%

40%

40%

40%



Year

0

1

2

3

4

5

Incremental Earnings Forecast ($000)

1   Sales



13,000

23,834

32,128

38,310


2 Cost of Goods Sold



(6,000)

(9,764)

(11,683)

(12,364)


3    Gross Profits



7,000

14,070

20,445

25,946


4   Selling, General, and Administrative



(2,800)

(2,800)

(2,800)

(2,800)


5 Research and Development


(15,000)




-


6 Depreciation



(2,500)

(2,500)

(2,500)

-


7 EBIT


(15,000)

1,700

3,770

15,145

23,146


8 Income Tax at 40%


6,000

(680)

(3,508)

(6,058)

(9,258)


9 Unlevered Net Income


(9,000)

1,020

5,262

9,087

13,888


Free Cash Flow ($000)








10 Plus: Depreciation



2,500

2,500

2,500

-


11 Less: Capital Expenditures


(7,500)

-





12 Less: Increases in NWC



(1,050)

(1,060)

(957)

(325)


13 Free Cash Flow


(16,500)

2,470

6,702

10,630

13,063

3,892

Reference no: EM13865696

Questions Cloud

Explain the culture of law enforcement : Compose a 1-2 page Essay discussing how one's disposition and manner contributes to building a rapport with colleagues. Be sure to address the prompts below: Describe the culture of law enforcement. How does effective, appropriate communication and..
Conducting an organizational assessment : Conducting an organizational assessment
Tory of the sadhu from your perspective? : McCoy concludes that the lesson of the sadhu is that in a complex corporate situation the individual requires and deserves the support of the group When people cannot find such support in their organizations, they don’t know how to act What support i..
The method of sections : 1. Determine, by THE METHOD OF SECTIONS, the forces in members AC, BC and BD. 2. Determine, by THE METHOD OF JOINTS, the forces in members FH, HI, GI, and GH.
Calculate the npv of the homenet project : Calculate the NPV of the HomeNet project assuming a cost of capital of 10%, 12% and 14% and NPV of the FCF's of the HomeNet project assuming a cost of capital of 10% is $__.
Is it fair to excuse the criminal responsibility of someone : Is it fair to excuse the criminal responsibility of someone who acted under an irresistible impulse
Explain how the debt capacity of the governmental entity : Explain how the debt capacity of the governmental entity is determined
Indicate whether operating investing activities are afected : Motif Furniture is an Austin- based furniture company. For each of the following first- quarter transactions, indicate whether operating (O), investing (I), or financing activities (F) are affected and whether the effect is a cash inflow (1) or outfl..
Community relating to current homeland security hazards : Determine which agencies will be involved in your larger group

Reviews

Write a Review

Financial Management Questions & Answers

  Calculate the financial ratios show your calculations for

find a publicly-traded company on yahooreg finance by entering the company name in the search bar. some examples

  Evaluation of an active portfolio management strategy

How is the Sharpe measure different from the Treynor measures of portfolio performance evaluation? What is the problem with using the Sharpe measure for evaluation of an active portfolio management strategy?

  Find the assessed value of a home with a market value

Find the assessed value of a home with a market value of $175,000 if the assessed valuation is 35% of the market price. Find the property tax on a home with an assessed value of $85,000 if the property tax rate is $11.25 per $1,000 of the assessed va..

  Difference between sensitivity analysis-scenario analysis

Explain the difference between sensitivity analysis and scenario analysis. Offer and argument for the proposition that scenario analysis offers a more realistic picture of a project’s risk than does sensitivity analysis

  Weighted average cost of capital

The Black Bird Company plans an expansion. The expansion is to be financed by selling $32 million in new debt and $71 million in new common stock. The before-tax required rate of return on debt is 11.74% percent and the required rate of return on equ..

  Formula of interest expense ebit

Formula of Interest expense EBIT divided by Interest expense but this does not seem correct -

  Unit in fixed cost at a volume

A company has $7.50 per unit in variable cost at $4.70 per unit in fixed cost at a volume of 50,000 units. If the company marks up the cost by 0.52 what price should be charged if 61,000 units are expected to be sold?

  Use trial and error to find the unknown rate of return

Storico Co. just paid a dividend of $1.30 per share. The company will increase its dividend by 20 percent next year and will then reduce its dividend growth rate by 5 percentage points per year until it reaches the industry average of 5 percent divid..

  Calculate the price-cash flow ratio and market-book ratio

Review the requirements of the Chapter 3 Mini-Case, parts b through j. Then apply those requirements to do an analysis of Brinker International, which is a real company. Don't complete the minicase itself, just Brinker. Calculate the 2014 current and..

  Determine the constant-growth rate

Robert Gillman, an equity research analyst at Gillman Advisors, believes in efficient markets. He has been following the mining industry for the past 10 years and needs to determine the constant-growth rate that he should use while valuing Pan Asia M..

  What is required return using capital asset pricing model

what is the required return using the capital asset pricing model if a stock's beta is 1.2 and the individual, who expects the market to rise by 11.2%, can earn 4.4% invested in risk -free Treasury bill?

  Price will eliminate triangular arbitrage

Assume you are a trader with Deutsche Bank. From the quote screen on your computer terminal, you notice that Dresdner Bank is quoting €0.7627/$1.00 and Credit Suisse is offering SF1.1806/$1.00. You learn that UBS is making a direct market between the..

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