by Naiyer Jawaid | Oct 5, 2015 | Excel, Finance, Formulas
Have you ever wondered how does Excel calculate irr (internal rate of return)? I never gave it a second thought until I wrote a post on the issues with NPV calculation in Excel. Our reader, Deyan, pointed out that... by Naiyer Jawaid | Aug 19, 2015 | Excel, Finance, Formulas
Future value calculation in Excel can be done either by using Excel FV formula or by manual calculation. Before we get into the calculations, let's review the concept of future value. We have discussed the time value of money earlier.... by Naiyer Jawaid | May 24, 2015 | Excel, Formulas
Excel Round Functions are used on daily basis by every Excel users. In this post, we will discuss various Excel round functions, their syntaxes, and their uses. You can download the Excel workbook from the link at the bottom which... by Naiyer Jawaid | Apr 20, 2015 | Excel, Finance, Formulas
Cash flow forecast is an important component of project finance modeling. Properly done cash flow forecast enables the firm to manage its fund and search for external funding in case of shortage. As the project progresses, we update the projections... by Naiyer Jawaid | Aug 18, 2013 | Excel, Finance, Formulas
A loan amortization schedule in Excel can be created either by using a template or creating a custom schedule - the easiest method will be using the template which is already in your Excel package. Alternatively, we can create a...