# LIGHTING THE WAY AT THE MANOR HOUSE HOTEL

Open Posted By: surajrudrajnv33 Date: 15/09/2020 High School Proofreading & Editing

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

Category: Mathematics & Physics Subjects: Algebra Deadline: 12 Hours Budget: \$100 - \$150 Pages: 2-3 Pages (Short Assignment)

## Summary of Present Values

 Summary of Bulb Choices Options: Present Value: Choice number Philips 60 Watt Equivalent Incandescent Philips 60 Watt Equivalent Twister CFL Philips 60 Watt Equivalent LED 19A Cree 60 Watt Equivalent LED

## PV Calculations

 Finance Case Study Philips 60 Watt Equivalent Incandescent Philips 60 Watt Equivalent Twister CFL Philips 60 Watt Equivalent LED 19A Cree 60 Watt Equivalent LED Period Year Electricity Cost Cost of new bulbs Replacement Cost Total Annual CF Discounted CF Period Year Electricity Cost Cost of new bulbs Replacement Cost Every 12 years Total Annual CF Discounted CF Period Year Electricity Cost Cost of new bulbs Replacement Cost Every 24 years Total Annual CF Discounted CF Period Year Electricity Cost Cost of new bulbs Replacement Cost Every 24 years Total Annual CF Discounted CF Present Value over 24 year period \$0 Present Value over 24 year period \$0 Present Value over 24 year period \$0 Present Value over 24 year period \$0 1 2013 1 1 2013 1 1 2013 1 1 2013 1 2 2014 2 2 2014 2 2 2014 2 2 2014 2 3 2015 3 3 2015 3 3 2015 3 3 2015 3 4 2016 4 4 2016 4 4 2016 4 4 2016 4 5 2017 5 5 2017 5 5 2017 5 5 2017 5 6 2018 6 6 2018 6 6 2018 6 6 2018 6 7 2019 7 7 2019 7 7 2019 7 7 2019 7 8 2020 8 8 2020 8 8 2020 8 8 2020 8 9 2021 9 9 2021 9 9 2021 9 9 2021 9 10 2022 10 10 2022 10 10 2022 10 10 2022 10 11 2023 11 11 2023 11 11 2023 11 11 2023 11 12 2024 12 12 2024 12 12 2024 12 12 2024 12 13 2025 13 13 2025 13 13 2025 13 13 2025 13 14 2026 14 14 2026 14 14 2026 14 14 2026 14 15 2027 15 15 2027 15 15 2027 15 15 2027 15 16 2028 16 16 2028 16 16 2028 16 16 2028 16 17 2029 17 17 2029 17 17 2029 17 17 2029 17 18 2030 18 18 2030 18 18 2030 18 18 2030 18 19 2031 19 19 2031 19 19 2031 19 19 2031 19 20 2032 20 20 2032 20 20 2032 20 20 2032 20 21 2033 21 21 2033 21 21 2033 21 21 2033 21 22 2034 22 22 2034 22 22 2034 22 22 2034 22 23 2035 23 23 2035 23 23 2035 23 23 2035 23 24 2036 24 24 2036 24 24 2036 24 24 2036 24

## Variables

 Light Bulb Specifications Philips 60 Watt Equivalent Incandescent Philips 60 Watt Equivalent Twister CFL Philips 60 Watt Equivalent LED 19A Cree 60 Watt Equivalent LED Cost Per Bulb Rated Lifetime (hours) Annual Hours Initial Quantity of Bulbs needed Wattage Annual Cost of electricity Bulb Replacement Labor Cost Inflation ROR Energy Cost Calculation

## Assumptions

 Assumptions taken for solving this case

&"Times New Roman,Normal"&12&A

&"Times New Roman,Normal"&12Page &P