Trending Content - Real Estate Forum
| +45 | Being a 100% Disabled Military Vet Pays as Much as RE Analyst Seat | 38 | 2h |
| +22 | Rate Hikes | 14 | 2d |
| +14 | ~$1M saved/invested at age 27 | 10 | 1m |
| +12 | Launching a Development Platform in Greece | 2 | 1d |
| +11 | Is anybody just going to leave the industry? | 6 | 18m |
| +9 | REPE Analyst Firm Advice | 3 | 3d |
| +8 | Hard Money Lenders? | 1 | 2d |
| +3 | 2027 Analyst Postings | 3 | 2h |
| +3 | BGO REPE LDN | 1 | 6d |
| +3 | LIHTC Syndicator Comp | 1 | 5d |
Career Resources
office deal?
Retail
I was in Argus DCF for a few years for office then changed firms and asset type and Argus moved to Enterprise so I'm not sure how the Enterprise export looks for retail but is it similar to the first snapshot and are you essentially trying to get to the last two snapshots?
Snapshot 1
Snapshot 2
Snapshot 3
This is certainly what he's asking (although I suspect more specifically in terms of a more typical rent roll with a single row for each tenant)
Curious if anyone has a good template as well. My shop's has always been overly convoluted when it comes to pulling in rent steps and MLAs.
You've gone above and beyond. Thank you. Are the second two spreadsheet views all formulas that automatically pull in from the first pic Argus dump? If so that's amazing.
The second worksheet is the model's output/summary so the values are merely references from other tabs.
The third worksheet is mixed, essentially if you don't have Argus you can model some of the more "advanced" stuff like reimbursements.
No -- I am trying to dump 3 tenant reports from ARGUS into excel and then have an excel sheet that pulls all relevant information from those three ARGUS reports into my one excel spreadsheet and make it look pretty haha
You can do this using =Match and =IF statements pretty easily. You'll have to assign unit numbers or pull through using Exact Tenant names.
=IF(Name on RR tab = Matches Argus Export tab, Show Rent $PSF, else, 0).
Gotcha, we'll i've shown all my cards, below is a "cleaned" up rollup of the tenant inputs which are also driven by the argus dumps. dm if u have more q's
I use a macro which might get you part of what you want, I haven't figured out importing rent schedules yet. What I do is export the Tenant Report>Tenant Rent Roll into an export package. I also export the monthly cash flows, the Dashboard Reports>Tenant Summary for the MLAs, Dashboard Reports>Property Summary for general assumptions and lease expiration report to calculate WALT. the macro copies and pastes everything from the report package into my model. I haven't figured out a macro to efficiently copy and pate the lease summary report and get rid of everything you don't need.
Sub InPlace_Rent_Dump()
Dim FileToOpen As Variant
Dim OpenBook As Workbook
Application.ScreenUpdating = False
FileToOpen = Application.GetOpenFilename(Title:="Browse for Your File & Import Range", FileFilter:="Excel Files(*.xls*),*xls*")
If FileToOpen > False Then
Set OpenBook = Application.Workbooks.Open(FileToOpen)
'Copy/Dump in-place rents
OpenBook.Sheets("Tenant Rent Roll").Cells(Rows.Count, 1).End(xlUp).EntireRow.Delete
Sheets("Tenant Rent Roll").Range("a10:f40").Copy
ThisWorkbook.Worksheets("In-Place Rents Dump").Range("B4:G34").PasteSpecial xlPasteValues
'Copy and paste the above with the other sheets and ranges you need for all other reports
OpenBook.Close False
End If
Application.ScreenUpdating = True
End Sub
I'm an absolute dumb shit when it comes to VBA. Is there anyway you can explain what this is doing or point me somewhere I can learn?
I am with you. Unfortunately I am not a VBA/Macros expert but this makes me wish I was. I would be open to someone pointing me in the right direction to learn/take a class that would help.
What this is doing is after exporting an argus report package to excel and saving it on my desktop, I run this macro to open up file explorer, select the report package from my desktop, it then opens the excel report package and goes into that argus report package and copies all of the cells I tell it to copy(basic rent roll info, monthly cash flow, MLAs, etc.) and pastes it into my model in the cells I tell it to paste into.
I didn't know how to code in VBA, still don't, it was mostly thanks to looking stuff up on stack overflow and trying stuff till I figured it out. AI should make it even easier now, but for me it was all trial and error.
I recently built something out. If you use index/match or xlookup, it gets most of it done. I have sheets to "dump" the argus files and then I have separate sheets to clean them up (Combo of the TRIM function and IFERROR). I then have a separate sheet for leveraged return calcs and unleveraged return calcs. If anyone wants to chat about it, PM. It's not the craziest thing in the world but I think it gets the job done. Open to criticism.
I can build whatever you want in a day for a hundo or two.
For any dump that you want to automatically reorganize, it's really just a handful of functions: XLOOKUP(), INDIRECT(), IFERROR(),IF(), and the comparator operators like , >, =.
what's the purpose of indirect in this context?
It's so that your formulas can reference sheets dynamically. If you tie your formula to a specific sheet without using the Indirect function, you can't delete that sheet without throwing #REF errors everywhere. That's not a problem if all you're doing is copying and pasting your data in. But I find it cleaner and more efficient to drag in the relevant worksheet tabs, delete any obsolete tabs, then just input the tab name into the cell my Indirect function is referencing.
Sit rerum quae dolore exercitationem. Consequuntur placeat iure est sit. Omnis vitae ullam quaerat porro quia quos.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...