scenario analysis
1 Topic
What If Investment Cost Subsidy and IRR
Hello, I am looking to create a dynamic tool that allows the user to decide how much subsidy to provide and generate a revised IRR. I'm not sure how to use a measure to create this calculation so it's dynamic. I need Subsidy to be changable by the user. Here is an example: Subsidy 500 Project Year CF CF + Subsidy Project IRR A 1/1/2021 -1000 -500 A 60% A 1/1/2022 350 350 B 32% A 1/1/2023 250 250 A 1/1/2024 450 450 A 1/1/2025 500 500 B 1/1/2021 -5000 -4500 B 1/1/2022 1000 1000 B 1/1/2023 2000 2000 B 1/1/2024 3000 3000 B 1/1/2025 4000 4000 Thanks!Solved886Views0likes1Comment