Diving deep into the month by month numbers

[Maxwell Manatt]

Hey BP,

Does anyone have a Monthly P+L/budgeting template they use for underwriting bigger value add apartment deals they would be willing to share?

Have an accepted LOI on a 46 unit apartment building. The value add will be mostly in increasing the projects occupancy from low 70s% to market occupancy (about 94% physical, 91-92% economic). We have budgeted a Capex assumption and have solid working year 1 Opex developed with our property manager.

But I want to create a Month by month budget for the first year incorporating our construction project timeline (wll be developed during due diligence) and the Expiration schedule on the leases. We will raise 9 months of principle and interest reserves (along with the funds to close and Capex) but I want to have a clear picture of what each month will look like so we can plan for any weak spots up front.

I am not an Excel wizard so if anyone has a tool they can share for this type of budgeting that would be spectacular. 

Thank you!