Corality

Blog

filter post by
Showing all blog

DSRA – Debt Service Reserve Account

The debt service reserve account (DSRA) works as an additional security measure for lenders. It is generally a deposit which is equal to a given number of months projected debt service obligations. This tutorial explains how to code a transparent and efficient DSRA, and how it is linked to the financial statements without circular references.

Learn More

Calculate NPV without Excel functions

Net present value (NPV) is a standard method of using the time value of money to appraise long-term projects and investments. This tutorial will discuss the principles of NPV calculation and the discount rate and, in particular, highlight how to calculate NPV without using the built-in functions in Excel. This achieves greater transparency and reduces the risk of errors.

Learn More

Working capital – financial modelling of trade debtors and creditors

It is important to recognise the trade debtors and trade creditors in a cash flow financial model because they capture the cash cycle of a company. This is important since not all revenue earned in a given period is received in the same period, and that not all costs are paid as soon as they are incurred.

Learn More

Financial modelling - Global infrastructure boom drives increased risk

The global surge of activity in the infrastructure sector has been very happily regarded by many people, including us here at Corality.

Learn More

Stop the guessing game: Intuition vs robust analysis

Do you trust your financial model to provide a good representation of your business? Don’t leave it up to intuition to guide decision making. Download “A strategic planning process for confident decisions” to align your financial model with strategic objectives.

Learn More