How to reduce Excel file size

Sometimes the models we build in Excel can be large and complex. Much of this will be necessary and outside your control. There, however, are a few causes of unnecessary file size bloat that you can and should manage.

Update: It's all about the system.

Dear friends, Many thanks for continuing to follow me on the journey of putting this book together. Over the last week or two, I've been thinking about what makes this book different from others out there. And I think it's this: a focus on teaching modelling

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

Progress report

Our relocation is complete!

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

The critical last step: The Model Release Checklist

Now that you have finished building your model, it's time to undertake some final checks. This is a critical step before releasing a model. Omitting this step can be costly.

Revolving credit facility

Throughout the model build process, we have set up our model to react in a way that pre-supposed we are before the transaction date. If we change the tariff and resolve the model, we’ll get a different IRR and debt amount. We are sculpting the ratios to hit a

Modelling a refinancing - retesting our hypotheses

With our early share capital redemption structure in place, we can now test our hypothesis about refinancing. The reference file for this bonus chapter is available in the file pack you'll receive when you purchase the handbook. See file 4.61 FMH early BEG 01a. Running our 10

Early share capital redemption

Extracting trapped cash from the business