Supporting Green Decisions With Financial Simulations
Sustainability is the idea of which the time has come. In earlier posts Decision Making Through Life Cycle Costing- A Simple Practical Example and Life Cycle Costing-2: A Practical Project Feasibility Example
Solutions were worked out with side by side generating the cash flows and evaluating the Present Worths of the two alternate cash flows.
The life now is not as simple as say a decade ago when the above solutions were evolved and accepted. The clients are more demanding and we have numerous options & better software tools. Most importantly passionate green professionals have to strive and inch all solutions towards sustainability.
FOCUS: Supporting Green Decisions With Financial Simulations
Problem Statement: To generate and present numerous scenarios for supporting a greener solution.
Taking our requirement for thermal comfort, say we have Air Conditioning procurement options for 3 to 5 star rated machines and we also have choices for types of insulations for energy savings.
A word of caution as usual: All outputs are as good as the inputs and processes.
The excel file is macro free. To Download Please click the link below.
The following required Excel skills are intuitive and can easily be learnt.
- Creating Scenarios
- Showing Scenarios
- Scenario Summary
- Conditional Formatting