Construction / Development Financial ModelDevelopment & Construction Model presents the case where a property with multiple residential units is constructed and subsequently rented for several years before the property being sold. The model generates cash flows an a project and equity basis and also calculates the relevant metrics (cash on cash, Internal Rate of Return, net present value, loan to value, debt yield, coverage ratio and DSCR). The financing options for the project include equity

For the forecast years a series of growth rates needs to be filled such as gross loans

including the income statement

The regulatory capital assumptions are calculated below along with their respective ratios CET1

- Costs (Variable and Fixed)

various charts

The way to proceed with the worksheet is to fill the yellow tabs first starting from leverage

Finally the last tab ensures that everything in this model is working as it should

investments

cash inflows

as well as your other operating costs for the next 5 years

and premium content

the user will also need to set the sensitivities steps