How to Calculate NPV, IRR & ROI in Excel -- Net Present Value -- Internal Rate of Return
Bodmer E. Corporate and Project Finance Modeling: Theory and Practice
Wiley, Apress, However, while many business professionals are familiar with financial statements and accounting Financial Modeling is now the standard text for explaining the implementation of financial models in Excel. This long-awaited fourth edition maintains the "cookbook" features and Excel dependence that have made the previous editions so popular. As in previous editions, basic and advanced models in the areas
By Dheeraj Vaidya Leave a Comment. Top Books. Fundamentally, project finance is concerned with identifying the specific financial requirements of a project, sourcing funds, entire financial structuring, assessment of different types of risks and addressing any legal, industrial and financial issues arising therein with the sole intent to ensure smooth functioning of a project. Here, we have compiled a careful selection of titles on project finance designed for professionals as well students to help acquire a greater understanding of the theory and practice of project financing and difference in risk structuring and other aspects in keeping with the nature of industry and other defining factors. A highly commendable reference work for professionals which lays bare the fundamentals of project financing along with the tools and techniques involved. The author maintains a clear balance between the theory and practice of project finance while providing useful information on legal and contractual issues, valuation methods and hedging of financial risk among other aspects to help enhance understanding of the subject. What brings added relevance to this work is the skilful manner in which author elucidates several key concepts related to project financing without focusing on any specific industry thus widening the scope of application for these broad-based principles.
This page includes project finance related excel files and videos that allow you to learn how to build a project finance model. Whilst I can tell you without any question at all that in-person courses are much, much, much better than on-line videos as a way to learn, I have included sets of videos and exercises that allow you to understand various basic and advanced issues. PPA] contract. The difficulty in project finance models often arises from financing and many of the exercises deal with financing issues including cash flow waterfalls, debt repayment structuring, debt sizing, interest during construction, fees, reserve accounts, cash flow sweeps and covenants. Project Finance Theory and Marriage Contracts. The files and videos are arranged by different subjects and different levels of complexity. Separate sets of videos and analyses are presented for:.
Financial Models Standard and Poors A good financial model should: Be relatively simple Focus on key cash flow drivers Clearly convey assumptions and conclusions. Alternative Models Back of the Envelope Quickly run the impact of an acquisition on debt service coverage Sensitivity of earnings to commodity price swings. Deterministic Set a number of assumptions and translate into financial ratios and cash flow. Stochastic Develop a range of possible inputs using Monte Carlo simulation. Used where there is a good and predictable history for value drivers. Basic Objective Measure whether the expected returns are worth taking the risk Models must be able to somehow measure risk to be effective. Objectives of Project Finance Modelling Valuation The basic objective of project finance is obviously to evaluate whether the project works whether the benefits of the project outweigh the costs of the project.