Pro Forma Template - Small Apartments v7

Category: Spreadsheets
Size: 7 MB
Uploaded by: Tiny 1400602323 avatar oracleofmn Phil C.
Time uploaded: over 6 years ago
Downloaded: 5897 times
File Type: Spreadsheet

Updated from v6

Download File

Disclaimer: Safety of files uploaded to the BiggerPockets FilePlace cannot be guaranteed. Download at your own risk.

Rating: 5


  • No avatar

    A solid model, thanks

    Nick Patrick, 2 months ago  

  • Small 1431557165 avatar jrussell999

    This looks very cool, but do you think you could make a version that doesn't use array formulas and data tables? Most people don't know how to deal with those.

    Most people also don't know how to change the calculation mode (because those data tables take a solid 30 seconds to calculate with every change), and even if they did, forgetting to change it back is such a huge potential problem that I would be reluctant to share this file with anyone who isn't an excel whiz.

    I've worked as a data analyst for several companies, helping regular excel users with their excel and VBA needs, and one thing I've learned is that simplicity is a virtue.

    This is obviously a very sophisticated tool, and it will help me greatly in my quest to learn real estate investment analysis, so thank you for that. I just think it's a step away from being truly great.

    Here's a great explanation of how (and why) to make your excel files calculate faster:

    Josh Russell, over 1 year ago  

  • Small 1399735564 avatar hearkevin

    New at this so this is great. One question, why is telephone over $1000 a month?

    Kevin Breslin, about 4 years ago  

  • Small 1399735041 avatar gpflanigan

    This is an excellent model. It needs some minor changes including adding line item for reserves and replacements. Also the statement of cash flows could be expanded to include cap ex from investment and disposition events

    George Flanigan, about 4 years ago  

  • Small 1493816089 avatar bamavestor

    Wow!! Thanks for sharing!

    George Gray, over 5 years ago  

  • Small 1399528344 avatar tpnorway

    Great model

    Truls Porter, almost 6 years ago  

  • Small 1448397352 avatar bryanhancock

    The model keeps getting better and better Phil!

    Bryan Hancock, over 6 years ago