Solar+Roof+top+model+that+uses+date+functions+to+work+through+portfolio+of+projects+with+different+construction+and+operation+timing

=== || Home Book Modelling Exercises Example PF, Corporate, M&A, Real Estate and Banking Models Renewable Energy Analysis Testimony Electricity Pricing Excel Utilities Case Studies Updates || ===

One of the difficulties in real world modeling is incorporating a portfolio of projects with different construction periods, start dates, retirement dates and financing periods.

I have tried alternative methods to model this issue and I think the best answer is a function that computes the percent of a period that a project is alive (under construction, in operation, repaying debt etc.). This function requires a common time period and then a start date and an end date for every project. I think it is much better than the alternative of using data tables.

The function is also documented in the function library.