Deal Analysis Help for Rehab/Stabilization Period

[Daniel Johnson]

Hey, fellow investors! 

I am putting together my first multi-family deal and wanted to get some feed back on the best way to present the rehab/stabilization period to an investor? I have MANY multi-family spread sheets and not one of them has a section where you can account for the difference in monthly cash flow during the rehab/lease up time? 

Is it best to work out separate 12-month P&Ls to support the annual cash flow on the larger Excel templates? It seems that most spread sheets only calculate annual numbers which leave investors wondering how accurate the numbers are or more specifically in my case, will the cash flow will cover the debt service while the property is being rehabbed and released? 

Any feedback from general or limited partners would be much appreciated!