Replacing Links with Values in Excel

Replacing links with values in Excel is a very useful tool. On many occasions before sharing our workbooks with external parties we prefer to replace the links with values. Links can be tricky - links to other workbooks can be in formulas, names, charts, text boxes,...

IRR Calculation in Excel [video]

IRR calculation in Excel can be done very easily. It can be calculated using three different formulas – IRR, XIRR and MIRR. We have discussed the syntax and specific use of each formulas in a previous post. On the requests of our readers we did a video on IRR...

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...

Sign-up and Get Free Feasibility Reports

60 real-life feasibility study reports!