Submission le format: Excel document with all the answers, clearly iden fying all four projects and showing the present values of the cash ows as well as explana ons when needed. Clearly provide all the assump ons which you take to solve this case.
For this Final Assignment (individual), the students must carry out the following work:
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 calcula on of the present values of the four alterna ves as well as the assump ons taken (20 pts each = total 80 points) 2. Summary of the present values and choice of the bulb (20 pts)
Show all your calcula on.
Be precise and provide numbers to support your analysis.
Create a speci c tab in your Excel le with only the nal answers (i.e. the four present values and the bulb chosen)
Case is attached with more files for more information.