Hi Stefano, Whether you're right or wrong, there's never a need to apologise. I agree the formula looks wrong and yours looks right (although I mi...
Hi Stefano, Thanks for your query. I am sure the Excel file would help! Once our technical team returns from the seasonal break, I will add it to...
Thanks for your reply Stefano. Unfortunately, debt models are often very specific as they are modelled for precise conditions in debt term sheets. H...
Hi Stefano, Thanks for the question. The model is describing two types of COGS - that which represents the physical inventory being utilised for p...
You're welcome - enjoy the course! L
Hi Stefano, I am glad you are finding the course useful. "Reporting Month Factor" is an interesting element. It's essentially an interim calc...
I am sorry but if you are on a Mac, it's not available for a Mac. Excel and Mac are not best friends!
Hi, this is SumProduct. I'm afraid we don't understand the question. Can you please be more specific what you are referring to? Thanks.
Actually, the course does give this. You use the Second Monthly Example from the Working Capital Adjustments file. You either use the Simple Grid Met...
The answer to the first is, it depends on how complicated it is. There are pro's and con's. If it's simple, I would probably build it in the same mo...
This is getting a little outside the scope of the course. I have provided a simple illustration of formulae in good faith (attached).
Now I see. Take a look at cell I330 in the two models. In the Final Model, it has the formula =I332, whereas yours is understandably blank. Put thi...
I am sorry, but I don't have your model to compare against.
When you complete the model and put the opening balances back in, the results should cascade through and provide (40) - at that point. If your model ...
Thanks for your query Alison. I think with regard to your first question, you are comparing your "work in progress" (WIP) result with the final val...