Life Cycle Costing-2: A Practical Project Feasibility Example

In an earlier simpler example ,we have worked out the PV (Present Value) of two  possible cash flows for decision making.
The example presented in this blog further works out two scenarios side by side and calculates the Payback period of an expenditure as well. As usual, one need to consult Subject Matter Experts and get the advise on the inputs.

Problem Statement

Decision is required whether to replace Sodium Vapour  Lights with LED Lights.

Cash Flows are created on the basis of expert inputs which may be provided or obtained from Facility Management, Procurement and  Electrical Engineering Departments. Risk Management part may also be deliberated  with Accounts, Finance and Legal Departments and can also be reflected into the cash flow.
The Excel workbook has been set in  a user friendly setup and may be understood by even a casual Excel User.

The following risk factors (not covered in the simulation) are also worth considerations/ evaluation. The scope of analysis should further be extended for a full scale Cradle to Grave and Cradle to Cradle LCA.
Performance Risks: Measurable performance requirements are required to be fixed during the procurement process. Like, “the Lux levels after the 3 year warranty period shall be more than 95% of the initial performance and power consumption during the warranty period shall not be more than 2% of the rated power”
Financial Risks: These can be mitigated by asking the contractor to provide The Facility Management  an FD or BG for the claimed warrantee period.
You might also like to consider our risks against accidental breakages and or thefts etc. Please discuss if any other consideration/ risk omission should be included in the excel simulation.


  1. Dear Ashutosh
    I navigated to the blog through address given in your mail. I am truly impressed by what you do. Please do keep it up. However life never poses such simple questions and one is forced to make or take decisions while being on the go. Not the the right thing but that is how currently the sector is structured.
    Keep it up!

    1. Thank You Sir for encouraging me.
      I am trying to address (i.e. Simulate) all possible situations in my ensuing blogs. Your comments and suggestions would be most helpful and provide the conversation the right direction.

  2. The content you've posted here is fantastic because it provides some excellent information that will be quite beneficial to me. Thank you for sharing that. Keep up the good work. LED Corn Bulb

  3. When selecting a machine that claims a excessive payout proportion, look intently at the commercial earlier than sitting down. More than likely, the "looser" machines that truly pay the 98% will not be recognized. To enhance your probabilities of finding them, ask 1xbet a casino flooring attendant for assist to seek out|to search out} out which machines are native participant favorites. On video slots, you should push two buttons to complete your guess. First, push one button for the number of paylines you want to activate and then push a second button to selected quantity of} credit you need to guess per line.


Post a Comment

Popular posts from this blog

Application for Making Parabolic Camber Board

Using Excel conditional formatting for comparative statements