Advice on spreadsheet building for portfolio analysis
I have a portfolio of multiple investments that are industrial warehouses and retail. I was wondering if anyone knows of templates or websites I can look for that can help me build cashflow projections. Trying to consolidate them onto one spreadsheet that gives me a big picture of the portfolio's health.

If you had a portfolio of different assets, what would you want to know and what kind of spreadsheet would you build?
[{"id": "gmzi0ra", "text": "Commenting because I just did a similar post looking for a forum to run industrial proformas. hopefully you get some options on a spreadsheet or software.", "replies": [], "depth": 1}, {"id": "gmziyga", "text": "Check out adventures in CRE. They have a number of models you should be able to use. Some may be overly complex but the mechanics are there. \n\nBasic build should be something like this:\n- Assumptions Page: equity, debt, returns summary, other assumptions for your portfolio like corporate cost, JV structure if any and taxes\n- Tenancy Schedule: per tenant, rent, rent dates, rent free, indexation mechanics, service charge, etc. \n- Business Plan Assumptions: capex for existing tenant, future leasing assumptions (capex amount and duration, void period, rent free, ERV, etc.) \n- Individual Proforma Cashflow \n- Portfolio Cashflow roll up\n\nDifferent levels of complexity depending on your needs but understand the mechanics and you can do whatever you want.", "replies": [{"id": "gmzq4f5", "text": "Thanks for this info. Can you elaborate on what you mean by individual proforma cashflow and portfolio cashflow roll up?", "replies": [{"id": "gn01jwr", "text": "Sure.\n\nYou mentioned you had multiple investments in warehouses and retail. Each asset will be different from the other; one may have a long term lease on it that will self operate (i.e. no management involved in the near term), one may have a lease expiring in 6 months, one may be vacant and require capex. Each asset has a different business plan (some call it underwriting assumptions). You need to be able to look at the cash flows on each individual property to understand where the pinch points are in your portfolio and where your attention is required. What years does income drop? When am i spending capex? Ask your self these questions to understand what can happen to your assets and portfolio. The templates from a.cre should have the line items (e.g. revenues, costs, net income, etc.) you are looking for to build a cash flow. \n\nThe portfolio roll up is just adding up the individual cash flows to a portfolio cash flow. \n\nAcross your assets and their asset life cycles you'll either see your portfolio cash flow be stable or quite volatile. Broadly speaking there are three life cycles: 1) value-add (i.e. major refurb or development), 2) core (i.e brand new asset post development or refurb on long term lease in best possible location), 3) in-between the two (i.e. needs some capex but not quite yet or there's some income left for another c.4 years but can't be considered core). If you\u2019re a value-add player then you basically buy a plot of land or run down asset, fix it, and flip it. Short term hold and higher profit because you're taking huge risk. Core players will hold it for longer: will buy in better locations, less risky, longer income. You can build a portfolio on either strategy. Manage your portfolio by spreading investments across those strategies will  likely yield a more stable cash flow. A bit about portfolio theory but I have no idea how you're managing your portfolio. \n\nLet me know if that's the answer you were looking for.", "replies": [{"id": "gn2qeno", "text": "Got it. Thank you so much for this explanation.\n\nI think the roll up part is where I'm looking for advice on how to build. If I build a master spreadsheet, with each asset proforma how the roll up cashflow should look. Same as each asset proforma?\n\nWe have owned the warehouses since the 80's and owned outright. Major capex improvements are being done for one right now (roof, siding, windows) and the retail is with partners. Retail is fairly new but TI's are the only budgeted items for now. But yes, understanding this and knowing our total cash flow is what I'm hoping to achieve, especially with major capex improvements or when we want to purchase\n\nI'll continue to search A.Cre. I was hoping to find the magic spreadsheet that was similar to my situation. I'm nowhere near the level they are with excel but their \"watch me build...\" videos have helped tremendously - especially with the keyboard shortcuts.", "replies": [{"id": "gn2s3pz", "text": "Same as each asset proforma? -- Yes that's right.\n\nYou're adding up the cells of each individual cash flow: SUM(tab 1 cell C15, tab 2 cell C15, etc.). Different ways of doing it but this is the simplest at this stage. Each tab is a different asset and each tab needs to have the proforma set up exactly the same as you want to be summing the same cell across multiple tabs which correspond to, for example, gross rent income for period 1 (cell C15). And that rolls up to your portfolio proforma cash flow. \n\nUnfortunately there isn't a magic spreadsheet that works for everyone, every where, every asset. Experience building models on excel is what allows you to get to a point where it works for you, your assets, and your business plan.", "replies": [], "depth": 5}], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}]