Read the case “Lighting 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.
1. Excel table showing the calculation of the present values of the four alternatives as well as the assumptions taken
2. Summary of the present values and choice of the bulb
Use the excel template provided