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 7 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
- A 0.0038 kg leaf falls 16.8 m to the ground, where it lands with a speed...
- Problem 1: In the figure to the right, m1=20.0kg and α=53.1o . The coefficient of kinetic...
- A palindrome is a string whose reversal is identical to the string. For example, 110010011 is...
- Explain how the shape of the load duration curve for a particular system affects the selection...
- For physics discussion post. Please TYPE the response as I struggle with reading written information. Explain...
- Consider a file system using a multi-level indexing scheme in inodes as the file organization. In...
- 1a) A sample of a new cleaning product, "Joe's Famous Bleach Cleaner," with a mass of...
ADVERTISEMENT