Hmmm... I might try. I don't know how easy it would be to do - I do most of them without much thought at this point, but I might try doing one slowly and consciously thinking about which ones I'm using!
Take a look at this one: ruclips.net/video/fV5Zon2OJw4/видео.html This talks about some more complicated debt modeling scenarios, but bit at the end about mortgage payments from first principles can also apply to modeling with variable rates.
Hi - I really enjoyed this video. do you perhaps have more problems like the above or similiar that i could model myself? or a a website where i could find them?
Hi Kaylin - the best I know of to get a lot of these is from the Financial Modeling World Cup website. They run monthly(-ish) competition with financial modeling case studies like this one that are designed to be doable in an hour or less by a good modeler, and all their past questions are for sale for $10 apiece (or various bundles). Each question includes the instructions, questions, answers, and a worked solution model, which is a great thing to learn from.
I'm not sure which bit of the video you're looking at, so I'm not exactly sure... but if I wanted to go to a cell 350 rows from where I was, I'd probably go to the address bar and type it in there (e.g. if it shows A7, then type in A357 and press enter). And any excuse to use SEQUENCE : )
You jumped when you were building the timeline. The EDATE function actually works really well for timelines. I think it might be even possible to make the time horizon a parameter, at least for small scale models. With the use of the new # operator and a lot of Offset() it is feasible.
Ah, OK - you can use the PgUp and PgDown buttons to jump up / down by a screen, and if you hold Alt with it, it jumps to the left or right instead. If you also hold shift, it expands the selection across from your starting cell too. I really wanted to build this model with the timeline coming fully from the variables, but unfortunately, I don't think it's possible (yet, at least). You can make just the timeline itself grow or shrink with a parameter - e.g. if I had put =EOMONTH(F5, SEQUENCE(, 120, , 3)) in F6, that would have given me 30 years of quarter end dates, and the 120 could be replaced with a variable - but to make the workings expand and contract in the same way is harder, because if you build a 'corkscrew' reference (row x refers to row y, which refers to the previous col of row x, and so on back) with dynamic arrays it treats it as an iterative calculation and runs very slowly. It would be a revolution for financial modeling if they could get that to work...
Is it possible that you make a video explaining which keyboard shortcuts you use? It's really impressive how fast you can format and fill the cells.
It is right unbelievable!
Hmmm... I might try. I don't know how easy it would be to do - I do most of them without much thought at this point, but I might try doing one slowly and consciously thinking about which ones I'm using!
can you one on modelling variable interest rate loans like LIBOR and SOFR?
Take a look at this one:
ruclips.net/video/fV5Zon2OJw4/видео.html
This talks about some more complicated debt modeling scenarios, but bit at the end about mortgage payments from first principles can also apply to modeling with variable rates.
Hi - I really enjoyed this video. do you perhaps have more problems like the above or similiar that i could model myself? or a a website where i could find them?
Hi Kaylin - the best I know of to get a lot of these is from the Financial Modeling World Cup website. They run monthly(-ish) competition with financial modeling case studies like this one that are designed to be doable in an hour or less by a good modeler, and all their past questions are for sale for $10 apiece (or various bundles). Each question includes the instructions, questions, answers, and a worked solution model, which is a great thing to learn from.
@@DimEarly Thank you appreciate your help
How do you jump exactly 350 cells?
And you could use the sequence function there, I guess 😇
I'm not sure which bit of the video you're looking at, so I'm not exactly sure... but if I wanted to go to a cell 350 rows from where I was, I'd probably go to the address bar and type it in there (e.g. if it shows A7, then type in A357 and press enter).
And any excuse to use SEQUENCE : )
You jumped when you were building the timeline.
The EDATE function actually works really well for timelines. I think it might be even possible to make the time horizon a parameter, at least for small scale models. With the use of the new # operator and a lot of Offset() it is feasible.
Ah, OK - you can use the PgUp and PgDown buttons to jump up / down by a screen, and if you hold Alt with it, it jumps to the left or right instead. If you also hold shift, it expands the selection across from your starting cell too.
I really wanted to build this model with the timeline coming fully from the variables, but unfortunately, I don't think it's possible (yet, at least). You can make just the timeline itself grow or shrink with a parameter - e.g. if I had put =EOMONTH(F5, SEQUENCE(, 120, , 3)) in F6, that would have given me 30 years of quarter end dates, and the 120 could be replaced with a variable - but to make the workings expand and contract in the same way is harder, because if you build a 'corkscrew' reference (row x refers to row y, which refers to the previous col of row x, and so on back) with dynamic arrays it treats it as an iterative calculation and runs very slowly.
It would be a revolution for financial modeling if they could get that to work...