filter post by
Showing all blog

Excel Keyboard shortcuts – download your Excel shortcuts PDF

In the world of financial modelling, you simply cannot survive without Excel keyboard shortcuts. To assist Excel users, Corality has compiled a list of productivity increasing Excel shortcuts.

Learn More

Financial modelling of stockpiles in a mining project

For many mining projects, the open pit/cut mining process often begins months or even years before the milling plant starts operating. The build-up of stockpile requires careful treatment to ensure the right grade of the ore milled is modelled and that the right value of this stockpile is reported on the balance sheets.

Learn More

EXCEL 2007 VS. 2010 – WHAT’S NEW?

Excel 2010 comes with a number of key improvements – high performance computing, increased row limits, improved statistical functions, and more powerful data analytics with PowerPivot and Slicer. Microsoft Office 2010 was released in April 2010, and was available for purchase from June 2010. We have compiled a list of the key improvements implemented in Excel 2010.

Learn More

Limitations of the IRR function

The IRR Excel function is appropriate for calculating returns of venture capital and other private equity investments which are characterised by several cash injections throughout the project, with one substantial payoff at the end in the form of either an IPO or M&A.

Learn More

Terminal value calculations in a financial model

Terminal value is the value of a project’s expected cash flow beyond the explicit forecast horizon. An estimate of terminal value is critical in financial modelling as it accounts for a large percentage of the project value in a discounted cash flow valuation. This tutorial focuses on ways in which terminal value can be calculated in a project finance model.

Learn More