Q&A

I've been increasingly interested in how we can use Dynamic Arrays in our models to achieve timeline flexibility. This is especially useful for charts.

Hi, Kenny! First of all, thank you so much for all your resources, this is truly amazing! Now, I am struggling to edit the productivity pack excel - I honestly just want to change the import and export font color, but whatever I change in the file it won'

Hi Kenny, so what are some ways to upstream cash when there is that cash trap due to the difference between net income and cash flows? Jason Hi Jason, Trapped cash is a common issue in Project Finance Models. There are a few options that are typically used to address

Please could you explain the meaning of a "reasonable arms-length interest rate" test and how this differs to other possible tests? I can't see this detail covered anywhere. Many thanks in advance. David Hi David. Thanks for the question. Let me start by saying I'

Hi Kenny, I can successfully create links for "Compound degradation" and "seasonality adjustment". However, in both cases, when I click Ctrl + Shift + a, the macro only copies across the next two columns (which are the constant and unit columns). When I enter the formula for electricity

Hi Kenny, First of all thanks a lot for this great course, already of great help in better understanding and reviewing models! I have a practical question, when using comments mine are turning the cell bright green (placing a comment with Ctrl + Alt +q). Is there a way to avoid

Hello, I thank you very much for your work teaching us with great precision the financial modelling tools. I have a question : The initial RCF balance is currently 0 in the model, but if I put an initial RCF balance of 10,000, then it will have an imbalance on

Hello there, My understanding of degradation is that the first year we operate at 100% capacity and then we loose each year the percentage capacity that is in cell F10. If this is correct i came up with another formula: J12*(1-(J11-1)*$F$10) So this basically is the

"You used ctrl+x to cut the Annual Real O&M cost input from the bottom of the sheet, how do you go about pasting this in above?" - Angus

Hi there! Thank you for sharing this and giving us options to change keystrokes. However, I'm wondering if it's possible to change color code? For example, I would like my numbers imported from other worksheet to be green. I guess I only need to change color