Question
In: Finance
The following information is available about an investment opportunity. Investment will occur at year 0 and...
The following information is available about an investment opportunity. Investment will occur at year 0 and sales will occur from year 1 to year 8. Use a nominal discount rate, calculated as in = (1 + ir)(1 + p) – 1, where ir is the real discount rate, and p is expected inflation.
Facts and assumptions
Initial cost $28,000,000
Unit sales $400,000
Selling price per unit, year 1 $60
Variable cost per unit, year 1 $42
Life expectancy (years) 8
Salvage value $0
Depreciation Straight-line
Tax rate 37%
Real discount rate 10.0%
Inflation rate 0.0%
a. Prepare a spreadsheet to estimate the project’s annual after-tax cash flows.
b. Calculate the investment’s internal rate of return and its net present value assuming zero inflation.
c.
How do the internal rate of return and net present value change when you assume an inflation rate of 8 percent per year in price and variable cost per unit?
d. How do you explain the fact that inflation causes the internal rate of return to increase and the NPV to decrease?
e. Does inflation make this investment more attractive or less attractive? Why?
Solutions
Expert Solution
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | |||
| Sales | $ | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | ||
| Varialble Cost | $ | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | ||
| EBITDA | $ | 72,00,000 | 72,00,000 | 72,00,000 | 72,00,000 | 72,00,000 | 72,00,000 | 72,00,000 | 72,00,000 | ||
| Depreciation | $ | 35,00,000 | 35,00,000 | 35,00,000 | 35,00,000 | 35,00,000 | 35,00,000 | 35,00,000 | 35,00,000 | ||
| EBT | $ | 37,00,000 | 37,00,000 | 37,00,000 | 37,00,000 | 37,00,000 | 37,00,000 | 37,00,000 | 37,00,000 | ||
| Tax | $ | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | ||
| Net Income | $ | 23,31,000 | 23,31,000 | 23,31,000 | 23,31,000 | 23,31,000 | 23,31,000 | 23,31,000 | 23,31,000 | ||
| a. Cash Flow Statement | |||||||||||
| Sales | $ | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | 2,40,00,000 | ||
| Varialble Cost | $ | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | 1,68,00,000 | ||
| Capex | $ | 2,80,00,000 | |||||||||
| Tax | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | 13,69,000.0 | |||
| Cash | $ | (2,80,00,000.0) | 58,31,000.0 | 58,31,000.0 | 58,31,000.0 | 58,31,000.0 | 58,31,000.0 | 58,31,000.0 | 58,31,000.0 |
58,31,000.0    |
jeff jeffy answered 8 months agoRelated Solutions
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 1,800,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment
$
1,800,000
Annual net income
$
200,000
Expected life
8
years
Salvage value
$
240,000
Merrill’s cost of capital
10
%
Assume straight line depreciation method is used.
Required:
1. Calculate the project’s net present
value.
2. Without making any calculations, determine
whether the internal rate of return (IRR) is more or less than 10
percent.
3. Calculate the net present value using a 15
percent...
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 900,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment
$
900,000
Annual net income
$
90,000
Expected life
8
years
Salvage value
$
100,000
Merrill’s cost of capital
7
%
Assume straight line depreciation method is used.
Required:
1. Calculate the project’s net present value. (Future
Value of $1, Present Value of $1, Future Value Annuity of $1,
Present Value Annuity of $1.) (Use appropriate factor(s)
from the tables provided. Do not round intermediate calculations....
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 1,100,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment
$
1,100,000
Annual net income
$
110,000
Expected life
8
years
Salvage value
$
120,000
Merrill’s cost of capital
7
%
Assume straight line depreciation method is used.
Required:
1. Calculate the project’s net present value. (Future
Value of $1, Present Value of $1, Future Value Annuity of $1,
Present Value Annuity of $1.) (Use appropriate factor(s)
from the tables provided. Do not round intermediate calculations....
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 800,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment
$
800,000
Annual net income
$
80,000
Expected life
8
years
Salvage value
$
90,000
Merrill’s cost of capital
7
%
Assume straight line depreciation method is used.
Required:
1. Calculate the project’s net present value. (Future Value of
$1, Present Value of $1, Future Value Annuity of $1, Present Value
Annuity of $1.) (Use appropriate factor(s) from the tables
provided. Do not round intermediate calculations....
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 1,200,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment
$
1,200,000
Annual net income
$
120,000
Expected life
8
years
Salvage value
$
130,000
Merrill’s cost of capital
10
%
Assume straight line depreciation method is used.
Required:
1. Calculate the project’s net present
value.
2. Without making any calculations, determine
whether the internal rate of return (IRR) is more or less than 10
percent.
3. Calculate the net present value using a 13
percent...
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 700,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment
$
700,000
Annual net income
$
70,000
Expected life
8
years
Salvage value
$
80,000
Merrill’s cost of capital
7
%
Assume straight line depreciation method is used.
Required:
1. Calculate the project’s net present value. (Future
Value of $1, Present Value of $1, Future Value Annuity of $1,
Present Value Annuity of $1.) (Use appropriate factor(s)
from the tables provided. Do not round intermediate calculations....
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 2,200,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment $ 2,200,000
Annual net income $ 190,000
Expected life 8 years
Salvage value $ 200,000
Merrill’s cost of capital 8 %
Assume straight line depreciation method is used.
Required: 1. Calculate the project’s net present value.
2. Without making any calculations, determine whether the
internal rate of return (IRR) is more or less than 8 percent.
3. Calculate the net present value using a 12 percent...
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 2,400,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment
$
2,400,000
Annual net income
$
170,000
Expected life
8
years
Salvage value
$
180,000
Merrill’s cost of capital
8
%
Assume straight line depreciation method is used.
Required:
1. Calculate the project’s net present value. (Future
Value of $1, Present Value of $1, Future Value Annuity of $1,
Present Value Annuity of $1.) (Use appropriate factor(s)
from the tables provided. Do not round intermediate calculations....
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 2,600,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment
$
2,600,000
Annual net income
$
150,000
Expected life
8
years
Salvage value
$
160,000
Merrill’s cost of capital
6
%
Assume straight line depreciation method is used.
Required:
1. Calculate the project’s net present value. (Future
Value of $1, Present Value of $1, Future Value Annuity of $1,
Present Value Annuity of $1.) (Use appropriate factor(s)
from the tables provided. Do not round intermediate calculations....
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 1,100,000...
Merrill Corp. has the following information available about a
potential capital investment:
Initial investment
$
1,100,000
Annual net income
$
110,000
Expected life
8
years
Salvage value
$
120,000
Merrill’s cost of capital
7
%
Assume straight line depreciation method is used.
Required:
1. Calculate the project’s net present value. (Future
Value of $1, Present Value of $1, Future Value Annuity of $1,
Present Value Annuity of $1.) (Use appropriate factor(s)
from the tables provided. Do not round intermediate calculations....
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Question 3: Suppose that 1000 customers are surveyed and 850 are satisfied or very satisfied with...
- Will biometrics involved encryption? How are biometric technology dependent on the use of cryptography?what are the...
- Please provide an example of how MC.sim in R is to be used. The data can...
- Java question: Explain how class (static) variables and methods differ from their instance counterparts. Give an...
- Select the correct statement(s) regarding TCP. a. TCP is a connectionless protocol b. TCP uses windowing...
- select any five bones in the body and provide the following for each: A locational description...
- How many total atoms are in 0.900 g of P2O5?
ADVERTISEMENT