please show how to do 4 IN EXCEL

What is the likelihood that this investment will have a positive NPV? Assume that the S450 million expense of building the hotel can be written off straight line over a 30 -year period (the other $150 million is for the land which is not depreciable) and that the present value of the hotel's terminal value will be $200 million. 4. Conduct a sensitivity analysis for a project with the following characteristics. Each parameter can take on any of three different values but once a parameter value is selected, that value remains constant for the 10 -year peribd. The discount rate is 10% and the project life is. 10 years. Ignore taxes and depreciation. 5. American Fruit C. is considering constructing a new plant to process frozen fruit juices One plant would be capital intensive. the other much more labor intensive. Although the final decision would hinge on the relative cosi of capital versus labor in the northern What is the likelihood that this investment will have a positive NPV? Assume that the S450 million expense of building the hotel can be written off straight line over a 30 -year period (the other $150 million is for the land which is not depreciable) and that the present value of the hotel's terminal value will be $200 million. 4. Conduct a sensitivity analysis for a project with the following characteristics. Each parameter can take on any of three different values but once a parameter value is selected, that value remains constant for the 10 -year peribd. The discount rate is 10% and the project life is. 10 years. Ignore taxes and depreciation. 5. American Fruit C. is considering constructing a new plant to process frozen fruit juices One plant would be capital intensive. the other much more labor intensive. Although the final decision would hinge on the relative cosi of capital versus labor in the northern