Implementing the Dynamic Salary Model - The Depth of a Financial Model скачать в хорошем качестве

Implementing the Dynamic Salary Model - The Depth of a Financial Model

Implementing the Dynamic Salary Model Part of the lecture series "The Depth of a Financial Model": https://nickderobertis.github.io/fin-... Full Course Website: https://nickderobertis.github.io/fin-... Notes -------- We are building this model from scratch as it is so different from the original We can break this larger problem down into three sub-problems: determining salary over time, determining wealth over time, and determining when the individual can retire. Each of these become worksheets in the model In the overall inputs, it is good to have sections if inputs are relevant only to individual sub-problems. Also reference over the inputs onto the individual sheet for both visual organization of having everything for the calculation on one sheet as well as keeping cell references shorter =IF and =MOD combined can figure out whether it is a promotion year A cumulative sum can be used to determine how many promotions have occurred up until a given point in time Calculating factors helps split out the calculation and make it more clear Resources ------------ Dynamic Salary Retirement Model - Excel: https://nickderobertis.github.io/fin-...