Question

In: Finance

Consider the following project of Hand Clapper, Inc. The company is considering a four-year project to...

Consider the following project of Hand Clapper, Inc. The company is considering a four-year project to manufacture clap-command garage door openers. This project requires an initial investment of $12.8 million that will be depreciated straight-line to zero over the project’s life. An initial investment in net working capital of $560,000 is required to support spare parts inventory; this cost is fully recoverable whenever the project ends. The company believes it can generate $10.3 million in pretax revenues with $3.8 million in total pretax operating costs. The tax rate is 25 percent and the discount rate is 9 percent. The market value of the equipment over the life of the project is as follows:

  

Year Market Value (millions)
1 $ 10.2   
2 8.3   
3 4.5   
4 1.2   

  

a.

Assuming the company operates this project for four years, what is the NPV? (Do not round intermediate calculations and enter your answer in dollars, not millions, rounded to 2 decimal places, e.g., 1,234,567.89.)

b-1. Compute the project NPV assuming the project is abandoned after one year. (Do not round intermediate calculations and enter your answer in dollars, not millions, rounded to 2 decimal places, e.g., 1,234,567.89.)
b-2. Compute the project NPV assuming the project is abandoned after two years. (Do not round intermediate calculations and enter your answer in dollars, not millions, rounded to 2 decimal places, e.g., 1,234,567.89.)
b-3. Compute the project NPV assuming the project is abandoned after three years. (Do not round intermediate calculations and enter your answer in dollars, not millions, rounded to 2 decimal places, e.g., 1,234,567.89.)


     

Solutions

Expert Solution

a). NPV at the end of year 4 = 6,059,711.11

Formula Year (n) 0 1 2 3 4
Initial investment (II)             1,28,00,000
Revenue ('R)         1,03,00,000         1,03,00,000         1,03,00,000        1,03,00,000
II/4 Depreciation (D)             32,00,000             32,00,000            32,00,000            32,00,000
Cost ('C)             38,00,000             38,00,000            38,00,000            38,00,000
R-D-C EBIT             33,00,000             33,00,000            33,00,000            33,00,000
25%*EBIT Tax @ 25%               8,25,000               8,25,000               8,25,000              8,25,000
EBIT - Tax Net income (NI)             24,75,000             24,75,000            24,75,000            24,75,000
Add: depreciation             32,00,000             32,00,000            32,00,000            32,00,000
NI + D Operating Cash Flow (OCF)             56,75,000             56,75,000            56,75,000            56,75,000
NWC                (5,60,000)              5,60,000
MV*(1-Tax) where MV = value at end of year 4 After tax salvage value (SV)              9,00,000
OCF + NWC + SV - II Free Cash Flow (FCF)          (1,33,60,000)             56,75,000             56,75,000            56,75,000            71,35,000
1/(1+d)^n Discount factor @ 9%                         1.000                     0.917                     0.842                     0.772                    0.708
FCF*Discount factor PV of FCF    (1,33,60,000.00)       52,06,422.02       47,76,533.96      43,82,141.25      50,54,613.88
Sum of all PVs NPV          60,59,711.11

b-1). NPV if project is abandoned after 1 year = 1,580,366.97

Formula Year (n) 0 1
Initial investment (II)             1,28,00,000
Revenue ('R)            1,03,00,000
II/4 Depreciation (D)                32,00,000
Cost ('C)                38,00,000
R-D-C EBIT                33,00,000
25%*EBIT Tax @ 25%                  8,25,000
EBIT - Tax Net income (NI)                24,75,000
Add: depreciation                32,00,000
NI + D Operating Cash Flow (OCF)                56,75,000
NWC                (5,60,000)                  5,60,000
II - D Book value (BV)                96,00,000
MV - (MV-BV)*Tax where MV = value at end of year 1 After tax salvage value (SV)            1,00,50,000
OCF + NWC + SV - II Free Cash Flow (FCF)          (1,33,60,000)            1,62,85,000
1/(1+d)^n Discount factor @ 9%                         1.000                        0.917
FCF*Discount factor PV of FCF    (1,33,60,000.00)      1,49,40,366.97
Sum of all PVs NPV          15,80,366.97


b-2). NPV if project is abandoned after 2 years = 3,680,442.72

Formula Year (n) 0 1 2
Initial investment (II)             1,28,00,000
Revenue ('R)            1,03,00,000            1,03,00,000
II/4 Depreciation (D)                32,00,000                32,00,000
Cost ('C)                38,00,000                38,00,000
R-D-C EBIT                33,00,000                33,00,000
25%*EBIT Tax @ 25%                  8,25,000                  8,25,000
EBIT - Tax Net income (NI)                24,75,000                24,75,000
Add: depreciation                32,00,000                32,00,000
NI + D Operating Cash Flow (OCF)                56,75,000                56,75,000
NWC                (5,60,000)                  5,60,000
II - Total depreciation Book value (BV)                64,00,000
MV - (MV-BV)*Tax where MV = value at end of year 2 After tax salvage value (SV)                78,25,000
OCF + NWC + SV - II Free Cash Flow (FCF)          (1,33,60,000)                56,75,000            1,40,60,000
1/(1+d)^n Discount factor @ 9%                         1.000                        0.917                        0.842
FCF*Discount factor PV of FCF    (1,33,60,000.00)          52,06,422.02      1,18,34,020.71
Sum of all PVs NPV          36,80,442.72

b-3). NPV if project is abandoned after 3 yrs = 4,661,386.01

Formula Year (n) 0 1 2 3
Initial investment (II)             1,28,00,000
Revenue ('R)            1,03,00,000            1,03,00,000                    1,03,00,000
II/4 Depreciation (D)                32,00,000                32,00,000                        32,00,000
Cost ('C)                38,00,000                38,00,000                        38,00,000
R-D-C EBIT                33,00,000                33,00,000                        33,00,000
25%*EBIT Tax @ 25%                  8,25,000                  8,25,000                          8,25,000
EBIT - Tax Net income (NI)                24,75,000                24,75,000                        24,75,000
Add: depreciation                32,00,000                32,00,000                        32,00,000
NI + D Operating Cash Flow (OCF)                56,75,000                56,75,000                        56,75,000
NWC                (5,60,000)                          5,60,000
II - Total depreciation Book value (BV)                        32,00,000
MV - (MV-BV)*Tax where MV = value at end of year 3 After tax salvage value (SV)                        41,75,000
OCF + NWC + SV - II Free Cash Flow (FCF)          (1,33,60,000)                56,75,000                56,75,000                    1,04,10,000
1/(1+d)^n Discount factor @ 9%                         1.000                        0.917                        0.842                                0.772
FCF*Discount factor PV of FCF    (1,33,60,000.00)          52,06,422.02          47,76,533.96                  80,38,430.03
Sum of all PVs NPV          46,61,386.01

Related Solutions

Consider the following project for Hand Clapper, Inc. The company is considering a 4-year project to...
Consider the following project for Hand Clapper, Inc. The company is considering a 4-year project to manufacture clap-command garage door openers. This project requires an initial investment of $16.3 million that will be depreciated straight-line to zero over the project’s life. An initial investment in net working capital of $1,030,000 is required to support spare parts inventory; this cost is fully recoverable whenever the project ends. The company believes it can generate $13.5 million in pretax revenues with $5.4 million...
Consider the following project for Hand Clapper, Inc. The company is considering a 4-year project to...
Consider the following project for Hand Clapper, Inc. The company is considering a 4-year project to manufacture clap-command garage door openers. This project requires an initial investment of $15.7 million that will be depreciated straight-line to zero over the project’s life. An initial investment in net working capital of $970,000 is required to support spare parts inventory; this cost is fully recoverable whenever the project ends. The company believes it can generate $12.3 million in revenues with $4.8 million in...
The Glenn Corporation is considering a four-year project with the following data; What is the project...
The Glenn Corporation is considering a four-year project with the following data; What is the project NPV using wacc of 5.4%? Additional investment in fixed assets but no additional working capital $100,000 Straight-line depreciation rate 25% but zero salvage value after four years Annual sales revenues (constant for every year) $75,000 Operating costs (excl. depreciation) (also constant) $25,000 Tax rate 21.0%
The Brookfield Corporation is considering a four-year project with the following data; What is the project...
The Brookfield Corporation is considering a four-year project with the following data; What is the project NPV using wacc of 11.3%? Additional investment in fixed assets but no additional working capital $100,000 Straight-line depreciation rate 25% but zero salvage value after four years Annual sales revenues (constant for every year) $75,000 Operating costs (excl. depreciation) (also constant) $25,000 Tax rate 21.0% Trumbull Inc. has $4.8 million  EBIT, $1.2 million depreciation, a tax rate of .4, a capital expenditure of $0.7 million,...
Gigi Buffon Manufacturing Company is considering a four-year investment project that involves the purchase of a...
Gigi Buffon Manufacturing Company is considering a four-year investment project that involves the purchase of a new equipment that costs $600,000 today. The equipment will be depreciated on a straight-line basis over 4 years. The company expects the salvage value of the equipment will equal zero at the end of the year four. However, the company expects to sell the equipment at the end of fourth year to generate $20,000 after tax cash flow. The purchase and utilization of the...
Gigi Buffon Manufacturing Company is considering a four-year investment project that involves the purchase of a...
Gigi Buffon Manufacturing Company is considering a four-year investment project that involves the purchase of a new equipment that costs $600,000 today. The equipment will be depreciated on a straight-line basis over 4 years. The company expects the salvage value of the equipment will equal zero at the end of the year four. However, the company expects to sell the equipment at the end of fourth year to generate $20,000 after tax cash flow. The purchase and utilization of the...
Harry Davis Inc is considering the following projects: Year   Project 1   Project 2   Project 3   Project...
Harry Davis Inc is considering the following projects: Year   Project 1   Project 2   Project 3   Project 4 0   $(50,000,000)   $(25,000,000)   $(25,000,000)   $(50,000,000) 1   $15,000,000    $10,000,000    $5,000,000    $22,000,000 2   $15,000,000    $15,000,000    $10,000,000    $17,000,000 3   $15,000,000    $17,000,000    $5,000,000    $13,500,000 4   $15,000,000    $25,000,000    $11,000,000    $10,000,000 5   $15,000,000    $(35,000,000)   $10,000,000    $8,000,000 The company has a weighted average cost of capital of 11.20% (this is the firm’s required return). Calculate the...
Please consider the following information on a potential investment project that a company is considering to...
Please consider the following information on a potential investment project that a company is considering to open a new office location. Initial cost of building and equipment is $15 million Expected to have a useful life of 30 years At the end of the project the building and its equipment are expected to be sold for a $5,000,000 salvage value The building and its equipment will be depreciated over their 30-year life using straight-line depreciation to a zero balance The...
Wilson, Inc., is considering a new four-year expansion project that requires an initial fixed asset investment...
Wilson, Inc., is considering a new four-year expansion project that requires an initial fixed asset investment of $1,950,000. The fixed asset will be depreciated straight-line to zero over its four-year tax life, after which time it will be worthless. The project is estimated to generate $2,145,000 in annual sales, with costs of $1,205,000. If the tax rate is 35%, what is the Operating Cash Flow (OCF) for this project ? 1. $327,430.28 2. $374,921.15 3. $2,277,430.38 4. $2,324.921.15 5. $781,625.00
Dr. Chan is considering a four year project. The project requires an initial investment of $10,000,000...
Dr. Chan is considering a four year project. The project requires an initial investment of $10,000,000 to buy new equipment. The equipment will be depreciated straight line to zero over the project’s life. The company believes it can generate $5,000,000 in pretax revenues in year 1. Revenues will increase at 20% per year. Total pretax operating cost would be 40% of the pretax revenues. Net working capital will be 20% of the pretax revenue for the year. Net working capital...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT