Financial Modelling Handbook

Topic

Q&A

In these Q&A posts, I answer questions from Handbook readers and financial modelling course students

Q&A: Ctrl+z undo after using macros / Excel Calculations no longer work / Selecting cells

Hi, I would like to know why my undo shortcut (ctrl + z) is not working after doing the ctrl + shift + A. Is it because it's working as a macro so undo shortcut wouldn't work afterwards? Is there any solution to that? Thank you! Weile Hey Weile.

Q&A: What to do if Control+Shift+0 is not working to unhide columns

We like to be able to hide unused columns at the end of the model timeline. If we need to change the timeline we want to be able to easily unhide columns again. The Excel keystroke to unhide columns is Ctrl+Shift+0. Many users find that this does not

Q&A: How to calculate period interest rates

Hi Kenny. Many thanks for this incredible material. I've got a doubt regarding the calculation of the quarterly interest. I thought that the conversion from annual interest to a smaller period interest shouldn't be just a division. I thought that you should always consider the time

Q&A: Row anchoring in calculations

Hello Kenny, While calculating the electricity generation revenue, why did we not fix the complete cell reference for power tariff and units in thousand and instead just fixed the column reference? Why didn’t we use $F$29 instead of $F29? Thanks, Shreyal Hi Shreyal, is a great question. It

Q&A: Including capex in IRR calculation

Hello Kenny, What about calculating IRR / NPV when the investment (CAPEX) is spread over several periods? Does it make sense to discount the CAPEX? I would think it doesn't, because if you commit CAPEX to project (solar PV plant in this case), you cannot use committed capital. So