Cases in Finance

Read the case “Ligthing the Way at the Manor House Hotel”, and calculate the present value among the four types of bulbs.Determine which bulb you would choose and why. The structure of the work will be built around the following elements:1. Excel table showing the calculation of the present values of the four alternatives as well as the assumptions taken2. Summary of the present values and choice of the bulbShow all your calculation.Be precise and provide numbers to support your analysis.Create a specific tab in your Excel file with only the final answers (i.e. the four present values and the bulb chose