You are evaluating the HomeNet project under the following assumptions: Sales of 50,000 units in year...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are evaluating the HomeNet project under the following assumptions: Sales of 50,000 units in year 1 increasing by 51,000 units per year over the life of the project, a year 1 sales price of $260.00/unit, decreasing by 11% annually and a year 1 cost of $120.00/unit decreasing by 21% annually. In addition, new tax laws allow 100% bonus depreciation (all the depreciation expense occurs when the asset is put into use, in this case immediately). 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: a. Using the FCF projections given, calculate the NPV of the HomeNet project assuming a cost of capital of 12%, 14%, and 16%. b. What is the IRR of the project in this case? a. Using the FCF projections given, calculate the NPV of the HomeNet project assuming a cost of capital of 12%, 14%, and 16%. The NPV of the FCF's of the HomeNet project assuming a cost of capital of 12% is $ (Round to the nearest thousand dollars.) (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 1 2 3 4 HomeNet Units Sales (000s) 51 Sales Price ($/unit) 11% Cost of Goods Sold ($/unit) 21% 50 101 152 260.00 231.40 205.95 203 183.30 120.00 94.80 74.89 59.16 Operating Expenses ($000s) Hardware and Software Development (15,000) - - - Marketing and Technical Support - (2,800) (2,800) (2,800) (2,800) Capital Expenditures Lab Equipment Depreciation (7,500) 100% | | Corporate Tax Rate 20% 20% 20% 20% 20% (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 2 3 4 5 Incremental Earnings Forecast ($000s) 1 Sales 2 Cost of Goods Sold 3 Gross Profits 4 Selling, General, and Administrative 5 Research and Development 6 Depreciation 7 EBIT 8 Income Tax at 20% 9 Unlevered Net Income Free Cash Flow ($000s) 10 Plus: Depreciation 11 Less: Capital Expenditures 12 Less: Increases in NWC 13 Free Cash Flow (15,000) (7,500) (22,500) 4,500 - 13,000 23,371 31,304 37,210 (6,000) (9,575) (11,383) (12,009) 7,000 13,796 19,921 25,201 (2,800) (2,800) (2,800) (2,800) - - 4,200 10,996 17,121 22,401 (840) (2,199) (3,424) (4,480) (18,000) 3,360 8,797 13,697 17,921 7,500 (7,500) (1,050) (1,020) (919) (792) 3,781 (18,000) 2,310 7,777 12,778 17,129 3,781 You are evaluating the HomeNet project under the following assumptions: Sales of 50,000 units in year 1 increasing by 51,000 units per year over the life of the project, a year 1 sales price of $260.00/unit, decreasing by 11% annually and a year 1 cost of $120.00/unit decreasing by 21% annually. In addition, new tax laws allow 100% bonus depreciation (all the depreciation expense occurs when the asset is put into use, in this case immediately). 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: a. Using the FCF projections given, calculate the NPV of the HomeNet project assuming a cost of capital of 12%, 14%, and 16%. b. What is the IRR of the project in this case? a. Using the FCF projections given, calculate the NPV of the HomeNet project assuming a cost of capital of 12%, 14%, and 16%. The NPV of the FCF's of the HomeNet project assuming a cost of capital of 12% is $ (Round to the nearest thousand dollars.) (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 1 2 3 4 HomeNet Units Sales (000s) 51 Sales Price ($/unit) 11% Cost of Goods Sold ($/unit) 21% 50 101 152 260.00 231.40 205.95 203 183.30 120.00 94.80 74.89 59.16 Operating Expenses ($000s) Hardware and Software Development (15,000) - - - Marketing and Technical Support - (2,800) (2,800) (2,800) (2,800) Capital Expenditures Lab Equipment Depreciation (7,500) 100% | | Corporate Tax Rate 20% 20% 20% 20% 20% (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 2 3 4 5 Incremental Earnings Forecast ($000s) 1 Sales 2 Cost of Goods Sold 3 Gross Profits 4 Selling, General, and Administrative 5 Research and Development 6 Depreciation 7 EBIT 8 Income Tax at 20% 9 Unlevered Net Income Free Cash Flow ($000s) 10 Plus: Depreciation 11 Less: Capital Expenditures 12 Less: Increases in NWC 13 Free Cash Flow (15,000) (7,500) (22,500) 4,500 - 13,000 23,371 31,304 37,210 (6,000) (9,575) (11,383) (12,009) 7,000 13,796 19,921 25,201 (2,800) (2,800) (2,800) (2,800) - - 4,200 10,996 17,121 22,401 (840) (2,199) (3,424) (4,480) (18,000) 3,360 8,797 13,697 17,921 7,500 (7,500) (1,050) (1,020) (919) (792) 3,781 (18,000) 2,310 7,777 12,778 17,129 3,781
Expert Answer:
Related Book For
Corporate Finance The Core
ISBN: 9781292158334
4th Global Edition
Authors: Jonathan Berk, Peter DeMarzo
Posted Date:
Students also viewed these finance questions
-
If a PM has a -1% Fama-French alpha, would you expect this PM to underperform or outperform the S&P500 on average over time? Please explain carefully.
-
You are evaluating the HomeNet project under the following assumptions: Sales of 50 comma 000 units in year 1 increasing by 53 comma 000 units per year over the life of the project, a year 1 sales...
-
Two charges are located in the (x, y) plane as shown. The positive a direction is to the right and the positive y direction is upwards. The fields produced by these charges are ob- served at a point...
-
When and how should you use multiple comparison procedures for evaluating pair wise combinations of the group means?
-
In most companies that are considered to be successful users of the S&OP process, the resulting plans and commitments are treated, essentially, as quasi-contracts. That is, the agreement reached...
-
Although everyone makes mistakes, describe how history repeats itself when there are patterns of progress and regression in the provision of patient care. In forming your answer, consider how...
-
Lindberg Delivery Service had the following selected transactions during October: 1. Received cash from issuance of capital stock, $75,000. 2. Paid rent for October, $4,200. 3. Paid advertising...
-
Given the following information, and using the VC method of valuation, determine the % of the company that needs to be given up for $1.5 m investment. Required ROR by investor(s): 25% Net income in...
-
The sales team at Joel Brown Manufacturing Company Ltd decided on the following sales forecast for the months indicated. The company produces two products Clam and Glam Sales Forecast 2016 Details...
-
Bond interest payments received are taxable at what rate? Short term capital gains Long term capital gains Dividend rates Ordinary income rate
-
(a) If the PowerShooter 1800 is marked up by $69.50, what is the cost (in $) and what is the percent markup based on cost? cost $ 60.50 percent markup based on cost % (b) If the CyberShooter 2400 has...
-
In IBM company, can you pls discuss the application of blockchain in business for the following, a. benefits, b. increased transparency, c. enhanced security, d. improved efficiency and e. cost...
-
Given that GILTI can cause US corporate parents of foreign corporations to be inclined to move tangible assets overseas, FDII comes along and further penalizes US Companies that have a lot intangible...
-
true or false: Given that GILTI can cause US corporate parents of foreign corporations to be inclined to move tangible assets overseas, FDII comes along and further penalizes US Companies that have a...
-
Discuss in scholarly detail size, age, management, business definition, linkages and other factors as the focus of strategic analysis and choice across multiple businesses and their interface with a...
-
Explain five different cases of income exempt from tax with clear examples.
-
What would be the length of a half-wave antenna for a radio station that emits its signal at \(90.5 \mathrm{MHz}\) ?
-
A sinusoidal electromagnetic wave has a maximum electric field magnitude of \(E_{\max }=500 \mathrm{~N} / \mathrm{C}\). What is the root-mean-square value of the electric field?
-
Full-body scanners at airports are sometimes referred to as millimeter-wave scanners and sometimes as terahertz scanners. Does this make sense?
Study smarter with the SolutionInn App