Real Estate Developer (Financial Modelling in Excel)

Value added and opportunistic property investments are complicated both in their initial scope and in their cash flow projections. Development projects need greater analytical skills and flexibility and an ability to work with project partners at the same time. This course that Emagister offers in its catalog will show participants how to evaluate projects in Excel, integrate and communicate updates as they occur and, ultimately, understand how to transform an investment of opportunistic property into a central asset in which you can sell .

The residual models (benefit and site) are manifested first to illustrate the essential components of any scheme and traditional methods of evaluation, such as benefit / cost ratio, rental yield and interest coverage. Afterwards, development cash flows are constructed in detail taking into account, in particular, staggered revenues, as well as fixed, variable and incidental construction costs and their influence on net cash flow. Additional performance metrics are calculated, including targeted IRR and capital performance.

Financing for development can be more complex than simple senior debt investment financing. This is because finance is usually required in stages. The method demonstrated in the course is the simplest way to deal with the programmed functions of debt reduction and accumulated interest.