Select Page

## How Does Excel Calculate IRR?

Have you ever wondered how does Excel calculate internal rate of return (IRR)? I never gave it second thought until I wrote a post on the issues with NPV calculation in Excel. Our reader, Deyan, pointed that similar type of issue can exist with the IRR calculation in...

## NPV Calculation in Excel: Why the Numbers do not Match!

NPV calculation in Excel can be tricky. I have written few posts on this subject – NVP & IRR – Key Metrics of a Feasibility Analysis and Net Present Value and Returns to the Equity Holders. I recommend that you read them too. The basics of net present value...

## Future Value Calculation in Excel

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. To remind ourselves, the basic...

## Excel Round Function: All You Need to Know

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 uses. You can download the Excel workbook from the link at the bottom which contains the examples of Excel round...

## Cash Flow Forecast: Adjusting for Actuals

Cash flow forecast is an important component of the 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 for the actuals...

## How to Create Loan Amortization Schedule in Excel?

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 custom loan amortization schedule using... WAIT
I have a FREE gift for you

Do you want FREE Beginners' Guide to Real Estate Financial Terms?