CAN YOU PLEASE DO IT AND SHOW IT IN EXCEL? THANK YOU!
The Lion’s Firm is considering buying a vacant lot that is selling for $1.5 million. It will take them two years to permit and construct a large retail center and will cost an additional $1 million in permitting and $2.5 million in construction. They anticipate an overall hold of 10 years including the permitting and construction time. Permitting will occur in year 1 at which time if the market has shifted, they can abandon the project without incurring the cost to construct but also not gaining any future cash flows. If they do abandon the project, they anticipate being able to sell the land with permits for $4.5 million at the end of year 1. Construction will occur in and placed into service by the end of year 2. If there is a shift in the market for retail space between purchase and start of operations (but after permitting) the after-tax cash flows would be $1,980,000 rather than the strong market of $3,300,000 for the remainder of the 10 years. They anticipate being able to sell the property at the end of the 10-year hold for an after-tax value of $60,000,000 if the market is good and $26,400,000 if the market is bad. There is 50% chance of a change in market (at any decision point, aka after permitting, at expansion option and at sale). Finally, assume if there is no option to abandon or delay the project, but that the company has the option to expand the facility at a cost of $2 million in year 3. If the market is good the net present value of developing this additional property (as of t=3) is $4 million, but if the market is bad then the net present value of development would be $1 million (so it wouldn’t make sense to expand). The Lion’s Firm has a discount rate of 12%.
Find the value of the real option for both market conditions and state if the project should be accepted.
Find the value of the abandonment option under both market conditions and if they should choose to abandon the project rather than proceed with construction. (Assume you will only abandon is the market has already shifted at end of permitting).
Find the value of the expansion option and the state if the expansion should occur.
CAN YOU PLEASE DO IT AND SHOW IT IN EXCEL? THANK YOU!
The Lion's Firm is considering buying a vacant lot that is selling for S1.5 million.It will take them two years to permit and construct a large retail center and will cost an additional s1 million in permitting and $2.5 million in construction. They anticipate an overall hold of 10 years including the permitting and construction time.Permitting will occur in year 1 at which time if the market has shifted, they can abandon the project without incurring the cost to construct but also not gaining any future cash flows. If they do abandon the project, they anticipate being able to sell the land with permits for S4.5 million at the end of year 1. Construction will occur in and placed into service by the end of year 2. If there is a shift in the market for retail space between
$1,980,000 rather than the strong market of $3,300,000 for the remainder of the 10 years.They anticipate being able to sell the property at the end of the 10-year hold for an after-tax value of $60,000,000 if the market is good and $26,400,000 if the market is bad. There is 50% chance of
Finally,assume if there is no option to abandon or delay the project,but that the company has the option to expand the facility at a cost of $2 million in year 3. If the market is good the net present value of developing this additional property (as of t=3) is $4 million, but if the market is bad then the net present value of development would be S1 million (so it wouldn't make sense to expand.The Lion's Firm has a discount rate of 12%.
Find the value of the real option for both market conditions and state if the project should be accepted. Find the value of the abandonment option under both market conditions and if they should choose to abandon the project rather than proceed with construction.(Assume you will only abandon is the market has already shifted at end of permitting). Find the value of the expansion option and the state if the expansion should occur.
