Hey! I am working on an excel model where i want to be able to compare the returns from different retirement insurances where I want to be able to calculate the returns based on a few different variables.
Lets say I have the underlying amount of $1000 with
1) Expected to grow at 5% per year
2) Annual management fees of 0,5%
3) X amount of years until payout starts
4) Payout for X amount of years
This was quite easy to build, however I have no idea how to structure my sheet if i want to build a dynamic model where i can easily change the inputs. Does anyone have an idea of how to proceed?
Lets say I have the underlying amount of $1000 with
1) Expected to grow at 5% per year
2) Annual management fees of 0,5%
3) X amount of years until payout starts
4) Payout for X amount of years
This was quite easy to build, however I have no idea how to structure my sheet if i want to build a dynamic model where i can easily change the inputs. Does anyone have an idea of how to proceed?