At F31, we are a team of passionate enthusiasts. Our interests range from the latest Microsoft technologies, Excel financial modelling, and Power BI interface design…
Excel Functions to Calculate NPV and IRR The Net Present Value (NPV) and the Internal Rate of Return (IRR) are crucial criteria for making investment…
Like the capitalisation method, DCF valuation is one of the so-called ‘income’ methods. Its use requires a greater number of parameters to be introduced into…
Capitalisation methods estimate the value of an asset (V) by dividing the rent (R) by a rate, or yield (Y), which amounts to capitalising to…
According to the comparison method, to calculate the value of a property asset (V), one should simply multiply two parameters: the surface area of the…
Are you about to create a Power BI dashboard but unsure where to begin? Have you already developed a Power BI report but feel dissatisfied…
Why financial statements are hard to build in Power BI? Power BI is an amazing tool to shape and visualise data. While it’s easy to…
Excel is often our first choice for addressing business needs. However, did you know that the Power Platform has significantly expanded the range of tools…
