Tutorials

The Debt Service Reserve Account provides additional security for lenders as it acts as a cash buffer during periods of weak cashflows.

Debt Sculpting is a commonly used term in project finance.

Stand Alone Cash Sweep Introduction

Stand alone cash sweep analysis is an alternative metric for refinance risk and repayment ability in cashflow models for project finance.

CFADS introduction

A project’s Cashflow Available for Debt Service (CFADS or CADS) is analysed by project lenders (senior debt banks) to determine debt sizes and repayment criteria.

Customizing number formats can be very useful in helping you control the appearance of numbers, dates, and text in cells.

In this tutorial, we look at the important uses of the OFFSET function, e.g. scenario-based modeling. However, we also examine modelling risk and some alternatives to the OFFSET function.

The Styles shortcut (Alt + ‘) is a popular shortcut for many Excel users. To their frustration and grief this shortcut was removed from Microsoft Excel 2007 and 2010.

One function in Microsoft Excel that calculates the IRR is the IRR function.

Range names are a useful tool in Excel that allows you to assign a name to a single cell or a range of cells.

In Excel you can perform some powerful and useful operations using array formulas.

Goal Seek is a very powerful tool in Excel for finding break-even points or to perform tailored what-if analysis.

Net Present Value (NPV) is a standard method of using the time value of money to appraise long-term projects and investments.