Say I have $500,000 capital expenditure and I want to amortize it and recover it from my tenants. In the row where I enter the CapEx amount, I see options for that and even a place to enter the interest rate... but I fill all those and the cashflow still doesn't have any amortized capex recovery showing. Only the expense portion shows. How come?
| +43 | What Is Your Backup Plan? | 20 | 10h |
| +39 | Where are free agents signing? | 21 | 16h |
| +35 | AvalonBay Equity Residential Merger discussion | 16 | 14h |
| +34 | Future of Real Estate | 9 | 19h |
| +31 | Laughable Job Posting | 12 | 12h |
| +16 | Extremely Slow Ramp Up | 1 | 1d |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 1d |
| +10 | Dynex | 5 | 1d |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 3d |
| +9 | Portfolio Management strategy/transaction exposure on the analyst/associate level? | 1 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Argus sucks
Sure does pal. It sure does.
Like donkey.kong said below, model in excel and copy the values year by year for your analysis period into an OPEX account, set it to reference only, and recover from there.
Currently pulling my hair out trying to input different capex scenarios into argus. It's an unmitigated disaster of a software platform.
But like costar, they seem to have some sort of legalized monopoly forcing us all to use their shit program.
You need to create a reference account in OPEX and recover on that reference account
How would you model the amortization schedule using just a reference account though? I know I can do "% of Other", but I need to include interest and the 180 month amortization into the calculation
Don’t use the amortization function in Argus, run your amortization calcs in excel and paste the values into the opex section and set it to exclude from DCF (and add it to your recovery pools).
Thanks man, I actually can't believe Argus doesn't have this functionality built it...
to make it even worse, they have all the inputs to make it work, but those inputs don't even do anything. thanks again
Sit odit eveniet voluptatem qui rerum adipisci. Impedit id accusantium aut voluptatum accusamus maxime deleniti. Aperiam qui ad exercitationem laborum vel. Quasi deleniti vel labore debitis autem.
Accusantium vero et ullam. Deserunt recusandae placeat dolores tenetur quae minima culpa. Pariatur qui qui pariatur sed vitae saepe aut. Totam ducimus magnam illum rerum voluptatem ad voluptas.
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...