In: Finance
Investment Timing Option: Decision-Tree Analysis
Kim Hotels is interested in developing a new hotel in Seoul. The company estimates that the hotel would require an initial investment of $18 million. Kim expects the hotel will produce positive cash flows of $3 million a year at the end of each of the next 20 years. The project's cost of capital is 13%.
$ million
Year | Calculation= (Cash inflow/ (1+ discount rate)^n) | Present Value Cash flow ( in million) |
1 | 3/(1+0.13)^1 | $2.655 |
2 | $3/(1+0.13)^2 | $2.349 |
3 | $3/(1+0.13)^3 | $2.079 |
4 | $3/(1+0.13)^4 | $1.839 |
5 | $3/(1+0.13)^5 | 1.628 |
6 | $3/(1+0.13)^6 | 1.441 |
7 | $3/(1+0.13)^7 | 1.275 |
8 | $3/(1+0.13)^8 | 1.128 |
9 | $3/(1+0.13)^9 | 0.998 |
10 | $3/(1+0.13)^10 | 0.883 |
11 | $3/(1+0.13)^11 | 0.782 |
12 | $3/(1+0.13)^12 | 0.692 |
13 | $3/(1+0.13)^13 | 0.612 |
14 | $3/(1+0.13)^14 | 0.542 |
15 | $3/(1+0.13)^15 | 0.479 |
16 |
$3/(1+0.13)^16 |
0.424 |
17 | $3/(1+0.13)^17 | 0.375 |
18 | $3/(1+0.13)^18 | 0.332 |
19 | $3/(1+0.13)^19 | 0.294 |
20 | $3/(1+0.13)^20 | 0.260 |
Total Cumulative Cashflow | $21.064 | |
Less: Investment | $18 | |
NPV | $3.064 |
Q2 there are two cases:
Ans:
Tax Imposed with Probability of 50% | Tax not Imposed | |||
Year |
Cash inflow/(1+discount rate)^n Cashflow = $2.2million Discount rate =13% |
PV Cashflow |
Cashflow/ (1+discount rate)^n Cashflow=$3.8million |
PV Cashflow |
1 | $2.2/(1+0.13)^1 | $1.947 | $3.8/(1+0.13)^1 | $3.363 |
2 | $2.2/(1+0.13)^2 | $1.723 | $3.8/(1+0.13)^2 | $2.976 |
3 | $2.2/(1+0.13)^3 | $1.525 | $3.8/(1+0.13)^3 | $2.634 |
4 | $2.2/(1+0.13)^4 | $1.349 | $3.8/(1+0.13)^4 | $2.331 |
5 | $2.2/(1+0.13)^5 | $1.194 | $3.8/(1+0.13)^5 | $2.062 |
6 | $2.2/(1+0.13)^6 | $1.057 | $3.8/(1+0.13)^6 | $1.825 |
7 | $2.2/(1+0.13)^7 | $0.935 | $3.8/(1+0.13)^7 | $1.615 |
8 | $2.2/(1+0.13)^8 | $0.828 | $3.8/(1+0.13)^8 | $1.429 |
9 | $2.2/(1+0.13)^9 | $0.732 | $3.8/(1+0.13)^9 | $1.265 |
10 | $2.2/(1+0.13)^10 | $0.648 | $3.8/(1+0.13)^10 | $1.119 |
11 | $2.2/(1+0.13)^11 | $0.574 | $3.8/(1+0.13)^11 | $0.991 |
12 | $2.2/(1+0.13)^12 | $0.449 | $3.8/(1+0.13)^12 | $0.877 |
13 | $2.2/(1+0.13)^13 | $0.397 | $3.8/(1+0.13)^13 | $0.776 |
14 | $2.2/(1+0.13)^14 | $0.352 | $3.8/(1+0.13)^14 | $0.687 |
15 | $2.2/(1+0.13)^15 | $0.311 | $3.8/(1+0.13)^15 | $0.608 |
16 | $2.2./(1+0.13)^16 | $0.275 | $3.8/(1+0.13)^16 | $0.538 |
17 | $2.2/(1+0.13)^17 | $0.244 | $3.8/(1+0.13)^17 | $0.476 |
18 | $2.2/(1+0.13)^18 | $0.216 |
$3.8/(1+0.13)^18 |
$0.421 |
19 | $2.2/(1+0.13)^19 | $0.191 | $3.8/(1+0.13)^19 | $0.373 |
20 | $2.2/(1+0.13)^20 | $0.397 | $3.8/(1+0.13)^20 | $0.330 |
Cumulative Present Value Cashflow | $15.45 | $26.697 | ||
Less: Investment | $20 | ($20) | ||
NPV | ($4.55) | $6.697 | ||
Tax imposed NPV @ year 1 |
($4.55)/(1+0.13)^1 =($4.027) |
$6.697/(1+0.13)^1 = $5.920 |
Decision Tree
New Hotel Project in Seoul | Imposed Tax with 50% probability | Investment | $20million |
cash flow | $15.45 | ||
NPV |
($15.45-$20)/(1+0.13)^1 =-$4.027 |
||
No Tax imposed with Probability 50% | investment | $20million | |
Cashflow | $26.697 | ||
NPV @ Year1 |
($26.697-$20)/(1+0.13)^1 =$5.920 |
Expected NPV = 0.50× $(-4.027)+ 0.50×$5.920
= 0.947
If the tax is imposed, the NPV of the Project is negative hence rejected
Option for waiting 1year
= 0.50×($0)+0.50×$5.920 = $2.96million
The NPV of waiting 1year ($2.96million) is greater than going today with NPV ($0.947million) hence waiting for 1year and then proceed is much wise decision.