Can you please help me identify the NPV of this project for both currencies list
ID: 2765796 • Letter: C
Question
Can you please help me identify the NPV of this project for both currencies listed?
TechMedia, Inc. is a U.S. firm that is planning to build a new production facility in either the USA or China. The initial cost to build the facility will be $10 million if built in the USA or ¥55 million if built in China. In either location, the project will require an initial investment of $200,000 in net working capital. Net working capital at the end of each of years 1 through 4 will be $50,000. Net working capital will be $0 at the end of the fifth (final) year of the project. The current exchange rate between the two currencies is 6.3 ¥/$. The risk-free rate in the U.S. is 0.5% and the risk-free rate in China is 6.5%. TechMedia, Inc. pays a 35% tax rate on its taxable income. The firm’s current and target debt-equity ratio is 0.6. Its cost of debt is 6.15% and its cost of equity is 11%. The facility will be fully depreciated over five years (straight line) with no salvage value. The facility is expected to impact the firm’s operating revenues and expenses as shown below. Which location should TechMedia, Inc. choose?
USA Location China Location Year Additional Revenue Additional Expense Additional Revenue Additional Expense 1 $4,000,000 $1,500,000 YEN20,000,000 YEN7,000,000 2 $4,000,000 $1,500,000 YEN25,000,000 YEN8,000,000 3 $5,000,000 $1,750,000 YEN30,000,000 YEN9,000,000 4 $6,000,000 $2,000,000 YEN35,000,000 YEN9,000,000 5 $6,000,000 $2,000,000 YEN40,000,000 YEN8,000,000Explanation / Answer
cashflow in usa in $
Year
Intial investment (USA)
Working capital
Depreciation tax asving
Revenue
Exp
Total cashflow $
0
-10
-0.2
-10.2
1
0.15
0.7
4.0
-1.5
3.35
2
0.7
4
-1.5
3.2
3
0.7
5
-1.75
3.95
4
0.7
6
-2
4.7
5
0.05
0.7
6
-2
4.75
cashflow in china in $
Year
Intial investment (china)
Working capital
Depreciation tax asving
Revenue
Exp
Total cashflow
Exchange rate
Total cashflow ($)
0
-55
-0.2
-55.2
6.30
-8.76
1
0.15
3.85
20
-7
17
6.68
2.55
2
3.85
25
-8
20.85
7.07
2.95
3
3.85
30
-9
24.85
7.50
3.31
4
3.85
35
-9
29.85
7.94
3.76
5
0.05
3.85
40
-8
35.9
8.42
4.26
Incremental chaflow in $
Year
Total cashflow in USA
Total cashflow in china
Incremental cashflow in USA
dis fatc @ 14.69%
Discounted cashflow
0
-10.2
-8.76
-1.44
1
-1.44
1
3.35
2.55
0.80
0.871915599
0.70
2
3.2
2.95
0.25
0.760236811
0.19
3
3.95
3.31
0.64
0.662862334
0.42
4
4.7
3.76
0.94
0.577960009
0.54
5
4.75
4.26
0.49
0.503932347
0.24
NPV
0.67
IRR
33%
Exchange rates
Years
$
China
$/china
0
1.00
6.30
6.30
1
1.01
6.71
6.68
2
1.01
7.15
7.07
3
1.02
7.61
7.50
4
1.02
8.10
7.94
5
1.03
8.63
8.42
Security
Proportion
cost of capital
Debt
0.6
0.0615
0.0369
Equity
1
0.11
0.11
Overall cost of capital
14.69%
cashflow in usa in $
Year
Intial investment (USA)
Working capital
Depreciation tax asving
Revenue
Exp
Total cashflow $
0
-10
-0.2
-10.2
1
0.15
0.7
4.0
-1.5
3.35
2
0.7
4
-1.5
3.2
3
0.7
5
-1.75
3.95
4
0.7
6
-2
4.7
5
0.05
0.7
6
-2
4.75